NTSB investigations: Cessna 182Q, 2018
7 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\") = 2018
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") = 2018
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 ERA19LA031Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Elba, ALA leak in the pitot-static system for reasons that could not be determined based on the available information, which resulted in an airspeed indication error, an aborted takeoff, and a subsequent runway overrun.NTSB GAA18CA552Accident · No injuriesData collectionFinal reportCessna 182 · Page, AZThe pilot's improper landing flare, which resulted in a bounced landing.NTSB WPR18LA227Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Salmon, IDThe pilot’s inadvertent encounter with downdraft conditions, which resulted in a loss of altitude, and the pilot’s subsequent decision to conduct a precautionary landing into a stand of trees.NTSB GAA18CA396Accident · No injuriesData collectionFinal reportCessna 182 · San Luis Obispo, CAThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA262Accident · No injuriesData collectionFinal reportCessna 182 · Albuquerque, NMThe pilot’s decision to continue flight in mountainous terrain with downdraft conditions, which necessitated a precautionary landing on unsuitable terrain.NTSB GAA18CA202Accident · No injuriesData collectionFinal reportCessna 182 · Nephi, UTThe pilot’s failure to maintain a proper landing flare, which resulted in a hard landing.NTSB GAA18CA157Accident · No injuriesData collectionFinal reportCessna 182 · Rockford, ILThe pilot’s unnecessary action during the approach, which resulted in a hard landing.