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 ANC04LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-160 · Chugiak, AKThe pilot's excessive use of the airplane's brakes during the landing roll, which resulted in the airplane nosing over. A factor contributing to the accident was the pilot's failure to maintain directional control.NTSB IAD04LA034Accident · No injuriesLimited investigationFinal reportCessna 172N · Wellsboro, PAThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. A factor was the crosswind.NTSB ATL04LA167Accident · No injuriesLimited investigationFinal reportCessna 172M · Winston Salem, NCThe pilot's failure to maintain clearance from the fence post, while taxing which resulted in a collision.NTSB MIA04CA104Accident · Minor injuriesData collectionFinal reportWilliam K. Crawford Tango 2 · Williston, FLThe failure of the pilot to maintain directional control of the airplane during a high speed taxi test resulting in the airplane veering off the left side of the runway, becoming airborne, and nosing over.NTSB CHI04CA168Accident · No injuriesData collectionFinal reportPeck Vans RV-4 · Palmyra, WIThe pilot's failure to maintain proper airspeed resulting in the inadvertent stall during the go-around. The overload failure of the left main landing gear was a contributing factor.NTSB ANC04LA072Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Beluga, AKThe pilot's selection of an unsuitable area for landing, which resulted in an on ground encounter with rocks during the landing roll, and the collapse of the left main landing gear.NTSB SEA04LA115Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Deer Park, WAThe flight instructor's delayed remedial action. Factors include the owner/pilot's failure to maintain directional control during the landing roll, and a warped/realigned fuselage that contributed to the sensitivity of the aircraft's response to pilot rudder…NTSB SEA04CA116Accident · No injuriesData collectionFinal reportChampion 7GCB · Florence, ORPilot's improper touchdown point during landing. A sand mound was a factor in the accident.NTSB ATL04CA131Accident · No injuriesData collectionFinal reportCessna 172 · Meridianville, ALThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with the ground.NTSB ATL04CA129Accident · No injuriesData collectionFinal reportCessna 172N · Dover, TNThe certified flight instructor initiated flight into thunderstorm activity that resulted in a loss of control and the subsequent collision with trees.NTSB DEN04TA088Accident · Serious injuriesFinal reportCessna C172P · Las Cruces, NMthe pilot's failure to maintain clearance from terrain and the improper go-around procedure. Contributing factors include the pilot's diverted attention, improper in-flight planning and decision making, pilot fatigue, the night conditions and the mesquite…NTSB CHI04CA152Accident · No injuriesData collectionFinal reportCessna 172N · Hillsboro, NDDirectional control not obtained/maintained by the pilot during landing roll.NTSB LAX04LA235Accident · 1 fatalLimited investigationFinal reportHarold W Bruce RV-6 · Cloverdale, CAthe pilot's inadequate in-flight planning/decision and selection of the wrong runway, and his inadequate compensation for the gusting tail wind conditions, which resulted in a stall/mush.NTSB SEA04LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Trego, MTFailure to maintain clearance from trees during the initial climb.NTSB MIA04CA094Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Lake Wales, FLThe pilot's delay in aborting the takeoff resulting in an overrun of the runway and subsequent impact with water. A finding in the accident was the pilot's failure to extend the flaps to the second notch (25 degrees).NTSB SEA04LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Columbus, MTThe pilot's failure to maintain directional control of the aircraft during the landing and subsequent go-around. Inadequate compensation for the gusting winds and an airport hangar were factors.NTSB CHI04CA136Accident · No injuriesData collectionFinal reportCessna 172P · Milwaukee, WIThe CFI failed to maintain adequate airspeed during the go-around which resulted in an inadvertent stall.NTSB SEA04LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Easton, WAThe pilot's failure to maintain terrain clearance while maneuvering in mountainous terrain. Mountain terrain was a factor.NTSB FTW04LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesquite, TXThe student pilot's delayed landing flare and the improper supervision provided by the flight instructor.NTSB FTW04LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Levelland, TXThe student pilot's failure to maintain directional control and his inadequate compensation for the winds.NTSB ATL04LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · St. Marys, GAThe pilot failure to use carburetor heat when weather condition were favorable for the for the formation of carburetor ice. .NTSB SEA04LA096Accident · No injuriesLimited investigationFinal reportCessna 172M · Vernonia, ORThe instructor pilot's misjudgment of speed and distance and his failure to execute a go-around resulting in an overrun of the runway.NTSB NYC04CA134Accident · Serious injuriesData collectionFinal reportCessna 172M · Worcester, MAThe pilot's improper recovery from a bounced landing, and his inadequate compensation for wind conditions. A factor in the accident was the gusting wind.NTSB DEN04LA081Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Peyton, COthe pilot's inadequate in-flight planning and decision making and his failure to maintain aircraft control during the landing flare which resulted in impact with terrain. Contributing factors include the pilot's failure to perform a go-around and the wind…NTSB NYC04CA129Accident · Minor injuriesData collectionFinal reportGrumman American AA-5 · Greene, RIThe pilots improper decision to depart with the flaps set to 10 degrees, and his failure to obtain proper airspeed, which resulted in a collision with trees.NTSB LAX04CA214Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's improper application of brakes during the landing roll, resulting in a nose over.NTSB MIA04CA085Accident · No injuriesData collectionFinal reportCessna 172N · Pembroke Pines, FLThe pilot's failure to establish a climb and his failure to maintain directional control of the airplane during an aborted landing leading to the airplane departing the runway and incurring substantial damage.NTSB SEA04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Shelton, WAThe pilot's failure to adequately compensate for wind conditions during landing. Factors include a crosswind, fracture/collapse of the landing gear hydrasorb and an improper weld on the landing gear assembly.NTSB LAX04CA208Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe backhoe driver's failure to maintain visual lookout while maneuvering near a taxiway, which resulted in its collision with a taxiing airplane.NTSB CHI04LA119Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Winsted, MNThe failure of the main rotor drive belts for an undetermined reason, and the pilot's misjudged flare during the autorotation.NTSB ATL04LA112Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Cortland, ALThe pilot's misjudgment of distance/altitude and his failure to maintain obstacle clearance which resulted in an undershoot and collision with trees.NTSB SEA04LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Battle Ground, WAThe student pilot's misjudgment of distance and his failure to do a go-around. Also causal was the instructor's inadequate supervision of the flight. Factors include gusty crosswinds, the dual student's failure to adequately compensate for those winds, a wet…NTSB DEN04LA069Accident · Minor injuriesLimited investigationFinal reportBranham Vans RV-6 · Paragonah, UTThe pilot's inadequate preflight and in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power. The berm and the pilot not stopping to refuel the airplane were contributing factors.NTSB SEA04LA078Accident · No injuriesLimited investigationFinal reportRobinson R-22 Mariner · Chehalis, WAA loss of engine power for undetermined reasons.NTSB ANC04LA051Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kasilof, AKThe pilot's inadequate compensation for wind conditions while landing, which resulted in an undershoot and an in-flight collision with terrain. Factors associated with the accident were a downdraft, and an embankment.NTSB CHI04CA114Accident · No injuriesData collectionFinal reportCessna 172P · Schaumburg, ILThe student pilot not maintaining directional control during the takeoff roll and his inadequate remedial action.NTSB ATL04CA113Accident · No injuriesData collectionFinal reportCessna 172N · Odessa, FLThe pilot's improper landing flare that resulted in a hard landing.NTSB CHI04CA113Accident · Minor injuriesData collectionFinal reportCessna 172K · Harrisonville, MOThe dual student's failure to maintain directional control of the aircraft during the landing flare. Contributing factors were the dual student's failure to relinquish the controls to the flight instructor, the resulting inability of the flight instructor to…NTSB FTW04LA119Accident · Minor injuriesLimited investigationFinal reportHolmes RV-6A · San Antonio, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI04CA111Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Rochester, MNThe pilot's failure to maintain control of the helicopter during landing. Contributing factors were the aircraft's low altitude and the pilot's limited flight experience.NTSB LAX04CA196Accident · No injuriesData collectionFinal reportCessna 172N · Lincoln, CAthe pilot's failure to maintain obstacle clearance.NTSB DEN04CA067Accident · No injuriesData collectionFinal reportCessna 172N · Lyons, COa loss of engine power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing and unsuitable terrain available on which to make a forced landing and the road sign.NTSB CHI04CA110Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Shakopee, MNThe dual student's failure to maintain control of the helicopter during hovering flight and the flight instructor's delayed remedial action in order to prevent a loss of control. Contributing factors were the flight instructor's lack of dual instruction…NTSB ATL04FA099Accident · 3 fatalField investigationFinal reportCessna 172N · Moselle, MSThe pilot's failure to maintain clearance and his inadequate visual look-out while maneuvering resulting in an in-flight collision with a radio tower.NTSB ANC04LA045Accident · Serious injuriesLimited investigationFinal reportArctic S-1B2 · Big Lake, AKThe flight instructor's failure to insure that the carburetor heat was activated by the dual student following a simulated loss of engine power, which resulted in carburetor ice and the actual loss of engine power during a descent. A factor associated with…NTSB LAX04CA193Accident · Minor injuriesData collectionFinal reportRobinson R22B · Long Beach, CAthe pilot's inadequate compensation for gusty wind conditions and failure to maintain control of the helicopter while hovering.NTSB NYC04LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Berkley, MAThe pilot's misjudgment of altitude/distance and his failure to maintain adequate clearance from trees while landing. Factors related to the accident were the lack runway displaced threshold markings, the trees located at the end of the runway, and the…NTSB LAX04FA190Accident · Serious injuriesField investigationFinal reportPiper PA 28-161 · Holoaloa, HIThe pilot's continued flight into adverse weather conditions that resulted in an in-flight collision with mountainous terrain. Factors in the accident were rising terrain, low clouds and rain, and the pilot's lack of familiarity with the geographic area.NTSB SEA04LA071Accident · Serious injuriesLimited investigationFinal reportKeller Prospector FK1 · Gibbonsville, IDThe pilot's failure to apply carburetor heat in icing conditions which resulted in a loss of engine power while in cruise flight. Factors contributing to the accident are unsuitable terrain for an emergency landing , trees and mountainous terrain.NTSB NYC04CA108Accident · Serious injuriesData collectionFinal reportAndrews Zenith Tri-Z · Kennedy, NYThe pilot's improper fuel tank selector position which resulted in a loss of engine power due to fuel starvation.