NTSB investigations: Cessna T210L

8 cases on aircraft the registry lists as Cessna T210L, where the first occurrence was “Loss of control - on ground/water”. 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

19832026

NTSB investigations: Cessna T210L per year, 1983–2026: 8 cases
1983	1
1985	1
1986	1
1994	2
1996	1
2000	1
2004	1

Where

Open the map

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073449') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073449')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073449')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 FTW04LA195Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Columbus, TXthe pilot's failure to maintain directional control during the takeoff roll and abort the attempted takeoff.Jul 22, 2004 · N5118Q · Substantial damage NTSB LAX00LA183Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Grand Canyon, AZThe pilot's inadequate compensation for a crosswind and his failure to maintain directional control during landing, resulting in the airplane veering off the runway and the subsequent collision with a culvert.May 7, 2000 · N1726X · Substantial damage NTSB LAX97LA043Accident · No injuriesLimited investigationFinal reportCessna T210L · Mesa, AZthe pilot's failure to maintain directional control of the aircraft during the landing roll, which resulted in an inadvertent ground swerve.Nov 16, 1996 · N911JB · Substantial damage NTSB CHI95LA025Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Beulah, NDthe failure of the pilot to maintain directional control.Oct 26, 1994 · N526HK · Substantial damage NTSB LAX94LA369Accident · No injuriesLimited investigationFinal reportCessna T210L · Kettleman City, CAThe pilot's selection of the wrong runway for takeoff and his failure to maintain runway alignment. The sun glare was a factor in this accident.Sep 3, 1994 · N732DT · Substantial damage NTSB SEA86LA190Accident · No injuriesLimited investigationFinal reportCessna T210L · Elko, NVDuring landing rollout on runway 23 the aircraft deviated to the right and the pilot corrected first with rudder and then left brake. The aircraft then veered left and departed the runway. The pilot then attempted to initiate a go around and fly out of the…Aug 2, 1986 · N5118Q · Substantial damage 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 CHI83LA132Accident · No injuriesLimited investigationFinal reportCessna 210 · Huntley, ILThe pilot stated he was aware of the cross wind so he used only 10 degrees of flaps. The acft began to drift while landing on runway 31. The pilot said he was holding 80 KTS on approach and as he started to flare the acft touched down hard on the rt main gear…Mar 10, 1983 · N2558S · Substantial damage