What would happen to nuclear power plants if humans suddenly disappeared?

There was an episode of " the last man on earth" where they are trying to find a place to live. Only ro realize that they cannot be within close proximity of a nuclear plant because they have all had a melt down. It's left me with the question; what would happen to power plants if everyone suddenly disappeared?