NTSB investigations: Cessna R182, IA
4 cases on aircraft the registry lists as Cessna R182. 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
| 1983 | 1 |
|---|---|
| 1984 | 2 |
| 2006 | 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\" = 'IA' 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 ('2072734'))
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" = 'IA' 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 ('2072734'))
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 CHI07LA011Accident · No injuriesLimited investigationFinal reportCessna R182 · Ames, IAThe fatigue failure of the landing gear actuator pin and the exterior visual maintenance inspection for cracks not possible by company maintenance personnel.NTSB MKC84FA271Accident · Serious injuriesField investigationFinal reportCessna R182 · Ottumwa, IAThe acft entered IMC weather, the plt became disoriented & cruised without ATC navigational assistance after failing to make radio contact or file a flt plan. The non-instrument rated private plt flew until acft power was lost due to fuel exhaustion. The…NTSB MKC84LA054Accident · No injuriesLimited investigationFinal reportCessna 182 · Marion, IAThe acft collided with a snowbank after swerving during takeoff. The swerve was started when the acft hit a windblown snowdrift which changed the acfts direction. After the collision the acfts nose gear collapsed and the left main gear retracted.NTSB MKC83LA056Accident · No injuriesLimited investigationFinal reportCessna 182RG · Woodbine, IAPilot checked braking on icy sod runway before takeoff and it seemed to be all right. Upon returning to land the pilot noticed a farmer driving cattle near the landing threshold so he decided to land long instead of going around. Using half flaps he landed…