NTSB investigations: Cessna T210L, CO
15 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
| 1973 | 1 |
|---|---|
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 2 |
| 1987 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2021 | 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 c.\"eventStateOrRegion\" = 'CO' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA'
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 CEN21LA271Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T210L · Buena Vista, COThe partial loss of engine power due to a vane failure in the engine-driven fuel pump.NTSB DEN05CA147Accident · No injuriesData collectionFinal reportCessna T210L · Las Animas, COthe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's inadequate preflight planning and lack of suitable terrain for the forced landing.NTSB DEN01FA066Accident · 1 fatalField investigationFinal reportCessna T210L · Howard, COthe pilot's continuation of a VFR flight into instrument meteorological conditions, and his subsequent failure to maintain terrain clearance. Contributing factors were his failure to obtain a preflight weather briefing, and his failure to obtain any in-flight…NTSB FTW97LA142Accident · No injuriesLimited investigationFinal reportCessna T210L · Durango, COthe pilot's improper planning/decision, and failure to ensure there was sufficient fuel aboard for the flight, which resulted in fuel exhaustion and loss of engine power. A factor relating to the accident was: the lack of suitable terrain for a successful…NTSB DEN93LA022Accident · No injuriesLimited investigationFinal reportCessna T210L · Monte Vista, COA loss of control during landing when the aircraft struck a snowbank which was left on the runway as a result of inadequate plowing.NTSB DEN91FA017Accident · 4 fatalField investigationFinal reportCessna T210L · Aspen, COImproper planning/decision by the pilot and his failure to maintain adequate airspeed, while turning over high terrain beside the airport, which resulted in an inadvertent stall. Factors related to the accident were: excessive gross weight of the aircraft,…NTSB DEN87FA061Accident · 4 fatalField investigationFinal reportCessna T210L · Nucla, COThe acft was on an IFR flt to an arpt without an instrument approach procedure. ATC cleared the flt to descend to 12,000 ft, the IFR mea for the area, at 30 NM NE of the arpt. At approx 3 min prior to the mishap, the plt was issued a cruise clearance at…NTSB DEN81FTE39Accident · No injuriesClosedCessna T210 · Pagosa Sprngs, CONTSB DEN81FTE25Accident · No injuriesClosedCessna 337 · Aurora, CONTSB DEN80FA040Accident · 3 fatalClosedCessna T210L · Hayden, CONTSB DEN79FTE48Accident · Minor injuriesClosedCessna T210 · Brighton, CONTSB DEN78FAO32Accident · 5 fatalClosedCessna T210L · Woodland Park, CONTSB DEN77FA018Accident · No injuriesClosedCessna T210L · Jaroso, CONTSB DEN7LAD018Accident · 2 fatalClosedCessna T210L · Trinidad, CONTSB DEN74FTE15Accident · Minor injuriesClosedCessna T210 · Windsor, CO