NTSB investigations: Lycoming 0-320 series

107 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the defining event was Collision during takeoff/land. 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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '490'))
  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 GAA18CA575Accident · Serious injuriesData collectionFinal reportPiper PA28 · Spokane, WAThe pilot’s improper retraction of the flaps during a go-around, which resulted in the airplane’s failure to climb and its subsequent collision with trees.Sep 29, 2018 · N40825 · Substantial damageNTSB CEN18LA316Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Wiley, COThe pilot's failure to maintain proper clearance from the sprinkler guy-wire, which resulted in the airplane’s collision with the wire during a visual approach to landing.Aug 5, 2018 · N90990 · Substantial damageNTSB GAA18CA376Accident · No injuriesData collectionFinal reportPiper PA 18 · Cantwell, AKThe pilot's failure to see and avoid a post during a go-around following a landing on unsuitable terrain.Jun 25, 2018 · N249T · Substantial damageNTSB ERA18LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Edgewater, FLThe flight instructor's failure to maintain the appropriate glidepath to the runway, which resulted in a collision with trees and terrain during final approach.Mar 6, 2018 · N6764W · Substantial damageNTSB GAA18CA017Accident · Serious injuriesData collectionFinal reportYoung David E Pitts S1 C · Farmville, VAThe pilot’s failure to see and avoid the other airplane landing in the opposite direction on the runway. Contributing to the accident was the pilot’s failure to use the correct runway call sign in his radio communications.Oct 20, 2017 · N25YD · 2 aircraft · Substantial damageNTSB GAA17CA157Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Weiser, IDThe student pilot’s failure to maintain directional control and to maintain clearance from a snow berm during the aborted landing.Feb 25, 2017 · N4404T · Substantial damageNTSB ANC16CA073Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Soldotna, AKThe pilot’s failure to maintain an adequate glidepath during landing, which resulted in an unintended touchdown before the chosen landing area.Sep 22, 2016 · N5507K · Substantial damageNTSB CEN16FA333Accident · 1 fatalField investigationFinal reportCessna 172N · Terre Haute, INThe pilot's failure to maintain a normal approach path to the runway, which resulted in the airplane colliding with a tree and a house during final approach. Contributing to the accident was the pilot's lack of recent flight experience.Aug 25, 2016 · N17SK · Substantial damageNTSB GAA16CA419Accident · No injuriesData collectionFinal reportCessna 172 · Lewiston, MTThe pilot's failure to ensure that his seat was adjusted and locked, which resulted in his seat sliding aft during the takeoff roll, and the subsequent loss of directional control and runway excursion.Aug 2, 2016 · N734GM · Substantial damageNTSB 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.Jul 2, 2016 · N5788D · Substantial damageNTSB CEN16LA097Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Sturtevant, WIThe pilot's failure to maintain a proper glidepath during a landing at dusk, which resulted in impact with a moving ground vehicle. Contributing to the accident was the inoperative precision approach path indicator.Feb 1, 2016 · N1572J · Substantial damageNTSB GAA16CA011Accident · No injuriesData collectionFinal reportCessna 172M · McMinnville, ORThe flight instructor's failure to correct the student pilot's approach path during the final approach, which resulted in a collision with runway threshold lights. Contributing to the accident was the student pilot's failure to attain and maintain the…Oct 2, 2015 · N20488 · Substantial damageNTSB CEN15LA413Accident · Minor injuriesLimited investigationFinal reportVenus CP328 Super Emeraude · Port Wing, WIThe pilot’s undershooting the landing area and the subsequent impact with a hay bale. Also causal to the accident was the operation of the airplane in conditions conducive to carburetor icing, which reduced the engine power during the landing.Sep 5, 2015 · N328TV · Substantial damageNTSB ANC15CA059Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Beluga, AKThe pilot's decision to land with insufficient obstacle clearance. The pilot's failure to maintain directional control after landing resulting in a collision with terrain.Jul 20, 2015 · N2868P · Substantial damageNTSB ERA14CA407Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Taylorsville, KYThe pilot's decision to land on a wet runway and delayed go-around attempt, which resulted in a collision with terrain.Aug 23, 2014 · N41224 · Substantial damageNTSB ERA14CA172Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Saluda, SCAn inadvertent encounter with a deer during the takeoff roll.Feb 21, 2014 · N6469W · Substantial damageNTSB CEN13CA303Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Livingston, TXThe pilot's delay to not perform a go-around when he lost sight of the runway while on final approach to land at night. Contributing to the accident was the obscuration (tall grass) of the runway edge lights.Apr 14, 2013 · N6784F · Substantial damageNTSB ERA13CA170Accident · No injuriesData collectionFinal reportCessna 172M · Hendersonville, NCThe student pilot’s failure to maintain control of the airplane during an attempted go-around in gusty tailwind conditions.Mar 15, 2013 · N61756 · Substantial damageNTSB ERA12CA585Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Maryville, TNThe pilot’s failure to plan and execute a takeoff that assured obstacle clearance at the departure end of the runway, which resulted in a collision with trees.Sep 22, 2012 · N56796 · Substantial damageNTSB CEN12LA629Accident · No injuriesLimited investigationFinal reportVarga 2150A · Clinton, IAThe pilot of the other airplane failing to adequately monitor for other aircraft while landing.Sep 13, 2012 · N4651V · 2 aircraft · Substantial damageNTSB CEN12LA569Accident · No injuriesLimited investigationFinal reportPiper PA28 · Leesburg, OHThe pilot's improper preflight planning and decision to attempt a takeoff from a runway that was too short for conditions, which resulted in the airplane settling into terrain.Aug 18, 2012 · N1845J · Substantial damageNTSB CEN12LA488Accident · 1 fatalLimited investigationFinal reportJoseph C. Andrews, Jr. Vans · Valentine, NEThe RV-6 pilot's failure to monitor the location of the RV-4, resulting in the on-ground collision. Contributing to the accident was the RV-6 pilot not ensuring proper separation from the RV-4 and his expectation that the pilot of RV-4 would roll out to the…Jul 27, 2012 · N122JA · 2 aircraft · Substantial damageNTSB ANC12CA076Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Whittier, AKThe pilot's failure to maintain clearance from brush during landing, which resulted in a loss of control.Jul 18, 2012 · N3764Z · Substantial damageNTSB ANC12CA065Accident · No injuriesData collectionFinal reportPiper PA-22-160 · McGrath, AKThe pilot’s decision to load the airplane in excess of its takeoff capability given the runway conditions, which resulting in a collision with terrain during the initial climb.Jul 3, 2012 · N8635D · Substantial damageNTSB CEN12CA270Accident · No injuriesData collectionFinal reportCessna 172M · Three Rivers, MICollision with a deer during the takeoff roll.May 1, 2012 · N30380 · Substantial damageNTSB WPR12CA117Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Randle, WAThe pilot exceeded the helicopter's performance, resulting in low rotor rpm and settling.Mar 8, 2012 · N54BA · Substantial damageNTSB CEN12TA122Accident · No injuriesFinal reportCessna 172P · Conroe, TXFailure of the rear crankshaft gear dowel pin due to improper installation, which resulted in a total loss of engine power.Jan 4, 2012 · N54872 · Substantial damageNTSB ERA12CA160Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Raleigh, NCThe pilot's loss of directional control while landing in gusting wind conditions.Dec 30, 2011 · N8330S · Substantial damageNTSB CEN12CA085Accident · Minor injuriesData collectionFinal reportGrumman American AA-5A · Bulverde, TXThe pilot's improper glidepath while on final approach.Nov 22, 2011 · N26067 · Substantial damageNTSB ANC12CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Portage, AKThe pilot's selection of unsuitable terrain for landing.Oct 22, 2011 · N82481 · Substantial damageNTSB ANC11CA106Accident · No injuriesData collectionFinal reportPiper PA-12 · Beluga, AKThe pilot's decision to take off uphill into rising terrain.Sep 23, 2011 · N78564 · Substantial damageNTSB ERA11CA497Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Okeechobee, FLThe student pilot's failure to maintain the proper glidepath during a power-off landing and the flight instructor's delayed remedial action.Sep 21, 2011 · N9249L · Substantial damageNTSB ANC11CA105Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Bethel, AKThe pilot's delayed decision to abort the takeoff.Sep 17, 2011 · N82907 · Substantial damageNTSB CEN11CA389Accident · No injuriesData collectionFinal reportConner Leroy RV6A · Oakwood, OKThe pilot's improper decision to land on a road with obstacles.Jun 10, 2011 · N25LC · Substantial damageNTSB ERA11CA346Accident · No injuriesData collectionFinal reportCessna 177 · Boone, NCThe pilot's delay in executing a go-around.Jun 3, 2011 · N3142T · Substantial damageNTSB CEN11LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Minneapolis, MNThe pilot's loss of directional control during the landing.Feb 12, 2011 · N536PU · Substantial damageNTSB CEN10LA575Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Basehor, KSThe pilot's improper touchdown point during landing and his delayed decision to execute a go-around. Contributing to the accident was the pilot's vision being obscured by the rain.Sep 25, 2010 · N6484R · DestroyedNTSB CEN10LA227Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Glenwood, NMThe pilot's decision to attempt a takeoff from an unimproved airstrip with a high density altitude.Aug 7, 2010 · N4372J · Substantial damageNTSB WPR10FA384Accident · Minor injuriesField investigationFinal reportCessna 172 · Roche Harbor, WAThe pilot’s failure to attain an adequate climb airspeed due to his use of flaps for takeoff, and his selection of a runway, which resulted in an uphill, and possibly downwind, takeoff and subsequent collision with a known obstacle. Contributing to the…Aug 6, 2010 · N9730H · Substantial damageNTSB ERA10CA392Accident · No injuriesData collectionFinal reportCessna 172N · Elk Creek, VAThe student pilot’s continued visual flight into instrument meteorological conditions, which resulted in an off-airport landing.Jul 31, 2010 · N172FL · Substantial damageNTSB ANC10CA063Accident · No injuriesData collectionFinal reportCessna 172P · New Stuyahok, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a collision with trees.Jul 18, 2010 · N63022 · Substantial damageNTSB ANC10CA047Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Port Alsworth, AKThe pilot's selection of unsuitable terrain for takeoff and inability to abort the takeoff, resulting in an overrun into the water.Jun 1, 2010 · N9217D · Substantial damageNTSB ANC10CA042Accident · No injuriesData collectionFinal reportPiper PA-12 · Chugiak, AKThe pilot's failure to maintain a proper glide path while landing, which resulted in an in-flight collision with a tree, and the collapse of the main landing gear during touchdown.May 22, 2010 · N2581M · Substantial damageNTSB WPR10CA167Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Okanogan, WAThe pilot's failure to maintain clearance from a fence at the end of the runway.Mar 17, 2010 · N4425Z · Substantial damageNTSB WPR10CA049Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lewiston, IDThe pilot's delayed decision to execute a go-around in gusting winds and with up-sloping terrain.Nov 1, 2009 · N82213 · Substantial damageNTSB ANC09LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nabesna, AKThe pilot's selection of an unsuitable takeoff area with an unfavorable wind.Sep 18, 2009 · N1169A · Substantial damageNTSB WPR09FA316Accident · 2 fatalField investigationFinal reportCessna 172M · Rimrock, WAThe pilot's failure to maintain clearance from trees during a go-around. Contributing to the accident was the pilot's lack of flight experience, and his delayed initiation of a go-around.Jun 28, 2009 · N4396R · Substantial damageNTSB ANC09CA054Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Tyonek, AKThe pilot's selection of unsuitable terrain for landing.Jun 7, 2009 · N82057 · Substantial damageNTSB ANC09CA028Accident · No injuriesData collectionFinal reportPiper PA-12 · Skwentna, AKThe pilot's selection of an unsuitable landing/takeoff area with an unfavorable wind.Apr 4, 2009 · N2997M · Substantial damageNTSB CEN09CA139Accident · No injuriesData collectionFinal reportCessna 172I · Rockford, ILThe pilot's inability to maintain directional control during the landing roll after contacting a low-lying snow bank that was obscured by drifting snow.Jan 19, 2009 · N35571 · Substantial damage