The most common cause of death is getting yourself trapped in a cave or wreck, getting drunk on nitrogen below 90 feet, or having a seizure from too much oxygen below a certain depth. All things that are easy to avoid.
This is actually incorrect. None of those things are why most people die scuba diving. I won't bore you with it here, but you can look it up easily.