NTSB investigations: Lycoming O-360 series

308 cases on aircraft whose registry engine model is Lycoming O-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 ('41575'))
  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 LAX04LA277Accident · No injuriesLimited investigationFinal reportCessna 172RG · San Diego, CAThe pilot's failure to ensure that the landing gear was fully extended, by use of the emergency gear extension system, which resulted in its partial collapse during landing rollout. Also causal was the pilot's failure to follow POH procedures relating to…Jul 24, 2004 · N5167R · Substantial damageNTSB MIA04CA106Accident · No injuriesData collectionFinal reportPiper PA-28 · Okeechobee, FLStudent pilot's failure to maintain directional control of the airplane during landing roll, resulting in the airplane departing the runway and impacting a fence incurring substantial damage to the airplane.Jul 17, 2004 · N315PA · Substantial damageNTSB NYC04LA162Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Norfolk, VAThe pilot's failure to complete an autorotation due to the restrictive movement of the collective control.Jul 9, 2004 · N152SP · Substantial damageNTSB LAX04CA198Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Squaw Valley, CAthe pilot's failure to maintain a proper descent rate during the landing approach, which resulted in a hard landing and roll over. Also causal was the pilot's inadequate compensation for tailwind conditions. A factor in the accident was the high density…Apr 27, 2004 · N7521P · Substantial damageNTSB DEN04CA061Accident · No injuriesData collectionFinal reportRobinson R22 · Nephi, UTthe flight instructor's failure to maintain control of the helicopter resulting in a hard landing.Apr 14, 2004 · N555UH · Substantial damageNTSB NYC04CA094Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Louisville, KYThe student pilot's failure to maintain directional control while landing, and the CFI's delayed remedial action. A factor related to the accident was the gusting wind conditions.Mar 25, 2004 · N340PA · Substantial damageNTSB MIA04FA045Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Fort Pierce, FLThe flight instructor's failure to comply with the instrument approach procedure in that he descended prematurely below decision height resulting in an in-flight collision with trees, power lines and the ground. Contributing factors were the dark night light…Jan 19, 2004 · N298PA · DestroyedNTSB SEA04FA031Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Cave Junction, ORBoth the pilot-in-command and the co-pilot allowing the aircraft to enter into an area of adverse weather (icing conditions at low [-20 degrees C] temperatures) resulting in sequential induction icing, induction filter blockage, carburetor icing and the…Jan 2, 2004 · N53505 · Substantial damageNTSB DEN04LA030Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Broomfield, COthe flight instructor's failure to maintain aircraft control. Contributing to the accident was the wind gust.Dec 17, 2003 · N341MK · DestroyedNTSB LAX04FA067Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Redlands, CAa loss of engine power due to the pilot inadvertently turning off the magnetos and his failure to initiate an autorotation and to maintain main rotor rpm. A factor in the accident was the pilot's use of an over-the-counter medication that impaired his…Dec 15, 2003 · N1225D · DestroyedNTSB NYC03CA182Accident · No injuriesData collectionFinal reportKucklick Hiperbipe · Marion, OHThe pilot's improper decision to install an inadequate air filter, which subsequently failed and resulted in a power loss.Aug 23, 2003 · N258HB · Substantial damageNTSB MIA03LA166Accident · Minor injuriesLimited investigationFinal reportRobinson Robinson R22 Beta · Odessa, FLThe failure of the pilot to maintain the proper airspeed during the practice 180-degree autorotational landing and his failure to maintain main rotor rpm resulting in a hard landing. A contributing factor in the accident was the delay by the designated pilot…Aug 20, 2003 · N129YE · Substantial damageNTSB SEA03LA167Accident · No injuriesLimited investigationFinal reportAviat A-1B · Driggs, IDThe pilot's failure to maintain control of the aircraft during the landing roll. A contributing factor was the dust devil.Aug 11, 2003 · N233HY · Substantial damageNTSB CHI03FA218Accident · Serious injuriesField investigationFinal reportRobinson R22-Beta · Flint, MIThe loss of engine power for undetermined reasons, and the pilot's inadequate decision to land on an unsuitable area.Jul 20, 2003 · N131MH · Substantial damageNTSB LAX03TA233Accident · No injuriesFinal reportPiper PA-18-150 · Ely, NVThe pilot's failure to maintain proper alignment with the road and the CFI's failure to adequately supervise the second pilot's landing and his delayed remedial action.Jul 14, 2003 · N8991Y · Substantial damageNTSB SEA03LA134Accident · No injuriesLimited investigationFinal reportArcher S-18T · Arlington, WAThe pilot's failure to maintain an airspeed above Vs (stalling speed) while making a close-in base-to-final turn.Jul 11, 2003 · N102PM · Substantial damageNTSB LAX03LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Phoenix, AZThe disengagement of the left control wheel from the control column, which was due to the attaching screw backing out of the nut plate. Also causal was the manufacturer's inadequate design of the installation and the improper length of the screw.Jul 7, 2003 · N288PA · Substantial damageNTSB LAX03CA220Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Chandler, AZThe student's failure to maintain adequate main rotor rpm and his failure to relinquish the controls.Jul 1, 2003 · N7508E · Substantial damageNTSB LAX03LA191Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Phoenix, AZThe student pilot's improper use of the throttle control, the certified flight instructor (CFI) inadequate supervision, and the student's control interference, which resulted in a loss of main rotor rpm.Jun 11, 2003 · N7508D · Substantial damageNTSB LAX03LA189Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta II · Phoenix, AZThe instructor's inadequate supervision and his failure to maintain aircraft control. The wind gusts were a factor.Jun 9, 2003 · N727DD · Substantial damageNTSB LAX03LA177Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe pilot's failure to maintain an adequate visual lookout.Jun 1, 2003 · N991RW · Substantial damageNTSB SEA03LA063Accident · No injuriesLimited investigationFinal reportHerb Six Northstar · Medford, ORThe compressive buckling and collapse of the right main landing gear.Apr 15, 2003 · N606HS · Substantial damageNTSB FTW03LA099Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta II · Kent, TXThe loss of main rotor drive due to a drive belt separation resulting in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.Feb 18, 2003 · N54TR · Substantial damageNTSB NYC03LA045Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Pittsfield, MAThe pilot's failure to maintain control, which resulted in a rollover. Factors in this accident were the night light conditions, ice covered ramp and a snowbank.Jan 25, 2003 · N7198U · Substantial damageNTSB CHI03FA025Accident · No injuriesField investigationFinal reportRobinson R22 · St. Jacob, ILFatigue fracture of the clutch assembly fan shaft and the resulting complete loss of power to the rotor drive system. A contributing factor was the loss of tail rotor authority due to the secondary failure of the control tube assembly.Nov 20, 2002 · N559DD · Substantial damageNTSB SEA02LA183Accident · Minor injuriesLimited investigationFinal reportPiper/Cub Crafters PA-18 · Gannett, IDThe pilot's excessive braking during the landing rollout.Sep 28, 2002 · N380CC · Substantial damageNTSB SEA02LA182Accident · No injuriesLimited investigationFinal reportCessna 172RG · Billings, MTThe failure of the landing gear actuator during landing as a result of fatigue.Sep 26, 2002 · N6525R · Substantial damageNTSB CHI02LA278Accident · Minor injuriesLimited investigationFinal reportFrank RV-8A · Brodhead, WIThe failure of the nose landing gear strut for undetermined reasons.Sep 10, 2002 · N54LF · Substantial damageNTSB NYC02LA186Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Jamestown, KYThe pilot's failure to maintain the proper descent rate, which resulted in low rotor rpm and a collision with water.Sep 7, 2002 · N707RG · Substantial damageNTSB MIA02LA153Accident · 2 fatalLimited investigationFinal reportReviere Vans RV6A · Tampa, FLthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, while maneuvering, and subsequent impact with a concrete wall. A factor in this accident was the impairment of the pilot in command due to the use of prescription…Aug 18, 2002 · N747ES · DestroyedNTSB FTW02LA227Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Cornudas, TXThe pilot's failure to maintain rotor RPM and his improper landing flare. A contributing factor was the activation of a warning light.Aug 3, 2002 · N681MP · Substantial damageNTSB LAX02LA239Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Prescott, AZthe student pilot's failure to maintain adequate main rotor rpm, the CFI's delayed remedial action and inadequate supervision of the flight, resulting in a hard landing. Wind gusts and the high density altitude were factors in the accident.Jul 27, 2002 · N232DR · Substantial damageNTSB LAX02LA067Accident · No injuriesLimited investigationFinal reportFarrand Vans RV6 · San Jose, CAFailure of the pilot to sufficiently slow the airplane prior to exiting the runway, which lead to the left main landing gear collapsing and a subsequent ground loop.Jan 10, 2002 · N164DF · Substantial damageNTSB LAX02FA020Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Escondido, CAthe pilot's failure to maintain an adequate clearance from obstacles while approaching to land at his private helipad. Factors in the accident were night conditions, inadequate illumination of the landing pad, and a likely low visibility condition due to fog.Nov 5, 2001 · N7197Y · DestroyedNTSB ANC01LA119Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Glennallen, AKThe pilot's inadequate compensation for wind conditions during takeoff. A factor associated with the accident was a variable wind.Aug 21, 2001 · N2871P · Substantial damageNTSB FTW01LA124Accident · No injuriesLimited investigationFinal reportRobinson R22 · Raymondville, TXthe failure of the main rotor drive belts while maneuvering which resulted in a loss of main rotor drive. A contributing factor was the lack of suitable terrain for the forced landing.May 18, 2001 · N7087X · Substantial damageNTSB CHI97LA291Accident · No injuriesLimited investigationFinal reportCessna 177B · Oxford, IAthe instructor pilot's improper recovery from a bounced landing and his failure to maintain control of the airplane. Factors were the improper flare by the dual student and the instructor pilot's lack of familiarity with the airplane.Sep 6, 1997 · N34829 · Substantial damageNTSB LAX97LA295Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe pilot's inadequate recovery from a bounced landing.Aug 19, 1997 · N3266E · Substantial damageNTSB CHI92LA157Accident · No injuriesLimited investigationFinal reportCessna 150 · South Bend, INImproper aircraft control by the pilot.May 22, 1992 · N6349G · Substantial damageNTSB LAX91LA194Accident · No injuriesLimited investigationFinal reportLancair 320 · Fall River Mill, CAFailure of the pilot-in-command to compensate for wind conditions and to recover from a bounced landing which resulted in an on ground loss of control. Contributing to the accident was the wind conditions and turbulence at the airport at the time of the…May 5, 1991 · N320MC · DestroyedNTSB NYC90DFJ01Accident · No injuriesFinal reportSteele Acrosport II · Penn Yan, NYFailure of the pilot to maintain directional control during the takeoff ground run. His lack of experience & the snowbank were related factors.Jan 3, 1990 · N896JC · Substantial damageNTSB ANC89LA132Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Canyon Creek, AKThe pilot's improper planning/decision concerning fuel management, which resulted in fuel starvation. Contributing factors were: probable water in the fuel, inadequate altitude for an engine restart, and the terrain conditions.Aug 4, 1989 · N679RK · Substantial damageNTSB DEN85LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Kemmerer, WYOn April 2, 1985, an inexperienced pvt plt attempted to land on a runway with a 24KT crosswind at Kemmerer, WY. The favorable runway was closed due to snow accumulations. On the third attempt the acft landed hard and bounced into the air. The plt attempted to…Apr 2, 1985 · N1085H · Substantial damageNTSB DEN83LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Worland, WYThe acft collided with a ditch and collapsed the landing gear during a forced landing after the engine quit during a ferry flight. The plt refueled the empty right fuel tank and topped-off the left tank with 3 gallons of fuel before the initial takeoff on the…Mar 28, 1983 · N8977D · Substantial damageNTSB SEA82DA023Accident · No injuriesFinal reportCessna 172P · Sinclair Island, WAThe airport was a privately owned strip approximately 1200 ft in length. About the last 25 percent of runway 33 was angled approximately 30 degrees to the right. Tth runway was considered unidirectional with landings normally made to the north/northwest and…Jan 30, 1982 · N53294 · Substantial damageNTSB ANC80DAG94Accident · No injuriesClosedPiper PA-18A · Togiak, AKJul 19, 1980 · N679RK · Substantial damageNTSB ANC80DA042Accident · No injuriesClosedBellanca 8GCBC · Kodiak, AKApr 25, 1980 · N2975Q · Substantial damageNTSB ANC79DAA09Accident · No injuriesClosedPiper PA-18 · Chicken, AKMar 28, 1979 · N5425Y · Substantial damageNTSB IAD76DID35Accident · No injuriesClosedCessna 177 · Danville, VAJul 12, 1976 · N34829 · Substantial damageNTSB OAK76FVW13Accident · Serious injuriesClosedAeronca 15AC · Goldfield, NVMar 2, 1976 · N1345H · Substantial damage