# NTSB investigations: Cessna 172K, 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 FTW98LA137](https://openairdocs.org/ntsb/FTW98LA137.md): Cessna 172K · Marietta, OK · Accident · Serious injuries · Limited investigation · Final report · Mar 1, 1998 · N84561 · Substantial damage
  > The pilot's improper compensation for the wind conditions. A factor was the crosswind.
- [NTSB FTW82DA070](https://openairdocs.org/ntsb/FTW82DA070.md): Cessna 172 · Hennessey, OK · Accident · No injuries · Final report · Feb 24, 1982 · N79325 · Destroyed
  > The pilot reported that he encountered a gust of wind as he was flaring with full flaps about two feet above the strip. He stated that the right wing was blown down (the tail moved to the left) and the right wing collided with a fence beside the airstrip. The…
- [NTSB FTW82FPM02](https://openairdocs.org/ntsb/FTW82FPM02.md): Cessna 172 · Broken Arrow, OK · Accident · No injuries · Closed · Oct 17, 1981 · N84796 · Substantial damage
- [NTSB FTW80FPJ04](https://openairdocs.org/ntsb/FTW80FPJ04.md): Cessna 172K · Norman, OK · Accident · No injuries · Closed · Nov 24, 1979 · N84907 · Substantial damage
- [NTSB FTW77FPM06](https://openairdocs.org/ntsb/FTW77FPM06.md): Cessna 172K · Bartlesville, OK · Accident · No injuries · Closed · Feb 22, 1977 · N46305 · Substantial damage
- [NTSB FTW74AF005](https://openairdocs.org/ntsb/FTW74AF005.md): Boeing 727 · Yukon, OK · Accident · 3 fatal · Closed · Jul 27, 1973 · N127 · 2 aircraft · Substantial damage
- [NTSB FTW73FPM12](https://openairdocs.org/ntsb/FTW73FPM12.md): Cessna 172K · Henryetta, OK · Accident · Serious injuries · Closed · Jun 5, 1973 · N84358 · Substantial damage
- [NTSB FTW73DPJ16](https://openairdocs.org/ntsb/FTW73DPJ16.md): Cessna 172 · Alva, OK · Accident · No injuries · Closed · Apr 19, 1973 · N84391 · Substantial damage
- [NTSB FTW72DPM22](https://openairdocs.org/ntsb/FTW72DPM22.md): Cessna 172 · Cookson, OK · Accident · No injuries · Closed · Mar 4, 1972 · N46743 · Substantial damage
- [NTSB FTW72FPM15](https://openairdocs.org/ntsb/FTW72FPM15.md): Cessna 172K · Jenks, OK · Accident · No injuries · Closed · Dec 12, 1971 · N84691 · Substantial damage
- [NTSB FTW71DPJ38](https://openairdocs.org/ntsb/FTW71DPJ38.md): Cessna 172K · Altus, OK · Accident · No injuries · Closed · Apr 13, 1971 · N79222 · Substantial damage
- [NTSB FTW71FPJ30](https://openairdocs.org/ntsb/FTW71FPJ30.md): Cessna 172K · Bethany, OK · Accident · No injuries · Closed · Mar 14, 1971 · N84226 · Substantial damage
- [NTSB FTW71DPJ19](https://openairdocs.org/ntsb/FTW71DPJ19.md): Cessna 172 · Oklahoma Cty, OK · Accident · No injuries · Closed · Sep 29, 1970 · N79444 · Substantial damage
- [NTSB FTW71FPM02](https://openairdocs.org/ntsb/FTW71FPM02.md): Cessna 172 · Tulsa, OK · Accident · Minor injuries · Closed · Jul 5, 1970 · N78312 · Substantial damage
- [NTSB FTW70D0312](https://openairdocs.org/ntsb/FTW70D0312.md): Cessna 172 · Pryor, OK · Accident · No injuries · Closed · Nov 22, 1969 · N78142 · Substantial damage
- [NTSB FTW69F0324](https://openairdocs.org/ntsb/FTW69F0324.md): Cessna 172K · Oklahoma Cty, OK · Accident · No injuries · Closed · Dec 12, 1968 · N78622 · 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 ('2072430'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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