Final NTSB investigations: Lycoming 0-320 series
14,453 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.\"completionStatus\" = 'Completed'
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."completionStatus" = 'Completed'
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 CEN26LA013Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Chaseley, NDThe pilot’s excessive braking during the landing roll, which resulted in a nose over.NTSB CEN26LA002Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 7GC · Haskell, OKThe pilot’s excessive braking during the landing roll, which resulted in a nose over. Contributing to the accident was the pilot’s lack of experience with the recently installed brakes and tundra tires.NTSB CEN25LA399Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV9 · Stephenville, TXThe pilot’s failure to ensure the canopy and the cockpit were properly secured during the hand prop sequence.NTSB ERA25LA364Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Merritt Island, FLThe pilot’s failure to maintain directional control while landing in a crosswind.NTSB ERA25LA360Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Linden, NJAn in-flight collision with a bird while on approach.NTSB ANC25LA108Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to maintain clearance from an object during takeoff, which resulted in a collision and ground loop. Contributing was the pilot’s selection of an unsuitable takeoff area.NTSB ANC25LA119Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Eagle, AKThe pilot’s failure to maintain clearance from brush during landing.NTSB CEN25LA353Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Pittsfield, ILThe collision with a deer during the aborted landing in night visual meteorological conditions.NTSB CEN25LA355Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Lubbock, TXThe pilot’s mismanagement of available fuel, which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA332Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Air Force Academy, COThe student pilot’s failure to perform an adequate preflight inspection.NTSB ANC25LA087Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Homer, AKThe failure of the left main landing gear mount due to extensive corrosion while landing in an area of rough terrain.NTSB CEN25LA322Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18-150 · Joliet, ILThe failure of the No. 2 cylinder exhaust valve, which resulted in a total loss of engine power.NTSB WPR25LA243Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Ronan, MTThe student pilot's inadequate landing flare and recovery from a bounced landing.NTSB CEN25LA284Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · New Hudson, MIThe student pilot’s improper landing flare and the flight instructor’s delayed remedial action during landing that resulted in a loss of control and impact with terrain.NTSB CEN25LA256Accident · Minor injuriesClass 4 · LimitedFinal reportFarrington Twinstar · Greencastle, INThe pilot’s failure to maintain pitch control during takeoff. Contributing to the accident was the pilot’s inexperience in the accident gyroplane.NTSB ANC25LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Dillingham, AKThe pilot’s failure to maintain direction control during takeoff roll which resulted in a ground loop, and subsequent runway excursion.NTSB CEN25LA241Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Jenison, MIThe pilot’s failure to maintain airplane control and clearance from trees during takeoff.NTSB WPR25LA206Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Page, AZThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB CEN25LA236Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Meeker, COThe student pilot’s failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB WPR25LA194Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Helena, MTThe pilot’s failure to maintain directional control of the airplane during landing.NTSB CEN25LA230Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Wichita, KSThe student pilot’s failure to maintain directional control during the takeoff that resulted in a runway excursion.NTSB ANC25LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Chenega, AKThe pilot’s failure to maintain directional control during landing in gusting and variable wind conditions.NTSB CEN25LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brookshire, TXThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapsing.NTSB ERA25LA223Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Hebron, OHThe airplane owner and pilot’s intentional allowance of unapproved maintenance and maintenance personnel’s failure to adequately maintain or service the brake system, which resulted in a total loss of brake pressure.NTSB ERA25LA217Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-23 · Palm Bay, FLA loss of engine power to both of the airplane’s engines due to fuel exhaustion and fuel starvation.NTSB ANC25LA071Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Willow, AKThe flight instructor’s delayed remedial action/lack of supervision. Contributing to the accident was the pilot receiving instructions failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a ground loop.NTSB WPR25LA162Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Monroe, WAThe student pilot’s failure to maintain airplane control during landing, and the flight instructor’s delayed remedial action, which resulted in impact with a ditch.NTSB ERA25LA213Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Murfreesboro, TNThe pilot’s failure to maintain directional control of the airplane while attempting to take off in a gusty crosswind, which resulted in a runway excursion.NTSB CEN25LA168Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Longmont, COThe disconnected throttle control that resulted in a loss of engine power due to improper maintenance.NTSB ERA25LA194Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Hastings, FLThe pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR25LA143Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Lakeview, ORThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA25LA189Accident · No injuriesClass 3 · LimitedFinal reportChampion 7GCBC · Weyers Cave, VAA total loss of engine power on approach due to carburetor ice.NTSB WPR25LA142Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · West Jordan, UTThe pilot's failure to maintain directional control during takeoff. Contributing to the accident was the pilot inadvertently using a runway that resulted in a tailwind condition and the flight instructors delayed remedial action.NTSB ANC25LA033Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Bethel, AKThe pilot's delayed decision to abort the takeoff when the airplane was not attaining sufficient airspeed for takeoff and subsequently departed the end of the lake and collided with terrain.NTSB CEN25LA146Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Ault, COThe flight instructor’s failure to maintain terrain clearance during an attempted go-around, which resulted in a collision with a fence post.NTSB ERA25LA164Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Hickory, NCThe student pilot’s failure to maintain airplane control during an attempted go-around, which resulted in an aerodynamic stall/spin and collision with terrain.NTSB ERA25LA207Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Winter Haven, FLThe pilot’s inadvertent movement of the fuel selector to a position that restricted fuel flow to the engine, which resulted in the loss of engine power during takeoff.NTSB ANC25LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Manley Hot Springs, AKThe student pilot’s failure to maintain directional control during the landing roll on a snow and ice-covered runway, which resulted in a runway excursion and subsequent nose over.NTSB ANC25LA028Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Royal Kunia, HIImproper alteration of the crankshaft propeller flange at an unknown time, which resulted in an in-flight separation of the propeller assembly.NTSB WPR25LA121Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Tracy, CAThe pilot's failure to maintain directional control during the landing roll.NTSB ANC25LA023Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Cantwell, AKThe pilot’s failure to maintain altitude during a low-altitude maneuver which resulted in inadvertent ground contact and a nose over.NTSB CEN25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Romeo, MIThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the soft, wet grass.NTSB CEN25LA111Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Pearland, TXBoth pilots’ failure to follow emergency procedures pertaining to the partial loss of engine power by either applying carburetor heat to address the carburetor icing or to abort the takeoff when they observed a partial loss of engine power during the takeoff…NTSB ERA25LA138Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Knoxville, TNThe student pilot’s failure to maintain clearance from a truck while taxiing.NTSB ANC25LA024Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to maintain an appropriate airspeed during the landing approach, which resulted in exceedance of the critical angle of attack and an aerodynamic stall, during gusting wind conditions.NTSB ANC25LA022Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Anchor Point, AKA complete loss of engine power as a result of carburetor ice due to the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB ERA25LA127Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Mayo, MDA total loss of engine power at low altitude due to an accumulation of carburetor ice while in a cruise-power descent, which resulted in a forced landing.NTSB ANC25LA020Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Kapolei, HIThe flight instructor’s failure to avoid wake turbulence from a heavy airplane departing from a parallel runway, which resulted in a loss of airplane control during initial climb after a touch-and-go landing.NTSB CEN25LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Pearland, TXThe pilot’s poor flight planning and decision making, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Rock Hill, SCThe student pilot’s failure to maintain control of the airplane during an aborded crosswind landing.