NTSB investigations: Cessna 182
7 cases on aircraft the registry lists as Cessna 182, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2005 | 2 |
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130))
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
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 DEN06LA015Accident · No injuriesLimited investigationFinal reportCessna 182 · Broomfield, COthe nose wheel assembly separation for reasons undetermined.NTSB LAX05LA125Accident · No injuriesLimited investigationFinal reportCessna 182 · Sacramento, CAa fatigue failure of the right side steering link rod for the nose landing gear steering system.NTSB SEA02LA184Accident · No injuriesLimited investigationFinal reportCessna 182 · Estacada, ORThe entanglement of an inadvertently opened skydiver's parachute in the aircraft’s elevator and rudder just after a group of four skydivers positioned themselves on the aircraft's external jump platform prior to a jump.NTSB SEA98LA158Accident · No injuriesLimited investigationFinal reportCessna 182 · Yellowpine, IDRight main landing gear spring strut fatigue, improper maintenance, and subsequent separation of the strut end.NTSB LAX93LA222Accident · No injuriesLimited investigationFinal reportCessna 182P · Reno, NVIncorrect installation of a bearing in the airplane's alternator during overhaul by maintenance personnel. A factor in the accident was the rough, uneven terrain.NTSB NYC84LA278Accident · No injuriesLimited investigationFinal reportCessna C182 · Norridgewock, MEA parachte became entangled in the horizontal stabilizer while the acft was maneuvering to drop the parachutists. The acft made a hard landing after the parachustist disengaged from the acft. The acft stabilizer spar was damaged in the encounter and the lack…NTSB CHI83LA004Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Shenandoah, OHJumper's parachute open prematurely pulling jumper into tail section bending horizontal stabilizer which in turn jammed the rudder. Plt could not flare acft during subsequent landing collapsing the main gear.