I Admit I Am More Interested In The Intrigue

Who is trying to drown Fredo? Is Fredo trying to take everyone else down on purpose or is he too stupid to realize what he is doing?