NTSB investigations: Cessna 182C, AK
8 cases on aircraft the registry lists as Cessna 182C. 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
| 1978 | 1 |
|---|---|
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 2009 | 1 |
| 2020 | 1 |
| 2022 | 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\" = 'AK' 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 ('2072708'))
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" = 'AK' 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 ('2072708'))
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 ANC22LA055Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182C · Port Moller, AKThe pilot’s inadequate preflight inspection, which did not detect a screw in the control yoke column, and his failure to confirm flight control continuity before takeoff.NTSB ANC20CA055Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Anchorage, AKThe pilot’s failure to maintain a proper descent rate during landing in gusting wind conditions, which resulted in a hard landing.NTSB ANC10CA009Accident · No injuriesData collectionFinal reportCessna 182C · Kotzebue, AKThe pilot's failure to maintain directional control and his selection of unsuitable terrain for takeoff.NTSB ANC97LA018Accident · No injuriesLimited investigationFinal reportCessna 182 · Skwentna, AKthe pilot's selection of an unsuitable area (terrain) for landing. A factor relating to the accident was: excessive snow cover on the airstrip.NTSB ANC91LA110Accident · No injuriesLimited investigationFinal reportCessna 182C · Cordova, AKA total loss of engine power while operating over water.NTSB ANC90FA032Accident · Minor injuriesField investigationFinal reportCessna 182 · Anchorage, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: the obstructions (utility pole, power line & fence) in the emergency landing area.NTSB ANC90LA028Accident · No injuriesLimited investigationFinal reportCessna 182 · Chakachamna Lk, AKInadequate preflight preparation of the takeoff area by the pilot, and his attempt to take off on unsuitable terrain. The soft/snow covered terrain was considered to be a contributing factor.NTSB ANC79DAG14Accident · No injuriesClosedCessna 182 · Skwentna, AK