Skip to content

NTSB investigations: Cessna T210N, FL

16 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19812026

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 ('2073456')) 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 ('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" = '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 ('2073456'))
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 ERA18LA103Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Orlando, FLThe improper adjustment of the fuel pump by maintenance personnel, which resulted in an overly rich fuel/air mixture and a total loss of engine power.Mar 13, 2018 · N5382A · Substantial damage NTSB ERA15LA058Accident · No injuriesLimited investigationFinal reportCessna T210 · Tampa, FLThe collapse of the left main landing gear for reasons that could not be determined during postaccident examination.Nov 24, 2014 · N610KC · Substantial damage NTSB MIA06LA121Accident · No injuriesLimited investigationFinal reportCessna T210 · Crestview, FLSpinning of the crankshaft No. 2 main bearing for undetermined reasons resulting in damage to the aft cheek of the No. 2 main bearing journal and fatigue failure of the crankshaft.Jul 15, 2006 · N5266Y · Substantial damage NTSB ATL02LA108Accident · No injuriesLimited investigationFinal reportCessna T210N · Orlando, FLThe pilot's inadequate planning decision that resulted in fuel exhaustion and subsequent loss of engine power.May 28, 2002 · N4672Y · Destroyed NTSB MIA96TA112Accident · No injuriesFinal reportCessna 210 · Lakeland, FLthe pilot's improper flare on landing, and his improper use of flight controls on landing rollout.Mar 29, 1996 · N2306D · Substantial damage NTSB MIA96LA027Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Ocala, FLThe failure of the pilot-in-command (CFI) of the Cessna, N210PW, to see and avoid the Piper, N2114P.Nov 22, 1995 · N2114P · 2 aircraft · Substantial damage NTSB MIA95LA137Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Homestead, FLBinding (mechanical) of the right elevator with the right horizontal stabilizer after collision with a dog at the right horizontal stabilizer during rotation. The deformation of the stabilizer reduced the pilot-in-commmand's ability to operate the elevator.May 27, 1995 · N6167Y · Substantial damage NTSB MIA88LA030Accident · No injuriesLimited investigationFinal reportCessna T-210N · Tallahassee, FLDuring ldg gear extension plt did not get safe down indication. Attempts to use emergency extension pump were unsuccessful. Acft was landed nose gear extended main gear retracted. Post accident inspection of the acft revealed the left main gear down lock…Nov 10, 1987 · N4612C · Substantial damage NTSB MIA87LA154Accident · No injuriesLimited investigationFinal reportCessna T210N · Apalachicola, FLThe plt stated that he departed panama city en route to tampa, FL, when the manifold pressure and oil pressure started to drop. He then turned towards Apalachicola to try to make it to the airport but was unable and made a forced landing in a swampy area aprx…May 2, 1987 · N4612C · Substantial damage NTSB MIA87MA064Accident · 6 fatalMajor investigationFinal reportCessna T210N · Jasper, FLDrg flt in an area of IFR conditions & rain showers, the plt reqd & recd clnc to dscnd from 9000' to 7000'. Later, he recd clnc for further dscnt to 5000'. After a freq chg at 2237 EST, the plt inquired about radar indcns of adverse wxahead. The ctlr adzd…Jan 1, 1987 · N5498A · Destroyed NTSB MIA83FA223Accident · Minor injuriesField investigationFinal reportCessna T-210N · Gainesville, FLThe acft collided with a ditch during a forced landing after engine failure in flt. The plt stated that during the climbto cruise the engine quit. He attempted to restart it once and then executed a forced landing. Examination of the acft wreckage revealed…Sep 6, 1983 · N6482Y · Substantial damage NTSB MIA83FA146Accident · Serious injuriesField investigationFinal reportCessna 210N · Avon Park, FLAbout 40 min after takeoff the plt reported he was having eng problems & requested radar vectors to the nearest arpt. He was given a 215 deg vector to Avon Park arpt, located about 11 mi sw. The plt stated he had the arpt in sight. Duringthe approach the acft…May 26, 1983 · N6190N · Destroyed NTSB MIA83LA071Accident · Minor injuriesLimited investigationFinal reportCessna T-210 · Ft. Myers, FLThe acft nosed over in a swampy area during a forced landing following an engine failure. The weather was VMC and no fltplan was filed. The two occupants of the acft received minor injuries. The pilot indicated that he believed he had enough fuel for the…Feb 8, 1983 · N9561Y · Substantial damage NTSB MIA82DA179Accident · Minor injuriesFinal reportCessna T210N · Near St. Peters, FLThe pilot reported that the flight was uneventful until it was about 5 miles northwest of st petersburg, FL. At about that point, the pilot contacted the tower for landing and advised that the plane was low on fuel. Shortly thereafter, the engine lost power.…Sep 9, 1982 · N9421Y · Destroyed NTSB MIA81FKT78Accident · No injuriesClosedCessna 210N · Key Largo, FLJun 11, 1981 · N6418N · Substantial damage NTSB MIA81FA069Accident · 1 fatalClosedRobertson T210N · Ft.Pierce, FLMay 6, 1981 · N5117Y · Destroyed