NTSB investigations: Cessna 182R
7 cases on aircraft the registry lists as Cessna 182R, where the first occurrence was “In flight collision with terrain/water”. 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 |
|---|---|
| 1985 | 2 |
| 1989 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1997 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072731')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072731')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
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 LAX98GA029Accident · 2 fatalFinal reportCessna 182R · Markleeville, CAthe pilot-passenger's failure to maintain sufficient altitude and airspeed to avoid collision with terrain, and the pilot-in-command's diverted attention and failure to recognize a deteriorating situation in time to effect a safe recovery.NTSB SEA96GA129Accident · Minor injuriesFinal reportCessna 182R · Grand View, IDfailure of the pilot to maintain clearance from mountainous terrain in a box canyon. The mountainous terrain and box canyon, limiting the pilot's ability to climb or maneuver and maintain sufficient altitude in the canyon, were related factors.NTSB LAX93LA129Accident · No injuriesLimited investigationFinal reportCessna 182R · Warner Springs, CAThe pilots decision to attempt flight into known adverse weather conditions.NTSB LAX89LA264Accident · No injuriesLimited investigationFinal reportCessna 182 · Parker Dam, CAThe pilot's delay in making a go-around, and his failure to maintain clearance from the terrain during the aborted landing. The runway/terrain condition was a related factor.NTSB SEA85LA202Accident · No injuriesLimited investigationFinal reportCessna 182R · Reno, NVThe student pilot had only 1.9 hours of flt time in the Cessna 182R and a ttl PIC time of 6.6 hrs. After practicing turns around a point at 800 ft AGL a climb was initiated. The acft was unable to clear the rising terrain due to a density alt of aprx 8200 ft.…NTSB DEN85LA182Accident · Minor injuriesLimited investigationFinal reportCessna 182-R · Telluride, COThe plt said that he maneuvered the near max gwt acft in close proximity to a ski slope and 'I didn't leave myself an exit.' The plt then applied full power in an attempt to outclimb the rising terrain but impacted a knoll. Density altitude was computed to be…NTSB LAX83FA188Accident · 2 fatalField investigationFinal reportCessna 182RII · Casa Grande, AZThe acft collided with a lone mountain while in straight & level flight.