NTSB investigations: Cessna T210M, 1990
9 cases on aircraft the registry lists as Cessna T210M. 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
| 1966 | 1 |
|---|---|
| 1977 | 3 |
| 1978 | 13 |
| 1979 | 15 |
| 1980 | 13 |
| 1981 | 9 |
| 1982 | 13 |
| 1983 | 10 |
| 1984 | 7 |
| 1985 | 10 |
| 1986 | 9 |
| 1987 | 4 |
| 1988 | 8 |
| 1989 | 4 |
| 1990 | 9 |
| 1991 | 8 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 10 |
| 1995 | 4 |
| 1996 | 6 |
| 1997 | 4 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 10 |
| 2002 | 5 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 5 |
| 2006 | 6 |
| 2007 | 5 |
| 2008 | 7 |
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 4 |
| 2013 | 2 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 3 |
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\") = 1990
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073451', '2073452'))
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") = 1990
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073451', '2073452'))
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 CHI91LA036Accident · No injuriesLimited investigationFinal reportCessna T210M · Marshall, MIDirectional control not maintained by the PIC.NTSB DEN91FA012Accident · 2 fatalField investigationFinal reportCessna T210M · Carbondale, COFailure of the pilot to see-and-avoid the power line.NTSB DEN91LA006Accident · No injuriesLimited investigationFinal reportCessna T210M · Englewood, COEngine failiure resulting from maintenance discrepancies.NTSB LAX90FA300Accident · 4 fatalField investigationFinal reportCessna T-210-M · Placerville, CAThe pilot's misidentification of the airport and his failure to select an adequate altitude above the terrain. Factors in the accident were the pilot's disregard for his night time medical limitation and lack of geographic familiarity with the area.NTSB LAX90LA290Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Soda Springs, CAEngine failure due to inadequate vapor recovery system (inadequate aircraft maintenance/service) and incorrect fuel grade. A factor in the accident was unsuitable terrain.NTSB ANC90LA132Accident · No injuriesLimited investigationFinal reportCessna C-T210 · Sleeper Bay, AKImproper fuel tank selection.NTSB FTW90LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Wharton, TXThe loss of power due to an out-of-rig condition in the automatic auxiliary boost pump mechanism.NTSB MKC90FA142Accident · Serious injuriesField investigationFinal reportCessna T210M · Kiowa, KSThe pilot's failure to maintain control of the airplane during takeoff.NTSB ATL90LA097Accident · No injuriesLimited investigationFinal reportCessna T210 · Lafayette, GAThe pilot's failure to properly manage his fuel supply, which resulted in a loss of engine power, due to fuel starvation.