NTSB investigations: Cessna 182, OK
13 cases on aircraft the registry lists as Cessna 182. 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.
Cases per year
| 1964 | 4 |
|---|---|
| 1969 | 1 |
| 1978 | 1 |
| 1992 | 3 |
| 1993 | 2 |
| 2004 | 1 |
| 2017 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('2072702'))
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 ('2072702'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN17LA126Accident · No injuriesLimited investigationFinal reportCessna 182 · Skiatook, OKThe loss of directional control while taxiing for reasons that could not be determined because postaccident examination of the airplane revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB FTW04TA219Accident · Serious injuriesFinal reportCessna 182Q · Lamar, OKThe pilot's failure to maintain airspeed which resulted in a inadvertent stall. Contributing factors were the low altitude and high wind.NTSB FTW94FA028Accident · 3 fatalField investigationFinal reportCessna 182P · Marlow, OKAn inoperative vacuum system, an inoperative turn & bank indicator, and an inoperative directional gyro, which resulted in an inability of the pilot to control the airplane after it encountered instrument meteorological conditions (IMC). Factors related to…NTSB FTW93LA111Accident · No injuriesLimited investigationFinal reportCessna 182 · Washington, OKLoss of engine power for undetermined reason(s).NTSB FTW93LA043Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Washington, OKThe pilot's failure to maintain proper clearance over the fence.NTSB FTW92LA147Accident · No injuriesLimited investigationFinal reportCessna 182 · Coweta, OKThe total loss of engine power for undetermined reasons. Factors were the darkness of the night and the lack of suitable terrain available to the pilot for the forced landing.NTSB FTW92FA064Accident · 2 fatalField investigationFinal reportCessna 182 · Bartlesville, OKThe pilot's failure to maintain terrain clearance. A factor was the dark night.NTSB FTW78FPJ31Accident · No injuriesClosedCessna 182 · Cushing, OKNTSB FTW70D0297Accident · No injuriesClosedCessna 182 · Oklahoma Cty, OKNTSB UNK65X0875Accident · No injuriesClosedCessna 182 · Broken Arrow, OKNTSB UNK64X3479Accident · No injuriesClosedCessna 182 · Mcalester, OKNTSB UNK64X0486Accident · No injuriesClosedCessna 182 · Broken Arrow, OKNTSB UNK64X0273Accident · No injuriesClosedCessna 182 · Ada, OK