That survey is almost the answer to my question so thank you for linking to it.

Guns were used in self defence in 0.9% of crimes where the victim of the crime was present. It doesn't state whether the gun was fired or not but given the low percentages of a gun being involved at all I guess there aren't many 'bad guys' being shot (or shot at).