NTSB investigations: Cessna 182H
5 cases on aircraft the registry lists as Cessna 182H, where the first occurrence was “Loss of control - in flight”. 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
| 1984 | 2 |
|---|---|
| 1995 | 1 |
| 1999 | 1 |
| 2003 | 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 ('2072718')
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\" = 250))
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 ('2072718')
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" = 250))
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 FTW03FA174Accident · 1 fatalField investigationFinal reportCessna 182H · Cushing, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.NTSB CHI99LA295Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Eagle River, WIthe pilot's inadequate compensation for the crosswind conditions and the subsequent failure to maintain directional control of the airplane. Factors associated with the accident were the gusty, crosswind conditions, and the rough/uneven terrain encountered.NTSB ATL95LA064Accident · No injuriesLimited investigationFinal reportCessna 182 · Nashville, TNThe pilot's improper use of the flight controls during takeoff which resulted in the inflight collision with the ground.NTSB DEN85FA035Accident · 2 fatalField investigationFinal reportCessna 182H · Provo, UTThe left seat non-instrument pvt plt was being checked out in the flying club acft by a comm plt. The acft was being flown over Utah lake on a dark night, on final approach to runway 31 at the pvu arpt. While on final, the flying plt manuevered the acft for…NTSB SEA84FA175Accident · 1 fatalField investigationFinal reportCessna 182H · Elko, NVAbout 5 min after taking off on rwy 23, the plt reported on a downwind leg of the traffic pattern. Shortly after that, the acft crashed about 2 mi south of the arpt while on a southerly heading in a left wing low attitude. During impact, the left wing tip hit…