I would say that it is fine to read up on things in order to respect that scuba diving, like a lot of other recreations, has it's dangers as does crossing the road, driving a car or getting a flight. As someone alluded to earlier, people only tend to post/write about the problem dives not the 1,000s of dives that went exactly to plan
That is one of the reasons why the courses are there - there is a fair amount of information/skills that you need to have on board in order to dive safely (you are getting.
A lot of the incidents you will probably be reading about will come down to a number of issues:
1) Diving beyond your limits - dive what you have been trained for. OW divers doing caves for example probably don't know a fraction of the dangers involved.
2) Pre-existing medical issues - issues that haven't came to light under normal day to day living can sometimes come to light when the body is stressed by depth/ unusual situations.
3) Forgetting or not practising skills - the skills taught on courses are potentially life saving but like any skill they deteriorate with time so need regular practise to stay active.
4) Not planning or not sticking to the plan - dive planning is important (even if it is a very simple plan). Plan the dive and dive the plan. Don't get distracted into changing or forgetting the plan.
5) Panic - even when faced with serious situations underwater such as out of air, you do have time to gather your thoughts, remember your training and carry out the relevant drill (such as sharing air with your buddy).
Stick to recreational dive limits, dive conservatively, remember the basic rules/drills and the sport is pretty safe. Push those limits without the right knowledge. experience and kit and things get more dangerous.