Skip to content

NTSB investigations: Cessna 182A, OK

20 cases on aircraft the registry lists as Cessna 182A. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with 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 ('2072704')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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 ('2072704'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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 ('2072704'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CEN17LA235Accident · No injuriesLimited investigationFinal reportCessna 182A · Buffalo, OKThe separation of the nose wheel axle bolt and the nose wheel during the landing roll for reasons that could not be determined because the bolt was not recovered.Jun 17, 2017 · N6196B · Substantial damage NTSB CEN12CA016Accident · No injuriesData collectionFinal reportCessna 182A · Skiatook, OKA total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel management.Oct 12, 2011 · N6171B · Substantial damage NTSB CEN09LA325Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Skiatook, OKLoss of engine power for undetermined reasons.May 23, 2009 · N4892D · Substantial damage NTSB FTW02LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Chickasha, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Oct 6, 2001 · N3862D · Substantial damage NTSB FTW96LA312Accident · No injuriesLimited investigationFinal reportCessna 182A · Skiatook, OKa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Jul 21, 1996 · N2182G · Substantial damage NTSB FTW96LA017Accident · No injuriesLimited investigationFinal reportCessna 182A · Norman, OKthe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for a forced landing.Oct 17, 1995 · N5060D · Substantial damage NTSB FTW89LA088Accident · No injuriesLimited investigationFinal reportCessna 182 · Owasso, OKInadequate preflight by the pilot, which resulted in fuel exhaustion from lack of fuel. The presence of trees was was a contributing factor.Apr 27, 1989 · N5160D · Substantial damage NTSB FTW86LPJ03Accident · No injuriesFinal reportCessna 182 · Goldsby, OKThe plt stated the purpose of the flt was to drop parachute jumpers. The jumpers deplaned at 8500 ft MSL and the plt reduced pwr for a descent and landing at the arpt of departure. He stated he did not apply carb heat during the entire descent and he entered…Nov 16, 1985 · N6001B · Destroyed NTSB FTW83FA172Accident · 1 fatalField investigationFinal reportCessna 182A · Bethany, OKThe student pilot departed Oklahoma city, OK en route to chickasha, OK. The acft was observed to depart runway 17R and proceed wsw of the airport. The acft wreckage was located about 1 1/2 miles west of wiley post airport. The acft was intact and exam…Mar 31, 1983 · N2030G · Destroyed NTSB FTW78DPJ11Accident · No injuriesClosedCessna 182 · Hooker, OKJan 12, 1978 · N4973D · Substantial damage NTSB FTW75FPJ06Accident · Minor injuriesClosedCessna 182A · Stroud, OKSep 21, 1974 · N5945B · Substantial damage NTSB FTW73FPM14Accident · No injuriesClosedCessna 182A · Kingston, OKJun 8, 1973 · N2146G · Destroyed NTSB FTW72FPJ43Accident · Minor injuriesClosedCessna 182A · Bison, OKJun 26, 1972 · N3712D · Substantial damage NTSB FTW72AF048Accident · 4 fatalClosedCessna 182A · Octavia, OKJan 18, 1972 · N6173B · Destroyed NTSB FTW69D0213Accident · No injuriesClosedCessna 182A · Mill Creek, OKSep 29, 1968 · N2201G · Substantial damage NTSB FTW69D0151Accident · No injuriesClosedCessna 182A · Lexington, OKAug 4, 1968 · N6123B · Substantial damage NTSB FTW68D0027Accident · No injuriesClosedCessna 182 · Hammon, OKJun 22, 1967 · N3837D · Substantial damage NTSB UNK65X0238Accident · No injuriesClosedCessna 182 · Cache, OKOct 11, 1964 · N4898D · Substantial damage NTSB UNK64X2853Accident · No injuriesClosedCessna 182 · Weatherford, OKJul 16, 1964 · N3971D · Substantial damage NTSB UNK64X0149Accident · No injuriesClosedCessna 182 · Kingston, OKJan 4, 1964 · N2204G · Substantial damage