The NYPD latest annual firearms-discharge report shows it's not like the films:

some quotes:
of 52 officers.. 'only one officer reported using the gun’s sight before firing'.

'The 33 instances in which an officer intentionally shot at a suspect last year represented a 30 percent decrease from the year before'.

'in 1971..the police in New York City fatally shot 93 people and injured 221 others.
Last year, the police shot and killed 8 people and injured 16'

'...the other lived after being struck by 23 bullets'.

'In a force of 34,565 officers, only 00.15 percent intentionally fired at people last year'.

'four officers were injured by gunfire during shootouts. Two were hurt by police bullets in [a]gun battle. One officer was shot three times when opening the door to the room of an armed suspect. Another officer was shot three times while pursuing an armed 17-year-old up a flight of stairs'.

'22 instances of unintentional discharges, including three in which officers accidentally fired while chasing suspects'.

full article:
http://www.nytimes.com/2011/11/25/nyregi...ml?_r=1&hpw