NTSB investigations: Cessna 182A, 1997
8 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\") = 1997
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") = 1997
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 IAD98FA012Accident · 2 fatalField investigationFinal reportCessna 182A · New Dover, OHThe pilot's attempted VFR flight into instrument conditions and the loss of aircraft ctontrol subsequent to the pilot's spatial disorientation. Contributing factors were low ceilings, snow and the pilot's failure to obtain a preflight weather briefing, as…NTSB ATL98LA014Accident · No injuriesLimited investigationFinal reportCessna 182A · Waycross, GAa loss of engine power for undetermined reasons.NTSB MIA98LA028Accident · No injuriesLimited investigationFinal reportCessna 182A · Parkton, NCimproper installation of an auto battery cable which led to an in-flight fire due to the chaffed cable.NTSB NYC98LA008Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-17 · Elkton, MDThe inadequate lookout by the pilot of the Cessna and his failure to maintain adequate clearance between his airplane and the active runway. A factor in the accident was the lack of taxiway hold signs or lines.NTSB FTW97LA324Accident · No injuriesLimited investigationFinal reportCessna 182A · Delta, COFailure by the pilot to properly plan for the flight in that the fuel aboard was insufficient for the planned flight. Factors were: inaccurate fuel gauges and terrain condition for the forced landing.NTSB NYC97LA140Accident · No injuriesLimited investigationFinal reportCessna 182A · Hayfield Twnshp, PAThe pilot's improper decision to attempt a takeoff from unsuitable terrain and failure to maintain airspeed. A factor in this accident was the gusty wind conditions.NTSB LAX97LA232Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Santa Paula, CAFuel exhaustion due to the pilot's inadequate preflight planning/inspection and his failure to ensure that adequate fuel was onboard prior to departure.NTSB FTW97LA091Accident · No injuriesLimited investigationFinal reportCessna 182A · Midland, TXThe pilot's failure to periodically clear the engine during an extended glide. Factors were the carburetor icing weather conditions and the lack of suitable terrain for the forced landing.