# NTSB investigations, MN: Gear collapsed

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 CHI02FA289](https://openairdocs.org/ntsb/CHI02FA289.md): McDonnell Douglas DC-9-32 · Minneapolis, MN · Accident · No injuries · Field investigation · Final report · Sep 22, 2002 · N941N · Substantial damage
  > The fatigue failure of the main landing gear strut due to inclusions in the material, residual stresses, and dissolved hydrogen content.
- [NTSB CHI02FA148](https://openairdocs.org/ntsb/CHI02FA148.md): Douglas DC-9-31 · Minneapolis, MN · Accident · No injuries · Field investigation · Final report · Jun 4, 2002 · N8986E · Substantial damage
  > The failure of the right main landing gear due to fatigue.
- [NTSB CHI01LA330](https://openairdocs.org/ntsb/CHI01LA330.md): Colonial C-2 · Faribault, MN · Accident · No injuries · Limited investigation · Final report · Sep 26, 2001 · N273B · Substantial damage
  > The failure of the landing gear shock strut.
- [NTSB CHI00LA010](https://openairdocs.org/ntsb/CHI00LA010.md): Cessna 172G · Cambridge, MN · Accident · No injuries · Limited investigation · Final report · Oct 15, 1999 · N4621L · Substantial damage
  > the fractured main landing gear due to the improper maintenance by an unknown person(s) and the inadequate annual inspection by an unqualified person.
- [NTSB CHI99LA156](https://openairdocs.org/ntsb/CHI99LA156.md): Beech 99A · Bemidji, MN · Accident · No injuries · Limited investigation · Final report · May 17, 1999 · N133BA · Substantial damage
  > Failure of the left main landing gear actuator for undetermined reasons.
- [NTSB CHI92DER03](https://openairdocs.org/ntsb/CHI92DER03.md): Schneider/Brashear Sorrell SNS-7 · Alexandria, MN · Accident · No injuries · Final report · Aug 9, 1992 · N226HB · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll.
- [NTSB CHI86LA086](https://openairdocs.org/ntsb/CHI86LA086.md): Cessna 172N · St. Cloud, MN · Accident · No injuries · Limited investigation · Final report · Feb 14, 1986 · N5466D · Substantial damage
  > The plt was diverting into galesburg due to bad weather at his original destination. Following an ILS approach at galesburg he spotted the rwy at '200 ft plus' off to his right. He then 'side-stepped' to the right but touched down in a crabbed angle. He…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 190)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=190&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.