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 ERA15LA015Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Granville, MADeformation of the No. 1 cylinder's intake valve, which resulted in a partial loss of engine power and a subsequent off-airport precautionary landing.NTSB ANC15CA002Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cordova, AKThe pilots decision to land and failure to maintain control of the airplane during landing in gusty wind conditions.NTSB ERA15CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Toccoa, GAThe private pilot's failure to maintain proper altitude and the flight instructor's failure to provide correction action, which resulted in a collision with terrain during landing.NTSB WPR14CA399Accident · No injuriesData collectionFinal reportCessna 172N · Thermal, CAThe student pilot's failure to maintain directional control during landing after an encounter with a dust devil.NTSB ERA14FA459Accident · 2 fatalField investigationFinal reportCessna 172M · Lancaster, NYThe other airplane pilot’s failure to maintain an adequate visual lookout for known traffic in the fly-in event traffic pattern, which resulted in a midair collision.NTSB ERA14LA451Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Homosassa, FLA partial loss of engine power for reasons that could not be determined because engine examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR14CA384Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Meadow Creek, MTThe pilot's inadequate landing flare and failure to maintain aircraft control during landing.NTSB WPR14CA383Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Rimrock, WAThe pilot's failure to maintain aircraft control during takeoff from a rough runway surface which resulted in an off-airport forced landing just beyond the runway.NTSB ERA14LA448Accident · No injuriesLimited investigationFinal reportCessna 172M · Leesburg, FLThe flight instructor’s delayed remedial action and his subsequent loss of directional control during landing on a wet runway for reasons that could not be determined because postaccident examination of the airplane revealed no anomalies.NTSB ANC14CA084Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cantwell, AKThe pilot's loss of directional control during takeoff from an off-airport site, which resulted in a collision with terrain.NTSB WPR14LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Lone Pine, CAThe fatigue failure of a propeller blade due to a propeller strike by/of an unidentified object at an unknown time.NTSB ANC14CA080Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Aniak, AKThe pilot's inability to maintain directional control of the airplane resulting in a separation of the wheel axle, resulting in a collision with terrain.NTSB ERA14LA434Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Spruce Creek, FLA total loss of engine power due to fuel exhaustion, which resulted from the pilots’ improper preflight and in-flight fuel planning.NTSB CEN14CA496Accident · No injuriesData collectionFinal reportCessna 172M · Oxford, WIThe pilot did not compensate for the decrease in the crosswind when he descended below the tree line during the landing.NTSB ERA14CA430Accident · Minor injuriesData collectionFinal reportCessna 172M · Watertown, CTThe pilot's decision to takeoff from a field which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's failure to correctly identify the destination airport and runway, which resulted in an off-airport landing in…NTSB ERA14FA428Accident · 2 fatalField investigationFinal reportCessna 172 · Selkirk, NYA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN14CA488Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Belen, NMThe student pilot's improper recovery from a bounced landing.NTSB CEN14CA512Accident · No injuriesData collectionFinal reportChampion 7GCAA · Alpine, TXThe loss of airplane control during a precautionary landing resulting in a hard landing.NTSB ERA14CA431Accident · No injuriesData collectionFinal reportPiper PA-18A-150 · Gunthersville, ALThe pilot's failure to retract the landing gear wheels prior to a water landing, resulting in a nose over upon touchdown.NTSB ANC14CA074Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Fairbanks, AKThe pilot's inability to maintain directional control of the airplane resulting in a runway excursion and collision with terrain.NTSB CEN14CA481Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Plymouth, INThe sun glare and the pilot's subsequent loss of airplane control.NTSB ANC14CA070Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Beluga, AKThe pilot's selection of an unsuitable takeoff area, resulting in an inflight collision with vegetation/brush during takeoff.NTSB WPR14CA354Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe student pilot's failure to maintain helicopter control during a practice hover. Contributing to the accident was the flight instructor's delayed remedial reaction.NTSB ERA14CA407Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Taylorsville, KYThe pilot's decision to land on a wet runway and delayed go-around attempt, which resulted in a collision with terrain.NTSB CEN14LA451Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Gordonville, TXA loss of directional control during a crosswind landing.NTSB CEN14FA448Accident · 1 fatalField investigationFinal reportAmerican Champion 7GCBC · Lago Vista, TXThe pilot's decision to fly at a low altitude and his subsequent failure to see and avoid the power lines.NTSB CEN14LA449Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · New Orleans, LAThe in-flight fatigue failure of the crankshaft gear retaining bolt, which resulted in a total loss of engine power. Contributing to the accident were the pilot/owner’s failure to maintain the airplane in accordance with an airworthiness directive following a…NTSB CEN14FA435Accident · 1 fatalField investigationFinal reportCessna 172N · Natchitoches, LAThe partial loss of engine power due to the exhaust valve rocker retaining stud backing out of the cylinder head, which resulted in the exhaust valve being stuck in the closed position. Contributing to the accident was the pilot’s failure to configure the…NTSB ERA14LA392Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Itta Bena, MSA total loss of engine power during maneuvering due to an obstruction from air intake filter material being ingested into the carburetor, which resulted in a forced landing.NTSB ANC14CA066Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Skwentna, AKThe pilot's failure to maintain the proper approach path for landing, and his delayed remedial action, which resulted in an undershoot and collision with terrain.NTSB WPR14CA344Accident · No injuriesData collectionFinal reportCessna 177 · Pine Bluffs, WYThe pilot's inadequate flare and failure to maintain aircraft control while landing.NTSB WPR14LA338Accident · No injuriesClass 3 · LimitedFinal reportNelson RV 3M · North Plains, ORA partial loss of engine power for undetermined reasons which resulted in a landing gear collapse during the precautionary landing to a field.NTSB ERA14CA438Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Block Island, RIA loss of control during the attempted go-around, which resulted in an aerodynamic stall and impact with trees.NTSB ERA14CA375Accident · Minor injuriesData collectionFinal reportCessna 172N · Valkaria, FLThe pilot's misjudgment of speed and distance on final approach during a precautionary landing, resulting in a touchdown off the departure end of the runway and collision with terrain. A factor in the accident was a partial loss of engine power for reasons…NTSB CEN14CA410Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Beach, NDThe student pilot's failure to initiate a go-around sooner, and his failure to maintain directional control.NTSB CEN14FA396Accident · Serious injuriesField investigationFinal reportRender RV 9A · Oshkosh, WIThe pilot's failure to establish a stabilized approach and to maintain airspeed during final approach over obstacles resulting in a stall/mush.NTSB CEN14CA392Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Caputa, SDThe student pilot's improper takeoff procedure and the flight instructor's failure to take control of the airplane and abort the takeoff.NTSB ERA14FA350Accident · 2 fatalField investigationFinal reportWilderoder Great Lakes 2TIA · Lillian, ALA loss of engine power due to an inoperative magneto and possible carburetor ice, which resulted in a forced landing into unsuitable terrain. Contributing to the accident was an inadequate magneto overhaul by unknown personnel and the modification to the…NTSB ERA14CA352Accident · No injuriesData collectionFinal reportCessna 172M · Chatham, MAThe pilot's failure to maintain directional control during takeoff, resulting in a runway excursion and collision with trees.NTSB WPR14FA302Accident · 2 fatalField investigationFinal reportCessna 172K · Littlefield, AZThe pilot's failure to maintain airplane control when the airplane encountered high gusting wind while conducting low altitude flight in a narrow canyon, which resulted in an inflight collision with terrain.NTSB WPR14CA342Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll in variable wind conditions, resulting in a ground-loop.NTSB ERA14LA346Accident · 1 fatalLimited investigationFinal reportCessna 172N · Elliott Key, FLThe airplane’s vertical descent into water for reasons that could not be determined because postaccident airplane examinations revealed no mechanical anomalies.NTSB CEN14CA378Accident · Serious injuriesData collectionFinal reportPiper PA 28-140 · Fort Worth, TXThe pilot's improper recovery from a bounced landing. Contributing to the accident was the deer on the runway and the pilot's mismanagement of airspeed which resulted in an aerodynamic stall.NTSB ANC14LA055Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palmer, AKThe pilot’s inadvertent application of excessive brake pressure during landing on a rough surface, which resulted in a nose-over.NTSB CEN14CA383Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · St. Louis, MOThe pilot's decision to operate an airplane with a known deficiency and to not properly secure the airplane before hand-starting the engine.NTSB ERA14CA354Accident · No injuriesData collectionFinal reportCessna 172P · Hagerstown, MDThe student pilot's improper landing flare.NTSB CEN14LA374Accident · No injuriesLimited investigationFinal reportCessna 172N · Rockville, INA partial loss of engine power due to a failure of the dual magneto system. Contributing to the accident was the improper maintenance of the duel magneto system.NTSB CEN14CA457Accident · No injuriesData collectionFinal reportCessna 172N · Murphysboro, ILA hard landing by person(s) unknown.NTSB CEN14LA361Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Monte Vista, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around following impact with a barley crop, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s…NTSB WPR14CA289Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Chandler, AZThe pilot's failure to maintain directional control during the landing roll.