NTSB investigations: Lycoming 0-290 series

137 cases on aircraft whose registry engine model is Lycoming 0-290 series, where the first occurrence was “Loss of control - on ground/water”. 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 ('41506')
      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\" = 260))
  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 FTW97LA017Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Boulder, COthe pilot's failure to maintain directional control and his improper use of rudder. A factor was the pilot's lack of total experience in the make and model of airplane.Oct 12, 1996 · N9967Q · Substantial damageNTSB CHI96LA299Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Portland, INthe aircraft ground looped when the pilot lost control of the aircraft during landing.Aug 16, 1996 · N2309A · Substantial damageNTSB ATL96LA098Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Calhoun, GAthe pilot's failure to maintain directional control during landing.Jun 30, 1996 · N7685K · Substantial damageNTSB ANC96LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe obstruction of the left rudder pedal and brake by the battery cable.Jun 9, 1996 · N8560C · Substantial damageNTSB SEA96LA107Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Pasco, WAthe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve and collapse of the left main gear.Jun 1, 1996 · N1645A · Substantial damageNTSB ATL96LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Cochran, GAfailure of the flight instructor (CFI) to maintain directional control of the airplane during takeoff, when the airplane encountered an uneven area on the airstrip and becoming airborne prematurely; and his failure to maintain clearance (or altitude) from…May 1, 1996 · N1209C · Substantial damageNTSB MIA96LA091Accident · No injuriesLimited investigationFinal reportPiper PA-22/20-150 · Merritt Island, FLThe pilot's inadequate compensation for crosswind conditions during the landing roll, which resulted in a loss of directional control and an inadvertent ground swerve. The crosswind was a related factor.Mar 3, 1996 · N3311B · Substantial damageNTSB FTW96LA112Accident · No injuriesLimited investigationFinal reportMasnic SKY Hopper II · Edgewood, NMthe pilot exceeding the airplane's crosswind component which led to his inability to compensate for the crosswind conditions. A factor was the gusty winds.Feb 8, 1996 · N2795 · Substantial damageNTSB LAX96LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Davis, CAthe pilot's failure to maintain directional control during the takeoff roll by diverting his attention.Oct 31, 1995 · N3562A · Substantial damageNTSB CHI95LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Hutchinson, MNthe pilot's not maintaining aircraft control. A factor was the crosswind condition.May 19, 1995 · N1097A · Substantial damageNTSB FTW95LA171Accident · No injuriesLimited investigationFinal reportChampion 7GC · Paragould, ARThe student pilot's failure to maintain directional control, resulting in an inadvertent groundloop. A factor was the instructor's inadequate supervision.Apr 15, 1995 · N4842E · Substantial damageNTSB SEA95LA075Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Klamath Falls, ORThe pilot-in-command's failure to maintain directional control during takeoff, resulting in a ground loop.Apr 2, 1995 · N8276C · Substantial damageNTSB SEA94LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Easton, WAThe pilot's failure to maintain directional control. Factors include soft, uneven terrain.Jul 15, 1994 · N1540A · Substantial damageNTSB ATL94LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22\20 · Kill Devil Hill, NCThe pilot's failure to adequately compensate for the crosswind condition during a landing rollout.May 29, 1994 · N1665A · Substantial damageNTSB ANC93LA180Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Yantarni Bay, AKThe pilot failed to maintain directional control of the airplane during the landing roll. A factor was the crosswind.Sep 19, 1993 · N4259H · Substantial damageNTSB ANC93LA117Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Circle Hot Spri, AKThe pilot-in-command's failure to maintain directional control during taxi. Factor is the rough/rutted condition of the airstrip.Jul 14, 1993 · N4946M · Substantial damageNTSB LAX93LA305Accident · No injuriesLimited investigationFinal reportAyres Pitts MA-1 · Greenfield, CAThe failure of the pilot to maintain directional control of the airplane during the landing roll and subsequent application of excessive braking that resulted in the airplane nosing over.Jul 5, 1993 · N81999 · Substantial damageNTSB SEA93LA131Accident · No injuriesLimited investigationFinal reportChampion 7GC · Gillette, WYThe pilot in command's not maintaining directional control and the overload of the left main landing gear. A factor contributing to the accident was the pilot's lack of experience in conventionally geared aircraft.Jun 14, 1993 · N8947R · Substantial damageNTSB CHI93LA151Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lapeer, MIThe pilot's failure to maintain directional control during the landing roll.Mar 30, 1993 · N7732K · Substantial damageNTSB CHI93LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Weeping Water, NEThe pilot's failure to maintain directional control.Oct 22, 1992 · N5592H · Substantial damageNTSB CHI92LA296Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Plattsmouth, NEThe pilot-in-command's failure to adequately compensate for wind conditions, and his not maintaining directional control.Sep 27, 1992 · N1270C · Substantial damageNTSB SEA92LA200Accident · Minor injuriesLimited investigationFinal reportYork Y2 · Mountain Home, IDThe pilot's failure to maintain directional control. Factors include gusty crosswinds.Sep 11, 1992 · N6107U · Substantial damageNTSB SEA92LA186Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Morgan, UTPoor inflight planning/decision by the pilot in command. Factors contributing to the accident were: the gravel/dirt bank, night environmental conditions, and runway lighting unavailable.Aug 24, 1992 · N2169A · Substantial damageNTSB ANC92LA135Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKThe pilot failed to maintain directional control of the airplane during the landing roll. Contributing factors were the unfavorable wind, the trees, and the fence.Aug 6, 1992 · N7146K · Substantial damageNTSB LAX92LA318Accident · No injuriesLimited investigationFinal reportChapuis Spezio Sport · Wells, NVThe pilot's inadequate compensation for the existing wind conditions and his subsequent failure to maintain directional control of the aircraft. A factor in the accident was the variable and gusty nature of the wind conditions at the airport.Jul 28, 1992 · N7715 · Substantial damageNTSB ANC92LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Alexander Creek, AKThe pilot's failure to maintain directional control during landing flare/touchdown. A factor relating to the accident was the crosswind weather condition.Jun 1, 1992 · N7475K · Substantial damageNTSB ANC92LA070Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Twin Hills, AKDirectional control was not maintained. A factor to the accident was: a bird.May 10, 1992 · N3498A · Substantial damageNTSB FTW92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-22 · New Roads, LAThe student pilot's loss of directional control and the resultant ground loop. Factors were the cfi's lack of supervision and the ditch adjacent to the runway.Dec 7, 1991 · N3746A · Substantial damageNTSB ANC92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Stebbins, AKThe pilot's failure to adequately compensate for the wind during landing. Factors were the crosswind and the attempted go aroundNov 8, 1991 · N1685A · Substantial damageNTSB CHI91LA285Accident · No injuriesLimited investigationFinal reportMonocoupe 90A · Creve Coeur, MOA premature liftoff and improper remedial action by the pilot during a takeoff ground run.Sep 1, 1991 · N11793 · Substantial damageNTSB CHI91LA271Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Saginaw, MIDirectional control was not maintained by the pilot which resulted in a ground loop. A factor related to the accident was a crosswind.Aug 25, 1991 · N7732K · Substantial damageNTSB ANC91LA120Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Eureka, AKThe pilot-in-command's failure to mantain directional control of the airplane during the takeoff roll. Contributing to the accident was the crosswind.Aug 7, 1991 · N7404K · Substantial damageNTSB SEA91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chehalis, WAThe pilot's failure to maintain proper runway alignment. Factors include gusty winds and crosswinds.Jul 13, 1991 · N7458K · Substantial damageNTSB ANC91LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Delta Junction, AKWas the pilot-in-command's loss of control during the takeoff run, thereby allowing the airplane to stray from the runway's centerline and to strike some high vegetation.Jul 1, 1991 · N1476C · Substantial damageNTSB SEA91LA085Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Ekalaka, MTThe pilot did not maintain directional control of the airplane during the landing roll. Factors to the accident were: the landing surface was covered with slush, snow was falling and obscured the pilot's vision.Apr 13, 1991 · N1322A · Substantial damageNTSB CHI91LA123Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Grand Marais, MNFailure of the pilot to maintain directional control. The crosswind and snow covered runway were related factors.Mar 24, 1991 · N7010K · Substantial damageNTSB CHI91LA012Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Mason, MIThe pilot's failure to maintain directional control. A factor in the accident is the pilot's lack of total experience in the accident type airplane.Oct 14, 1990 · N2600A · Substantial damageNTSB ANC91LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · King Salmon, AKInadvertant stall during an aborted landing.Oct 12, 1990 · N7049K · Substantial damageNTSB ANC90LA118Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Port Moller, AKThe pilot failed to maintain directional control during landing. Contributing to the accident were the unfavorable winds, the soft runway surface, and the pilot's lack of training and total experience.Jul 15, 1990 · N1765A · Substantial damageNTSB LAX90DUQ01Accident · Minor injuriesFinal reportDavidson Throp T-18 · Camarillo, CAPilots failure to maintain directional control while landing in a crosswind.Jan 6, 1990 · N66MY · Substantial damageNTSB DEN89LA179Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Boulder, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent damage to the wing.Jul 25, 1989 · N9967Q · Substantial damageNTSB ANC89LA128Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chitina, AKThe pilot's selection of an unsuitable landing area and delay in slowing the airplane after landing. A factor in the accident was the rough/uneven terrain.Jul 23, 1989 · N7400K · Substantial damageNTSB CHI89LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Gladwin, MIFailure of the pilot seated in the left seat of the airplane to use brakes to correct for a left turn caused by a bent tail wheel.Jul 3, 1989 · N7093K · Substantial damageNTSB LAX89LA051Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chino, CAThe plt lost directional control of the acft during the landing roll and ground looped. The flight instructor reported that this was the first landing of the day and that they were staying in the traffic pattern to practice touch and go landings on rwy 26.…Nov 19, 1988 · N1441C · Substantial damageNTSB ANC89LA010Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Soldotna, AKDuring the landing roll the pilot lost directional control of the airplane. The airplane ground looped on the runway.Oct 16, 1988 · N1208C · Substantial damageNTSB ANC88LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chandalar River, AKAfter touchdown on the gravel bar along the side of the River, the pilot lost control and the airplane nosed over on its back.Aug 9, 1988 · N8066C · Substantial damageNTSB ANC88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot stated that after touchdown on the runway a gust of wind hit the plane pushing the tail to the right and causing the aircraft to ground loop.Jun 21, 1988 · N4260H · Substantial damageNTSB SEA88LA111Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Kelso, WAThe plt stated that he selected rnwy 29 in very gusty conditions. He believed the landing was made with no problems. As the acft slowed below 45 mph it suddenly veered to the right. The plt failed to control the drift. The acft departed the runway and…Jun 12, 1988 · N1453A · Substantial damageNTSB CHI88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Charlotte, MIDuring touchdown in a slight right crosswind, the student pilot inappropriately applied right rudder pressure. The aircraft yawed to the right and left the sod runway, veering into a plowed field. The aircraft struck a furrow and nosed over.May 16, 1988 · N8800C · Substantial damageNTSB MIA88LA039Accident · No injuriesLimited investigationFinal reportPitts S-1C · Clearwater, FLThe plt stated that on landing roll, as he added power to go around, he lost control of the aircraft, ran off the runway, flipped over and came to rest inverted. The torque of the relatively powerful engine added to the control problems in this short fuselage…Oct 25, 1987 · N14SH · Substantial damage