NTSB investigations: Cessna 182, OR
13 cases on aircraft the registry lists as Cessna 182. 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
| 1964 | 2 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 1 |
| 1977 | 1 |
| 1982 | 1 |
| 2002 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2012 | 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 ('2072702'))
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 ('2072702'))
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 WPR12CA353Accident · No injuriesData collectionFinal reportCessna 182 · Joseph, ORThe pilot’s excessive use of brakes during the landing roll in a gusting crosswind, which resulted in a noseover.NTSB WPR09CA477Accident · No injuriesData collectionFinal reportCessna 182 · Enterprise, ORThe pilot's failure to stop his airplane before it departed the end of the unimproved remote airstrip.NTSB LAX08CA174Accident · Minor injuriesData collectionFinal reportCessna 182 · Cottage Grove, ORThe pilot's misjudged landing flare.NTSB LAX07CA111Accident · Serious injuriesData collectionFinal reportCessna 182 · Diamond Lake, ORFuel exhaustion due to the pilot's inadequate preflight inspection and failure to verify the fuel supply. A factor was the night lighting condition.NTSB SEA02LA184Accident · No injuriesLimited investigationFinal reportCessna 182 · Estacada, ORThe entanglement of an inadvertently opened skydiver's parachute in the aircraft’s elevator and rudder just after a group of four skydivers positioned themselves on the aircraft's external jump platform prior to a jump.NTSB SEA82DYM14Accident · No injuriesFinal reportCessna 182 · Albany, ORThe pilot proceeded to the run-up area at the end of the runway. After making a run-up, he elected to taxi to refuel before taking off. He stated that he was making a turn when a gust of wind picked up his right wing. The aircraft then turned until it was in…NTSB SEA77FYK06Accident · No injuriesClosedCessna 182 · Burns, ORNTSB SEA68D0229Accident · No injuriesClosedCessna 182 · Forest Grove, ORNTSB SEA67D0074Accident · No injuriesClosedCessna 182 · Frenchglen, ORNTSB SEA66F0118Accident · No injuriesClosedCessna 182 · Baker, ORNTSB SEA66A0018Accident · 2 fatalClosedCessna 182 · Prineville, ORNTSB UNK65X0271Accident · No injuriesClosedCessna 182 · Minam Lodge, ORNTSB UNK64X0268Accident · 4 fatalClosedCessna 182 · Lakeview, OR