General Zod
TGT Addict
There was a case a few years ago where they went to the wrong house with a no-knock warrant and an officer got shot by the home owner. The owner wasn't prosecuted IIRC.
I can think of one instance in College Station like that. I think there have been others. However...it's rare that a homeowner getting shot in a raid on the wrong address results in any police personnel being prosecuted for murder or even manslaughter. Usually a cover-up ensues.