Skip to content

NTSB investigations: Cessna T210L, NM

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19772026

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" = 'NM' 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

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\" = 'NM' 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" = 'NM' 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

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 WPR25LA071Accident · No injuriesClass 3 · LimitedFinal reportCessna T210L · Gallup, NMThe pilot’s improper fuel management, which resulted in a total loss of engine power.Dec 28, 2024 · N505SW · Substantial damage 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.Oct 14, 2009 · N211LC · Substantial damage 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.Jul 1, 2009 · N2118S · Substantial damage 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.Mar 23, 2009 · N59287 · Substantial damage NTSB CEN09CA125Accident · No injuriesData collectionFinal reportCessna T210L · Albuquerque, NMThe pilot's failure to remove the airplane's tow bar before takeoff.Jan 10, 2009 · N211LC · Substantial damage NTSB CEN09CA101Accident · No injuriesData collectionFinal reportCessna T210L · Santa Fe, NMThe pilot's decision to land in gusty crosswinds, leading to his inability to maintain directional control. Contributing to the accident were the crosswinds.Dec 24, 2008 · N732DK · Substantial damage NTSB DEN00FA025Accident · 1 fatalField investigationFinal reportCessna T210L · Elida, NMThe pilot's failure to maintain aircraft control for reasons undetermined. Factors were icing conditions and instrument failure, as reported by the pilot.Dec 9, 1999 · N2179S · Destroyed NTSB DEN99LA070Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Albuquerque, NMThe pilot's improper mixture control use and the engine's subsequent power loss due to fuel starvation, and the lack of suitable terrain for the pilot to perform a forced landing. Factors were the pilot's lack of recent experience in type of airplane, the…Apr 30, 1999 · N59235 · Destroyed NTSB FTW98LA173Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Santa Teresa, NMfailure of the number 1 piston, which resulted in loss of engine power and a subsequent forced landing. The lack of suitable terrain for a forced landing was a related factor.Apr 5, 1998 · N591DC · Substantial damage NTSB FTW96LA328Accident · No injuriesLimited investigationFinal reportCessna T210L · Santa Fe, NMthe pilot's improper decision to continue the flight after noting the low fuel quantity indication, which resulted in fuel starvation before reaching the airport. A factor was the lack of suitable terrain for the forced landing.Jul 20, 1996 · N210RE · Substantial damage NTSB FTW95LA174Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Estancia, NMThe loss of engine power due to exhaust valve separation resulting from inadequate maintenance. A factor was the dark night and the lack of suitable terrain for the forced landing.Apr 19, 1995 · N1664X · Substantial damage NTSB DEN91FA020Accident · Serious injuriesField investigationFinal reportCessna T210L · Clovis, NMAn inadvertent descent into the ground while conducting a non-precision instrument approach, as a result of the pilot failing to stop his descent at mda. A factor is low visibility due to fog.Nov 20, 1990 · N22054 · Destroyed NTSB DEN90LA173Accident · No injuriesLimited investigationFinal reportCessna T-210-L · Edgewood, NMEngine failure due to a broken connecting rod. A factor was the rough uneven terrain available for the forced landing.Aug 23, 1990 · N5397V · Substantial damage NTSB DEN90FA013Accident · 2 fatalField investigationFinal reportCessna T210L · Penasco, NMImproper inflight planning/decision by the pilot, and his failure to maintain sufficient altitude over mountainous terrain. Factors related to the accident were: failure of the pilot to obtain (and/or understand) wind aloft information, his lack of…Oct 25, 1989 · N93110 · Destroyed NTSB DEN85LA239Accident · No injuriesLimited investigationFinal reportCessna T210L · Gallup, NMThe student plt was returning from a solo x-country flt. Prior to landing, he called the fss & was advised that the wind was from 190 deg & was gusty. As he landed on rwy 6, the acft veered to the left, went off the rwy, hit a rwy light & was damaged.Sep 11, 1985 · N399KM · Substantial damage NTSB DEN80DQA20Accident · No injuriesClosedCessna 210L · Farmington, NMMar 2, 1980 · N2235S · Substantial damage NTSB DEN80FQA14Accident · No injuriesClosedCessna 210L · Corona, NMJan 16, 1980 · N5159V · Substantial damage NTSB DEN80FQA08Accident · Minor injuriesClosedCessna T210L · Farmington, NMNov 5, 1979 · N59156 · Destroyed NTSB DEN78FQA09Accident · Minor injuriesClosedCessna T210L · Moriarty, NMDec 23, 1977 · N5114Q · Substantial damage