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 MIA03FA141Accident · 2 fatalClass 1 · FieldFinal reportCessna 402C · Treasure Cay, Bahamasthe in-flight failure of the right engine and the pilot’s failure to adequately manage the airplane’s performance after the engine failed. The right engine failure resulted from inadequate maintenance that was performed by Air Sunshine’s maintenance personnel…NTSB SEA03LA133Accident · No injuriesLimited investigationFinal reportCessna 402 B · Lakeview, ORFailure of the landing gear shaft roll pin resulting in a main gear collapse during the taxi phase of operation.NTSB CHI03WA198Accident · 1 fatalForeign investigationBeech BE-58TC · Toronto, CanadaNTSB DEN03LA123Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Englewood, COthe pilot's improper flare which resulted in a hard landing. Contributing factors were the out-of-calibration waste gate actuator, a blown tire, and the airport sign.NTSB SEA03FA124Accident · 1 fatalField investigationFinal reportBeech A36TC · East Wenatchee, WALoss of engine power due to fuel starvation that resulted from the right wing tank reaching an unusable fuel level. Also causal was an unapproved alteration of the aircraft’s fuel system. Contributing to the accident were the incorrect installation of an…NTSB DEN03LA116Accident · No injuriesLimited investigationFinal reportCessna T210M · Aspen, COthe failure of the landing gear actuator switch. Factors relating to the accident were the false landing gear indication, the precautionary landing, and the improper maintenance adjustment performed on the landing gear switch prior to the accident flight.NTSB ATL03FA115Accident · 2 fatalField investigationFinal reportBeech 58P · Memphis, TNAn encounter with wake turbulence on approach, which resulted in the pilot's inability to maintain control and subsequent in-flight collision with the ground.NTSB LAX03WA205Accident · No injuriesForeign investigationCessna T210L · Anahim Lake, CanadaNTSB SEA03LA113Accident · No injuriesLimited investigationFinal reportCessna 206 · Soldier Bar, IDThe overload failure of the nose landing gear assembly during the landing roll, due to an improper maintenance installation. A factor was the rough/uneven terrain condition.NTSB MIA03WA126Accident · No injuriesForeign investigationCessna 402B · LittleWhale Cay, BahamasNTSB CHI03LA159Accident · No injuriesLimited investigationFinal reportCessna T210N · Tribune, KSThe in-flight separation of the turbocharger exhaust band clamp resulting in an in-flight fire and uncommanded landing gear extension. Also causal was the improper maintenance by unknown personnel.NTSB ANC03LA065Accident · No injuriesLimited investigationFinal reportCessna 402B · Telida, AKThe pilot's selection of an unsuitable landing site, which resulted in the collapse of the nose landing gear. A factor in the accident was a soft runway.NTSB LAX03FA182Accident · 5 fatalField investigationFinal reportBeech A36TC · Los Angeles, CAthe pilot's in-flight loss of control due to spatial disorientation, and failure to maintain airspeed, which resulted in a stall/spin. Also causal was the pilot's disregard of the weather information provided and his attempt to continue VFR flight into IMC. A…NTSB ATL03LA101Accident · No injuriesLimited investigationFinal reportBeech 58P · Gatlinburg, TNThe pilot's misjudgment of altitude and distance to the runway during final approach, and his failure to attain the proper touchdown point for landing.NTSB IAD03LA055Accident · No injuriesLimited investigationFinal reportCessna 414 · Port Jefferson, NYLoss of power to both engines for undetermined reasons.NTSB MIA03IA110Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe inadequate annual inspection of the airplane by other maintenance personnel for failure to note an incorrect washer was installed securing the upper and lower torque links, resulting in separation of the upper and lower links and subsequent rotation of…NTSB SEA03LA079Accident · No injuriesLimited investigationFinal reportCessna P210N · Boise, IDThe landing gear extension was not performed by the pilot for landing. Contributing factors included the pilot's failure to perform the Before Landing checklist and his unfamiliarity with the landing gear warning horn system.NTSB LAX03LA149Accident · No injuriesLimited investigationFinal reportCessna 340A · Boulder City, NVthe airport committee members failure to repair or mark the faulty telephone junction box cover as a hazard. A factor in the accident was the inadequate notification process of the airport and city personnel.NTSB ATL03FA077Accident · 1 fatalField investigationFinal reportCessna 414 · Waleska, GAThe pilot's failure to maintain clearance from terrain.NTSB SEA03LA056Accident · Minor injuriesLimited investigationFinal reportCessna TU206 G · Pistol Creek, IDInadequate visual lookout by the driver of the vehicle that turned on to the runway. Factors include rising terrain decreasing the possibility of a successful go-around and rough uneven terrain beyond the departure end of the runway.NTSB CHI03LA076Accident · Minor injuriesLimited investigationFinal reportCessna T210L · New Hudson, MIThe pilot's failure to maintain aircraft control which resulted in the airplane stalling while on final approach.NTSB MIA03LA064Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Marathon, FLThe loss of engine power to both engines for undetermined reasons.NTSB LAX03LA089Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Stockton, CAfuel starvation due to the pilot's mismanagement of the fuel supply and failure to verify the fuel quantity on board at departure.NTSB ATL03LA045Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Bolivar, TNThe loss of engine power for undetermined reasons. A factor was trees.NTSB FTW03FA093Accident · 3 fatalField investigationFinal reportCessna T210N · Mission, TXThe pilot's failure to maintain aircraft control, which resulted in his exceeding the airplane's design limitation. Contributing factors were the pilot's decision to fly the airplane with known deficiencies with the attitude indicator, and the failure of the…NTSB LAX03LA075Accident · No injuriesLimited investigationFinal reportCessna T210L · El Monte, CAthe alternator switch contact failure, which resulted in a complete electrical failure.NTSB LAX03FA073Accident · Serious injuriesField investigationFinal reportCessna 402C · Mather, CAloss of engine power in the left engine for undetermined reasons. Also causal was the pilot's failure to correctly configure the airplane for a single engine missed approach, which resulted in a negative climb performance. A factor was the pilot's decision to…NTSB NYC03LA040Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Put In Bay, OHThe pilot's inadequate fuel management, which resulted in fuel starvation and a total loss of engine power during the initial climb.NTSB LAX03FA067Accident · Serious injuriesField investigationFinal reportCessna 414 · Palm Springs, CAThe flight instructor's improper selection of the high boost position for the operating right engine while on base leg to land, which resulted in a loss of engine power of the right engine. Factors associated with the accident are the left engine's loss of…NTSB CHI03LA046Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Ada, MNThe pilot's failure to maintain the minimum descent altitude and his failure to maintain obstacle clearance. A low ceiling was a factor.NTSB FTW03LA070Accident · No injuriesLimited investigationFinal reportCessna T207 · Brownsville, TXThe loss of engine power due to the separation of the crankshaft. A factor was the lack of suitable terrain for the forced landing.NTSB LAX03TA048Accident · No injuriesFinal reportCessna T210L · Agua Caliente, CAThe failure of the right main landing gear actuator during the landing roll, which resulted in a collapse of the right main land gear, and loss of directional control.NTSB LAX03FA037Accident · 1 fatalField investigationFinal reportBeech B36TC · Union City, CAthe pilot's failure to maintain an adequate terrain clearance altitude, which resulted in controlled flight into rising mountainous terrain. Contributing factors were the pilot's loss of situational awareness to his terrain proximity, the dark night, and the…NTSB LAX03LA034Accident · Minor injuriesLimited investigationFinal reportCessna T210 L · Williams, AZAn in-flight fire for undetermined reasons.NTSB LAX03FA031Accident · Minor injuriesField investigationFinal reportCessna T210L · Pacoima, CAa loss of engine power due the inadvertent unporting of the fuel pickup tube, which resulted in fuel starvation during the go-around. The pilot's preflight and in-flight decisions regarding fuel quantity and fuel system management are also causal.NTSB FTW03LA025Accident · No injuriesLimited investigationFinal reportCessna T188C · Seminole, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN03FA002Accident · 1 fatalField investigationFinal reportCessna T210M · Laramie, WYthe pilot's improper inflight planning/decision, and his failure to maintain terrain clearance while attempting a low altitude maneuver. Contributing factors were the mountainous terrain, the airplane’s low altitude, and the pilot's lack of total instrument…NTSB ANC02LA128Accident · No injuriesLimited investigationFinal reportCessna 207 · Circle, AKThe pilot's inadequate wind evaluation during takeoff resulting in a downwind takeoff and subsequent overrun during an aborted takeoff. Factors in the accident were a tailwind and the pilot's failure to verify the selected flap setting.NTSB CHI02LA276Accident · No injuriesLimited investigationFinal reportCessna T188C · Olivia, MNThe fouled spark plugs and the terrain condition encountered during the aborted takeoff.NTSB NYC02FA178Accident · 7 fatalField investigationFinal reportBeechcraft 58P · Swanzey, NH**This report was modified on 2/24/2016. Refer to the public docket for this accident for additional information.** the pilot's improper preflight planning and his decision to depart with known landing gear system mechanical deficiencies, which resulted in a…NTSB IAD02LA090Accident · No injuriesLimited investigationFinal reportCessna T210N · Glastonbury, CTA partial loss of engine power for undetermined reasons. A factor in the airplane's damage was the standing corn.NTSB NYC02WA175Accident · Serious injuriesForeign investigationCessna 310R · Saint Tropez, FranceNTSB SEA02LA138Accident · No injuriesLimited investigationFinal reportCessna T188C · Choteau, MTFuel exhaustion as a result of the pilot's inattention to fuel consumption (flight duration) which resulted in a total loss of power and subsequent hard landing.NTSB SEA02FA119Accident · 2 fatalField investigationFinal reportCessna 335 · Tensed, IDAircraft control was not maintained during an emergency landing. A loss of power for undetermined reasons was a factor.NTSB DEN02LA057Accident · No injuriesLimited investigationFinal reportBeech 58P · Broomfield, COthe pilot's failure to follow procedures for a balked landing which resulted in a stall/mush.NTSB MIA02FA113Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Naples, FLThe pilot's failure to maintain airspeed above the stall speed while maneuvering to land after the engine ceased operating for undetermined reasons, which resulted in a stall/spin, an uncontrolled descent, and an impact with the ground.NTSB FTW02LA184Accident · No injuriesLimited investigationFinal reportCessna P210N · Shreveport, LAthe collapse of the right main landing gear for undetermined reasons.NTSB MIA02FA111Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Osteen, FLthe pilot's inadequate weather evaluation and his failure to maintain control of the airplane after entering an area of thunderstorms resulting in an in-flight separation of the right wing and right horizontal stabilizer and impact with the ground during an…NTSB DEN02TA052Accident · No injuriesFinal reportBeech 58P · Grand Junction, COthe pilot's inadvertent flight into adverse weather conditions. A factor contributing to the accident was the terrain-induced turbulence.NTSB ATL02LA108Accident · No injuriesLimited investigationFinal reportCessna T210N · Orlando, FLThe pilot's inadequate planning decision that resulted in fuel exhaustion and subsequent loss of engine power.