Is scuba diving dangerous?

Not really.  Statistics show that recreational scuba diving is about as safe as swimming.  Certainly there are potential hazards (which is why you need training and certification) but like driving a car, as long as you follow the rules and use common sense, it's pretty safe.

To put it in perspective, driving the car to go diving is more dangerous than diving.