NTSB investigations: Cessna T210L, 2009
6 cases on aircraft the registry lists as Cessna T210L. 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 | 4 |
|---|---|
| 1973 | 6 |
| 1974 | 9 |
| 1975 | 14 |
| 1976 | 16 |
| 1977 | 18 |
| 1978 | 15 |
| 1979 | 18 |
| 1980 | 10 |
| 1981 | 8 |
| 1982 | 8 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 11 |
| 1986 | 5 |
| 1987 | 9 |
| 1988 | 5 |
| 1989 | 7 |
| 1990 | 8 |
| 1991 | 4 |
| 1992 | 10 |
| 1993 | 4 |
| 1994 | 8 |
| 1995 | 6 |
| 1996 | 6 |
| 1997 | 5 |
| 1998 | 4 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 5 |
| 2002 | 3 |
| 2003 | 6 |
| 2004 | 5 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 3 |
| 2008 | 2 |
| 2009 | 6 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 4 |
| 2024 | 3 |
| 2026 | 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\") = 2009
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073449'))
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") = 2009
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073449'))
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 CEN10LA014Accident · No injuriesLimited investigationFinal reportCessna T210L · Albuquerque, NMThe mechanic's failure to find and repair a leaking main landing gear hydraulic line during an annual inspection.NTSB CEN09LA417Accident · No injuriesLimited investigationFinal reportCessna T210L · Santa Teresa, NMThe failure of the landing gear accumulator seal for undetermined reasons. Contributing to the accident was the pilot’s failure to confirm the status of the landing gear.NTSB WPR09FA212Accident · No injuriesField investigationFinal reportCessna T210L · Moab, UTThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's self-induced distraction by maneuvering on final to show a point of interest to passengers.NTSB WPR09LA170Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Madera, CAA total loss of engine power during the initial climb due to fuel exhaustion as a result of the pilot's failure to properly monitor the airplane's fuel quantity and to correctly ascertain the fuel on board the airplane prior to takeoff.NTSB CEN09CA235Accident · No injuriesData collectionFinal reportCessna 210 · Angel Fire, NMThe pilot's failure to maintain directional control during takeoff. Contributing to the accident was the pilot's decision to take off on an icy runway with high crosswinds.NTSB CEN09CA125Accident · No injuriesData collectionFinal reportCessna T210L · Albuquerque, NMThe pilot's failure to remove the airplane's tow bar before takeoff.