NTSB investigations: Lycoming O&VO-360 series

5,181 cases on aircraft whose registry engine model is Lycoming O&VO-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 ('41514'))
  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 LAX07CA165Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Moab, UTThe pilot's failure to obtain and maintain an adequate airspeed that resulted in a stall/mush. Also causal was the pilot's failure to abort the takeoff in a timely way. A factor in the accident was the high density altitude.May 12, 2007 · N8598N · Substantial damageNTSB LAX07CA151Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Las Vegas, NVfuel starvation due to the pilot's inadequate fuel system management.May 5, 2007 · N2834U · Substantial damageNTSB DFW07CA101Accident · No injuriesData collectionFinal reportMaule MXT-7-180 · Sierra Blanca, TXThe loss of control as result of the pilot's failure to compensate for the existing wind conditions. A contributing factor was the crosswind.Apr 24, 2007 · N800CP · Substantial damageNTSB CHI07FA102Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Viburnum, MOThe pilot's loss of aircraft control during cruise flight in instrument meteorological conditions. Factors contributing to the accident were turbulence and icing conditions.Apr 14, 2007 · N8969J · DestroyedNTSB ATL07LA067Accident · 1 fatalLimited investigationFinal reportPiper PA28-181 · New Tazewell, TNThe pilot's failure to maintain aircraft control. Contributing to the accident was the non-instrument rated pilot's continued flight from visual meteorological conditions into instrument meteorological conditions, and a low cloud ceiling.Apr 2, 2007 · N30465 · Substantial damageNTSB DFW07LA088Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Laredo, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.Mar 25, 2007 · N854WT · Substantial damageNTSB ATL07CA062Accident · No injuriesData collectionFinal reportPiper PA-28A-180C · Atlanta, GAThe pilot's failure to maintain directional control of the airplane while landing with a flat main tire.Mar 24, 2007 · N4988L · Substantial damageNTSB ATL07CA055Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Myrtle Beach, SCThe loss of engine power due to undetermined reasons. A factor in the accident was the pilot's failure to follow emergency procedures when he failed to jettison the advertising banner prior to his forced landing in water.Mar 24, 2007 · N4330Z · Substantial damageNTSB LAX07LA114Accident · No injuriesLimited investigationFinal reportMooney M20B · St. George, UTOil contamination of the right magneto. Factors were the airplane owner's failure to comply with manufacturer's service bulletins and overhaul porcedures.Mar 18, 2007 · N74503 · Substantial damageNTSB NYC07CA079Accident · No injuriesData collectionFinal reportBeech C23 · Fredericksburg, VAThe pilot's misjudgment of the airplane's speed and distance during the landing approach.Mar 11, 2007 · N9150S · Substantial damageNTSB LAX07CA098Accident · No injuriesData collectionFinal reportMooney M20D · Visalia, CAThe pilot's inadequate in-flight fuel system management, which resulted in fuel starvation and a loss of engine power.Mar 3, 2007 · N6628U · Substantial damageNTSB NYC07CA067Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Millbrook, NYThe pilot's failure to maintain a proper glidepath to the runway.Feb 17, 2007 · N47480 · Substantial damageNTSB DEN07FA054Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Centennial, WYthe pilot's inadvertent flight into adverse weather conditions resulting in a loss of aircraft control. Contributing factors include the pilot's improper preflight planning and decision making, the pilot's spatial disorientation, the pilot's lack of night…Jan 18, 2007 · N43630 · Substantial damageNTSB SEA07CA042Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Buckley, WAThe pilot's failure to release brake pressure soon enough when his airplane skidded from wet grass onto dry terrain during an off-airport, full-stop landing. A factor was the change in terrain from wet grass to dry ground in the landing area.Jan 5, 2007 · N186AC · Substantial damageNTSB LAX07CA070Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Jackpot, NVthe pilot's failure to maintain directional control after encountering loose snow conditions on the runway.Jan 1, 2007 · N7769W · Substantial damageNTSB NYC07CA053Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Cumberland, MDThe pilot's misjudgment of the airplane's distance/altitude during the landing approach.Dec 31, 2006 · N348TF · Substantial damageNTSB SEA07CA029Accident · No injuriesData collectionFinal reportCessna 172RG · Laurel, MTThe pilot's inadequate compensation for the crosswind conditions during the landing roll, which resulted in a loss of control and subsequent nose over. A contributing factor was the crosswind condition.Dec 11, 2006 · N6501V · Substantial damageNTSB DEN07CA035Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Falcon, COloss of power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing, unsuitable terrain available on which to make a forced landing and the tree.Dec 8, 2006 · N6487J · Substantial damageNTSB DEN07WA031Accident · 1 fatalForeign investigation107.5 Flying One Design DR 107 · Langenthal, SwitzerlandDec 3, 2006 · N107FP · DestroyedNTSB LAX07CA050Accident · No injuriesData collectionFinal reportRobinson R22B · Redding, CAThe student's misjudged landing flare, the instructor's inadequate supervision of the flight, and the instructor's failure to maintain adequate rotor rpm.Nov 27, 2006 · N7198N · Substantial damageNTSB LAX07CA044Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Springerville, AZthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during landing. A factor was the crosswind.Nov 23, 2006 · N4925L · Substantial damageNTSB NYC07CA034Accident · Serious injuriesData collectionFinal reportTaylorcraft BC12-D · Benton, KYThe pilot's improper decision to fly between the trees during his approach to the runway.Nov 21, 2006 · N148HW · Substantial damageNTSB SEA07LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Billings, MTThe flight instructor's inadequate remedial action to maintain directional control, which resulted in a ground loop/swerve during takeoff roll. A factor was the failure of the pilot who was receiving instruction to maintain directional control.Nov 18, 2006 · N2619D · Substantial damageNTSB MIA07FA011Accident · 2 fatalField investigationFinal reportBeech BE-76 · Port Orange, FLThe flight instructor's inadequate preflight planning which resulted in fuel exhaustion.Nov 1, 2006 · N6017U · DestroyedNTSB LAX07LA020Accident · Serious injuriesLimited investigationFinal reportAero Commander 112 · Chino, CAA loss of engine power during the initial climb after takeoff due to blocked fuel vent lines that resulted in fuel starvation. Contributing to the accident was an inadequate preflight inspection by the pilot-in-command (CFI).Oct 23, 2006 · N1022J · Substantial damageNTSB ATL07CA006Accident · No injuriesData collectionFinal reportMcCullough J-2 · Indian Trail, NCThe pilot's inadequate compensation for gusting wind conditions and his improper landing flare during an emergency landing after takeoff resulting in a hard landing.Oct 12, 2006 · N4362G · Substantial damageNTSB LAX07LA004Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Oakdale, CAA total loss of engine power resulting from lubrication deprivation for undetermined reasons.Oct 8, 2006 · N39ER · Substantial damageNTSB LAX07CA013Accident · No injuriesData collectionFinal reportAviat A-1A · Woodlake, CAthe collapse of the landing gear during the landing roll out due to an encounter with rough uneven terrain. Also causal was the pilot's in-flight decision to land on the unsuitable mountainous uneven terrain with hidden obstructions.Oct 7, 2006 · N40AW · Substantial damageNTSB SEA07LA001Accident · Minor injuriesLimited investigationFinal reportOneil Oneil Glassair II-S · Richland, WALoss of partial engine power for undetermined reasons during the initial climb after takeoff. Trees were a factor during the landing roll.Oct 1, 2006 · N204BL · Substantial damageNTSB LAX06LA298Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Auburn, CAthe fatigue failure of the elevator's control rod due to inadequate lubrication. Contributing factors were the inadequate maintenance and the owner-pilot's failure to comply with an airworthiness directive.Sep 20, 2006 · N5577Q · Substantial damageNTSB CHI06WA280Accident · 1 fatalForeign investigationGuscott VariViggen · Plaster Rock, CanadaSep 17, 2006 · N106VV · DestroyedNTSB SEA06LA172Accident · No injuriesLimited investigationFinal reportMooney M20C · Eastsound, WAThe pilot's failure to maintain airspeed during final approach resulting in an inadvertent stall and hard landing.Aug 28, 2006 · N5738Q · Substantial damageNTSB CHI06CA239Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Napoleon, MIThe pilot's failure to maintain a proper glidepath during the landing approach, and his excessive airspeed during the landing which resulted in the overrun. A factor was the fence that the airplane impacted.Aug 16, 2006 · N4008Q · Substantial damageNTSB LAX06LA257Accident · 1 fatalLimited investigationFinal reportRobinson R22 Beta · Tucson, AZThe pilot's failure to maintain adequate rotor rpm and adequate terrain clearance while maneuvering to reverse direction. Contributing factors were the high density altitude, that exceeded the helicopter's performance capability, and the rising mountainous…Aug 10, 2006 · N7059S · Substantial damageNTSB DEN06FA109Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Mosca, COa non-mechanical partial loss of engine power due to carburetor ice, and the pilot's failure to maintain clearance from terrain. Contributing factors in this accident were weather conditions conducive to carburetor icing and the pilot inadvertently flying…Aug 3, 2006 · N5416P · DestroyedNTSB LAX06LA246Accident · 2 fatalLimited investigationFinal reportCessna 177B · Kalaupapa, HILoss of aircraft control during cruise flight for undetermined reasons. Clouds, rain, and dark night conditions were factors.Jul 28, 2006 · N30652 · DestroyedNTSB ANC06LA092Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Deland, FLThe flight instructor's inadequate supervision of the dual student during final approach to land, and his delayed remedial action following a partial loss of engine power on one of the two engines. Factors associated with the accident are the dual student's…Jul 19, 2006 · N717PE · Substantial damageNTSB DEN06LA100Accident · No injuriesLimited investigationFinal reportMaule M 6 180C · Kemmerer, WYthe pilot's loss of directional control during takeoff due to the improper rigging of the airplane's flap system by unknown maintenance personnel. A contributing factor was the high density altitude.Jul 16, 2006 · N72RM · Substantial damageNTSB DFW06CA181Accident · Minor injuriesData collectionFinal reportMooney M20C · Eldorado, TXThe pilot's failure to switch fuel tanks during cruise flight, which resulted in a loss of engine power due to fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.Jul 9, 2006 · N6697U · Substantial damageNTSB LAX06CA223Accident · No injuriesData collectionFinal reportPiper PA28-181 · Dorris, CAthe pilot's failure to maintain an adequate airspeed during a go-around, which resulted in a stall/mush. A contributing factor was the high density altitude.Jul 3, 2006 · N6413C · Substantial damageNTSB SEA06CA131Accident · No injuriesData collectionFinal reportCessna 177A · Olympia, WAThe pilot's inadequate recovery from a bounced landing which resulted in a hard landing.Jun 28, 2006 · N30328 · Substantial damageNTSB LAX06CA217Accident · No injuriesData collectionFinal reportBeech 76 · El Cajon, CAthe failure of the "A" frame tube, which caused the left main landing gear to collapse.Jun 27, 2006 · N6720T · Substantial damageNTSB LAX06CA216Accident · Minor injuriesData collectionFinal reportEklund Thorp T-18 · San Andreas, CAthe pilot's misjudged airspeed and distance during the approach, and his failure to initiate a timely go-around, which resulted in a landing overrun.Jun 27, 2006 · N181RE · Substantial damageNTSB ANC06CA077Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Takotna, AKThe pilot's excessive use of brakes during the landing roll. A factor associated with the accident was soft terrain.Jun 19, 2006 · N9622V · Substantial damageNTSB LAX06LA205Accident · No injuriesLimited investigationFinal reportCessna 177B · Redwood City, CAA collision with water for undetermined reasons.Jun 17, 2006 · N35058 · Substantial damageNTSB NYC06LA139Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Du Bois, PAThe pilot's inadequate compensation for wind conditions, which resulted in a stall and subsequent impact with the ground. A factor was the wind gust as reported by the pilot.Jun 5, 2006 · N1654B · Substantial damageNTSB NYC06CA141Accident · No injuriesData collectionFinal reportMaule M-5-180C · Mount Pocono, PAThe disconnected tailwheel compression spring, which resulted in a loss of directional control.May 29, 2006 · N5640S · Substantial damageNTSB NYC06CA120Accident · No injuriesData collectionFinal reportPiper PA-28-280 · Tangier Island, VAThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a ditch. A factor was the rough runway condition.May 24, 2006 · N5180L · Substantial damageNTSB MIA06LA109Accident · Serious injuriesLimited investigationFinal reportMooney M20G · Lantana, FLThe pilot's inadequate preflight inspection, which resulted in a loss of engine power during initial climb due to water contamination in the fuel. Contributing factors were the deteriorated fuel cap o-ring and the pilot's failure to maintain adequate airspeed.May 18, 2006 · N12RH · Substantial damageNTSB DEN06CA078Accident · No injuriesData collectionFinal reportAviat A-1A · Englewood, COthe pilot's failure to maintain aircraft control while taxiing from landing, resulting in a collision with a refuse dumpster. A contributing factor was his physical impairment by alcohol.May 15, 2006 · N153C · Substantial damage