NTSB investigations: Cessna 182A, 2009
5 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 | 48 |
|---|---|
| 1965 | 43 |
| 1966 | 42 |
| 1967 | 28 |
| 1968 | 31 |
| 1969 | 24 |
| 1970 | 17 |
| 1971 | 21 |
| 1972 | 17 |
| 1973 | 16 |
| 1974 | 19 |
| 1975 | 19 |
| 1976 | 15 |
| 1977 | 12 |
| 1978 | 13 |
| 1979 | 8 |
| 1980 | 20 |
| 1981 | 11 |
| 1982 | 7 |
| 1983 | 8 |
| 1984 | 6 |
| 1985 | 13 |
| 1986 | 11 |
| 1987 | 7 |
| 1988 | 8 |
| 1989 | 14 |
| 1990 | 10 |
| 1991 | 13 |
| 1992 | 7 |
| 1993 | 8 |
| 1994 | 6 |
| 1995 | 5 |
| 1996 | 5 |
| 1997 | 8 |
| 1998 | 6 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 9 |
| 2002 | 6 |
| 2003 | 8 |
| 2004 | 6 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 3 |
| 2008 | 5 |
| 2009 | 5 |
| 2010 | 2 |
| 2011 | 7 |
| 2012 | 6 |
| 2013 | 2 |
| 2014 | 5 |
| 2015 | 4 |
| 2016 | 6 |
| 2017 | 6 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 4 |
| 2022 | 1 |
| 2024 | 4 |
| 2025 | 2 |
| 2026 | 2 |
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 year(c.\"eventDate\") = 2009
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 year(c."eventDate") = 2009
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 CEN09CA519Accident · No injuriesData collectionFinal reportCessna 182A · Watertown, SDA loss of engine power due to fuel exhaustion as a result of a fuel tank leak. Contributing to the accident was the reported malfunction of the fuel gauge.NTSB CEN09LA325Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Skiatook, OKLoss of engine power for undetermined reasons.NTSB WPR09CA194Accident · Minor injuriesData collectionFinal reportCessna 182A · Las Vegas, NVThe pilot's inadequate compensation for the gusty crosswind conditions while landing.NTSB WPR09CA121Accident · Minor injuriesData collectionFinal reportCessna 182 · Caldwell, IDThe loss of engine power due to carburetor icing as a result of the pilot's failure to apply carburetor heat before reducing power and his failure to clear the engine during a prolonged glide.NTSB CEN09LA183Accident · No injuriesLimited investigationFinal reportCessna 182 · Kelleys Island, OHThe pilot's failure to maintain aircraft control while landing in gusty winds due to inadequate aileron cable tension.