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 DFW08LA029Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Midland, TXThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the prevailing tailwind and an airport sign.NTSB SEA08LA021Accident · 3 fatalLimited investigationFinal reportCessna 340 · Garberville, CAThe pilot's intentional visual flight rules (VFR) flight into instrument meteorological conditions (IMC), and his failure to maintain clearance from the trees and terrain during climb. Contributing to the accident were the weather conditions of fog and a low…NTSB DEN08CA023Accident · Minor injuriesData collectionFinal reportCessna TP206A · Boulder, COThe pilot's misjudgment of altitude. Contributing factors in this accident were the pilot's intentional low airspeed, his failure to execute a go-around, and the soft terrain.NTSB MIA08LA009Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Atlanta, GAA misalignment of the nose landing gear wheel assembly during landing for undetermined reasons.NTSB CHI08CA009Accident · No injuriesData collectionFinal reportCessna Turbo Centurion T210 · Festus, MOThe deer on the runway during the airplane landing rollout.NTSB DEN07FA165Accident · 1 fatalField investigationFinal reportCessna T210M · Moriarty, NMthe instructor pilot's failure to maintain aircraft control during aborted landing and attempted go-around which resulted in an inadvertent elevator trim stall. Contributing to the accident were the instructor pilot's inadequate supervision during the…NTSB SEA07FA262Accident · 3 fatalField investigationFinal reportBeech A-36TC · Burlington, WAThe pilot's decision to descend below the published minimum descent altitude (MDA), and his failure to maintain clearance from vertical objects during an instrument approach. Contributing to the accident were low ceilings, inadequate preflight planning, and…NTSB DEN07LA156Accident · No injuriesLimited investigationFinal reportCessna 402B · Hobbs, NMThe failure of the left main landing gear down lock due to overload causing the main landing gear to collapse.NTSB LAX07CA261Accident · Minor injuriesData collectionFinal reportCessna T210N · San Jose, CAThe pilot's mismanagement of the fuel supply that resulted in fuel starvation.NTSB NYC07LA197Accident · No injuriesLimited investigationFinal reportCessna T210N · Old Bridge, NJThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation during approach.NTSB MIA07LA133Accident · Serious injuriesLimited investigationFinal reportBeech B36TC · Clearwater, FLThe pilot's improper rotation and climb during the takeoff which resulted in a stall/mush, a descent, and an impact with the ground.NTSB SEA07LA209Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Nampa, IDThe total loss of engine power for an undetermined reason. Factors include a power transmission line between the point were the aircraft lost power and the runway that the pilot was attempting to reach.NTSB DEN07LA135Accident · No injuriesLimited investigationFinal reportCessna T188C · Colby, KSThe pilot's failure to maintain directional control during the take-off roll resulting in a ground loop.NTSB SEA07TA203Accident · No injuriesFinal reportCessna TU206G · New Meadows, IDThe loss of engine power due to the loss of engine oil pressure following the oil pump's drive shaft failure for an undetermined reason. Contributing factors were the lack of suitable terrain for a forced landing and the rough/uneven terrain.NTSB MIA07WA114Accident · Serious injuriesForeign investigationCessna T210H · McLean's Town, BahamasNTSB DEN07CA116Accident · No injuriesData collectionFinal reportCessna T210N · Loveland, COThe pilot's failure to lower the landing gear. Contributing factors were the pilot's attention being diverted, and his failure to use the BEFORE LANDING checklist.NTSB CHI07FA176Accident · 1 fatalField investigationFinal reportBeech A36TC · Cannon Falls, MNThe pilot's continued flight into instrument meteorological conditions, which resulted in spatial disorientaton and loss of control.NTSB DEN07CA104Accident · No injuriesData collectionFinal reportBeech B36TC · Hudson, COThe pilot's improper in-flight decision, and his failure to maintain proper aircraft control during takeoff resulting in an inadvertent stall and the subsequent impact with the runway and terrain.NTSB SEA07LA156Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Ludlow, CAThe loss of engine power from both engines due to fuel starvation resulting from the pilot's improper fuel tank selector position. Contributing factors were the pilot's inadequate preflight inspection and the lack of suitable terrain for the forced landing.NTSB SEA07LA166Accident · No injuriesLimited investigationFinal reportCessna T188C · Rock Springs, MTThe failure of the left main landing gear due to fatigue.NTSB SEA07CA146Accident · No injuriesData collectionFinal reportCessna T210N · Bakersfield, CAThe pilot's improper flare, which resulted in a loss of directional control. Factors included the crosswind and gusty wind condition.NTSB LAX07CA182Accident · No injuriesData collectionFinal reportCessna 340A · Chandler, AZfuel starvation due to the pilot's failure to adequately manage and monitor his fuel supply.NTSB LAX07LA179Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Napa, CAFailure of the number 5 connecting rod due to oil starvation.NTSB LAX07CA159Accident · No injuriesData collectionFinal reportCessna T210L · The Dalles, ORThe pilot's failure to extend the landing gear.NTSB SEA07FA124Accident · 1 fatalField investigationFinal reportCessna P210N · Spanish Fork, UTAn engine oil line leak and subsequent engine compartment fire while in cruise flight.NTSB CHI07LA135Accident · No injuriesLimited investigationFinal reportCessna 414A · Sturgeon Bay, WIWorn brakes which resulted in an overrun during landing. A fence was a factor.NTSB LAX07LA143Accident · Serious injuriesLimited investigationFinal reportBeech B36TC · West Athens, CAthe pilot's descent below the published minimum descent altitude for the instrument approach procedure, which resulted in a collision with wires and terrain. Contributing to the accident were the pilot's lack of recent experience in the accident airplane and…NTSB MIA07LA073Accident · 2 fatalLimited investigationFinal reportPiper PA-46-310P · Bird Cay, BahamasThe pilot's poor in-flight weather evaluation, which resulted in flight into a level 6 thunderstorm.NTSB LAX07LA136Accident · No injuriesLimited investigationFinal reportCessna T210N · Oakland, CACollapse of the landing gear for undetermined reasons.NTSB SEA07LA081Accident · No injuriesLimited investigationFinal reportCessna T210N · Livermore, CAThe pilot's failure to maintain clearance from another aircraft holding on the taxiway while taxiing from landing. The pilot's inadequate visual lookout was a factor.NTSB LAX07CA110Accident · No injuriesData collectionFinal reportCessna T210N · Barstow, CAThe pilot's failure to properly execute the manual landing gear extension procedures.NTSB DFW07LA082Accident · No injuriesLimited investigationFinal reportCessna T210R · Boerne, TXThe pilot of the other airplane's failure to maintain proper spacing during approach to landing and subsequent go-around, which resulted in a midair collision.NTSB SEA07CA072Accident · No injuriesData collectionFinal reportCessna T210M · Boulder City, NVThe pilot's failure to maintain directional control of the airplane during landing, which resulted in a runway excursion.NTSB ANC07LA021Accident · No injuriesLimited investigationFinal reportCessna 402C · Cordova, AKThe failure of the right main landing gear linkage during the landing roll, which resulted in a loss of directional control and the collapse of the right main landing gear. A factor associated with the accident was the failure of company maintenance personnel…NTSB CHI07FA073Accident · 4 fatalField investigationFinal reportCessna 340A · Council Bluffs, IAThe pilot's continued flight into adverse weather, and his failure to maintain altitude during the instrument approach. Contributing factors were the presence of severe icing, moderate turbulence, and low-level wind shear.NTSB DFW07FA067Accident · 2 fatalField investigationFinal reportCessna 414 · Rocksprings, TXThe pilot's failure to maintain clearance with terrain. Contributing factors were the below approach/landing minimums weather and the drizzle/mist weather conditions.NTSB CHI07LA064Accident · No injuriesLimited investigationFinal reportCessna 414A · Dickinson, NDThe undetermined failure of the emergency landing gear system and the retraction of the right main landing gear during landing.NTSB ATL07FA036Accident · 1 fatalField investigationFinal reportCessna T210M · Haddock, GALoss of engine power for undetermined reasons.NTSB DFW07CA059Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Madison, MSThe loss of engine power due to water contamination in the fuel system. A factor was the muddy terrain.NTSB CHI07CA047Accident · Minor injuriesData collectionFinal reportCessna T210L · North St. Louis, MOFuel starvation due to an inadequate fuel supply. A factor associated with the accident was the soft terrain encountered during the landing.NTSB NYC07FA051Accident · 2 fatalField investigationFinal reportCessna 414 · Johnstown, PAThe pilot's improper decision to abort the landing with a damaged airplane. Contributing to the accident were the damage from the airplane's impact with the runway, the pilot's failure to lower the landing gear prior to the landing attempt, and the in-flight…NTSB ATL07FA030Accident · 3 fatalField investigationFinal reportCessna 414A · Lawrenceville, GAThe pilot's failure to follow the instrument approach procedure. Contributing to the accident was the pilot's descent below the prescribed decision height altitude.NTSB DEN07CA039Accident · No injuriesData collectionFinal reportCessna T210M · Broomfield, COthe failure of the mechanic to comply with the required replacement schedule resulting in the failure of the hydraulic line and the resulting gear up landing.NTSB ATL07FA029Accident · 4 fatalField investigationFinal reportCessna 340A · Charleston, SCThe pilot's failure to maintain airspeed during a turn from base to final, resulting in an inadvertent stall/spin. Contributing to the accident was the impairment of the pilot due to the combination of drugs found in his toxicological report.NTSB DFW07FA042Accident · 1 fatalField investigationFinal reportCessna T210N · Austin, TXThe pilot's failure to maintain control of the airplane while executing an instrument approach for undetermined reasons.NTSB CHI07LA038Accident · No injuriesLimited investigationFinal reportBeech B36TC · Peoria, ILThe loss of engine power due to a fatigue fracture of the exhaust valve as a result of maintenance not performed by the aircraft owner, and the unsuitable terrain encountered during the forced landing.NTSB SEA07LA030Accident · No injuriesLimited investigationFinal reportCessna P210N · Burns, ORThe pilot's failure to put the landing gear down for landing.NTSB LAX07FA049Accident · Serious injuriesField investigationFinal reportBeech B36TC · Buena Park, CAa fuel starvation induced loss of engine power due to pilot's inadequate fuel system management.NTSB LAX07CA046Accident · No injuriesData collectionFinal reportCessna T210M · Las Vegas, NVfuel exhaustion due to the pilot's inadequate fuel consumption calculations and his failure to refuel the airplane during the cross-country flight,.NTSB NYC07LA036Accident · No injuriesLimited investigationFinal reportCessna T210N · Caldwell, NJThe private pilot's failure to maintain adequate altitude/clearance, and the flight instructor's failure to take remedial action. Contributing to the accident was the night light conditions.