Fatal NTSB investigations: Cessna T210M, UT
4 cases on aircraft the registry lists as Cessna T210M. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1994 | 1 |
| 1997 | 1 |
Where
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.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
AND 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 ('2073451', '2073452'))
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" = 'UT' AND c."eventCountry" = 'USA'
AND 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 ('2073451', '2073452'))
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 SEA97FA097Accident · 4 fatalField investigationFinal reportCessna T210M · Bullfrog, UTThe pilot-in-command's failure to maintain adequate flying airspeed, for reason(s) unknown, resulting in a subsequent stall.NTSB FTW95FA003Accident · 2 fatalField investigationFinal reportCessna T210M · Richmond, UTThe loss of engine oil pressure due to an oil leak from a loose oil line fitting. Factors were the obscuration, and the unsuitable terrain at the pilot's disposal.NTSB DEN83FA087Accident · 3 fatalField investigationFinal reportCessna T210M · Salt Lake City, UTBefore departing phoenix, AZ, the plt obtained a wx briefing, was advised of forcasted icing conditions & was informed that the Salt Lake City (slc) VORTAC was out of service. While en route, at 0931, he received a wx update. The slc wx at that time was, in…NTSB DEN83FTM03Accident · 3 fatalFinal reportCessna T210M · Tremonton, UTThe acft was observed flying over the interstate highway approximately 100 ft AGL prior to colliding with two high voltage power transmission lines.