NTSB investigations: Cessna T210L

7 cases on aircraft the registry lists as Cessna T210L, where the first occurrence was “In flight encounter with weather”. 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

19822026

NTSB investigations: Cessna T210L per year, 1982–2026: 7 cases
1982	2
1985	1
1987	1
1997	1
1998	1
2005	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" = 240)) 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\" = 240))
  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" = 240))
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 LAX05FA132Accident · 3 fatalField investigationFinal reportCessna T210L · Tranquility, CAthe pilot's in-flight loss of control due to spatial disorientation and a likely accumulation of airframe ice that led to a high speed descent and a structural breakup once the aerodynamic forces exceeded the strength limits of the structure. A factor in the…Apr 7, 2005 · N8126L · Destroyed NTSB CHI98FA099Accident · 1 fatalField investigationFinal reportCessna T210L · Orleans, INThe pilot's attempted VFR flight into instrument meteorological conditions and his subsequent failure to maintain clearance with trees. Contributing factors were the pilot's impairment from prescription drugs, low ceilings, fog, trees, and hilly terrain.Mar 5, 1998 · N2546S · Destroyed NTSB SEA97FA075Accident · 4 fatalField investigationFinal reportCessna T210L · Dillon, MTflight by the pilot into adverse weather conditions, and his failure to maintaint altitude/clearance from terrain. The adverse weather condition was a related factor.Mar 23, 1997 · N22219 · Destroyed NTSB LAX87FA267Accident · 4 fatalField investigationFinal reportCessna T210L · Marina Del Rey, CAWeather at dept airport was clouds at about 900 ft with tops at 2,400 ft. based on ATC transcripts and the recorded radar flight path, the flt entered the clouds about 1 mile from the end of the runway. Shortly thereafter the flt entered the los angeles tca.…Jul 15, 1987 · N7JT · Destroyed NTSB DEN86FA056Accident · 6 fatalField investigationFinal reportCessna T210L · West Valley, UTDuring apch to rwy 34L, the rt horizontal stab, elevators and wings separated in-flt. Investigation revealed the plt was not instr current. Ntap data revealed N2082S at an alt of 7,400 ft and 203 KTS grnd speed at outer marker. The mca at the marker is 6,100…Dec 29, 1985 · N2082S · Destroyed NTSB LAX83FA041Accident · 2 fatalField investigationFinal reportCessna T210L · 13 Se Of Linden, CAPilot encountered weather on a cross-country flight and reported icing at 10,000 feet at 1828. He had been at 10000 feetsince 1745. At 1831, the pilot requested 8,000 feet to get out of ice and at 1836 requested 6,000 and was approved. At 1857 level at 6,000…Nov 29, 1982 · N732BQ · Destroyed NTSB LAX82FA088Accident · 6 fatalField investigationFinal reportCessna T21OL · Verdi, NVPrior to the acft's departure from truckee-tahoe arpt, an inbound plt recommended via radio that the flt not go because he had just flown thru the donner pass & the wx was terrible. He reported the wind 25-35K, gusting 40-45K. The flt received a wx briefing…Mar 1, 1982 · N93338 · Destroyed