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 WPR12FA139Accident · 1 fatalField investigationFinal reportBeech B36 · Panoche, CAThe pilot’s lack of situational awareness regarding the surrounding terrain while descending during dark night conditions, which resulted in controlled flight into terrain.NTSB CEN12WA178Accident · 1 fatalForeign investigationCessna T210N · Torreon, Coahuila, Mexico, MexicoOn February 25, 2012, about 1130 central standard time, a Cessna T210N, N6YY, struck high tension wires and impacted terrain near Torreon International Airport (MMTC), Torreon, Coahuila, Mexico. The commercial pilot, who was the sole occupant, was fatally…NTSB CEN12FA161Accident · 2 fatalField investigationFinal reportCessna 414A · Hayden, COThe pilot’s inadvertent stall during a missed approach. Contributing to the accident was the pilot’s operation of the airplane in forecasted icing conditions without using all of its anti-ice systems.NTSB ERA12LA164Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Clearwater, FLThe total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident testing of the engine did not reveal any malfunctions or failures that would preclude normal operation. Contributing to the accident was the…NTSB ERA12FA161Accident · 1 fatalField investigationFinal reportCessna 340A · Ocala, FLThe pilot's failure to maintain adequate airspeed and altitude on final approach, resulting in an impact with terrain short of the airport.NTSB WPR12LA097Accident · No injuriesLimited investigationFinal reportBeech 58P · Santa Ana, CAThe pilot’s failure to review or execute any applicable checklist procedures or troubleshoot or take corrective action before landing despite indications that the landing gear was not extended. Contributing to the accident were the pilot’s misunderstanding of…NTSB ERA12IA114Incident · No injuriesIncident investigationFinal reportCessna T210L · Clewiston, FLThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR12CA004Accident · No injuriesData collectionFinal reportCessna T310R · Hilo, HIA total loss of engine power during cruise flight due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB CEN11LA657Accident · No injuriesLimited investigationFinal reportCessna P210N · Longview, TXThe flight's inadvertent encounter with a rare and unforecasted mesoscale gravity wave while on base leg, which resulted in a sudden loss of altitude and subsequent collision with trees.NTSB WPR11LA434Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Saratoga, WYA loss of engine power during an attempted go-around for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR11FA430Accident · 2 fatalField investigationFinal reportCessna P210 · Tehachapi, CAThe pilot’s intentional low-altitude maneuvering and failure to maintain clearance from terrain due to distraction.NTSB WPR11CA419Accident · Minor injuriesData collectionFinal reportCessna TU206F · Bremerton, WAThe total loss of engine power as a result of fuel exhaustion due to the pilot's inadequate in-flight planning.NTSB CEN11WA603Accident · 1 fatalForeign investigationCessna TU206G · Sioux Lookout, CanadaNTSB CEN11CA620Accident · No injuriesData collectionFinal reportCessna T210M · Kremmling, COThe pilot's failure to maintain aircraft control during the landing.NTSB CEN11CA640Accident · No injuriesData collectionFinal reportCessna T210M · Cahokia, ILA failure of a spring in the main landing gear actuation system that prevented the landing gear from extending.NTSB CEN11CA586Accident · Minor injuriesData collectionFinal reportCessna TU206G · Shawno, WIThe pilot's loss of control on final approach, while maneuvering to avoid birds.NTSB WPR11LA380Accident · No injuriesLimited investigationFinal reportBeech B36TC · Lemoore, CAA loss of engine power during cruise flight due to maintenance personnel's failure to adequately torque the number 4 cylinder retaining nuts, which resulted in the in-flight separation of the cylinder.NTSB WPR11FA382Accident · 4 fatalField investigationFinal reportCessna P210N · Burley, IDThe pilot's failure to attain sufficient altitude and maintain aircraft control during a turn shortly after liftoff while operating at maximum gross weight, with a tailwind, and in high density altitude conditions.NTSB CEN11LA494Accident · No injuriesLimited investigationFinal reportCessna T210L · Columbia, MOThe collapse of the right main landing gear during landing due to a lack of component lubrication, which resulted in the failure of the landing gear to lock once extended.NTSB CEN11FA425Accident · 1 fatalField investigationFinal reportCessna T210L · Romeoville, ILA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB ERA11FA349Accident · 4 fatalField investigationFinal reportCessna T210N · Armonk, NYThe pilot's decision to depart on the flight with a suspected mechanical deficiency and his subsequent decision to fly the final approach at a reduced power setting. Contributing to the accident was the improper timing of the magneto(s) that resulted in a…NTSB CEN11CA408Accident · No injuriesData collectionFinal reportCessna TU206G · Truth or Consequences, NMThe pilot's inability to control the airplane on take off.NTSB WPR11LA363Accident · No injuriesLimited investigationFinal reportCessna 340A · Fullerton, CAThe pilot's inability to maintain directional control during landing due to the left brake's degraded performance due to oil contamination, which resulted from the fatigue failure of an oil line component.NTSB CEN11LA357Accident · No injuriesLimited investigationFinal reportCessna T210M · Pueblo, COFailure of the landing gear to fully extend due to a failed o-ring in the nose gear actuator piston and a broken seal in the emergency landing gear extension system.NTSB WPR11CA196Accident · No injuriesData collectionFinal reportCessna T188C · Palouse, WAThe pilot's inadequate evaluation of the wind conditions at takeoff and failure to maintain an adequate airspeed, which resulted in a stall and collision with terrain during the initial climb.NTSB ERA11FA233Accident · 1 fatalField investigationFinal reportCessna 402B · Biddeford, METhe pilot did not maintain minimum controllable airspeed while on final approach with a partial loss of power in the right engine, which resulted in a loss of control. Contributing to the accident was the partial loss of engine power in the right engine due…NTSB CEN11LA273Accident · No injuriesLimited investigationFinal reportCessna 414A · Aberdeen, SDThe pilot's inadequate compensation for gusty crosswinds during takeoff, which resulted in a loss of directional control.NTSB WPR11FA173Accident · 3 fatalField investigationFinal reportCessna P210 · Daggett, CAThe pilot's decision to conduct the flight into a region of reported moderate to severe turbulence and icing conditions, followed by a loss of airplane control and an aerodynamic spin from which the pilot did not recover.NTSB WPR11LA168Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Puyallup, WAThe pilots’ activation of the fuel boost pump while preparing to land, which was contrary to checklist procedures and resulted in a loss of engine power.NTSB WPR11FA170Accident · 1 fatalField investigationFinal reportCessna T310R · Butte, MTThe pilot's loss of airplane control during the missed approach for undetermined reasons. Contributing to the accident was the rapid and unforecast deterioration of the weather conditions to below the landing minimum and the pilot's decision to attempt the…NTSB WPR11LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · Santa Ana, CAThe failure of the left main landing gear due to the lack of lubrication.NTSB CEN11FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Milaca, MNThe pilot did not recover from an unusual attitude while operating in instrument meteorological conditions following a disconnect of the autopilot system for undetermined reasons. Contributing to the accident were the pilot’s lack of recent flight experience…NTSB CEN11CA132Accident · No injuriesData collectionFinal reportCessna T210L · Abilene, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11CA128Accident · No injuriesData collectionFinal reportCessna 340A · Madison, WIThe pilot's failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure to check the de-ice fluid level prior to takeoff, which resulted in the failure of the de-ice…NTSB WPR11FA073Accident · Serious injuriesField investigationFinal reportCessna T210M · Ogden, UTThe pilot did not maintain clearance from obstacles after descending below the published approach decision height when visibility was less than published approach minimums due to heavy ground fog and he did not execute a missed approach after failing to…NTSB CEN11FA075Accident · 1 fatalField investigationFinal reportHawker-Beechcraft A36 · Oklahoma City, OKThe pilot’s loss of control of the airplane during night instrument meteorological conditions, likely due to spatial disorientation.NTSB WPR11LA038Accident · No injuriesLimited investigationFinal reportCessna T210N · Baggs, WYThe failure of a connecting rod cap retaining bolt during cruise flight, which resulted in a loss of engine power.NTSB ERA11FA036Accident · 2 fatalField investigationFinal reportBeech B36TC · Rienzi, MSThe pilot's continued flight into known adverse weather conditions. Contributing to the accident was the air traffic controller's failure to provide precipitation information to the pilot as required.NTSB WPR11FA029Accident · 3 fatalField investigationFinal reportCessna 340A · Morton, WAThe pilot’s failure to arrest the excessive rate of turn into the failed engine, which resulted in a loss of control and subsequent impact with terrain. Contributing to the accident was a partial loss of engine power for reasons that could not be determined…NTSB CEN11LA034Accident · No injuriesLimited investigationFinal reportCessna T210N · Presidio, TXA loss of engine power due to fuel exhaustion for undetermined reasons.NTSB WPR11CA026Accident · No injuriesData collectionFinal reportCessna 340A · Camp Verde, AZThe pilot's misjudged approach and failure to attain the correct touchdown point, which resulted in a runway overrun.NTSB WPR10LA476Accident · No injuriesLimited investigationFinal reportCessna 310R · Great Falls, MTThe uncommanded retraction of the right main landing gear during taxi due to the failure of the landing gear extension system to move the right main gear upper side link into the locked position for undetermined reasons.NTSB CEN10LA559Accident · No injuriesLimited investigationFinal reportBeech A36TC · Snook, TXThe pilot's failure to recognize the change in wind velocity and his decision to make a downwind takeoff from the grass airstrip, which led to the airplane's degraded climb capability.NTSB WPR10FA459Accident · 2 fatalField investigationFinal reportCessna T210N · Coeur d'Alene, IDThe pilot’s continued flight into instrument meteorological conditions and failure to maintain clearance with mountainous terrain while maneuvering in an area of low cloud ceilings.NTSB ANC10CA093Accident · Minor injuriesData collectionFinal reportCessna T310R · Nome, AKThe pilot's failure to maintain clearance from terrain during a special VFR approach, resulting in a collision with terrain.NTSB CEN10CA533Accident · No injuriesData collectionFinal reportPiper PA46-310P · Farmington, NMThe pilot’s premature retraction of the landing gear and the flaps during landing. Contributing to the accident was the inadvertent dimming of the cockpit lighting, resulting in a perceived unsafe gear configuration.NTSB CEN10FA520Accident · 2 fatalField investigationFinal reportCessna T210 · Mountain Home, ARThe pilot’s decision to continue flight into a known area of heavy rain and his subsequent failure to maintain aircraft control.NTSB CEN10FA521Accident · No injuriesField investigationFinal reportCessna P210N · Caledonia, MIA loss of engine power as a result of a fatigue failure of the crankshaft due to the loss of engine case through-bolt torque. Contributing to the accident was a mechanic's use of incorrect hardware.NTSB WPR10LA472Accident · No injuriesLimited investigationFinal reportCessna T188C · Craigmont, IDThe pilot's failure to maintain directional control during the landing roll.NTSB CEN10LA512Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Houma, LAThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.