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.
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" DESCRun 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 MKC79FA051Accident · 2 fatalClosedCessna 210L · Garden City, KSNTSB LAX79FUA15Accident · 1 fatalClosedCessna T210L · Newport Beach, CANTSB OAK79FA024Accident · 6 fatalClosedCessna T210L · Dunsmuir, CANTSB LAX79IA033Incident · 1 fatalClosedCessna T210L · Lancaster, CANTSB LAX79FA026Accident · 1 fatalClosedCessna T210L · Long Beach, CANTSB OAK79FA008Accident · 1 fatalClosedCessna T-210L · Dayton, NVNTSB OAK79FA003Accident · 1 fatalClosedCessna T-210L · San Leandro, CANTSB DEN78FAO32Accident · 5 fatalClosedCessna T210L · Woodland Park, CONTSB LAX78FA029Accident · 6 fatalClosedCessna T2101 · Bakersfield, CANTSB OAK78FA013Accident · 1 fatalClosedCessna T210L · Bishop, CANTSB LAX77FA064Accident · 1 fatalClosedCessna T210L · Carlsbad, CANTSB MKC77FA017Accident · 3 fatalClosedCessna T210L · Atkins, IANTSB CHI76AC093Accident · 3 fatalClosedCessna T210L · Peoria, ILNTSB DEN7LAD018Accident · 2 fatalClosedCessna T210L · Trinidad, CONTSB OAK75AP046Accident · 1 fatalClosedCessna T210L · San Lucas, CANTSB FTW75ORG47Accident · 3 fatalClosedCessna T210L · Mal Paso, MexicoNTSB FTW74OQD20Accident · 2 fatalClosedCessna 210 · Arteaga, MexicoNTSB CHI73FCA03Accident · 1 fatalClosedRobertson T210L · Bethalto, ILNTSB CHI72FEE85Accident · 1 fatalClosedCessna T210L · Moline, IL