Fatal NTSB investigations: Cessna T210L

6 cases on aircraft the registry lists as Cessna T210L, where the first occurrence was “In flight collision with terrain/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.

Cases per year

19822026
Fatal NTSB investigations: Cessna T210L per year, 1982–2026: 6 cases
19821
19871
19891
19901
20012

Latest 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.\"highestInjuryLevel\" = 'Fatal'
    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')
      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\" = 230))
  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.

NTSB LAX02FA049Accident · 1 fatalField investigationFinal reportCessna T210L · San Jacinto, CAThe pilot's loss of situational awareness and his failure to adhere to the prescribed instrument approach procedures, including the track and altitudes flown. The underlying reasons for the pilot's loss of situational awareness are unknown.Dec 14, 2001 · N210RE · DestroyedNTSB 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…Mar 10, 2001 · N222ED · DestroyedNTSB SEA90FA122Accident · 5 fatalField investigationFinal reportCessna T210L · Ashford, WAThe pilot's continuation of VFR flight into instrument meteorological conditions.Jul 2, 1990 · N59291 · DestroyedNTSB SEA89FA057Accident · 1 fatalField investigationFinal reportCessna T210L · Longmire, WAPhysical incapacitation of the pilot.Mar 19, 1989 · N8822C · DestroyedNTSB 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…Jan 28, 1987 · N1721X · DestroyedNTSB LAX82FA262Accident · 1 fatalField investigationFinal reportCessna T-210L · Reno, NVThe pilot was descending in a mountainous area and did not clear the high terrain before collision with the ground occurred. The pilot was in radio communication with Reno tower and was given landing instructions. There was no verbal indication of trouble on…Jul 16, 1982 · N66GH · Destroyed