NTSB investigations: Lycoming I0360 series

121 cases on aircraft whose registry engine model is Lycoming I0360 series, where the first occurrence was “Loss of control - in flight”. 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 ('41515')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
  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 CHI01LA153Accident · No injuriesLimited investigationFinal reportRockwell 112TC · Cambridge, MNThe pilot's inadequate compensation for the wind conditions and the failure to maintain control of the airplane. A factor associated with the accident were the trees that the airplane contacted during the aborted landing.Jun 3, 2001 · N4612W · Substantial damageNTSB SEA01IA113Incident · No injuriesIncident investigationFinal reportCessna 172S · Monroe, ORA degradation of aircraft control for undetermined reasons.May 31, 2001 · N571SP · No damageNTSB SEA01LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Corvallis, ORThe student instructor's failure to maintain the airplane's minimum control airspeed during a practice single-engine approach, and the flight instructor's failure to direct or accomplish a timely go-around, resulting in loss of aircraft control with…May 9, 2001 · N47GM · DestroyedNTSB NYC01LA097Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hagerstown, MDThe pilot's failure to maintain runway alignment during the landing phase. A factor in the accident was a sudden change in wind direction and speed.Apr 13, 2001 · N55134 · Substantial damageNTSB MIA01FA060Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Bethel, NCthe pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an in-flight collision with power lines and the subsequent impact with terrain. A factor in this accident was: the pilot's lack of recent instrument…Jan 14, 2001 · N3996T · DestroyedNTSB NYC01LA057Accident · No injuriesLimited investigationFinal reportMooney M-20J · Trenton, NJThe flight instructor's improper decision to allow his student to land in close proximity to a hovering helicopter.Dec 9, 2000 · N201MP · Substantial damageNTSB LAX01FA036Accident · 2 fatalField investigationFinal reportPiper PA28-200 · Teec Nos Pos, AZIn-flight loss of control resulting in airframe structural failure. Contributing to the accident was the pilot's inadvertant visual flight into instrument meteorological conditions.Nov 5, 2000 · N3032R · DestroyedNTSB MIA01LA023Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Daytona Beach, FLThe CFI's inadequate supervision of the dual student and the dual student's loss of directional control during landing.Nov 3, 2000 · N1519T · Substantial damageNTSB SEA00LA193Accident · No injuriesLimited investigationFinal reportHughes 269B · Laurel, MTFailure to maintain aircraft control during hover operations. Inadequate remedial action by the pilot was a factor.Sep 27, 2000 · N9503F · Substantial damageNTSB CHI00FA234Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Beloit, KSthe inadvertent stall. Factors relating to the accident were the pilot's low altitude, his abrupt pull up, the power lines, and his lack of recent flying experience.Aug 2, 2000 · N2732Q · DestroyedNTSB MIA00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fayette, ALThe pilot's failure to maintain directional and altitude control of the airplane during a ago-around maneuver, resulting in collision with a fence and utility pole.Feb 4, 2000 · N8924T · Substantial damageNTSB FTW00FA052Accident · 2 fatalField investigationFinal reportBeech D95A · Boyd, TXThe instructor pilot's inadvertent stall/spin.Dec 22, 1999 · N456E · Substantial damageNTSB LAX99FA275Accident · 2 fatalField investigationFinal reportMooney M20E · Las Vegas, NVThe pilot's steep turn at low altitude that resulted in an accelerated stall while in the landing configuration, leading to a loss of control and subsequent ground impact.Aug 20, 1999 · N2654W · Substantial damageNTSB IAD99FA038Accident · 4 fatalField investigationFinal reportBeech BE-95A · Shawsville, VAthe pilot's inadequate preflight planning which resulted in intentional flight into known severe turbulence and the subsequent loss of control. Factors in the accident were the turbulence in instrument meteorological conditions and an airplane loaded over the…Apr 12, 1999 · N3113K · DestroyedNTSB ATL99FA066Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Tallahassee, FLThe pilot's failure to maintain flying speed during initial climb which resulted in a stall and uncontrolled collision with terrain.Apr 1, 1999 · N15478 · DestroyedNTSB CHI99FA101Accident · 1 fatalField investigationFinal reportMooney M20F · Cabool, MOThe pilot not maintaining an appropriate airspeed during the turn from base to final resulting in a stall.Mar 4, 1999 · N9381M · DestroyedNTSB FTW98FA378Accident · 2 fatalField investigationFinal reportMooney M20F · Fort Collins, COThe pilot's inadvertent stall/mush due to his excessive angle of bank during his traffic pattern turn to base. Factors were the pilot's improper downwind altitude, the pilot not properly setting his Kollsman Window in his altimeter, and the high density…Aug 29, 1998 · N377X · DestroyedNTSB FTW98LA356Accident · No injuriesLimited investigationFinal reportHughes 269B · Uvalde, TXThe pilot's failure to maintain control during a vertical, out of ground effect takeoff which resulted in a hard emergency landing. Factors were; the exceeded hover performance of the helicopter, the high density altitude, and the lack of suitable terrain for…Aug 7, 1998 · N9425F · Substantial damageNTSB CHI98LA204Accident · 1 fatalLimited investigationFinal reportCessna 172R · Greenfield, INthe pilot's incapacitation due to a heart attack. A factor in the accident was the passenger's, a non-pilot, improper recovery from a bounced landing which resulted in an overload failure of the nose gear.Jun 17, 1998 · N387MA · Substantial damageNTSB CHI98LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Sikesville, MOthe deer which ran in front of the airplane during the landing flare. Factors associated with the accident were the inadequate airspeed which resulted in the pilot not being able to maintain directional control of the airplane as he attempted to avoid deer,…May 31, 1998 · N9324N · Substantial damageNTSB FTW98LA085Accident · No injuriesLimited investigationFinal reportMooney M20J · Westport, OKThe pilot's inadequate compensation for the existing wind conditions. A factor was gusty winds.Jan 2, 1998 · N201LG · Substantial damageNTSB FTW97LA153Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Marietta, OKThe pilot's inadequate short field takeoff. A factor was the pilot's lack of recent experience in short field takeoffs from a grass/turf runway.Apr 6, 1997 · N6492Q · Substantial damageNTSB BFO96FA034Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Louisville, KYfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall, loss of altitude, and subsequent collision with obstructions (utility pole and supporting cable).Dec 30, 1995 · N7676J · DestroyedNTSB ATL95LA175Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Hoover, ALThe pilot's failure to maintain directional control when he positioned the helicopter in a hover so as to induce a loss of tail rotor effectiveness.Sep 27, 1995 · N267RW · Substantial damageNTSB CHI95LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Wheeling, ILthe pilot's abrupt raising of the flaps during the attempted go-around and the resulting stall.Aug 12, 1995 · N43847 · Substantial damageNTSB NYC95IA164Incident · No injuriesIncident investigationFinal reportEnstrom F-28A · Philadelphia, PAthe pilot's failure to maintain aircraft control resulting in a collision with the water.Jul 9, 1995 · N203Q · Minor damageNTSB NYC95LA012Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Shelburne, VTThe pilot's inadequate compensation for wind conditions which resulted in a loss of tail rotor effectiveness.Oct 15, 1994 · N9238 · Substantial damageNTSB MIA94FA031Accident · 1 fatalField investigationFinal reportMooney M20E · Jacksonville, FLFailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall. A factor related to the accident was: the lack of altitude for recovery from a stall.Nov 30, 1993 · N9241V · Substantial damageNTSB NYC94LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Bowling Green, OHThe flight instructor's inadequate supervision of an attempted go-around by the student pilot which resulted in a loss of control and subsequent impact with the terrain. Factors were noncompliance with published procedures.Oct 24, 1993 · N2874T · Substantial damageNTSB CHI93LA361Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Fenton, MOFailure of the pilot to maintain lateral (roll) and directional control of the airplane, when one engine hesitated to respond to application of power during an attempted go-around. Factors related to the accident were: the crosswind and the pilot's inadequate…Sep 15, 1993 · N3084T · Substantial damageNTSB LAX93GA195Accident · 2 fatalFinal reportMooney M20J · Sedona, AZUndetermined.May 1, 1993 · N201GK · DestroyedNTSB SEA93FA091Accident · 4 fatalField investigationFinal reportLake LA-4-200 · Gold Bar, WAThe pilot's failure to maintain adequate airspeed while maneuvering for a water landing.Apr 4, 1993 · N39375 · Substantial damageNTSB SEA93IA073Incident · No injuriesIncident investigationFinal reportHughes 269B · Mcminnville, ORAn inflight loss of control, and inadequate remedial action. Factors include a tailwind, and gusts.Mar 5, 1993 · N9474F · Minor damageNTSB FTW92FA163Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Bethany, OKThe pilot's failure to maintain control which resulted in an inadvertent stall. The gusty wind was a factor.Jun 17, 1992 · N7419J · DestroyedNTSB SEA92LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · W. Yellowstone, MTA stall/mush encountered due to poor pre-flight planning/preparation. Factors to the accident were: high density altitude and gross weight exceeded.Jun 15, 1992 · N2839R · Substantial damageNTSB BFO92LA077Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Westhampton Bch, NYThe pilot's inadequate landing flare which resulted in a hard landing. Contributing was the pilot's failure to maintain directional control and inadequate supervision.May 25, 1992 · N15109 · Substantial damageNTSB BFO92FA051Accident · 2 fatalField investigationFinal reportSam R. Crowell SH-2R · Somerville, VAThe pilot's inadequate handling of aircraft during aerobatic maneuver which resulted in a loss of control. Contributing factors were lack of experience in operation.May 3, 1992 · N1RX · DestroyedNTSB FTW90LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Denton, TXThe instructor pilot's failure to take control of the aircraft in a timely manner, resulting in loss of control. A factor was the instructor's failure to assume control of the throttles, and aircraft engine out capability exceeded.Aug 8, 1990 · N15515 · Substantial damageNTSB FTW90LA128Accident · No injuriesLimited investigationFinal reportMooney M-20E · Luling, TXLoss of control in-flight due to the pilot's failure to maintain adequate airspeed. Factors would be the high density altitude and the tree that he hit.Jun 29, 1990 · N9376V · Substantial damageNTSB CHI90LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Jenison, MIThe pilot's failure to maintain adequate airspeed during the approach. A contributing factor was the icing condition that existed at the time of the accident.Dec 29, 1989 · N1294T · Substantial damageNTSB MIA90FA014Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Athens, TNLoss of control of the airplane in instrument flight conditions due to spatial disorientation, which resulted in an inadvertent descending spiral. Lack of total experience in the type of operation (actual instrument conditions) was considered to be a…Oct 18, 1989 · N5005S · DestroyedNTSB NYC89LA213Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Boston, MAFailue of pilot to maintain control of the helicopter when a passenger inadvertently pushed the cyclic control. The fence (near the helipad) was considered to be a factor.Sep 8, 1989 · N203Q · Substantial damageNTSB FTW89LA149Accident · No injuriesLimited investigationFinal reportMooney M20F · Davis, OKThe pilot's failure to maintian directional control and properly flare the airplane during landing.Aug 15, 1989 · N6814V · Substantial damageNTSB NYC89FA015Accident · 4 fatalField investigationFinal reportBeech A24R · Blue Bell, PAImproper VFR procedures, the pilot failed to maintian adequate airspeed for the attitude of flight of the airplane causing it to stall and collide with trees and a powerline during recovery.Oct 20, 1988 · N1RJ · DestroyedNTSB NYC88FA229Accident · 4 fatalField investigationFinal reportPiper PA-28R-201 · Pomfret, CTThe Piper arrow PA-28R-201, had asked ATC for vectors to windam airport. After being vectored the pilot requested his distance from the airport. He was told that he was 12 miles from the airport, the pilot then decided to descend. ATC advised the pilot to…Aug 28, 1988 · N3478M · DestroyedNTSB CHI88LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Dodgeville, WIDuring an attempted landing in gusty wind, the pilot failed to maintain directional control, got blown off to the left side of the runway and experienced a tail strike. The pilot attempted to abort the landing, but was unable to climb out of ground effect,…Aug 13, 1988 · N47804 · Substantial damageNTSB CHI88FA145Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Detroit Lakes, MNJun 29, 1988 · N44140 · Substantial damageNTSB NYC88LA136Accident · Serious injuriesLimited investigationFinal reportBeech A23-24 · Lyons, NYPilot failed to maintain airspeed during his go around.May 8, 1988 · N7982L · DestroyedNTSB DEN88LA076Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Miles City, MTFeb 21, 1988 · N6693R · Substantial damageNTSB DEN87FA186Accident · 2 fatalField investigationFinal reportMooney M20E · Vail, COThe pilot proceeded up a box canyon while on a cross-country flight. When unable to out climb terrain, the pilot attempted to reverse direction. During the turn, the aircraft stalled and crashed into trees. The pilot had not received instruction in mountain…Jul 17, 1987 · N71SB · Destroyed