NTSB investigations: Continental TSIO-520 series, CA
245 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND 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 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 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 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 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 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 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 WPR10CA296Accident · No injuriesData collectionFinal reportCessna P210N · Petaluma, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll in gusty crosswind conditions.NTSB WPR10CA190Accident · No injuriesData collectionFinal reportCessna T210N · Truckee, CAThe pilot's failure to identify the snow-covered runway, which resulted in an off-runway landing and subsequent collision with a berm.NTSB WPR10LA191Accident · No injuriesLimited investigationFinal reportBeech 58 · Santa Barbara, CAThe landing gear collapsing during the landing roll for undetermined reasons.NTSB WPR09CA352Accident · No injuriesData collectionFinal reportCessna T210N · Corona, CAThe pilot's inadequate flare during touchdown, which resulted in a hard landing.NTSB WPR09LA214Accident · No injuriesLimited investigationFinal reportCessna T210M · Hanford, CAA loss of engine power during descent due to fuel starvation as a result of the pilot's improper fuel management. Contributing to the accident was the pilot's failure to use the correct fuel flow performance chart.NTSB WPR09LA170Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Madera, CAA total loss of engine power during the initial climb due to fuel exhaustion as a result of the pilot's failure to properly monitor the airplane's fuel quantity and to correctly ascertain the fuel on board the airplane prior to takeoff.NTSB WPR09CA129Accident · No injuriesData collectionFinal reportCessna T210 · Twentynine Palms, CAThe pilot's inadequate compensation for the gusting wind conditions.NTSB WPR09CA044Accident · No injuriesData collectionFinal reportCessna T210M · Hanford, CAThe failure of the pilot to use the before-landing checklist and extend the landing gear prior to landing.NTSB LAX08LA292Accident · No injuriesLimited investigationFinal reportCessna T210N · Oakland, CAA loss of engine power while maneuvering due to the disintegration of the number two main bearing, which resulted in a fracture of the crankshaft. Contributing to the accident was inadequate maintenance.NTSB OPS08IA013Incident · No injuriesIncident investigationFinal reportPiper PA-46 · Fresno, CAThe tower controller's failure to ensure the runway was clear before allowing Skywest 69R to land. Factors contributing to the incident were the Malibu pilot's and tower controller's unfamiliarity with the airport layout.NTSB LAX08LA281Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Groveland, CAThe pilot's failure to ensure that the landing gear was retracted prior to the water landing.NTSB SEA08LA084Accident · Serious injuriesLimited investigationFinal reportRaytheon B36TC · Mammoth, CAA loss of engine power for undetermined reasons. Contributing to the accident was dense snow covering the level terrain.NTSB LAX08FA058Accident · 4 fatalField investigationFinal reportCessna 340A · Cabazon, CAThe pilot's continued visual flight into instrument meteorological conditions and failure to maintain terrain clearance while en route. Contributing to the accident were clouds and mountainous terrain.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 LAX07CA261Accident · Minor injuriesData collectionFinal reportCessna T210N · San Jose, CAThe pilot's mismanagement of the fuel supply that resulted in fuel starvation.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 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 LAX07LA179Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Napa, CAFailure of the number 5 connecting rod due to oil starvation.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 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 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 LAX06TA291Accident · No injuriesFinal reportCessna U206G · Wasco, CAThe pilot's improper decision in leaving the engine running while he left the airplane unattended.NTSB LAX06CA279Accident · No injuriesData collectionFinal reportCessna T210G · So Lake Tahoe, CAthe pilot's failure to maintain an adequate airspeed and his inadequate remedial actions during a balloon in the landing flare, which resulted in a stall and hard landing.NTSB LAX06CA268Accident · No injuriesData collectionFinal reportCessna 414A · Ontario, CAthe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB LAX06CA248Accident · No injuriesData collectionFinal reportCessna T210N · Truckee, CAthe pilot's inadequate compensation for the existing wind conditions and failure to maintain an adequate airspeed.NTSB LAX06LA214Accident · No injuriesLimited investigationFinal reportCessna T210M · Hayward, CAA loss of power for undetermined reasons.NTSB LAX06LA213Accident · 1 fatalLimited investigationFinal reportCessna T210M · Hayward, CAThe passenger's failure to see and avoid the rotating propeller.NTSB LAX06LA178Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Chico, CAThe loss of engine power due to the pilot's inadequate preflight inspection and failure to verify the amount of fuel onboard.NTSB LAX06LA094Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Mariposa, CAThe failure of the maintenance personnel to follow the procedures in the TCM maintenance manual and adequately torque the engine through-bolts, which led to the separation of the No. 6 cylinder and the catastrophic failure of the engine.NTSB LAX06FA043Accident · 4 fatalField investigationFinal reportCessna T210N · Dana Point, CAThe pilot's inability to maintain aircraft control, which resulted in a loss of airspeed and a stall/spin. The inability of the pilot to maintain control of the airplane was likely due to an incapacitating cardiac event.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 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 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 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 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 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 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 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 LAX04LA047Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Visalia, CAa loss of engine power 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.