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 ERA24LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Medina, OHThe student pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun and subsequent noseover.NTSB ANC24LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA18 · Goose Bay, AKThe pilot's failure to maintain directional control during the landing roll.NTSB ERA24LA336Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Immokalee, FLThe student pilot’s (of the high wing airplane) inadequate visual lookout, which resulted in a ground collision with another airplane while taxiing.NTSB ERA24LA332Accident · No injuriesClass 4 · LimitedFinal reportBucker Jungmann C.A.S.A. 1.131 · Red Hook, NYThe Great Lakes pilot's failure to maintain adequate clearance from the Bucker Jungmann while maneuvering during an air show, which resulted in a midair collision, the inability of the Bucker Jungmann to maintain altitude, and its subsequent forced landing.NTSB ERA24LA311Accident · Serious injuriesClass 3 · LimitedFinal reportChampion 7ECA · Beaufort, NCThe pilot’s inadequate fuel planning and preflight inspection, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB ERA24FA300Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Palm Beach Gardens, FLA loss of engine power for reasons that could not be determined.NTSB ANC24LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Koliganek, AKThe pilot's improper landing flare and an improper recovery from a bounced landing, resulting in a loss of directional control, and a subsequent nose over.NTSB WPR24LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Sunriver, ORThe pilot’s loss of control during landing roll with a gusty tailwind.NTSB WPR24LA229Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · San Diego, CAA failure of the No. 2 cylinder due to fatigue cracking as the result of an undersized fillet radius around the edge of the cylinder head dome.NTSB WPR24LA221Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Running Springs, CAThe pilot’s decision to maneuver the airplane at a low altitude toward rising terrain, which exceeded the climb capability of the airplane.NTSB WPR24LA219Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Oxnard, CAThe student pilot’s failure to maintain directional control during the takeoff roll.NTSB ERA24LA289Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Lewiston Woodville, NCThe obstruction of the engine’s cooling system by foreign object debris (residential-type insulation), which resulted in smoke, an elevated oil temperature, and a subsequent off-airport landing on unsuitable terrain.NTSB ERA24LA271Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Hernando, FLThe improper installation of a cylinder rocker stud by maintenance personnel, which resulted in a partial loss of engine power and subsequent forced landing.NTSB ERA24LA270Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Hernando, FLThe pilot’s inadvertent throttle input during landing which resulted in a runway overrun.NTSB ANC24FA052Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-18-150 · Moose Pass, AKOn June 18, 2024, about 1400 Alaska daylight time, a float-equipped Piper PA-18-150 airplane, N645DT, was substantially damaged when it was involved in an accident near Moose Pass, Alaska. The instructor pilot and the pilot receiving instruction were fatally…NTSB ERA24LA264Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV6 · Townsend, DEAn inadvertent encounter with rough or soft terrain during landing, resulting in a bent nose landing gear leg and subsequent nose over.NTSB CEN24LA222Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Ada, OKThe student pilot’s failure to maintain directional control during landing resulting in a runway excursion and impact with a sign.NTSB CEN24FA215Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Clinton, MIThe flight instructor’s failure to maintain airplane control while maneuvering for a forced landing. Contributing to the accident was the student pilot’s or flight instructor’s inadvertent positioning of the fuel selector valve between the Left Tank and Off…NTSB WPR24LA187Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Garrett, WYThe pilot’s failure to maintain clearance from terrain while conducting low-level altitude operations, following an encounter with wake turbulence.NTSB ERA24LA241Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Terryville, CTA total loss of engine power for undetermined reasons.NTSB ERA24LA243Accident · Minor injuriesClass 4 · LimitedFinal reportEide Turner T-40A · Middleburg, FLThe pilot’s loss of control during climb out, which resulted in a collision with a tree.NTSB ERA24LA232Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172P · Citronelle, ALA total loss of engine power due to fuel starvation as a result of a fuel vent line that was clogged by an insect nest.NTSB CEN24LA200Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Taylor, TXA partial loss of engine power due to an incorrect carburetor air inlet hose, which led to a reduction in air flow to the engine.NTSB ANC24LA041Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Knik, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.NTSB ERA24LA230Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Hope Mills, NCA loss of engine performance due to carbon fouling of three spark plugs that, when combined with the airplane’s high gross weight condition, resulted in a collision with trees and terrain.NTSB ERA24LA225Accident · Minor injuriesClass 4 · LimitedFinal reportNickle C R Acro II · Milford, NJThe pilot’s lack of familiarity with the airplane’s fuel system, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA24LA222Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177 · Selma, ALInsufficient lubrication of the engine’s internal components, which resulted in a total loss of engine power.NTSB ANC24LA034Accident · Minor injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Wellsville, UTThe pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in a nose over.NTSB ANC24LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Afton, WYThe commercial pilot’s failure to maintain directional control of the airplane during takeoff. Contributing was the student pilot’s application of brakes during the takeoff roll and the failure of both pilots to maintain a positive transfer of controls.NTSB WPR24LA147Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Emmett, IDThe pilot’s loss of directional control during landing roll due to a loose tailwheel leaf spring assembly.NTSB CEN24LA196Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · New Century, KSThe inability of the Boeing 75 pilot to anticipate that the Piper would stop earlier on the taxiway which resulted in the on-ground collision.NTSB CEN24LA178Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Midland, TXThe pilot’s failure to maintain airplane control during a go-around in a gusting crosswind, which resulted in an aerodynamic stall and collision with terrain. Contributing to the accident was the pilot’s lack of system knowledge regarding the operation of the…NTSB ANC24LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Anchorage, AKThe student pilot’s failure to maintain directional control during landing.NTSB WPR24LA139Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Olympia, WAThe flight instructor’s delayed action to arrest the descending, left pedal turn while maneuvering for a low-altitude hover with the helicopter near the maximum gross weight limitation, which resulted in an impact with the ground and a dynamic rollover.NTSB CEN24LA174Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · West Chicago, ILThe flight instructor’s failure to maintain control of the airplane during an encounter with wind while holding short of the runway.NTSB ERA24LA204Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Westminster, MDThe pilot’s failure to attain a proper touchdown point during a simulated loss of engine power approach, which resulted in a hard landing short of the runway. Also causal was the flight instructor’s delayed remedial action during the approach and subsequent…NTSB CEN24LA168Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172M · Clearbrook, MNThe pilot’s delayed use of carburetor heat which resulted in the loss of engine power due to carburetor icing.NTSB ANC24LA027Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Marana, AZA total loss of engine power due to a failure of the No. 4 cylinder piston boss.NTSB ERA24LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Stoneville, NCThe student pilot’s improper landing flare, which resulted in a bounced, hard landing.NTSB ERA24LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Shelbyville, TNThe student pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.NTSB ANC24LA101Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Big Lake, AKThe pilot’s failure to maintain clearance from an obstacle during takeoff.NTSB CEN24LA157Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-161 · Montmorenci, INThe pilot’s intentional flight into terrain as an act of suicide.NTSB CEN24LA156Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Monroe, LAThe student pilot’s failure to maintain directional control during the landing roll.NTSB WPR24LA117Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Acton, CAThe pilots inability to fully turn off the carburetor heat which resulted in a reduction of engine power and reduced climb performance. Contributing to the accident was the pilots delayed recovery from the simulated emergency landing.NTSB ERA24LA135Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Homestead, FLA loss of engine power due to carburetor ice as a result of the pilot’s failure to use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB ERA24LA133Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Greensboro, NCThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN24LA131Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Lubbock, TXThe student pilot’s failure to maintain directional control during a touch-and-go.NTSB CEN24LA130Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Oklahoma City, OKThe student pilot’s improper landing flare, which resulted in a bounced landing, aerodynamic stall, and impact with the runway.NTSB CEN24FA125Accident · 2 fatalClass 3 · FieldFinal reportGlobe GC-1B · Afton, MNThe pilot’s failure to maintain airplane control while maneuvering, which resulted in an aerodynamic stall and spin.NTSB WPR24LA099Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-18A 150 · Dallesport, WAThe pilot’s failure to disengage the ignition prior to moving the propeller by hand resulting in the inadvertent starting of the engine.