Why are people afraid of Nuclear power plants?

Probably because they're aware of the catastrophic devastation a leak of radioactivity can cause ! The pollution of the local area could last for hundreds of years - causing birth defects, cancers and other health-related issues. It would also render the land surrounding the plant totally unusable for a similar length of time.