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 WPR12LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Casper, WYA total loss of engine power during cruise flight due to a failed piston pin plug, which resulted in engine oil contamination and subsequent oil starvation. Contributing to the loss of power was the failure of maintenance personnel to identify contaminants…NTSB WPR12CA083Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Santa Barbara, CAThe pilot did not maintain directional control during takeoff.NTSB WPR12LA076Accident · No injuriesLimited investigationFinal reportPiper PA28 · Phoenix, AZThe pilot’s inability to maintain directional control during the landing roll for reasons that could not be determined because impact damage precluded determination of the preaccident functionality of the braking and steering systems.NTSB CEN11CA682Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Texarkana, ARThe pilot's failure to maintain directional control while landing with a crosswind.NTSB CEN11CA647Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Pinckneyville, ILThe pilot's failure to conduct a go-around due to his excessive airspeed while on approach to land, which resulted in a runway excursion.NTSB ERA11FA480Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot’s failure to maintain adequate clearance from trees and terrain during the initial climb. Contributing was spatial disorientation due to a vestibular illusion and the pilot’s likely impairment due to alcohol consumption.NTSB ERA11CA271Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Millbrook, NYThe student pilot’s failure to maintain directional control during landing and the pilot’s inadequate remedial action, which resulted in a runway excursion.NTSB WPR11FA145Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Phoenix, AZThe pilot and flight instructor's failure to adequately monitor the flight task and environment while maneuvering to maintain sufficient altitude with rising terrain in dark night conditions and the flight instructor's improper decision to practice in an area…NTSB WPR11CA126Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Minden, NVThe pilot's loss of directional control during landing.NTSB WPR11CA085Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Wickenburg, AZThe student pilot's failure to maintain clearance between the airplane's right wing and the pole.NTSB WPR11CA084Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot's failure to maintain clearance from obstacles while taxiing.NTSB ERA10CA473Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's inadequate compensation for crosswind conditions which resulted in a hard landing and loss of directional control.NTSB ERA10CA441Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Oakland, MDThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA10CA337Accident · Serious injuriesData collectionFinal reportPiper PA-28-181 · Great Barrington, MAThe pilot's attempted visual flight into night instrument meteorological conditions, which resulted in spatial disorientation and subsequent controlled flight into terrain.NTSB CEN10FA316Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Umpire, ARThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation.NTSB ERA10CA303Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Block Island, RIThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with a fence.NTSB WPR10CA267Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Palo Alto, CAA total loss of engine power on final approach due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB WPR10CA172Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe flight instructor's failure to attain and maintain adequate airspeed while demonstrating a soft-field takeoff.NTSB WPR10FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot’s decision to take off in marginal visual flight rules conditions, which resulted in an encounter with low clouds, and the pilot's failure to maintain clearance from wires while maneuvering in the traffic pattern for landing.NTSB ERA10CA122Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Great Barrington, MAThe pilot's improper approach, failure to perform a go-around, and failure to maintain directional control while braking after a long landing.NTSB WPR10LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Apple Valley, CAThe pilot's loss of directional control during the landing roll and the check airman’s delayed remedial response.NTSB CEN10LA054Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Mineola, TXA loss of engine power due to fuel exhaustion and the pilot's inadequate preflight planning.NTSB WPR09CA410Accident · No injuriesData collectionFinal reportPiper PA28 · Glendale, AZThe student pilot's failure to maintain directional control during the landing roll.NTSB WPR09CA406Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s inadequate compensation for the crosswind condition and failure to maintain directional control during landing.NTSB WPR09CA363Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Metaline Falls, WAThe pilot’s failure, during the landing roll, to identify the end of the runway and stop the airplane within the space available.NTSB ERA09CA322Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Caldwell, NJThe pilot’s failure to maintain directional control of the airplane during landing. Contributing to the accident was the pilot’s failure to ensure that he could operate the rudder pedals without interference.NTSB ERA09LA296Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Dingman, PAA total loss of engine power in flight due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB CEN09WA248Accident · 2 fatalForeign investigationPiper PA-28-181 · Steep, United KingdomNTSB WPR09LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Firebaugh, CAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning and monitoring.NTSB CEN09CA020Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lufkin, TXThe student pilot's improper decision to takeoff with a known brake problem. Contributing to the accident were the malfunctioning brake and the rough terrain in the excursion area.NTSB SEA08FA174Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Monticello, UTThe pilot's failure to maintain clearance from terrain while maneuvering. Contributing to the accident was the low altitude.NTSB LAX08CA199Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Mesa, AZThe student pilot's inadequate recovery from a bounced landing and failure to maintain directional control.NTSB CHI08CA147Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Dixon, ILThe student pilot improperly raised the flaps during the go-around, did not maintain airspeed, and stalled the airplane. The trees were a factor.NTSB CHI08CA126Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Naperville, ILThe pilot's failure to execute a go-around. Contributing to the accident was the pilot's excessive airspeed during touchdown, which resulted in the runway overrun.NTSB DEN08LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Reserve, NMThe pilot's loss of aircraft control, resulting in an inadvertent stall. Contributing factors in this accident were the sudden windshift to a gusting tailwind, an uphill runway, high density altitude, the pilot's failure to use all available runwayt, and his…NTSB LAX08CA087Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Bremerton, WAThe pilot's failure to maintain directional control while taxiing. A contributing factor was the control interference on the rudder pedals created by the pilot's footwear.NTSB LAX08CA076Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll. Contributing to the accident was the crosswind condition.NTSB SEA08LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Phoenix, AZThe failure of the solo student pilot operating the other airplane to maintain clearance while taxiing for takeoff.NTSB NYC08FA020Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Boynton Beach, FLA total loss of engine power due to fuel starvation as a result of the pilots' improper in-flight fuel management.NTSB MIA08FA001Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Walthourville, GAThe non-instrument rated pilot's loss of control at night in marginal night VFR operations due to spatial disorientation. A factor in the accident was the pilot's improper decision to continue the flight.NTSB NYC07CA218Accident · No injuriesData collectionFinal reportPiper PA-28-181 · N Myrtle Beach, SCThe pilot's failure to maintain aircraft control during a go-around, which resulted in a collision with water. A factor in this accident was the crosswind conditions.NTSB NYC07LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Daytona Beach, FLThe inadequate visual lookout of the pilot of the unknown airplane.NTSB NYC07LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sevierville, TNThe pilot misjudged his speed and distance resulting in an overrun. Contributing to the accident was the wet turf runway and the lack of any information in the pilot operating handbook regarding landing distance on a wet turf runway.NTSB LAX07LA268Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lopez Island, WAA loss of engine power due to the fatigue failure of the left idler gear. Inadequate maintenance installation of the recently installed left magneto was also causal.NTSB NYC07CA179Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's delayed decision to abort the landing, which resulted in an impact with a tree.NTSB LAX07FA219Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · El Cajon, CAthe pilot's inadequate in-flight decision to attempt low altitude flight operations into a box canyon in mountainous terrain, and his failure to maintain an adequate airspeed while maneuvering to reverse direction, which led to an accelerated stall and spin.NTSB CHI07CA200Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lake in the Hil, ILThe pilot's failure to achieve a proper touchdown point and delayed decision to abort the landing. Factors contributing to the accident include the chain link fence and the trees.NTSB LAX07CA151Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Las Vegas, NVfuel starvation due to the pilot's inadequate fuel system management.NTSB ATL07LA067Accident · 1 fatalLimited investigationFinal reportPiper PA28-181 · New Tazewell, TNThe pilot's failure to maintain aircraft control. Contributing to the accident was the non-instrument rated pilot's continued flight from visual meteorological conditions into instrument meteorological conditions, and a low cloud ceiling.NTSB MIA07LA053Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Venice, FLThe failure of the student pilot to maintain airspeed during a go-around.