It has not happened numerous times. It has happened a handful of times in the last few decades. I'm sure there are flamers here who will point out several instances, but they are all the same few incidents, over and over.
There is no legal right to resist a law enforcement officer attempting to make an arrest or a search, even if the arrest or search later turns out to be incorrect. This is long and well established in case law.
These officers who are involved in these mistakes do not wake up in the morning and say "let's go violate someone's 4th Amendment rights!" When these mistakes happen, it is usually not the fault of the guys serving the warrant. When they do happen, strong disciplinary action, and even criminal prosecutions of the involved officers usually occurs.
As far as the homeowner goes, how do you know it is an "incorrect" warrant? You don't know why the police are there until after the entry is over with and someone explains it.
To answer the question, resisting a search or arrest warrant, even an incorrect one, with deadly force, will result in criminal chrages being filed against the resister, if they survive.