Look through the list of contents and see what you think.
http://books.mcgraw-hill.com/search.php?PHPSESSID=039d8495b305580698313699902e52d3&keyword=fluid+mechanics&template=&subjectarea=ALL [Broken]
Design codes are constantly evolving from such failures, looking at how the material fails is key to revising the equations that engineers use. Recent building and bridge failures from earthquakes have resulted in tremendous code revisions, without looking at how the material failed, there would...
Those are design failures but they are also material failures. I think a design failure independent of material would be where an unstable structure collapses. Yielding or fracture is not necessary, the structure collapses from a lack of stability (boundary conditions).
The Hyatt Regency collapse is one of the most well known among structural engineers
http://www.glendale-h.schools.nsw.edu.au/faculty_pages/ind_arts_web/bridgeweb/Hyatt_page.htm [Broken]