NTSB investigations: Cessna 182Q, OR
9 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
| 1980 | 1 |
|---|---|
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2004 | 1 |
| 2023 | 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\" = 'OR' 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" = 'OR' 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 WPR23LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Aurora, ORThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB SEA04FA060Accident · 3 fatalField investigationFinal reportCessna 182Q · Santiam Junc., ORThe pilot's failure to maintain adequate airspeed which resulted in a stall while attempting a low-level crossing of a ridge from the leeward to the windward side. Factors include low-level maneuvering, strong gusty winds, and downdrafts.NTSB SEA99LA164Accident · No injuriesLimited investigationFinal reportCessna 182Q · Crescent Lake, ORThe pilot's failure to maintain directional control during a bounced landing. Factors include a sudden wind shift, a crosswind gust, and tall trees growing along the side of the airstrip.NTSB SEA97LA007Accident · No injuriesLimited investigationFinal reportCessna 182Q · Manzanita, ORfailure of pilot to adequately compensate for wind conditions on final approach and attain a proper touchdown point for landing. A factor relating to the accident was: the unfavorable wind condition.NTSB SEA94FA100Accident · 2 fatalField investigationFinal reportCessna 182Q · The Dalles, ORAn inflight loss of control for undetermined reasons.NTSB SEA83FA139Accident · Serious injuriesField investigationFinal reportCessna 182Q II · Near Peak, ORThe acft collided with rising terrain as the pilot tried unsuccessfully to avoid the trees and ridges. The two rear seatpassengers reported that they flew up a canyon at about 6500 ft MSL. The ridges on either side were as high as the acft. The pilot was seen…NTSB SEA82DA073Accident · No injuriesFinal reportCessna 182QII · Cove, ORThe pilot stated that he landed heavy and was not quite straight. When the aircraft bounced the pilot attempted a go-around but the nose gear contacted a fence and the aircraft nosed over.NTSB SEA81DYM40Accident · No injuriesClosedCessna 182Q · Enterprise, ORNTSB SEA81FA002Accident · 1 fatalClosedCessna 182Q · Ashland, OR