NTSB investigations: Cessna 182
10 cases on aircraft the registry lists as Cessna 182, where the sequence of events included Collision with terr/obj (non-CFIT). 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
| 2008 | 3 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2021 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072702')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072702')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 ERA22FA083Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Statesboro, GAThe pilot’s decision to initiate a visual flight rules flight into dark night instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control shortly after takeoff.NTSB WPR18LA183Accident · No injuriesLimited investigationFinal reportCessna 182 · Jacksonville, FLA total loss of engine power for reasons that could not be determined due to insufficient evidence.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 CEN16LA235Accident · No injuriesLimited investigationFinal reportCessna 182 · Kankakee, ILAa total loss of engine power due to fuel starvation, which resulted from the low level of fuel unporting during a rapid spiraling descent.NTSB ANC15CA052Accident · No injuriesData collectionFinal reportCessna 182 · Wasilla, AKThe pilot's failure to ensure adequate fuel was onboard to complete the flight, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the improperly calibrated fuel quantity indication system.NTSB ERA11CA430Accident · No injuriesData collectionFinal reportCessna 182 · Dandrige, TNThe loss of engine power due to fuel exhaustion as a result of poor planning.NTSB WPR10LA209Accident · Minor injuriesLimited investigationFinal reportCessna 182 · El Cajon, CAThe pilot's delayed use of carburetor heat while operating in conditions conducive to carburetor icing.NTSB CEN09IA096Incident · No injuriesIncident investigationFinal reportCessna 182 · Fort Worth, TXCollision with a hidden obstruction while taxiing through a grass field following a forced landing. Contributing to the accident was a loss of engine power due to the pilot's failure to turn on the carburetor heat.NTSB CHI08LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Romeo, MIThe misjudged landing flare by the pilot, and the inadequate landing gear inspection/repair procedure used by other maintenance personnel, resulting in the failure of the main landing gear strut during landing.NTSB SEA08CA076Accident · No injuriesData collectionFinal reportCessna 182 · Livermore, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during landing.