Skip to content

Fatal NTSB investigations: Cessna T210F

17 cases on aircraft the registry lists as Cessna T210F. 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

19662026

Where

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."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 ('2073422')) 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.\"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 ('2073422'))
  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 ('2073422'))
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 ATL01FA109Accident · 1 fatalField investigationFinal reportCessna T-210F · Hendersonville, NCThe pilot's failure to follow the air traffic controllers verbal instructions pertaining to heading and minimum safe vectoring altitude while being vectored for an ILS approach to his destination airport. This resulted in an in-flight collision with trees and…Sep 15, 2001 · N6740R · Destroyed NTSB LAX91FA044Accident · 1 fatalField investigationFinal reportCessna T210-F · Fontana, CAThe pilot-in-command's decision to continue flight into known adverse weather conditions during the hours of darkness in mountainous terrain.Nov 26, 1990 · N6775R · Destroyed NTSB DEN89FA036Accident · 5 fatalField investigationFinal reportCessna T210F · Cortez, COThe plt obtained a wx briefing from las vegas fss and was told that flt under VFR was not recommended for the proposed flt to durango (dro). The plt filed a VFR flt plan and departed las vegas. Over page, AZ, he filed a PIREP and was again told VFR flt not…Nov 24, 1988 · N6105R · Destroyed NTSB MKC89FA007Accident · 2 fatalField investigationFinal reportCessna T210F · Rogers, ARContinued flight by the pilot into instrument meteorological conditions (IMC) and his failure to maintain aircraft control after becoming disoriented. Contributing factors were: dark night, low ceilings, fog, drizzle, obscuration, and failure of the pilot to…Oct 21, 1988 · N6191R · Destroyed NTSB MIA87FA069Accident · 1 fatalField investigationFinal reportCessna T210F · Tallahassee, FLPlt/owner was informed by mechanics that the acft fuel tanks had water contamination on two occurrences prior to test flights. The plt reported he ahd had water contamination and believed the fuel caps were leaking. New caps were ordered to be installed at…Jan 7, 1987 · N6184R · Destroyed NTSB MIA87FA035Accident · 1 fatalField investigationFinal reportCessna T210F · West Palm Bch, FLThe eng was reported to be sputtering during the takeoff roll. The plt continued the takeoff and after liftoff declared an emergency. As the acft turned to a downwind position at a low alt with the eng still sputtering it struck a tree and a building at which…Nov 22, 1986 · N6194R · Destroyed NTSB FTW81FA140Accident · 1 fatalClosedCessna T210R · Lake Jackson, TXSep 4, 1981 · N6153R · Destroyed NTSB DEN74AD044Accident · 1 fatalClosedCessna T210F · Rocky Ford, COMar 14, 1974 · N6150R · Destroyed NTSB NYC73AN111Accident · 2 fatalClosedCessna 210 · Missing AircraftJan 28, 1973 · N6710R · Destroyed NTSB OAK72AP035Accident · 1 fatalClosedCessna 210K · Sacramento, CAMar 22, 1972 · N6725R · Destroyed NTSB MIA72AM094Accident · 1 fatalClosedCessna T210F · Jasper, GAMar 21, 1972 · N6117R · Destroyed NTSB DEN72AD034Accident · 1 fatalClosedCessna T210F · Lehi, UTFeb 1, 1972 · N6762R · Destroyed NTSB DEN72AD033Accident · 1 fatalClosedCessna T210F · Wagon Mound, NMJan 26, 1972 · N6152R · Destroyed NTSB DEN69A0010Accident · 1 fatalClosedCessna T-210F · Mesa, COAug 28, 1968 · N6196R · Destroyed NTSB SEA68A0053Accident · 2 fatalClosedCessna T-210F · Lamont, WAFeb 19, 1968 · N6792R · Destroyed NTSB SEA67A0062Accident · 4 fatalClosedCessna T210F · Lapine, ORMay 9, 1967 · N6164R · Destroyed NTSB DEN67A0001Accident · 2 fatalClosedCessna T210F · Cisco, UTJul 6, 1966 · N6790R · Destroyed