NTSB investigations: Lycoming 0-320 series, OR
298 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\" = 'OR' 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" = 'OR' 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 SEA00LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Gleneden Beach, ORThe pilot's failure to remove the control lock during his preflight inspection. Factors contributing to the accident were the pilot's failure to follow the BEFORE TAKEOFF checklist, trees beyond the upwind end of the runway, and the pilot's self-induced…NTSB SEA00LA125Accident · No injuriesLimited investigationFinal reportCessna 172I · Sandy, ORThe pilot's failure to attain the proper touchdown point for landing, and his failure to go around from the improperly executed approach. Factors included the pilot's failure to attain the proper glidepath on the approach, a short landing runway, and…NTSB SEA99LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Hillsboro, ORLoss of engine power due to fuel contamination.NTSB SEA99LA130Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Jordan Valley, ORThe pilot's inadvertent stall/mush of the aircraft while attempting a forced landing due to partial power loss of the engine. Factors include carburetor icing conditions and the pilot's improper use of carburetor heat.NTSB SEA99LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cottage Grove, ORThe pilot's inadequate management of fuel which led to fuel starvation.. A related factor was the unsuitable terrain.NTSB SEA99LA108Accident · Serious injuriesLimited investigationFinal reportWilliamson/Williamson RV-4 · Coos Bay, ORInadequate aircraft preflight inspection (engine air inlet cover not removed) by the pilot, resulting in obstruction of the carburetor air inlet in flight and consequent inflight engine stoppage. Factors contributing to the accident included a vehicle…NTSB SEA99LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Salem, ORThe pilot's improper decision not to apply carburetor heat during a reduced power descent in conditions conducive to carburetor icing. Factors include weather conditions conducive to carburetor icing, and high vegetation and a fence post in the area where the…NTSB SEA99LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Salem, ORThe pilot-in-command's misjudgment of distance/altitude on final approach, and overload of the left main landing gear. A factor was the embankment at the end of the landing strip.NTSB SEA99LA026Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe pilot's failure to maintain aircraft control.NTSB SEA99LA005Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Scappoose, ORAircraft control was not maintained. Inadequate remedial action is a factor.NTSB SEA98LA145Accident · 1 fatalLimited investigationFinal reportBaggarley Glasair II-FT · Vernonia, ORA loss of aircraft control for undetermined reasons.NTSB SEA98LA137Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Pacific City, ORThe pilot's improper compensation for wind conditions (landing with a tail wind.) Related factors were tail wind conditions, a short runway, and diminished brake system effectiveness.NTSB SEA98LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Newberg, ORThe pilots failure to account for the increased drag on the runway during the preflight planning. Factors were the long, wet grass.NTSB SEA97LA207Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel AIR 12-Q · Pendleton, ORthe tail wheel assembly spring disconnected.NTSB SEA97FA178Accident · 2 fatalField investigationFinal reportCessna 172M · Clackamas, ORThe pilot's failure to maintain adequate airspeed in a steep turn and his concurrent failure to maintain adequate altitude, resulting in an accelerated stall at an altitude insufficient for recovery. Factors include the pilot's intentional low altitude flight…NTSB SEA97LA069Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5A · North Bend, ORThe pilot's failure to perform the proper remedial action of applying carburetor heat/alternate induction air after impact ice accumulated on his aircraft's induction air filter. Factors include intentional flight into known adverse weather (icing…NTSB SEA97LA059Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Madras, ORThe pilot's inadvertent visual flight rules (VFR) flight into instrument meteorological conditions (IMC). Factors include the pilot's improper decision to fly under a low ceiling while in mountainous/hilly terrain, and his encounter with fog and low clouds…NTSB SEA96LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Pacific City, ORthe pilot's failure to see-and-avoid the transmission line. Factors relating to the accident were: the pilot's low altitude flight, and the transmission line.NTSB SEA96LA194Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mulino, ORloss of engine power for undetermined reason(s).NTSB SEA96LA180Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Klamath Falls, ORthe pilot's inadequate compensation for wind conditions, and his failure to maintain proper alignment with the runway during the landing/go-around. Factors relating to the accident were: strong, gusty crosswinds, and the encounter with a runway…NTSB SEA96LA116Accident · No injuriesLimited investigationFinal reportCessna 172L · Sisters, ORthe pilot's inadequate compensation for wind conditions during a go-around, which resulted in his failure to maintain proper runway alignment. Factors relating to the accident were: the variable/gusty crosswind condition, and the proximity of the hanger and…NTSB SEA96LA097Accident · No injuriesLimited investigationFinal reportPowers Bede BD-4 · Pacific City, ORthe pilot's inadequate compensation for wind conditions during the landing flare, and his failure to maintain runway alignment, which resulted in an encounter with tall grass beside the intended landing area. Factors relating to the accident were: the…NTSB SEA96LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Harper, ORthe pilot's selection of unsuitable terrain (landing area) for a precautionary landing. A factor relating to the accident was: the pilot became ill during the flight.NTSB SEA96LA035Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacific City, ORThe pilot's delay in aborting the landing, which resulted in his failure to clear the perimeter fence. Factors relating to the accident were: the tailwind, and the pilot's failure to land at the proper touchdown point.NTSB SEA96LA032Accident · No injuriesLimited investigationFinal reportCessna 172K · Owyhee, ORthe pilot's selection of unsuitable terrain for landing. The soft terrain and high vegetation were related factors.NTSB SEA95LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Arock, ORThe pilot's failure to maintain directional control during takeoff from a dirt road.NTSB SEA95LA184Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Owyhee, ORThe pilot's failure to maintain directional control. A factor contributing to the accident was his diversion of attention.NTSB SEA95LA105Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe student pilot's failure to maintain directional control while hovering, which resulted in the aircraft colliding with terrain. Contributing to the accident were gusting wind conditions.NTSB SEA95LA065Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe dual student pilot's failure to maintain directional control of the helicopter during the practice hover autorotation to landing, and the flight instructor's failure to adequately supervise the dual student during the landing. Contributing to the accident…NTSB SEA95LA046Accident · No injuriesLimited investigationFinal reportCessna 177 · Corvallis, ORThe pilot's improper flare and improper recovery from a bounced landing.NTSB SEA94LA171Accident · No injuriesLimited investigationFinal reportRobinson R-22M · Portland, ORTail rotor gearbox failure due to inadequate assembly and inspection procedures by the manufacturer.NTSB SEA94LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Prineville, ORThe pilot's inadequate compensation for wind conditions. A factor was gusty wind conditions.NTSB SEA94LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · Hillsboro, ORPoor in-flight planning. Factors to the accident were: inadequate remedial action and uncontrolled porpoise.NTSB SEA94FA071Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Frenchglen, ORThe pilot's failure to maintain minimum airspeed (vs). The tailwind was a factor.NTSB SEA94LA023Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Mckenzie Bridge, ORA partial loss of engine power for undetermined reasons.NTSB SEA94LA015Accident · 1 fatalLimited investigationFinal reportVarga 2150A · Burns, ORPoor in-flight planning/decision and an inadvertent stall/spin. A factor to the accident was an excessive pull-up.NTSB SEA93LA070Accident · No injuriesLimited investigationFinal reportCessna 172M · Salem, ORThe failure of the engine oil pump impeller.NTSB SEA93LA064Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Bend, ORRotor RPM was not maintained. Factors to the accident were: low ceiling and poor inflight planning.NTSB SEA93LA009Accident · Minor injuriesLimited investigationFinal reportMorrisey Shinn 2150A · Dallas, ORFailure to maintain airspeed. Factors include an improper fuel selector setting, and fuel starvation.NTSB SEA92LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Sisters, ORThe improper use of flight controls by the PIC during an aborted takeoff. Factors relating to the accident were the unfavorable wind (windshift) encountered during takeoff ground roll, the tailwind and high da weather conditions.NTSB SEA92LA090Accident · No injuriesLimited investigationFinal reportCessna 172N · Parkdale, ORThe pilot's failure to use the proper touchdown point for landing. A factor relating to the accident was the soft dirt runway surface.NTSB SEA92LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Newberg, ORA poorly planned final approach. Factors in the accident were: proper glidepath was not maintained and inadequate remedial action.NTSB SEA91LA141Accident · No injuriesLimited investigationFinal reportCessna 172-M · Salem, ORThe pilot's poor in-flight decision and his failure to select a proper touchdown point. Factors include a wet runway, soft terrain and high vegetation.NTSB SEA91LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Corvallis, ORThe student pilot's overconfidence in his personal ability and inadquate remedial action. Contributing to the accident was his decision to attempt a solo autoroation.NTSB SEA91LA145Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Corvallis, ORThe pilot displayed poor in-flight planning. A factor to the accident was: the pilot did not maintain a proper altitude over mountainous terrain.NTSB SEA91FA262Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Dayville, ORThe pilot's poor in flight decision. Factors include mountainous/hilly terrain.NTSB SEA90FA183Accident · 1 fatalField investigationFinal reportCessna 172-P · Hood River, ORThe pilot in command's encountering spatial disorientation and his failure to maintain airspeed.NTSB SEA90LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · North Plains, ORThe pilot's failue to maintain adequate clearance from an object near the runway.NTSB SEA90LA044Accident · Serious injuriesLimited investigationFinal reportRansome Pitts Special S-1C · Troutdale, ORInadequate maintenance which resulted in a loss of engine power during the initial climb shortly after takeoff.NTSB SEA90LA031Accident · No injuriesLimited investigationFinal reportCessna 172M · Salem, ORThe pilots inadequate visual lookout while taxiing. Factors related to the accident are: the pilot's diverted attention and the pole.