Skip to content

NTSB investigations: Cessna 210, FL

22 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" = 'FL' 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\" = 'FL' 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" = 'FL' 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 ERA12LA306Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Fowler's Bluff, FLThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.Apr 27, 2012 · N6564X · Substantial damage NTSB ATL96LA077Accident · No injuriesLimited investigationFinal reportCessna 210M · Everglades City, FLthe pilot's excessive airspeed and misjudgment of the landing distance. A factor was the right brake not working due to a hydraulic leak.Apr 6, 1996 · N700RP · Substantial damage NTSB MIA90LA151Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Naples, FLImproper maintenance of the fuel system resulting in the loss of power due to internal contamination of the engine driven fuel pump.Jul 12, 1990 · N7406E · Substantial damage NTSB MIA90LA007Accident · No injuriesLimited investigationFinal reportCessna 210 · Jacksonville, FLInadequate preflight by the pilot, and fuel starvation, due to his improper positioning of the fuel selector.Oct 7, 1989 · N5252E · Substantial damage NTSB MIA88LA047Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Quincy, FLThe plt stated that he performed a prelanding check on final apch but failed to lower the landing gear. He continued the apch, & just prior to touchdown, was advised that the gear was not down. The apch to landing was continued & the acft slid to a stop. He…Nov 29, 1987 · N9492T · Substantial damage NTSB MIA87LA008Accident · No injuriesLimited investigationFinal reportCessna 210 · Kissimmee, FLThe plt stated that he forgot to lower the gear and that the accident could have been prevented if a tower had told him to lower the gear. There is no tower at the arpt. After the accident, the plt produced a caa commercial plt certificate which was issued in…Oct 15, 1986 · N7395E · Substantial damage NTSB MIA84LA050Accident · No injuriesLimited investigationFinal reportCessna 210 · Ft. Myers, FLDuring tkof roll abt halfway down the rwy the plt noticed the acft was not accelerating normally. Aft liftoff he atmptd to return to the arpt however was forced to ditch the acft in the caloosahatche river due to a loss of pwr. Exam of the eng revealed that…Dec 23, 1983 · N9510T · Destroyed NTSB MIA83LA024Accident · No injuriesLimited investigationFinal reportCessna 210 · Near Miami, FLAbout 15 minutes after takeoff the aircraft engine quit. All attempts to restart the engine were unsuccessful and the pilot landed in the everglades swamp. Examination of the aircraft revealed that the fuel manifold valve, PN-631427-A15 was stuck in the…Nov 5, 1982 · N6545X · Substantial damage NTSB MIA82DA056Accident · No injuriesFinal reportCessna 210A · Florida City, FLThe aircraft was found inverted in 5 feet of water. Only one seat was installed and an auxiliary fuel pump was inside the aircraft. It appeared that the aircraft landed on the adjacent canal bank and then purposely run into the water. Police suspect a drug…Feb 22, 1982 · N7335E · Substantial damage NTSB MIA77FLD79Accident · No injuriesClosedCessna 210 · Zephyraills, FLAug 15, 1977 · N6545X · Substantial damage NTSB MIA77FA064Accident · 1 fatalClosedCessna 210 · Summerland Key, FLJun 23, 1977 · N9536T · Destroyed NTSB MIA77FL035Accident · No injuriesClosedCessna 210 · Vero Beach, FLMar 16, 1977 · N49KT · Substantial damage NTSB MIA75DLA23Accident · No injuriesClosedCessna 210 · Keystone Hts, FLNov 16, 1974 · N9434T · Substantial damage NTSB MIA73FKT02Accident · No injuriesClosedCessna 210 · Opa Locka, FLJul 4, 1972 · N9454T · Substantial damage NTSB MIA72AM069Accident · 3 fatalClosedCessna 210A · Perry, FLJan 11, 1972 · N9429X · Destroyed NTSB MIA70AM092Accident · 1 fatalClosedCessna 210 · Mims, FLMay 9, 1970 · N9624T · Destroyed NTSB MIA70DLD20Accident · Minor injuriesClosedCessna 210 · Ocala, FLApr 24, 1970 · N7329E · Substantial damage NTSB MIA70F0070Accident · No injuriesClosedCessna 210 · Orlando, FLJun 26, 1969 · N7303E · Substantial damage NTSB MIA68F0401Accident · No injuriesClosedCessna 210 · Jacksonville, FLJan 16, 1968 · N4567F · Substantial damage NTSB MIA67F0151Accident · No injuriesClosedCessna 210 · Opa Locka, FLAug 1, 1966 · N7342E · Substantial damage NTSB MIA66D0341Accident · No injuriesClosedCessna 210 · Opa Locka, FLDec 17, 1965 · N7465E · Substantial damage NTSB UNK64X0638Accident · No injuriesClosedCessna 210 · Summerland Ky, FLFeb 21, 1964 · N7416E · Substantial damage