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.

NTSB DEN00LA013Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Grand Junction, COA failure of the left main landing gear attachment (u-bolt) due to fatigue.Oct 27, 1999 · N8707V · Substantial damageNTSB CHI99LA345Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Troy, MOthe failure of the pilot to maintain directional control during landing. Factors in the accident were the proper alignment not attained by the pilot and the trees.Sep 18, 1999 · N53895 · Substantial damageNTSB FTW99FA222Accident · 1 fatalField investigationFinal reportPiper PA30 · Holdenville, OKthe pilot's failure to maintain aircraft control during takeoff initial climb. Factors were the loss of right engine power for undetermined reasons, and the pilot's lack of total experience in the make and model of aircraft.Aug 16, 1999 · N7178Y · DestroyedNTSB FTW99LA154Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Mcalester, OKThe pilot inadvertently stalling the airplane while attempting to avoid power lines. Factors were the loss of power on both the left and right engines as a result of water contamination in the fuel system, the pilot's inadequate preflight procedures, and the…May 28, 1999 · N7991Y · Substantial damageNTSB FTW99LA145Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Lufkin, TXThe loss of control due to the separation of the left main landing gear as a result of the fatigue failure of the U-bolt which attaches the landing gear to the airframe.May 21, 1999 · N5500C · Substantial damageNTSB ATL99LA091Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Brooksville, FLThe certified flight instructor's failure to recover from a porpoise during landing and his failure to maintain directional control.May 15, 1999 · N8055Y · Substantial damageNTSB MIA99LA074Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Crystal River, FLThe failure of the pilot to maintain directional control during takeoff and his failure to abort the takeoff after directional control was lost.Feb 3, 1999 · N68573 · Substantial damageNTSB IAD99LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Fairfield, VAThe owner's failure to comply with the Airworthiness Directive and the subsequent fuel system filter blockage by ice leading to fuel starvation and power loss of the right engine. Additionally, the pilot's improper selection of the left auxiliary fuel tank…Jan 5, 1999 · N3TH · DestroyedNTSB IAD98LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Dayton, OHthe pilot's inadequate recovery from a bounced landing.Aug 30, 1998 · N8349Y · Substantial damageNTSB ATL98LA118Accident · No injuriesLimited investigationFinal reportPiper PA-30-39 · Greenville, NCA loose wiring connection at the landing gear motor relay that prevented the electrical extension of the landing gear.Aug 20, 1998 · N7298Y · Substantial damageNTSB FTW98LA312Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Watkins, COThe pilot misjudged his altitude. Contributing to the accident were unfavorable wind and dark night conditions.Jul 16, 1998 · N444BP · Substantial damageNTSB SEA98LA085Accident · 1 fatalLimited investigationFinal reportPiper PA-30 · Everett, WAThe pilot-in-command's exiting the aircraft with both engines running to remove a wheel chock. A factor was the inadequate preflight of the aircraft (not removing the chock) prior to engine start.Jun 4, 1998 · N98NT · Minor damageNTSB IAD98LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Floyd, VAThe pilot's improper selection of fuel tank position resulting in fuel starvation of both engines.Jun 1, 1998 · N7794Y · DestroyedNTSB FTW98LA094Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Leadville, COThe failure of the pilot to maintain directional control of the airplane. Factors were a sudden windshift from a headwind to a quartering tailwind, and the snowbank.Jan 10, 1998 · N5275X · Substantial damageNTSB CHI98LA072Accident · 1 fatalLimited investigationFinal reportPiper PA-30/A · Hastings, NEThe pilot's improper IFR procedure, by which he failed to maintain minimum descent altitude. Fog, a low ceiling, and night condition were a contributing factor.Dec 24, 1997 · N9WG · DestroyedNTSB FTW97LA368Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Englewood, COfailure of the right main landing gear due to multiple fatigue cracks.Sep 19, 1997 · N88314 · Substantial damageNTSB LAX97LA310Accident · No injuriesLimited investigationFinal reportBingelis Falco F.8L · Watsonville, CAthe pilot's misjudgment of distance and speed on final approach, leading to a landing undershoot.Sep 4, 1997 · N84TX · Substantial damageNTSB CHI97LA247Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Hampshire, ILthe pilot's failure to maintain directional control of the airplane during landing, and his excessive use of brakes, which resulted in a nose over. Factors relating to the accident were: the crosswind condition, and the pilot's lack of experience in the make…Aug 5, 1997 · N5066X · Substantial damageNTSB MIA97LA080Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sarasota, FLthe pilot's failure to maintain clearance from obstacles.Feb 1, 1997 · N64TD · Substantial damageNTSB MIA97FA049Accident · 1 fatalField investigationFinal reportPiper PA-30 · Goldsboro, NCThe pilot's failure to follow instrument approach procedures during numerous instrument approaches and missed approaches which resuled in a total loss of engine power on both engines due to fuel exhaustion. Factors contributing to the accident were: the…Dec 28, 1996 · N8220Y · DestroyedNTSB ATL97LA018Accident · No injuriesLimited investigationFinal reportPiper PA-30-160 · Cartersville, GAthe flight instructor's (CFI's) inadequate supervision by failing to ensure that directional control of the aircraft was maintained, during a simulated engine failure. The student pilot's delay in performing the appropriate single-engine emergency procedure…Nov 11, 1996 · N7392Y · Substantial damageNTSB ANC96LA155Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Skwentna, AKthe pilot's improper planning/decision. Related factors were: the terrain condition, unfavorable (lee-side) wind, and trees.Sep 15, 1996 · N9033L · Substantial damageNTSB IAD96LA137Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Waterford, OHthe pilot's decision to abruptly maneuver the airplane with insufficient altitude to recover.Aug 18, 1996 · N88428 · Substantial damageNTSB CHI96FA278Accident · 1 fatalField investigationFinal reportLancair 320 · Fond Du Lac, WIthe fatigue in the propeller flange with soft material and oversized lightening holes. A factor was the pilot's inability to maintain control of the aircraft due to the exceeded weight and balance which led to a stall/spin.Aug 8, 1996 · N320L · DestroyedNTSB LAX96FA290Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Mound House, NVthe flight instructor's improper in-flight planning/decision by allowing the student pilot to get too low during a simulated emergency landing before initiating a go-around.Jul 25, 1996 · N57438 · DestroyedNTSB CHI96LA253Accident · No injuriesLimited investigationFinal reportYasecko LONG-EZE · Waukesha, WIFailure of the throttle cable.Jul 24, 1996 · N303Y · Substantial damageNTSB SEA96FA133Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Pomeroy, WAThe pilot's failure to maintain adequate clearance with the surrounding terrain while maneuvering to land. A factor was the rising terrain conditions.Jun 21, 1996 · N57514 · DestroyedNTSB NYC96LA069Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · South Wales, NYthe pilot's improper flare and failure to maintain directional control during landing.Mar 1, 1996 · N7807S · Substantial damageNTSB LAX96LA102Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Hilo, HIInadequate supervision of the student pilot by the flight instructor during an attempted go-around from a balked landing, which resulted in a loss of directional control and collision with a distance remaining marker.Jan 28, 1996 · N7358Y · Substantial damageNTSB ANC95LA155Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Big Lake, AKThe pilot's failure to maintain a proper rate of descent during the approach to land, and his misjudgment of altitude to flare for landing on glassy water. The glassy water condition was a related factor.Sep 2, 1995 · N9033L · Substantial damageNTSB SEA95LA142Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Island Park, IDThe pilot's inadequate compensation for wind conditions. A factor to the accident was wind gusts.Jul 6, 1995 · N7487Y · Substantial damageNTSB MIA95LA149Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Miami, FLTotal blockage of the air induction at the servo fuel injector by paper from an undetermined source and inadequate maintenance servicing by other maintenance personnel. Contributing to the accident was unsuitable terrain encountered by the pilot during the…Jun 11, 1995 · N7631S · Substantial damageNTSB FTW95FA232Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Joaquin, TXThe performance of aerobatics at low altitude and the inadvertent stall.Jun 7, 1995 · N8754 · DestroyedNTSB MIA95LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Miami, FLThe failure of the truck driver to follow airport operations procedures and signs.Feb 11, 1995 · N8778Y · Substantial damageNTSB FTW94LA322Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Frederick, COA fatigue failure of the left main landing gear axle.Sep 28, 1994 · N53844 · Substantial damageNTSB BFO94LA124Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sandy Hook, NJThe loss of engine power for reasons undetermined and the inability of the pilot to feather the propeller.Jun 30, 1994 · N7041Y · DestroyedNTSB CHI94DCA01Accident · 1 fatalFinal reportPiper PA-39 · Viburnum, MOThe pilot's failure to maintain adequate airspeed during the turn to final. The gusty tailwind during the turn was a contributing factor.Feb 18, 1994 · N8913Y · DestroyedNTSB LAX94FA047Accident · 1 fatalField investigationFinal reportPiper PA-30 · Brea, CAThe pilot's choice of an inadequate cruise altitude over rolling hill terrain which resulted in an in-flight collision with helium balloons and an in-flight loss of control for undetermined reasons. A factor in the accident was the pilot's inadequate visual…Nov 15, 1993 · N8238Y · DestroyedNTSB LAX93LA291Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Thermal, CAthe pilot's inadvertent movement of the landing gear selector switch to the up position. A factor in the accident was the difference in cockpit switch layout between the PA23 and PA39 aircraft.Jul 17, 1993 · N8975Y · Substantial damageNTSB NYC93LA132Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Mitchellville, MDThe failure of the pilot to maintain a proper glide path during the final approach, which resulted in the airplane striking a moving vehicle.Jun 27, 1993 · N7563Y · Substantial damageNTSB LAX93LA237Accident · Minor injuriesLimited investigationFinal reportSchmidt JURCA-MJ55 · Bakersfield, CALoss of engine power for undetermined reasons.Jun 2, 1993 · N5045 · Substantial damageNTSB ATL93LA049Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Crossville, TNThe pilot's failure to follow checklist procedures in that he did not utilize the alternate gear extension method when electrical power was lost. A factor was his failure to follow the checklist when he failed to turn on the generators prior to flight, which…Jan 2, 1993 · N7712Y · Substantial damageNTSB DEN93LA014Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Boulder, COUndetermined.Dec 2, 1992 · N2751G · Substantial damageNTSB CHI92DCA04Accident · Serious injuriesFinal reportTinsman RV6 · Foristell, MOThe partial failure of the fuel injection system. Factors related to the accident are the pilot's insufficient altitude to reach the runway from the downwind leg, and the presence of transmission wires in the off airport landing site.Sep 13, 1992 · N42JT · Substantial damageNTSB BFO92LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-30K · Schaghticoke, NYThe loss of total engine power due to fuel starvation. Contributing to the accident was the loss of total electrical power.Sep 7, 1992 · N400RD · Substantial damageNTSB NYC92LA112Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Indian Head, MDThe pilot improperly compensated for the wind conditions and lost control of the airplane after touchdown which resulted in the airplane departing the runway. An additional cause of the accident was, the delayed remedial action on the part of the flight…Jun 13, 1992 · N7958Y · Substantial damageNTSB LAX92LA099Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Pacoima, CAThe pilot's improper preflight and delay in aborting the takeoff. Contributing to this accident was the unlocked nose baggage door.Jan 23, 1992 · N8662Y · Substantial damageNTSB DEN92LA019Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Aurora, COThe pilot failed to maintain control of the aircraft. A factor was: improper supervision by the flight instructor.Dec 24, 1991 · N53883 · Substantial damageNTSB ATL92LA001Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Cartersville, GAThe failure of the pilot to maintain control of the aircraft during the landing roll and the improper remedial action taken by the pilot to regain control of the airplane.Oct 3, 1991 · N5282X · Substantial damageNTSB DEN91FA126Accident · 1 fatalField investigationFinal reportPiper PA-30 · Ft. Carson, COThe loss of power to both engines due first to fuel starvation followed by fuel exhaustion, the pilot's failure to refuel, and the inadvertent stall. A factor was: the pilot's improper use of powerplant controls.Sep 11, 1991 · N7730Y · Destroyed