NTSB investigations: Cessna 182E, 1988
3 cases on aircraft the registry lists as Cessna 182E. 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 | 30 |
|---|---|
| 1965 | 23 |
| 1966 | 28 |
| 1967 | 22 |
| 1968 | 7 |
| 1969 | 10 |
| 1970 | 18 |
| 1971 | 10 |
| 1972 | 8 |
| 1973 | 6 |
| 1974 | 10 |
| 1975 | 11 |
| 1976 | 8 |
| 1977 | 2 |
| 1978 | 5 |
| 1979 | 8 |
| 1980 | 2 |
| 1981 | 2 |
| 1982 | 6 |
| 1983 | 3 |
| 1985 | 1 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 5 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 5 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2013 | 3 |
| 2015 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 4 |
| 2022 | 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\") = 1988
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072712'))
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") = 1988
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072712'))
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 MIA89LA049Accident · No injuriesLimited investigationFinal reportCessna 182E · Ocala, FLShortly after rotation at an alt of aprx 20 ft AGL, the plt stated the control column would not move. He closed the throttle & the acft landed hard, bounced, then came to rest off the rwy. Examination of the acft revealed 3 of the 4 lower instrument panel…NTSB ATL89FA013Accident · 1 fatalField investigationFinal reportCessna 182E · Brooklet, GAWitnesses reported the plt began a low altitude, high speed pass over the rwy as he had done on several previous occasions. However, as he initiated the pass, the descent to the rwy was not arrested & the airplane 'pancaked' near the threshold. The airplane…NTSB CHI88LA171Accident · No injuriesLimited investigationFinal reportCessna 182E · Cedar Springs, MIDuring cruise flight the pilot reported that a total power loss occurred. The pilot executed a forced landing in an open field. On rollout the aircraft struck a stump and then a small shed. The post accident investigation revealed loosefuel caps and no fuel…