NTSB investigations: Cessna 210L, 1989
6 cases on aircraft the registry lists as Cessna 210L. 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
| 1972 | 1 |
|---|---|
| 1973 | 1 |
| 1974 | 10 |
| 1975 | 11 |
| 1976 | 17 |
| 1977 | 13 |
| 1978 | 10 |
| 1979 | 9 |
| 1980 | 8 |
| 1981 | 10 |
| 1982 | 12 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 8 |
| 1989 | 6 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 2 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 10 |
| 2003 | 4 |
| 2004 | 1 |
| 2005 | 4 |
| 2007 | 2 |
| 2008 | 1 |
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2016 | 1 |
| 2017 | 2 |
| 2019 | 2 |
| 2020 | 3 |
| 2024 | 1 |
| 2025 | 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\") = 1989
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073448'))
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") = 1989
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073448'))
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 CHI90LA047Accident · No injuriesLimited investigationFinal reportCessna 210 · New Phila, OHThe pilot's failure to drain all of the trapped water from the fuel system prior to flight. Factors related to the accident were: the unfavorable wind condition and trees in the emergency landing area.NTSB LAX89LA305Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Marble Canyon, AZThe pilot selected the wrong runway and landed downwind.NTSB NYC89LA209Accident · Serious injuriesLimited investigationFinal reportCessna 210 · No. Windham, VTThe pilot's failure to assure an adequate supply of fuel was available.NTSB MIA89FA214Accident · 1 fatalField investigationFinal reportCessna 210L · Marco, FLContinued VFR flight by the pilot into instrument meteorological conditions (IMC), his misjudgment of altitude and his physical impairment from use of drugs. Contributing factors were: the pilot's probable spatial disorientation, and the night/weather…NTSB MIA89LA175Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Miramar, FLInadequate planning/decision by the pilot, which resulted in loss of engine power due to fuel exhaustion. A contributing factor was the faulty reading from the fuel quantity indicator.NTSB MIA89LA062Accident · No injuriesLimited investigationFinal reportCessna 210L · Greenwood, MSFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve.