NTSB investigations: Lycoming 0-320 series, WY
159 cases on aircraft whose registry engine model is Lycoming 0-320 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.\"eventStateOrRegion\" = 'WY' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
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.
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."eventStateOrRegion" = 'WY' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA97LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Moorcroft, WYThe pilot's failure to maintain adequate airspeed. A factor was the pilot's low altitude flight and maneuvering.NTSB SEA96LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Cheyenne, WYthe pilot's improper flare during the landing and improper recovery from the subsequent bounced landing. A factor relating to the accident was: the pilot's failure to maintain the proper approach path during the approach for landing.NTSB SEA95LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Wheatland, WYThe pilot's continued flight into known adverse weather conditions. A factor in the accident was the airframe icing encountered during the flight.NTSB SEA95LA020Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casper, WYFuel exhaustion due to the pilot's failure to refuel.NTSB SEA94LA130Accident · Minor injuriesLimited investigationFinal reportLatter Christen Eagle II · Jackson Hole, WYThe failure of the pilot of the christen eagle ii, N246RL, to see and avoid the Cessna 172, N62463, and the pilot of the christen eagle ii diverting his attention from operation of his airplane.NTSB SEA94LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Casper, WYThe pilot's failure to maintain proper alignment with the runway. The crosswind was of factor.NTSB SEA94LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · Gillette, WYWas the pilot's inadequate remedial action. Factors include an inadvertent porpoise, and a lack of total experience.NTSB SEA92LA207Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Smoot, WYThe pilot in command's delayed go-around. Factors contributing to the accident were the pilot in command's selection of unsuitable terrain and trees.NTSB DEN92FA093Accident · 1 fatalField investigationFinal reportCessna 172M · Evanston, WYLoss of control for undetermined reasons.NTSB SEA92LA030Accident · Minor injuriesLimited investigationFinal reportArtic S-1B2 · Lysite, WYThe pilot's failure to maintain clearance with terrain. Factors contributing to the accident were rising terrain, downdrafts, and the pilot's inadequate compensation for wind conditions.NTSB SEA91LA254Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Kaycee, WYInadequate clearance with the vehicle and the pilot's failure to obtain proper assistance for the takeoff. Factors contributing to the accident were 1) the pilot's inadequate preflight planning, 2) the vehicle, and 3) high density altitude conditions.NTSB SEA91LA140Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Newcastle, WYThe fracture failure of the landing gear axle.NTSB DEN90LA141Accident · No injuriesLimited investigationFinal reportBeech 23 · Wheatland, WYPermature liftoff.NTSB DEN90LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Douglas, WYThe accident to be improper installation of aileron control system by maintenance personnel, and failure to perform an aircraft preflight by the pilot in command.NTSB DEN89LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Alpine, WYPilot's decision to land at an unlighted airport at night. The aircraft landed long and overran the runway.NTSB DEN89LA037Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casper, WYThe plt attempted a takeoff to the west on a county gravel road. The pilot said he had routinely used the gravel road for about 10 years because of its convenience to his hangar/tool shed. He reported the winds were from 210 deg at 15 KTS. During the ground…NTSB DEN88LA195Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rawlins, WYPlt and pax were on a flight from milwaukee, WI, to las vegas, NV. The plt made an unscheduled stop at Rawlins due to poor vis and low fuel. The airplane was loaded with suit cases, camping gear, coolers and full fuel. The pilot and pax combined weight was…NTSB DEN88LA174Accident · No injuriesLimited investigationFinal reportCessna 172M · Gillette, WYThe student plt was completing his first solo x-country flt. During touchdown, the airplane bounced and began to porpoise. On the third bounce, the nose wheel fork failed. Subsequently, the acft turned 180 deg to the left & came to rest on the left side of…NTSB DEN88LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casper, WYThe commercial plt was taxiing after landing during a fuel stop while on a long cross country flight. The plt landed on runway 21, a hard surface runway, 10,600 feet long by 150 feet wide. The winds were reported from 230 degrees at 22 knots, with gusts to 31…NTSB DEN87LA181Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Worland, WYThe plt said the acft bounced during landing and he lost control. The acft ran off the rwy and when the plt applied the brakes too hard, the acft nosed over.NTSB DEN87LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glenrock, WYThe private plt planned a takeoff from the unimproved ranch rwy for a local flt. Elevator trim was not set for takeoff according to the plt. When the tailwheel came up during the takeoff roll, the acft swerved left, and the plt attempted to correct with…NTSB DEN87FA036Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Rawlins, WYThe plt took off on a 7000 ft long runway with a heavy coat of frost on the acft. The acft became airborne and flew in ground effect until it impacted a 30 ft high pile of sand 200 yards beyond the end of the runway.NTSB DEN86LA260Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wright, WYAcft was taxiing for takeoff from driveway on private ranch. Plt said there was strong x-wing gusting from left to right. Plt said he was holding right rudder when wind velocity decreased. Wing tip struck post beside driveway, acft turned right, and rolled…NTSB DEN86FTE03Accident · 1 fatalFinal reportHomebuilt Bushby Mustang · Casper, WYThe Homebuilt acft crashed during low alt maneuvers from about 150 ft AGL. A witness who helped build the acft was taking pictures and recording data of the flt at the time of the accident. This witness stated that the plt attempted an aileron roll. The first…NTSB DEN86LA250Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Casper, WYWhile in normal cruise flt, after crossing a ridgeline, the plt encountered downdraft wind currents. The acft entered a descent from which the plt could not recover. He attempted to make an emergency forced landing in rough desert terrain. The acft impacted…NTSB DEN86FA213Accident · 2 fatalField investigationFinal reportThorp T-18 · Rawlins, WYThe accident acft, a Thorp T-18, was one of four acft (quickie ii, varieze, longeze) in a loose formation that was en route to the annual eaa convention at oshkosh, WI. The acft departed redding, CA, at 0500 PDT, refueled at wendover, UT, and departed there…NTSB DEN86LA168Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bosler, WYAccording to the plt, the acft had just become airborne when it encountered a gust of wind while simultaneously crossing a gully, lost lift & descended until ground contact. The plt also indicated there was a 'density altitude problem.' The density altitude…NTSB DEN86LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Afton, WYThe plt stated he had descended to observe wildlife. When he attempted to add pwr he discovered the eng had quit. The plt indicated the acft wheel contacted the deep snow at a moderate rate of horizontal speed while he was trying to restart the eng.NTSB DEN85LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Rawlins, WYThe acft lost eng pwr and was substantially damaged during an off arpt energency landing. The purpose of the flt was to look for coyotes. The post accident eng exam revealed that 9 consecutive teeth on the left magneto drive gear were ground off. This allowed…NTSB DEN84LA132Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Jackson, WYThe acft crashed during takeoff from Jackson airport. Investigation revealed that the plt and CFI were in the process of ferrying the acft to Washington state. The plt stated that during taxi the airport UNICOM reported the wind to be from the northeast at 18…NTSB DEN83LA223Accident · No injuriesLimited investigationFinal reportMooney M-2O · Rock Spring, WYThe acft landed with the landing gear up after the flt experienced some delays in landing because an airshow was in progress. The accident plt was told to hold 30 minutes and then 6 minutes later was told he could land if he hurried and'got back to the arpt…NTSB DEN83LA169Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Cody, WYThe acft groundlooped during landing and damaged the landing gear. The pilot had 80 hours in tailwheel acft but only 1.6IN the accident make and model. The landing was on rwy 22 and the wind was from 130 degrees at 10 to 12 KTS. The plt slipped the acft on…NTSB DEN83FA156Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Wheatland, WYDuring an aerial application maneuver, the acft collided with the ground. An exam of the wreckage indicated that it impacted in a steep nose down attitude while rotating to the left. The flaps were found extended 25 deg & the airspeed gage was found…NTSB DEN82DA204Accident · No injuriesFinal reportCessna 172 · Rock Springs, WYAccording to the pilot, a strong gust of wind lifted the aircraft during the landing and power was applied for a go-around. Another gust of wind forced the aircraft off the runway into the dirt next to the runway. When the aircraft departed the runway, the…NTSB DEN82DA152Accident · No injuriesFinal reportCessna 172N · Lander, WYThe pilot reported that the aircraft suddenly veered to the right after he had slowed to about 30 to 35 KTS. An examination revealed that the nose gear fork had failed in two places. The breaks were just below the strut attachment point and directly accross…NTSB DEN82FTC06Accident · Serious injuriesFinal reportBellance 7GCBC · Pinedale, WYDuring a running takeoff the pilot allowed the aircraft to lose control. The aircraft went off the runway, swerved, bounced into the air and nosed over.NTSB DEN82FTC04Accident · 1 fatalFinal reportCessna 172P · Osage, WYThe aircraft departed gillette, Wyoming on a pipeline patrol mission. This was the pilot's first pipeline patrol over the line that he was patrolling. During the flight, the aircraft struck three powerlines and crashed. The passenger stated that he saw the…NTSB DEN82DA041Accident · No injuriesFinal reportBellanca 7GCBC · Thermopolis, WYDuring a landing in a hay meadow the pilot touched down long, due to a tailwind, and turned uphill to avoid hitting a fence and ditch. The aircraft ground looped breaking the right wheel strut.NTSB DEN81FTC28Accident · No injuriesClosedPiper PA-18 · 25m S Gillette, WYNTSB DEN81FA061Accident · 3 fatalClosedPiper PA-28 · 40 Mi S Casper, WYNTSB DEN81FTC03Accident · No injuriesClosedPiper PA-20 · Cody, WYNTSB DEN80DTC26Accident · No injuriesClosedPiper PA-18 · Lysite, WYNTSB DEN80DTC06Accident · No injuriesClosedCessna 172N · Kemmerer, WYNTSB DEN79DTC11Accident · No injuriesClosedPiper PA-18A · Casper, WYNTSB DEN78FTC38Accident · No injuriesClosedPiper PA-18 · Casper, WYNTSB DEN78FTC30Accident · No injuriesClosedPiper PA-28 · Casper, WYNTSB DEN78FTC27Accident · No injuriesClosedGrum Amer AA-5A · Evanston, WYNTSB DEN78DTC18Accident · No injuriesClosedPiper PA-18 · Worland, WYNTSB DEN78FTC13Accident · No injuriesClosedCessna 172N · Pinedale, WYNTSB DEN78DTC06Accident · No injuriesClosedCessna 172 · Pinedale, WY