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 ANC99LA098Accident · No injuriesLimited investigationFinal reportCessna 172 · Sheldon Point, AKThe pilot's inadequate compensation for the gusty crosswind conditions during takeoff. Factors associated with the accident were a crosswind, and wind gusts.NTSB LAX99LA259Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hayward, CAthe pilot's failure to apply carburetor heat to prevent the formation of carburetor ice while operating in IFR conditions which resulted in the loss of engine power.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 LAX99LA257Accident · No injuriesLimited investigationFinal reportEwertz Starduster II · Winslow, AZthe pilot's failure to attain and maintain a sufficient flying airspeed for the existing density altitude conditions, which resulted in an inadvertent stall/mush.NTSB DEN99LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA28-160B · Pueblo, COTotal loss of power during initial climb for undetermined reasons.NTSB ATL99LA113Accident · No injuriesLimited investigationFinal reportBeech BE23 · Vidalia, GAPilot's decision to attempt a takeoff from an unsuitable pasture. A factor contributing to the accident consisted of previous damage to the leading edges of the wings.NTSB FTW99LA200Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Alvaredo, TXThe student pilot's failure to maintain a proper glidepath during his short-field approach.NTSB DEN99LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Lamar, COThe left brake locked during takeoff roll for undetermined reasons.NTSB CHI99LA245Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, MIthe student pilot's inadequate use of the rudder which resulted in a loss of directional control during an aborted landing. A factor associated with the accident was the student's lack of total experience and the segmented circle which the airplane contacted.NTSB ANC99LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Teller, AKThe pilot's improper starting procedure.NTSB ATL99LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · Kissimmee, FLThe pilot's improper flare and recovery from a bounced landing.NTSB DEN99LA121Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe flight instructor's failure maintain aircraft control. A factor was the inadequate supervision by the flight instructor.NTSB CHI99LA237Accident · No injuriesLimited investigationFinal reportCessna 172L · Montezuma, IAthe pilot inadvertently landed on the wrong runway and exceeded the proper touchdown point on the runway. Factors associated with the accident were the gusty tailwind, the fence, and the ditch.NTSB DEN99FA120Accident · 4 fatalField investigationFinal reportPiper PA-22-150 · Roy, UTThe pilot inadvertently allowing the aircraft to enter a stall during initial climb following takeoff. Factors were high density altitude and gross weight which exceeded the maximum.NTSB CHI99LA224Accident · No injuriesLimited investigationFinal reportCessna 172N · Faribault, MNthe pilot's failure to maintain directional control of the airplane during the takeoff ground run.NTSB LAX99LA250Accident · No injuriesLimited investigationFinal reportCessna 172M · Fresno, CAThe pilot's misjudged landing flare and inadequate recovery procedures from the subsequent bounced landing.NTSB NYC99LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Mattituck, NYThe pilot's failure to maintain control of the airplane, and the flight instructor's inadequate supervision of the solo flight.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 SEA99FA105Accident · 1 fatalField investigationFinal reportGadbury RV-6A · Arlington, WAThe pilot's excessive climb rate, which lead to his failure to maintain an airspeed above stalling speed (Vs). Factors include the pilot's lack of total experience in the aircraft make and model.NTSB CHI99LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Rogers City, MIThe pilot's inadequate compensation for the crosswind.NTSB SEA99LA110Accident · Minor injuriesLimited investigationFinal reportParks RV-6 · Hunters, WAThe pilot's failure to maintain adequate airspeed during an attempted go-around.NTSB FTW99LA181Accident · Minor injuriesLimited investigationFinal reportPitts Special S-1C · Temple, TXThe loss of engine power due to fuel starvation, as a result of fuel moving away from the fuel supply outlets during maneuvering with a low fuel level, and the pilot's failure to maintain clearance with the power lines during the ensuing forced landing.NTSB SEA99LA101Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Auburn, WATotal mechanical failure of the hydraulic tappet. A factor was an overdue major overhaul per manufacturer's recommendations.NTSB NYC99LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · New Castle, VAThe pilot tookoff with the fuel tank selector in an improper position (OFF), resulting in fuel starvation.NTSB CHI99LA198Accident · No injuriesLimited investigationFinal reportMahler BD-4 · Baldwin City, KSThe pilot not maintaining directional control with the runway centerline during takeoff. A factor was the high vegetation off the left side of the runway.NTSB ANC99LA081Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Anchorage, AKThe pilot's failure to maintain an adequate airspeed, and subsequent inadvertent stall.NTSB NYC99FA157Accident · 1 fatalField investigationFinal reportRobinson R-22 · Hurricane, WVA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain rotor rpm and the transmission wires.NTSB NYC99WA206Accident · 4 fatalForeign investigationRobinson R22 · Grossenhain, GermanyNTSB LAX99LA221Accident · Serious injuriesLimited investigationFinal reportCessna 172M · San Diego, CAThe mechanic's improper installation of nonapproved automotive electrical system parts, and his failure to ensure that all electrical connections were secure during the reinstallation, which resulted in the failure of the electrical system. The pilot's…NTSB CHI99LA191Accident · No injuriesLimited investigationFinal reportBeech B19 · Taylor, MOthe airplane pilot's and the helicopter pilot's failure to maintain visual clearance from each other while in the traffic pattern.NTSB SEA99LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Zillah, WAThe pilot's selection of unsuitable terrain for landing adjacent to the runway. Factors include sun glare encountered at the time of the landing attempt.NTSB ANC99LA078Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Skwentna, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident was high vegetation.NTSB DEN99LA106Accident · No injuriesLimited investigationFinal reportCessna 172N · Platteville, COThe pilot misjudging the flare altitude, resulting in a hard landing, and his subsequent loss of aircraft control. A factor was overload forces collapsing the nose landing gear assembly.NTSB SEA99LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Easton, WAThe flight instructor's delayed remedial action. Factors include the student allowing the aircraft to climb too steeply at too low an airspeed, and the soft/rough terrain on which the aborted takeoff took place.NTSB NYC99LA137Accident · No injuriesLimited investigationFinal reportCessna 172 · Ravenna, OHThe pilot-in-command's failure to maintain aircraft control during landing.NTSB ANC99LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Big Lake, AKThe pilot's inadvertent stall during takeoff. Factors associated with the accident are wind gusts and turbulence.NTSB LAX99LA213Accident · No injuriesLimited investigationFinal reportCessna 172 · Weaverville, CAthe pilot's failure to follow prescribed procedures and directives for the particular airport.NTSB CHI99LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Traer, IAThe pilot's not maintaining proper runway alignment during the aborted takeoff, and the airport personnel not maintaining the runway. Factors were rough terrain and a dirt bank.NTSB CHI99LA178Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Salem, MOthe engine quit due to water contamination of the fuel and the pilot's inadequate preflight.NTSB CHI99FA174Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Drummond Island, MIthe altitude/clearance not obtained/maintained and the inadequate planning/decision by the pilot-in-command. The exceeded aircraft performance was an additional cause. The unfavorable wind and trees were contributing factors.NTSB LAX99LA209Accident · 1 fatalLimited investigationFinal reportBlanco SEA Hawker · Yucca Valley, CAA loss of control in flight for undetermined reasons that resulted in an in flight collision with terrain. A factor was turbulent weather conditions in mountainous/hilly terrain.NTSB ANC99LA158Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ekwok, AKThe pilot's inadequate compensation for crosswind conditions. Factors in the accident were a crosswind, and an inadvertent ground loop.NTSB ANC99LA069Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's failure to compensate for the wind conditions and maintain a proper rate of descent during the approach for landing, which resulted in a hard landing, and the subsequent collapse of the right main landing gear strut.NTSB NYC99LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe flight instructors failure to maintain climb airspeed during the go-around, which degraded climb performance, resulting in an in-flight collision with terrain. Factors in the accident were, delay in executing a go-around, retracting the flaps to 10…NTSB LAX99LA204Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesa, AZThe failure of the tower (local) air traffic controller to issue a landing sequence to the climbing, high wing Cessna 172 aircraft, and, the controller's failure to maintain visual separation between the two aircraft on downwind leg.NTSB ANC99LA067Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKThe pilot's inadequate compensation for a crosswind. A factor associated with the accident is a crosswind.NTSB NYC99LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Alliance, OHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Factors in this accident were the crosswind conditions and wind gusts.NTSB NYC99FA125Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Hillsborough, NJThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor in the accident was the pilot's lack of experience in the accident airplane's make and model.NTSB FTW99FA153Accident · 2 fatalField investigationFinal reportMooney M20B · Mesquite, TXThe failure by both pilots to maintain visual lookout. A factor was the inadequate radio communications maintained by both pilots while in the traffic pattern.