NTSB investigations: Cessna T210L, IL

11 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

19722026

NTSB investigations: Cessna T210L, IL per year, 1972–2026: 11 cases
1972	1
1973	2
1976	1
1979	1
1982	1
1983	1
1984	1
1985	2
2011	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."eventStateOrRegion" = 'IL' 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\" = 'IL' 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" = 'IL' 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 CEN11FA425Accident · 1 fatalField investigationFinal reportCessna T210L · Romeoville, ILA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.Jun 26, 2011 · N732BX · Substantial damage NTSB CHI85IA145Incident · 1 fatalIncident investigationFinal reportCessna T210L · Peoria, ILWhile in cruise flight the commercial rated pilot suffered a fatal heart attack. The non-rated passenger landed the aircraft safely.Mar 21, 1985 · N11KW · No damage NTSB CHI85LA141Accident · No injuriesLimited investigationFinal reportCessna T210L · Sauk Village, ILDuring a night preflight the fuel quantity was visually checked and the plt estimated each tank contained 35 gals. The left fuel guage indicated 220 pounds and the right guage was inop. After aprx 1 hour 50 minutes of flt time a total loss of power occurred.…Mar 18, 1985 · N94032 · Substantial damage NTSB CHI85IA042Incident · No injuriesIncident investigationFinal reportCessna T210L · Wheeling, ILDuring a preflt, just prior to takeoff, the plt checked the flt controls & full travel of the controls was achieved. He initiated the takeoff, but when he applied back pressure on the elevator control, it would only move about 1 inch. He aborted the takeoff…Nov 3, 1984 · N21YF · Minor 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 NTSB CHI83FA007Accident · Serious injuriesField investigationFinal reportCessna T210L · Lansing, ILThe pilot cut short a cross-country flight because of weather, and during a down-wind landing, the aircraft overran runway 36. The aircraft was landed fast about 1600 ft down the 2500 foot runway, went off the end and ran into a deep ditch. The wind was from…Oct 5, 1982 · N2546S · Substantial damage NTSB CHI80FA009Accident · Minor injuriesClosedCessna T210L · Galesburg, ILNov 23, 1979 · N22434 · Substantial damage NTSB CHI76AC093Accident · 3 fatalClosedCessna T210L · Peoria, ILSep 26, 1976 · N732AB · Destroyed NTSB CHI74FCA01Accident · Minor injuriesClosedCessna T210L · Cahokia, ILSep 13, 1973 · N30607 · Substantial damage NTSB CHI73FCA03Accident · 1 fatalClosedRobertson T210L · Bethalto, ILMar 2, 1973 · N22458 · Destroyed NTSB CHI72FEE85Accident · 1 fatalClosedCessna T210L · Moline, ILJun 30, 1972 · N4691Q · Substantial damage