Some others have touched on this, but IMHO one of the attractions of flying (anything) is that it is as safe as you want to make it. The aircraft accident (especially GA) which could not have been avoided by good pilot technique or plain common sense is very rare. There is no equavalent of many road accident scenarios - HGVs shedding tyres and sweving across 3 lanes, 4 wheel drives rolling over and involving you in their accident, chlideren stepping out from between parked cars, white van man, or just plain stupidity in other drivers.
As a pilot, you are pretty much in charge of your own destiny. If that appeals, you'll probably make a good pilot. If it worries you, stay on the ground.
SSD