The NYPD suffers from a severe lack of a local gun culture---the city has a bit over 50,000 each of legally registered handguns and long guns, and there aren't many places to shoot---as you note does very little proficiency training, I myself shoot around 200 handgun rounds per range visit, their leadership is notoriously gun ignorant and saddled them with Full Metal Jacket (FMJ) rounds for a long time, and still uses the heavy New York trigger modification, and the force is notorious for a very large fraction being poor in gun fights.

There was a recent incident where ALL the civilian casualties were from the cops, and most specifically we believe from one who screwed up big time, the other did the right thing for himself and others, to the extent we could determine.