NTSB investigations: Lycoming 0-320 series
14,588 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 GAA18CA201Accident · Minor injuriesData collectionFinal reportCessna 172 · Livermore, CAThe student pilot’s failure to maintain runway centerline and flight instructor’s delayed remedial action during landing.NTSB GAA18CA191Accident · No injuriesData collectionFinal reportPiper PA18 · Dorris, CAThe pilot’s failure to maintain directional control during takeoff.NTSB GAA18CA176Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Ontario, ORThe flight instructor's failure to maintain directional control during landing, in cross wind conditions.NTSB GAA18CA197Accident · No injuriesData collectionFinal reportPiper PA28 · Cedar Key, FLThe pilot’s unstabilized approach, which resulted in a long landing and subsequent runway overrun.NTSB GAA18CA161Accident · No injuriesData collectionFinal reportCessna 172 · Green Valley, AZThe pilot’s failure to maintain directional control of the airplane during landing with a tailwind.NTSB WPR18FA104Accident · 1 fatalField investigationFinal reportPiper PA 18-150 · La Center, WAThe pilot's failure to maintain clearance from trees while maneuvering at a low altitude.NTSB GAA18CA181Accident · No injuriesData collectionFinal reportPiper PA22 · Hillsboro, ORThe pilot's failure to maintain directional control during the landing roll in tailwind conditions.NTSB ERA18LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Edgewater, FLThe flight instructor's failure to maintain the appropriate glidepath to the runway, which resulted in a collision with trees and terrain during final approach.NTSB GAA18CA204Accident · No injuriesData collectionFinal reportPiper PA28 · Vero Beach, FLThe student pilot’s failure to maintain a stabilized approach, which resulted in overcorrection with the rudder during the landing, loss of control, and a runway excursion.NTSB CEN18LA112Accident · No injuriesLimited investigationFinal reportPiper PA 28 · Mackinac Island, MIThe improper reinstallation of the right main landing gear by maintenance personnel which resulted in the separation of the landing gear and the subsequent abnormal runway contact during the landing.NTSB ERA18FA084Accident · 1 fatalField investigationFinal reportPiper PA28 · Bonifay, FLA partial loss of engine power due to a stuck exhaust valve. Contributing to the accident was the pilot's decision to operate an airplane with a known mechanical deficiency and his failure to fly an appropriate traffic pattern that would have allowed the…NTSB WPR18LA092Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Obyan, SarkThe pilot's inadequate preflight fuel planning and inadequate in-flight fuel monitoring which resulted in a total loss of engine power due to fuel exhaustion and an emergency landing and subsequent impact with a ditch.NTSB GAA18CA144Accident · No injuriesData collectionFinal reportPiper PA 22 · Ashland, OHThe pilot’s failure to maintain directional control during the landing roll resulting in a ground loop.NTSB GAA18CA135Accident · No injuriesData collectionFinal reportCessna 172 · Broomfield, COThe pilot’s failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.NTSB CEN18LA102Accident · Serious injuriesLimited investigationFinal reportScheineman-Van Buren T 18 · Longmont, COThe pilot’s failure to maintain directional control during the landing roll and the flight instructor’s delayed remedial action, which resulted in a groundloop and nose over.NTSB CEN18LA095Accident · Serious injuriesLimited investigationFinal reportHenderson Thorp T 18 · Troy, MOThe pilot's failure to maintain adequate clearance from trees while landing in crosswind conditions.NTSB CEN18LA092Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172M · Centralia, ILThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall/spin.NTSB GAA18CA120Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Santa Paula, CAThe pilot’s failure to maintain directional control during landing due to being distracted by another airplane and her delayed initiation of a go-around, during which the right wing struck a parked helicopter.NTSB ERA18LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Meriden, CTThe pilot's inadequate preflight fuel planning and his improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA18CA112Accident · No injuriesData collectionFinal reportCessna 172 · Silver City, NMThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a hard, bounced landing.NTSB CEN18FA083Accident · 1 fatalField investigationFinal reportSkwira Matthew J W-10 Tailwind · Sauk Centre, MNImpact with terrain for reasons that could not be determined based on the available information.NTSB WPR18CA072Accident · Minor injuriesData collectionFinal reportCessna 172P · Cloverdale, CAThe pilot's failure to maintain airplane control during the approach and his delayed decision to go around.NTSB GAA18CA102Accident · No injuriesData collectionFinal reportPiper PA 28 · Corona, CAThe student pilot and flight instructor’s failure to see and avoid powerlines during a simulated emergency landing, which resulted in a wire strike during a go-around.NTSB GAA18CA116Accident · No injuriesData collectionFinal reportBeech B19 · Meadville, PAThe student pilot’s failure to maintain directional control during landing.NTSB CEN18LA068Accident · No injuriesLimited investigationFinal reportBarnes Steven D Steve Barnes RV 4 · Montrose, COThe total loss of engine power for reasons that could not be determined because a postaccident examination of the engine did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR18FA063Accident · 2 fatalField investigationFinal reportCessna 172M · Ogden, UTThe pilot's failure to maintain clearance from the water while flying over a lake with glassy surface conditions. Contributing to the accident was the pilot's use of three impairing medications.NTSB ERA18TA059Accident · Minor injuriesFinal reportCessna 172 · Union Mills, NCThe pilot's failure to use carburetor heat in weather conditions conducive to serious carburetor icing, which resulted in a total loss of engine power and a subsequent forced landing.NTSB GAA18CA097Accident · No injuriesData collectionFinal reportCessna 172 · Monroe, MIThe student pilot’s improper yaw control during the landing flare and the flight instructor’s failure to take remedial action, which resulted in a hard landing.NTSB CEN18LA059Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCAA · Longmont, COThe failure of the landing gear through bolt primarily due to fatigue during a hard landing, which resulted in a landing gear collapse and runway excursion. Contributing to the accident was noncompliance with the manufacturer service letter.NTSB ERA18LA054Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Ridgeland, SCThe student pilot’s improper control inputs, which resulted in a loss of control on takeoff. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB WPR18CA048Accident · Serious injuriesData collectionFinal reportCessna 172P · Valley Springs, CAThe pilot's failure to maintain clearance from trees while maneuvering for landing and his decision to land on a surface with obstructions.NTSB GAA18CA078Accident · No injuriesData collectionFinal reportCessna 172 · Everett, WAThe pilot’s decision to abort the takeoff following a touch-and-go landing with too little runway remaining, which resulted in a runway overrun.NTSB ANC18CA017Accident · No injuriesData collectionFinal reportPiper PA 18-125 · Nikolai, AKThe pilot’s improper decision to contact an unsuitable landing surface, which resulted in a nose-over.NTSB WPR18LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Odessa, FLA loss of engine power due to fuel starvation as a result of the pilot's inadequate planning and in-flight fuel management. Contributing to the accident was the pilot’s failure to follow proper procedures after the loss of engine power.NTSB ANC18LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Oloh, MSA partial loss of engine power due to the failure of the No. 3 valve key (exhaust).NTSB CEN18LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Maple Lake, MNThe pilot’s failure to maintain directional control while landing, which resulted in a runway excursion.NTSB GAA18CA063Accident · No injuriesData collectionFinal reportCessna 172N · San Diego, CAAn in-flight collision with a bird.NTSB WPR18LA034Accident · Serious injuriesClass 2 · LimitedFinal reportCessna 172P · San Jose, CAThe pilot's delayed decision to execute an emergency landing and his attempt to return to the airport following a partial loss of power due to wear on internal engine components, which prevented the engine from developing full-rated power during the…NTSB GAA18CA048Accident · Minor injuriesData collectionFinal reportCessna 172M · Chico, CAAn in-flight collision with a bird.NTSB GAA18CA064Accident · No injuriesData collectionFinal reportCessna 172 · Pompano, FLThe pilot’s improper landing flare, which resulted in a porpoise.NTSB GAA18CA038Accident · Minor injuriesData collectionFinal reportPiper PA28 · Batavia, OHThe pilot’s failure to apply carburetor heat in conditions conducive to carburetor icing, which resulted in a partial loss of engine power during landing.NTSB CEN18FA024Accident · 4 fatalField investigationFinal reportCessna 172N · Hatch, NMThe pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.NTSB GAA18CA017Accident · Serious injuriesData collectionFinal reportYoung David E Pitts S1 C · Farmville, VAThe pilot’s failure to see and avoid the other airplane landing in the opposite direction on the runway. Contributing to the accident was the pilot’s failure to use the correct runway call sign in his radio communications.NTSB GAA18CA024Accident · No injuriesData collectionFinal reportCessna 172 · Old Bridge, NJThe student pilot’s failure to maintain directional control during the landing roll.NTSB CEN18FA011Accident · 2 fatalField investigationFinal reportCessna 172M · Ramsey, MNThe pilot's decision to fly along the river at a low altitude contrary to applicable regulations and safety of flight considerations which resulted in the impact with the power lines. Contributing to the accident was the pilot's inability to see the and avoid…NTSB CEN18LA012Accident · 1 fatalLimited investigationFinal reportGlobe GC 1A · Los Lunas, NMThe loss of directional control during takeoff and impact with a steel culvert.NTSB GAA18CA005Accident · No injuriesData collectionFinal reportCessna 172 · Black River Falls, WIThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB WPR18LA003Accident · No injuriesClass 3 · LimitedFinal reportBorom Marcus P Long EZ · Tucson, AZThe failure of both pilots to see and avoid the other airplane while maneuvering in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the controller's failure to provide adequate traffic information, issue necessary…NTSB WPR17FA215Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Brinnon, WAThe flight instructor's failure to completely and properly evaluate the student pilot's incorrectly- planned flight, and his failure to use all available resources to maintain situation awareness during the flight, which resulted in controlled flight into…NTSB WPR17LA216Accident · No injuriesLimited investigationFinal reportCessna 172P · TamuningThe pilot's inadequate preflight inspection, which resulted in oil exhaustion and a subsequent total loss of engine power during cruise flight.