NTSB investigations: Piper PA-28-151
409 cases on aircraft the registry lists as Piper PA-28-151. 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 ('7102805', '7104223'))
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 ('7102805', '7104223'))
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 CEN09CA479Accident · Serious injuriesData collectionFinal reportPiper PA28-151 · Purcell, OKThe student pilot's failure to see and avoid the power lines.NTSB ERA09CA207Accident · No injuriesData collectionFinal reportPiper PA28-151 · Dover, DEThe pilot's failure to maintain directional control during landing.NTSB CEN09CA212Accident · No injuriesData collectionFinal reportPiper PA28-151 · Gardner, KSThe pilot's failure to ensure adequate clearance between the airplane's right wing and the building.NTSB ERA09LA123Accident · 2 fatalLimited investigationFinal reportPiper PA-28-151 · Powder Springs, TNThe non-instrument rated pilot's decision to continue under visual flight rules into an area of instrument meteorological conditions, which resulted in an in-flight collision with terrain.NTSB ANC08CA051Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Stevensville, MDThe pilot's misjudged speed/distance during landing.NTSB NYC08LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sacramento, KYA total loss of engine power during initial climb for undetermined reasons.NTSB CHI08CA032Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Alliance, OHThe pilot's inadvertent activation of the parking brake which resulted in the toe brakes becoming ineffective. Contributing to the accident was the airport perimeter fence, the ditch, and the vehicle.NTSB CHI08LA006Accident · 1 fatalLimited investigationFinal reportPiper PA-28-151 · Festus, MOThe pilot's inadequate aircraft preflight, fuel system water contamination and fuel starvation which resulted in a loss of engine power during landing approach. An additional cause was the emergency landing procedure not followed by the pilot following a loss…NTSB SEA08CA004Accident · No injuriesData collectionFinal reportPiper PA 28-151 · Salt Lake City, UTThe leak at the fuel line fitting, which resulted in a fire during engine start.NTSB SEA07LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Cibecue, AZThe pilot's failure to maintain proper control of the airplane during an off airport landing. Contributing factors were the pilot's psychological condition, impairment due to overdose of prescription medication, inadequate in-flight planning and mountainous…NTSB NYC07FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Howell, NJThe pilot's improper decision to attempt a flight with known serious medical conditions, which resulted in impairment during cruise flight, likely due to a stroke or transient ischemic attack. A factor was the pilot providing false information on his medical…NTSB LAX07LA113Accident · 2 fatalLimited investigationFinal reportPiper PA-28-151 · Lincoln City, ORIn-flight collision with water for undetermined reasons.NTSB NYC07CA045Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Danbury, CTThe student pilot's inadequate recovery from a bounced landing, which resulted in a hard landing.NTSB DFW06CA160Accident · Serious injuriesData collectionFinal reportPiper PA-28-151 · Brownwood, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Oxnard, CAThe loss of engine power for undetermined reasons.NTSB SEA06CA032Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Emmett, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the fence post.NTSB LAX05FA255Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · San Luis Obispo, CAThe pilot's continued flight into instrument meteorological conditions, and his failure to maintain clearance from the rising hilly terrain. Contributing factors were the pilot's inexperience regarding flying during the dark, nighttime condition, and the low…NTSB CHI05CA205Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall, and subsequent collision with trees. Contributing to the accident were the trees.NTSB CHI05CA174Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Willmar, MNThe pilot's improper flare which resulted in a hard landing.NTSB IAD05LA057Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Hampton, NHThe pilot's improper decision to depart with a tailwind, and his failure to perform preflight performance calculations.NTSB CHI05LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Waunakee, WIThe pilot's inadequate preflight planning and the delay in aborting the landing which resulted in the subsequent insufficient airspeed. Factors associated with the accident were the night light conditions, the fence, and the pole which the airplane contacted.NTSB ATL05CA064Accident · No injuriesData collectionFinal reportPiper PA28-151 · Eastman, GAThe certified flight instructors failure to maintain a visual look out while demonstrating a simulated emergency landing resulting in an in-flight collision with a known transmission wire.NTSB LAX05CA066Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Tucson, AZthe pilot's failure to maintain directional control during landing rollout.NTSB MIA04CA118Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Sugar Loaf Key, FLThe failure of the pilot to attain the proper touchdown point resulting in a landing overrun and subsequent on-ground collision with trees.NTSB SEA04LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Easton, WAThe pilot's failure to maintain terrain clearance while maneuvering in mountainous terrain. Mountain terrain was a factor.NTSB FTW04LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Goldwaite, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN04LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bountiful, UTthe pilot's failure to maintain aircraft control and adequate visual outlook during the landing flare. Contributing factors include the pilot's lack of recent experience, the snow bank, and the snow-covered runway.NTSB NYC04FA056Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Danbury, CTThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed.NTSB NYC04LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Quantico, VAThe pilot's failure to maintain directional control during landing. A factor was the tail wind.NTSB FTW03LA232Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Beaumont, TXThe loss of engine power for undetermined reasons.NTSB ATL03LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Rogersville, TNThe rupture of the carburetor float, which resulted in the loss of engine power and subsequent on ground collision with trees.NTSB CHI03LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · South Haven, MIThe inadequate fuel consumption calculations by the pilot and the fuel exhaustion. The inadequate traffic pattern distance from the runway, which precluded his reaching the runway.NTSB LAX03LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · San Luis Obispo, CAThe pilot's failure to maintain obstacle clearance due to her inadequate visual lookout.NTSB FTW02LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Masterson, TXThe loss of engine power due to fuel starvation as a result of a blockage of the carburetor. A contributing factor was the lack of suitable terrain for the emergency landing.NTSB IAD02LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Port Columbus, OHThe pilot's exhaustion of his fuel supply. A factor in the accident was the pilot's inadequate preflight planning.NTSB NYC02LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Belmar, NJThe student pilot's failure to maintain runway alignment during landing. A factor in the accident was the winds.NTSB ATL02FA059Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Macon, GAThe pilot's failure to maintain clearance from a tree while maneuvering after takeoff.NTSB ATL02LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bessemer, ALOn ground collision with an animal during landing.NTSB NYC02LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Cross Keys, NJThe pilot's delayed decision to abort the landing.NTSB MIA01LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Melbourne, FLthe pilot's failure to maintain directional control of the aircraft during the landing rollout while landing in gusty crosswind conditions, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial damage when it…NTSB ATL01FA094Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Rienzi, MSThe pilot experienced spatial disorientation, which resulted in an in-flight loss of control and subsequent collision with trees and terrain. A factor was the dark night condition.NTSB MIA01LA236Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Venice, FLan on ground fire that started in the engine due to an excessive fuel flow causing the engine to flood. A factor in this accident was the pilot-in-command did not follow all the emergency procedures for an engine fire during start.NTSB CHI00LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fulton, MOthe pilot's poor inflight planning which resulted in exceeded the proper touchdown point on the runway. A factor associated with the accident was the ditch that the airplane contacted.NTSB NYC00LA093Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Farmingdale, NYa power loss over unsuitable terrain, for undetermined reason(s).NTSB CHI99LA301Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Red Wing, MNDirectional control not being maintained by the pilot. A factor to the accident was the ditch.NTSB FTW99LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Springtown, TXThe pilot's failure to maintain clearance with the trees during the initial takeoff climb. A factor was the high density altitude.NTSB CHI99LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Vincennes, INthe pilot's failure to maintain directional control of the airplane during the soft field takeoff. Factors associated with the accident were inadequate airspeed and the cable fence which was contacted.NTSB CHI99FA174Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Drummond Island, MIthe altitude/clearance not obtained/maintained and the inadequate planning/decision by the pilot-in-command. The exceeded aircraft performance was an additional cause. The unfavorable wind and trees were contributing factors.NTSB MIA99FA031Accident · Minor injuriesField investigationFinal reportPiper PA-28-151 · Chattanooga, TNThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion.NTSB CHI98LA315Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Redwood Falls, MNthe pilot's not following proper short field landing procedures.