# NTSB investigations: Cessna 172P, 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 CHI99LA040](https://openairdocs.org/ntsb/CHI99LA040.md): Cessna 172P · Brainerd, MN · Accident · Minor injuries · Limited investigation · Final report · Nov 27, 1998 · N52502 · 2 aircraft · Substantial damage
  > The visual lookout not obtained/maintained by the pilot of the other aircraft. Contributing factors were the unicom frequency not selected and the traffic advisory not issued by the pilot of the other aircraft. An additional factor was the aircraft moving on…
- [NTSB CHI95LA233](https://openairdocs.org/ntsb/CHI95LA233.md): Cessna 172 · Motley, MN · Accident · No injuries · Limited investigation · Final report · Jul 18, 1995 · N53716 · Substantial damage
  > the pilot's failure to maintain control of the airplane during a soft field takeoff.
- [NTSB CHI92LA008](https://openairdocs.org/ntsb/CHI92LA008.md): Cessna 172P · Maple Lake, MN · Accident · Minor injuries · Limited investigation · Final report · Oct 17, 1991 · N97984 · Substantial damage
  > The loss of engine power for an undetermined reason.
- [NTSB MKC90LA043](https://openairdocs.org/ntsb/MKC90LA043.md): Cessna 172 · St Cloud, MN · Accident · No injuries · Limited investigation · Final report · Jan 7, 1990 · N97984 · Substantial damage
  > Inadequate visual outlook by the pilot and his failure to maintain clearance from the light pole. The location of the pole was considered to be a related factor.
- [NTSB MKC89LA164](https://openairdocs.org/ntsb/MKC89LA164.md): Cessna 172 · Duluth, MN · Accident · No injuries · Limited investigation · Final report · Jul 23, 1989 · N97984 · Substantial damage
  > Aircraft control was not maintained by the pilot in command due to improper use of the aircraft flight controls.
- [NTSB MKC89LA032](https://openairdocs.org/ntsb/MKC89LA032.md): Cessna 172 · Little Falls, MN · Accident · No injuries · Limited investigation · Final report · Dec 2, 1988 · N65642 · Substantial damage
  > While attempting a touch and go ldg during a student solo cross country flt, directional control was lost during the takeoff phase on the snow packed runway. The student pilot said he had never landed and taken off under those runway conditions. The acft…
- [NTSB CHI88LA132](https://openairdocs.org/ntsb/CHI88LA132.md): Cessna 172 · Fairmont, MN · Accident · No injuries · Limited investigation · Final report · Jun 9, 1988 · N5317K · Substantial damage
  > The student pilot was attempting to land. Just prior to touchdown a gust of wind pushed the aircraft to the left of the runway. The pilot was unable to maintain control of the aircraft resulting in the aircraft encountering a stall and colliding with the…
- [NTSB CHI88LA095](https://openairdocs.org/ntsb/CHI88LA095.md): Cessna 172P · Sauk Center, MN · Accident · No injuries · Limited investigation · Final report · Apr 6, 1988 · N62218 · Destroyed
  > While enroute on the last leg of a solo cross country instructional flight, the student pilot experienced a rough running engine, followed by an engine failure. The pilot elected to land on a frozen lake, executed emergency procedures, and made a hard landing…
- [NTSB CHI86LA156](https://openairdocs.org/ntsb/CHI86LA156.md): Cessna 172P · Grand Rapids, MN · Accident · Minor injuries · Limited investigation · Final report · Jun 17, 1986 · N52565 · Substantial damage
  > The CFI and sp were returning from a transition. Enroute the #3 exhaust valve push rod failed. When the CFI smelled 'something burning' she shut down the engine. During the descent struck power lines. Acft ld in swampy terrain and nosed over inverted.
- [NTSB CHI81FER48](https://openairdocs.org/ntsb/CHI81FER48.md): Cessna 172P · Thief River Fa, MN · Accident · No injuries · Closed · Jul 1, 1981 · N52565 · 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 ('2072436'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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