I think that’s happened more than once. And at least once was captured on video and put on YouTube. It has to do with trigger “safeties” such as on Glocks which increase the possibility of a negligent discharge. Were I a warrior who likely would be in a situation where their lives depended on getting a quick shot off, I’d consider a pistol with a trigger safety. But not otherwise.
I’ve had several, performed by good dentists. By far the worst part is administering the anesthesia. Second to that is the long boring wait in the dentist’s chair.