# NTSB investigations: Cessna 172L, MN

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 CHI07FA032](https://openairdocs.org/ntsb/CHI07FA032.md): Cessna 172 · Crookston, MN · Accident · 2 fatal · Field investigation · Final report · Dec 2, 2006 · N9850G · Destroyed
  > The pilot's inadvertent flight into instrument meteorological conditions which led to his spatial disorientation and subsequent loss of control. Factors were the snow, the low ceiling, and the pilot's lack of instrument flight experience.
- [NTSB CHI03LA005](https://openairdocs.org/ntsb/CHI03LA005.md): Cessna 172L · Fish Lake, MN · Accident · No injuries · Limited investigation · Final report · Oct 5, 2002 · N713SX · Substantial damage
  > The altitude/clearance not maintained while maneuvering on short final for landing on the lake. The glassy water was a contributing factor.
- [NTSB CHI90LA184](https://openairdocs.org/ntsb/CHI90LA184.md): Cessna 172 · Graceton, MN · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1990 · N7895G · Substantial damage
  > Vso airspeed not maintained and stall encountered by the pilot in command/cfi.
- [NTSB CHI88LA049](https://openairdocs.org/ntsb/CHI88LA049.md): Cessna 172L · Buffalo, MN · Accident · No injuries · Limited investigation · Final report · Jan 16, 1988 · N7895G · Substantial damage
- [NTSB CHI87LA224](https://openairdocs.org/ntsb/CHI87LA224.md): Cessna 172L · Lakeville, MN · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N3599F · Substantial damage
  > Aircraft landed hard, nose wheel first, and collapsed the nose landing gear tire. PIC was concerned about a sharp knocking noise in the rear of the aircraft that he heard after liftoff. The reason for the noise was not determined. He acknowledged that he…
- [NTSB MKC78FER33](https://openairdocs.org/ntsb/MKC78FER33.md): Cessna 172 · Thief Riv Fall, MN · Accident · No injuries · Closed · Mar 8, 1978 · N3889Q · Destroyed
- [NTSB MKC78FER14](https://openairdocs.org/ntsb/MKC78FER14.md): Cessna 172L · Minneapolis, MN · Accident · No injuries · Closed · Dec 11, 1977 · N9828G · Substantial damage
- [NTSB MKC75DER57](https://openairdocs.org/ntsb/MKC75DER57.md): Cessna 172 · Pine River, MN · Accident · No injuries · Closed · Feb 28, 1975 · N7830G · Substantial damage
- [NTSB MKC75DER45](https://openairdocs.org/ntsb/MKC75DER45.md): Cessna 172 · Eden Prairie, MN · Accident · No injuries · Closed · Jan 30, 1975 · N4380Q · Substantial damage
- [NTSB MKC74DER41](https://openairdocs.org/ntsb/MKC74DER41.md): Cessna 172 · Ely, MN · Accident · No injuries · Closed · Feb 23, 1974 · N19752 · Substantial damage
- [NTSB MKC71FDM34](https://openairdocs.org/ntsb/MKC71FDM34.md): Cessna 172L · Minneapolis, MN · Accident · No injuries · Closed · Nov 3, 1970 · N7737G · Substantial damage

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072432'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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