NTSB investigations: Cessna 182A, WI
12 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 | 1 |
|---|---|
| 1965 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1974 | 1 |
| 1978 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2010 | 1 |
| 2013 | 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\" = 'WI' 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" = 'WI' 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 CEN13LA503Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Concord, WIThe pilot's failure to properly plan for a maximum performance takeoff by not fully addressing the elevated density altitude or the nonstandard runway surface conditions and his failure to properly configure the airplane's flap setting for the accident…NTSB CEN10CA283Accident · No injuriesData collectionFinal reportCessna 182A · Franksville, WIThe pilot’s inadequate preflight inspection and delay in aborting the takeoff.NTSB CHI00FA227Accident · 4 fatalField investigationFinal reportCessna 182A · Sauk City, WIVFR flight into IMC encountered by the pilot and exceeding the design limits of the aircraf. A factor was flight to a destination alternate not performed by the pilot.NTSB CHI98LA261Accident · No injuriesLimited investigationFinal reportCessna 182A · Springbrook, WIThe pilot's improper attitude and excessive sink rate during landing. The terrain condition was a contributing factor in the accident.NTSB CHI91LA215Accident · No injuriesLimited investigationFinal reportCessna 182A · Menomonee Falls, WIThe fatigue induced propeller blade failure. A related factor was the operator's delayed propeller overhaul.NTSB CHI89LA051Accident · No injuriesLimited investigationFinal reportCessna 182A · Baldwin, WIFailure of the pilot to go around when he landed long with too much speed for the conditions. Factors related to the accident were: the pilot's excessive airspeed, his failure to attain the proper touchdown point, the crosswind, snowy/icy runway conditions,…NTSB CHI78FEP59Accident · Minor injuriesClosedCessna 182 · Bristol, WINTSB CHI75FEP15Accident · No injuriesClosedCessna 182A · Appleton, WINTSB CHI70DDJ25Accident · No injuriesClosedCessna 182 · Milwaukee, WINTSB CHI70D0130Accident · Minor injuriesClosedCessna 182A · Pulaski, WINTSB CHI65F0159Accident · No injuriesClosedCessna 182A · Phillips, WINTSB UNK64X3935Accident · No injuriesClosedCessna 182 · Eau Claire, WI