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 SEA96LA102Accident · No injuriesLimited investigationFinal reportCessna T188C · Hooper, UTloss of engine power for undetermined reason(s). A factor relating to the accident was: the proximity of obstructions, which limited the pilot's ability to reach a suitable emergency landing area.NTSB FTW96LA227Accident · No injuriesLimited investigationFinal reportCessna 414 · Broomfield, COfailure of the pilot to maintain adequate visual lookout by allowing his attention to be diverted.NTSB CHI96LA168Accident · No injuriesLimited investigationFinal reportCessna 188 · Roseau, MNthe pilot failed to maintain directional control during takeoff. The crosswind was a factor.NTSB IAD96LA079Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carrollton, OHThe pilot's inadequate fuel management. Factors in this accident were the pilot's reliance on a fuel data computer and his untimely reaction to a known fuel quantity discrepancy.NTSB CHI96FA171Accident · No injuriesField investigationFinal reportCessna 401 · Great Bend, KSthe failure of the exhaust header. Additional factors include the visual restrictions which prevented a detailed examination of the exhaust system, and the inadequate inspection procedures required in AD 75-23-08 R5.NTSB CHI96FA152Accident · Serious injuriesField investigationFinal reportCessna 340A · Waukegan, ILthe pilot's inability to maintain visual contact with the runway environment due to 'flash blindness' when he turned on the airplane's landing light, and his subsequent inability to regain control of the airplane after turning off the landing light due to his…NTSB FTW96TA186Accident · No injuriesFinal reportCessna T210N · Beaumont, TXFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB MIA96TA112Accident · No injuriesFinal reportCessna 210 · Lakeland, FLthe pilot's improper flare on landing, and his improper use of flight controls on landing rollout.NTSB LAX96LA133Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Grass Valley, CAfuel starvation for an undetermined reason.NTSB IAD96LA046Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Hazard, KYfailure of the engine crankshaft, which resulted in loss of engine power, a forced landing, and subsequent damage to the airplane. A factor relating to the accident was: lack of suitable terrain for a forced landing.NTSB SEA96FA061Accident · 1 fatalField investigationFinal reportCessna 402B · Estacada, ORloss of aircraft control for undetermined reason(s).NTSB NYC96WA070Accident · 5 fatalForeign investigationPiper PA-46 · ZambiaNTSB FTW96LA098Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Las Vegas, NMfailure of the throttle cable. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB SEA96FA031Accident · 1 fatalField investigationFinal reportCessna T210M · Netarts, ORa loss of control for undetermined reasons.NTSB LAX96LA059Accident · No injuriesLimited investigationFinal reportCessna TU206G · Eagar, AZthe pilot's failure to assure an adequate amount of fuel was on board for the flight.NTSB MIA96LA027Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Ocala, FLThe failure of the pilot-in-command (CFI) of the Cessna, N210PW, to see and avoid the Piper, N2114P.NTSB NYC96LA020Accident · No injuriesLimited investigationFinal reportCessna 414A · Grt Barrington, MAthe pilot's inadequate compensation for wind conditions, which resulted in an undershoot of the proper touchdown point for landing. Factors relating to the accident were: the unfavorable wind conditions and the exposed runway lip.NTSB BFO96LA019Accident · No injuriesLimited investigationFinal reportCessna T210L · College Park, MDthe pilot's improper recovery from a bounced landing and his failure to initiate a go-around. Related factors were the crosswind and the pilot's concern about being late for meetings he had scheduled.NTSB LAX95LA342Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Phoenix, AZthe pilot's inadequate preflight planning and improper fuel consumption calculations. The soft terrain was a factor in this accident.NTSB ANC95LA159Accident · No injuriesLimited investigationFinal reportCessna 206 · Homer, AKThe pilot's inadequate compensation for the wind conditions, which resulted in his failure to reach the proper touchdown point for landing. Factors related to the accident were: the variable wind condition, and rising terrain (no overrun) at the approach end…NTSB SEA95LA200Accident · No injuriesLimited investigationFinal reportCessna 210 · Sunriver, ORThe failure of the landing gear hydraulic drive motor.NTSB SEA95LA197Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Spokane, WAthe pilot's failure to maintain airspeed while trying to clear a transmission wire. Factors include a transmission wire near the end of the takeoff area and glassy water.NTSB LAX95LA257Accident · 1 fatalLimited investigationFinal reportCessna TU206 · Danville, CAThe pilot's intentional flight into known adverse weather and failure to maintain proper altitude.NTSB ANC95LA094Accident · No injuriesLimited investigationFinal reportBeech 36 · Chitina, AKAn inadvertent stall while on approach. The pilot-in-command's inadequate remedial action was a factor.NTSB ANC95LA077Accident · No injuriesLimited investigationFinal reportCessna 402B · Tuntutuliak, AKThe airport maintenance personnel's inadequate maintenance of the runway by not replacing the yellow cones that marked the soft area. The soft area on the runway was a related factor.NTSB LAX95LA205Accident · No injuriesLimited investigationFinal reportCessna T210M · Coalinga, CAThe pilot's improper landing flare and inadequate bounced landing recovery technique.NTSB MIA95LA137Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Homestead, FLBinding (mechanical) of the right elevator with the right horizontal stabilizer after collision with a dog at the right horizontal stabilizer during rotation. The deformation of the stabilizer reduced the pilot-in-commmand's ability to operate the elevator.NTSB SEA95FA095Accident · 6 fatalField investigationFinal reportCessna T210L · Milford, UTthe pilot's continued flight into known adverse weather (icing conditions), and his delay in executing a course reversal to exit those conditions, which resulted in airframe ice accumulation and loss of control. A factor was the icing conditions.NTSB FTW95TA187Accident · No injuriesFinal reportCessna 210J · Fabens, TXLoss of engine power due to water contamination of the fuel.NTSB CHI95LA137Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Dodge City, KSfatigue and subsequent catastrophic failure of the connecting rod originating from the decarburized area on the shank of the rod. Factors were the low cloud weather condition and the ditch.NTSB CHI95FA121Accident · 3 fatalField investigationFinal reportCessna P-210N · Belle Plaine, MNthe failure to replace the deteriorated deicing boots, and the failure of the boots to operate when the airplane encountered icing condition. An additional causes were the pilot's failure to maintain adequate airspeed and the excessive pullup performed by the…NTSB ANC95LA040Accident · No injuriesLimited investigationFinal reportCessna 206G · Chevak, AKThe pilot's misjudgment of the landing flare and failure to maintain adequate airspeed to avoid stalling the airplane.NTSB FTW95LA138Accident · No injuriesLimited investigationFinal reportCessna 340 · Santa Fe, NMWorn landing gear assembly due to inadequate maintenance by maintenance personnel and delayed maintenance by operators.NTSB CHI95LA096Accident · No injuriesLimited investigationFinal reportCessna T210N · Rockford, ILA disconnect of the alternator belt, and failure of the pilot to attain a down and locked condition of the gear with the emergency extension system.NTSB BFO95FA028Accident · 1 fatalField investigationFinal reportCessna T210M · Youngstown, OHloss of engine power for undetermined reason(s). Factors relating to the accident were: the weather conditions (restricted visibility with snow falling), reduced light condition at dusk, and the lack of suitable terrain for an emergency landing.NTSB LAX95LA117Accident · No injuriesLimited investigationFinal reportCessna T210F · Phalen, CAthe pilot's decision to continue the flight with a known mechanical discrepancy in the brake system.NTSB FTW95LA120Accident · No injuriesLimited investigationFinal reportCessna T210M · Montrose, COThe bent landing gear emergency extension assembly and the accumulation of airframe ice which interfered with landing gear activation. A factor was the alternator failure for unknown reasons.NTSB NYC95FA056Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Chippewa Falls, WIThe pilot's improper decision to depart into known adverse weather conditions, and the subsequent encounter with freezing drizzle, resulting in an inadvertent stall and collision with the terrain during an approach to land. Also causal to the accident was the…NTSB SEA95LA034Accident · No injuriesLimited investigationFinal reportCessna T210 · Kellogg, IDThe pilot's improper positioning of the fuel selector valve, his inadequate remedial action, and starvation of fuel to the engine. Factors include a sign post alongside the road on which the forced landing took place.NTSB CHI95IA052Incident · No injuriesIncident investigationFinal reportCessna 402 · Saint Louis, MOimproper maintenance installation (fuel line fitting)by other maintenance personnel. A factor was the cross threaded fuel line fitting.NTSB CHI95LA047Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Aurora, MOAn undetermined failure of the engine crankshaft resulting in total loss of engine power. The terrain at the emergency landing site and nighttime darkness were contributing factors.NTSB FTW95LA051Accident · No injuriesLimited investigationFinal reportCessna P210N · Alamosa, COFailure by the pilot to properly judge the touch down point. Factors were: failure of the nose landing gear to extend and rough and uneven terrain.NTSB MIA95LA016Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe failure of the left main landing gear upper barrel and trunion assembly due to overstress separations, resulting in the collapse of the left main landing gear on landing rollout.NTSB CHI95LA025Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Beulah, NDthe failure of the pilot to maintain directional control.NTSB MIA95WA009Accident · No injuriesForeign investigationCessna 402B · Exuma Island, BahamasNTSB SEA95LA003Accident · No injuriesLimited investigationFinal reportCessna 210 · Bend, ORThe failure of the landing gear downlock mechanism to engage due to undetermined reasons.NTSB FTW95FA003Accident · 2 fatalField investigationFinal reportCessna T210M · Richmond, UTThe loss of engine oil pressure due to an oil leak from a loose oil line fitting. Factors were the obscuration, and the unsuitable terrain at the pilot's disposal.NTSB FTW94FA311Accident · 1 fatalField investigationFinal reportCessna T188C · Roscoe, TXThe pilot's failure to maintain flying speed resulting in an aerodynamic stall. A factor was the pilot's lack ofNTSB NYC94LA175Accident · No injuriesLimited investigationFinal reportCessna T210R · Tunkhannock, PAUse of improper procedures during a short field landing which resulted in an overrun and noseover.NTSB ATL94LA169Accident · No injuriesLimited investigationFinal reportCessna T210M · Willacooche, GAThe pilot's excessive fuel leaning during improper use of the mixture control, which resulted in pre-ignition/detonation and a total loss of engine power. Factors were the electrical wires and vehicles.