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.

NTSB ERA18LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA34 · Gulf Shores, ALThe pilot's improper preflight and in-flight fuel planning, which resulted in fuel exhaustion to the left engine and a total loss of engine power during an attempted go-around maneuver.Jul 7, 2018 · N294AB · Substantial damageNTSB ERA18FA148Accident · 1 fatalField investigationFinal reportPiper PA34 · Bennington, VTThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in a loss of control during a turn.May 20, 2018 · N1101X · DestroyedNTSB WPR18LA124Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 34-220T · Clewiston, FLThe pilot's failure to maintain directional control during takeoff following an overboost of the right engine during takeoff.Apr 20, 2018 · N8404B · Substantial damageNTSB WPR18FA091Accident · 1 fatalField investigationFinal reportPiper PA34 · Minden, NVThe pilot's loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot's impairment from the use of a sedating antihistamine.Feb 19, 2018 · N14GQ · DestroyedNTSB ANC18FA024Accident · 1 fatalField investigationFinal reportMooney M20 · Chuckanut, WAThe pilot's failure to maintain clearance from terrain during a visual approach in dark night visual meteorological conditions, which resulted in controlled flight into terrain.Feb 13, 2018 · N123JN · DestroyedNTSB CEN18LA093Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-220T · Patterson, LAThe pilot's inadequate in-flight fuel management, which resulted in a dual loss of engine power due to fuel exhaustion.Feb 6, 2018 · N9148B · Substantial damageNTSB ERA18LA058Accident · No injuriesLimited investigationFinal reportMooney M20K · Venice, FLA failure of the normal landing gear extension system for reasons that could not be determined due to damage to the system and the pilot's failure to ensure that the landing gear was down and locked before touchdown. Contributing to the accident was the…Dec 22, 2017 · N5254G · Substantial damageNTSB CEN18LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · Versailles, MOThe total loss of engine power due to fuel starvation when the cap fitting came off the inlet tee fitting on the throttle body/fuel metering unit.Dec 19, 2017 · N555WM · Substantial damageNTSB WPR18LA044Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 34-200T · Glendale, AZThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the fatigue of the left main landing gear assembly.Dec 5, 2017 · N47536 · Substantial damageNTSB ERA18LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-220T · Ebensburg, PAThe pilot's improper decision to fly an airplane with a known oil leak, which led to a total loss of engine power due to oil starvation. Contributing to the accident was the pilot's decision to land with a tailwind, which led to his attempted go-around and…Nov 25, 2017 · N263DM · Substantial damageNTSB WPR18LA033Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28R-201T · Nipton, CAA loss of engine power due to the detonation of the No. 5 cylinder due to excessive leaning at high power settings, which resulted in a forced landing and the subsequent hard touchdown.Nov 17, 2017 · N5966V · Substantial damageNTSB GAA17CA580Accident · No injuriesData collectionFinal reportMooney M20K · Los Lunas, NMThe pilot’s improper glidepath during a night approach, which resulted in impact with terrain short of the runway.Nov 7, 2017 · N231JD · Substantial damageNTSB CEN18LA008Accident · No injuriesLimited investigationFinal reportPiper PA 34-220T · Sugar Grove, ILA partial loss of engine power for reasons that could not be determined based on the available information.Oct 6, 2017 · N4136D · Substantial damageNTSB GAA17CA472Accident · No injuriesData collectionFinal reportMooney M20 · Skiatook, OKThe pilot's improper decision to conduct the flight despite the fuel gauges indicating that there was insufficient fuel for the flight, which resulted in the low amount of fuel in the right tank becoming unported during the multiple turns, and his subsequent…Aug 2, 2017 · N95442 · Substantial damageNTSB GAA17CA162Accident · No injuriesData collectionFinal reportCessna T337 · Linden, NJThe pilot’s abrupt maneuver to avoid birds during short final approach, which resulted in a hard, bounced landing.Feb 24, 2017 · N685V · Substantial damageNTSB CEN17WA086Accident · 1 fatalForeign investigationMooney M20K · Saarbrucken, GermanyOn October 27, 2016, about 0946 UTC, a Mooney M20T, N400MW, owned and operated by a private individual, impacted on the runway at the Saarbrucken-Ensheim Airport (EDDR), Saarbrucken, Germany. The pilot on board was fatally injured and the airplane was…Oct 27, 2016 · N400MW · Substantial damageNTSB GAA16CA454Accident · No injuriesData collectionFinal reportPiper PA 34 · Fort Lauderdale, FLThe other pilot's failure to ensure that the brake was fully engaged and his subsequent failure to notice that his airplane was rolling forward, which resulted in it hitting another airplane.Aug 13, 2016 · N8166U · 2 aircraft · Minor damageNTSB WPR16FA158Accident · 1 fatalField investigationFinal reportPiper PA 34-200T · Flagstaff, AZA departure flight path that consisted of several unexplained turns during the initial climbout, and terminated in a high-speed descent and ground impact. The reason(s) for the turns and descent could not be determined due to lack of definitive evidence.Aug 3, 2016 · N82806 · DestroyedNTSB WPR16FA095Accident · 1 fatalField investigationFinal reportMooney M20K · Woodland, WAThe pilot's delay in recognizing that the airplane was not performing as expected and aborting the takeoff, which resulted in collision with a berm beyond the end of the runway. Contributing to the accident were the pilot's exceedance of the airplane's gross…Apr 21, 2016 · N97119 · Substantial damageNTSB ERA16FA150Accident · 1 fatalField investigationFinal reportMooney M20K · Ocala, FLThe pilot's failure to maintain sufficient airspeed following a loss of engine power, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's inadvertent placement of the…Apr 9, 2016 · N96398 · Substantial damageNTSB ERA15LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA 28RT-201T · Dawson Springs, KYThe fatigue failure of a crankshaft counterweight, which resulted in a total loss of engine power during cruise flight.Sep 29, 2015 · N2175K · Substantial damageNTSB ERA15LA345Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201T · Atmore, ALA total loss of engine power due to oil starvation caused by insufficiently torqued cylinder through bolt nuts, which caused bearings to shift and led to the subsequent failure of the No. 3 connecting rod.Sep 7, 2015 · N44903 · Substantial damageNTSB CEN15LA279Accident · No injuriesLimited investigationFinal reportMooney M20K · Sheboygan, WIOil starvation due to preignition in the No. 5 cylinder as a result of failed spark plugs; the top and sides of the piston head were eroded, which allowed the exhaust gases caused by the preignition to pressurize the crankcase and force engine oil out of the…Jun 21, 2015 · N1168Z · Substantial damageNTSB WPR15LA175Accident · No injuriesLimited investigationFinal reportMooney M20K · Fresno, CAA total loss of engine power during cruise flight due to a failure of the No. 1 piston and connecting rod assembly.Jun 3, 2015 · N3567H · Substantial damageNTSB ERA15CA157Accident · No injuriesData collectionFinal reportMooney M20K · Laurel, MDThe pilot's improper decision to attempt a nighttime landing at an unsuitable airport, which resulted in a collision with the precision approach path indicator.Mar 16, 2015 · N231KA · Substantial damageNTSB CEN15FA101Accident · 1 fatalField investigationFinal reportPiper PA 28RT-201T · Brighton, COThe pilot's intentional descent into the terrain.Jan 11, 2015 · N82828 · DestroyedNTSB ERA15FA088Accident · 4 fatalField investigationFinal reportPiper PA34 · Kuttawa, KYThe pilot's failure to properly set the left engine fuel selector before takeoff and to recognize the incorrect setting during the flight, which resulted in fuel starvation and a loss of engine power on both engines.Jan 2, 2015 · N81291 · Substantial damageNTSB CEN15FA087Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Port Huron, MIThe pilot’s decision to continue flight below the minimum descent altitude without visually acquiring the runway and his delayed and improperly executed missed approach procedure in instrument meteorological conditions.Dec 24, 2014 · N38884 · DestroyedNTSB CEN15LA062Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201T · Addison, TXThe pilot's failure to maintain directional control during landing with a gusting crosswind, which resulted in a hard landing adjacent to the runway.Nov 30, 2014 · N533MC · Substantial damageNTSB CEN15FA044Accident · 1 fatalField investigationFinal reportMooney M20K · Clines Corners, NMThe noninstrument-rated pilot's decision to initiate the flight into known deteriorating weather conditions and his continued visual flight into instrument meteorological conditions, which ultimately resulted in a loss of airplane control. Contributing to the…Nov 13, 2014 · N231JF · DestroyedNTSB CEN14LA489Accident · No injuriesLimited investigationFinal reportGallager John C Glasair · Highland Heights, OHThe pilot’s loss of aircraft control during landing, and his failure to maintain directional control.Sep 5, 2014 · N4PX · Substantial damageNTSB ERA14CA420Accident · No injuriesData collectionFinal reportMooney M20K · Vero Beach, FLThe failure of the pilot and personnel from the fixed base operator to assure the correct ground power unit was utilized to provide external power, resulting in damage to the aircraft's electrical wiring and subsequent damage to structure adjacent to the…Aug 23, 2014 · N231MN · Substantial damageNTSB ERA14CA406Accident · No injuriesData collectionFinal reportPiper PA 34-200T · Gainesville, FLThe pilot's inadequate landing flare, which resulted in a bounced landing.Aug 11, 2014 · N178SB · Substantial damageNTSB ERA14CA376Accident · Minor injuriesData collectionFinal reportPiper PA 34-220T · Gulf Shores, ALThe pilot's improper flare, which resulted in a bounced landing and subsequent loss of aircraft control.Aug 6, 2014 · N212RW · Substantial damageNTSB CEN14LA474Accident · No injuriesLimited investigationFinal reportPiper PA 28RT-201T · Houston, TXThe landing gear’s failure to extend for reasons that could not be determined based on the available evidence.Jul 27, 2014 · N2148J · Substantial damageNTSB ERA14CA284Accident · No injuriesData collectionFinal reportPiper PA-28-201T · Defuniak Springs, FLThe pilot's failure to maintain directional control in gusty wind conditions during landing, which resulted in a runway excursion and collision with terrain.Jun 6, 2014 · N2890Z · Substantial damageNTSB WPR14CA215Accident · No injuriesData collectionFinal reportPiper PA28R - 201T · Novato, CAThe pilot's failure to maintain directional control during landing roll with a crosswind, which resulted in a runway excursion and impact with terrain.May 27, 2014 · N222RS · Substantial damageNTSB ERA14LA242Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Georgetown, DEThe pilot’s improper preflight planning and in-flight fuel management, which resulted in fuel starvation and a total loss of engine power. Also causal to the accident was the pilot’s failure to see and avoid the wires on the airport boundary.May 18, 2014 · N200DP · Substantial damageNTSB ERA14LA024Accident · Serious injuriesLimited investigationFinal reportPiper PA 28R-201T · Everglades City, FLThe pilot’s failure to maintain airplane control and airspeed during a go-around, which resulted in a stall and impact with terrain. Contributing to the accident were the pilot’s inadvertent use of an outdated GPS navigation database, which provided an…Oct 27, 2013 · N2702M · Substantial damageNTSB ERA13CA357Accident · No injuriesData collectionFinal reportPiper PA-34-200T · West Mifflin, PAThe pilot's improper landing flare, which resulted in a hard landing.Aug 4, 2013 · N75131 · Substantial damageNTSB CEN13FA429Accident · No injuriesField investigationFinal reportPiper PA-28R-201T · Holdrege, NEThe loss of engine power during takeoff due to the activation of the primer diverter valve.Jul 19, 2013 · N31698 · Substantial damageNTSB CEN13LA388Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Hudson, COThe pilot's improper fuel management, which resulted in the loss of engine power due to fuel starvation.Jun 28, 2013 · N5254G · Substantial damageNTSB ERA13IA267Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Tallahassee, FLThe failure of the elevator trim cable due to fatigue cracking, which resulted from maintenance personnel’s repeated inadequate inspection of the cable.Jun 3, 2013 · N633TC · No damageNTSB ERA13FA253Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Johnstown, NYThe pilot's loss of control due to spatial disorientation in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations, and a subsequent in-flight breakup.May 24, 2013 · N31743 · DestroyedNTSB ERA13LA113Accident · 1 fatalLimited investigationFinal reportPiper PA-34-200T · Manteo, NCThe pilot's attempted visual flight in instrument meteorological conditions while maneuvering at a low altitude in the traffic pattern, which resulted in spatial disorientation and impact with the water. Contributing was the pilot's lack of experience flying…Jan 13, 2013 · N6537C · DestroyedNTSB ERA13LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Boca Raton, FLThe pilot's improper landing flare after a loss of engine power shortly after takeoff, which resulted in a hard landing. The reason for the loss of engine power could not be determined based on the available information.Dec 23, 2012 · N4340G · Substantial damageNTSB ERA12LA522Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Hernando Beach, FLA partial loss of engine power due to a blockage of the No. 6 cylinder fuel injector nozzle.Aug 22, 2012 · N2970G · Substantial damageNTSB CEN12CA461Accident · No injuriesData collectionFinal reportMooney M20K · Hutchinson, MNThe student pilot’s inadequate flare and failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with obstructions.Jul 20, 2012 · N262RW · Substantial damageNTSB WPR12CA240Accident · No injuriesData collectionFinal reportCessna P337H · Jerome, IDThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to use the checklist before landing.May 30, 2012 · N5KX · Substantial damageNTSB WPR12CA210Accident · No injuriesData collectionFinal reportPiper PA-28RT-201T · Mariposa, CAThe pilot's delay in aborting the takeoff, which resulted in a runway overrun.May 5, 2012 · N2195X · Substantial damage