NTSB investigations: Piper PA-28-180

96 cases on aircraft the registry lists as Piper PA-28-180, where the sequence of events included Collision with terr/obj (non-CFIT). 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.aircraft_model_code IN ('7102808')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  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 GAA15CA240Accident · No injuriesData collectionFinal reportPiper PA 28-180 · DeFuniak Springs, FLThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion, and collision with a ditch.Aug 26, 2015 · N7215W · Substantial damageNTSB GAA15CA239Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Susanville, CAThe pilot's failure to maintain airspeed control during the landing in gusty wind conditions, resulting in an abnormal runway contact, and collision with terrain.Aug 26, 2015 · N1417X · Substantial damageNTSB GAA15CA103Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Steele, NDThe pilot's failure to maintain directional control during landing, which resulted in a collision with objects while attempting to abort the landing.May 12, 2015 · N56074 · Substantial damageNTSB GAA15CA050Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Deer Lodge, MTThe pilot's inadequate recovery from a bounced landing, resulting in a loss of control and collision with terrain.Apr 17, 2015 · N7374W · Substantial damageNTSB WPR15CA107Accident · No injuriesData collectionFinal reportPiper PA28 - 180 · Garfield, WAThe pilot did not maintain clearance from a power line while maneuvering at a low altitude.Feb 15, 2015 · N7928W · Substantial damageNTSB ERA15CA064Accident · Serious injuriesData collectionFinal reportPiper PA 28-180 · Athens, ALThe pilot's failure to maintain adequate altitude while landing in gusty wind conditions, which resulted in a collision with power lines while on final approach.Nov 30, 2014 · N7422W · Substantial damageNTSB ERA14LA440Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-180 · St. Petersburg, FLA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s improper preflight fuel planning and in-flight fuel management.Sep 15, 2014 · N15833 · Substantial damageNTSB ERA14LA404Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Gaithersburg, MDThe loss of engine power due to fuel starvation for reasons that could not be determined during postaccident examination of the fuel supply and fuel vent systems.Aug 23, 2014 · N9095J · Substantial damageNTSB CEN14TA421Accident · Minor injuriesFinal reportPiper PA 28-180 · Sulphur, LAThe pilot’s failure to properly manage the airplane’s fuel supply, which led to fuel starvation and a total loss of engine power.Aug 8, 2014 · N4286T · Substantial damageNTSB WPR14LA249Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Quincy, CAThe partial loss of engine power during takeoff due to the separation of the exhaust baffling, which resulted in a partial blockage of airflow to the engine. Contributing to the accident was maintenance personnel’s inadequate inspection of the exhaust system…Jun 15, 2014 · N4931L · Substantial damageNTSB ERA14CA233Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Indian Trail, NCThe pilot's improper flap retraction during a short field takeoff, which resulted in the aircraft experiencing an aerodynamic stall and impact with trees.May 11, 2014 · N15230 · Substantial damageNTSB WPR13LA366Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Overgaard, AZThe partial loss of engine power during takeoff due to the separation of the exhaust baffling, which resulted in a partial blockage of airflow. Contributing to the accident was inadequate maintenance of the exhaust system.Aug 10, 2013 · N9752J · Substantial damageNTSB CEN13CA475Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Poteau, OKThe pilot’s application of excessive left rudder during the takeoff roll, resulting in a loss of directional control, his failure to correct the excursion with opposite rudder, and his failure to abort the takeoff in a timely manner.Aug 10, 2013 · N7811W · Substantial damageNTSB CEN13CA474Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Clare, MIThe flight instructor's failure to adequately monitor the landing approach, his delayed corrective action and his failure to maintain directional control that resulted in the airplane's collision with a ditch adjacent to the runway. The student pilot's…Aug 7, 2013 · N2195T · Substantial damageNTSB ERA12CA573Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Berlin, NJThe pilot’s failure to maintain directional control during landing.Sep 21, 2012 · N7290W · Substantial damageNTSB WPR12CA419Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · French Valley, CAThe pilot’s loss of directional control during a go-around following a sudden change in wind direction.Sep 14, 2012 · N7971W · Substantial damageNTSB ERA12LA469Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Statesboro, GAA total loss of engine power as a result of oil exhaustion due to the mechanic's failure to apply appropriate torque to the oil filter.Jul 20, 2012 · N3692R · Substantial damageNTSB CEN12LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Frankenmuth, MIA partial loss of engine power for undetermined reasons and the pilot’s failure to maintain airspeed, which resulted in an aerodynamic stall.May 20, 2012 · N4595T · Substantial damageNTSB ERA12CA277Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Georgetown, KYThe pilot's failure to maintain control of the airplane after engine start.Apr 10, 2012 · N9518J · Substantial damageNTSB ERA12LA253Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Margaret, ALThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power during cruise flight due to fuel starvation.Mar 24, 2012 · N7309W · Substantial damageNTSB CEN12FA158Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Osborn, MOThe pilot’s decision to conduct low-level passes above a residence and his failure to maintain sufficient altitude.Feb 14, 2012 · N4824L · Substantial damageNTSB ERA12FA163Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Thomasville, PAThe pilot's failure to maintain airspeed during an approach in gusty crosswind conditions, which resulted in an inadvertent aerodynamic stall.Jan 29, 2012 · N1352T · Substantial damageNTSB CEN12LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Lebanon, OHThe pilot’s inadvertent positioning of the fuel selector valve between the right tank and OFF position, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the inadequate inspection of the fuel valve and…Dec 28, 2011 · N994NC · Substantial damageNTSB CEN12FA072Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Perryville, ARThe pilot's loss of control in flight.Nov 17, 2011 · N7746W · Substantial damageNTSB CEN11LA441Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Flippin, ARThe loss of engine power due to improper maintenance and resultant oil starvation.Jul 1, 2011 · N56417 · Substantial damageNTSB ERA11FA291Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · New Hampton, NYThe PA24 pilot’s failure to maintain adequate clearance from the PA28, resulting in an in-flight collision. Contributing to the accident was the PA24 pilot's decision to overtake the PA28.May 9, 2011 · N5275L · 2 aircraft · Substantial damageNTSB ERA11LA289Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocilla, GAThe pilot did not maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.May 7, 2011 · N7317W · Substantial damageNTSB CEN11LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Streetman, TXThe airplane’s inability to establish a climb for undetermined reasons, which resulted in a collision with trees.Apr 25, 2011 · N6492J · Substantial damageNTSB ERA11CA259Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Lake Wales, FLThe pilot’s failure to maintain directional control during the landing roll.Apr 23, 2011 · N57WV · Substantial damageNTSB ERA11CA243Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Latrobe, PAMaintenance personnel’s failure to properly secure the throttle cable to the fuel servo.Apr 14, 2011 · N5325L · Substantial damageNTSB ERA11CA127Accident · No injuriesData collectionFinal reportPiper PA28 · Monroeville, ALThe pilot's failure to maintain directional control during the landing rollout.Jan 26, 2011 · N9742J · Substantial damageNTSB CEN11CA176Accident · Serious injuriesData collectionFinal reportPiper PA-28-180 · Pekin, ILThe student pilot's failure to maintain adequate airspeed during the landing approach, which resulted in an aerodynamic stall.Jan 19, 2011 · N5658W · Substantial damageNTSB CEN10LA476Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Winnfield, LAA loss of engine power due to fuel exhaustion.Aug 12, 2010 · N9507J · Substantial damageNTSB CEN10LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Three Rivers, MIThe pilot's inability to maintain directional control during landing due to the failure of the left main landing gear torque link as a result of fatigue.Apr 12, 2010 · N3470R · Substantial damageNTSB ERA10CA214Accident · Serious injuriesData collectionFinal reportPiper PA28 · Louisville, KYA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.Apr 7, 2010 · N4247T · Substantial damageNTSB ERA10CA194Accident · Serious injuriesData collectionFinal reportPiper PA-28-180 · Palermo, NYA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Mar 28, 2010 · N3442R · Substantial damageNTSB ERA10FA148Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Springfield, KYThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion, and the pilot's impairment due to alcohol. Contributing to the accident was the Federal Aviation Administration's failure to adequately oversee…Feb 23, 2010 · N7778W · Substantial damageNTSB CEN10LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Coldwater, MIA loss of engine power due to the separation of the No. 4 piston connecting rod as a result of inadequate torque of the connecting rod bolt.Nov 2, 2009 · N8364W · Substantial damageNTSB ERA10LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Brooksville, FLA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight fuel planning.Oct 25, 2009 · N7220W · Substantial damageNTSB ERA10FA020Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Oliver Springs, TNThe pilot's loss of directional control while landing on a wet turf runway, which resulted in a runway excursion and collision with a tree.Oct 18, 2009 · N7906W · Substantial damageNTSB WPR09LA431Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Oroville, CAA total loss of engine power for undetermined reasons.Sep 4, 2009 · N2482R · DestroyedNTSB CEN09FA377Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Sanborn, IAA loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel planning and failure to refuel.Jun 23, 2009 · N7795N · Substantial damageNTSB WPR09CA099Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Bisbee, AZThe student pilot's failure to maintain directional control during takeoff and the flight instructor's inadequate supervision of the flight and delay in remedial action.Jan 24, 2009 · N5117L · Substantial damageNTSB ERA09LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jasper, GAA total loss of engine power for an undetermined reason.Jan 17, 2009 · N9459J · Substantial damageNTSB SEA08FA187Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Springerville, AZThe pilot's failure to attain and maintain an adequate airspeed during takeoff in high density altitude conditions that resulted in an aerodynamic stall.Aug 20, 2008 · N5316L · Substantial damageNTSB CHI08CA174Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Greenwood, ILThe student pilot's inadequate compensation for the gusting crosswind, and the flight instructor's delayed remedial actions that resulted in a loss of control during the go-around maneuver. Contributing to the accident was the gusting wind condition.Jun 30, 2008 · N4433T · Substantial damage