# NTSB investigations, MN: Uncontained engine failure

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ENG23LA034](https://openairdocs.org/ntsb/ENG23LA034.md): Hall Lester R Legacy · Rochester, MN · Incident · No injuries · Class 3 · Limited · Final report · Jul 20, 2023 · N707MM · Minor damage
  > Mechanically distressed reduction gears causing an engine overspeed and turbine blade tensile overload and subsequent uncontainment. Contributing to the uncontainment was the operator’s use of the engine after knowingly purchasing the engine in an…
- [NTSB ENG10IA037](https://openairdocs.org/ntsb/ENG10IA037.md): Douglas DC9 · Minneapolis, MN · Incident · No injuries · Incident investigation · Final report · Jun 15, 2010 · N671MC · Minor damage
  > The failure of the facility that overhauled the 1st stage fan blade to properly restore the leading edge, which caused a flutter mode resulting in a fatigue crack and fracture of the fan blade.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'MN' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '343' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/343/sequence?state=MN

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.