NTSB investigations: Lycoming IO-320 series
889 cases on aircraft whose registry engine model is Lycoming IO-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 ('41509'))
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 ('41509'))
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 NYC08LA207Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Pawtucket, RIBoth pilots' failure to see and avoid the other airplane. Contributing to the accident was the air traffic controllers failure to notify either pilot of the potential conflict.NTSB DFW08CA141Accident · No injuriesData collectionFinal reportPiper PA-30 · Houston, TXThe pilot's loss of directional control during the landing. A contributing factor was the flight instructor's delayed remedial action.NTSB MIA08CA095Accident · No injuriesData collectionFinal reportChampion 7KCAB · Alexander City, ALThe separation of the right tail wheel spring on landing roll out for undetermined reasons, resulting in a loss of directional control and collision with a ditch.NTSB LAX08LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Holbrook, AZA total loss of engine power due to fuel starvation as a result of the pilot's fuel system mismanagement and incorrect positioning of the fuel selector valves.NTSB NYC08CA105Accident · No injuriesData collectionFinal reportPiper PA-30 · Atlanta, GAThe pilot's failure to maintain directional control during the landing roll.NTSB DFW08CA069Accident · No injuriesData collectionFinal reportPiper J3C-65 · Shallowater, TXFailure of the pilot to maintain a safe clearance from the terrain while manuevering for the landing surface.NTSB SEA08LA048Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bridger, MTThe landing gear collapsed during landing for undetermined reasons.NTSB NYC08FA054Accident · 2 fatalField investigationFinal reportPiper PA-30 · Parkland, FLBoth pilots' failure to see and avoid the other airplane. Contributing to the accident were the erroneous readouts from the Cessna's altitude encoder.NTSB CHI08CA036Accident · No injuriesData collectionFinal reportPiper PA-30 · Lonoke, ARThe pilot's misjudgment of the landing flare resulting in a hard landing.NTSB MIA07LA152Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Milton, FLThe failure of the pilot to attain the proper touchdown point during the precautionary landing resulting in the on-ground collision with fence posts.NTSB NYC07CA216Accident · No injuriesData collectionFinal reportPiper PA28-161 · William-Sodus, NYThe pilot's improper flare at touchdown, which resulted in a hard landing.NTSB DEN07LA160Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lawrence, KSTotal failure of the landing gear retraction/extension assembly. Contributing factors in this accident were worn parts in the landing gear retraction/extension assembly, and mechanical binding of the extension assembly.NTSB DEN07WA147Accident · 2 fatalForeign investigationPiper PA-39 · Vannes, FranceNTSB MIA07FA117Accident · 2 fatalField investigationFinal reportPiper PA-30 · Nichols, FLFailure of the flight crew to maintain minimal controllable airspeed following a total loss of power in the right engine.NTSB SEA07LA190Accident · Serious injuriesLimited investigationFinal reportChampion 7KCAB · Orangeburg, SCThe pilot's failure to maintain airspeed during go-around which resulted in a stall. The tailwind was a factor.NTSB DEN07CA103Accident · No injuriesData collectionFinal reportPiper PA-30 · Highgate, VTThe pilot's failure to maintain airspeed on approach resulting in the stall and subsequent impact with terrain.NTSB ANC07CA030Accident · No injuriesData collectionFinal reportPiper PA-22 · Soldotna, AKThe pilot's failure to compensate for a crosswind during the landing roll, which resulted in a loss of control, an encounter with a muddy berm, and a nose over. A factor in the accident was a crosswind.NTSB NYC07FA091Accident · 3 fatalField investigationFinal reportPiper PA-30 · Trappe, MDThe pilot's improper decision to fly into an area of thunderstorms, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was the thunderstorm.NTSB LAX07LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Paris, IDa loss of power in the right engine for undetermined reasons.NTSB SEA07LA059Accident · Minor injuriesLimited investigationFinal reportBarnhart RV-6 · Auburn, WAA loss of engine power due to the obstruction of the engine's air inlet by a fabricated neoprene seal, and inadequate maintenance by unknown maintenance personnel. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DFW07LA075Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lubbock, TXThe pilot's improper landing flare. A contributing factor was the prevailing tailwind.NTSB DEN07WA028Accident · 1 fatalForeign investigationYoakley Glasair · Rieden, GermanyNTSB CHI06CA270Accident · No injuriesData collectionFinal reportDevereux Mustang II · Auburn, INThe failure of the left main landing gear attachment weld which resulted in the pilot's inablility to maintain directional control of the airplane during the landing roll.NTSB NYC06CA221Accident · No injuriesData collectionFinal reportCessna 172P · Baltimore, MDThe pilot's improper flare, which resulted in a hard landing.NTSB NYC06CA195Accident · Minor injuriesData collectionFinal reportChampion 7KCAB · Hyannis, MAThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB CHI06CA237Accident · No injuriesData collectionFinal reportSpittler Rans S-16 · Plattsmouth, NEA loss of engine power due to fuel starvation which resulted from a binding within the fuel servo. A factor associated with the accident was the high vegetation that was encountered during the forced landing.NTSB DEN06FA107Accident · 2 fatalField investigationFinal reportAmerican Champion 7KCAB · Winter Park, COThe pilot's failure to maintain adequate airspeed to avoid a stall while maneuvering at a low altitude in mountainous terrain. Factors associated with the accident are the pilot's performance of a low altitude flight maneuver, an inadvertent stall/spin, and…NTSB NYC06CA164Accident · Serious injuriesData collectionFinal reportBaker, Timithy Falco F8L · Montgomery, NYThe pilot's inadequate pre-flight inspection, which resulted in a loss of engine power due to fuel contamination.NTSB ATL06LA079Accident · 1 fatalLimited investigationFinal reportTaylor Skybolt · Sharpsburg, GAThe pilot's loss of control while conducting aerobatic flight. Factors in the accident were the pilot's ostentatious display, and lack of recent and total experience in type of operation.NTSB NYC06LA090Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Norfolk, VAThe pilot's failure to maintain aircraft control during a single-engine go-around. A factor was the partial loss of engine power.NTSB DEN06LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Greeley, COthe pilot's flight into adverse weather conditions, the airframe ice, and the wheels up landing. Factors contributing to the accident were the icing conditions, the frozen landing gear, the frozen alternate gear extension system, and the runway sign.NTSB LAX06FA089Accident · 4 fatalField investigationFinal reportPiper PA-30 · Visalia, CAthe pilot's failure to maintain airspeed during the landing approach, which resulted in a stall and uncontrolled descent. Contributing factors to the accident were the pilot's impairment due to his prolonged use of a highly sedating over-the-counter sleep aid…NTSB LAX06CA086Accident · Minor injuriesData collectionFinal reportBellanca 7KCAB · Fallbrook, CAthe student pilot's inadequate compensation for a crosswind condition and his failure to maintain directional control.NTSB DFW06FA037Accident · 3 fatalField investigationFinal reportPiper PA-30 · Raymond, MSThe pilot's failure to maintain Vmc (velocity minimum control) on initial climb resulting in a loss of control. Contributing factors were the loss of engine power to the right engine and the prevailing gusty wind conditions.NTSB ANC05CA134Accident · No injuriesData collectionFinal reportChampion 7KCAB · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the landing roll. A factor contributing to the accident was a depression/ditch in the landing surface.NTSB SEA05CA183Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Chiloquin, ORThe failure of the left chain link which permits the pilot to control the tailwheel, and the subsequent inability of the pilot to control the airplane during the landing roll.NTSB CHI05FA189Accident · 3 fatalField investigationFinal reportPiper PA-30 · Aurora, MOThe pilot not maintaining adequate airspeed and aircraft control during initial climb, which resulted in an inadvertent stall/spin at a low altitude. A factor to the accident was the pilot operating the airplane over its certified maximum gross weight.NTSB ATL05CA125Accident · No injuriesData collectionFinal reportCessna 172P · Monroeville, ALThe student pilot's failure to maintain directional control and the subsequent collision with the ground during landing.NTSB MIA05CA061Accident · No injuriesData collectionFinal reportCessna 172 · Brooksville, FLThe pilot's improper landing flare which resulted in substantial damage during the subsequent hard landing.NTSB ATL05FA043Accident · 1 fatalField investigationFinal reportPiper PA-30 · Charleston, SCThe pilot's inadequate preflight and mismanagement of the fuel supply, which resulted in fuel exhaustion.NTSB NYC05LA056Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Millville, NJThe flight instructor's failure to lower the landing gear during landing.NTSB CHI05CA041Accident · No injuriesData collectionFinal reportPiper PA-30 · Atlantic, IAThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. The dark night light conditions was a contributing factor.NTSB DFW05FA015Accident · 1 fatalField investigationFinal reportPiper PA-30 · Boise City, OKThe pilot's incapacitation (cardiovascular) resulting in a loss of aircraft control.NTSB NYC04LA221Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Cynthiana, KYThe inoperative left main landing gear brake check valve, which resulted in a loss of directional control during the takeoff.NTSB LAX04LA325Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Auburn, CAa collapse of the landing gear for undetermined reasons.NTSB CHI04CA226Accident · No injuriesData collectionFinal reportDevereux Mustang II · Elkhart, INThe pilot not maintaining directional control during landing roll. A factor was the soft terrain, and the inadequate training in type aircraft.NTSB NYC04LA181Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Farmingdale, NJThe pilot's failure to maintain adequate airspeed which resulted in a stall and collision with wires.NTSB LAX04CA252Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Casa Grande, AZthe pilot misjudged the flare resulting in a bounced landing. Also causal was the pilot's inadequate recovery from the bounced landing resulting in a loss of directional control.NTSB DEN04FA074Accident · 2 fatalField investigationFinal reportPiper PA-30 · Evanston, WYthe pilot's failure to maintain terrain clearance. Contributing factors include snow, low ceiling, icing conditions, and the dark night.NTSB FTW04LA095Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Galveston, TXThe pilot's failure to maintain directional control during the landing roll. A factor was the pilot's failure to evaluate the wind, prior to landing downwind.