They're really not bad tbh. I grew up going on a tiny 4-seater Cessna that my dad flies and accidents are pretty rare for them. You have to go through a lot of training and retraining. The plane's instruments have to be reevaluated every few years to make sure they're up to date and in proper working order. Yes, things can fail, but plane crashes tend to be sensationalized more in the news than other types of accidents. Plane crashes just make the news more often than car crashes do.

EDITED to say that I would trust my dad flying over some other pilot, who could be drunk or asleep for all I know.