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 GAA18CA134Accident · No injuriesData collectionFinal reportCessna T303 · Great Barrington, MAThe pilot’s failure to see the taxiway when returning to the ramp from the snow-covered runway, which resulted in the airplane rolling down an embankment.Feb 4, 2018 · N303TL · Substantial damageNTSB ERA18LA072Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Farmington, PAA total loss of engine power due to fatigue failure of the crankshaft drive gear teeth.Jan 29, 2018 · N34VF · Substantial damageNTSB WPR18LA057Accident · No injuriesLimited investigationFinal reportCessna T210L · Aurora, ORA collapse of the right main landing gear during the landing roll because the gear would not lock into place. Contributing to the accident was the pilot's failure to perform the alternate landing gear extension procedure before landing.Jan 2, 2018 · N2122S · Substantial damageNTSB CEN18FA061Accident · 5 fatalField investigationFinal reportCessna 340 · Bartow, FLThe pilot's loss of control due to spatial disorientation during takeoff in instrument meteorological conditions.Dec 24, 2017 · N247AT · DestroyedNTSB CEN18FA053Accident · 3 fatalField investigationFinal reportCessna T210M · Oldenburg, INA total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…Dec 17, 2017 · N761YZ · DestroyedNTSB ERA18WA047Accident · 1 fatalClass 5 · ForeignCessna T210 · West End, BahamasDec 14, 2017 · N727TJ · Substantial damageNTSB CEN18FA049Accident · 1 fatalField investigationFinal reportRaytheon B36TC · Chesterfield, MOThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Dec 6, 2017 · N679EA · DestroyedNTSB GAA18CA071Accident · No injuriesData collectionFinal reportCessna 402 · Hyannis, MAEncounter with a flock of birds during takeoff at night, resulting in multiple bird strikes and structural damage.Dec 4, 2017 · N2748Y · Substantial damageNTSB CEN18LA031Accident · No injuriesLimited investigationFinal reportCessna T210N · Grayslake, ILThe failure of the No. 4 connecting rod due to inadequate oil lubrication for reasons that could not be determined because the postaccident engine examination did not reveal any anomalies that would have caused a lack of lubrication.Nov 12, 2017 · N5300A · Substantial damageNTSB WPR18LA022Accident · No injuriesLimited investigationFinal reportCessna P210N · Mount Vernon, WAThe failure of the right main landing gear (MLG) down-lock mechanism due to an out-of-tolerance down-lock hook, which resulted in the collapse of the right MLG during the landing roll.Oct 28, 2017 · N6582P · Substantial damageNTSB CEN18CA021Accident · No injuriesData collectionFinal reportCessna T210N · Eagle, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Oct 23, 2017 · N5129C · Substantial damageNTSB ERA18LA011Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 402 · St. Petersburg, FLThe pilot's mismanagement of the onboard fuel, which resulted in fuel starvation, a total loss of power to both engines, and a subsequent forced landing.Oct 18, 2017 · N900CR · Substantial damageNTSB GAA18CA007Accident · No injuriesData collectionFinal reportCessna T210 · Waterford, MIThe pilot's unstabilized approach at night, which resulted in collision with trees.Oct 7, 2017 · N5EC · Substantial damageNTSB ERA18FA004Accident · 2 fatalField investigationFinal reportCessna 401 · Salters, SCThe pilot's decision to attempt a low-altitude aerobatic maneuver in a non-aerobatic airplane, and his subsequent failure to maintain control of the airplane during the maneuver. Contributing to the accident was the pilot's impairment by the effects of…Oct 4, 2017 · N401HH · DestroyedNTSB GAA17CA581Accident · No injuriesData collectionFinal reportCessna 414 · San Jose, CAThe pilot’s failure to maintain a proper descent rate, which resulted in a hard landing.Sep 29, 2017 · N1652T · Substantial damageNTSB GAA17CA543Accident · No injuriesData collectionFinal reportCessna T210 · St George, UTThe pilot’s failure to extend the landing gear before landing.Sep 20, 2017 · N22650 · Substantial damageNTSB WPR17LA204Accident · No injuriesClass 3 · LimitedFinal reportCessna T210N · Watsonville, CAThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent nose gear separation.Sep 15, 2017 · N5391A · Substantial damageNTSB WPR17LA172Accident · No injuriesLimited investigationFinal reportCessna T210F · Llano, CAA failure of the turbocharger that resulted in complete depletion of the engine oil and catastrophic internal failure of the engine. Contributing to the accident was improper and/or incomplete maintenance and inspection of the turbocharger.Aug 1, 2017 · N6109R · Substantial damageNTSB CEN17WA291Incident · No injuriesForeign investigationCessna 402 · British Virgin Islands, British Virgin IslandsOn July 27, 2017, a Cessna 402C airplane, N618CA, exited the prepared surface during an aborted takeoff at the Terrance B. Lettsome International Airport, British Virgin Islands. The pilots and occupants were not injured and the airplane was not damaged.The…Jul 27, 2017 · N618CA · No damageNTSB GAA17CA414Accident · No injuriesData collectionFinal reportCessna TU206 · Albuquerque, NMThe pilot’s improper landing flare in gusting wind conditions, which resulted in a porpoised landing.Jul 16, 2017 · N166Z · Substantial damageNTSB GAA17CA423Accident · No injuriesData collectionFinal reportCessna T210L · Yuba City, CAThe pilot’s failure to extend the landing gear before landing.Jul 7, 2017 · N333GK · Substantial damageNTSB CEN17LA247Accident · No injuriesLimited investigationFinal reportCessna P210N · Eagle, COThe loss of engine power due to fuel starvation for reasons that could not be determined because an examination of the airplane and engine did not reveal any malfunctions or failures that would have precluded normal operation.Jun 30, 2017 · N210HG · Substantial damageNTSB GAA17CA365Accident · Minor injuriesData collectionFinal reportBeech 58 · Ingleside, TXThe pilot’s inability to avoid a collision with an unauthorized vehicle on the runway during the landing roll and the truck driver’s decision to cross the runway in front of the airplane.Jun 26, 2017 · N58SM · DestroyedNTSB ERA17FA180Accident · 2 fatalField investigationFinal reportBeech A36TC · Hopkinsville, KYThe noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident were the pilot's overreliance on his…May 12, 2017 · N1804E · DestroyedNTSB WPR17LA090Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Banning, CAThe pilot's improper energy management during an emergency landing approach that was prompted by an engine power loss. The specific reason(s) for the power loss and the improper energy management could not be determined based on available evidence.Apr 24, 2017 · N6218Y · Substantial damageNTSB WPR17IA086Incident · No injuriesClass 3 · IncidentFinal reportBeech A36TC · Livermore, CAA mistrim condition while the autopilot was engaged for reasons that could not be determined based on available evidence, and the pilot’s subsequent failure to confirm the command bar status before disengaging the autopilot. Contributing to the accident were…Apr 10, 2017 · N755R · Minor damageNTSB WPR17FA085Accident · 4 fatalField investigationFinal reportPiper PA 46-310P · Harrisburg, ORAn encounter with a downburst during an instrument approach, which resulted in a loss of control at low altitude. Contributing to the accident was the air traffic controller's failure to solicit and disseminate pilot reports from arriving and departing…Apr 7, 2017 · N123SB · DestroyedNTSB ERA17LA151Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Atlanta, GAThe pilot's diverted attention during the landing approach, which resulted in his failure to configure the landing gear and a subsequent a gear-up landing.Apr 7, 2017 · N56H · Substantial damageNTSB GAA17CA221Accident · No injuriesData collectionFinal reportCessna P210 · Granby, COThe pilot's failure to extend the landing gear before landing.Apr 6, 2017 · N829BA · Substantial damageNTSB CEN17LA148Accident · No injuriesLimited investigationFinal reportCessna T210M · Detroit Lakes, MNThe malfunction of the right main landing gear actuator for reasons that could not be determined because postaccident examination revealed no mechanical anomalies that would have precluded normal operation. Contributing to the accident was the improper…Apr 5, 2017 · N1215M · Substantial damageNTSB ERA17FA136Accident · 4 fatalField investigationFinal reportCessna T210 · Hayden, ALThe pilot's decision to continue the flight into known adverse weather conditions, which resulted in spatial disorientation and a subsequent loss of airplane control and in-flight breakup.Mar 25, 2017 · N6563D · DestroyedNTSB WPR17FA066Accident · 4 fatalField investigationFinal reportCessna T310Q · Riverside, CAThe pilot's failure to maintain airplane control upon entering instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's personal pressure…Feb 28, 2017 · N1246G · DestroyedNTSB CEN17CA114Accident · No injuriesData collectionFinal reportCessna 340A · Waukesha, WIThe pilot’s decision to fly in in conditions conducive to structural icing and her subsequent failure to maintain airplane control during the instrument approach.Feb 25, 2017 · N255BC · Substantial damageNTSB WPR17LA064Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Stevensville, MTThe pilot's decision to conduct a takeoff with a tailwind on an upsloping runway in an overweight airplane, which resulted in the airplane having insufficient energy to climb out of ground effect.Feb 23, 2017 · N3803J · Substantial damageNTSB GAA17CA131Accident · Minor injuriesData collectionFinal reportCessna T210 · Loveland, COThe pilot's exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.Feb 5, 2017 · N4853U · Substantial damageNTSB ERA17LA098Accident · Minor injuriesLimited investigationFinal reportCessna P210 · Pottsville, PAA total loss of engine power for reasons that could not be determined because postaccident examinations of the engine and airframe did not reveal any preimpact mechanical malfunctions or failures that would have precluded normal operation.Jan 30, 2017 · N4796P · Substantial damageNTSB WPR17LA053Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Buckeye, AZThe pilot's failure to maintain directional control of the airplane during the landing roll.Jan 14, 2017 · N6366B · Substantial damageNTSB CEN17FA045Accident · 1 fatalField investigationFinal reportCessna 340 · Fargo, NDThe loose fuel fitting on the combustion heater that leaked a lean fuel-air mixture into the nose baggage compartment. The mixture was most likely ignited by the combustion heater, blowing off the nose baggage compartment doors and starting an in-flight fire.Dec 1, 2016 · N123KK · DestroyedNTSB CEN17LA039Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Pleasanton, TXMaintenance personnel's improper installation of the throttle linkage attachment hardware, which resulted in a partial loss of engine power when the hardware separated in flight.Nov 13, 2016 · N44C · Substantial damageNTSB CEN17LA022Accident · No injuriesLimited investigationFinal reportCessna T210L · Pflugerville, TXLanding gear collapse upon landing due to a hydraulic leak that led to insufficient pressure to fully extend and lock the gear in a down position.Oct 18, 2016 · N210LC · Substantial damageNTSB CEN16RA399Accident · No injuriesForeign investigationCessna P210N · Guatemala City, GuatemalaOn September 13, 2016, about 1600 UTC, a Cessna turbo P210N, N210BC, owned and operated by a private individual lost engine power in cruise flight and impacted on a road near Guatemala City, Guatemala. The pilot on board was not injured. The airplane…Sep 13, 2016 · N210BC · Substantial damageNTSB CEN16FA361Accident · 1 fatalField investigationFinal reportPiper PA 46-310P · Chariton, IAThe non-instrument-rated pilot's loss of control due to spatial disorientation in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations and a subsequent in-flight breakup. Contributing to the…Sep 7, 2016 · N465JM · Substantial damageNTSB GAA16CA445Accident · No injuriesData collectionFinal reportCessna T207 · Nanwalek, AKThe pilot’s unstabilized approach and a subsequent runway overrun while landing on a short runway in variable wind conditions.Aug 23, 2016 · N91025 · Substantial damageNTSB CEN16LA356Accident · No injuriesLimited investigationFinal reportCessna P210N · Waco, TXThe failure of the right main landing gear (MLG) down-lock mechanism, which resulted in the collapse of the landing gear. The root cause of the right MLG down-lock mechanism could not be determined because the components were not available for examination.Aug 5, 2016 · N323DC · Substantial damageNTSB ERA16FA279Accident · 1 fatalField investigationFinal reportCessna 414 · Destin, FLThe pilot's loss of control due to spatial disorientation shortly after takeoff, while maneuvering over water during dark night conditions.Aug 3, 2016 · N2735A · DestroyedNTSB GAA16CA390Accident · No injuriesData collectionFinal reportPiper PA46 · Claremore, OKThe pilot's failure to maintain directional control during takeoff after multiple climb attempts at insufficient airspeed, which resulted in a runway excursion, a landing gear collapse, and a collision with a ditch.Jul 22, 2016 · N9111P · Substantial damageNTSB WPR16LA171Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Schafer Meadows, MTA loss of directional control while landing, which resulted in a runway excursion and landing gear collapse for reasons that could not be determined.Jun 26, 2016 · N455TB · Substantial damageNTSB CEN16FA224Accident · 3 fatalField investigationFinal reportCessna 320E · Creede, COThe pilot's loss of airplane control during descent following a loss of engine power for reasons that could not be determined because postaccident examinations and engine test-runs of both engines revealed no evidence of any mechanical malfunctions or…Jun 15, 2016 · N777GY · DestroyedNTSB GAA16CA337Accident · No injuriesData collectionFinal reportCessna T210 · Buena Vista, COThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and substantial damage to the firewall.Jun 9, 2016 · N9915Y · Substantial damageNTSB CEN16FA188Accident · 1 fatalField investigationFinal reportCessna P210N · Sheridan Lake, COThe pilot's severe impairment from the combined effects of high levels of ingested alcohol as well as three impairing medications (zolpidem, lorazepam, and diphenhydramine), which resulted in his decision to attempt an aerobatic maneuver that the airplane was…May 18, 2016 · N6609P · Substantial damage