Fatal NTSB investigations: Cessna T210L

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

Cases, newest first

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'))
  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 MKC79FA051Accident · 2 fatalClosedCessna 210L · Garden City, KSSep 5, 1979 · N59200 · DestroyedNTSB LAX79FUA15Accident · 1 fatalClosedCessna T210L · Newport Beach, CAJul 22, 1979 · N732AR · DestroyedNTSB OAK79FA024Accident · 6 fatalClosedCessna T210L · Dunsmuir, CAApr 16, 1979 · N2253S · DestroyedNTSB LAX79IA033Incident · 1 fatalClosedCessna T210L · Lancaster, CAMar 14, 1979 · N123DH · No damageNTSB LAX79FA026Accident · 1 fatalClosedCessna T210L · Long Beach, CAJan 23, 1979 · N4634Q · DestroyedNTSB OAK79FA008Accident · 1 fatalClosedCessna T-210L · Dayton, NVNov 1, 1978 · N777FT · DestroyedNTSB OAK79FA003Accident · 1 fatalClosedCessna T-210L · San Leandro, CAOct 20, 1978 · N5148Q · DestroyedNTSB DEN78FAO32Accident · 5 fatalClosedCessna T210L · Woodland Park, COMar 10, 1978 · N22443 · DestroyedNTSB LAX78FA029Accident · 6 fatalClosedCessna T2101 · Bakersfield, CAFeb 22, 1978 · N59313 · DestroyedNTSB OAK78FA013Accident · 1 fatalClosedCessna T210L · Bishop, CAJan 10, 1978 · N30053 · DestroyedNTSB LAX77FA064Accident · 1 fatalClosedCessna T210L · Carlsbad, CASep 22, 1977 · N732GL · DestroyedNTSB MKC77FA017Accident · 3 fatalClosedCessna T210L · Atkins, IAMar 19, 1977 · N2231S · DestroyedNTSB CHI76AC093Accident · 3 fatalClosedCessna T210L · Peoria, ILSep 26, 1976 · N732AB · DestroyedNTSB DEN7LAD018Accident · 2 fatalClosedCessna T210L · Trinidad, COSep 11, 1975 · N4617Q · DestroyedNTSB OAK75AP046Accident · 1 fatalClosedCessna T210L · San Lucas, CAApr 3, 1975 · N29052 · DestroyedNTSB FTW75ORG47Accident · 3 fatalClosedCessna T210L · Mal Paso, MexicoSep 19, 1974 · N90707 · DestroyedNTSB FTW74OQD20Accident · 2 fatalClosedCessna 210 · Arteaga, MexicoApr 26, 1974 · N59082 · DestroyedNTSB CHI73FCA03Accident · 1 fatalClosedRobertson T210L · Bethalto, ILMar 2, 1973 · N22458 · DestroyedNTSB CHI72FEE85Accident · 1 fatalClosedCessna T210L · Moline, ILJun 30, 1972 · N4691Q · Substantial damage