# NTSB investigations: Cessna 172K, MO

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 GAA16CA473](https://openairdocs.org/ntsb/GAA16CA473.md): Cessna 172 · Fulton, MO · Accident · No injuries · Data collection · Final report · Aug 14, 2016 · N78242 · Substantial damage
  > The pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the airplane porpoising.
- [NTSB CHI04CA113](https://openairdocs.org/ntsb/CHI04CA113.md): Cessna 172K · Harrisonville, MO · Accident · Minor injuries · Data collection · Final report · May 1, 2004 · N7448G · Substantial damage
  > The dual student's failure to maintain directional control of the aircraft during the landing flare. Contributing factors were the dual student's failure to relinquish the controls to the flight instructor, the resulting inability of the flight instructor to…
- [NTSB MKC80FCG28](https://openairdocs.org/ntsb/MKC80FCG28.md): Cessna 172K · Warrensburg, MO · Accident · Minor injuries · Closed · Jun 13, 1980 · N78395 · Substantial damage
- [NTSB MKC77FCG52](https://openairdocs.org/ntsb/MKC77FCG52.md): Cessna 172K · Kimberling Cy, MO · Accident · Minor injuries · Closed · Sep 2, 1977 · N84104 · Substantial damage
- [NTSB MKC77FCA06](https://openairdocs.org/ntsb/MKC77FCA06.md): Cessna 172K · Fenton, MO · Accident · No injuries · Closed · Dec 22, 1976 · N46694 · Substantial damage
- [NTSB MKC75FCA18](https://openairdocs.org/ntsb/MKC75FCA18.md): Cessna 172 · Wentzville, MO · Accident · No injuries · Closed · Jan 11, 1975 · N84717 · Substantial damage
- [NTSB MKC75DCA09](https://openairdocs.org/ntsb/MKC75DCA09.md): Cessna 172 · Montgomery Cty, MO · Accident · No injuries · Closed · Sep 17, 1974 · N84456 · Substantial damage
- [NTSB MKC75FCG12](https://openairdocs.org/ntsb/MKC75FCG12.md): Cessna 172 · Marshfield, MO · Accident · Serious injuries · Closed · Aug 23, 1974 · N7130G · Substantial damage
- [NTSB MKC75DCG01](https://openairdocs.org/ntsb/MKC75DCG01.md): Cessna 172 · Strafford, MO · Accident · No injuries · Closed · Jul 9, 1974 · N84907 · Substantial damage
- [NTSB MKC72DCG66](https://openairdocs.org/ntsb/MKC72DCG66.md): Cessna 172K · Cosby, MO · Accident · No injuries · Closed · Jun 24, 1972 · N7101G · Substantial damage
- [NTSB MKC72FCA17](https://openairdocs.org/ntsb/MKC72FCA17.md): Cessna 172K · Fenton, MO · Accident · No injuries · Closed · Nov 25, 1971 · N7041G · Substantial damage
- [NTSB MKC72FCA01](https://openairdocs.org/ntsb/MKC72FCA01.md): Cessna 172K · Bonne Terre, MO · Accident · No injuries · Closed · Jul 5, 1971 · N7480G · Substantial damage
- [NTSB MKC71FCA20](https://openairdocs.org/ntsb/MKC71FCA20.md): Cessna 172 · Chesterfield, MO · Accident · Serious injuries · Closed · Nov 30, 1970 · N79942 · Destroyed
- [NTSB MKC70FCA08](https://openairdocs.org/ntsb/MKC70FCA08.md): Cessna 172 · Fenton, MO · Accident · Serious injuries · Closed · Apr 21, 1970 · N78356 · Destroyed
- [NTSB MKC70DCA04](https://openairdocs.org/ntsb/MKC70DCA04.md): Cessna 172K · Clarence, MO · Accident · Minor injuries · Closed · Mar 26, 1970 · N79929 · 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" = 'MO' 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 ('2072430'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072430&state=MO

---
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.