NTSB investigations: Lycoming 0-320 series, GA
282 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.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA'
AND 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 NYC08CA037Accident · No injuriesData collectionFinal reportCessna 172N · Statesboro, GAThe student pilot's failure to maintain a proper flare at touchdown.NTSB MIA08FA003Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Newton, GAThe failure of the right wing wooden spar due while the airplane was in cruise flight, due to the mechanic's inadequate annual inspection and his failure to comply with an airworthiness directive.NTSB ATL07CA099Accident · No injuriesData collectionFinal reportCessna 172P · Perry, GAThe student pilot's failure to maintain directional control on landing roll out resulting in the airplane departing the runway and collision with a ditch.NTSB ATL07CA058Accident · No injuriesData collectionFinal reportCessna 172K · Cornelia, GAThe failure of the owner/operator to repair or replace a known leaking brake system components resulting in a total loss of brakes while taxing and an on-ground collision with trees.NTSB ATL07FA002Accident · 4 fatalField investigationFinal reportCessna 177 · Stockbridge, GAThe pilot's attempted takeoff over the allowable takeoff gross weight of the airplane and his failure to maintain airspeed during climb after takeoff.NTSB ATL06CA116Accident · No injuriesData collectionFinal reportCessna 172M · Augusta, GAThe pilot's improper flare on landing with excessive altitude resulting in a hard landing.NTSB ATL06CA105Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Griffin, GAThe pilot's failure to maintain direction control of the airplane during the landing roll.NTSB ATL06CA065Accident · No injuriesData collectionFinal reportCessna 172 M · Griffin, GAThe pilot's failure to achieve the proper touchdown point, which resulted in an overrun of the runway, collision with an embankment, and subsequent nose over.NTSB ATL06CA057Accident · No injuriesData collectionFinal reportCessna 172M · Newnan, GAThe student pilot's failure to maintain directional control on the landing roll out, resulting in the airplane veering off the right side of the runway and colliding with an airport runway sign.NTSB ATL06LA019Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Blairsville, GAThe non-instrument rated pilot's continued flight into known adverse weather and his failure to maintain clearance in mountainous terrain, resulting in an in-flight collision with trees and the ground. A factor in the accident was the pilot's lack of an…NTSB ATL06CA118Accident · No injuriesData collectionFinal reportCessna 172N · Perry, GAThe student pilot's failure to maintain airspeed during a touch-and-go landing on initial takeoff climb, resulting in a hard landing on the departure runway.NTSB ATL05CA132Accident · No injuriesData collectionFinal reportCessna 172P · Savannah, GAThe pilot's failure to maintain directional control on landing roll out resulting in a ground loop, and on ground collision of the right wing with the ground.NTSB ATL05CA096Accident · Serious injuriesData collectionFinal reportPiper PA-18A-150 · Griffin, GAThe pilot's mismanagement of the fuel supply which resulted in fuel starvation. A contributing factor was the pilot's inadequate preflight preparation which failed to verify the fuel amount.NTSB ATL05LA091Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Newnan, GAThe improper repair to the main landing gear assembly resulted in the actuator bracket failure and the right main gear collapse. A factor was the inadequate inspection of the right main landing gear.NTSB ATL05CA064Accident · No injuriesData collectionFinal reportPiper PA28-151 · Eastman, GAThe certified flight instructors failure to maintain a visual look out while demonstrating a simulated emergency landing resulting in an in-flight collision with a known transmission wire.NTSB ATL05CA058Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Suches, GAThe pilot's premature liftoff and failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall/mush to the runway and subsequent collision with a fence during aborted takeoff.NTSB ATL04CA162Accident · No injuriesData collectionFinal reportCessna 172 · Chamblee, GAThe pilot's improper landing flare that resulted in a hard landing. A factor was a tailwind condition.NTSB ATL04LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Cumming, GAThe pilot's failure to obtain takeoff performance data, and his intentional takeoff from a closed and short runway which resulted in an in-flight collision with a tree.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 ATL04CA089Accident · No injuriesData collectionFinal reportCessna 172N · Statesboro, GAThe pilot's failure to establish a positive climb and his failure to maintain clearance during a go-around, which resulted in an in-flight collision with trees. A factor was the gusting winds.NTSB ATL03FA142Accident · 1 fatalField investigationFinal reportCessna 172M · Perry, GAThe pilot inadequate preflight inspection of the airplane, and also causal was his failure to detect water-contaminated fuel which resulted in a loss of engine power and his failure to maintain adequate airspeed which resulted in an stall.NTSB ATL03LA120Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · Canon, GAThe loss of engine power due to water and corrosion in the fuel system. A factor was the collision with a ditch.NTSB ATL03LA098Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hampton, GAThe certified flight instructor's failure to maintain clearance from the runway during a low pass. A factor was gusty wind conditions.NTSB ATL03LA097Accident · No injuriesLimited investigationFinal reportCessna 172P · Newnan, GAThe pilot's failure to maintain directional control during the landing roll that resulted in the collapse of the right main landing gear.NTSB ATL03LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Savannah, GAThe pilot misjudged the landing distance, landed with excessive airspeed, did not attempt a go-around resulting in the airplane going off the overrun, and colliding with trees.NTSB MIA03LA035Accident · Minor injuriesLimited investigationFinal reportLonnie Johnson RV6A · Peachtree City, GAThe failure of the pilot to activate carburetor heat control during cruise flight after experiencing a loss of engine rpm, inadequate carburetor heat system by the builder, and the unsuitable terrain encountered by the pilot-in-command during the forced…NTSB ATL03LA024Accident · No injuriesLimited investigationFinal reportCessna 172N · Cartersville, GAThe student pilot's failure to maintain directional control, during the landing roll resulted in the on ground collision with a ravine.NTSB ATL02LA151Accident · No injuriesLimited investigationFinal reportCessna 172M · Dahlonega, GAThe pilot's improper recovery from a bounced landing and failure to maintain directional control resulting in the airplane going off the left side of the runway and colliding with a ditch.NTSB MIA02LA117Accident · No injuriesLimited investigationFinal reportCessna 172N · Marietta, GAthe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the left side of the runway, impacting with a gully and nosing over.NTSB ATL02LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Thomaston, GAFailure of the pilot-in-command to maintain directional control on landing, resulting in an inadvertent ground loop.NTSB ATL02LA090Accident · No injuriesLimited investigationFinal reportCessna 177 · Locust Grove, GAThe pilot improper flare during an aborted takeoff, followed by an subsequent hard landing.NTSB ATL02FA059Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Macon, GAThe pilot's failure to maintain clearance from a tree while maneuvering after takeoff.NTSB ATL02LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Kennesaw, GAThe pilot's improper in-flight planning/decision resulting in a total loss of engine power due to fuel exhaustion,which resulted in a forced landing, and subsequent in-flight collision with transmission wires.NTSB MIA01LA207Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Covington, GAThe flight instructor's improper monitoring of the dual student during a simulated engine out approach and her delayed decision to initiate a go-around resulting in the airplane colliding with trees at the departure end of the runway during the go-around.NTSB ATL01LA069Accident · No injuriesLimited investigationFinal reportCessna 177 · Milledgeville, GAThe student pilot's failure to maintain directional control and the subsequent collision with an object during an attempted landing. A factor was porpoise induced oscillation.NTSB MIA01LA159Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Dahlonega, GAThe failure of the No. 3 exhaust valve due to fatigue cracking for undetermined reasons, which resulted in a partial loss of engine power and an in-flight collision with a building during an attempted forced landing to unsuitable terrain..NTSB MIA01LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Tifton, GAThe pilot's failure to properly judge his altitude (too high) during a forced landing to a runway. The pilot made a 270-degree turn in an attempt to lose altitude resulting in a forced landing in a swampy/marshy area short of the runway. Contributing to the…NTSB MIA01LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Jesup, GAA total failure of the wheel braking system due to the pilot's improper use of braking in downwind, downhill conditions, resulting in overheated brakes, and subsequent encounter with a downslope and terrain collision.NTSB MIA00LA223Accident · No injuriesLimited investigationFinal reportCessna 172P · Jesup, GAThe failure of the student pilot to maintain directional control during takeoff resulting in an excursion off the runway and collision with adjacent foliage. A factor in the accident was the student's decision to takeoff downwind.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 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 MIA99LA059Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Conyers, GAThe pilot's decision to attempt a touch-and-go landing with insufficient runway remaining, and his failure to maintain adequate clearance from an object (tree).NTSB MIA99LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chamblee, GAThe pilot's excessive use of right wheel brake to correct for a left drift during landing rollout resulting in a ground loop to the right and the left wing contacting the runway.NTSB MIA99LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Lawrenceville, GAA fire from an undetermined origin.NTSB MIA98LA150Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Woodstock, GAThe pilot's failure to establish a positive climb to outclimb obstacle (tree) and his decision to execute a takeoff with a tailwind.NTSB MIA98LA126Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Mallards Ldg, GAA deer on the runway which led to the pilot's evasive manuever to avoid the deer.NTSB ATL98FA060Accident · 5 fatalField investigationFinal reportCessna 525 · Marietta, GAThe failure of both pilots to see and avoid conflicting traffic, and the failure of the 172 pilot to operate the transponder as required by current regulations. Factors were the controller's failure to observe the traffic conflict, the lack of radar conflict…NTSB ATL98LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lawrenceville, GAfailure of the student pilot to maintain directional control of the airplane, during the landing roll.NTSB MIA98FA015Accident · 2 fatalField investigationFinal reportCessna 172M · Rabun Gap, GAThe pilot's continued flight under visual flight rules into known instrument meteorological conditions and his failure to maintain a safe altitude for terrain clearance resulting in the aircraft colliding with trees and the ground on the side of a mountain.NTSB MIA97LA247Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Bainbridge, GAthe failure of the pilot to see and avoid the tractor resulting in an on ground collision. A factor in this accident was the limited forward visibility from the cockpit of the airplane.