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 GAA16CA371Accident · No injuriesData collectionFinal reportCessna 172 · San Diego, CAThe pilot's failure to maintain situational awareness while taxiing, which resulted in an impact with a stationary fuel truck.NTSB CEN16LA256Accident · No injuriesLimited investigationFinal reportGulfstream American AA 5 · Cheyenne, WYThe airplane’s encounter with low-level wind shear during takeoff, which resulted in an off-airport landing.NTSB CEN16LA246Accident · No injuriesLimited investigationFinal reportCessna 172 · Wonder Lake, ILThe flight instructor's inadequate supervision and lack of remedial action due to his diverted attention to a radio call, which resulted in the airplane landing short of the runway.NTSB GAA16CA360Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during the landing flare, which resulted in a runway excursion, and impact with a sign.NTSB GAA16CA357Accident · Minor injuriesData collectionFinal reportBeech 23 · Maryville, MOThe pilot's failure to see and avoid power lines on approach during landing, resulting a power line strike, uncontrolled descent, and collision with terrain. Contributing to the accident was the pilot's inadequate pre-flight planning.NTSB ERA16CA239Accident · Serious injuriesData collectionFinal reportPiper PA 22-160 · Harrisonburg, VAThe pilot's loss of directional control during takeoff in gusting crosswind conditions.NTSB CEN16LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Houghton Lake Heights, MIThe pilot's delayed reaction to the variable wind condition, which resulted in an excessive descent rate and the airplane's subsequent collision with a wire fence short of the runway.NTSB GAA16CA358Accident · No injuriesData collectionFinal reportCessna 172 · Bountiful, UTThe pilot's decision to fly into a canyon without sufficient room to reverse course if necessary, which resulted in an emergency landing, loss of directional control, collision with terrain, and a post-crash fire.NTSB GAA16CA359Accident · No injuriesData collectionFinal reportPiper PA28 · Amarillo, TXThe pilot's failure to attain an adequate rate of climb, which resulted in off airport landing and substantial damage to the fuselage and right wing.NTSB GAA16LA352Accident · No injuriesLimited investigationFinal reportPiper PA 28 · Merritt Island, FLA total loss of engine power during the landing roll, and an engine fire during a subsequent engine restart attempt. Neither the cause for the loss of engine power nor the source of the fire could be determined because the airplane was not made available for…NTSB ERA16CA237Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Honesdale, PAThe pilot's inadequate preflight planning, which resulted in his attempt to take off near the airplane’s maximum gross weight in high-density altitude conditions that degraded the airplane’s takeoff and climb performance and resulted in an aborted takeoff and…NTSB GAA16CA346Accident · No injuriesData collectionFinal reportCessna 172 · Flushing, MIThe collision with a deer during touchdown of a night landing, which resulted in substantial damage to the horizontal stabilizer and elevator of the airplane.NTSB ERA16LA231Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Hollywood, FLA partial loss of engine power during the initial climb for undetermined reasons.NTSB GAA16CA333Accident · Minor injuriesData collectionFinal reportCessna 172 · Anthony, NMThe pilot's failure to maintain clearance from a cable while maneuvering at a low altitude over water, which resulted in a collision with a cable and impact with water.NTSB ERA16LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Hollywood, FLThe pilot’s inadequate preflight inspection of the fuel system, which resulted in a total loss of engine power due to water contamination.NTSB ERA16LA224Accident · No injuriesLimited investigationFinal reportCessna 172P · Honesdale, PAThe pilot's failure to maintain adequate airspeed while departing in a heavily loaded airplane at high density altitude, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall, landing hard, and overrunning…NTSB WPR16FA126Accident · 1 fatalField investigationFinal reportPiper PA 23-150 · Hayward, CAThe failure of the left engine due to water contamination and the pilot's subsequent failure to maintain single-engine minimum control airspeed, which resulted in an uncontrolled descent. Contributing to the accident was the pilot's lack of total and recent…NTSB ERA16CA222Accident · No injuriesData collectionFinal reportCessna 172M · Lenoir, NCThe student pilot’s failure to compensate for gusting wind conditions during landing, which resulted in a bounced landing. Contributing to the accident was the flight instructor’s inadequate review of the weather conditions with the student and his inadequate…NTSB GAA16CA312Accident · No injuriesData collectionFinal reportPiper PA 28 · Gilmer, TXThe student pilot's failure to see and avoid powerlines during landing, and the flight instructor's delayed remediation when the student cut the base to final turn short, resulting in a wire strike and collision with terrain. Contributing to the accident was…NTSB GAA16CA306Accident · Minor injuriesData collectionFinal reportS.O.C.A.T.A. Rallye 150 · York, SCThe pilot's failure to maintain directional control during takeoff, which resulted in an impact with a peach tree(s).NTSB GAA16CA305Accident · Minor injuriesData collectionFinal reportCessna 172 · Pasco, WAThe flight instructor's failure to maintain pitch control during the simulated engine failure after takeoff, which resulted in a hard landing, landing gear(s) collapse, and wing damage.NTSB CEN16FA212Accident · 3 fatalField investigationFinal reportPiper PA 28-140 · Wishek, NDThe pilot's failure to maintain adequate airspeed during a climbing turn after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's self-induced pressure to…NTSB GAA16CA301Accident · No injuriesData collectionFinal reportCessna 172 · Urbana, OHThe pilot's abnormal runway contact during the landing flare, which resulted in a porpoise, hard landing, and runway excursion.NTSB GAA16CA284Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Ferndale, MTThe pilot's loss of directional control during takeoff resulting in a decision to rotate early, and a collision with a hangar and subsequent fire.NTSB GAA16CA340Accident · No injuriesData collectionFinal reportCessna 172 · Lumberton, NJThe pilot's hard landing, resulting in a runway excursion and substantial damage to the firewall.NTSB GAA16CA265Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Laurel, MTThe pilot's loss of directional control during the landing touchdown, resulting in a runway excursion and substantial damage to the both wings.NTSB ERA16CA197Accident · Serious injuriesData collectionFinal reportAmerican Champion 7GCBC · Warner, NHAn encounter with instrument meteorological conditions, which resulted in the pilot's spatial disorientation and a loss of airplane control.NTSB CEN16LA202Accident · No injuriesLimited investigationFinal reportHarry Oas Pitts S1C · Carlsbad, NMThe pilot's failure to maintain directional control while landing in crosswind conditions.NTSB WPR16FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172N · Avalon, CAUndetermined because the airplane was not located.NTSB GAA16CA287Accident · No injuriesData collectionFinal reportPiper PA 18 · Palmer, AKThe pilot's incorrect brake application during the landing roll, which resulted in a nose over.NTSB CEN16LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · Cozad, NEAn in-flight loss of control for reasons that could not be determined because examination of the wreckage did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.NTSB GAA16CA264Accident · No injuriesData collectionFinal reportPiper PA18 · Seward, AKThe pilot receiving instruction's failure to maintain proper airspeed and descent rate, and the flight instructor's delayed remedial action during the landing flare, which resulted in a hard landing and landing gear collapse.NTSB GAA16CA245Accident · No injuriesData collectionFinal reportCessna 172 · Carbondale, ILThe student pilot's inadequate flare which resulted in a hard landing, loss of directional control, and a runway excursion.NTSB ERA16FA186Accident · Serious injuriesField investigationFinal reportPiper PA28 · Homestead, FLThe pilot's improper decision to allow the passenger to attempt a landing, which resulted in a loss of control during landing with a quartering tailwind. Contributing to the severity of the pilot's injuries was the separation of the deteriorated shoulder…NTSB ERA16LA184Accident · Serious injuriesLimited investigationFinal reportGlobe GC 1B · Hedgesville, WVThe pilot's failure to maintain airplane control when it encountered a wind gust during climbout.NTSB WPR16FA103Accident · Serious injuriesField investigationFinal reportPiper PA28 · Pomona, CAThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA16CA220Accident · No injuriesData collectionFinal reportCessna 172 · Richmond, KYThe student pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with tree(s).NTSB ANC16CA025Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · McCarthy, AKThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall from which he could not recover.NTSB GAA16CA202Accident · No injuriesData collectionFinal reportCessna 172 · Camarillo, CAThe student pilot's incorrect pitch control input, resulting in a porpoise during landing and substantial damage to the airplane's firewall.NTSB ANC16FA019Accident · 4 fatalField investigationFinal reportCessna 172 · Chugiak, AKThe in-flight collision with one or more large birds (Bald Eagle), which resulted in a loss of airplane control.NTSB GAA16CA204Accident · No injuriesData collectionFinal reportPiper PA 18 · Palmer, AKThe pilot's decision to land on unsuitable terrain and incorrect brake application during the landing roll, which resulted in a nose over.NTSB ERA16LA164Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Okeechobee, FLThe failure of the No. 3 piston due to fatigue cracking, which resulted in a total loss of engine power and subsequent forced landing, during which the airplane impacted obstacles.NTSB WPR16LA093Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Avalon, CAThe pilot's failure to maintain a proper approach path on landing because he failed to familiarize himself with the airport's unique approach hazards and recommended procedures before the flight. Also causal was the pilot's failure to recognize the airplane's…NTSB ERA16LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · Bayport, NYMaintenance personnel’s improper installation and maintenance of the fuel selector valve, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN16FA145Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Midlothian, TXThe flight instructor's inability to move the control stick after takeoff for undetermined reasons, which resulted in an exceedance of the airplane's critical angle of attack and inadvertent aerodynamic stall. The reason for the inability to move the control…NTSB GAA16CA185Accident · No injuriesData collectionFinal reportPiper PA 22-160 · Palmer, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a runway over-run and collision with trees.NTSB GAA16CA181Accident · No injuriesData collectionFinal reportCessna 172 · Orangeburg, SCThe pilot's failure to maintain directional control during the takeoff, resulting in a runway excursion and a nose over.NTSB WPR16LA090Accident · No injuriesLimited investigationFinal reportCessna 172L · McNeil Island, WAThe student pilot's fuel mismanagement, which led to fuel starvation and a total loss of engine power during cruise flight. Contributing to the accident was his failure to follow the appropriate engine start, before takeoff, and emergency checklists.NTSB ERA16FA141Accident · 1 fatalField investigationFinal reportCessna 172N · Charleston, WVThe flight instructor's failure to ensure that her seat was properly secured before initiating the takeoff, which resulted in a subsequent loss of control. Contributing was the lack of an installed secondary seat stop.NTSB CEN16LA128Accident · Serious injuriesLimited investigationFinal reportGrumman AA5 · Longview, TXThe noninstrument-rated pilot's decision to depart into instrument meteorological conditions, which resulted in a loss of control.