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 WPR21LA052Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7GCBC · Fallbrook, CAA partial loss of engine power for reasons that could not be determined with the available evidence.NTSB ERA21LA150Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Montgomery, NYThe pilot’s failure to maintain directional control during landing, resulting in a ground loop and structural damage to the airframe.NTSB WPR21LA032Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · Billings, MTThe pilot’s failure to maintain the proper descent glide path while on final approach for reasons that could not be determined from available evidence.NTSB CEN21LA035Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Crystal Beach, TXThe partial loss of engine power for reasons that could not be determined.NTSB CEN21FA026Accident · 2 fatalClass 3 · FieldFinal reportGrumman AA5 · Woodbranch, TXThe pilot’s failure to maintain control of the airplane due to spatial disorientation.NTSB WPR21LA024Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8KCAB · Rock Springs, WYThe separation of the control grip which resulted in the pilot’s inability to maintain directional control during takeoff, and collision with terrain.NTSB CEN21LA031Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Buda, TXAn improperly torqued oil line fitting during an engine overhaul, which resulted in oil exhaustion and a total loss of engine power.NTSB WPR21LA017Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Puyallup, WAA partial loss of engine power as a result of carburetor icing and the flight instructors failure to use carburetor heat.NTSB CEN21LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Beloit, OHThe pilot’s inadequate preflight inspection and inflight planning that resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA21LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Williston, FLThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA21LA013Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA18 · Plymouth, MAThe pilot’s failure to maintain directional control during the landing roll with a quartering gusting headwind.NTSB ERA21LA006Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Fulton, NYThe mechanic’s improper maintenance, which resulted in the crankshaft expansion plug dislodging in flight and a subsequent forced landing.NTSB CEN21LA003Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Hinckley, MNThe airplane’s impact with deer while landing.NTSB WPR20LA332Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Oregon City, ORThe pilot’s improper landing flare which resulted in a bounced landing, loss of directional control and subsequent collision with a hangar.NTSB CEN20LA431Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Big Rapids, MIThe airplane’s impact with a deer during takeoff.NTSB CEN20LA425Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Spring, TXThe student pilot’s failure to maintain airplane control during climb and subsequent impact with terrain.NTSB ERA20LA335Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Union, SCA total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s failure to use carburetor heat in conditions conducive to the development of carburetor icing.NTSB ERA20LA336Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · La Grange, NCThe pilot’s failure to maintain directional control during final approach, which resulted in a collision with trees.NTSB ERA20LA332Accident · No injuriesClass 3 · LimitedFinal reportGlasair 1RG · Hagerstown, MDThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA20LA330Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA25 · Floral City, FLThe pilot’s failure to see and avoid a tree while flying towards the rising sun during an aerial application flight, which resulted in a collision with the tree and a subsequent loss of airplane control.NTSB ERA20LA344Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Laconia, NHThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapsing.NTSB CEN20CA405Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Huntley, ILThe pilot’s decision to land at night without runway lighting, which resulted in a collision with an object.NTSB ANC20CA097Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Arctic Village, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a rock damaging the empennage.NTSB WPR20LA330Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Stanley, IDThe pilot's failure to maintain terrain clearance after flying into the wrong canyon in mountainous terrain which resulted in a collision with trees and terrain.NTSB ERA20LA315Accident · 2 fatalClass 3 · LimitedFinal reportVans RV9 · Steinhatchee, FLThe failure of the air traffic controller to provide hazardous weather information to the pilot, resulting in the flight’s encounter with strong updraft conditions, an inflight loss of airplane control, and an in-flight breakup. Contributing was the pilot’s…NTSB CEN20LA392Accident · 3 fatalClass 3 · LimitedFinal reportCessna 172 · Cottage Grove, MNA steep descent and impact with terrain for reasons that could not be determined based on the available information.NTSB ANC20CA096Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Chitina, AKThe pilot’s loss of directional control during takeoff, which resulted in a runway excursion.NTSB ERA20LA316Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Melbourne, FLA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR20CA300Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 172 · Stuart Island, WAThe pilot’s improper approach airspeed and landing flare, which resulted in a hard, bounced landing and nose over.NTSB ERA20CA318Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Wilmington, DEThe student pilot’s improper landing flare, which resulted in a hard bounced landing.NTSB ERA20LA310Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Fort Myers, FLForeign object damage of the turning tailrotor by a soft-bodied object, which resulted in the sudden stoppage of the tailrotor and the catastrophic failure of the tailrotor assembly and its mount structure.NTSB CEN20LA385Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28-140 · Red Oak, IAThe pilot’s improper fuel management, which resulted in fuel exhaustion and a loss of engine power.NTSB ANC20LA086Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA 14 · Wasilla, AKThe pilot’s failure to maintain airplane control during an attempted go-around in gusting wind conditions, which resulted in impact with trees.NTSB ERA20LA299Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Weston, FLA total loss of engine power due to the failure of the Nos. 1 and 3 connecting rods from lack of lubrication.NTSB WPR20CA287Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Tok, AKThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with trees.NTSB ANC20CA087Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Lake Louise, AKThe pilot’s decision to takeoff in shifting winds from a remote unimproved gravel bar, which resulted in a failure to attain an airspeed suitable for flight and a loss of control.NTSB CEN20CA359Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Corsicana, TXThe student pilot did not maintain control of the airplane during the takeoff roll.NTSB CEN20LA343Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA18 · Brandon, MNThe partial loss of engine power during takeoff due to carburetor icing.NTSB WPR20LA278Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Harlowton, MTThe pilot’s failure to follow the appropriate takeoff procedures, which resulted in a collision with terrain.NTSB CEN20LA329Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Burlington, WIA partial loss of engine power due to the formation of carburetor ice while on the ground, which resulted in reduced climb capability and impact with trees during the initial climb.NTSB CEN20CA340Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Englewood, COThe student pilot misjudged the landing flare which resulted in a loss of control and a hard bounced landing.NTSB ANC20CA076Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Wasilla, AKThe pilot's failure to maintain directional control during takeoff in crosswind conditions, which resulted in a runway excursion and collision with trees.NTSB CEN20CA351Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Conway, ARThe pilot’s improper recovery from a bounced landing.NTSB ERA20LA271Accident · 1 fatalClass 3 · LimitedFinal reportAmerican AA 5 · Dunnellon, FLA total loss of engine power due to fuel starvation as a result of improper installation and inspection of the airplane’s fuel system. Contributing to the accident was the pilot’s lack of certification and knowledge in aircraft maintenance.NTSB ERA20CA269Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Hudson, NYThe pilot's failure to maintain directional control during the takeoff, which resulted in a runway excursion and impact with vegetation.NTSB ANC20CA075Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Chisana, AKThe pilot's overapplication of brakes during landing in gusting tailwind conditions, which resulted in a nose-over.NTSB CEN20LA305Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · San Antonio, TXThe pilot’s improper decision to take off in an airplane over maximum gross weight and with a tailwind, which prevented the airplane from climbing.NTSB CEN20CA310Accident · Minor injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Angola, INThe pilot's failure to maintain control of the airplane during a low-level pass, resulting in the airplane exceeding its critical angle of attack that caused an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot's…NTSB ERA20CA256Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 172 · Wellington, FLThe pilot’s inadequate compensation for a wind gust during landing.NTSB CEN20LA290Accident · No injuriesClass 3 · LimitedFinal reportPiper PA22 · Loveland, OHThe loss of engine power due to fuel starvation