NTSB investigations: Piper PA-28-181
787 cases on aircraft the registry lists as Piper PA-28-181. 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 ('7102807', '7102832'))
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.aircraft_model_code IN ('7102807', '7102832'))
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 CHI94LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Woonsocket, SDthe pilot misjudging the airplane's clearance under the wires. Factors related to the accident were the performance of a low pass and the wires which were contacted.NTSB SEA93LA197Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Merrill, ORFuel exhaustion and inadequate inflight planning/decision.NTSB CHI93LA355Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Davison, MIImproper planning/decision by the pilot, which resulted in inadequate fuel and fuel exhaustion.NTSB BFO93LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Columbia Stn, OHThe pilot's delay in initiating a go-around (aborted landing), and his improper raising of the flaps at a low airspeed after lift-off, which resulted in a stall/mush. A factor related to the accident was: the pilot's failure to attain the proper touchdown…NTSB NYC93FA140Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot initiating VFR flight into instrument meteorological conditions resulting in spatial disorientation and loss of aircraft control. During his attempt to regain control of the aircraft the pilot exceeded the design stress limits resulting in wing…NTSB LAX93LA312Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fresno, CAThe pilot's inadequate flare and his improper recovery from the resulting bounced landing. Factors related to this accident were the alternator failure and the night condition.NTSB CHI93LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Senter, MIThe pilot-in-command's inadequate pre-flight planning. Factors relating to this accident are fuel exhaustion, unsuitable terrain on which to make an emergency landing, as well as an inadvertent stall.NTSB FTW93LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Baton Rouge, LAThe student pilot's failure to abort the landing in a timely manner and his failure to maintain directional control.NTSB LAX93LA278Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Columbia, CAa loss of engine power for undetermined reasons.NTSB FTW93LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rogers, ARThe pilot's failure to maintain control of the airplane. A factor was the tailwind.NTSB SEA93LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Provo, UTThe wild animals on the runway. A factor relating to the accident was the dark night light conditions.NTSB FTW93LA155Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dougherty, TXFuel exhaustion power loss due to refueling not performed by the pilot. A factor was lack of suitable terrainNTSB BFO93LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Chesterfield, VAFatigue failure of the engine crankshaft at the number 1 journal. A factor related to the accident was unsuitable terrain in the emergency landing area.NTSB LAX93LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Las Vegas, NVThe pilot's failure to maintain directional control of the aircraft during the touchdown. Factors in the accident were the pilot's lack of experience and his failure to maintain a balance between the wing fuel tanks.NTSB DEN93FA043Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Elbert, COThe pilot's inadvertent VFR flight into IMC. Factors were his lack of instrument training/experience, existing weather, and dark night conditions.NTSB BFO93LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Springboro, OHThe pilot misjudged his distance, and altitude on final approach, and failed to attain the proper touchdown point.NTSB NYC93LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Danbury, CTThe pilot misjudged the clearance between two snow banks, striking one of the snow banks with the airplane's right wing.NTSB LAX93FAMS2Accident · 4 fatalMissing aircraftFinal reportPiper PA-28-181 · Missing Acft, CAUndetermined.NTSB LAX93LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Novato, CAFailed to maintain directional control and an inadequate visual lookout. Contributing to this accident were the inoperative runway lights.NTSB CHI93IA019Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Chicago, ILThe failure of the midway arsa controller to coordinate use of the airspace with the Chicago north local controller which resulted in an operational deviation. A factor related to the incident was the pilot's failure to follow his assigned heading.NTSB BFO92LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Pikesville, KYThe pilot's failure to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were: the pilot's improper flare. And objects near the runway.NTSB BFO92LA091Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Clay City, KYFuel starvation for an undetermined reason. Darkness and trees in the emergency landing area were related factors.NTSB FTW92LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Wichita Falls, TXThe pilot's failure to maintain directional control.NTSB LAX92FA204Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Cucamonga, CAThe pilot's decision to continue VFR flight into instrument meteorological conditions. Factors in the accident were: the pilot's failure to obtain a weather briefing, the adverse weather conditions, his physical impairment due to drugs, and the mountainous…NTSB MIA92FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-181 · MissingUndetermined.NTSB CHI92LA043Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Rochester, MNImproper use of autopilot during approach which resulted in proper alignment not maintained by the pilot. Factors related to the accident were turbulence and crosswinds, over confidence in aircraft's capability and overconfidence in personal ability.NTSB LAX91FA399Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Cupertino, CAThe pilot's failure to maintain the proper altitude, his improper inflight decision to attempt flight below the base of an overcast layer of clouds toward rising mountainous terrain and the flight's inadvertent entry into instrument meteorological conditions.…NTSB BFO92DOA01Accident · 1 fatalFinal reportPiper PA-28-181 · Belington, WVThe pilot's failure to maintain clearance above the terrain which resulted in inflight collision with the terrain. Contributing was mountainous terrain.NTSB SEA91LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sunriver, ORThe pilot's inadequate compensation for wind conditions, which resulted in a failure to maintain runway alignment. The gusty crosswind was a related factor.NTSB LAX91FA333Accident · 3 fatalField investigationFinal reportPiper PA 28-181 · Sonora, CAFailure of the flight instructor/pilot-in-command to adequately supervise the flight and to maintain adequate airspeed by exceeding the climb performance of the airplane. Contributing to the accident was the pilot-in-command's inadequate planning and his…NTSB FTW91LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Heber Springs, ARThe pilot's touchdown at an improper point on the airstrip. A factor was the wet downsloping grass airstrip.NTSB LAX91LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rio Vista, CAFuel exhaustion due to the pilots improper fuel consumption calculations and inadequate preflight planning.NTSB CHI91LA192Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Marquette, MIThe pilot-in-command's failure to maintain proper altitude.NTSB NYC91FA144Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · East Haddam, CTThe non-mechanical loss of engine power due to the failure of the pilot to use the auxiliary fuel boost pump during takeoff.NTSB NYC91LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dushore, PAThe pilot landed with excessive airspeed, which resulted in ineffective braking and a loss of control.NTSB MIA91LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Cedar Key, FLThe pilot's selection of the wrong runway for wind conditions.NTSB FTW91LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Longview, TXFuel exhaustion resulting in a complete power loss due to the pic/cfi's failure to refuel at intermediate destinations.NTSB LAX91FA181Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Carpenteria, CA1) Inadequate weather evaluation by the pilot, 2) poor inflight decision to try and continue VMC flight, and 3) the pilot's lack of total experience.NTSB CHI91LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · West Branch, MIThe pilot's failure to follow recommeded starting procedures/directives and precautions.NTSB CHI91LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Morgan, MNA guy wire was struck on takeoff because of inadequate clearance. Factors related to the accident were poor planning/decision by the pilot and over confidence in personal ability.NTSB LAX91FA106Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Fredonia, AZThe pilot's inattention to the airspeed and subsequent loss of aircraft control after attempting VFR flight into adverse weather conditions. Contributing to the accident was the pilot's failure to recognize his limitations of his aircraft.NTSB CHI91LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Marshfield, WIImproper in-flight planning/decision by the pilot and his failure to maintain airspeed, which resulted in an inadvertent stall/mush onto snow covered terrain beside the runway. The adverse weather conditions and snow covered terrain were related factors.NTSB LAX91LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Mokuleia, HIThe cfi's failure to use carburetor heat. A factor was the manufacturer's inadequate procedure.NTSB LAX91LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ramona, CAThe pilot's failure to maintain directional control of the airplane during an attempted takeoff. A contributing factor was related to the student's improper use of rudder control.NTSB FTW91FA025Accident · 1 fatalField investigationFinal reportPiper PA28-181 · Olla, LAThe collapsed carburetor float and restricted movement of the fuel metering needle. Factors were the darknight, the unsuitable terrain, and the operator's maintenance personnel failure to inspect (repair) the engine.NTSB BFO91FA008Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · Elkton, MDLoss of engine power for an undetermined reason, and the pilot's failure to maintain adequate airspeed, which resulted in a stall and an inflight collision with the terrain.NTSB MIA91LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Orlando, FLInadequate planning by the pilot.NTSB SEA91LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Princeton, ORThe pilot's failure to maintain clearance from obstacles at the side of the runway.NTSB MIA91LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rolling Fork, MSThe failure of the pilot to maintain wingtip clearance with tall grass at the edge of the runway during the ground roll.NTSB CHI90LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Amana, IAProper touchdown point not attained and go-around delayed by the pilot in command. Contributing factors were ATC communications inadequate and wet, grass runway with a tailwind environment plus a fence.