NTSB investigations: Continental TSIO-520 series, TX
133 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\" = '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.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" = '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.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 DFW07FA042Accident · 1 fatalField investigationFinal reportCessna T210N · Austin, TXThe pilot's failure to maintain control of the airplane while executing an instrument approach for undetermined reasons.NTSB DFW06CA201Accident · No injuriesData collectionFinal reportCessna T210N · San Angelo, TXThe failure of the landing gear to extend as result of a frayed electrical wire.NTSB DFW06LA188Accident · 1 fatalLimited investigationFinal reportCessna P210N · Amarillo, TXThe loss of engine power as result of the failure by maintenance personnel to install oil pump support bushings, which resulted in the fracture of the driven-gear and subsequent loss of oil pressure. Contributing factors were the lack of suitable terrain for…NTSB DFW06CA175Accident · No injuriesData collectionFinal reportCessna C340A · San Antonio, TXThe collapse of the left main landing gear as result of the failure of the gear pivot bolt for undetermined reasons.NTSB DFW06CA168Accident · No injuriesData collectionFinal reportCessna TU206G · Eldorado, TXThe pilot's failure to maintain airspeed during an emergency simulation resulting in a hard landing. A contributing factor was the flight instructor's delayed remedial action.NTSB DFW06CA134Accident · No injuriesData collectionFinal reportCessna P210N · Weslaco, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing,NTSB DFW06CA050Accident · No injuriesData collectionFinal reportCessna T210 · Midland, TXThe loss of engine power due to a connecting rod failure. Contributing factors were the dark night conditions and the lack of suitable terrain for the forced landing.NTSB DFW05FA241Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Houston, TXThe pilot's improper in-flight decision to maneuver back to the departure airport following a loss of engine power on initial climb. Contributing factors were the loss of engine power for undetermined reasons, and the dark night conditions.NTSB DFW05CA087Accident · No injuriesData collectionFinal reportCessna TU206G · Lancaster, TXThe pilot's mismanagement of the available fuel supply, which resulted in a total loss of engine power due to fuel starvation.NTSB FTW04LA223Accident · No injuriesLimited investigationFinal reportCessna 340 · Odessa, TXThe pilot's failure to extend the landing gear prior to landing and the instructor's inadequate supervision.NTSB FTW04IA104Incident · No injuriesIncident investigationFinal reportCessna 414 · Midland, TXThe in-flight wing fire for undetermined reasons.NTSB FTW04FA062Accident · 1 fatalField investigationFinal reportBeech B36TC · Willow Park, TXThe pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the dark night and rain.NTSB FTW04LA047Accident · No injuriesLimited investigationFinal reportCessna T210N · Marfa, TXThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04FA022Accident · 1 fatalField investigationFinal reportCessna 210M · Tolar, TXThe pilot's improper pre-flight planning and loss of engine power for undetermined reasons. A factor was the fog.NTSB FTW03LA199Accident · No injuriesLimited investigationFinal reportCessna T188C · Colorado City, TXThe loss of engine power due to failure of the crankshaft. A contributing factor was low altitude flight.NTSB FTW03FA093Accident · 3 fatalField investigationFinal reportCessna T210N · Mission, TXThe pilot's failure to maintain aircraft control, which resulted in his exceeding the airplane's design limitation. Contributing factors were the pilot's decision to fly the airplane with known deficiencies with the attitude indicator, and the failure of the…NTSB FTW03LA070Accident · No injuriesLimited investigationFinal reportCessna T207 · Brownsville, TXThe loss of engine power due to the separation of the crankshaft. A factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA025Accident · No injuriesLimited investigationFinal reportCessna T188C · Seminole, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02FA070Accident · 3 fatalField investigationFinal reportCessna 340A · Temple, TXThe pilot's mismanagement of fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing factors were the pilot's failure to follow the checklist to feather the propellers in order to reduce drag.NTSB FTW01LA210Accident · No injuriesLimited investigationFinal reportCessna T188C · Aiken, TXthe application of silicon sealant to the crankcase mating surfaces by maintenance personnel, which resulted in improper torque on the bolts which mate the crankcase halves, vibration, and the subsequent failure of the #2 main crankshaft bearing. A factor was…NTSB FTW01LA191Accident · 1 fatalLimited investigationFinal reportPiper PA-46-310P · Bulverde, TXthe pilot's failure to obtain airspeed after rotation, which resulted in a stall/mush. Contributing factors were the tailwind condition, high density altitude, and upsloping runway.NTSB FTW01LA185Accident · Minor injuriesLimited investigationFinal reportBeech A-36TC · Fort Worth, TXthe partial loss of engine power for an undetermined reason and the pilot's decision to initiate the takeoff downwind.NTSB FTW01LA170Accident · No injuriesLimited investigationFinal reportCessna T210N · Amarillo, TXthe pilot's failure to verify that the landing gear was extended and locked before landing. A contributing factor was a tripped landing gear motor circuit breaker, which resulted in the failure of the main landing gear to fully extend and lock.NTSB FTW01LA096Accident · No injuriesLimited investigationFinal reportCessna T210M · Abilene, TXthe loss of engine power while on final approach due to fuel starvation as a result of the pilot's improper use of the fuel selector. A contributing factor was the elevated runway edge.NTSB FTW00LA231Accident · No injuriesLimited investigationFinal reportCessna T210L · Addison, TXthe electrical wire bundle fire during approach, which tripped the hydraulic motor circuit breaker resulting in collapse of the landing gear on landing.NTSB FTW00LA099Accident · No injuriesLimited investigationFinal reportCessna 402C · San Antonio, TXThe pilot's inadequate handling of the aircraft during the landing flare/touchdown resulting in a hard landing that collapsed the left main landing gear.NTSB FTW99LA241Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Alpine, TXThe pilot's improper use of the emergency fuel boost pump, which resulted in excessive fuel flow to the engine and subsequent total loss of left engine power. Factor's were the high density altitude, the pilot exceeding the airplane's weight and balance, the…NTSB FTW99LA160Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Cleburne, TXThe total loss of engine power resulting from a failure of the #4 cylinder exhaust valve and/or piston. Factors were the dark night conditions and the lack of suitable terrain for the forced landing.NTSB FTW98LA025Accident · No injuriesLimited investigationFinal reportBeech A36TC · Stratford, TXThe pilot's failure to maintain the proper glidepath with the airplane resulting in the airplane not touching down at the proper touchdown point on the runway. A factor was the unfavorable winds.NTSB FTW97FA130Accident · 1 fatalField investigationFinal reportCessna 421 · League City, TXThe pilot's failure to refuel the airplane which resulted in the loss of power to the right engine due to fuel exhaustion, and the pilot's failure to maintain airspeed during the single engine landing approach which resulted in a stall/spin.NTSB FTW97LA037Accident · No injuriesLimited investigationFinal reportCessna T210N · Grand Prairie, TXfailure of the pilot to ensure that the fuel selector was positioned to a tank with sufficient fuel, which resulted in fuel starvation and loss of engine power. Factors relating to the accident were: the pilot's inadequate preflight, false indication from the…NTSB FTW96TA400Accident · No injuriesFinal reportCessna T188C · Snyder, TXThe pilot's failure to maintain clearance with a pole resulting in the separation of the left aileron and a loss of aircraft control. A factor was the haze.NTSB FTW96LA397Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Lonestar, TXThe loss of engine power due to the pilot's improper fuel consumption calculations resulting in the fuel exhaustion. A factor was the unsuitable terrain for the forced landing.NTSB FTW96LA295Accident · No injuriesLimited investigationFinal reportCessna T210L · Terrell, TXthe mechanic's improper installation of the left main landing gear brake line, which resulted in chaffing and failure of the brake line, loss of hydraulic fluid, and inoperative brake(s).NTSB FTW96TA186Accident · No injuriesFinal reportCessna T210N · Beaumont, TXFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95TA187Accident · No injuriesFinal reportCessna 210J · Fabens, TXLoss of engine power due to water contamination of the fuel.NTSB FTW94FA311Accident · 1 fatalField investigationFinal reportCessna T188C · Roscoe, TXThe pilot's failure to maintain flying speed resulting in an aerodynamic stall. A factor was the pilot's lack ofNTSB FTW94LA001Accident · Minor injuriesLimited investigationFinal reportCessna T188C · New Deal, TXFailure of the pilot to maintain ground clearance while avoiding a powerline. Failure of the pilot to see a second set of power lines prior to initiating the spraying run was also a cause.NTSB FTW93LA249Accident · No injuriesLimited investigationFinal reportCessna T188C · Rockport, TXInadvertent stall/mush experienced by the pilot.NTSB FTW92GA227Accident · No injuriesFinal reportCessna T210L · Spring, TXThe pilot under instruction failure to follow the landing checklist and the instructor pilot's inadequate supervision. A factor was the overheated landing gear motor.NTSB FTW92FA029Accident · Serious injuriesField investigationFinal reportCessna 402B · Roanoke, TXThe operation of the airplane with known deficiencies, a missing air cooling baffle, and inadequate maintenance. Factors were the frozen propeller, inability of the pilot to feather the propeller, inoperative landing gear, the inability of the pilot to…NTSB FTW89DQG06Accident · Minor injuriesFinal reportCessna T188C · Levelland, TXA partial brake system failure due to a leak in the left brake master cylinder.NTSB FTW87FA196Accident · Minor injuriesField investigationFinal reportCessna P210N · Pearland, TXDrg arrival, the plt made a nr half circle ovr the arpt & entered a dwnwnd for rwy 14R. Drg the entry, he reduced pwr & noted 2 or 3 sputters fm the eng. Just bfr turning to a base leg, he advanced the throttle for adnl power, but there wasno response fm the…NTSB FTW87FA032Accident · 1 fatalField investigationFinal reportCessna 340A · Tomball, TXThe pilot took off in fog and light rain and climbed into clouds at about 300-400 feet above the ground while both landing lights were extended and illuminated. Also the airport's rotating beacon (located aobut a mile from the accident site) was flashing on…NTSB FTW87LA004Accident · No injuriesLimited investigationFinal reportCessna T210N · Caddo, TXPrivate pilot in Cessna T210 attempted take off from soft, unimproved field, pilot and 1 passenger, 80 gallons fuel, crosswind component of 12 knots. Pilot rotated aircraft prematurely. Acft settled back to ground and became airborne with approximately 20 ft…NTSB FTW86FRG17Accident · Minor injuriesFinal reportCessna T210 · Ozona, TXThe acft was damaged in an off-arpt lndg after the eng quit. The plt said there was plenty of fuel on board the acft which was being ferried to its owner after an eng change. The plt was unable to restart the eng which had vibrated so that the plt thought he…NTSB FTW86FQG11Accident · No injuriesFinal reportCessna 402B · Plainview, TXThe acft landed gear up after a practice single-eng procedure. The plt attempted a go-around when the landing was aborted due to an improper approach. When the approach proceeded to this point with an intentionally inoperative eng the go-around was not a…NTSB FTW86FRA02Accident · Minor injuriesFinal reportCessna T210N · Houston, TXThe acft crashed in a wooded area during a forced landing after fuel exhaustion. The acft had extra fuel cans on board and had been flying for almost 12 hours in an attempt to avoid capture by U.S. Agents for the possession of marijuana. The acft contained…NTSB FTW85LA296Accident · No injuriesLimited investigationFinal reportCessna T210M · Kilgore, TXThe plt was to ferry the acft from mena, AR, to jacksonville, TX. During pre-flt he discovered the fuel gages were inop and a visual check of the fuel quantity was made. The plt estimated sufficient fuel remained in the tanks to complete the 50 minute flt. En…NTSB FTW85LA286Accident · No injuriesLimited investigationFinal reportCessna T210N · College Station, TXAbout 25 minutes after takeoff from a planned intermediate stop, the right fuel tank ran dry. After switching tanks, theplt decided to divert to a nearby arpt to refuel. During the descent, the left fuel tank ran dry and the eng quit due to fuel exhaustion.…