NTSB investigations: Cessna T210N, 1992
7 cases on aircraft the registry lists as Cessna T210N. 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
| 1968 | 1 |
|---|---|
| 1970 | 2 |
| 1971 | 1 |
| 1979 | 6 |
| 1980 | 10 |
| 1981 | 14 |
| 1982 | 11 |
| 1983 | 11 |
| 1984 | 14 |
| 1985 | 12 |
| 1986 | 16 |
| 1987 | 15 |
| 1988 | 12 |
| 1989 | 10 |
| 1990 | 6 |
| 1991 | 5 |
| 1992 | 7 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 8 |
| 1996 | 9 |
| 1997 | 7 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 7 |
| 2001 | 5 |
| 2002 | 6 |
| 2003 | 7 |
| 2004 | 3 |
| 2005 | 6 |
| 2006 | 11 |
| 2007 | 9 |
| 2008 | 2 |
| 2009 | 4 |
| 2010 | 6 |
| 2011 | 1 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 5 |
| 2018 | 5 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 2 |
| 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\") = 1992
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073456'))
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") = 1992
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073456'))
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 NYC93LA041Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Londonderry, NHThe pilot's inadequate inflight decision which resulted in fuel exhaustion and the loss of engine power. Contributing was the pilot's inadequate preflight planning and preparation.NTSB SEA93LA022Accident · No injuriesLimited investigationFinal reportCessna 210N · Spokane, WAThe pilot's premature retraction of the gear. Factors include a wet and icy runway.NTSB FTW92LA206Accident · Serious injuriesLimited investigationFinal reportCessna T-210N · Palestine, TXThe pilot's disregard of the checklist and the resulting inadvertent stall mush during takeoff.NTSB LAX92FA289Accident · 1 fatalField investigationFinal reportCessna T210N · Superior, AZAn inadequate major engine overhaul procedure, during which previous crankshaft damage was not detected. Contributing to the accident was a surface initiated fatigue failure of the engine crankshaft.NTSB LAX92LA258Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Georgetown, CAThe under torque of the crankcase through bolts during overhaul causing; 1) the number 2 main bearing to spin, 2) the resultant blockage of the internal oil passage, and 3) the oil starvation induced failure of the number 2 connecting rod and cap. A factor in…NTSB DEN92FA045Accident · 1 fatalField investigationFinal reportCessna T210N · Larkspur, COThe pilot's failure to flare the airplane due to his reduced forward visibility. Factors were: the pilot's improper fuel consumption calculations, his failure to proceed to an alternate airport, fuel exhaustion, and weather conditions including snow, fog, and…NTSB LAX92GA128Accident · 2 fatalFinal reportCessna T210N · Lake Hughes, CAPoor maintenance repair and annual inspection by the company's maintenance personnel and the pilot-in-command's misjudging altitude. Contributing to this accident was the pilot-in-command intentional stall, improper emergency procedure, selection of…