NTSB investigations: Continental GTSIO-520-C
332 cases on aircraft whose registry engine model is Continental GTSIO-520-C. 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 ('17035'))
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 ('17035'))
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 CHI07FA060Accident · Minor injuriesField investigationFinal reportBeechcraft BE99 · Milwaukee, WIThe failure of both pilots to adequately scan for and avoid other aircraft traffic during taxi operations, and the failure of Air Traffic Control to issue a traffic advisory to both of the pilots. A contributing factor to the accident was the night time light…NTSB MIA07FA029Accident · 5 fatalField investigationFinal reportCessna 421B · Greenhead, FLThe pilot-in-command's improper planning/decision and continued flight into known adverse weather which resulted in an encounter with a level 5 thunderstorm.NTSB DFW07CA038Accident · No injuriesData collectionFinal reportCessna 421 · Brackettville, TXThe pilot's failure to maintain proper runway alignment on final approach and his delayed decision to execute a go-around. Factors were the dark night conditions and the inoperative runway edge lights.NTSB LAX07FA035Accident · 3 fatalField investigationFinal reportCessna 421B · Big Bear Lake, CAFailure of the turbine wheel shaft in the left turbocharger during the takeoff initial climb for undetermined reasons, and the pilot's failure to attain and maintain safe single engine airspeed that led to a loss of control.NTSB NYC06FA209Accident · 7 fatalField investigationFinal reportCessna 401A · Whick, KYThe non-instrument-rated pilot's continued flight into instrument meteorological conditions, and his subsequent failure to maintain airspeed which resulted in an inadvertent stall. Contributing was the instrument meteorological conditions.NTSB DEN06FA114Accident · Serious injuriesField investigationFinal reportCirrus Design SR20 · Kremmling, COThe pilot's failure to properly execute the published missed approach procedure resulting in an impact with mountainous terrain. Contributing factors were the pilot's attempted flight into known adverse weather conditions, failure to obtain the UNICOM…NTSB CHI06CA177Accident · Minor injuriesData collectionFinal reportCessna T210G · Pontiac, ILA loss of engine power due to the pilot's improper in-flight planning which led to fuel exhaustion and his failure to maintain an adequate airspeed during the landing approach which resulted in an inadvertent stall. The road embankment was a factor.NTSB ANC06LA069Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Jacksonville, FLAn undetermined event during takeoff/initial climb, which resulted in an emergency landing after takeoff and substantial damage to the airplane.NTSB MIA06LA105Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Marathon, FLThe pilot's failure to extend the landing gear prior to landing, which resulted in the propellers striking the runway, an aborted landing, and an in-flight collision with terrain.NTSB SEA06CA027Accident · Minor injuriesData collectionFinal reportCessna TP206A · Snohomish, WAThe pilot's higher than normal airspeed on landing which resulted in a runway overrun. Contributing factors were the fog and the wet runway surface.NTSB NYC06FA015Accident · 1 fatalField investigationFinal reportCessna 411 · East Hampton, NYThe pilot's failure to maintain airspeed, while maneuvering with the left engine inoperative. Contributing to the accident were the failure of the left engine, and the pilot's lack of multiengine certification.NTSB DEN05FA074Accident · 4 fatalField investigationFinal reportCessna T210G · Ouray, COthe pilot's inadvertent flight into adverse weather conditions, loss of control, and resulting exceedence of the design stress limits of the aircraft. which led to an in-flight structural failure. Factors in the accident included the pilot's inadequate…NTSB LAX05LA130Accident · No injuriesLimited investigationFinal reportCessna 421B · Lake Havasu Cit, AZthe fracture of the landing gear shaft roll pin that resulted in a main gear collapse during the taxi.NTSB DEN05FA038Accident · 3 fatalField investigationFinal reportCessna 421 · Englewood, COloss of engine power due to fuel starvation, and the instructor's failure to maintain aircraft control. Contributing factors were a partially blocked fuel line resulting in restricted fuel flow, the instructor's failure to perform critical emergency…NTSB LAX05FA041Accident · 2 fatalField investigationFinal reportCessna 411 · Corona, CAA loss of engine(s) power for undetermined reasons. Also causal was the pilot's failure to maintain the airplane's minimum controllable airspeed (Vmc) during the initial climb following a loss of power in one engine, which resulted in a loss of aircraft…NTSB LAX05CA001Accident · No injuriesData collectionFinal reportCessna TU206A · Nogales, AZthe pilot's failure to remain on the designated taxiway surface, which resulted in the airplane's collision with the ditch. The dark lighting condition was a factor to the accident.NTSB CHI04LA264Accident · Minor injuriesLimited investigationFinal reportCessna 401 · New Century, KSA loss of engine power due to fuel starvation and the pilot's failure to maintain directional control during approach to an alternate airport. Contributing to the accident was the pilot's failure to obtain a weather briefing, his flight into adverse weather,…NTSB LAX04LA284Accident · No injuriesLimited investigationFinal reportCessna 206 · Truckee, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control of the airplane.NTSB FTW04LA195Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Columbus, TXthe pilot's failure to maintain directional control during the takeoff roll and abort the attempted takeoff.NTSB DEN04CA096Accident · Minor injuriesData collectionFinal reportCessna T210J · Cheyenne, WYthe detachment of the nut and bolt that attaches the throttle control cable to the fuel induction due to improper maintenance. Contributing factors were the fiber optics wire, fence, and ditch, and the unavailability of suitable terrain on which to make a…NTSB IAD04LA029Accident · No injuriesLimited investigationFinal reportCessna 421B · Portland, MEFailure of the right main landing gear down-lock mechanism resulting in the collapse of the right main landing gear.NTSB LAX04FA031Accident · 5 fatalField investigationFinal reportCessna 421B · Kelso, CAThe pilot's continued VFR flight into instrument conditions between cloud layers and with reduced visibility due to smoke that resulted in an in-flight loss of control from spatial disorientation, and the structural overload of the airframe during the…NTSB LAX03FA147Accident · 1 fatalField investigationFinal reportCessna 411 · Corona, CAThe failure of the pilot to properly configure the airplane for a one engine inoperative condition (including his failure to feather the propeller of the affected engine, retract the landing gear, and maintain minimum single engine speed). Factors related to…NTSB LAX03LA121Accident · Serious injuriesLimited investigationFinal reportBeech V35A · North Las Vegas, NVFuel starvation due to the pilot's mismanagement of his fuel supply and failure to verify the fuel quantity onboard prior to departure.NTSB ATL03FA062Accident · 1 fatalField investigationFinal reportCessna 320D · Perry, GAThe pilot continued visual flight into instrument meteorological conditions, and his failure to maintain altitude/terrain clearance.NTSB LAX03LA106Accident · No injuriesLimited investigationFinal reportCessna 421C · Crescent City, CAThe separation of the upper and lower right main landing gear scissor links due to improper maintenance, which resulted in a ground loop, and the collapse of the right main landing gear during the landing roll.NTSB IAD03FA032Accident · 3 fatalField investigationFinal reportCessna 421 · Ferguson, KYThe pilot's failure to follow the instrument approach procedure, which resulted in an early descent into trees and terrain. Factors included the low ceiling and the night lighting conditions.NTSB NYC03FA001Accident · 1 fatalField investigationFinal reportBeagle B.206 Basset · West Carrollton, OHThe pilots inadequate preflight inspection, his operation of the airplane with an overdue annual inspection, and his failure to maintain airspeed after the failure of an engine which resulted in an inadvertent stall/spin. A factor related to the accident was…NTSB FTW02LA269Accident · No injuriesLimited investigationFinal reportCessna 421B · Mineral Wells, TXThe pilot's failure to maintain a proper descent rate which resulted hard landing and a subsequent failure of the main landing gear.NTSB MIA02FA170Accident · 1 fatalField investigationFinal reportBeagle B-206 Series 2 · McAlpin, FLthe pilot's failure to maintain an adequate airspeed to sustain controlled flight, which resulted in an inadvertent stall during a turn from base to final. A contributing factor was the pilot's use of judgment and performance impairing drugs.NTSB FTW02LA261Accident · No injuriesLimited investigationFinal reportBeech V35 · Del Rio, TXThe loss of engine power due to the low-pressure pump separating internally. Contributing factors were the deterioration of the fuel pump and the lack of suitable terrain for the forced landing.NTSB LAX02LA238Accident · No injuriesLimited investigationFinal reportCessna T210F · Willits, CAthe student pilot's misjudged, distance, and speed, and failure to attain the proper touchdown point.NTSB CHI02LA117Accident · Serious injuriesLimited investigationFinal reportCessna 411 · Lee's Summit, MOThe pilot failed to maintain control of the airplane during the inital takeoff climb. Factors associated with the accident were the pilot's inadequate preflight of the airplane, the separation of the emergency exit, and the pilot's lack of a multi-engine…NTSB ATL01FA109Accident · 1 fatalField investigationFinal reportCessna T-210F · Hendersonville, NCThe pilot's failure to follow the air traffic controllers verbal instructions pertaining to heading and minimum safe vectoring altitude while being vectored for an ILS approach to his destination airport. This resulted in an in-flight collision with trees and…NTSB MIA01WA179Accident · No injuriesForeign investigationCessna 402 · Walker Cay, BahamasNTSB FTW01FA033Accident · 2 fatalField investigationFinal reportCessna 421B · Norman, OKthe pilot's failure to follow the instrument approach procedure and his continued descent below the prescribed minimum descent altitude (MDA). Contributory factors were the pilot's physical impairment from drugs, the low ceiling, fog, and dark night light…NTSB FTW01LA002Accident · Serious injuriesLimited investigationFinal reportCessna 401A · Andrews, TXThe hard landing due to the pilot's excessive rate of descent. A factor was the loss of engine power due to fuel starvation as a result of the pilot's improper positioning of the fuel selectors.NTSB MIA00LA225Accident · No injuriesLimited investigationFinal reportCessna 421A · Homewood, MSThe inadequate installation of the right propeller by the mechanic for his failure to properly torque the eight nuts resulting in fatigue failure of the studs and separation of the right propeller during cruise flight. Findings in the investigation were 1)…NTSB FTW00LA019Accident · No injuriesLimited investigationFinal reportCessna TU206A · Jeanerette, LAThe total loss of power for undetermined reasons and the pilot's failure to maintain airspeed, while clearing a ditch during a forced landing, resulting in an inadvertent stall. A factor was the ditch.NTSB LAX00LA004Accident · No injuriesLimited investigationFinal reportCessna 421B · Montague, CAThe collapse of the left main landing gear during the landing rollout for undetermined reasons, which resulted in the pilot's loss of directional control.NTSB NYC00FA001Accident · Serious injuriesField investigationFinal reportCessna 401B · Caldwell, NJThe pilot's inadequate preflight, which resulted in an attempted takeoff with the pitot covers installed. An additional cause was the pilot's delayed decision to abort the takeoff, while factors included the misleading airspeed indications, and the proximity…NTSB DEN99LA138Accident · No injuriesLimited investigationFinal reportCessna TU206A · Durango, COA worn landing nose gear steering system that diminished the ability to steer the airplane. Factors were improper maintenance by unknown persons, and loose gravel.NTSB DEN99LA127Accident · No injuriesLimited investigationFinal reportCessna T210F · Albuquerque, NMThe pilot's inadvertent wheels up landing.NTSB LAX99FA225Accident · Minor injuriesField investigationFinal reportCessna 402A · Van Nuys, CAThe pilot's inadequate fuel management that resulted in fuel exhaustion and the subsequent collision with vehicles during a forced landing on a city street.NTSB SEA99FA041Accident · 2 fatalField investigationFinal reportCessna 421B · North Bend, ORA delayed aborted takeoff for an undetermined reason.NTSB FTW99LA029Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Monroe, LAThe pilot's spatial disorientation which resulted in a loss of aircraft control. Factors were fog, low ceilings, and dark night conditions.NTSB FTW98FA319Accident · Minor injuriesField investigationFinal reportCessna T-310P · Colorado Sprngs, COThe separation of a portion of the right engine exhaust stack, and the ensuing fuel fire in the right engine nacelle.NTSB FTW98FA216Accident · 3 fatalField investigationFinal reportBeagle B-206 · Vernon, TXThe pilot's failure to maintain the airplane's minimum controllable airspeed following a loss of left engine power after takeoff, which resulted in a loss of control. Contributing factors were the fractured exhaust valve guide on the left engine's # 2…NTSB MIA98WA157Accident · Serious injuriesForeign investigationCessna 421B · Nassau, BahamasNTSB LAX98LA121Accident · No injuriesLimited investigationFinal reportCessna 421B · Show Low, AZThe pilot's failure to attain the proper alignment on the runway due to the obscuration by snow of the runway and on the airplane's windows.