NTSB investigations: Cessna 182K, 1995
3 cases on aircraft the registry lists as Cessna 182K. 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
| 1967 | 26 |
|---|---|
| 1968 | 28 |
| 1969 | 20 |
| 1970 | 10 |
| 1971 | 12 |
| 1972 | 9 |
| 1973 | 7 |
| 1974 | 15 |
| 1975 | 11 |
| 1976 | 7 |
| 1977 | 12 |
| 1978 | 3 |
| 1979 | 5 |
| 1980 | 14 |
| 1981 | 4 |
| 1982 | 2 |
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 4 |
| 1990 | 2 |
| 1991 | 4 |
| 1992 | 3 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 4 |
| 2000 | 2 |
| 2001 | 5 |
| 2003 | 3 |
| 2004 | 5 |
| 2006 | 2 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 1 |
| 2014 | 2 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 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 year(c.\"eventDate\") = 1995
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072724'))
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") = 1995
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072724'))
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 CHI96LA051Accident · No injuriesLimited investigationFinal reportCessna 182 · Tamms, ILfuel exhaustion due to inadequate maintenance performed on the fuel cap by the maintenance personnel, fuel siphoning out of the left fuel cap, and the failure of the pilot to properly monitor his fuel consumption.NTSB FTW95LA229Accident · No injuriesLimited investigationFinal reportCessna 182K · Alamosa, COFailure of the pilot to maintain directional control during the landing roll, which resulted in a ground swerve and collision with a taxiway sign. Factors relating to the accident were: the unfavorable (gusty/quartering) wind condition, and the taxiway sign's…NTSB BFO95LA034Accident · No injuriesLimited investigationFinal reportCessna 182K · Gretna, VAThe pilot's improper flare which resulted in a hard landing.