The word you are looking for is "fiasco" or "failure." These words describe situations where something was planned, intended, or expected to happen, but it didn't materialize or went completely awry.