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.
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" 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 WPR22LA060Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Hillsboro, ORThe on-ground collision with a tree during an off airport precautionary landing. Contributing was the partial loss of engine power for undetermined reasons.NTSB CEN22LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Cassville, MOThe pilot’s failure to reinstall the nose landing gear linkage prior to the flight which resulted in a loss of directional control during landing.NTSB CEN22LA039Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36TC · Rockport, TXThe total loss of engine power for reasons that could not be determined based on available evidence.NTSB GAA22WA029Accident · 1 fatalClass 5 · ForeignCessna P210N · Dornbirn, AustriaNTSB CEN22FA021Accident · 1 fatalClass 3 · FieldFinal reportBeech B36TC · Lena, WIImpairment and subsequent incapacitation of the pilot for reasons that could not be determined. The incapacitation resulted in a loss of engine power due to fuel starvation. Likely contributing was pilot hypoxia due to altitude exposure, possibly worsened by…NTSB WPR22FA004Accident · 2 fatalClass 3 · FieldFinal reportCessna 340A · Santee, CALoss of control due to spatial disorientation.NTSB CEN22FA011Accident · 1 fatalClass 3 · FieldFinal reportBeech 58TC · Mesa, COThe maintenance personnel’s failure to properly tighten the turbocharger oil line and the right engine propeller governor, which resulted in a loss of engine power. Contributing to the accident was the loss of airplane control following the loss of engine…NTSB CEN21LA472Accident · No injuriesClass 3 · LimitedFinal reportCessna T210N · East Sparta, OHA total loss of engine power due to a fatigue failure of the No. 2 cylinder exhaust valve.NTSB CEN21LA460Accident · No injuriesClass 4 · LimitedFinal reportCessna P210N · El Paso, TXA faulty landing gear pressure switch prematurely deactivated the landing gear motor during extension, which resulted in the landing gear collapsing during rollout.NTSB WPR21LA350Accident · No injuriesClass 3 · LimitedFinal reportCessna 404 · Sheridan, WYThe pilot experiencing an episode of impaired behavior and incapacitation for reasons that could not be determined based on the available information.NTSB WPR21LA342Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 58 · Palo Alto, CAThe fuelers addition of the incorrect fuel to the fuel tanks which resulted in a total loss of engine power.NTSB ERA21FA354Accident · Serious injuriesClass 3 · FieldFinal reportCessna 402C · Provincetown, MAThe pilot’s delayed decision to perform an aborted landing late in the landing roll with insufficient runway remaining. Contributing to the accident was the pilot’s failure to execute a go-around once the approach became unstabilized, per the operator’s…NTSB WPR21FA330Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Bernard, IDThe pilot’s decision to continue the flight into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees an terrain.NTSB WPR21LA345Accident · No injuriesClass 4 · LimitedFinal reportCessna 340 · Rock Springs, WYThe pilot’s improper pitch control during takeoff which resulted in an aerodynamic stall and subsequent hard landingNTSB WPR21LA292Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 180K · Mt. Hood, ORThe total loss of engine power while in cruise flight for reasons that could not be determined based on available evidence. Contributing to the accident was the presentation of an abandoned airport as available for use in the Federal Aviation Administration…NTSB CEN21LA323Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Refugio, TXThe pilot’s failure to maintain directional control during the landing roll with a tailwind.NTSB WPR21LA287Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36TC · Chandler, AZThe pilot’s delayed decision to abort the takeoff due to insufficient airspeed.NTSB CEN21LA271Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T210L · Buena Vista, COThe partial loss of engine power due to a vane failure in the engine-driven fuel pump.NTSB CEN21FA207Accident · 1 fatalClass 3 · FieldFinal reportCessna T210M · Oxford, IAThe pilot’s loss of directional control during landing in gusting crosswind conditions that exceeded the airplane’s capability and his decision to attempt to takeoff from a field, which resulted in collision with a power pole/line and terrain.NTSB CEN21FA198Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-46-310P · Danville, ARThe pilot’s improper decision to continue flight in an area of moderate-to-heavy icing conditions, which resulted in exceedance of the airplane’s anti-icing system capabilities, a degradation of aircraft performance, and subsequent aerodynamic stall.NTSB ERA21LA197Accident · No injuriesClass 4 · LimitedFinal reportCessna 402C · New Bedford, MAAn inadvertent collision with a bird during descent, resulting in substantial damage to the vertical stabilizer.NTSB ERA21LA159Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Marianna, FLThe failure of the alternator control unit housing plug connection, which resulted in insufficient battery power to fully extend the landing gear. Contributing to the accident was the pilot’s decision to not use the emergency gear extension handle to secure…NTSB WPR21LA131Accident · No injuriesClass 3 · LimitedFinal reportCessna T210M · Leadore, IDThe pilot’s failure to attain the proper touchdown point on a graveled surfaced runway with insufficient landing performance and subsequent loss of control during the landing roll.NTSB ERA21LA147Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Johnstown, NYA failure of the landing gear system hydraulic pump assembly for reasons that could not be determined based on available evidence. Contributing was the pilot’s failure to confirm that the landing gear was down and locked before landing.NTSB GAA21WA026Accident · No injuriesClass 5 · ForeignCessna 340A · Toulouse, FranceNTSB WPR21LA078Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Moab, UTThe pilot’s improper application of full throttle during takeoff, which resulted in loss of engine power due to an excessive fuel flow and overly rich fuel mixture.NTSB WPR21LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206 · Twentynine Palms, CAThe pilot’s decision to takeoff with a known mechanical engine anomaly, and the failure of the No. 2-cylinder exhaust valve, which resulted in a total loss of engine power during the initial climb and subsequent impact with terrain.NTSB CEN21WA093Accident · No injuriesClass 4 · ForeignCessna 401B · Toussus-le-Noble, FranceNTSB ERA21LA011Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 414 · West Palm Beach, FLThe pilot’s inadequate preflight inspection during which he failed to detect a flight control abnormality, and his failure to expediently abort the takeoff, which resulted in the co-pilot performing a delayed aborted takeoff and the subsequent runway overrun.NTSB WPR20LA325Accident · No injuriesClass 4 · LimitedFinal reportCessna T210 · Bridgeport, CAAn inadvertent retraction of the flaps during a go-around by the pilot-rated passenger, which caused the airplane to settle onto the runway with the landing gear retracted.NTSB CEN20LA402Accident · 4 fatalClass 3 · LimitedFinal reportPiper PA46 · Hilltop Lakes, TXThe loss of engine power for reasons that could not be determined and the pilot’s failure to maintain control of the airplane which resulted in an aerodynamic stall and spin. Contributing to the accident was the pilot’s failure to establish and maintain a…NTSB CEN20LA378Accident · No injuriesClass 3 · LimitedFinal reportCessna 340 · Oklahoma City, OKA failure of the windscreen for reasons that could not be determined based on available evidence.NTSB WPR20LA291Accident · Minor injuriesClass 3 · LimitedFinal reportCessna TU206 · Tusayan, AZA total loss of engine power due to fuel starvation as a result of contamination in the airplane’s fuel system.NTSB CEN20LA365Accident · 1 fatalClass 3 · LimitedFinal reportCessna T210 · Peyton, COThe pilot’s failure to maintain adequate airspeed and the exceedance of the airplane’s critical angle of attack during the airplane’s turn to final, resulting in an aerodynamic stall.NTSB WPR20LA258Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Hanna, UTThe pilot’s failure to maintain sufficient airspeed after a partial loss of power for undetermined reasons, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall from which the pilot could not recover.NTSB ERA20LA278Accident · Serious injuriesClass 3 · LimitedFinal reportCessna P210 · Allendale, SCA total loss of engine power as a result of fuel starvation due to contamination from a thermoplastic polymer used in the fuel system. Contributing to the accident was the pilot’s failure to report debris observed in the fuel system during previous preflight…NTSB CEN20LA271Accident · 1 fatalClass 3 · LimitedFinal reportCessna T188 · Dustin, OKThe pilot’s continued takeoff without ensuring obstacles could be avoided due to his use of a sedating medication, which likely diminished his reaction time and flying performance.NTSB WPR20FA206Accident · 8 fatalClass 3 · FieldFinal reportCessna TU206 · Coeur d'Alene, IDThe failure of the pilots of both airplanes to see and avoid the other airplane.NTSB WPR20CA184Accident · No injuriesClass 4 · Data collectionFinal reportCessna P210 · Maricopa, AZThe pilot's failure to extend the airplane’s retractable landing gear before landing.NTSB CEN20CA229Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna T188 · McCurtain, OKThe pilot's failure to maintain the proper airspeed during a low altitude aerial application maneuver and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodymanic stall at too low of an altiutde to recover.NTSB WPR20CA158Accident · No injuriesClass 4 · Data collectionFinal reportCessna P210 · Heber City, UTThe pilots failure to switch the fuel pump to the 'OFF' position during landing, resulting in a loss of engine power and subsequent collision with a fence during landing. Contributing to the accident was a modified before landing checklist which omitted the…NTSB CEN20LA179Accident · 1 fatalClass 3 · LimitedFinal reportCessna P210 · Burlington, WIThe pilot did not maintain a safe altitude during the visual approach, and subsequently lost control which resulted an impact with trees and terrain.NTSB ERA20CA176Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 402 · Hampton, GAA dual total loss of engine power as a result of fuel exhaustion.NTSB CEN20LA172Accident · 1 fatalClass 3 · LimitedFinal reportCessna T210L · Burleson, TXThe loss of engine power due to fuel starvation.NTSB WPR20LA123Accident · 1 fatalClass 3 · LimitedFinal reportCessna TU206 · Auburn, CAThe total loss of engine power after takeoff due to water contamination of the fuel.NTSB CEN20LA149Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Kirksville, MOA loss of engine power after takeoff for undetermined reasons.NTSB CEN20LA132Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Waxahachie, TXThe partial loss of engine power due to water and contaminants in the fuel, due to the pilot’s inadequate preflight inspection, and the pilot’s decision to conduct a steep turn at low altitude to return to the runway rather than land straight ahead, which…NTSB WPR20LA101Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Needles, CAA loss of engine power for undetermined reasons due to a lack of available evidence.NTSB ERA20FA118Accident · 3 fatalClass 3 · FieldFinal reportPiper PA46 · Bishop, GAThe pilot’s encounter with a rain shower updraft and severe turbulence, which resulted in a loss of airplane control and an inflight breakup. Contributing to the accident was the pilot’s reliance on outdated weather information on his in-cockpit weather…NTSB ERA20CA112Accident · Minor injuriesClass 4 · Data collectionFinal reportBeech 58 · Augusta, GAThe pilot's failure to land and stop the airplane within the available runway, which resulted in a runway overrun. Contributing to the outcome was the pilot's inadvertent feathering of both propellers during approach to landing.