NTSB investigations: Lycoming I0360 series

2,882 cases on aircraft whose registry engine model is Lycoming I0360 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 ('41515'))
  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 CHI03LA104Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Lino Lakes, MNThe pilot not maintaining aircraft control while manuevering.Apr 13, 2003 · N26HW · Substantial damageNTSB CHI03LA102Accident · No injuriesLimited investigationFinal reportCessna 172S · Grayslake, ILThe flight instuctor's improper in-flight decision to land with a tailwind and failure to maintain directional control of the airplane during landing. Factors contributing to the accident were the tailwind, the student pilot's inadequate flare, and the muddy…Apr 11, 2003 · N389SP · Substantial damageNTSB CHI03LA098Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Wichita, KSThe premature lowering of the collective and the improper use of the cyclic during the run-on landing performed by the flight instructor, as well as the main rotor/tail boom contact. Contributing factors were the intentional run-on landing, the grass landing…Apr 7, 2003 · N8968F · Substantial damageNTSB MIA03LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Sarasota, FLA loss of engine power due to the crankshaft bolt losing torque, the gear disengaging, and the engine ceasing to operate as a result of inadequate maintenance installation.Apr 1, 2003 · N4952J · Substantial damageNTSB IAD03CA044Accident · No injuriesData collectionFinal reportCessna 172S · Cleveland, OHThe student pilot's improper flare, which resulted in a hard landing.Mar 27, 2003 · N613SP · Substantial damageNTSB ATL03LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Enterprise, ALThe loss of engine power due to oil starvation resulting from a crack in the propeller governor external oil line. A factor was the soft terrain.Mar 16, 2003 · N7635J · Substantial damageNTSB LAX03LA112Accident · No injuriesLimited investigationFinal reportCessna 172R · Thermal, CAthe student pilot's failure to use aileron controls to compensate for the known crosswind and failure to maintain directional control during the landing rollout.Mar 11, 2003 · N4201Y · Substantial damageNTSB CHI03FA080Accident · 2 fatalField investigationFinal reportMooney M20J · Tower, MIThe pilot's failure to maintain aircraft control during cruise flight. A factor to the accident was the clouds and night conditions.Mar 10, 2003 · N201ZM · DestroyedNTSB NYC03LA048Accident · No injuriesLimited investigationFinal reportCessna 172SP · Flemington, NJThe manufacturer's improper assembly of the accessory drive section of the engine.Feb 19, 2003 · N197ME · Substantial damageNTSB SEA03LA037Accident · No injuriesLimited investigationFinal reportCessna 172S · Everett, WAThe pilot's failure to maintain adequate airspeed and the instructor's inadequate supervision of the flight. Contributing factors were the rime icing conditions, and the soft terrain encountered on the off runway rollout.Feb 9, 2003 · N912LB · Substantial damageNTSB SEA03FA038Accident · No injuriesField investigationFinal reportBeech A23 · Fort Klamath, ORThe separation of the rod end cap from the connecting rod for an undetermined reason during the descent for landing. The ditch was a factor.Feb 8, 2003 · N2392W · Substantial damageNTSB ATL03LA040Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Titusville, FLThe loss of engine power for undetermined reasons. The pilot's failure to attain full power for takeoff in accordance with the operation handbook was a factor.Feb 2, 2003 · N9769L · Substantial damageNTSB LAX03FA078Accident · 2 fatalField investigationFinal reportBeech D95A · Lancaster, CAa loss of aircraft control due to the instructor pilot's incapacitation by seizure activity as a result of his undiagnosed cancer, and his use of a medication that can increase seizure risk.Jan 31, 2003 · N5639S · DestroyedNTSB DEN03FA038Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · La Sal, UTthe loss of engine power (total) due to fuel starvation, the pilot not following procedures/directives (fuel management procedures), and the pilot's inadequate preflight planning/preparation for the flight. Contributing factors were the pilot's inadequately…Jan 24, 2003 · N106AW · DestroyedNTSB SEA03FA025Accident · No injuriesField investigationFinal reportMooney M20F · Tacoma, WAA loss of engine power during cruise flight due to fatigue failure of the crankshaft as a result of an inadequate quality of material during the manufacturing process. Trees were a factor.Jan 12, 2003 · N6442Q · Substantial damageNTSB FTW03LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Roanoke, TXThe failure of the main landing gear assembly and attach points for undetermined reasons.Jan 9, 2003 · N2981R · Substantial damageNTSB FTW03LA069Accident · Serious injuriesLimited investigationFinal reportWood Thorp T-18 · Stephenville, TXThe pilot's loss of directional control as result of his failure to compensate for the prevailing wind conditions. A contributing factor was the gusty crosswinds.Jan 1, 2003 · N335BW · Substantial damageNTSB NYC03LA032Accident · No injuriesLimited investigationFinal reportCessna 172S · Akron, OHThe pilot's improper flare which resulted in a hard landing.Dec 26, 2002 · N782SP · Substantial damageNTSB CHI03LA075Accident · No injuriesLimited investigationFinal reportCessna 172S · Tea, SDThe student pilot's improper flare. The pilot's lack of experience and diverted attention were factors.Dec 24, 2002 · N692SP · Substantial damageNTSB CHI03LA032Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Jeffersonville, INThe mechanical binding of the left main landing gear, which resulted in the left main landing gear not fully extending to the down-and-locked position. Factors to the accident were the oleo-strut linkage being corroded and the contamination of the gear…Dec 1, 2002 · N15723 · Substantial damageNTSB DEN03LA013Accident · No injuriesLimited investigationFinal reportMooney M20E · Broomfield, COthe pilot's failure to maintain directional control after landing due to a sheared steering horn attach bolt that should have been replaced by maintenance personnel in compliance with an outstanding service bulletin. Contributing factors included the pilot's…Nov 4, 2002 · N9288M · Substantial damageNTSB FTW03FA029Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · Las Vegas, NMThe pilot's inadvertent flight into instrument meteorological conditions and failure to maintain clearance with the terrain. A contributing factor was the pilot's failure to obtain an updated preflight weather briefing.Nov 3, 2002 · N566T · DestroyedNTSB ATL03LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Laurel Bloomery, TNThe pilot's failure to maintain clearance with terrain, which resulted in an inflight collision with mountainous terrain. Factors were the pilot's inadequate preflight planning and failure to obtain weather information, which resulted in an inflight encounter…Oct 31, 2002 · N15704 · DestroyedNTSB MIA03LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Cullman, ALthe pilot-in-command's (CFI) delayed remedial action, and improper recovery from a bounced landing, resulting in a hard landing, and impact with a parked airplane.Oct 9, 2002 · N22DB · Substantial damageNTSB DEN03LA004Accident · No injuriesLimited investigationFinal reportBeech C24R · Newcastle, UTthe pilot's failure to maintain clearance from the tree during takeoff. A factor was the reduced light conditions.Oct 9, 2002 · N18917 · Substantial damageNTSB SEA02LA187Accident · No injuriesLimited investigationFinal reportMooney M20J · Oakley, IDFailure (fracture) of the two number four piston compression rings, leading to the erosion of a section of the piston sidewall, resulting in the exhaustion of the engine's oil supply during cruise flight, followed by a forced landing on a country road.…Sep 30, 2002 · N4232H · Substantial damageNTSB SEA02FA185Accident · 2 fatalField investigationFinal reportCessna 172S · Medford, ORTerrain clearance was not maintained during cruise flight. Dark night and mountainous terrain were factors.Sep 30, 2002 · N514SP · Substantial damageNTSB NYC02FA200Accident · 1 fatalField investigationFinal reportMooney M20E · West Creek, NJThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel, and his failure to maintain airspeed.Sep 30, 2002 · N5556Q · DestroyedNTSB MIA02LA175Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Irvington, ALThe loss of engine power due to internal contamination (rust and water) of the servo fuel injector resulting in it flowing approximately half of the required fuel flow at full throttle. A contributing factor was the unsuitable terrain encountered by the pilot…Sep 29, 2002 · N2963R · Substantial damageNTSB CHI02LA295Accident · No injuriesLimited investigationFinal reportCessna 172R · Greenwood, ILThe CFI's poor inflight planning/decision to allow the airplane to get to too low of an altitude to assure a safe recovery from the simulated forced landing. Factors associated with the accident were the student pilot's delay initiating the go around and the…Sep 26, 2002 · N3510A · Substantial damageNTSB FTW02FA262Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Chromo, COThe flight instructor's failure to maintain clearance with the mountainous terrain during the cross-country flight. A contributing factor was the dark night light conditions.Sep 24, 2002 · N6227J · DestroyedNTSB CHI02LA291Accident · No injuriesLimited investigationFinal reportCessna 172S · Boyne Falls, MIThe pilot's improper flare during landing.Sep 21, 2002 · N784SA · Substantial damageNTSB LAX02FA288Accident · 3 fatalField investigationFinal reportMooney M-20E · Carlsbad, CAfailure of the pilots of both airplanes to maintain an adequate visual lookout and to see and avoid each other. A contributing factor was the failure of the controller to detect and resolve the conflict between the airplanes.Sep 17, 2002 · N7199U · 2 aircraft · DestroyedNTSB NYC02LA188Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Canadaigua, NYThe pilot's inadequate preflight inspection of the airplane, which resulted in a loss of engine power due to fuel contamination.Sep 16, 2002 · N201ZC · Substantial damageNTSB FTW02LA253Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Rector, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Sep 7, 2002 · N6369Q · Substantial damageNTSB IAD02LA092Accident · No injuriesLimited investigationFinal reportGoff Glassair · Stow, MAThe pilot's improper positioning of the throttle during engine start, which resulted in his inability to maintain control of the airplane.Sep 6, 2002 · N7223R · Substantial damageNTSB ATL02LA166Accident · No injuriesLimited investigationFinal reportCessna 172S · Immokalee, FLThe student pilot's improper flare at touchdown resulted in a hard landing while performing an off-airport precautionary landing after the inadvertent activation of the autopilot.Sep 6, 2002 · N827SP · Substantial damageNTSB DEN02LA104Accident · No injuriesLimited investigationFinal reportBeech D95A · Broomfield, COthe dual student pilot's inadvertent retraction of the landing gear. Contributing factors included the dual student's lack of familiarity with the airplane, and inadequate supervision by the flight instructor.Sep 5, 2002 · N2705T · Substantial damageNTSB CHI02FA262Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Newaygo, MIThe altitude/clearance disregarded by the pilot and his ostentatious display. The wire and low altitude flight were a contributing factor.Aug 28, 2002 · N4988J · DestroyedNTSB ATL02LA161Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Peachtree City, GAThe certified flight instructors failure to feather the propeller in accordance with operating procedures that resulted in loss of altitude and the in-flight collision with terrain.Aug 24, 2002 · N55210 · Substantial damageNTSB LAX02LA256Accident · Minor injuriesLimited investigationFinal reportDodd RV-4 · Tehachapi, CAthe owner/builder's improperly fabricated and installed fuel line, which cracked at the point of the flare, resulting in a fuel leak and loss of engine power during the takeoff climb. A contributing factor was the soft terrain that jammed the landing gear…Aug 21, 2002 · N62VR · Substantial damageNTSB LAX02FA255Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Echo Summit, CAThe pilot's decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were the rising mountainous terrain, and the high density altitude,Aug 19, 2002 · N7794C · DestroyedNTSB IAD02FA086Accident · 2 fatalField investigationFinal reportCessna 172S · Plainville, CTAn in-flight engine compartment fire of unknown origin, and a loss of engine power for undetermined reasons. Also causal, was the pilot's failure to maintain airspeed during a turn back to the airfield, which resulted in an inadvertent stall and subsequent…Aug 17, 2002 · N35073 · DestroyedNTSB NYC02LA161Accident · No injuriesLimited investigationFinal reportCessna 172RG · Rochester, NYThe pilot's improper flare and recovery from a bounced landing. A factor in the accident was the slow response time of the airspeed indicator.Aug 12, 2002 · N888RG · Substantial damageNTSB IAD02LA083Accident · No injuriesLimited investigationFinal reportMenzies Glassair II · Laconia, NHThe pilot's improper recovery from a bounced landing and his failure to maintain directional control.Aug 11, 2002 · N55RK · Substantial damageNTSB DEN02LA088Accident · No injuriesLimited investigationFinal reportCessna 172S · Englewood, COthe instructor's inadequate supervision of the flight and his premature raising of the flaps, resulting in a hard landing.Aug 4, 2002 · N238SP · Substantial damageNTSB NYC02FA142Accident · 2 fatalField investigationFinal reportBeech C24R · Grindstone, PAThe pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control resulting in overstress of aircraft. A factor was the thunderstorm activity.Jul 18, 2002 · N18860 · DestroyedNTSB FTW02LA202Accident · Minor injuriesLimited investigationFinal reportJackie SNS-7-Hiperbipe 3 · Lancaster, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's failure to maintain directional control during takeoff roll.Jul 6, 2002 · N234JD · Substantial damageNTSB MIA02LA126Accident · No injuriesLimited investigationFinal reportRockwell International 112TC · Atlantic Ocean (Atlantic Ocean)The pilot's improper planning/decision and insufficient refueling which resulted in the loss of engine power due to fuel exhaustion and the aircraft being ditched in the ocean.Jul 3, 2002 · N4561W · DestroyedNTSB CHI02LA179Accident · No injuriesLimited investigationFinal reportWaltz RV-8 · Omaha, NEA loss of engine power due to a loose connecting rod cap bolt and the resulting fatigue failure of the connecting rod cap. A related factor was the unsuitable terrain.Jun 30, 2002 · N877TC · Substantial damage