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 SEA93LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-46 · Twin Falls, IDThe pilot's failure to maintain the ILS glide path.NTSB CHI93LA040Accident · No injuriesLimited investigationFinal reportCessna 401B · Rice Lake, WIImproper rigging of the right main landing gear retract bellcrank by other maintenance personnel.NTSB SEA93LA022Accident · No injuriesLimited investigationFinal reportCessna 210N · Spokane, WAThe pilot's premature retraction of the gear. Factors include a wet and icy runway.NTSB FTW92GA227Accident · No injuriesFinal reportCessna T210L · Spring, TXThe pilot under instruction failure to follow the landing checklist and the instructor pilot's inadequate supervision. A factor was the overheated landing gear motor.NTSB SEA92LA194Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · The Dalles, ORA misjudged approach. Factors to the accident were: inaccurate fuel consumption calculations and fuel exhaustion.NTSB ATL92FA167Accident · 2 fatalField investigationFinal reportCessna 402B · Miramar, FLThe failure of the pilot to perform preflight planning in that the weight and balance of the aircraft were exceeded. The pilot's lack of experience in the type of aircraft and lack of multiengine certification.NTSB NYC92FA150Accident · 1 fatalField investigationFinal reportCessna 340 · Falmouth, KYThe improper decision by the non-instrument-rated pilot to attempt VFR flight into instrument meteorological conditions resulting in a loss of airplane control and subsequent inadvertent spiral and collision with the ground. Factors related to the accident…NTSB SEA92FA140Accident · 1 fatalField investigationFinal reportBeech A36TC · Ballantine, MTThe pilot-in-command's physical impairment and his continued VFR flight into instrument meteorological conditions. Factors relating to the accident were: the weather conditions and the hilly terrain.NTSB ATL92LA133Accident · No injuriesLimited investigationFinal reportCessna 402B · Tuscaloosa, ALThe improper installation of the emergency exit, by an unknown person, which resulted in its separation, in flight.NTSB SEA92LA122Accident · No injuriesLimited investigationFinal reportNorth American Navion · Spokane, WAThe partial failure of the nose gear trunnion. Factors include the pilot's decision to land with the gear in the up position.NTSB LAX92WA231Accident · Minor injuriesForeign investigationPiper PA-46-310P · Yokota, JapanNTSB LAX92LA233Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Fallbrook, CAThe loss of engine power due to a disconnection of the turbocharger inlet duct.NTSB SEA92LA087Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Prineville, ORThe pilot in command delaying his decision to divert for fuel, overloading of the nose gear strut and the pilot in command's inability to maintain aircraft control subsequent to the nose wheel separation. Factors contributing to the accident were: the pilot…NTSB SEA92LA082Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mona, UTA fatigue failure to the crankshaft and a manufacturing material defect.NTSB LAX92FA174Accident · 5 fatalField investigationFinal reportCessna P210N · Baxter, CA1) A partial loss of the airplane's vacuum system which resulted in the total loss of the directional gyro and the attitude indicator, 2) the pilot not maintaining aircraft control due spatial disorientation, and 3) the pilot not correcting for a spiral by…NTSB FTW92LA109Accident · No injuriesLimited investigationFinal reportCessna T188C · Cordel, OKThe animals in the landing area. A factor was the loss of engine power for undetermined reasons.NTSB MIA92IA100Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe total failure of the main landing gear uplock and sequencing valve for undetermined reasons.NTSB BFO92LA037Accident · No injuriesLimited investigationFinal reportPiper 46-310P · Lima, OHThe pilot failure to maintian adequate airspeed during final approach which resulted in a stall. Contributing to the accident was ice on the wings.NTSB SEA92LA051Accident · No injuriesLimited investigationFinal reportBeech A36TC · Salt Lake City, UTThe pilot's inadvertent activation of the fuel boost pump. Factors to the accident were: poor aircraft preflight. Diverted attention, and inadequate remedial action.NTSB BFO92LA028Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Baltimore, MDThe failure of the fuel line, for undetermined reasons, resulting in a fuel leak causing an engine fire and total power loss.NTSB CHI92LA076Accident · No injuriesLimited investigationFinal reportCessna 414 · Gaylord, MIDirectional control was not maintained by the pilot. Factors related to the accident were: airport snow removal had not been performed by the airport personnel, a dark night with falling snow and the snowbank on the runway.NTSB MIA92FA058Accident · 1 fatalField investigationFinal reportCessna 402B · Lantana, FLThe pilot in commands failure to maintain airspeed above single engine minimum control speed resulting in an inflight loss of control and collision with terrain. Contributing to the accident was the pilot in command's failure to declare an emergency and…NTSB LAX92LA098Accident · No injuriesLimited investigationFinal reportMooney M20J · Bullhead City, AZThe pilot of the other aircraft inadvertently landing on the taxiway instead of the active runway.NTSB LAX92LA077Accident · No injuriesLimited investigationFinal reportPiper PA46-310P · Carson City, NVThe failure of the pilot to arrest an excessive sink rate resulting in not attaining the proper touch down point and landing short of the runway threshold. Contributing to the accident was an excessive runway end lip due to inadequate runway end maintenance.NTSB CHI92LA047Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mt Pleasant, MIWater in the fuel, and an inadequate preflight by the pilot.NTSB FTW92FA029Accident · Serious injuriesField investigationFinal reportCessna 402B · Roanoke, TXThe operation of the airplane with known deficiencies, a missing air cooling baffle, and inadequate maintenance. Factors were the frozen propeller, inability of the pilot to feather the propeller, inoperative landing gear, the inability of the pilot to…NTSB NYC92FA029Accident · 5 fatalField investigationFinal reportCessna 340 · Columbus, OHThe pilot's improper execution of an emergency procedure, after an engine failure, which resulted in the loss of airplane control. Factors related to the accident were: the pilot's improper management of the fuel system; the pilot's lack of proficiency in…NTSB BFO92LA004Accident · No injuriesLimited investigationFinal reportCessna T210N · Wheeling, WVThe engine failure caused by fuel starvation and the pilot's improper fuel management.NTSB LAX92LA001Accident · Serious injuriesLimited investigationFinal reportBeech A36TC · Dunsmuir, CA1) Improper preflight planning by the aircraft owner, 2) failure of the owner to refuel the aircraft, 3) operation of the aircraft by the owner and a mechanic at a known fuel state below the minimum required for takeoff, and 4) failure of the mechanic to…NTSB MIA91WA212Accident · No injuriesForeign investigationCessna 402 · Andros Island, BahamasNTSB NYC91LA222Accident · No injuriesLimited investigationFinal reportCessna T-210-M · Clearfield, PAVapor lock of the fuel system resulting in fuel starvation. A factor related to the accident was the failure of the owner to comply with a service letter calling for insulated fuel lines forward of the fire wall.NTSB NYC91LA216Accident · No injuriesLimited investigationFinal reportCessna TU206G · Block Island, RIImproper planning/decision by the pilot by electing to takeoff with a known deficiency with the equipment. The deficiency (cracked/leaking float) was a related factor.NTSB SEA91LA214Accident · No injuriesLimited investigationFinal reportBeech 58TC · Kalispell, MTThe pilot's failure to extend the landing gear. A factor contributing to the accident was the pilot's failure to identtify a down and locked landing gear condition prior to touchdown.NTSB ATL91FA161Accident · 3 fatalField investigationFinal reportCessna 402B · Kathleen, GAThe pilot's failure to maintain aircraft control while descending at night. Factors related to the accident were: darkness, fog, the pilot's lack of qualification in multi-engine aircraft, his lack of experience in this type of aircraft, his overconfidence in…NTSB LAX91LA350Accident · No injuriesLimited investigationFinal reportCessna 402C · Grand Canyon, AZThe failure of the airport operator to develop animal control procedures for the airport property.NTSB NYC91LA198Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Atlantic City, NJThe failure of the pilot of N6877M to insure the runway was clear prior to pulling onto the runway.NTSB CHI91DCJ04Accident · No injuriesFinal reportCessna T188C · Grand Island, NEThe pilot's failure to maintain adequate clearance from crops during aerial application maneuvers. Related factors are the failure of a propeller pitch change mechanism and the pilot's diverted attention.NTSB SEA91LA189Accident · No injuriesLimited investigationFinal reportBeech V35A · Weiser, IDThe pilot did not refuel the airplane resulting in fuel exhaustion.NTSB CHI91DTG04Accident · No injuriesFinal reportCessna T188C · Walhalla, NDInadequate compensation for wind conditions, and failure to maintain directional control. Factors related to the accident are gusty crosswind conditions.NTSB SEA91LA117Accident · Minor injuriesLimited investigationFinal reportCessna T-210N · Klamath Falls, ORThe loss of engine power due to failure of the number 5 cylinder rod bearing which resulted from lack of lubrication of the main bearing.NTSB SEA91LA118Accident · No injuriesLimited investigationFinal reportBeech A36TC · Ogden, UTLoss of control by the pilot due to inadequate preflight planning and preparation which resulted in over gross weight aircraft loading. A factor relating to the accident was the high density altitude weather conditions.NTSB MIA91LA139Accident · 1 fatalLimited investigationFinal reportCessna TU-206G · Gulf Of MexicoAn in flight collision with the water for undetermined reasons.NTSB NYC91LA127Accident · No injuriesLimited investigationFinal reportCessna 414A · Piqua, OHThe pilot's incomplete preflight of the fuel quantity and the inaccurate fuel gages, which resulted in fuel starvation and total loss of engine power and subsequent forced landing on rough terrain. Factors relating to the accident were the pilot's improper…NTSB NYC91LA118Accident · No injuriesLimited investigationFinal reportCessna P210 · Olean, NYImproper flare by the pilot, which resulted in a hard landing. Factors related to the accident were: the pilot's lack of recent experience and the unfavorable wind condition.NTSB LAX91LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA 46 · North Hollywood, CAThe pilot-in-command's poor preflight planning, inadequate fuel consumption calculations which resulted in a loss of engine power due to fuel exhaustion, and the pilot-in-command's failure to follow air traffic control verbal instructions which would have…NTSB NYC91LA094Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Milleville, NJThe total loss of engine power caused by mechanical failure, which resulted in the pilot landing the airplane on unsuitable terrain.NTSB MIA91RA102Accident · 5 fatalForeign investigationCessna 402C · Treasure Cay, BahamasNTSB MIA91MA100Accident · 4 fatalMajor investigationFinal reportPiper PA-46-310P · Bronson, FLThe pilot's failure to activate the pitot heat before ascending above the freezing level in instrument meteorological conditions (IMC), followed by his improper response to erroneous airspeed indications that resulted from blockage of the pitot tube by…NTSB CHI91LA105Accident · No injuriesLimited investigationFinal reportCessna 401 · St. Louis, MOThe landing gear locking mechanism (bell crank) had fractured.NTSB LAX91FA117Accident · 1 fatalField investigationFinal reportBeech 58P · Green Valley, CAThe pilot's loss of aircraft control due to his disregard for and poor evaluation of significant weather advisories forecasting adverse weather conditions along the route of flight and the pilot's decision to initiate the flight.