# NTSB investigations: Cessna R172K, 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 CEN20CA188](https://openairdocs.org/ntsb/CEN20CA188.md): Cessna R172 · Lino Lakes, MN · Accident · No injuries · Class 4 · Data collection · Final report · May 20, 2020 · N612R · Substantial damage
  > The pilot's loss of directional control during takeoff with a crosswind.
- [NTSB CHI06LA212](https://openairdocs.org/ntsb/CHI06LA212.md): Cessna R172K · Grand Rapids, MN · Accident · No injuries · Limited investigation · Final report · Jul 9, 2006 · N736VM · Substantial damage
  > The pilot's failure to maintain control of the airplane during the landing. A factor associated with the accident was the gusty tailwind that prevailed.
- [NTSB CHI96LA093](https://openairdocs.org/ntsb/CHI96LA093.md): Cessna 172 · Worthington, MN · Accident · No injuries · Limited investigation · Final report · Feb 18, 1996 · N758CQ · Substantial damage
  > Progressive failure of the engine, beginning with failure of the left magneto, which resulted in preignition or detonation, a burned hole in the #3 piston, subsequent oil exhaustion, and failure of the #1 and #2 connecting rods.
- [NTSB CHI85LA333](https://openairdocs.org/ntsb/CHI85LA333.md): Cessna 172XP · Int'L Falls, MN · Accident · No injuries · Limited investigation · Final report · Aug 10, 1985 · N1254V · Substantial damage
  > The acft veered hard to the rt & collided with the water during takeoff at about 45 mph. It was discovered that the left float failed and allowed the left float to turn rt and go under the rt float.
- [NTSB CHI83LA015](https://openairdocs.org/ntsb/CHI83LA015.md): Cessna 172 · Sacred Heset, MN · Accident · No injuries · Limited investigation · Final report · Oct 14, 1982 · N758QX · Substantial damage
  > While on a flight to photograph farms, the engine lost power and the pilot was unable to get it restarted. An emergency landing was made in a bean field that was soft from recent rains. Shortly after touchdown, the aircraft nosed over. After the accident,…
- [NTSB MKC79FA055](https://openairdocs.org/ntsb/MKC79FA055.md): Cessna 172XP · Intl Falls, MN · Accident · 2 fatal · Closed · Sep 16, 1979 · N736QH · Destroyed
- [NTSB MKC76DER93](https://openairdocs.org/ntsb/MKC76DER93.md): Cessna 172 · Crane Lake, MN · Accident · No injuries · Closed · Aug 27, 1976 · N13673 · 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 ('2072431'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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