Final NTSB investigations: Continental GTSIO-520-C
318 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.\"completionStatus\" = 'Completed'
AND 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."completionStatus" = 'Completed'
AND 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 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 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 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.NTSB ANC98FA019Accident · 1 fatalField investigationFinal reportCessna 207 · Homer, AKA fatigue failure, and partial separation of the number 6 engine cylinder head assembly, the operator's inadequate progressive inspection performed by company maintenance personnel, and the pilot's inadvertent stall during a maneuvering turn toward an…NTSB CHI97LA048Accident · Minor injuriesLimited investigationFinal reportCessna 402A · Menominee, MIice restricting normal brake system, normal braking not possible for the pilot and the pilot's poor in-flight planning. A factor was the pilot not performing a flight to an alternate destination airport.NTSB ATL96FA017Accident · 2 fatalField investigationFinal reportCessna 402A · Avon Park, FLThe failure of the pilot to maintain the proper climb rate and direction of flight following takeoff, resulting in a collision with obstacles. The reason for the loss of control and subsequent unusual attitude ground impact was not determined.NTSB ATL96LA011Accident · No injuriesLimited investigationFinal reportCessna 421 · Peachtree City, GADeer on the runway during a night landing that resulted in the collision.NTSB CHI96LA028Accident · No injuriesLimited investigationFinal reportCessna 421 · Romeo, MIthe failure of the pilot to maintain sufficient airspeed during landing, causing the inadvertent stall. A factor was the icing conditions.NTSB SEA95LA194Accident · No injuriesLimited investigationFinal reportCessna 421 · Creswell, ORthe company mechanic's failure to properly fabricate a fuel line.NTSB LAX95FA297Accident · 2 fatalField investigationFinal reportBeech D55 · Kingsburg, CAthe failure of the pilot to maintain sufficient airspeed during a simulated engine failure to avoid an inadvertent stall/spin, and inadequate supervision by the designated pilot examiner. A factor in the accident was the decision of the examiner to use an…NTSB SEA95LA174Accident · No injuriesLimited investigationFinal reportCessna T210K · Bliss, IDThe pilot's failure to properly manage the fuel system to avoid running a tank dry at a low altitude. A factor was the lack of suitable terrain for a forced landing.NTSB LAX95LA232Accident · No injuriesLimited investigationFinal reportCessna 401A · Van Nuys, CAthe failure of the wing rib web due to undetected cracking in an area of known crack development around the landing gear side brace fitting. The operator's failure to accomplish a Service Letter addressing the problem is a factor in the accident.NTSB LAX95IA011Incident · No injuriesIncident investigationFinal reportCessna 402 · Grand Canyon, AZthe fracture and failure of the left main landing gear bellcrank which jammed the landing gear in the retracted position.