NTSB investigations: Piper PA-28-180

2,065 cases on aircraft the registry lists as Piper PA-28-180. 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'))
  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 ERA13FA064Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Canton, CTThe pilot’s failure to maintain clearance from terrain while performing a night visual approach to an airport. Contributing to the accident were the dark night and the pilot's lack of recent experience flying at night.Nov 19, 2012 · N8826J · Substantial damageNTSB WPR13FA001Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Beatty, NVThe pilot’s inadequate flight planning, subsequent loss of situational awareness, and failure to maintain clearance from the power lines during a dark night approach to a closed, unlit runway.Oct 3, 2012 · N7895W · 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 ERA12LA394Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocilla, GAA failure of the No. 2 cylinder connecting rod due to a lack of lubrication, which resulted in a total loss of engine power.Jun 13, 2012 · N9238J · 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 CEN11CA678Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Buena Vista, COThe airplane’s diminished climb performance due to the pilot not leaning the engine mixture enough prior to takeoff in high density altitude conditions and at nearly maximum gross takeoff weight.Sep 6, 2011 · N9430J · Substantial damageNTSB WPR11CA425Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Gerlach, NVThe pilot’s decision to land at an unknown off-airport location.Sep 3, 2011 · N7303W · Substantial damageNTSB CEN11LA555Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Millsap, TXA sudden loss of engine thrust due to the separation of a propeller blade in cruise flight due to high cycle fatigue.Aug 7, 2011 · N7689W · Substantial damageNTSB ERA11FA422Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Berne, NYThe pilot's continued visual flight into instrument meteorological conditions, which resulted in a collision with trees and rising terrain while attempting to reverse course. Contributing to the accident was the pilot's failure to obtain a preflight weather…Jul 25, 2011 · N1279T · 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 CEN11LA430Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Barron, WIThe loss of engine power, which resulted from fuel exhaustion due to the pilot's inadequate in-flight planning.Jun 29, 2011 · N9002J · 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 WPR10LA427Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sequim, WAThe pilot’s failure to maintain the proper approach path and his delayed corrective actions, which resulted in an undershoot. Contributing to the accident was the pilot's distraction from other aircraft in the area.Aug 24, 2010 · N5101L · 2 aircraft · 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 WPR10LA370Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Walla Walla, WAThe pilot's partial incapacitation during cruise flight and his subsequent inadequate fuel management, which resulted in fuel starvation.Jul 28, 2010 · N57PJ · Substantial damageNTSB ERA10LA306Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lucedale, MSThe partial separation of the No. 3 cylinder due to improper torquing of the cylinder hold-down bolts by maintenance personnel during installation of the cylinder.Jun 8, 2010 · N5118L · 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 ERA10CA152Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Patillas, PRThe student pilot’s decision to abort the takeoff with insufficient runway remaining.Feb 24, 2010 · N5212L · 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 CEN10LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Alexandria, LAA loss of engine power for undetermined reasons.Dec 27, 2009 · N7230W · Substantial damageNTSB CEN10LA055Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Naytahwaush, MNThe non-instrument rated pilot's decision to continue the flight into known instrument meteorological conditions resulting in spatial disorientation and impact with terrain.Nov 14, 2009 · N7736N · DestroyedNTSB 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 ERA09LA547Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Glen St. Mary, FLThe pilot's failure to maintain control of the airplane during the landing.Sep 27, 2009 · N7720W · Substantial damageNTSB CEN09CA599Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Sibley, IAThe pilot's long and fast landing and her delayed decision to execute a go-around.Sep 21, 2009 · N57354 · 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 ERA09CA405Accident · No injuriesData collectionFinal reportPiper PA28 · Blacksburg, VAThe pilot's failure to maintain directional control during the takeoff roll.Jul 14, 2009 · N7418W · Substantial damageNTSB 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 WPR09CA238Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Globe, AZThe pilot's inadequate compensation for the crosswinds during landing.May 10, 2009 · N8401W · Substantial damageNTSB ERA09LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Pittstown, NJA loss of engine power due to the improper tightening of a fuel hose B-nut by maintenance personnel during engine installation.Feb 11, 2009 · N55854 · Substantial damageNTSB CEN09IA161Incident · No injuriesIncident investigationFinal reportPiper PA28 · Fairmont, NEBoth pilots' failure to see and avoid the other aircraft.Feb 7, 2009 · N55502 · 2 aircraft · Minor 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 damage