NTSB investigations: Cessna 182A, OR
19 cases on aircraft the registry lists as Cessna 182A. 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 | 3 |
| 1966 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1977 | 1 |
| 1978 | 2 |
| 1979 | 1 |
| 1980 | 2 |
| 1983 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 2005 | 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 ('2072704'))
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 ('2072704'))
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 SEA05CA059Accident · No injuriesData collectionFinal reportCessna 182A · Manzanita, ORThe pilot's inadequate compensation for the wind, which resulted in an inflight loss of control, a subsequent uncontrolled descent into the tree stump and guy wire, and the resultant nose over. A factor contributing to the accident was the downdraft.NTSB SEA91LA234Accident · No injuriesLimited investigationFinal reportCessna 182A · Grants Pass, ORPilot's selection of unsuitable terrain for a precautionary landing. Factors related to the accident were: motion sickness of the passenger, wet grass runway, the pilot's self-induced pressure to land at the accident airport, and the ditch.NTSB SEA91LA029Accident · No injuriesLimited investigationFinal reportCessna 182A · Burns, ORThe formation of carburetor ice when the pilot delayed the use of carburetor heat.NTSB SEA89LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Arlington, ORThe student pilot touched down too FAR down the runway to allow him to stop before running into a trailer.NTSB SEA83LA161Accident · No injuriesLimited investigationFinal reportCessna 182A · Sheridan, ORThe acft lost power on final approach to land and made contact with a fence short of the rwy and nosed over. During preflt the pilot had omitted checking the fuel with a fuel strainer because he did not have one. During inspection the carburetor was found to…NTSB SEA80FYM63Accident · No injuriesClosedCessna 182A · Harrisburg, ORNTSB SEA80FYK12Accident · Serious injuriesClosedCessna 182A · Roseburg, ORNTSB SEA79FYM41Accident · No injuriesClosedCessna 182 · Wilsonville, ORNTSB SEA79FYA04Accident · Serious injuriesClosedCessna 182A · Jamieson, ORNTSB SEA78FYM51Accident · Minor injuriesClosedCessna 182 · Oregon City, ORNTSB SEA77DYM56Accident · No injuriesClosedCessna 182 · John Day, ORNTSB SEA71AS002Accident · No injuriesClosedCessna 182A · Glendale, ORNTSB OAK70A0004Accident · 1 fatalClosedCessna 182 · Pendleton, ORNTSB SEA67F0112Accident · No injuriesClosedCessna 182-A · Crescent Lke, ORNTSB SEA66F0051Accident · No injuriesClosedCessna 182 · Grants Pass, ORNTSB SEA65F0043Accident · Minor injuriesClosedCessna 182 · Pilot Rock, ORNTSB SEA65A0041Accident · 2 fatalClosedCessna 182 · Unity, ORNTSB UNK65X0484Accident · No injuriesClosedCessna 182 · Wallowa Co, ORNTSB UNK64X0246Accident · No injuriesClosedCessna 182A · Hood River, OR