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 DEN04FA109Accident · 3 fatalField investigationFinal reportBeech 58P · Fort Collins, COthe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed which resulted in a stall/spin. Clouds and the pilot's diverted attention were contributing factors.NTSB DEN04LA107Accident · No injuriesLimited investigationFinal reportCessna P210N · Douglas, WYthe failure of the engine's crankshaft due to the rotation of the engine's number two bearing, which resulted in the oil starvation of the crankshaft's number 2 main journal. Contributing factors include the engine's improper maintenance, and the in-flight…NTSB ATL04FA159Accident · 4 fatalField investigationFinal reportBeech 36TC · Sylvester, GAThe pilot's inadequate in-flight planning/decision resulting in flight into thunderstorms resulting in an in-flight breakup of the airframe.NTSB CHI04LA183Accident · No injuriesLimited investigationFinal reportCessna 340A · Mason City, IAThe proper touchdown point not obtain/maintained by the pilot following a single-engine approach to landing. Contributing factors were the vacuum pump oil leak, the low oil pressure of the propeller control system, and the unfeathered propeller.NTSB DEN04LA098Accident · No injuriesLimited investigationFinal reportCessna T210N · Spanish Fork, UTthe improper reassembly of the engine following major overhaul (application of Permatex over entire crankcase surfaces). Contributing factors included the number 2 main bearing and crankshaft shifting forward, causing the alternator drive shaft and other…NTSB SEA04CA123Accident · No injuriesData collectionFinal reportCessna T210M · Mallard Creek, IDImproper touchdown during landing. A factor contributing to the accident was soft ground conditions.NTSB NYC04FA144Accident · 1 fatalField investigationFinal reportCessna P210N · Dunkirk, NYThe pilot's loss of aircraft control and the subsequent overstress and separation of the wing during an encounter with convection induced turbulence.NTSB CHI04CA164Accident · No injuriesData collectionFinal reportCessna 401 · Mt. Vernon, ILThe pilot's misjudgment of the landing flare. Contributing factors were the pilot's failure to execute a stabilized approach for landing. An additional factor was the presence of the runway lights.NTSB MIA04WA110Accident · No injuriesForeign investigationCessna 402B · Bonaire, NTNTSB CHI04CA135Accident · Minor injuriesData collectionFinal reportCessna T210L · Wichita, KSThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB LAX04LA230Accident · No injuriesLimited investigationFinal reportCessna T210M · Santa Rosa, CAMaintenance personnel's improper installation and servicing of a retaining ring, which resulted in the failure of the landing gear door actuator and failure of the landing gear extension system during landing.NTSB FTW04CA140Accident · Minor injuriesData collectionFinal reportBeech BE-58P · Oklahoma City, OKThe pilot's failure to attain the proper touchdown point of the runway. Contributing factors were the excessive airspeed and the pilot's failure to initiate a go-around.NTSB NYC04LA105Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Taylor, PAThe failure of the number 2 connecting rod, after a main bearing shift, which resulted in a catastrophic engine failure.NTSB MIA04WA065Accident · No injuriesForeign investigationCessna 402B · Walker's Cay, BahamasNTSB MIA04WA066Incident · No injuriesForeign investigationCessna 402C · Marsh Harbour, BahamasNTSB FTW04IA104Incident · No injuriesIncident investigationFinal reportCessna 414 · Midland, TXThe in-flight wing fire for undetermined reasons.NTSB ATL04FA077Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Arlington, ALThe pilots inadequate in-flight planning/decision and his failure to maintain aircraft control, resulting in an in-flight encounter with a thunderstorm and exceeding the design limits of the aircraft.NTSB CHI04LA065Accident · Serious injuriesLimited investigationFinal reportCessna 402B · Sturgis, MIThe failure to maintain obstacle clearance during an intentional low altitude maneuver and the ostentatious display by the pilot-in-command. A factor to the accident was the tree.NTSB LAX04LA111Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Goodyear, AZThe pilot's inadequate fuel consumption calculations and in-flight planning/decision, which resulted in fuel exhaustion.NTSB LAX04FA113Accident · 3 fatalField investigationFinal reportCessna 414A · Laupahoehoe, HIthe pilot's disregard for an in-flight weather advisory, his likely encounter with marginal VFR or IMC weather conditions, his decision to continue flight into those conditions, and failure to maintain an adequate terrain clearance altitude resulting in an…NTSB LAX04CA105Accident · No injuriesData collectionFinal reportBeech B36TC · San Diego, CAthe pilot's misjudged speed and altitude, which led to a failure to attain the proper touchdown point and a subsequent runway overrun. Also causal was the pilot's delayed decision to perform a go-around.NTSB FTW04FA062Accident · 1 fatalField investigationFinal reportBeech B36TC · Willow Park, TXThe pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the dark night and rain.NTSB NYC04LA067Accident · No injuriesLimited investigationFinal reportCessna 421 · Ravenna, OHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent hard landing. A factor in the accident was degraded aircraft performance due to the airframe ice accumulation.NTSB SEA04LA029Accident · Minor injuriesLimited investigationFinal reportBeech 58P · Missoula, MTThe second pilot's failure to maintain terrain clearance while maneuvering after takeoff. Proper climb rate not verified by the flight crew, fog, freezing fog, dark night conditions and inadequate supervision by the pilot-in-command were factors.NTSB FTW04LA047Accident · No injuriesLimited investigationFinal reportCessna T210N · Marfa, TXThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX04FA066Accident · 1 fatalField investigationFinal reportCessna 421C · Claremont, CAthe pilot became lost/disoriented during the approach, failed to maintain course alignment with the missed approach procedure, and subsequently lost control of the airplane.NTSB ANC04FA015Accident · 2 fatalField investigationFinal reportCessna P210N · Tonopah, NVThe pilot's failure to follow approved instrument flight procedures, and his failure to maintain clearance from obstacles/terrain, which resulted in an in-flight collision with terrain. Factors associated with the accident are snow and low clouds.NTSB ATL04FA051Accident · 4 fatalField investigationFinal reportCessna 414 · Greeneville, TNThe pilot's failure to maintain airspeed while maneuvering in icing conditions on a circling approach for landing resulting in an inadvertent stall and collision with trees and terrain. A factor in the accident was a partial loss of engine power due to the…NTSB DEN04LA025Accident · No injuriesLimited investigationFinal reportCessna T210K · Deming, NMThe pilot's improper in-flight planning and decision. Factors contributing to the accident were fuel exhaustion and the fence.NTSB SEA04FA022Accident · 4 fatalField investigationFinal reportBeech S35 · Warren, ORThe vacuum pump failure and the pilot's failure to maintain control of the airplane. Factors contributing to the accident included the instrument meteorological weather conditions and the pilot's improper recovery from the descent.NTSB CHI04LA038Accident · No injuriesLimited investigationFinal reportCessna 340A · Poplar Bluff, MOFailure to maintain directional control during landing. Collapse of the nose landing gear, the muddy grass/turf and the berm were contributing factors.NTSB SEA04FA020Accident · 1 fatalField investigationFinal reportCessna T210N · Bellevue, IDThe pilot's failure to maintain adequate altitude above mountainous terrain while maneuvering during descent. Factors included the mountainous terrain, the high wind condition, and dark night light conditions.NTSB LAX04LA047Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Visalia, CAa loss of engine power for undetermined reasons.NTSB FTW04FA022Accident · 1 fatalField investigationFinal reportCessna 210M · Tolar, TXThe pilot's improper pre-flight planning and loss of engine power for undetermined reasons. A factor was the fog.NTSB ANC04LA011Accident · No injuriesLimited investigationFinal reportCessna 402 · Galena, AKWater contamination and freezing of the landing gear actuator that prevented the extension of the right main landing gear, resulting in a gear-up landing. Factors contributing to the accident were freezing temperatures at the accident location, and inadequate…NTSB DEN04LA021Accident · No injuriesLimited investigationFinal reportCessna T210N · Johnstown, COThe pilot's failure to maintain directional control during the landing roll. Factors contributing to the accident were the gusting crosswinds.NTSB SEA04FA006Accident · 2 fatalField investigationFinal reportCessna 340A · Scappoose, ORThe pilot's failure to maintain airspeed while maneuvering. An inadvertent stall, the pilot's failure to follow engine operation procedures and engine detonation were factors.NTSB SEA04LA001Accident · Minor injuriesLimited investigationFinal reportCessna 340 · Blakely Island, WAThe pilot's inadequate compensation for downdrafts on final approach resulting in an excessive descent rate on short final. Factors include downdrafts off the approach end of the selected runway, and low clouds/fog.NTSB NYC03FA203Accident · 1 fatalField investigationFinal reportCessna 402C · Nantucket, MAThe pilot's failure to maintain aircraft control during a missed approach. Factors in this accident were fog and the night light conditions.NTSB NYC03LA201Accident · No injuriesLimited investigationFinal reportRaytheon B36TC · Batavia, OHA loss of engine power during an approach for undetermined reasons.NTSB LAX03LA283Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Monterey, CAThe pilot’s inadequate in-flight planning/decision, which resulted in a loss of engine power during an instrument approach to land, and an in-flight collision with a tree and terrain.NTSB CHI03LA305Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Pine River, MNAn inadequate pre-flight inspection by the pilot due to his failure to visually confirm fuel quantity prior to flight, and the resulting fuel exhaustion. Contributing factors were the pilot's improper use of the fuel management computer installed in the…NTSB CHI03FA291Accident · 3 fatalField investigationFinal reportBeech B36TC · Uniondale, INThe pilot's inaccurate preflight planning which resulted in an inadequate fuel supply and subsequent fuel exhaustion. Factors associated with the accident were the low ceiling, dark night conditions, and the utility pole which the airplane contacted during…NTSB ATL03FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Hilton Head Is, SCThe pilot's failure to maintain control of the airplane during a VFR pattern for a precautionary landing, which resulted in an uncontrolled descent and subsequent collision with terrain. Also causal was the pilot's inadequate preflight inspection of the…NTSB FTW03LA199Accident · No injuriesLimited investigationFinal reportCessna T188C · Colorado City, TXThe loss of engine power due to failure of the crankshaft. A contributing factor was low altitude flight.NTSB MIA03LA160Accident · No injuriesLimited investigationFinal reportCessna T210M · Hialeah, FLSpinning of the crankshaft No. 2 main bearing for undetermined reasons resulting in damage to the aft cheek of the No. 2 main bearing journal, fatigue failure of the crankshaft cheek, failure of the engine in cruise flight, and damage to the airplane during…NTSB LAX03FA254Accident · 1 fatalField investigationFinal reportCessna 340A · Bishop, CAthe pilot's in-flight loss of control due to a Somatogravic illusion and/or spatial disorientation. Factors in the accident were the dark lighting conditions and the pilot's lack of familiarity with the airplane.NTSB IAD03LA066Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Hampton Bays, NYA loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB NYC03FA161Accident · 1 fatalField investigationFinal reportCessna T210L · Quakertown, PAA loss of engine power for undetermined reasons.NTSB ANC03LA076Accident · 4 fatalLimited investigationFinal reportCessna 401 · Gustavus, AKThe pilot's inadequate in-flight decision making process, and failure to refuel the airplane prior to fuel exhaustion, which resulted in a total loss of engine power. A factor associated with the accident was the lack of a suitable forced landing site.