I have a few friends who have their own pilots license (private pilot i assume). How safe is it to fly your own plane?

I have acrophobia so learning how to fly is not high on my list but would like to know about how safe it is to assuage some fears. To be it seems scary because if something goes wrong, you wouldn’t be the only person getting hurt (as would be the case for scuba diving or skiing) but you might also risk hurtings others like your plane crashing out of control.

edit: i’m asking on the off chance i feel like one day getting a private pilots license like my friends. i’m not planning on flying with the friends anytime soon; they live on the other side of the world.