Fredo's fatal (pun intended) mistake:

Getting in a boat alone with Al Neri and going out in the middle of a large lake.