NTSB investigations: Cessna 182Q, 2002
15 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\") = 2002
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") = 2002
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 ATL03FA017Accident · 1 fatalField investigationFinal reportCessna 182Q · Cornelia, GAThe pilot's failure to follow IFR approach procedures and continue below the minimum descent altitude, which resulted in an inflight collision with trees, and the ground. A factor was the pilot's impairment from a prescription drug.NTSB MIA03LA015Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Orlando, FLThe poor in-flight planning by the pilot-in-command for his failing to request a runway more aligned with the wind and his failure to maintain directional control after landing resulting in collapse of the nose landing gear and the airplane nosing over.NTSB LAX03LA046Accident · No injuriesLimited investigationFinal reportCessna 182Q · Pacoima, CAThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/mush and hard landing. A factor in the accident was the gusty wind.NTSB FTW02LA246Accident · No injuriesLimited investigationFinal reportCessna 182-Q · New Roads, LAThe pilot's failure to maintain airspeed which resulted in a stall.NTSB NYC02LA156Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cincinnati, OHThe pilot's misjudgment of distance which resulted in the airplane landing short of the runway.NTSB NYC02LA150Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Ravenna, OHThe pilot's loss of directional control for undetermined reasons.NTSB FTW02LA218Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Mc Allen, TXThe pilot's failure to refuel the airplane resulting in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA188Accident · No injuriesLimited investigationFinal reportCessna 182Q · Midland, TXThe pilot's hard landing as a result of her improper landing flare. Factors were the prevailing dark night conditions and the student pilot's lack of total experience in night operations.NTSB ATL02LA127Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lawrenceburg, TNThe pilot's failure to secure the fuel cap after refueling that resulted in fuel siphoning from the right main fuel tank and the subsequent fuel supply exhaustion, and the total loss of engine power. The airplane was damaged during the forced landing to a…NTSB LAX02FA198Accident · Serious injuriesField investigationFinal reportCessna 182Q · Deer Valley, AZa loss of engine power for undetermined reasons during the takeoff initial climb, and, the pilot's failure to maintain an adequate airspeed while maneuvering to return to the runway, which resulted in a stall.NTSB CHI02LA178Accident · No injuriesLimited investigationFinal reportCessna 182Q · Vermillion, SDThe pilot's improper flare.NTSB LAX02LA194Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sedona, AZThe pilot's inadequate recovery from a bounced landing.NTSB IAD02LA055Accident · No injuriesLimited investigationFinal reportCessna 182Q · Rutland, VTThe pilot's failure to attain the proper touchdown point. A factor was the crosswindNTSB LAX02LA165Accident · No injuriesLimited investigationFinal reportCessna 182Q · San Diego, CAThe pilot's failure to apply continuous brake pressure. Sun glare is a contributing factor.NTSB NYC02LA101Accident · No injuriesLimited investigationFinal reportCessna 182Q · Teterboro, NJThe pilot's improper flare and his improper recovery from a bounced landing, which resulted in a hard landing. A factor in this accident was the crosswind condition.