Skip to content

NTSB investigations: Cessna T210N, CO

21 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19702026

Where

Latest cases

Query with SQL

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 ('2073456')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('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 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 ('2073456'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN22LA204Accident · No injuriesClass 3 · LimitedFinal reportCessna T210N · Denver, COThe main landing gear collapsed during landing for reasons that could not be determined.May 17, 2022 · N210SD · Substantial damage NTSB CEN20LA365Accident · 1 fatalClass 3 · LimitedFinal reportCessna T210 · Peyton, COThe pilot’s failure to maintain adequate airspeed and the exceedance of the airplane’s critical angle of attack during the airplane’s turn to final, resulting in an aerodynamic stall.Aug 26, 2020 · N64EM · Destroyed NTSB CEN18LA142Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Colorado Springs, COThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.Apr 15, 2018 · N6988N · Substantial damage NTSB CEN18CA021Accident · No injuriesData collectionFinal reportCessna T210N · Eagle, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Oct 23, 2017 · N5129C · Substantial damage NTSB GAA17CA131Accident · Minor injuriesData collectionFinal reportCessna T210 · Loveland, COThe pilot's exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.Feb 5, 2017 · N4853U · Substantial damage NTSB GAA16CA337Accident · No injuriesData collectionFinal reportCessna T210 · Buena Vista, COThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and substantial damage to the firewall.Jun 9, 2016 · N9915Y · Substantial damage NTSB CEN12CA564Accident · Minor injuriesData collectionFinal reportCessna T210N · Boulder, COThe pilot’s decision to continue the unstable approach, which resulted in a loss of control during landing and a runway excursion.Aug 22, 2012 · N85S · Substantial damage 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.Jul 3, 2007 · N5129C · Substantial damage NTSB DEN04LA021Accident · No injuriesLimited investigationFinal reportCessna T210N · Johnstown, COThe pilot's failure to maintain directional control during the landing roll. Factors contributing to the accident were the gusting crosswinds.Nov 10, 2003 · N6961N · Substantial damage NTSB DEN02LA012Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Montrose, COthe loss of engine power during initial climb for undetermined reason. A factor was the lack of suitable terrain for a forced landing.Nov 16, 2001 · N210GB · Destroyed NTSB DEN99FA077Accident · No injuriesField investigationFinal reportCessna 172Q · Greeley, COFailure of both the pilot receiving instruction and the flight instructor to maintain a visual lookout. A factor was the failure of the other pilot to maintain a visual lookout.May 13, 1999 · N96299 · 2 aircraft · Minor damage NTSB FTW98FA344Accident · 4 fatalField investigationFinal reportCessna T210N · Creede, COThe pilot's failure to maintain flying airspeed and the subsequent stall/spin. A contributing factor was high density altitude.Aug 6, 1998 · N2WF · Destroyed NTSB DEN93LA030Accident · No injuriesLimited investigationFinal reportCessna T210N · Walsh, COA complete power loss from mechanical failure. A factor was: a pond, which the aircraft entered during landing roll.Mar 3, 1993 · N5367A · Substantial damage 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…Mar 31, 1992 · N212CS · Destroyed NTSB DEN91LA029Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Aspen, COFuel exhaustion induced power loss resultant from faulty fuel caps and fuel syphoning.Dec 29, 1990 · N1604U · Substantial damage NTSB DEN91FA002Accident · 1 fatalField investigationFinal reportCessna T210N · Gypsum, COThe pilot flying into known adverse icing and thunderstorm weather conditions which resulted in the loss of control of the aircraft.Oct 3, 1990 · N6477N · Destroyed NTSB DEN88LA117Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Ft. Collins, COJun 1, 1988 · N6638N · Substantial damage NTSB DEN87LA040Accident · No injuriesLimited investigationFinal reportCessna T210N · Pueblo, COPlt and two pax departed limon, CO, at 1000 for return trip to center, CO. At 1030 plt switched to the right fuel tank, ten min later eng lost power and plt made forced landing west of Pueblo, CO. Plt claimed right fuel gauge was faulty. Plt later said he…Jan 4, 1987 · N2WF · Substantial damage NTSB DEN81FA035Accident · 4 fatalClosedCessna T210N · Castle Rock, COMay 18, 1981 · N5137Y · Destroyed NTSB DEN80FA003Accident · 8 fatalClosedCessna T210N · Gunnison, COOct 14, 1979 · N7618N · Destroyed NTSB DEN70DXD10Accident · No injuriesClosedCessna 182 · Dove Creek, COMar 1, 1970 · N6470A · Substantial damage