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 NYC98LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Newport, NHThe seizure of the throttle shaft, due to the overhaul facilities' failure to insure all metal fragments had been removed from the carburetor before inserting the throttle shaft after reaming the throttle shaft bushings.NTSB CHI98LA252Accident · Serious injuriesLimited investigationFinal reportPiper PA28-151 · Anthon, IAThe pilot-in-command's improper preflight planning, preparation and fuel management resulting in an unscheduled landing and impact with a pole.NTSB CHI98LA203Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Jefferson, IAthe pilot's lack of total experience in this type of aircraft and his failure to maintain directional control during an aborted takeoff. A factor was the ditch.NTSB IAD98LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Princeton, NJA stuck carburetor float which restricted fuel flow to the engine that resulted in a loss of engine power.NTSB MIA98LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Columbia, SCThe pilot's inadequate preflight planning, and his poor in-flight decision making.NTSB MIA98LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Clarksville, FLthe pilot's improper flare and touchdown.NTSB SEA98LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Vashon, WAA misjudged soft field takeoff. Factors include wet grass.NTSB ATL97LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bennettsville, SCfailure of the pilot to properly plan his approach, and his failure to attain a proper touchdown point for landing.NTSB CHI97LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fessenden, NDthe pilot's premature liftoff and/or failure to abort the takeoff while there was sufficient runway remaining.NTSB ATL97LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Daytona Beach, FLfailure of the pilot of N7617F to comply with an ATC instruction to hold short of a taxiway, and failure of the pilots in both airplanes to see-and-avoid each other's airplane.NTSB ATL97LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sophia, NCimproper maintenance performed by an unknown person, which resulted in the reduction of airflow through the engine induction system and subsequent loss of engine power. A factor related to the accident was: failure of the pilot to attain a proper touchdown…NTSB FTW97LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Brownsville, TXthe pilot's failure to refuel the airplane which led to fuel exhaustion and subsequent loss of engine power. Factors were the pilot's lack of preflight planning and the lack of suitable terrain for the forced landing.NTSB SEA97LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bruneau, IDthe pilot's failure to perform adequate preflight planning to ensure that the aircraft could complete a takeoff in the distance available. Factors relating to the accident included: a short takeoff area, and a dirt bank at the end of the road from which the…NTSB FTW96LA401Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Falcon, COFailure by the pilot to select suitable terrain for landing. Factors were inadequate preflight planning and preparation for the flight by the pilot by failing to check NOTAMS and failing to use communication aids available to him.NTSB CHI96LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · New Melle, MOthe pilot's selection of an unsuitable area for an emergency/precautionary landing. Factors relating to the accident were: the pilot's continual operation of the airplane with a known deficiency (broken trim switch); an uncommanded activation of the elevator…NTSB FTW96LA266Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Abilene, TXfuel mismanagement by the pilot, which resulted in fuel starvation; and the pilot's failure to reposition the fuel selector (follow emergency procedure) while attempting to restart the engine. A factor relating to aircraft damage was: concrete debris (rocks)…NTSB FTW96FA183Accident · 4 fatalField investigationFinal reportPiper PA-28-151 · Vera, OKimproper installation by unknown person(s) of incorrect exhaust system clamps, which led to an exhaust system disconnect and a subsequent engine compartment fire.NTSB MIA96FA116Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Kissimmee, FLthe pilot's improper planning/decision, which resulted in fuel starvation and a forced landing in a residential area. A factor relating to the accident was: the inaccuracy of the expected fuel consumption.NTSB ATL96LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Columbia, TNthe student pilot's improper recovery from a bounced landing and his failure to maintain directional control. A factor was the improper level-off.NTSB CHI96FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Fond Du Lac, WIthe pilot's intentional VFR flight into instrument meteorological conditions, and his failure to maintain altitude. Factors included the weather obscuration due to snow and fog, the dark night, and the pilot's lack of recent night flight time.NTSB NYC95LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Warminster, PAthe pilot's improper positioning of the fuel selector which resulted in a total loss of engine power due to fuel starvation. A contributing factor was pilot distraction.NTSB SEA95LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Panguitch, UTthe pilot's misjudgment of the distance from the sign post.NTSB LAX95LA265Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · San Luis Obispo, CAthe pilot's failure to lower the flaps to the correct short field takeoff setting as specified in the aircraft's Pilot Operating Handbook.NTSB LAX95LA199Accident · 3 fatalLimited investigationFinal reportPiper PA-28-151 · Honolulu, HIfuel exhaustion resulting from pilot's inadequate preflight fuel planning for the over water flight.NTSB CHI95FA149Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · North Loup, NEFailure to the student pilot to maintain control of the airplane during a forced landing, after experiencing fuel starvation due to fuel mismanagement. Factors relating to the accident were: inadequate oversight (supervision) by the flight instructor (CFI),…NTSB LAX95LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Parker, AZthe failure and separation of the No. 2 cylinder exhaust valve. Darkness was a factor in the accident.NTSB NYC95LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Farmingdale, NYthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane veering off the left side of the runway. A factor was the pilot's failure to abort the takeoff.NTSB NYC95LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Wilmington, OHThe flight instructor's inadequate supervision of the student pilot during the approach, resulting in a loss of control and hard landing. The gusty wind condition was a factor.NTSB ATL95LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Orange Beach, ALA loss of engine power for undetermined reasons.NTSB ATL95LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Foley, ALAn engine fire for undetermined reasons.NTSB ATL95FA008Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Conway, SCThe pilot's failure to maintain a proper altitude during the missed approach, resulting in a collision with trees and terrain. Factors were the weather conditions (low ceiling, fog), and the pilot's diverted attention outside the cockpit.NTSB LAX94LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Simi Valley, CAThe student pilot's failure to properly align the airplane's flightpath over the runway during initial climb. A contributing factor was the student pilot's total lack of recent flying experience.NTSB LAX94LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sonoma, CAThe pilot's failure to attain the proper touchdown point and his failure to initiate a go-around.NTSB MIA94LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Boca Raton, FLThe failure of the dual student to maintain directional control during landing and the failure of the flight instructor to properly supervise the dual student and take corrective action in a timely manner.NTSB ATL94LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Jasper, ALLoss of engine power for undetermined reasons.NTSB FTW94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mckinney, TXThe pilot's improper approach angle.NTSB MIA94FA030Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Daytona Beach, FLLoss of aircraft control for an undetermined reason.NTSB BFO94LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Greentown, PAThe pilot's selection of the wrong runway, and his delay in attempting a go-around which resulted in an inflight collision with the trees. A related factor was the unfavorable wind.NTSB CHI94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Allendale, MIImproper in-flight planning/decision by the pilot, after encountering unfavorable winds and a low fuel level, which resulted in fuel exhaustion. The unfavorable wind was a related factor.NTSB BFO93LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Painesville, OHThe pilot's attempt to land with excessive airspeed, his improper use of the brakes, and his delay in performing remedial action.NTSB FTW93LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Tulsa, OKThe loss of engine power and engine fire for undetermined reasons.NTSB ATL93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Lafayette, GAThe failure of the pilot to maintain control of the aircraft.NTSB NYC93LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Farmingdale, NYThe pilot's inadequate compensation for wind conditions and failure to maintain control of the airplane. The crosswind was a related factor.NTSB BFO93LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Monticello, MEA disconnection of the fuel line, which resulted in fuel starvation and loss of engine power. A related factor was the lack of suitable terrain for an emergency landing.NTSB NYC93LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · New Cumberland, PAThe loss of engine power for undetermined reasons, resulting in a forced landing in the river.NTSB CHI93LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Manhattan, ILInadequate compensation for wind conditions by the pilot.NTSB BFO93LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Willimantic, CTA cracked no. 2 engine cylinder, and the pilot's failure to attain the proper touchdown point during the forced landing, due to excessive airspeed, which resulted in an overrun of the runway. A factor related to the accident was an improper weld repair on the…NTSB ATL92FA185Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Samantha, ALThe pilot's inadequate preflight planning and preparation, his lack of expereince, which resulted in an encounter with instrument weather conditions during an attempted visual flight, and his subsequent spatial disorientation. Factors were the dark night…NTSB BFO92LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Mount Holly, NJA loss of engine power for undetermined reasons.NTSB LAX92LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Compton, CAThe improper maintenance of the alternator's drive belt by the aircraft owner which resulted in its total failure. A factor which contributed to the accident was the inadequate distance available for the pilot to stop the airplane.