NTSB investigations: Lycoming 0-320 series
14,589 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.\"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."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 DEN99LA085Accident · No injuriesLimited investigationFinal reportCessna 172L · Gunnison, COThe pilot's inadvertent stall/mush immediately after takeoff. Factors were the high density altitude weather condition, and the pilot's total lack of experience in type of operation.NTSB SEA99LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lyman, WAThe pilot-in-command's improper execution of takeoff procedures, and his delay in aborting the takeoff. Contributing factors were the fence post and trees.NTSB NYC99LA116Accident · 1 fatalLimited investigationFinal reportNations Acro Sport II · Pence Springs, WVThe student pilot's improper decision to perform aerobatics, and his failure to maintain aircraft control, which resulted in an inadvertent spin. A factor in the accident was the pilot's lack of aerobatic experience.NTSB FTW99LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palacios, TXThe pilot's failure to maintain clearance with terrain. A factor was the high vegetation.NTSB DEN99LA082Accident · No injuriesLimited investigationFinal reportRich RV3-A · Bountiful, UTThe pilot's inadequate preflight planning, and the subsequent fuel exhaustion during the flight. Factor was the airplane's inaccurate fuel gauge.NTSB CHI99LA168Accident · No injuriesLimited investigationFinal reportCessna 172P · Wichita, KSthe student pilot's improper recovery from a bounced landing.NTSB SEA99LA062Accident · No injuriesLimited investigationFinal reportCessna 172M · Omak, WAThe pilot's failure to properly secure the aircraft before hand-propping.NTSB ATL99LA090Accident · No injuriesLimited investigationFinal reportCessna 172M · Double Springs, ALThe pilot's failure to maintain directional control of the aircraft during landing. A factor was the pilot's lack of experience.NTSB ANC99TA061Accident · No injuriesFinal reportPiper PA-18 · Nome, AKThe pilot's failure to maintain directional control during landing. A factor in this accident was the crosswind.NTSB FTW99LA141Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Roanoke, TXThe partial loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB LAX99LA179Accident · No injuriesLimited investigationFinal reportHamilton Pitts Special SC-1 · Sacramento, CAThe pilot's misjudged flare, which led to bounced landing, and his failure to maintain directional control of the aircraft during the bounced landing recovery.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 NYC99FA107Accident · 1 fatalField investigationFinal reportCessna 172K · Shirley, NYThe pilot's loss of control of the airplane due to intoxication. A factor was the pilot's self-induced pressure to conduct the flight.NTSB FTW99LA133Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lancaster, TXThe pilot's inadequate preflight inspection which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB DEN99LA073Accident · Minor injuriesLimited investigationFinal reportDavis RV-6A · Truth Or Cnsqnc, NMA soft runway surface that caused the airplane to nose over.NTSB MIA99LA148Accident · No injuriesLimited investigationFinal reportCessna 172N · Eagleville, TNThe dual's student failure to maintain adequate altitude/clearance from the wire during takeoff/initial climb. Also causal was the certified flight instructor's inadequate supervision.NTSB NYC99LA105Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Oswego, NYThe pilot's inadequate fuel management which resulted in fuel starvation and subsequent loss of engine power.NTSB ANC99LA056Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Talkeetna, AKThe pilot's inadequate compensation for the wind conditions, and an inadvertent ground loop. A factor in the accident was a quartering tailwind.NTSB MIA99LA147Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Lares, PRThe improper touchdown by the pilot resulting in dynamic rollover. Contributing to the accident was the pilot's diverted attention.NTSB CHI99LA148Accident · No injuriesLimited investigationFinal reportCessna 172 · Blair, NEThe pilot's misjudged landing flare.NTSB ATL99FA078Accident · Serious injuriesField investigationFinal reportCessna 172N · Winter Haven, FLThe pilot of the other aircraft's failure to maintain visual lookout. A factor was the other pilot's disregard for VFR Traffic pattern procedures.NTSB DEN99LA067Accident · No injuriesLimited investigationFinal reportCessna 172I · Las Cruces, NMThe pilot of N46204's failure to maintain visual lookout and to identify the other aircraft visually during landing.NTSB CHI99LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · Mayview, MOthe pilot's selection of unsuitable terrain for the attempted precautionary landing. Factors to the accident were the overcast weather condition, inadequate preflight planning by the pilot, the inadvertent flight into instrument meteorological conditions, and…NTSB NYC99FA097Accident · 1 fatalField investigationFinal reportIves Sonerai II-L · Eastford, CTInadequate welding of the airplane's spar-box by the owner/builder, which resulted in a total spar-box failure in-flight. A factor in the accident was the pilot's decision to perform aerobatics.NTSB CHI99LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Morris, ILthe directional control not maintained by the pilot. Contributing factors were the wind gusts, crosswind and runway light.NTSB CHI99LA131Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greencastle, INthe pilot operating with known deficiencies in equipment and the fuel cap that disengaged. Factors were the wet grass, and muddy terrain conditions.NTSB FTW99LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Cleburne, TXThe pilot's improper flare which resulted in a hard landing and his improper recovery procedures from a bounced landing.NTSB NYC99LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Lumberton, NJThe pilot's misjudgment of altitude and distance which resulted in a runway overrun.NTSB ANC99LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions. Factors associated with the accident were a crosswind, and an inadvertent ground loop.NTSB SEA99LA049Accident · No injuriesLimited investigationFinal reportCessna 172N · Puyallup, WAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB NYC99LA089Accident · No injuriesLimited investigationFinal reportAmerican AA-5 · Stiefler Corner, PAThe pilot diverting his attention inside the cockpit, and allowing the airplane to enter instrument meteorological conditions, resulting in an in-flight collision with a tree.NTSB SEA99LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Boulder, MTThe pilot-in-command's failure to maintain directional control after encountering a dust-devil during landing rollout, resulting in a ground loop and collapse of the main landing gear. Factors include the dust-devil.NTSB CHI99LA125Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mora, MNthe student pilot's improper soft field takeoff technique in that excessive back pressure was used which resulted in an inadvertent stall/mush. A factor associated with the accident was the student's lack of total experience.NTSB DEN99LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Dulce, NMThe pilot-in-command becoming disoriented during cruise flight, and his intentional flight into instrument meteorological conditions without proper certification. Factors were the existing weather conditions that included snow, fog, obscuration and icing, the…NTSB FTW99LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · Turrell, ARThe total loss of engine power as the result of improper maintenance which led to the number one cylinder intake valve rocker assembly stud bolt backing out rendering the valve inoperative. A factor was the lack of suitable terrain for the forced landing.NTSB IAD99LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Zelienople, PAThe pilot's inadequate preflight planning to practice crosswind landings in wind that exceeded the airplane's demonstrated capability and his failure to maintain directional control. A factor in the accident was the high wind.NTSB FTW99LA114Accident · No injuriesLimited investigationFinal reportCessna 172N · Cleburne, TXThe pilot's failure to maintain adequate altitude/ clearance from the wires.NTSB FTW99LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Midlothian, TXThe pilot's failure to maintain clearance with the powerlines. Factors were the low ceilings and the dusk light illumination.NTSB LAX99LA131Accident · No injuriesLimited investigationFinal reportCessna 172N · Scottsdale, AZFailure of the student pilot to maintain directional control of the aircraft while retracting the flaps during a touch-and-go.NTSB CHI99LA118Accident · No injuriesLimited investigationFinal reportCessna 172M · New Hudson, MIThe pilot's misjudgment of speed and distance and his failure to execute a go-around. A related factor was the crosswind.NTSB ATL99LA057Accident · No injuriesLimited investigationFinal reportBeech 23 · Jacksonville, FLThe overload failure of the landing gear attach points during takeoff from a turf airstrip. Factors are rough and uneven terrain.NTSB LAX99LA123Accident · No injuriesLimited investigationFinal reportCessna 172M · Reno, NVThe pilot's inadequate compensation for the crosswind condition and his failure to maintain runway alignment during the crosswind landing.NTSB ANC99LA035Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Healy, AKThe pilot's inadequate recovery from a bounced landing. A factor associated with the accident was a snowbank.NTSB DEN99LA052Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Leadville, COThe pilot's inadequate compensation for the gusty crosswind conditions. A factor was the gusting crosswindNTSB SEA99LA043Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rexburg, IDA loss of engine power for undetermined reasons.NTSB LAX99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Rubidoux, CAThe pilot's failure to maintain adequate clearance from parked airplanes while taxiing due to his diverted attention.NTSB CHI99LA104Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainfield, ILthe pilot's inadequate directional control during landing roll. A factor was the snow bank.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 FTW99LA090Accident · No injuriesLimited investigationFinal reportCessna 172N · Orange, TXThe student pilot's failure to maintain directional control during landing touchdown. A factor was the muddy drainage ditch.NTSB NYC99LA066Accident · No injuriesLimited investigationFinal reportCessna 172N · Berlin, NJThe pilot in command's failure to obtain the proper touch down point on the runway, and failure to perform a go-around. A factor relating to the accident was a sudden wind shift.