# NTSB investigations: Cessna R172K, OK

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 CEN10CA132](https://openairdocs.org/ntsb/CEN10CA132.md): Cessna 172 · Davis, OK · Accident · No injuries · Data collection · Final report · Feb 28, 2010 · N72TN · Substantial damage
  > The flight instructor’s improper recovery from a bounced landing.
- [NTSB DEN08LA110](https://openairdocs.org/ntsb/DEN08LA110.md): Cessna R172K · Goldsby, OK · Accident · No injuries · Limited investigation · Final report · Jun 21, 2008 · N1439V · Substantial damage
  > The pilot's delay in initiating rejected takeoff procedures, resulting in the airplane going off the end of the runway and nosing over.
- [NTSB FTW87FA031](https://openairdocs.org/ntsb/FTW87FA031.md): Cessna 172K · El Reno, OK · Accident · 2 fatal · Field investigation · Final report · Dec 15, 1986 · N736XP · Destroyed
  > Private pilot of Cessna 172K attempted VFR flight in IFR flight conditions. Contacted okc approach control and requested special VFR approach during hours of darkness. Approach denied special VFR due to lack of instrument qualification of pilot. Pilot was…
- [NTSB FTW81FPM03](https://openairdocs.org/ntsb/FTW81FPM03.md): Cessna R172K · Lenapah, OK · Accident · No injuries · Closed · Nov 30, 1980 · N758BN · Substantial damage
- [NTSB FTW79DPJ38](https://openairdocs.org/ntsb/FTW79DPJ38-133393.md): Cessna R172K · El Reno, OK · Accident · No injuries · Closed · Sep 19, 1979 · N4634K · Substantial damage
- [NTSB FTW79DPJ39](https://openairdocs.org/ntsb/FTW79DPJ39-202546.md): Cessna 172 · Enid, OK · Accident · No injuries · Closed · Sep 27, 1978 · N736HH · 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" = 'OK' 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=OK

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