NTSB investigations: Piper PA-28-140
3,857 cases on aircraft the registry lists as Piper PA-28-140. 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 ('7102802'))
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 ('7102802'))
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 GAA17CA336Accident · No injuriesData collectionFinal reportPiper PA 28 · Auburn, INThe pilot’s decision to continue to attempt to take off despite the airplane’s inability to attain a positive climb rate, which resulted in little runway remaining, and his subsequent decision to turn off the runway, which resulted in a collision with a barn.NTSB GAA17CA322Accident · No injuriesData collectionFinal reportPiper PA28 · Gilbert, SCThe pilot's improper glidepath in variable wind conditions, which resulted in the airplane impacting terrain short of the runway threshold.NTSB CEN17LA341Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Ray, MIThe pilot's failure to maintain a proper approach speed, which resulted in in a hard landing and a runway excursion. Contributing to the accident was the pilot's decision to fly the airplane without an instructor onboard.NTSB CEN17LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Muskogee, OKThe pilot's improper in-flight fuel management, which resulted in a partial loss of engine power due to fuel starvation.NTSB WPR17LA092Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Whittier, CAThe pilot's impaired decision-making due to alcohol intoxication and his improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN17FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stonewall, TXThe pilot's failure to attain a proper touchdown point following a loss of engine power and his inability to stop the airplane on the short, soft runway. Contributing to the accident was the inadequate maintenance of the airplane by the owner and the mechanic…NTSB ERA17LA128Accident · No injuriesLimited investigationFinal reportPiper PA28 · Tampa, FLA collapsed engine induction duct, which resulted in restricted air flow to the engine and a subsequent loss of engine power. Contributing to the accident was the operator's failure to ensure that the correct induction duct was installed.NTSB GAA17CA157Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Weiser, IDThe student pilot’s failure to maintain directional control and to maintain clearance from a snow berm during the aborted landing.NTSB GAA17CA103Accident · Minor injuriesData collectionFinal reportPiper PA28 · Shreveport, LAThe pilot’s inadequate compensation for crosswind conditions during the go-around, which resulted in a loss of airplane control.NTSB GAA17CA149Accident · No injuriesData collectionFinal reportPiper PA28 · Palm Coast, FLThe pilot’s failure to maintain clearance from the taxiway sign.NTSB GAA17CA120Accident · No injuriesData collectionFinal reportPiper PA28 · St. Louis, MOThe student pilot's improper landing flare, which resulted in a bounced landing.NTSB ERA17LA057Accident · No injuriesLimited investigationFinal reportPiper PA28 · Columbus, GAA total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of any anomalies that would have precluded normal operation.NTSB GAA17CA035Accident · Minor injuriesData collectionFinal reportPiper PA 28 · Fresno, CAThe pilot’s exceedance of the airplane’s critical angle of attack during departure due to being distracted by looking for his phone.NTSB ERA17LA005Accident · No injuriesLimited investigationFinal reportPiper PA28 · Laurel, MSA total loss of engine power due to a stuck carburetor float. The reason the carburetor float became stuck could not be determined because postaccident examination of the float and needle/seat revealed no anomalies.NTSB ERA16FA324Accident · 3 fatalField investigationFinal reportCessna 120 · North Collins, NYThe failure of the second airplane's pilot to see and avoid the first airplane as he was overtaking the first airplane.NTSB CEN16LA382Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Wooster, OHA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA16CA490Accident · No injuriesData collectionFinal reportPiper PA 28 · Parkersburg, WVThe flight instructor’s delayed remedial action during the approach for landing, which resulted in impact with terrain short of the runway threshold. Contributing to the accident was the student pilot’s failure to maintain an appropriate descent rate during…NTSB GAA16CA359Accident · No injuriesData collectionFinal reportPiper PA28 · Amarillo, TXThe pilot's failure to attain an adequate rate of climb, which resulted in off airport landing and substantial damage to the fuselage and right wing.NTSB ERA16LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Hollywood, FLThe pilot’s inadequate preflight inspection of the fuel system, which resulted in a total loss of engine power due to water contamination.NTSB GAA16CA312Accident · No injuriesData collectionFinal reportPiper PA 28 · Gilmer, TXThe student pilot's failure to see and avoid powerlines during landing, and the flight instructor's delayed remediation when the student cut the base to final turn short, resulting in a wire strike and collision with terrain. Contributing to the accident was…NTSB CEN16FA212Accident · 3 fatalField investigationFinal reportPiper PA 28-140 · Wishek, NDThe pilot's failure to maintain adequate airspeed during a climbing turn after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's self-induced pressure to…NTSB ERA16FA186Accident · Serious injuriesField investigationFinal reportPiper PA28 · Homestead, FLThe pilot's improper decision to allow the passenger to attempt a landing, which resulted in a loss of control during landing with a quartering tailwind. Contributing to the severity of the pilot's injuries was the separation of the deteriorated shoulder…NTSB ERA16LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · Bayport, NYMaintenance personnel’s improper installation and maintenance of the fuel selector valve, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN16LA097Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Sturtevant, WIThe pilot's failure to maintain a proper glidepath during a landing at dusk, which resulted in impact with a moving ground vehicle. Contributing to the accident was the inoperative precision approach path indicator.NTSB GAA16CA077Accident · No injuriesData collectionFinal reportPiper PA 28 · California, MDThe student pilot's descent below the prescribed final approach path at night, and flight instructor's failure to correct the student pilot's descent, which resulted in a collision with trees and impact with the ground.NTSB WPR16LA033Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28-140 · Wickenburg, AZA partial loss of engine power due to a separation of the mixture control cable clamp, which was either not installed or secured correctly during maintenance.NTSB GAA16CA037Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Perry, NYThe student pilot's failure to maintain vigilance, which resulted in a loss of directional control during the landing roll.NTSB CEN16FA001Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Huntsville, TXThe pilot's mismanagement off the fuel supply to the engine, which resulted in fuel starvation.NTSB WPR15LA266Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Elko, NVThe pilot's failure to sufficiently lean the engine’s fuel-to-air mixture for the given density altitude, which resulted in reduced engine power output and the airplane’s inability to climb.NTSB ANC15LA069Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · North Pole, AKThe student pilot’s loss of directional control during landing with a tailwind, which resulted in a runway excursion and collision with trees.NTSB CEN15LA301Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · Oakdale, LAThe pilot's inadequate preflight planning resulting in the airplane not having adequate performance to climb and clear the trees off the end of the dirt runway.NTSB ERA15LA237Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Hampton, NHThe pilot’s failure to properly set the stabilator trim prior to takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.NTSB GAA15CA130Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Swanton, OHThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion, and a collision with a sign.NTSB WPR15LA164Accident · No injuriesLimited investigationFinal reportPiper PA28 - 140 · El Cajon, CAThe pilot's improper in-flight fuel management, which resulted in fuel exhaustion in the selected tank, and his delayed movement of the fuel selector handle to the other tank, which resulted in a loss of engine power due to fuel starvation.NTSB GAA15CA079Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Princeton, NJThe pilot's failure to maintain directional control during the landing, resulting in a runway excursion.NTSB WPR15FA152Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Mt Tom, ORThe noncertificated pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation leading to the pilot's loss of control of the airplane and subsequent collision with mountainous terrain.NTSB ERA15LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lancaster, NYThe loss of engine power during takeoff for reasons that could not be determined during postaccident examination of the engine or testing of the carburetor.NTSB ERA15FA171Accident · 2 fatalField investigationFinal reportPiper PA28 · West Chester, PAThe failure of the flight instructor and the pilot to abort the takeoff after the airplane experienced a partial loss of engine power with adequate runway remaining, and their subsequent failure to maintain adequate airspeed, which led to the airplane…NTSB ERA15FA170Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Orange, VAThe student pilot's failure to maintain adequate airspeed after takeoff, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN15CA158Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Kansas City, MOThe loss of engine power due to fuel starvation.NTSB ERA15FA128Accident · 1 fatalField investigationFinal reportPiper PA28 · Greensboro, NCA total loss of engine power after takeoff due to fuel starvation as a result of excessive wear of the fuel selector valve. Also causal was the owner/operator and maintenance personnel's inadequate maintenance, and inadequate postmaintenance inspection.NTSB WPR15LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Helena, MTLoss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any evidence of an anomaly that would have precluded normal operation.NTSB ERA15LA028Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Valley Point, WVUndetermined based on a lack of available information.NTSB ERA15CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Toccoa, GAThe private pilot's failure to maintain proper altitude and the flight instructor's failure to provide correction action, which resulted in a collision with terrain during landing.NTSB CEN14CA488Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Belen, NMThe student pilot's improper recovery from a bounced landing.NTSB CEN14CA481Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Plymouth, INThe sun glare and the pilot's subsequent loss of airplane control.NTSB ERA14CA407Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Taylorsville, KYThe pilot's decision to land on a wet runway and delayed go-around attempt, which resulted in a collision with terrain.NTSB CEN14CA410Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Beach, NDThe student pilot's failure to initiate a go-around sooner, and his failure to maintain directional control.NTSB CEN14CA378Accident · Serious injuriesData collectionFinal reportPiper PA 28-140 · Fort Worth, TXThe pilot's improper recovery from a bounced landing. Contributing to the accident was the deer on the runway and the pilot's mismanagement of airspeed which resulted in an aerodynamic stall.NTSB CEN14CA383Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · St. Louis, MOThe pilot's decision to operate an airplane with a known deficiency and to not properly secure the airplane before hand-starting the engine.