# NTSB investigations: Cessna 172, 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 CHI07LA185](https://openairdocs.org/ntsb/CHI07LA185.md): Cessna 172 · Oak Grove, MN · Accident · No injuries · Limited investigation · Final report · Jun 28, 2007 · N6267E · Substantial damage
  > A loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain.
- [NTSB CHI05CA084](https://openairdocs.org/ntsb/CHI05CA084.md): Cessna 172 · Baudette, MN · Accident · No injuries · Data collection · Final report · Mar 26, 2005 · N8954B · Substantial damage
  > The pilot's inadequate compensation for the crosswind which resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind, the snow covered surface on which the landing was being made, and the…
- [NTSB CHI96LA249](https://openairdocs.org/ntsb/CHI96LA249.md): Cessna 172 · Emily, MN · Accident · No injuries · Limited investigation · Final report · Jul 20, 1996 · N7101T · Destroyed
  > the pilot misjudged his altitude and distance to the runway on final approach, and he failed to maintain obstacle clearance during landing. A factor relating to the accident was: the parked car.
- [NTSB CHI94LA338](https://openairdocs.org/ntsb/CHI94LA338.md): Cessna 172 · Mora, MN · Accident · No injuries · Limited investigation · Final report · Sep 17, 1994 · N8064B · Substantial damage
  > was an improper touchdown by the pilot-in-command. Factor's associated with this accident were the pilot's diverted attention due to his perception of a crosswind condition and the pilot not performing a recovery from a bounced landing.
- [NTSB CHI93LA037](https://openairdocs.org/ntsb/CHI93LA037.md): Cessna 172 · Elk River, MN · Accident · 1 fatal · Limited investigation · Final report · Nov 17, 1992 · N7463A · Substantial damage
  > Failure of the pilot to refuel the airplane before the flight.
- [NTSB MKC78DER98](https://openairdocs.org/ntsb/MKC78DER98.md): Cessna 172 · Warren, MN · Accident · No injuries · Closed · Sep 22, 1978 · N8976B · Substantial damage
- [NTSB MKC77FA004](https://openairdocs.org/ntsb/MKC77FA004.md): Piper PA-18 · Grand Rapids, MN · Accident · 3 fatal · Closed · Nov 20, 1976 · N8415P · 2 aircraft · Destroyed
- [NTSB MKC74FER44](https://openairdocs.org/ntsb/MKC74FER44.md): Cessna 172 · Willmar, MN · Accident · No injuries · Closed · Mar 23, 1974 · N6126E · Substantial damage
- [NTSB MKC71FDD22](https://openairdocs.org/ntsb/MKC71FDD22.md): Cessna 172 · Detroit Lks, MN · Accident · No injuries · Closed · Mar 14, 1971 · N8607B · Substantial damage
- [NTSB MKC69F0451](https://openairdocs.org/ntsb/MKC69F0451.md): Cessna 172 · Pequot Lakes, MN · Accident · No injuries · Closed · Apr 26, 1969 · N8688B · Substantial damage
- [NTSB MKC69D0103](https://openairdocs.org/ntsb/MKC69D0103.md): Cessna 172 · Isle, MN · Accident · No injuries · Closed · Aug 4, 1968 · N8522B · Substantial damage
- [NTSB MKC69D0067](https://openairdocs.org/ntsb/MKC69D0067-201692.md): Cessna 150G · St Cloud, MN · Accident · No injuries · Closed · Jul 14, 1968 · N3252J · 2 aircraft · Substantial damage
- [NTSB MKC68F0358](https://openairdocs.org/ntsb/MKC68F0358.md): Cessna 172 · Hill City, MN · Accident · No injuries · Closed · Nov 13, 1967 · N5686A · Substantial damage
- [NTSB MKC68F0242](https://openairdocs.org/ntsb/MKC68F0242-201110.md): Cessna 172 · Green Isle, MN · Accident · Minor injuries · Closed · Sep 24, 1967 · N6389E · Destroyed
- [NTSB MKC67A0041](https://openairdocs.org/ntsb/MKC67A0041.md): Cessna 172 · Spring Grove, MN · Accident · 1 fatal · Closed · Jan 1, 1967 · N7378A · Destroyed
- [NTSB MKC67F0243](https://openairdocs.org/ntsb/MKC67F0243.md): Cessna 172 · So.St.Paul, MN · Accident · No injuries · Closed · Sep 26, 1966 · N8746B · Substantial damage
- [NTSB MKC67F0145](https://openairdocs.org/ntsb/MKC67F0145.md): Cessna 172 · Madison, MN · Accident · Minor injuries · Closed · Jul 28, 1966 · N6332E · 2 aircraft · Substantial damage
- [NTSB MKC66D0545](https://openairdocs.org/ntsb/MKC66D0545.md): Cessna 172 · Worthington, MN · Accident · No injuries · Closed · May 19, 1966 · N7040T · Substantial damage
- [NTSB MKC66D0532](https://openairdocs.org/ntsb/MKC66D0532.md): Cessna 172 · Faribault, MN · Accident · No injuries · Closed · Mar 31, 1966 · N8264B · Substantial damage
- [NTSB MKC66D0531](https://openairdocs.org/ntsb/MKC66D0531.md): Cessna 172 · Minneapolis, MN · Accident · Minor injuries · Closed · Mar 31, 1966 · N8159B · Substantial damage
- [NTSB MKC66F0486](https://openairdocs.org/ntsb/MKC66F0486.md): Cessna 172 · Dexter, MN · Accident · No injuries · Closed · Mar 8, 1966 · N5100A · Substantial damage
- [NTSB MKC66D0308](https://openairdocs.org/ntsb/MKC66D0308.md): Cessna 172 · Maple Plain, MN · Accident · No injuries · Closed · Oct 29, 1965 · N6345E · Substantial damage
- [NTSB MKC65F0112](https://openairdocs.org/ntsb/MKC65F0112.md): Cessna 172 · Rosemount, MN · Accident · No injuries · Closed · Feb 14, 1965 · N8722B · Substantial damage
- [NTSB MKC65F0019](https://openairdocs.org/ntsb/MKC65F0019-180170.md): Cessna 172 · Crystal, MN · Accident · No injuries · Closed · Jan 2, 1965 · N8264B · Substantial damage
- [NTSB UNK64X1453](https://openairdocs.org/ntsb/UNK64X1453.md): Cessna 172 · Circle Pines, MN · Accident · No injuries · Closed · Apr 25, 1964 · N9146B · Substantial damage
- [NTSB UNK64X0843](https://openairdocs.org/ntsb/UNK64X0843.md): Cessna 172 · Le Sueur, MN · Accident · No injuries · Closed · Mar 8, 1964 · N6314E · 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 ('2072402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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