Skip to content

NTSB investigations: Cessna 210A, TX

23 cases on aircraft the registry lists as Cessna 210A. 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

19642026

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."eventStateOrRegion" = 'TX' 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 ('2073408')) 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.\"eventStateOrRegion\" = 'TX' 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 ('2073408'))
  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" = 'TX' 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 ('2073408'))
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 CEN12CA006Accident · No injuriesData collectionFinal reportCessna 210A · Wolfe City, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.Oct 6, 2011 · N9448X · Substantial damage NTSB CEN10LA085Accident · No injuriesLimited investigationFinal reportCessna 210A · Robert Lee, TXThe collapse of the right main landing gear during landing for unknown reasons.Dec 25, 2009 · N9499X · Substantial damage NTSB DFW06CA176Accident · No injuriesData collectionFinal reportCessna 210A · Denver City, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Jul 7, 2006 · N9419X · Substantial damage NTSB FTW02LA208Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Sherman, TXfuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.Jul 16, 2002 · N9466X · Substantial damage NTSB FTW99LA242Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Grapevine, TXThe pilot's failure to maintain directional control of the aircraft during landing.Aug 27, 1999 · N6657X · Substantial damage NTSB FTW99LA130Accident · No injuriesLimited investigationFinal reportCessna 210A · Bay City, TXThe pilot's inadequate management of fuel and his failure to follow the pre-landing checklist resulting in the loss of engine power as a result of fuel starvation. Factors were the pilot's physiological condition and the lack of suitable terrain for the…Apr 30, 1999 · N9404X · Substantial damage NTSB FTW98LA226Accident · No injuriesLimited investigationFinal reportCessna 210A · Weatherford, TXThe restricted movement of the elevator control system by a bolt.Apr 29, 1998 · N9466X · Substantial damage NTSB FTW80FQD10Accident · No injuriesClosedCessna 210A · El Paso, TXJun 14, 1980 · N6639X · Substantial damage NTSB FTW76FRA18Accident · Minor injuriesClosedCessna 210A · La Grange, TXDec 4, 1975 · N9508X · Substantial damage NTSB FTW75FPD27Accident · No injuriesClosedCessna 210A · Hamilton, TXFeb 24, 1975 · N9497X · Substantial damage NTSB FTW71FPA19Accident · No injuriesClosedCessna 210A · Addison, TXDec 16, 1970 · N9524X · Substantial damage NTSB FTW71FRG58Incident · No injuriesClosedCessna 210A · Mcallen, TXDec 7, 1970 · N6578X · Minor damage NTSB FTW70D0182Accident · Minor injuriesClosedCessna 210 · Mullins, TXAug 31, 1969 · N6655X · Substantial damage NTSB FTW69D0347Accident · No injuriesClosedCessna 210A · Crowley, TXDec 27, 1968 · N9408X · Substantial damage NTSB FTW67F0427Accident · No injuriesClosedCessna 210A · Keller, TXJan 31, 1967 · N9457X · Substantial damage NTSB FTW66D0694Accident · No injuriesClosedCessna 210 · Borger, TXMay 14, 1966 · N6641X · Substantial damage NTSB FTW66A0045Accident · 2 fatalClosedCessna 210 · Ft Stockton, TXNov 8, 1965 · N6671X · Destroyed NTSB FTW66A0016Accident · 1 fatalClosedPiper PA-24 · Amarillo, TXAug 12, 1965 · N2507P · 2 aircraft · Destroyed NTSB FTW66F0257Accident · No injuriesClosedCessna 210 · Ft Worth, TXMar 26, 1965 · N6636X · Substantial damage NTSB UNK65X0854Accident · No injuriesClosedCessna 210A · El Paso, TXNov 27, 1964 · N951E · Substantial damage NTSB UNK64X1078Accident · No injuriesClosedCessna 210 · Brady, TXMar 28, 1964 · N9469X · Substantial damage NTSB UNK64X1058Accident · No injuriesClosedCessna 210 · Midland, TXMar 27, 1964 · N6677X · Substantial damage NTSB UNK64X1041Accident · No injuriesClosedCessna 210 · Coleman, TXMar 26, 1964 · N6671X · Substantial damage