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 SEA06LA011Accident · No injuriesLimited investigationFinal reportCessna 402B · Sandpoint, IDThe pilot's misjudged distance/altitude, which led to him landing short of the runway and impacting the runway's elevated lip. Contributing factors were the elevated runway lip and the right main landing gear failure.NTSB SEA05FA201Accident · 2 fatalField investigationFinal reportCessna P210N · Salmon, IDThe pilot's failure to obtain airspeed during the initial takeoff climb, which resulted in a stall/mush and subsequent collision with terrain.NTSB DEN05CA147Accident · No injuriesData collectionFinal reportCessna T210L · Las Animas, COthe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's inadequate preflight planning and lack of suitable terrain for the forced landing.NTSB DFW05FA241Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Houston, TXThe pilot's improper in-flight decision to maneuver back to the departure airport following a loss of engine power on initial climb. Contributing factors were the loss of engine power for undetermined reasons, and the dark night conditions.NTSB DEN05CA136Accident · Minor injuriesData collectionFinal reportCessna T207A · Telluride, COthe pilot's improper in-flight planning/decision and failure to maintain aircraft control. Contributing factors were the pilot's failure to maintain airspeed which resulted in an inadvertent stall, and the rising terrain and encounter with downdrafts.NTSB CHI05CA244Accident · No injuriesData collectionFinal reportCessna 414 · Drummond Island, MIThe right main gear collapsed due to undetermined reasons. A factor associated with the accident was the fence that the airplane contacted.NTSB ATL05CA143Accident · No injuriesData collectionFinal reportCessna 402B · Alabaster, ALThe loss of engine power for undetermined reasons.NTSB MIA05LA147Accident · No injuriesLimited investigationFinal reportCessna T210M · Kissimmee, FLA loss of engine power due to the pilot's inaccurate fuel consumption calculations and subsequent fuel exhaustion.NTSB ATL05LA137Accident · 1 fatalLimited investigationFinal reportCessna T210 · Muscle Shoals, ALThe pilot's inadequate visual lookout, and failure to maintain clearance, which resulted in an in flight collision with a transmission wire.NTSB DEN05LA110Accident · Minor injuriesLimited investigationFinal reportCessna TU206F · Vernal, UTThe pilot's failure to maintain aircraft control during takeoff. Factors contributing to the accident were the soft dirt airstrip, the low airspeed and the stall/mush.NTSB LAX05CA235Accident · No injuriesData collectionFinal reportCessna T210M · TwentyninePalms, CAthe pilot's failure to verify the current local wind condition that resulted in his selection of the wrong runway and an inadvertent downwind landing, a runway overrun and a ground collision with objects. A factor in the accident was the short runway and its…NTSB CHI05FA162Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Grand Rapids, MNAn observed loss of engine power due to the bound/jammed turbocharger wastegate during takeoff, the pilot not maintaining airplane control, and the stall he inadvertently encountered. A factor was the maintenance personnel not replacing the turbocharger…NTSB ANC05FA090Accident · 3 fatalField investigationFinal reportCessna T207 · Nanwalek, AKThe pilot's continued VFR flight into instrument meteorological conditions, which resulted in an in-flight collision with an island cliff during cruise flight. A factor contributing to the accident was fog in the area of the accident.NTSB IAD05LA079Accident · No injuriesLimited investigationFinal reportCessna 414 · Butler, PAThe pilot's decision to conduct the flight with a known equipment deficiency. A factor was the tailwind condition.NTSB DEN05LA091Accident · No injuriesLimited investigationFinal reportCessna 340A · Santa Fe, NMtotal failure of the main landing gear due to improper installation of the push-pull tubes by maintenance personnel, and their failure to follow proper procedures/directives.NTSB DEN05LA075Accident · No injuriesLimited investigationFinal reportCessna T188C · Fowler, COthe pilot's failure to maintain visual lookout and clearance, resulting in an in-flight collision with transmission lines.NTSB SEA05FA092Accident · 2 fatalField investigationFinal reportCessna T210N · Kalispell, MTLoss of aircraft control during climb while in instrument meteorological conditions. Icing conditions was a factor.NTSB SEA05LA084Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Kalispell, MTAn airborne fire which was fueled by leaking hydraulic fluid (the ignition source for the fire was undetermined) from the landing gear hydraulic system located under the cockpit instrument panel due to inadequate maintenance from other maintenance personnel.…NTSB NYC05LA074Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Southbury, CTThe failure of the counter weight aft snap ring to hold the associated plate and pin in place, which resulted in a total loss of engine power.NTSB LAX05LA136Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Phoenix, AZa loss of power for undetermined reasons.NTSB LAX05FA132Accident · 3 fatalField investigationFinal reportCessna T210L · Tranquility, CAthe pilot's in-flight loss of control due to spatial disorientation and a likely accumulation of airframe ice that led to a high speed descent and a structural breakup once the aerodynamic forces exceeded the strength limits of the structure. A factor in the…NTSB LAX05LA120Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Carefree, AZthe pilot's improper use of the fuel boost pump contrary to the procedures specified in the pilot owner handbook and other documents.NTSB DFW05CA087Accident · No injuriesData collectionFinal reportCessna TU206G · Lancaster, TXThe pilot's mismanagement of the available fuel supply, which resulted in a total loss of engine power due to fuel starvation.NTSB DEN05LA057Accident · No injuriesLimited investigationFinal reportCessna P210N · Lander, WYthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC05IA052Incident · No injuriesIncident investigationFinal reportCessna 402C · Hyannis, MAThe mechanic's inadequate inspection, which failed to discover cracks in the left wing spar around wing station 114.NTSB LAX05FA092Accident · 2 fatalField investigationFinal reportCessna P210N · Lebec, CAthe pilot's in-flight loss of control due to the flight's encounter with unforecasted localized mountain wave activity with severe to potentially extreme turbulence, downdrafts, and rotors.NTSB MIA05WA056Accident · 2 fatalForeign investigationCessna 340 · Mendoza, ArgentinaNTSB LAX05LA080Accident · No injuriesLimited investigationFinal reportCessna T210N · Glendale, AZThe airplane was struck by lightning during the approach to land.NTSB LAX05LA068Accident · No injuriesLimited investigationFinal reportCessna T210L · Yuba City, CAthe pilot's inadequate preflight preparation and failure to verify the fuel supply, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB LAX05LA065Accident · No injuriesLimited investigationFinal reportCessna T210M · Mesa, AZthe pilot's failure to use the emergency gear extension procedure to manually extend the landing gear to the down and locked position.NTSB LAX05LA063Accident · No injuriesLimited investigationFinal reportCessna 340 · Carefree, AZthe pilot's improper use of the throttles during an aborted landing attempt that resulted in an engine over-boost condition requiring a reduction in power that then resulted in a runway overrun and collision with a ditch.NTSB SEA05CA029Accident · No injuriesData collectionFinal reportBeech 58TC · Everett, WAThe pilot's misjudgment of distance/speed on landing touchdown and rollout, and his subsequent excessive braking. A factor was the fence.NTSB DFW05FA038Accident · 2 fatalField investigationFinal reportCessna T210N · Abita Springs, LAThe loss of engine power for undetermined reasons. Also causal was the pilot's improper in-flight emergency planning when he misjudged his available altitude and made a 360 degree turn away from the airport instead of proceeding directly to it, which resulted…NTSB LAX05FA046Accident · 1 fatalField investigationFinal reportCessna T207A · Meadview, AZa loss of control due to the in-flight separation of the right elevator and elevator trim tab control surfaces. The precipitating reason for the elevator separation could not be resolved as related to the tab foam core issue with the available evidence.NTSB LAX05FA045Accident · 1 fatalField investigationFinal reportCessna T310R · Flagstaff, AZThe pilot's decision to attempt flight into known adverse weather conditions beyond the capability of the airplane and his failure to ensure that the airplane's wings were free of ice and/or snow contamination that accumulated while the airplane was on the…NTSB IAD05LA022Accident · No injuriesLimited investigationFinal reportCessna 414 · Petersburg, VAThe partial loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed (Vmc).NTSB DFW05LA027Accident · No injuriesLimited investigationFinal reportCessna P210N · Pawhuska, OKThe pilot's mismanagement of the fuel by his failure to adequately set the fuel selector position which resulted in fuel exhaustion and the loss of engine power.NTSB IAD05FA012Accident · 1 fatalField investigationFinal reportCessna P210 · Paint Lick, KYImproper alignment of a turbocharger oil line, which resulted in wear damage through the hose wall and a subsequent loss of engine oil. Contributing to the accident was the low cloud ceiling.NTSB LAX05CA031Accident · Minor injuriesData collectionFinal reportCessna P210N · North Las Vegas, NVthe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. Also causal was the pilot's inadequate preflight planning/preparation which failed to assure an adequate fuel supply.NTSB LAX05CA030Accident · No injuriesData collectionFinal reportCessna P210N · Rancho Cordova, CAThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power. Contributing factors were the pilot's improper in-flight decision to continue the flight at night after experiencing the total failure of the…NTSB LAX05FA026Accident · 1 fatalField investigationFinal reportCessna T210M · Lomita, CAA loss of engine power due to fuel starvation as a result of the pilot's mismanagement and inadequate preflight inspection.NTSB MIA05LA018Accident · No injuriesLimited investigationFinal reportCessna 340A-RAM VI · Pensacola, FLThe left landing gear collapsing due to the actuator separating for undetermined reasons.NTSB MIA05LA016Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Raymond, MSThe total loss of engine power which was initiated by fretting of the crankcase halves for undetermined reasons, causing rotation of several of the main bearings, oil starvation, and subsequent failure of several of the connecting rods. A contributing factor…NTSB CHI05FA016Accident · 2 fatalField investigationFinal reportCessna P210N · Wautoma, WIThe pilot not maintaining airplane control during cruise flight in instrument meteorological conditions after reporting a loss of gyros leading to his exceeding the design load limits of the wings. Factors were the clouds, the deteriorated vacuum manifold…NTSB SEA05LA011Accident · No injuriesLimited investigationFinal reportCessna T210H · Missoula, MTThe pilot's failure to follow published procedures/directives (inducing excessive fuel flow to the engine), and the subsequent loss of engine power for nonmechanical reasons while on final approach. Contributing factors were the utility pole and the ditch.NTSB CHI05WA008Accident · 4 fatalForeign investigationPiper PA-46-310P · Dijon Longvic, FranceNTSB NYC04CA207Accident · No injuriesData collectionFinal reportCessna 402C · Charleston, WVThe pilot's improper decision to abort the takeoff with insufficient runway remaining. A factor was the wet runway.NTSB CHI04CA252Accident · No injuriesData collectionFinal reportCessna T310R · Marshall, MNThe pilot rated passenger selecting an improper fuel selector position, and the pilot in command not verifying the fuel selector position which resulted in fuel starvation. Contributing factors were the pilot's failure to feather the right engine propeller…NTSB FTW04LA223Accident · No injuriesLimited investigationFinal reportCessna 340 · Odessa, TXThe pilot's failure to extend the landing gear prior to landing and the instructor's inadequate supervision.NTSB ANC04CA085Accident · No injuriesData collectionFinal reportCessna 402C · Huslia, AKThe pilot's failure to extend the landing gear, which resulted in an inadvertent wheels up landing. A factor associated with the accident was the pilot's diverted attention.