For the third time in a week, a New York City police officer has gotten drunk and shot at someone