NTSB investigations: Cessna 182Q, IA
4 cases on aircraft the registry lists as Cessna 182Q. 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
| 1979 | 1 |
|---|---|
| 1987 | 1 |
| 1991 | 1 |
| 2025 | 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 ('2072732'))
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 ('2072732'))
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 ANC26LA020Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182Q · Mapleton, IAOn October 29, 2025, at about 1200 Central daylight time, a Cessna 182Q, N735ZD, was substantially damaged when it was involved in an accident near Mapleton, Iowa. The pilot and three passengers were not injured. The airplane was operated as a Title 14 Code…NTSB CHI91LA263Accident · No injuriesLimited investigationFinal reportBeech 36 · Davenport, IAThe inadequate visual lookout and poor inflight planning and decision making by the pilot of N97867. Factors in the accident are inoperative exterior lights and radio communication not possible.NTSB MKC88LA035Accident · No injuriesLimited investigationFinal reportCessna 182Q · Davenport, IAThe PIC had chosen rwy 15 for the LOC app and was cleared by approach control. The PIC stated that he cancelled his IFR flt plan entering clear conditions at 3,000 ft. the PIC further stated that he planned an approach using a ltl higher spd for the gusty…NTSB MKC79FCD15Accident · No injuriesClosedCessna 182Q · Tipton, IA