Bingo, and it's many studies; amusingly, the first was done with data collected by gun grabbers, and it had lower numbers since it didn't ask if the respondent had used a gun in self-defense more than once during the year.
Current numbers put self-defense gun uses at something like 2.25 million per year, with indeed way over 90% never involving a gun being discharged.
There's also a systematic difficulty in the other direction, I'm pretty sure most criminal uses of guns also don't involve it being discharged. And some fraction of those don't get reported to the police or then reported accurately, you'd need to start with the national crime survey data.
Current numbers put self-defense gun uses at something like 2.25 million per year, with indeed way over 90% never involving a gun being discharged.
There's also a systematic difficulty in the other direction, I'm pretty sure most criminal uses of guns also don't involve it being discharged. And some fraction of those don't get reported to the police or then reported accurately, you'd need to start with the national crime survey data.