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.

NTSB ERA16FA185Accident · 4 fatalField investigationFinal reportBeech A36TC · Tupelo, MSA preexisting stress rupture that initiated at a spot weld in the turbocharger v-band exhaust clamp, which resulted in the failure of the clamp and separation of the exhaust tailpipe, an in-flight fire, and subsequent impact with terrain.May 16, 2016 · N60RW · DestroyedNTSB GAA16CA235Accident · No injuriesData collectionFinal reportCessna 182P · Williamsburg, VAThe pilot's failure to maintain directional control during the landing in variable direction and gusting wind conditions, resulting in a landing off the side of the runway and impact with a drainage culvert.May 14, 2016 · N58625 · Substantial damageNTSB ERA16FA133Accident · 2 fatalField investigationFinal reportCessna 340 · Tampa, FLThe intentional low altitude maneuvering during takeoff in response to a near-miss with an airplane departing from a converging runway, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.Mar 18, 2016 · N6239X · DestroyedNTSB CEN16LA107Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Bryan, TXA failure of the crankshaft due to improper torque of the crankcase through bolts.Feb 16, 2016 · N732FU · Substantial damageNTSB WPR16LA066Accident · Minor injuriesLimited investigationFinal reportBeech B36TC · Santa Barbara, CAA total loss of engine power during initial climbout for reasons that could not be determined because postaccident examination and testing of the engine did not reveal any mechanical anomalies that would have precluded normal operation.Feb 9, 2016 · N113TM · Substantial damageNTSB WPR16LA060Accident · No injuriesLimited investigationFinal reportPiper PA46 · Burns, ORThe total loss of engine power for reasons that could not be determined because postaccident examination revealed no evidence of an anomaly that would have precluded normal operation. Contributing to the accident was a preexisting landing gear anomaly that…Jan 31, 2016 · N777PG · Substantial damageNTSB WPR16LA058Accident · No injuriesLimited investigationFinal reportCessna 340A · Bakersfield, CAMaintenance personnel’s repeated failure to re-rig the main landing gear (MLG) in accordance with the airplane manufacturer's service manual requirements, which resulted in the collapse of the right MLG.Jan 27, 2016 · N346MC · Substantial damageNTSB GAA16CA092Accident · No injuriesData collectionFinal reportPiper PA 46 · Stevensville, MDThe pilots failure to maintain glide path, descent rate and landing flare, in off shore wind conditions, resulting in a hard landing short of the runway.Dec 28, 2015 · N9083U · Substantial damageNTSB GAA16CA065Accident · Minor injuriesData collectionFinal reportCessna T210N · Avalon, CAThe pilot's delay in aborting the landing, resulting in a runway overrun and nose over.Nov 29, 2015 · N99210 · Substantial damageNTSB ERA16FA043Accident · 2 fatalField investigationFinal reportBeech A36TC · Orlando, FLThe pilot's failure to maintain adequate airspeed while turning to join the final approach leg of the airport traffic pattern with full airplane-nose-up trim, which resulted in the airplane exceeding its critical angle of attack and experiencing an…Nov 20, 2015 · N7FG · DestroyedNTSB WPR16LA031Accident · No injuriesLimited investigationFinal reportCessna 210 · Coalinga, CAA partial loss of engine power during takeoff for reasons that could not be determined, because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.Nov 19, 2015 · N9824G · Substantial damageNTSB ERA16LA042Accident · No injuriesLimited investigationFinal reportCessna P210 · Atlanta, GAThe pilot's delayed extension of the landing gear and his failure to ensure that the main landing gear (MLG) were down and locked before touchdown, which resulted in the collapse of both MLG. Contributing to the landing gear collapse was the mis-set landing…Nov 6, 2015 · N731LT · Substantial damageNTSB CEN15LA354Accident · Serious injuriesLimited investigationFinal reportCessna C421B · Clovis, NMThe pilot's improper management of fuel to the left engine during approach for landing, which resulted in a total loss of left engine power due to fuel starvation, and his subsequent failure to maintain control during the final landing approach, which…Aug 9, 2015 · N726JB · Substantial damageNTSB WPR15LA229Accident · No injuriesLimited investigationFinal reportCessna TU206G · Saint Ignatius, MTMaintenance personnel’s failure to tighten a fuel line, which resulted in a loss of fuel pressure and a subsequent loss of engine power during cruise flight and an off-airport landing and collision with obstacles.Aug 3, 2015 · N235HM · Substantial damageNTSB GAA15CA206Accident · No injuriesData collectionFinal reportCessna T210L · Duluth, MNThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing. Contributing to the accident was the pilot's diverted attention to another airplane in the vicinity and that he inaccurately…Jul 25, 2015 · N1650X · Substantial damageNTSB CEN15FA311Accident · Serious injuriesField investigationFinal reportPiper PA-46-310P · Oshkosh, WIThe pilot's failure to perform a go-around after receiving a modified landing clearance and his failure to maintain adequate airspeed while maneuvering to land, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering…Jul 22, 2015 · N4BP · Substantial damageNTSB CEN15CA304Accident · No injuriesData collectionFinal reportCessna 340 · South St. Paul, MNThe airplane's inability to takeoff for reasons that could not be determined because postaccident examination of the airplane revealed no anomalies. The aborted takeoff resulted in a runway overrun and impact with a fence.Jul 12, 2015 · N5139J · Substantial damageNTSB ERA15LA258Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Oneonta, NYThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel starvation.Jul 7, 2015 · N59024 · Substantial damageNTSB ERA15LA238Accident · No injuriesLimited investigationFinal reportCessna T210 · Palmyra, PAThe pilot's delay in conducting an aborted landing and his subsequent failure to establish a proper airspeed during the attempted go-around on a hot day, which resulted in the airplane’s inability to climb and a subsequent stall/mush.Jun 14, 2015 · N732VN · Substantial damageNTSB WPR15CA173Accident · No injuriesData collectionFinal reportCessna T188C · Ismay, MTThe pilot's incorrect action to continue the takeoff when he failed to maintain directional control during the takeoff roll.May 31, 2015 · N9987J · Substantial damageNTSB CEN15LA250Accident · No injuriesLimited investigationFinal reportCessna T188C · Pine Bluffs, WYThe pilot's loss of directional control to the right for reasons that could not be determined during examination of the right main landing gear wheel and brake drum.May 27, 2015 · N1965J · Substantial damageNTSB WPR15FA143Accident · 4 fatalField investigationFinal reportCessna T210M · Challis, IDThe pilot's attempt to depart in conditions that resulted in the airplane having insufficient performance capability, which resulted in a collision with a tree.Apr 10, 2015 · N732YQ · Substantial damageNTSB CEN15FA190Accident · 7 fatalField investigationFinal reportCessna 414A · Bloomington, ILThe pilot's failure to maintain control of the airplane during the instrument approach in night instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the…Apr 7, 2015 · N789UP · Substantial damageNTSB CEN15CA184Accident · No injuriesData collectionFinal reportCessna T188C · Burdett, KSThe pilot did not maintain directional control of the airplane in gusting wind conditions.Mar 28, 2015 · N2093J · Substantial damageNTSB WPR15LA137Accident · No injuriesLimited investigationFinal reportPiper PA 46-310P · Redmond, ORA loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.Mar 1, 2015 · N9133G · Substantial damageNTSB WPR15CA112Accident · No injuriesData collectionFinal reportCessna T210 - L · The Dalles, ORThe pilot's failure to extend the landing gear prior to touch down. Contributing to the accident was the pilot's failure to utilize the pre-landing checklist.Feb 16, 2015 · N93810 · Substantial damageNTSB ERA15LA125Accident · No injuriesLimited investigationFinal reportCessna 402C · Isla de Vieques, PRThe pilot's failure to maintain directional control during the landing roll with a strong crosswind, which resulted in a runway excursion.Feb 10, 2015 · N223PB · Substantial damageNTSB WPR15LA099Accident · No injuriesLimited investigationFinal reportBeech A36TC · Flagstaff, AZThe pilot's improper landing flare and loss of airplane control, which resulted in a hard landing and the subsequent failure of the nose landing gear.Jan 18, 2015 · N3685W · Substantial damageNTSB CEN15FA090Accident · 1 fatalField investigationFinal reportCessna 404 · Englewood, COThe loss of power to the right engine for reasons that could not be determined during postaccident examination and teardown and the pilot’s failure to properly configure the airplane for single-engine flight.Dec 30, 2014 · N404MG · Substantial damageNTSB 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 damageNTSB CEN15LA053Accident · Minor injuriesLimited investigationFinal reportBeech 58P · San Antonio, TXThe pilot’s improper decision to land long (past the midpoint) on a wet runway and his failure to conduct a go-around when the airplane did not touch down at the approach end of the runway, which resulted in an overrun.Nov 20, 2014 · N3689L · Substantial damageNTSB WPR15LA032Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Jacksonville, ORA loss of engine power during cruise flight due to the failure of the No. 6 connecting rod, which resulted from oil starvation.Nov 2, 2014 · N1593M · Substantial damageNTSB WPR15LA022Accident · No injuriesLimited investigationFinal reportCessna TU206G · Monument, ORThe loss of braking action during the landing roll on a gravel runway for reasons that could not be determined based on the available information.Oct 26, 2014 · N4776U · Substantial damageNTSB CEN15LA015Accident · No injuriesLimited investigationFinal reportCessna P210N · West Memphis, ARA catastrophic engine failure due to an oil starvation event for reasons that could not be determined based on the available evidence.Oct 15, 2014 · N731QV · Substantial damageNTSB CEN15FA008Accident · 1 fatalField investigationFinal reportPiper PA46 · Dubuque, IAThe pilot's loss of airplane control while attempting to fly a missed approach procedure in instrument meteorological conditions.Oct 14, 2014 · N9126V · DestroyedNTSB ERA14TA435Accident · No injuriesFinal reportCessna T210N · Gaithersburg, MDThe pilot’s failure to execute a missed approach after recognizing that the airplane was not aligned with the wet runway, which resulted in a long landing with a tailwind and a subsequent runway overrun.Sep 13, 2014 · N5132C · Substantial damageNTSB ERA14WA393Accident · 4 fatalForeign investigationCessna 340A · Freeport, BahamasAug 18, 2014 · N340MM · DestroyedNTSB CEN14FA438Accident · 2 fatalField investigationFinal reportCessna 414 · Bowie, TXThe pilot’s incapacitation in flight as the result of a an acute cardiac event, which resulted in a loss of control and collision with terrain.Aug 15, 2014 · N127BC · DestroyedNTSB CEN14LA408Accident · No injuriesLimited investigationFinal reportRaytheon B36TC · Decatur, ILDebris in the fuel system, which resulted in fuel starvation and a subsequent loss of engine power.Aug 6, 2014 · N1069T · Substantial damageNTSB ERA14FA359Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Clayton, GAThe pilot’s decision to begin a flight with fog and low clouds present at the airport, which resulted in an encounter with instrument meteorological conditions immediately after takeoff and a controlled flight into terrain.Jul 26, 2014 · N248SP · DestroyedNTSB CEN14LA327Accident · Minor injuriesLimited investigationFinal reportCessna T207 · Indianapolis, INA loss of engine power due to fuel starvation, which resulted from the pilot's failure to monitor the fuel level and switch tanks in a timely fashion.Jun 27, 2014 · N207AB · Substantial damageNTSB CEN14LA324Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Maryland Heights, MOThe loss of left engine power for reasons that could not be determined due to impact and fire damage.Jun 26, 2014 · N1552T · DestroyedNTSB CEN14CA295Accident · Minor injuriesData collectionFinal reportCessna 414 · Pleasanton, TXThe pilot's failure to maintain aircraft control during an aborted landing due to an encounter with a tailwind.Jun 16, 2014 · N1671T · Substantial damageNTSB ERA14LA179Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Clayton, ALMaintenance personnel’s failure to properly torque the engine case through bolts, which resulted in the fatigue fracture of the crankshaft and subsequent total loss of engine power.Apr 3, 2014 · N1631X · Substantial damageNTSB CEN14WA184Accident · 2 fatalForeign investigationCessna T210L · San Marcos, GuatemalaOn April 1, 2014, about 1340 local time, a Cessna T210L, single engine airplane, N732JY, was destroyed after impacting mountainous terrain near San Marcos, Guatemala. The pilot and passenger were fatally injured. About 1318 the airplane departed from…Apr 1, 2014 · N732JY · DestroyedNTSB ERA14LA156Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Stuart, FLThe pilot’s improper preflight planning and fuel management, which resulted in a total loss of power in both engines due to fuel exhaustion.Mar 14, 2014 · N419AR · Substantial damageNTSB WPR14LA118Accident · No injuriesLimited investigationFinal reportCessna P210N · Bountiful, UTFuel starvation due to the in-flight loosening of the fuel lines attached to the fuel flow indicator as a result of inadequate maintenance.Feb 23, 2014 · N18DP · Substantial damageNTSB CEN14LA120Accident · No injuriesLimited investigationFinal reportCessna 414A · Ashland, MOThe in-flight failure of both engines due to water contamination.Jan 23, 2014 · N414CJ · Substantial damageNTSB CEN14CA114Accident · No injuriesData collectionFinal reportCessna 340 · Coldwater, MIAirport personnel did not remove the snow banks from the intersecting runway and/or close the intersection runway, which resulted in the airplane impacting the snow banks. Contributing to the accident was the reduced visibility inhibiting the pilot's ability…Jan 15, 2014 · N10MF · Substantial damageNTSB CEN14CA106Accident · Minor injuriesData collectionFinal reportCessna P210N · Pagosa Springs, COThe pilot's inadequate preflight inspection which led to a loss of oil pressure and partial loss of engine power on takeoff. Contributing to the accident was the pilot's failure to check the security of the oil filler cap prior to the flight.Jan 8, 2014 · N4817K · Substantial damage