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 NYC07CA067Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Millbrook, NYThe pilot's failure to maintain a proper glidepath to the runway.NTSB NYC07CA053Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Cumberland, MDThe pilot's misjudgment of the airplane's distance/altitude during the landing approach.NTSB CHI06CA239Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Napoleon, MIThe pilot's failure to maintain a proper glidepath during the landing approach, and his excessive airspeed during the landing which resulted in the overrun. A factor was the fence that the airplane impacted.NTSB LAX06CA223Accident · No injuriesData collectionFinal reportPiper PA28-181 · Dorris, CAthe pilot's failure to maintain an adequate airspeed during a go-around, which resulted in a stall/mush. A contributing factor was the high density altitude.NTSB LAX06CA159Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Columbia, CAthe pilot's failure to maintain directional control during the landing roll.NTSB NYC06CA102Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Jeannette, PAExcessively worn brake pads and rotors, which resulted in a runway overrun and subsequent collision with a tree.NTSB CHI06CA144Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Logansport, INThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB LAX06CA272Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Coalinga, CAthe pilot's misjudged landing flare, which resulted in a bounced landing, and his inadequate recovery technique that led to a hard landing.NTSB NYC06LA066Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Henderson, WVThe pilot's improper decision to attempt the off-airport takeoff; and his improper decision to continue the takeoff after striking a pole during the takeoff roll.NTSB SEA06LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Brookings, ORThe pilot's inadequate in flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. Trees and no suitable terrain for the landing were factors.NTSB SEA06LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Butte, MTThe pilot's failure to maintain clearance from the terrain during low-level maneuvering at night. Factors included the pilot’s improper in-flight decision to continue into an area that was forecasted to possibly contain snow, fog, and low ceilings. Additional…NTSB CHI06LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Milwaukee, WIThe loss of engine power due to fuel starvation as a result of the pilot's fuel mismanagement. Factors to the accident included the pilot's impairment due to alcohol, the FAA's inadequate oversight when it issued the pilot a second class medical certificate,…NTSB ATL06CA002Accident · Serious injuriesData collectionFinal reportPiper PA-28-181 · Pageland, SCThe pilots failure to maintain flying speed during the go-around, which resulted in a stall and the subsequent collision with trees.NTSB LAX05CA301Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Petaluma, CAa loss of engine power due to fuel exhaustion.NTSB CHI05CA247Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Ypsilanti, MIThe pilot's failure to maintain adequate airspeed which resulted in his inability to properly flare the airplane and the subsequent hard landing.NTSB CHI05CA208Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Willard, MOThe airplane overran the runway and hit a utility pole due to the pilot's delayed decision making and his failure to execute a go-around. Contributing factors included the exessive airspeed during the final approach, the high density altitude, the…NTSB IAD05FA110Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Georgetown, DEThe pilot's misjudged distance/altitude while on final approach to land, which resulted in an in-flight collision with a vehicle. Factors associated with the accident are the pilot's improper use of the flaps, and the state of Delaware's insufficient…NTSB IAD05LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, OHThe flight instructor's failure to maintain directional control during the landing rollout. A factor was the night lighting conditions.NTSB CHI05CA142Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Raymore, MOThe loss of total engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A factor was the unsuitable terrain encountered during the forced landing.NTSB LAX05LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Avalon, CAfuel exhaustion due to the pilot's inadequate preflight and failure to refuel the airplane prior to takeoff.NTSB LAX05CA182Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Oxnard, CAthe pilot's failure to maintain an adequate clearance from the building. The pilot's diverted attention was a factor.NTSB CHI05FA180Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Lake Michigan, WIThe pilot's inaccurate preflight planning and his delayed en route decision to make a fuel stop, which resulted in the loss of engine power due to fuel exhaustion and subsequent ditching.NTSB LAX05FA106Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Yucaipa, CAThe failure of the private pilot and the flight instructor to maintain adequate terrain clearance while flying in unfamiliar mountainous terrain in dark night conditions.NTSB SEA05LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · The Dalles, ORThe student pilot's improper compensation for the wind condition and the improper rejected landing procedure, which resulted in the collision with terrain. A contributing factor to the accident was the crosswind condition.NTSB ATL05FA041Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Bradley, SCThe pilot's loss of control of the airplane due to spatial disorientation, which resulted in an uncontrolled descent and collision with trees and the ground. A factor was the dark night conditions.NTSB MIA05LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Pierce, FLThe failure of the pilot of the Piper 181 to apply his parking brake when stopped awaiting departure and his failure to maintain a visual lookout resulting in his airplane rolling forward and colliding with the Piper 201 which was awaiting departure.NTSB LAX05CA043Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Santa Monica, CAthe certified flight instructor's inadequate supervision, inadequate compensation for the tailwind condition, and delayed remedial action, which resulted in a runway overrun and collision with a ditch.NTSB CHI05CA039Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lee's Summit, MOThe inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power. Contributing factors were the muddy terrain and the vegetation.NTSB IAD05CA018Accident · No injuriesData collectionFinal reportPiper PA 28-181 · York, PAThe pilot's inadequate weather evaluation and his decision to depart from a rain-soaked runway with strong quartering tailwinds, which resulted in a runway overrun and collision with a fence during the aborted takeoff.NTSB CHI05CA022Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Morris, ILThe pilot's inadequate preflight planning in that he failed to assure that the airplane was properly secured prior to hand propping the engine. Factors associated with the accident were the broken tie down rope and the other airplanes which were contacted.NTSB ANC04CA119Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Haines, AKThe pilot's inadequate compensation for wind conditions during the takeoff roll, which resulted in a premature liftoff and subsequent uncontrolled descent and collision with the runway.NTSB FTW04CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Haskell, TXThe pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB SEA04LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Seattle, WAThe failure of the pilot to maintain clearance with the parked airplane while taxiing. A factor contributing to the accident was the pilot's inadequate preflight planning.NTSB NYC04FA179Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Exton, PAThe pilot's failure to maintain aircraft control in instrument meteorological conditions, which resulted in the airplane impacting a residence. Factors in the accident were the pilot's lack of recent instrument experience.NTSB MIA04CA106Accident · No injuriesData collectionFinal reportPiper PA-28 · Okeechobee, FLStudent pilot's failure to maintain directional control of the airplane during landing roll, resulting in the airplane departing the runway and impacting a fence incurring substantial damage to the airplane.NTSB CHI04WA171Accident · 1 fatalForeign investigationPiper PA-28-181 · Qaqortoq, GreenlandNTSB ATL04FA139Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Fort Lauderdale, FLThe pilot's inadequate preflight planning which resulted in the loss of engine power due to fuel exhaustion, and the pilot's failure to maintain flying speed which resulted in an inadvertent stall, and the subsequent collision with a building.NTSB LAX04CA236Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Dunsmuir, CAthe pilot's misjudgment of speed and distance, which resulted in an overrun of the runway. The pilot's failure to use flaps and his landing at an airport with a runway shorter than he expected is a contributing factor.NTSB FTW04LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Many, LAThe pilot's improper touchdown which resulted in a hard landing.NTSB NYC04CA094Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Louisville, KYThe student pilot's failure to maintain directional control while landing, and the CFI's delayed remedial action. A factor related to the accident was the gusting wind conditions.NTSB NYC04FA077Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Corry, PAThe loss of partial engine power for undetermined reasons, and the pilot's lost of control after performing an evasive maneuver to avoid trees during a forced landing at night. Factors related to the accident were a rough running engine and the pilot's…NTSB LAX04LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Palmdale, CAloss of engine power for undetermined reasons.NTSB MIA04FA045Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Fort Pierce, FLThe flight instructor's failure to comply with the instrument approach procedure in that he descended prematurely below decision height resulting in an in-flight collision with trees, power lines and the ground. Contributing factors were the dark night light…NTSB LAX04CA093Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Scottsdale, AZfailure of the pilot to maintain directional control on the takeoff roll. A factor in the accident was the pilot's failure to retract the flaps.NTSB LAX04CA088Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Groveland, CAthe pilot's inadequate visual lookout, and his failure to maintain obstacle clearance. Factors to the accident were the parked vehicle, and the pilot's diverted attention.NTSB FTW04FA037Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Sugar Land, TXThe pilots failure to maintain clearance with powerlines during a VFR approach. Contributing factors were the prevailing dark night conditions,and the high winds.NTSB NYC04FA033Accident · 2 fatalField investigationFinal reportCessna 180 · Westerly, RIThe Piper pilot's improper decision to continue a landing on an occupied runway, which resulted in an in-flight collision with the departing Cessna. Factors related to the accident were the departing Cessna pilot's inattentive radio communications, and the…NTSB NYC04LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Montauk, NYThe pilot's loss of control after performing an evasive maneuver to avoid a deer crossing the unlit runway, which resulted in a collision with trees. Factors related to the accident were the nighttime conditions, the inoperative runway lighting system, and…NTSB CHI03FA284Accident · 3 fatalField investigationFinal reportCessna 172S · Lake Elmo, MNBoth pilots failed to maintain adequate visual lookout and did not maintain clearance from the other aircraft.NTSB NYC03LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Sandusky, OHThe pilot's failure to maintain the engine mixture control during the go-around, which resulted in a loss of power, and in-flight collision with trees.