Skip to content

NTSB investigations: Cessna 210, TX

29 cases on aircraft the registry lists as Cessna 210. 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 ('2073402')) 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 ('2073402'))
  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 ('2073402'))
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 CEN23LA124Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Waco, TXThe nose landing gear retract arm separation for reasons that could not be determined.Nov 27, 2022 · N9468T · Substantial damage NTSB CEN21LA030Accident · 1 fatalClass 3 · LimitedFinal reportCessna 210 · Lubbock, TXThe pilot’s improper decision to fly into icing conditions with an airplane that was not equipped for icing, which led to structural icing and a subsequent loss of airplane control, and the pilot’s impairment from carbon monoxide poisoning due to a cracked…Oct 26, 2020 · N9622T · Destroyed NTSB CEN15CA067Accident · No injuriesData collectionFinal reportCessna 210 · Edinburg, TXThe loss of engine power due to fuel exhaustion, which resulted from the non-certificated pilot's inadequate preflight planning and inflight decision making.Dec 2, 2014 · N9452T · Substantial damage NTSB DFW07CA031Accident · No injuriesData collectionFinal reportCessna 210 · Baytown, TXThe failure of the main landing gear to fully extend for an undetermined reason during takeoff-initial climb, which resulted in a gear-up landing.Nov 22, 2006 · N7499E · Substantial damage NTSB FTW04LA042Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Clarendon, TXthe loss of engine power due the separation of the number six cylinder as a result of a fatigue failure from the loosening of the cylinder attachment hardware.Dec 14, 2003 · N718LG · Destroyed NTSB FTW00LA051Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Bulverde, TXThe total loss of engine power for an undetermined reason.Dec 21, 1999 · N6561X · Substantial damage NTSB FTW92LA031Accident · No injuriesLimited investigationFinal reportCessna 210 · Groves, TXFuel exhaustion which precipitated the forced landing due to the pilot's inadequate fuel consumption calculations. A factor in the accident was the pilot's failure to divert to an alternate destination when he recognized that fuel exhaustion was a possibility.Dec 1, 1991 · N9503T · Substantial damage NTSB FTW82DA120Accident · No injuriesFinal reportCessna 210A · Rock Springs, TXThe pilot became disoriented during a cross country flight. He decided to make a precautionary landing in a clearing. During the landing roll the left wing collided with a tree.Apr 10, 1982 · N9637T · Substantial damage NTSB FTW80DQD15Accident · No injuriesClosedCessna 210 · El Paso, TXAug 24, 1980 · N7483E · Substantial damage NTSB FTW79FRG20Accident · Minor injuriesClosedCessna 210 · San Marcos, TXMar 1, 1979 · N3603Y · Substantial damage NTSB FTW76DRG45Accident · No injuriesClosedCessna 210 · Del Rio, TXApr 10, 1976 · N9419T · Substantial damage NTSB FTW76DRA21Accident · No injuriesClosedCessna 210A · Addicks, TXJan 25, 1976 · N7425E · Substantial damage NTSB FTW75FPD34Accident · No injuriesClosedCessna 210 · Abilene, TXApr 16, 1975 · N7365E · Substantial damage NTSB FTW75AF030Accident · No injuriesClosedCessna 210 · Grand Prairie, TXNov 2, 1974 · N7352E · 2 aircraft · Substantial damage NTSB FTW72DQG25Accident · No injuriesClosedCessna 210 · Denver City, TXNov 27, 1971 · N1446 · Substantial damage NTSB FTW71FRH03Accident · Serious injuriesClosedCessna 210 · Rocksprings, TXMar 28, 1971 · N7487E · Substantial damage NTSB FTW71DQG42Accident · No injuriesClosedCessna 210 · Midland, TXOct 30, 1970 · N6538X · Substantial damage NTSB FTW70FPA08Accident · No injuriesClosedCessna 210 · Plano, TXMar 8, 1970 · N9420T · Substantial damage NTSB FTW69D0217Accident · No injuriesClosedCessna 210 · Pecos, TXSep 22, 1968 · N9538T · Substantial damage NTSB FTW69D0229Accident · No injuriesClosedCessna 210 · Taylor, TXJul 14, 1968 · N7435E · Substantial damage NTSB FTW67F0249Accident · No injuriesClosedCessna 210 · Ubbock, TXMay 9, 1966 · N9649T · Substantial damage NTSB FTW66F0513Accident · No injuriesClosedCessna 210 · Devine, TXFeb 2, 1966 · N9661T · Substantial damage NTSB FTW66F0505Accident · No injuriesClosedCessna 210 · Seguin, TXFeb 2, 1966 · N9661T · Substantial damage NTSB FTW66D0403Accident · No injuriesClosedCessna 210 · Smithville, TXOct 22, 1965 · N215MD · Substantial damage NTSB FTW66D0244Accident · No injuriesClosedCessna 210 · Gonzales, TXAug 12, 1965 · N7344E · Substantial damage NTSB FTW66F0125Accident · No injuriesClosedCessna 210 · Friendswood, TXJul 4, 1965 · N6538X · Substantial damage NTSB UNK65X1433Accident · No injuriesClosedCessna 210 · Addison, TXFeb 17, 1965 · N215MD · Substantial damage NTSB UNK64X0871Accident · No injuriesClosedCessna 210 · Port Lavaca, TXMar 10, 1964 · N9421T · Destroyed NTSB UNK64X0340Accident · No injuriesClosedCessna 210 · Giddings, TXJan 24, 1964 · N9661T · Substantial damage