NTSB investigations: Cessna T210N, 2007
9 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\") = 2007
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") = 2007
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 MIA08FA027Accident · 2 fatalField investigationFinal reportCessna T210N · Bloomfield, KYthe pilot exceeded the design stress limits of the airplane, which resulted in the in-flight break up. Contributing to the accident was the pilot's loss of control in-flight due to spatial disorientation.NTSB LAX07CA261Accident · Minor injuriesData collectionFinal reportCessna T210N · San Jose, CAThe pilot's mismanagement of the fuel supply that resulted in fuel starvation.NTSB NYC07LA197Accident · No injuriesLimited investigationFinal reportCessna T210N · Old Bridge, NJThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation during approach.NTSB DEN07CA116Accident · No injuriesData collectionFinal reportCessna T210N · Loveland, COThe pilot's failure to lower the landing gear. Contributing factors were the pilot's attention being diverted, and his failure to use the BEFORE LANDING checklist.NTSB SEA07CA146Accident · No injuriesData collectionFinal reportCessna T210N · Bakersfield, CAThe pilot's improper flare, which resulted in a loss of directional control. Factors included the crosswind and gusty wind condition.NTSB CHI07CA100Accident · No injuriesData collectionFinal reportCessna 210N · Charlotte, MIThe pilot's inadequate compensation for the wind conditions, inadequate landing flare, failure to maintain directional control, and encounter with a pilot-induced oscillation (porpoise. A contributing factor was the wind gust.NTSB LAX07LA136Accident · No injuriesLimited investigationFinal reportCessna T210N · Oakland, CACollapse of the landing gear for undetermined reasons.NTSB SEA07LA081Accident · No injuriesLimited investigationFinal reportCessna T210N · Livermore, CAThe pilot's failure to maintain clearance from another aircraft holding on the taxiway while taxiing from landing. The pilot's inadequate visual lookout was a factor.NTSB LAX07CA110Accident · No injuriesData collectionFinal reportCessna T210N · Barstow, CAThe pilot's failure to properly execute the manual landing gear extension procedures.