Historically, what final trigger causes a fiat currency to collapse?

The Fractional Reserve system of creating money and lending. No matter what you do, you can never pay back the interest in full. That money just does not exist. Each year we print more money and it loses value. One day, the interest owed cracks will open wide.