The situation you you are referring to is called "ditching" and yes, it is possible in an emergency...yet it is very remote. A successful ditching requires a good pilot, great weather and calm seas because as you mentioned, the aircraft tend to break apart on contact with the water. In answer to your question, there have been successful ditching of aircraft, but not in recent memory. The last one that came close to successful was a high jacked 767 that ran out of fuel. The pilot did his best, but one wing hit the water at an odd angle and cartwheeled. As violent as this water landing was, some passengers still survived....some without a scratch. I also remember a very successful ditching of a C-130 where no one was hurt and the crew simply climbed up on the wing and waited for rescue.
23+ years in the military and 6 years as a military flyer