NTSB investigations: Continental TSIO-360 series
500 cases on aircraft whose registry engine model is Continental TSIO-360 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 ('17019', '17023'))
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 ('17019', '17023'))
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 ATL98LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Tampa, FLIn-flight collision with a bird, which separated a fuel line causing a loss of engine power, and resulting in an emergency landing on unsuitable terrain.NTSB MIA98LA125Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Fort Lauderdale, FLThe failure of the O-rings in the landing gear hydraulic cylinder.NTSB SEA98IA044Incident · No injuriesIncident investigationFinal reportMooney M20K · Klamath Falls, ORThe pilot's inadequate preflight which failed to detect water contaminated fuel that subsequently led to fuel icing at altitude, blockage of fuel lines which resulted in fuel starvation. A related factor was the dark night conditions.NTSB CHI98LA077Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Winterset, IAThe pilot misjudging his airspeed on final approach, resulting in a long touchdown and insufficient distance to stop on the remaining runway available.NTSB CHI98LA054Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Lee'S Summit, MOthe pilot's inadequate remedial action concerning the loss of engine power, after inadvertently switching off the magnetos. Factors relating to the accident were: the broken springs for magneto cover guard; excessive drag from the extended landing gear and…NTSB CHI98LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Janesville, WIthe dual student's failure to obtain the proper touchdown point, and the instructor's failure to provide adequate supervision of the flight. Factors associated with the accident were: inadequate altitude, the student's diverted attention, the snowbank, and…NTSB CHI98LA042Accident · No injuriesLimited investigationFinal reportMooney M20K · Eden Prairie, MNthe pilot's improper decision to continue the approach beyond decision height, when he could not see the runway; and his attempt to land without being properly aligned on the runway. Factors relating to this accident were: darkness, fog and and runway lights.NTSB FTW98FA044Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Myton, UTThe pilot exceeded the design stress limits of the airplane which resulted in an in-flight airframe overload failure. A related factor was the dark night.NTSB LAX97LA282Accident · No injuriesLimited investigationFinal reportMooney M20K · Lakeport, CAthe pilot's inadequate preflight by failing to ensure that the fuel selector was positioned to a tank containing fuel, which resulted in fuel starvation, and a forced landing shortly after takeoff.NTSB CHI97LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Lansing, ILthe pilot's inadequate compensation for wind conditions, and his failure to maintain sufficient airspeed to flare during the landing. The crosswind was a related factor.NTSB FTW97LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28R-210T · Fort Collins, COthe pilot's failure to know and follow the emergency procedure for extending the landing gear after loss of electrical power. Factors relating to the accident were: an inoperative alternator, inadequate maintenance by the operator, a depleted battery, and…NTSB MIA97WA164Accident · No injuriesForeign investigationPiper PA-34-200T · Cotton Bay, BahamasNTSB MIA97LA131Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Stuart, FLThe pilot's failure to maintain directional control during a crosswind landing. Factors were the crosswind and his improper level off.NTSB LAX97LA153Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Healdsburg, CAThe loss of pressure in the landing gear normal brake system for undetermined reasons requiring the pilot to make an intentional ground loop to stop the aircraft.NTSB FTW97LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hartsel, COThe pilot's misjudging the proper touchdown point on the dirt road due to excessive airspeed and his failure to deploy flaps. Factors were the partial loss of engine lubricating oil due to the oil filler cap separating because some unknown person failed to…NTSB LAX97LA085Accident · No injuriesLimited investigationFinal reportMooney M20K · Van Nuys, CAthe pilot's failure to maintain directional control of the aircraft during landing rollout.NTSB ATL97LA009Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Amelia Island, FLinadequate maintenance/inspection, which resulted in a failure to detect and correct moisture contamination of the left magneto; and/or improper adjustment of the engine fuel pump output, which resulted in excessive fuel pressure.NTSB NYC96LA122Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Danbury, CTthe safety pilot's raising of the flaps, while the airplane was at an inadequate airspeed during the aborted landing, which resulted in a stall, uncontrolled descent, and subsequent collision with parked airplanes.NTSB CHI96LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · Wichita, KSthe pilot's failure to maintain directional control of the airplane during landing. A factor associated with the accident was the gusty crosswind condition.NTSB FTW96LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Columbus, TXthe pilot's improper inflight planning/decision to continue the flight instead of returning to the takeoff airport after encountering adverse weather. Factors were: the inaccurate weather forecast, the low ceiling and the lack of suitable terrain for the…NTSB NYC96LA087Accident · Serious injuriesLimited investigationFinal reportMooney M20K · West Milford, NJloss of engine power for undetermined reason(s), which resulted in a forced landing on unsuitable terrain and subsequent collision with trees.NTSB ATL96LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Gulfport, MSinadequate preflight planning/preparation by the pilot, and inadequate supply of fuel in the airplane, which resulted in fuel exhaustion and subsequent ditching at sea.NTSB FTW96LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-201T · Keller, TXthe inadequate visual lookout by the driver of the vehicle resulting in his obstructing the runway.NTSB ATL96LA005Accident · No injuriesLimited investigationFinal reportMooney M20K · Dalton, GAOil starvation for an unknown reason, which resulted in progressive connecting rod failure and subsequent loss of engine power. Factors relating to the accident were: the unfavoable weather and light conditions (low ceiling and fog at dusk), which hampered…NTSB NYC95WA219Accident · 6 fatalForeign investigationPiper PA-34-200T · Poznan, PolandNTSB SEA95LA190Accident · No injuriesLimited investigationFinal reportMooney M20K · Roundup, MTan engine failure due to foreign object ingestion into the oil pump. A ruptured oil inlet screen contributed to the accident.NTSB SEA95LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Tacoma, WAFuel starvation due to an unlocked mixture control that had not been properly rigged. A factor was the ditch in the emergency landing area.NTSB NYC95LA085Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Tangier Island, VAThe pilot's failure to maintain obstacle clearance which resulted in an inflight collision with a tree. Contributing factors are a crosswind and the pilot's failure to maintain directional control and his inadequate compensation for wind conditionsNTSB MIA95LA095Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Kissimmee, FLThe inadequate annual inspection by a mechanic that failed to detect corrosion that eventually failed the engine mounts and allowed the engine and nosegear to deflect to the side during landing roll.NTSB MIA95LA112Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Boynton Beach, FLThe failure of the pilot-in-command to obtain the proper touchdown point and his failure to flare properly.NTSB CHI95LA058Accident · No injuriesLimited investigationFinal reportMooney M20K · Minneapolis, MNthe pilot's misjudging of distance and airspeed during the approach to landing which resulted in an overrun. Factors associated with the accident were the separation of the exhaust pipe and the pilot's not understanding communications from the air traffic…NTSB FTW94FA208Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Southard, OKThe pilot's continued flight into known adverse weather resulting in the design limits of the airplane being exceeded. Factors were the thunderstorms and the pilot's disregard for the forecasted adverse weather.NTSB CHI94LA177Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Bolivar, MOthe failure of a pressure fuel line. A factor was the encountering of unsuitable terrain during a forced landing.NTSB NYC94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Warfordsburg, PAThe engine failure as a result of a main bearing shift and restricted lubrication, and the lack of suitable terrain for a forced landing.NTSB SEA94FA060Accident · 1 fatalField investigationFinal reportMooney M20K · Applegate, ORPoor in-flight planning/decision and icing conditions. Factors to the accident were: selected flight into known adverse weather, dark night, and mountainous terrain.NTSB CHI94LA078Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Delavan, WIthe pilot-in-command's not maintaining directional control and his inadequate compensation for wind conditions. Factors were icy runway and crosswind.NTSB FTW94LA068Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Dallas, TXThe pilot's failure to attain the proper touchdown point. A factor was the pilot's disorientation and dark night conditions.NTSB CHI93LA370Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · New Lenox, ILSelection of the wrong runway by the pilot after misreading the wind sock. The resultant tailwind was a related factor.NTSB BFO93LA151Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Williamson, WVA fire in the cockpit area for undetermined reasons.NTSB CHI93FAMS4Accident · 1 fatalMissing aircraftFinal reportMooney M20K · Hobart, INundetermined.NTSB BFO93LA072Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Simsbury, CTLack of braking action from the right brake. The pilot's failure to attain the proper touchdown point was a related factor.NTSB MIA93LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Boca Raton, FLThe failure of the pilot-in-command to maintain directional control while landing with a crosswind.NTSB LAX93LA146Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Avalon, CAThe pilot's poorly planned approach, excessive airspeed, and failure to attain the proper touchdown point. The pilot's lack of familiarity with the airport is a factor in this accident.NTSB CHI93FA063Accident · 3 fatalField investigationFinal reportCessna T337G · Smiths Creek, MIThe pilot-in-command's failure to maintain control of the airplane during the approach. Factors which contributed to the accident were the adverse weather conditions and the dark night.NTSB LAX93WA090Accident · No injuriesForeign investigationPiper PA-34-200 · Loreto, MexicoNTSB CHI93LA006Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Madison, WIWas the pilot's inadequate compensation for wind conditions which resulted in an improper flare. A factor related was the gusty wind condition.NTSB DEN92IA072Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Lamar, COFractured nose landing gear bolt due to fatigue.NTSB ATL92LA123Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Winnsboro, SCThe pilot's improper level off and his improper recovery from a bounced landing.NTSB LAX92LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Ludlow, CAThe failure of the repair station to adequately perform a top overhaul and comply with a service bulletin. Contributing to this accident was the failure of the connecting rod due to fatigue and unsuitable terrain.NTSB BFO92LA024Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Columbus, OHFuel starvation in both engines, due to the pilot's improper positioning of the engine or fuel controls.