NTSB investigations: Continental TSIO-520 series, FL
106 cases on aircraft whose registry engine model is Continental TSIO-520 series. 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.
Cases, newest first
Query with SQL
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.engine_model_code IN ('17040'))
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.engine_model_code IN ('17040'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 MIA99LA136Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLA loss of engine power due to fuel exhaustion and the pilot in command's failure to ensure that the aircraft had adequate fuel to complete the flight.NTSB MIA98LA133Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Miami Lakes, FLThe failure of the pilot to ensure the aircraft contained enough fuel to complete the flight resulting in loss of engine power due to fuel exhaustion.NTSB MIA98LA123Accident · No injuriesLimited investigationFinal reportCessna 402B · West Palm Beach, FLthe pilot allowed the airplane to improperly touchdown on the right main landing gear, resulting in the gear collapsing, and subsequent impact with runway visual range equipment.NTSB MIA98LA019Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe pilot's improper management of fuel resulting in a total loss of engine power on both engines due to fuel exhaustion.NTSB ATL97LA099Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Destin, FLa loss of engine power for undetermined reasons.NTSB MIA96TA112Accident · No injuriesFinal reportCessna 210 · Lakeland, FLthe pilot's improper flare on landing, and his improper use of flight controls on landing rollout.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.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.NTSB MIA95LA016Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe failure of the left main landing gear upper barrel and trunion assembly due to overstress separations, resulting in the collapse of the left main landing gear on landing rollout.NTSB MIA94FA044Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Destin, FLAirspeed not maintained, inadvertent stall/mush, and altitude inadequate for recovery from the inflight loss of control by the pilot-in-command while circling for landing.NTSB MIA94LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-301P · Fort Myers, FLThe failure of the pilot-in-command to abort the takeoff. A contributing factor was the soft condition of the runway surface.NTSB MIA94LA014Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Fort Lauderdale, FLAn engine failure for undetermined causes over terrain unsuitable for a forced landing.NTSB ATL92FA167Accident · 2 fatalField investigationFinal reportCessna 402B · Miramar, FLThe failure of the pilot to perform preflight planning in that the weight and balance of the aircraft were exceeded. The pilot's lack of experience in the type of aircraft and lack of multiengine certification.NTSB MIA92IA100Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe total failure of the main landing gear uplock and sequencing valve for undetermined reasons.NTSB MIA92FA058Accident · 1 fatalField investigationFinal reportCessna 402B · Lantana, FLThe pilot in commands failure to maintain airspeed above single engine minimum control speed resulting in an inflight loss of control and collision with terrain. Contributing to the accident was the pilot in command's failure to declare an emergency and…NTSB MIA91MA100Accident · 4 fatalMajor investigationFinal reportPiper PA-46-310P · Bronson, FLThe pilot's failure to activate the pitot heat before ascending above the freezing level in instrument meteorological conditions (IMC), followed by his improper response to erroneous airspeed indications that resulted from blockage of the pitot tube by…NTSB MIA89FA151Accident · 1 fatalField investigationFinal reportCessna TU206F · Immokalee, FLThe pilot's failure to establish the descent angle which would attain the proper touchdown point. Consequently, the airplane collided, in flight, with the airport boundary fence.NTSB MIA89LA107Accident · No injuriesLimited investigationFinal reportCessna 402A · Miami, FLThe overload failure of the bellcrank for the left main gear retraction linkage assembly for an unknown reason.NTSB MIA89LA085Accident · No injuriesLimited investigationFinal reportCessna 340A · Jacksonville, FLSeizure of the right main landing gear upper downlock top bushing, and the failure of other maintenance personnel to properly rig the landing gear down light micro switches.NTSB MIA89GA082Accident · Minor injuriesFinal reportCessna T210L · Melbourne, FLFailure of the pilot to accurately determine fuel quantity prior to departure followed by his failure to operate the engine on the fullest fuel tank resulting in a fuel tank being run dry resulting in engine failure while on short final approach at his…NTSB MIA89LA075Accident · No injuriesLimited investigationFinal reportCessna T310R · Pensacola, FLFailure of the pilot to maintain the proper airspeed during the approach resulting in landing short of the runway and failure to maintain directional control during the landing roll.NTSB MIA88LA189Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe right main gear collapsed on touchdown. An exam of the gear revealed that a fork bolt had been improperly adjusted. The facility that performed the last maintenance denied adjusting the bolt.NTSB MIA88IA181Incident · No injuriesIncident investigationFinal reportCessna P210N · Daytona Beach, FLThe plt rprtd that while on final apch to land, he became distracted by conversation with the passenger & failed to lower the landing gear. Subsequently, the acft was landed with the gear retracted. After it was lifted from the rwy after the incident, the…NTSB MIA88FA107Accident · 2 fatalField investigationFinal reportBeech 58P · Dunedin, FLFlt was being vectored for practice ILS approach in VFR conditions while the plt-in-command was receiving a biennial flt review. Radar data showed the acft constantly veering to the left off assigned heading and witnesses reported only hearing one engine…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…NTSB MIA87LA253Accident · No injuriesLimited investigationFinal reportCessna TU206F · Tavernier, FLThe acft ditched in the atlantic about 40 mi e of Tavernier, FL during an extended overwater flt to georgetown, Bahamas. The acft sank after the accident & the plt & his pax were rescued by the USCG unharmed. The fixed base operator where the acft departed,…NTSB MIA87IA229Incident · No injuriesIncident investigationFinal reportCessna 402B · W.Palm Beach, FLThe lt main gear would not extend when the plt attempted to lower the gear & and the acft was landed in that condition. An exam of the strut assy revealed that a bearing, p/n 5041108-1/2 had failed permitting the strut to overextend, jamming the gear in the…NTSB MIA87LA197Accident · Minor injuriesLimited investigationFinal reportCessna TU-206F · Ft. Lauderdale, FLThe pilot refueled for the flight by topping off the fuel tanks. He then utilized the left tank until it was empty and switched to the right for the remainder of the flight. About 2 miles short of the destination the engine failed. The right fuel cap was…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…NTSB MIA87IA011Incident · No injuriesIncident investigationFinal reportCessna 310R · West Palm Beach, FLWhile on an on-demand air-taxi flight the pilot noted that at touchdown the rt main gear was collapsing. He executed a go-around and attempted to lower the gear manually, but could not. The pilot then shut down the right engine and feathered the right…NTSB MIA86LA132Accident · No injuriesLimited investigationFinal reportCessna 402B · Opa Locka, FLThe plt stated that upon arrival at his destination he could not get his landing gear to extend. He then returned to Opa Locka airport where he intentionally landed with the gear up. Post crash investigation of the acft revealed that the landing gear would…NTSB MIA86FA076Accident · 2 fatalField investigationFinal reportCessna 340A · Dania, FLShortly after takeoff on a check-out flight the aircraft was observed on crosswind leg to descend until impact. There was an extensive post impact fire. Witnesses heard the aircraft make a 'poof' type of noise just as the pilot radioed the control tower and…NTSB MIA86LA051Accident · No injuriesLimited investigationFinal reportCessna T210L · Madison, FLThe pilot stated that he had started the flight at about 1000 EST from miami, FL and had planned on landing at Madison county airport. As he flew overhead he noted an airstrip with county vehicles parked nearby. He landed and was informed that it was local…NTSB MIA85LA157Accident · No injuriesLimited investigationFinal reportCessna T310R · Boca Raton, FLThe plt stated that while taxiing in from landing & upon exicuting a right turn into the ramp the right main landing gear collapsed. Inspection of the landing gear revealed that the aft push pull retract rod failed at the rod end allowing the collapse of the…NTSB MIA85IA152Incident · No injuriesIncident investigationFinal reportCessna 402C · West Palm Beach, FLThe nose gear collapsed on touchdown. An exam of the nose gear actuating rod, the only positive down lock, revealed that it had been improperly adjusted.NTSB MIA84LA107Accident · No injuriesLimited investigationFinal reportCessna 210N · Lacrosse, FLThe plt reported that the right fuel tank went dry when the fuel gage indicated it had 6 gal remaining. He switched fuel tanks, & shortly thereafter, the left tank emptied when the gage indicated it had 13 gal remaining. He tried to land in a pasture, but was…NTSB MIA84LA089Accident · 2 fatalLimited investigationFinal reportCessna P-210N · Key West, FLDuring his wx briefing the plt was given the flight precautions & enroute forecast along his proposed route of flt. Enroute at 14,000 ft the plt advised ARTCC that the flt had encountered rime ice. The controller cleared the flt to descend to 12,000 ft & the…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…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…NTSB MIA83FLA01Accident · Serious injuriesFinal reportCessna T188C · St. Augustine, FLThe plt reported that he had just completed east to west swath runs & turned toward the sun to trim the east side of the field. Also, he reported that his windshield was covered with spray mist which restricted his visibility. Subsequently, he did not see how…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…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.…NTSB MIA82DA118Accident · Minor injuriesFinal reportCessna T210M · Fort Lauderdale, FLApproximately 18 miles west of the Fort Lauderdale airport, while cruising at 7500 feet, the engine lost power. After advising the tower of the problem, ATC suggested attempting a landing at a closer airport. At this point the pilot stated that power had been…NTSB MIA82DA074Accident · No injuriesFinal reportCessna T210M · Miami, FLThe pilot experienced a loss of electrical power on a VFR flight. Upon arrival in the Miami area he was unable to extend the main gear and landed gear up.NTSB MIA81FKU05Accident · No injuriesClosedCessna 402B · Miami, FLNTSB MIA81FLD65Accident · No injuriesClosedCessna 401B · Tampa, FLNTSB MIA81DLA33Accident · No injuriesClosedBeech 58P · Jacksonville, FLNTSB MIA81DLD61Accident · No injuriesClosedCessna T188C · Romeo, FLNTSB MIA81FKT78Accident · No injuriesClosedCessna 210N · Key Largo, FLNTSB MIA81FA069Accident · 1 fatalClosedRobertson T210N · Ft.Pierce, FL