NTSB investigations: Cessna 182Q, 2007
10 cases on aircraft the registry lists as Cessna 182Q. 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
| 1977 | 6 |
|---|---|
| 1978 | 15 |
| 1979 | 21 |
| 1980 | 15 |
| 1981 | 17 |
| 1982 | 13 |
| 1983 | 14 |
| 1984 | 9 |
| 1985 | 8 |
| 1986 | 6 |
| 1987 | 9 |
| 1988 | 5 |
| 1989 | 10 |
| 1990 | 4 |
| 1991 | 10 |
| 1992 | 10 |
| 1993 | 8 |
| 1994 | 6 |
| 1995 | 10 |
| 1996 | 7 |
| 1997 | 4 |
| 1998 | 8 |
| 1999 | 9 |
| 2000 | 5 |
| 2001 | 9 |
| 2002 | 15 |
| 2003 | 6 |
| 2004 | 7 |
| 2005 | 4 |
| 2006 | 4 |
| 2007 | 10 |
| 2008 | 2 |
| 2009 | 7 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 4 |
| 2014 | 5 |
| 2015 | 10 |
| 2016 | 5 |
| 2017 | 2 |
| 2018 | 7 |
| 2019 | 5 |
| 2020 | 1 |
| 2021 | 8 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 1 |
| 2025 | 3 |
| 2026 | 5 |
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\") = 2007
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072732'))
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") = 2007
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072732'))
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 DEN08FA036Accident · 1 fatalField investigationFinal reportCessna 182Q · Farmerville, LAThe pilot's failure to maintain aircraft control due to the effects of impairment from alcohol consumption resulting in the collision with the trees.. A contributing factor was the Federal Aviation Administration's failure to identify existing evidence of…NTSB DEN07CA162Accident · Minor injuriesData collectionFinal reportCessna 182Q · Glenwood Spring, COThe pilot's failure to go around when it became apparent that he could not land and stop the airplane on the remaining runway. Factors contributing to the accident were the tailwind and the gusts.NTSB SEA07CA257Accident · No injuriesData collectionFinal reportCessna 182Q · Dunsmuir, CAThe pilot's misjudgment of distance/speed and his failure to attain the proper touchdown point during landing, which resulted in a runway overrun during the landing roll.NTSB NYC07CA161Accident · No injuriesData collectionFinal reportCessna 182Q · New Haven, CTThe pilot's improper flare which resulted in a hard landing. A factor to the accident was the wind gusts.NTSB SEA07FA189Accident · 1 fatalField investigationFinal reportCessna 182Q · Cashmere, WAThe pilot's failure to maintain adequate clearance from trees while on final approach. A contributing factor was the sun glare.NTSB ATL07FA083Accident · 3 fatalField investigationFinal reportCessna 182Q · Asheville, NCThe failure of the directional gyro and attitude indicator due to a vacuum system leak caused by a loose fitting. Contributing to the accident was the pilot's failure to execute a partial panel, no-gyro approach.NTSB LAX07LA140Accident · 3 fatalLimited investigationFinal reportCessna 182Q · Carlsbad, CAthe pilot's loss of control due to spatial disorientation.NTSB MIA07FA083Accident · 3 fatalField investigationFinal reportCessna 182Q · Cudjoe Key, FLThe pilot's failure to maintain clearance from an active restricted area, which resulted in the airplane colliding with the tether of an aerostat.NTSB LAX07LA102Accident · No injuriesLimited investigationFinal reportCessna 182Q · Banning, CALoss of engine power while on final approach for undetermined reasons. Contributing to the accident was the unfavorable wind condition.NTSB MIA07LA036Accident · No injuriesLimited investigationFinal reportCessna 182Q · Coral Springs, FLThe improper design change associated with a Supplemental Type Certificate (STC), which resulted in an in-flight fire.