NTSB investigations: Cessna T210N, UT
5 cases on aircraft the registry lists as Cessna T210N. 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 |
|---|---|
| 1984 | 1 |
| 1988 | 1 |
| 2004 | 1 |
| 2019 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073456'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073456'))
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 WPR19LA195Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Hurricane, UTMaintenance personnel's improper installation of a throttle cable to the throttle body arm, which resulted in a throttle detachment during takeoff and subsequent loss of power. Contributing to the accident was the inadequate inspection of the throttle…NTSB DEN04LA098Accident · No injuriesLimited investigationFinal reportCessna T210N · Spanish Fork, UTthe improper reassembly of the engine following major overhaul (application of Permatex over entire crankcase surfaces). Contributing factors included the number 2 main bearing and crankshaft shifting forward, causing the alternator drive shaft and other…NTSB DEN89LA008Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Price, UTThe pilot was performing a business flight over mountainous terrain. About 1 hr into the flight, he noticed smoke or oil vapor in the cockpit. He saw oil on the lower cowling and wing and communicated his position and problem to the salt lake city ARTCC. The…NTSB DEN84LA092Accident · No injuriesLimited investigationFinal reportCessna T-210 · Duchesne, UTThe acft departed the side of the rwy during the landing roll. The plt stated that he could no determine where the center of the rwy was due to about 2 inches of fresh snow. The rt landing gear collapsed & the nose gear failed.NTSB DEN82FA018Accident · 3 fatalField investigationFinal reportCessna T210N · 28 Mi Ene Ogden, UTDuring an IFR flt at 12,000 ft the plt contacted ATC & requested a higher altitude to get out of IMC. He was cleared to climb & maintain 14,000 ft. the plt acknowledged the clearance at 1855 & was not heard from again. Radar contact was lost at 1859.…