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 ANC99LA149Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were a windshear, and a short runway area.NTSB LAX99LA313Accident · No injuriesLimited investigationFinal reportCessna 172N · Merced, CAThe pilot's premature retraction of the flaps during an attempted go-around with insufficient airspeed, which led to an inadvertent stall/mush condition.NTSB FTW99LA260Accident · No injuriesLimited investigationFinal reportCessna 172K · Mountain Home, ARThe pilot's failure to obtain runway alignment. Factors were the dark night conditions, an embankment, and the pilot's lack of total experience flying at night.NTSB LAX99LA307Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Azusa, CAthe pilot's delay in recognizing the settling with power condition while performing a pinnacle approach, thus delaying his attempted go-around.NTSB ANC99LA138Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKA loss of engine power for an undetermined reason. A factor in the accident was unsuitable terrain for a forced landing.NTSB LAX99LA306Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAThe pilot's failure to maintain an adequate visual lookout during taxi. Sun glare was a factor in the accident.NTSB SEA99LA160Accident · No injuriesLimited investigationFinal reportCessna 172M · Tahola, WAThe pilot's inadequate directional control and his failure to maintain clearance from trees along the side of the landing area. Factors include a landing area surrounded by tall trees.NTSB MIA99LA256Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Canton, GAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during.NTSB CHI99LA336Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Daleville, INA loss of engine power for undetermined reasons.NTSB ANC99LA143Accident · No injuriesLimited investigationFinal reportDiehl Interstate S-4 · Anchorage, AKThe pilot's inadequate planning/decision, and his failure to maintain directional control of the airplane. Factors in the accident were a short runway/lake area for departure, and the pilot's extension of the landing gear steering system (water rudders)…NTSB SEA99LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Hillsboro, ORLoss of engine power due to fuel contamination.NTSB LAX99LA300Accident · Minor injuriesLimited investigationFinal reportRobinson R-22-BETA · Piute, NVthe failure of the pilot to maintain rotor rpm while practicing autorotations, resulting in a hard landing and roll over.NTSB LAX99FA301Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Strathmore, CAThe failure of the pilot to maintain an adequate terrain and obstacle clearance altitude, which resulted in a collision with power transmission wires.NTSB CHI99LA333Accident · No injuriesLimited investigationFinal reportCessna 172K · Pickrell, NEthe loose oil dipstick guide tube resulting in loss of oil and the engine failure. The night condition was a contributing factor.NTSB ANC99LA148Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Sleetmute, AKThe pilot's selection of an unsuitable landing area. A factor in this accident was the rough and uneven gravel bar.NTSB LAX99LA309Accident · No injuriesLimited investigationFinal reportCessna 172N · Carlsbad, CAThe pilot's failure to maintain an adequate clearance from obstacles during taxi in a confined space.NTSB ANC99LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Kenai, AKThe pilot's inadvertent stall. A factor was the intentional low altitude maneuvering by the pilot.NTSB SEA99LA154Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Columbus, MTThe pilot's failure to maintain directional control. A wet runway surface was a factor.NTSB DEN99LA159Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COThe pilot's failure to maintain adequate airspeed during the flare for landing/touchdown phase of flight. A factor was a ditch off the side of the runway.NTSB DEN99FA158Accident · 2 fatalField investigationFinal reportWroblewski RV-4 · Bayfield, COThe pilot's failure to maintain control of the aircraft for undetermined reasons.NTSB ANC99LA131Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Skwentna, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were a crosswind, and wind gusts.NTSB CHI99LA313Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pawnee City, NEThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB MIA99LA239Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot misjudged the flare, resulting in the nose gear impacting the runway, and a bounced landing.NTSB LAX99LA286Accident · No injuriesLimited investigationFinal reportCessna 177 · Carson City, NVThe pilot's use of an excessive approach reference airspeed, his misjudged landing flare, and subsequent hard landing/porpoise. A contributing factor was the airplane's excessive approach airspeed.NTSB CHI99LA312Accident · No injuriesLimited investigationFinal reportCessna 172M · Bloomington, ILthe pilot's inadequate visual lookout and not performing a maneuver to avoid obstructions. A factor was the road signs.NTSB MIA99LA238Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Jackson, ALthe pilot's inadequate preflight planning and preparation, which resulted in taking off with the airplane's maximum gross weight exceeded, and subsequent impact with trees. Factors in this accident were high temperatures and an in-flight encounter with a…NTSB NYC99LA209Accident · Serious injuriesLimited investigationFinal reportMorrisey 2150A · Ellisburg, NYThe pilot's delay in applying carburetor heat which resulted in the loss of power, and his misjudgment of the flare during the forced landing.NTSB NYC99FA210Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Saddle Island, METhe pilot's failure to maintain altitude/clearance from trees.NTSB ANC99LA135Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Fairbanks, AKThe pilot's inadvertent stall during the landing flare.NTSB ANC99LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Sleetmute, AKThe pilot's selection of an unsuitable takeoff area, which resulted in the airplane colliding with vegetation, knocking the gascolator off the airplane, and fuel starvation of the engine.NTSB DEN99FA148Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Newcastle, WYThe pilot's inadequate visual lookout and inadequate altitude/clearance from the transmission wires.NTSB ANC99LA119Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Seward, AKThe pilot's selection of unsuitable terrain for landing. A factor was soft sand.NTSB IAD99LA058Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Islip, NYwas the student pilot's improper control input and the flight instructor's delayed remedial action.NTSB CHI99FA293Accident · 2 fatalField investigationFinal reportHudson Avenger · Lansing, ILthe weight and balance exceeded by the owner/builder. The inadequate preflight planning/preparation by the owner/builder.NTSB CHI99LA301Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Red Wing, MNDirectional control not being maintained by the pilot. A factor to the accident was the ditch.NTSB ANC99LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's inadequate compensation for wind conditions during takeoff. A factor was a crosswind, and an inadvertent ground loop.NTSB MIA99FA224Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pembroke Pines, FLThe failure of the pilot to maintain airspeed and inadvertent stall of the airplane by the pilot-in-command resulting in the uncontrolled descent and in-flight collision with a house. Contributing factors in the accident were the loss of engine power due to…NTSB FTW99LA219Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5A · Wayton, ARThe pilot's inadequate compensation for wind conditions, and his failure to maintain clearance with trees during a go-around. Factors were the gusty wind condition, and the high density altitude. Factors associated with the accident were gusty winds, and a…NTSB ANC99LA111Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's selection of unsuitable terrain for landing. A factor was high vegetation in the landing area.NTSB NYC99LA196Accident · No injuriesLimited investigationFinal reportCessna 172P · Montgomery, NYthe failure of the student pilot to maintain directional control during the touchdown and landing roll.NTSB ANC99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's selection of unsuitable terrain for landing. A factor was high vegetation.NTSB FTW99LA250Accident · No injuriesLimited investigationFinal reportCessna 177 · Austin, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane.NTSB FTW99LA213Accident · No injuriesLimited investigationFinal reportCessna 172N · Hot Springs, ARthe pilot's failure to refuel the airplane which resulted in fuel exhaustion and a total loss of engine power. A factor was the lack of suitable terrain for a forced landing.NTSB CHI99LA279Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Schaumburg, ILthe CFI's delay in taking remedial action to maintain directional control of the airplane. A factor associated with the accident was the student's improper use of the brakes.NTSB CHI99FA284Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Titonka, IAThe low altitude maneuver attempted and altitude/clearance not being maintained by the pilot, which resulted in an impact with a pine tree. A factor to the accident was the pine tree.NTSB ANC99FA110Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Anaktuvuk Pass, AKThe inadvertent stall/spin by the pilot. A factor was the box canyon into which he had flown.NTSB LAX99LA265Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Coalinga, CAThe flight instructor's failure to maintain a sufficient airspeed to compensate for the known wind shear condition, which resulted in a failure to maintain runway alignment and a hard landing. The flight instructor's inadequate supervision of the flight was…NTSB SEA99LA132Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Creek, IDThe pilot-in-command's improper remedial action (continued takeoff). Contributing factors were the tree and control interference (inadvertent brake activation) by the passenger..NTSB MIA99LA210Accident · No injuriesLimited investigationFinal reportWilderoder Great Lakes 2TIA · Pensacola, FLThe pilot's failure to check the brake hydraulic fluid reservoir prior to flight resulting in a low fluid level going undetected and failure of the brakes during landing rollout, which resulted in the aircraft overrunning the runway, colliding with a fence,…NTSB MIA99LA207Accident · No injuriesLimited investigationFinal reportCessna 172M · Pierson, FLthe flight instructor's (pilot in command) failure to achieve the proper touch down point, his improper decision to continue the touch and go, and failure to abort the takeoff in sufficient time, resulting in the aircraft overrunning the runway and colliding…