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 WPR22LA144Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Alpine, CAThe pilot’s failure to maintain clearance from rising terrain while operating in a canyon, which resulted in an impact with terrainNTSB ERA22LA164Accident · Minor injuriesClass 4 · LimitedFinal reportHartz Paul RV-6A · Lake City, FLThe pilot’s improper landing flare, which resulted in overload bending of the nose landing gear leg and subsequent nose-over.NTSB ERA22LA152Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Plainville, CTThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR22LA118Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Bonners Ferry, IDThe pilot’s improper landing flare, and bounced landing, which resulted in a ground loop and runway excursion.NTSB ERA22LA158Accident · No injuriesClass 4 · LimitedFinal reportAxell Charles L RV-6 · Laurens, NYThe pilot’s failure to maintain directional control during landing.NTSB CEN22LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Pinckneyville, ILThe airplane’s collision with a deer on the runway during landing.NTSB ERA22LA143Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Manassas, VAThe student pilot’s improper left rudder input after power application during the touch-and-go landing which resulted in a runway excursion and collision with airport lighting equipment. Contributing to the accident was the flight instructor’s inadequate…NTSB WPR22LA113Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Buffalo, WYThe pilot’s failure to compensate for a wind gust during the landing roll, which resulted in a loss of directional control and collision with terrainNTSB WPR22LA111Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Banning, CAThe solo student pilot's improper landing flare and bounced landing, which resulted in a runway excursion and impact with a parked vehicle and hanger.NTSB ERA22LA144Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-150 · Savannah, GAThe student pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN22LA129Accident · Serious injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Franklin, INThe pilot’s loss of control in the landing pattern resulting in an aerodynamic stall and impact with terrain.NTSB CEN22LA121Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Furlow, ARA loss of engine power for undetermined reasons.NTSB CEN22LA120Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Murphysboro, ILThe pilot’s failure to maintain clearance from power lines during approach for landing.NTSB ANC22LA017Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Kasilof, AKThe pilot’s decision to land on an unmaintained runway surface, which resulted in a loss of control and nose over.NTSB ERA22LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Waynesboro, VAThe student pilot’s loss of directional control while landing.NTSB ERA22LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Louisville, KYThe pilot’s failure to maintain directional control during landing in cross wind conditions.NTSB ERA22LA437Accident · No injuriesClass 4 · LimitedFinal reportWhiting Cleon Glasair SH-2 · Palmetto, FLThe pilot’s loss of directional control during takeoff roll.NTSB WPR22LA081Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28 · Scottsdale, AZA loss of engine power due to oil exhaustion.NTSB CEN22LA108Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Lamesa, TXThe pilot’s failure to maintain clearance from terrain during a descent that resulted in an impact with terrain.NTSB ERA22LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Knoxville, TNThe pilot of the Cessna 150’s failure to avoid the taxiing Cessna 172.NTSB ERA22LA101Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Lebanon, TNThe failure of the certified flight instructor to attain the proper glidepath which resulted in a collision with a fence and terrain.NTSB CEN22LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Minocqua, WIThe pilot’s loss of control during landing when the airplane encountered ice and snow on the runway.NTSB WPR22LA069Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172N · Auburn, CAThe pilot’s failure to maintain altitude during an instrument approach, which resulted in an impact with power lines.NTSB WPR22FA067Accident · 2 fatalClass 3 · FieldFinal reportVans RV6 · Show Low, AZThe pilot’s exceedance of the airplane’s critical angle of attack following an aborted landing approach, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery.NTSB WPR22LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Ivanhoe, CAThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB CEN22FA067Accident · 2 fatalClass 3 · FieldFinal reportPiper PA 28-140 · Houston, TXThe student pilot’s decision to depart into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB ANC22LA008Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Palmer, AKThe pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power, off-airport landing, and nose over.NTSB CEN22LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Wheeling, ILThe student pilot’s improper landing flare, which resulted in a hard landing. Contributing was the student pilot’s self-induced pressure to land after being admonished by the controller.NTSB CEN22LA041Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Miamisburg, OHThe student pilot’s failure to maintain control of the helicopter during a low-altitude hover shortly after liftoff.NTSB CEN22LA040Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 23 · Abilene, TXThe flight instructor’s inadequate fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the missing placard showing the usable fuel quantity.NTSB CEN22LA038Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-160 · West Union, OHA malfunction of the flight controls for reasons that could not be determined based on available information.NTSB GAA22WA031AccidentClass 5 · ForeignCessna 172N · Worms, GermanyNTSB ERA22LA066Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · St. Petersburg, FLThe pilot’s inadvertent selection of an off fuel selector position, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA22LA054Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Sarasota, FLA partial loss of engine power due to a failed throttle cable.NTSB CEN22LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Hudson Oaks, TXThe partial loss of engine power due to fuel exhaustion. Contributing was the pilot’s improper fuel planning.NTSB WPR22LA030Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Newdale, IDThe flight instructor’s failure to monitor the flight to ensure terrain clearance during the dark night conditions.NTSB WPR22FA022Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Ukiah, CAA power interruption due to water-contaminated fuel, which resulted in the student pilot aborting the takeoff and landing hard. Contributing to the accident were a leak in the left fuel tank that allowed water to enter and damage to the fuel tank that…NTSB ERA22LA033Accident · No injuriesClass 3 · LimitedFinal reportBeech 23 · Ballston Spa, NYThe flight instructor’s and student pilot’s inadequate preflight fuel planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR22LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · White Swan, WAA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB ERA22LA023Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Inverness, FLThe pilots inadequate recovery from a wind gust during landing, which resulted in a hard landing and substantial damage to the fuselage.NTSB WPR22LA009Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Albany, ORThe pilot's failure to maintain directional control during takeoff.NTSB ERA22LA006Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Williston, FLThe pilot’s failure to maintain clearance from terrain on approach which resulted in controlled flight into trees. Contributing to the accident was the flight instructor’s inadequate supervision of the approach path, the dark night conditions and the landing…NTSB ANC21LA098Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Willow, AKThe pilot’s failure to maintain clearance to terrain following a go-around.NTSB ERA22LA068Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Indian Trail, NCThe pilot’s failure to maintain airplane control during takeoff and initial climb. Contributing was the pilot’s physical limitation which caused an inadvertent application of left rudder.NTSB ANC21LA099Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Cordova, AKThe pilot’s failure to maintain control of the airplane after landing in gusty wind conditions.NTSB WPR21LA364Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Auburn, CAThe student pilot’s inadequate flare which resulted in a hard and bounced landing.NTSB WPR21LA348Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Grass Valley, CAThe pilot’s failure to attain a proper touchdown point on the runway while landing in gusting wind conditions, which resulted in a runway overrun. Contributing to the accident was the pilot’s distraction due to an electrical issue.NTSB ERA21LA370Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Walnut Cove, NCThe pilot’s failure to attain the proper touchdown point which resulted in a runway overrun, collision with an airport boundary fence, and a nose over event.NTSB ANC21LA092Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Homer, AKThe pilot’s failure to maintain directional control while landing in crosswind conditions.NTSB ANC21LA091Accident · No injuriesClass 4 · LimitedFinal reportChampion 7GCBC · Nenana, AKThe pilots over application of the brakes during landing, which resulted in a nose-over.