# NTSB investigations: Cessna 172G, 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 FTW98LA040](https://openairdocs.org/ntsb/FTW98LA040.md): Cessna 172G · Elk City, OK · Accident · No injuries · Limited investigation · Final report · Nov 2, 1997 · N5745R · Substantial damage
  > The high winds and the pilot's poor judgment in attempting to taxi in the existing wind conditions.
- [NTSB FTW96LA204](https://openairdocs.org/ntsb/FTW96LA204.md): Cessna 172G · Okmulgee, OK · Accident · Minor injuries · Limited investigation · Final report · May 9, 1996 · N202EX · Substantial damage
  > The pilot's continued operation with known deficiencies in the airplane and the pilot's and maintenance personnel's failure to comply with an airworthiness directive resulting in the malfunctioning of a worn ignition switch. A factor was trees.
- [NTSB FTW88DPJ06](https://openairdocs.org/ntsb/FTW88DPJ06.md): Cessna 172G · Frederick, OK · Accident · Serious injuries · Final report · Jun 9, 1988 · N1103F · Substantial damage
  > During slow taxi to takeoff, a gust of wind or a dust devil lifted aircraft off taxiway and flipped it inverted. Numerous small whirlwinds were observed in the vicinity of the airport at the time.
- [NTSB FTW86FA086](https://openairdocs.org/ntsb/FTW86FA086.md): Cessna 172G · Blackwell, OK · Accident · 1 fatal · Field investigation · Final report · May 13, 1986 · N5878R · 2 aircraft · Destroyed
  > The pilot of N5878R, a Cessna 172G, had no previous experience in formation flying. The pilot of N2603E, an Aeronca 7AC, stated he had many hours of formation flying in the military during world war ii and has made an occasional formation flight since that…
- [NTSB FTW76AF103](https://openairdocs.org/ntsb/FTW76AF103.md): Cessna 172M · Sperry, OK · Accident · 3 fatal · Closed · Jun 18, 1976 · N13132 · 2 aircraft · Destroyed
- [NTSB FTW72AF003](https://openairdocs.org/ntsb/FTW72AF003.md): Cessna 172 · Sasakwa, OK · Accident · 2 fatal · Closed · Jul 12, 1971 · N5978R · Destroyed
- [NTSB FTW72FPJ02](https://openairdocs.org/ntsb/FTW72FPJ02.md): Cessna 172 · Fort Supply, OK · Accident · No injuries · Closed · Jul 5, 1971 · N3761L · Substantial damage
- [NTSB FTW68F0509](https://openairdocs.org/ntsb/FTW68F0509.md): Cessna 172 · Oklahoma Cty, OK · Accident · Minor injuries · Closed · Mar 14, 1968 · N1156F · Substantial damage
- [NTSB FTW68F0045](https://openairdocs.org/ntsb/FTW68F0045.md): Cessna 172G · Washington, OK · Accident · Minor injuries · Closed · Jul 5, 1967 · N4346W · Substantial damage
- [NTSB FTW67D0444](https://openairdocs.org/ntsb/FTW67D0444.md): Cessna 172 · Newkirk, OK · Accident · No injuries · Closed · Feb 10, 1967 · N3683L · Substantial damage
- [NTSB FTW67D0319](https://openairdocs.org/ntsb/FTW67D0319.md): Cessna 172 · Norman, OK · Accident · No injuries · Closed · Nov 20, 1966 · N5950R · Substantial damage
- [NTSB FTW67D0274](https://openairdocs.org/ntsb/FTW67D0274.md): Cessna 172 · Bartlesville, OK · Accident · No injuries · Closed · Oct 14, 1966 · N4206L · Substantial damage
- [NTSB FTW66D0452](https://openairdocs.org/ntsb/FTW66D0452.md): Cessna 172 · Altus, OK · Accident · No injuries · Closed · Dec 24, 1965 · N5950R · 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 ('2072420'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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