NTSB investigations: Cessna 182P, AK
8 cases on aircraft the registry lists as Cessna 182P. 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
| 1977 | 1 |
|---|---|
| 1982 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1992 | 1 |
| 2006 | 1 |
| 2011 | 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 ('2075816'))
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 ('2075816'))
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 ANC11FA069Accident · 2 fatalField investigationFinal reportCessna 182P · Juneau, AKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. Contributing to the accident was the pilot's self-induced pressure to reach his destination.NTSB ANC11CA042Accident · No injuriesData collectionFinal reportCessna 182P · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions and his failure to maintain control of the airplane during a water landing.NTSB ANC06LA067Accident · No injuriesLimited investigationFinal reportCessna 182 · Chenega Bay, AKA loss of engine power for an undetermined reason while maneuvering at low level over a beach, which resulted in an in-flight collision with rough terrain and a nose over. A factor in the accident was the rough/uneven terrain.NTSB ANC92LA149Accident · No injuriesLimited investigationFinal reportCessna 182P · Montague Island, AKThe pilot in command did not properly align the airplane with the airstrip landing zone. A factor which contributed to the accident were the trees.NTSB ANC87FA110Accident · Minor injuriesField investigationFinal reportCessna 182P · Anchorage, AKThere was hvy traffic when the plt of N1946M contacted Anchorage (anc) intl twr for lndg instrns at the lake hood strip. Anc twr ctld traffic at the nrby lake hood strip & lake hood seaplane base, as well as at the anc intl arpt. The wnd at lake hood had been…NTSB SEA86FA041Accident · 1 fatalField investigationFinal reportCessna 182 · Juneau, AKPilot requested clearance to return to airport after takeoff due to eng power loss. Clearance was given by ATC. Pilot made rt turn from about 100 ft alt. Acft crashed about 1500 foot south of rwy. No shoulder harnesses installed. Pax survived. Ice found on…NTSB ANC82DAA09Accident · No injuriesFinal reportCessna 182 · Ft. Yukon, AKThe pilot stated that he overflew the Ft. Yukon airport and observed men working on runway 21. He flew a downwind pattern for runway 03. While on final approach to runway 03 the pilot observed an "x" on the end of the runway the pilot attempted a landing off…NTSB ANC77DAA32Accident · No injuriesClosedCessna 182 · Chandalar Camp, AK