NTSB investigations: Cessna 182G, AK
5 cases on aircraft the registry lists as Cessna 182G. 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
| 1975 | 1 |
|---|---|
| 1979 | 1 |
| 1986 | 1 |
| 1987 | 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.\"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 ('2072716'))
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 ('2072716'))
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 ANC87LA155Accident · No injuriesLimited investigationFinal reportCessna 182 · Anchorage, AKThe pilot stated that after touchdown on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back. He also indicated that the strip was soft and the nose wheel dug in after touchdown.NTSB ANC87LA087Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Chistochina, AKDuring a telephone interview the pilot stated the aircraft did not produce full power and believed the reason was the propeller setting was not set to high RPM before landing. The aircraft stalled on final approach to the airport and the aircraft impacted the…NTSB SEA87LA022Accident · No injuriesLimited investigationFinal reportCessna 182G · Juneau, AKAccording to the plt, he 'greased' the acft on the rwy, but the cast alluminum yoke on the nose gear failed & the nosewheel left the airplane. The strut then failed & the acft was further damaged.NTSB ANC79DA079Accident · No injuriesClosedCessna 182 · Bornite, AKNTSB ANC76DAG39Accident · Serious injuriesClosedCessna 182 · Isabell Camp, AK