The US alone has a lengthy track record of collapses

The Conservation Fund's Freshwater Institute has kept records of US RAS projects, both past, present and future. These ones didn't make it.

Table: Source: Freshwater Institute