I will say that in the last few years this sort of stuff is in the public eye a lot more, and also due to that seems to be happening a lot more often too.
The LAPD a year or two ago, chasing after that armed and dangerous x-cop I think he was? Anyhow, the LAPD accidentally shot up a truck of the same model and color in the dark, containing 2 older aged Asian ladies - wrong race, sex, and everything else, a terribly bad shoot. Also, enroute to that very same bad shooting, the LAPD encountered another unlucky soul driving the same make and model vehicle - they rammed him at full speed and unloaded a bunch of rounds into the truck, luckily missing the occupants. I've never heard about what punishment if any happened over that, as the LAPD policy is to keep the punishment classified. The police likely weren't fired from the articles I read. The 2 woman in Torrance mistakenly shot cost the taxpayers 4.2 million dollars, and 40,000 for a new truck, the initial peace offering from the city, which the lawyer didn't like, hence the 4.2 mil. Also, the 2 woman stopped doing the delivery job, saying it was "dangerous"...no kidding. They now clean homes for a living - get that.
It's a tough job, no denying it, and I won't bash the police here or anywhere else for that matter, but brutal mistakes like the former make it a hard thing sometimes to support. I do understand the police were out of their element, being hunted by one of their own, and having lost an officer to the culprit prior to the "bad shoots".