NTSB investigations: Cessna 182C, ID
7 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
| 1967 | 1 |
|---|---|
| 1979 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 2003 | 1 |
| 2011 | 1 |
| 2021 | 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\" = 'ID' 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" = 'ID' 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 WPR21LA304Accident · No injuriesClass 4 · LimitedFinal reportCessna 182C · Coeur D Alene, IDThe pilot’s failure to attain a proper touchdown point due to excessive airspeed, which resulted in a runway excursion and collision with an object near the end of the runway.NTSB WPR12CA060Accident · No injuriesData collectionFinal reportCessna 182C · Lowman, IDThe pilot's misjudgment of the runway surface firmness, which resulted in a nose-over during the landing roll.NTSB SEA03LA070Accident · No injuriesLimited investigationFinal reportCessna 182C · Stanley, IDThe pilot's inadequate in-flight planning that resulted in fuel exhaustion and the subsequent loss of engine power during descent. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB SEA83FA187Accident · 3 fatalField investigationFinal reportCessna 182C · Near Elk River, IDThe acft collided with trees and crashed into heavily wooded area at about 4000 ft MSL. The purpose of flight was to look for game or areas for hunting in a pre-hunting game spotting trip. The acft first impacted a large 200 ft tree about 85 ft below its top.…NTSB SEA82DA118Accident · No injuriesFinal reportCessna 182C · Near Dixie, IDThe pilot was taking off from a wet, sod airstrip when he elected to abort at about the midway point of the runway. While aborting, the aircraft hit a soft spot in the runway which sheared off the nose gear. Aircraft continued off end of runway and burned.NTSB SEA80FYP01Accident · No injuriesClosedCessna 182C · Lewiston, IDNTSB SEA68D0129Accident · No injuriesClosedCessna 182 · Bridge, ID