NTSB investigations: Continental TSIO-520 series
1,736 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.\"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."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 DEN91FA048Accident · 1 fatalField investigationFinal reportCessna T210M · Taos, NMThe pilot's decision to initiate flight into freezing rain which resulted in structural icing that exceeded the ability of the aircraft to maintain flight. A factor was: improper deicing.NTSB CHI91LA101Accident · No injuriesLimited investigationFinal reportCessna T210N · Elwood, INThe pilot's improper use of the fuel selector which resulted in fuel starvation. A related factor was: soft terrain in the emergency landing area.NTSB MIA91WA079Accident · No injuriesForeign investigationBeech B36TC · Pitts Town, BahamasNTSB LAX91FA081Accident · 1 fatalField investigationFinal reportCessna T210M · Sacramento, CAA loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed during the ensuing emergency landing.NTSB LAX91FA066Accident · 1 fatalField investigationFinal reportCessna T210M · Sacramento, CAThe failure of the pilot-in-command to maintain control of the airplane while flying in instrument meteorological conditions and spatial disorientation of the pilot-in-command. Contributing to the accident was diversion of the pilot's attention to…NTSB CHI91LA056Accident · No injuriesLimited investigationFinal reportCessna 340 · Chesterfield, MOFailure of the pilot to maintain directional control during the landing roll. Factors related to the accident are a foggy windshield, misjudgement of altitude, premature landing flare, and slush on the runway.NTSB MIA91WA054Accident · Serious injuriesForeign investigationCessna 401B · Marsh Harbor, BahamasNTSB CHI91LA036Accident · No injuriesLimited investigationFinal reportCessna T210M · Marshall, MIDirectional control not maintained by the PIC.NTSB NYC91LA031Accident · No injuriesLimited investigationFinal reportBeech B36TC · Caldwell, NJPremature rotation and an inadvertent stall. Factors include lack of total experience in this type of aircraft.NTSB CHI91LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · La Crosse, WIInadequate visual outlook by the PIC.NTSB SEA91LA009Accident · No injuriesLimited investigationFinal reportCessna T210N · Laramie, WYThe pilot did not properly set the mixture control.NTSB DEN91LA006Accident · No injuriesLimited investigationFinal reportCessna T210M · Englewood, COEngine failiure resulting from maintenance discrepancies.NTSB DEN91FA002Accident · 1 fatalField investigationFinal reportCessna T210N · Gypsum, COThe pilot flying into known adverse icing and thunderstorm weather conditions which resulted in the loss of control of the aircraft.NTSB MIA90LA192Accident · No injuriesLimited investigationFinal reportCessna 402B · St. ThomasSeparation of the left main landing gear torque tube bracket assembly due to sheared rivets from a previous hard side load landing which was not reported.NTSB DEN90LA173Accident · No injuriesLimited investigationFinal reportCessna T-210-L · Edgewood, NMEngine failure due to a broken connecting rod. A factor was the rough uneven terrain available for the forced landing.NTSB DEN90DTE06Accident · Serious injuriesFinal reportCessna 188A · Holyoke, COA stall mush which occurred when the pilot retracted the flaps prematurely following takeoff, causing the aircraft to settle into the ground.NTSB ANC90LA132Accident · No injuriesLimited investigationFinal reportCessna C-T210 · Sleeper Bay, AKImproper fuel tank selection.NTSB LAX90LA258Accident · No injuriesLimited investigationFinal reportCessna 340-A · Truckee, CAThe pilots loss of brake performance due to hydroplaning.NTSB DEN90FA159Accident · 1 fatalField investigationFinal reportCessna P210R · Ogden, UTFailure of the #1 piston due to pre-ignition/detonation in the #1 cylinder, and inadequate visual lookout by the pilot (his failure to see-and-avoid the obstruction). The obstruction (power line) was a related factor.NTSB ATL90LA142Accident · No injuriesLimited investigationFinal reportCessna T210L · Memphis, TNFuel mismanagement by the pilot which resulted in fuel starvation during final approach.NTSB DEN90LA158Accident · No injuriesLimited investigationFinal reportCessna T-188 · Devils Lake, NDThe pilot's failure to refuel, resulting in fuel exhaustion. A forced landing in rough terrain is a factor.NTSB LAX90LA242Accident · No injuriesLimited investigationFinal reportCessna 340 · Salinas, CAThe failure of maintenance personnel to reinstall the landing gear retract/extension linkage and the failure of inspection personnel to detect the improper installation.NTSB DEN90LA150Accident · No injuriesLimited investigationFinal reportCessna T 188C · Wray, COThe failure of the pilot to maintain proper alignment proper alignment during landing.NTSB SEA90LA110Accident · No injuriesLimited investigationFinal reportCessna 340A · Priest River, IDThe pilot's misjudgement of distance and altitude and his failure to maintain an adequate airspeed during the landing approach.NTSB CHI90LA151Accident · No injuriesLimited investigationFinal reportCessna T210N · Wheeling, ILPilot-in-command's failure to obtain a proper flare attitude in the aircraft prior to touchdown.NTSB SEA90LA093Accident · No injuriesLimited investigationFinal reportCessna TU206G · Elk City, IDThe pilot did not maintain directional control of the airplane during the landing roll. The landing was made on a wet runway with excessive airspeed.NTSB CHI90DEM03Accident · No injuriesFinal reportCessna T188 · Williamsburg, MIA loss of engine power for undetermined reasons. The lack of suitable terrain for landing was a factor related to the accident.NTSB ATL90LA097Accident · No injuriesLimited investigationFinal reportCessna T210 · Lafayette, GAThe pilot's failure to properly manage his fuel supply, which resulted in a loss of engine power, due to fuel starvation.NTSB SEA90FA066Accident · 2 fatalField investigationFinal reportMooney M20K · Carson City, NVThe pilot failed to maintain airspeed during takeoff. A contributing factor was the high density altitude.NTSB LAX90LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chino, CAFuel starvation due to the fuel tank outlets becoming unported as the aircraft maneuvered for landing. A factor was the pilot's preflight planning failed to insure that he had adequate fuel for the flight.NTSB MIA90LA099Accident · No injuriesLimited investigationFinal reportCessna P210N · Natchez, MSThe late extension of the landing gear by the pilot.NTSB MKC90FA044Accident · Serious injuriesField investigationFinal reportCessna P210N · Newton, KSLoss of engine power for an undetermined reason. Darkness and the resultant delay in flaring to land were related factors.NTSB DEN90LA026Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Gillette, WYForced landing in unsuitable terrain as a result of an engine crankshaft failure at low level cruise flight.NTSB MKC90FA026Accident · Serious injuriesField investigationFinal reportCessna T210 · Columbia, MOAn engine compartment fire due to a missing turbocharger exhaust duct and tailpipe assembly. The clamp used to retain the tailpipe assembly to the turbocharger was also missing, contributing factor(s) was: the soft terrain.NTSB ATL90LA009Accident · No injuriesLimited investigationFinal reportCessna 210 · Kernersville, NCImproper fuel consumption calculations by the pilot, which resulted in fuel exhaustion from lack of fuel. Adverse weather conditions were related to the accident.NTSB BFO90LA006Accident · No injuriesLimited investigationFinal reportCessna T310Q · Stevensville, MDThe pilot failed to maintain directional control of the aircraft during the landing roll.NTSB FTW89DQG06Accident · Minor injuriesFinal reportCessna T188C · Levelland, TXA partial brake system failure due to a leak in the left brake master cylinder.NTSB MKC89LA163Accident · No injuriesLimited investigationFinal reportBeech 58 · Cedar Rapids, IAThe failure of the pilot in command to maintain alignment with the runway and excessive aircraft control in close proximity to the ground. Contributing to the accident was the pilot's diverted attention which resulted from having to shut down the left engine.NTSB CHI89LA136Accident · No injuriesLimited investigationFinal reportCessna 335 · Pontiac, MIFailure of the right main landing gear extension/retraction component resulting from unacceptable loads incurred due to improper adjustment.NTSB LAX89LA233Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Los Angeles, CAAn undertorqued oil line fitting, due to its improper installation by maintenance personnel, which resulted in a loose oil line fitting, an oil line leak, oil exhaustion, and subsequent failure of the engine.NTSB DEN89LA172Accident · No injuriesLimited investigationFinal reportCessna T188C · Fort Benton, MTOverload failure of the left main landing gear attaching bolts for an unknown reason.NTSB LAX89LA223Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Herlong, CAFuel starvation, after the pilot diverted his attention to an electrical problem, and his failure to reposition the fuel selector switch, either before the engine lost power or during emergency procedures. Factors related to the accident were: the tripped…NTSB SEA89LA112Accident · No injuriesLimited investigationFinal reportCessna TU206G · Las Vegas, NVThe loss of directional control as a result of gusting wind conditions.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 LAX89LA193Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Upland, CAInadequate in-flight planning/decision by the pilot in command, the instructor pilot. Factors were the private pilot did not switch the fuel tanks and the instructor did not catch it.NTSB LAX89LA156Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Scottsdale, AZThe pilot's loss of directional control of the airplane during the ground run and abrupt rotation to get airborne.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 DEN89LA087Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Broomfield, COPilot's failure to properly control the aircraft while conducting a crosswind takeoff.NTSB SEA89LA055Accident · Minor injuriesLimited investigationFinal reportCessna TU206-G · Reno, NVThe pilot's failure to adequately compensate for crosswinds. Contributing to the accident was the pilot's decision to land the amphibious aircraft in strong crosswind conditions.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.