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 CEN20LA305Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · San Antonio, TXThe pilot’s improper decision to take off in an airplane over maximum gross weight and with a tailwind, which prevented the airplane from climbing.NTSB CEN20LA258Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Bridgeport, TXMaintenance personnel’s inadequate inspection, which resulted in a total loss of engine power due to a restricted air intake-induction system.NTSB ERA20LA121Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Mount Pleasant, TNA partial loss of engine power during initial climb due to carburetor icing that formed while idling on the ground for an extended amount of time. Contributing was the flight instructor's failure to perform the recommended ground checks before takeoff.NTSB CEN20CA089Accident · No injuriesData collectionFinal reportPiper PA28 · Sparta, MIThe student pilot's failure to maintain directional control while landing on the snow/slush-covered portion of the runway and the flight instructor's improper decision to allow the student to make his first solo flight from a snow/slush-covered runway.NTSB WPR20FA079Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Payson, AZThe pilot's decision to fly into a canyon with rising terrain, and his subsequent loss of aircraft control while maneuvering away from rising terrain.NTSB ERA20CA110Accident · Minor injuriesData collectionFinal reportPiper PA28 · Cortland, NYThe student pilot's failure to maintain the runway heading during takeoff, which resulted in impact with a snowbank and a subsequent nose-over.NTSB ERA20CA111Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Hanson, MAThe flight instructor's delayed remedial action, which resulted in his decision to perform an off field landing and the airplane's subsequent impact with terrain.NTSB CEN20FA038Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Evansville, INThe pilot’s failure to maintain control of the airplane.NTSB CEN19LA299Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Conroe, TXA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA19CA512Accident · No injuriesData collectionFinal reportPiper PA28 · Chickasha, OKThe student pilot's failure to maintain crosswind correction during landing and his subsequent loss of directional control during the landing roll, which resulted in a runway excursion and impact with uneven terrain.NTSB CEN19LA252Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Miami, FLThe flight instructor's and student pilot's inadequate preflight inspection of the fuel system for water contamination, which resulted in a loss of engine power during takeoff and subsequent forced landing.NTSB CEN19LA265Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Fairhope, ALFailure of the No. 3 exhaust valve and the subsequent loss of engine power due to engine operation with an excessively lean fuel mixture over a period of time.NTSB GAA19CA430Accident · No injuriesData collectionFinal reportPiper PA28 · Wasilla, AKThe pilot's improper landing flare, which resulted in an aerodynamic stall and subsequent hard landing, runway excursion, and collision with a sign.NTSB GAA19CA404Accident · No injuriesData collectionFinal reportPiper PA28 · SaipanThe pilot's failure to maintain directional control while exiting the runway, which resulted in a runway excursion and collision with taxiway lighting and runway signage.NTSB GAA19CA350Accident · No injuriesData collectionFinal reportPiper PA28 · Nowdoinham, METhe flight instructor's delayed decision to abort the takeoff from a wet, grass runway with insufficient runway remaining, which resulted in a runway overrun and the airplane going down an embankment.NTSB CEN19LA150Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · McKinney, TXThe pilot's loss of control during an attempted go-around in gusting crosswind conditions.NTSB GAA19CA272Accident · No injuriesData collectionFinal reportPiper PA28 · Maitland, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, the total loss of engine power, and subsequent impact with a car during an emergency landing on a road.NTSB ERA19FA164Accident · 1 fatalField investigationFinal reportPiper PA28 · Foley, ALA partial loss of engine power due to a stuck exhaust valve and the flight instructor's exceedance of the airplane's critical angle of attack following the loss of power, which resulted in an aerodynamic stall at low altitude.NTSB ERA19CA289Accident · No injuriesData collectionFinal reportPiper PA28 · Winder, GAThe student pilot’s loss of airplane control, the flight instructor's delayed remedial action, and the student's delay in relinquishing the flight controls, which resulted in the airplane striking a runway sign during a go-around.NTSB GAA19CA176Accident · No injuriesData collectionFinal reportPiper PA28 · Savannah, GAThe pilot's failure to conduct the engine starting procedures in accordance with the Pilot’s Operating Handbook, which resulted in an engine fire.NTSB GAA19CA131Accident · No injuriesData collectionFinal reportPiper PA28 · Williamsburg, VAThe pilot's excessive brake application during the landing roll, which resulted in a runway excursion and collision with a drainage culvert.NTSB WPR19LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Salt Lake City, UTA partial loss of engine power due to the mechanic’s failure to properly secure the throttle lever locking nut and cotter pin.NTSB WPR19LA050Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Santa Ana, CAA total loss of engine power due to a loose carburetor bowl.NTSB GAA19CA095Accident · No injuriesData collectionFinal reportPiper PA28 · Chino, CAThe flight instructor's failure to maintain directional control during landing.NTSB WPR19LA027Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Presidio, TXThe student pilot’s loss of control at low altitude during a forced landing, which resulted in impact with terrain and substantial damage to the right wing. A contributing factor in the accident was the loss of engine power for undetermined reasons.NTSB GAA19CA040Accident · No injuriesData collectionFinal reportPiper PA28 · Miami, FLThe student pilot's improper landing flare, which resulted in a hard landing.NTSB ERA19LA027Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Parker, COA partial loss of engine power during initial climb due to carburetor icing, and the pilot's failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB ERA19LA021Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Plant City, FLThe pilot’s failure to utilize carburetor heat in conditions conducive to the formation of carburetor icing, which resulted in a total loss of engine power.NTSB GAA18CA575Accident · Serious injuriesData collectionFinal reportPiper PA28 · Spokane, WAThe pilot’s improper retraction of the flaps during a go-around, which resulted in the airplane’s failure to climb and its subsequent collision with trees.NTSB GAA18CA553Accident · Minor injuriesData collectionFinal reportPiper PA28 · Spanish Fork, UTThe student pilot’s failure to maintain the runway heading during takeoff and the flight instructor’s decision to conduct primary flight instruction in an airplane without dual controls.NTSB GAA18CA542Accident · No injuriesData collectionFinal reportPiper PA28 · Chino, CAThe student pilot's failure to maintain lateral control during the aborted landing.NTSB GAA18CA546Accident · No injuriesData collectionFinal reportPiper PA28 · De Pere, WIThe pilot's improper decision not to abort the takeoff after the airplane encountered standing water on the runway, which decreased its speed and led to its subsequent inability to climb and resulted in a runway overrun.NTSB WPR18TA236Accident · Minor injuriesClass 3Final reportPiper PA28 · Mokuleia, HIA total loss of engine power due to fuel starvation as a result of the flight instructor's inadequate preflight inspection.NTSB CEN18LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Columbia, ILThe airplane's inability to climb due to reduced engine power as a result of insufficient compression in all cylinders and fouled spark plugs in the No. 2 cylinder while operating near its maximum gross weight.NTSB CEN18LA281Accident · No injuriesLimited investigationFinal reportPiper PA28 · Shreveport, LAThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR18LA173Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28-140 · Hartford, CTA loss of engine power for undetermined reasons because postaccident examination of the engine and fuel system did not reveal any anomalies that would have precluded normal operation, which led to the pilot’s forced landing and subsequent runway overshoot and…NTSB GAA18CA307Accident · No injuriesData collectionFinal reportPiper PA28 · Butler, KYThe pilot’s improper fuel management, which resulted in fuel starvation.NTSB ERA18FA150Accident · 1 fatalField investigationFinal reportPiper PA28 · Chesapeake, VAThe pilot's loss of airplane control due to spatial disorientation during the departure climb in instrument meteorological conditions.NTSB ERA18LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Edgewater, FLThe flight instructor's failure to maintain the appropriate glidepath to the runway, which resulted in a collision with trees and terrain during final approach.NTSB CEN18LA112Accident · No injuriesLimited investigationFinal reportPiper PA 28 · Mackinac Island, MIThe improper reinstallation of the right main landing gear by maintenance personnel which resulted in the separation of the landing gear and the subsequent abnormal runway contact during the landing.NTSB ERA18FA084Accident · 1 fatalField investigationFinal reportPiper PA28 · Bonifay, FLA partial loss of engine power due to a stuck exhaust valve. Contributing to the accident was the pilot's decision to operate an airplane with a known mechanical deficiency and his failure to fly an appropriate traffic pattern that would have allowed the…NTSB ERA18LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Meriden, CTThe pilot's inadequate preflight fuel planning and his improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA18CA102Accident · No injuriesData collectionFinal reportPiper PA 28 · Corona, CAThe student pilot and flight instructor’s failure to see and avoid powerlines during a simulated emergency landing, which resulted in a wire strike during a go-around.NTSB WPR18LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Odessa, FLA loss of engine power due to fuel starvation as a result of the pilot's inadequate planning and in-flight fuel management. Contributing to the accident was the pilot’s failure to follow proper procedures after the loss of engine power.NTSB GAA18CA038Accident · Minor injuriesData collectionFinal reportPiper PA28 · Batavia, OHThe pilot’s failure to apply carburetor heat in conditions conducive to carburetor icing, which resulted in a partial loss of engine power during landing.NTSB WPR17FA215Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Brinnon, WAThe flight instructor's failure to completely and properly evaluate the student pilot's incorrectly- planned flight, and his failure to use all available resources to maintain situation awareness during the flight, which resulted in controlled flight into…NTSB ERA17LA277Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Canton, GAMaintenance personnel's failure to ensure the proper throttle linkage travel clearance after the installation of an exhaust system.NTSB ERA17LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Pittstown, NJThe student pilot's improper decision to conduct a night flight and his failure to maintain adequate altitude during the approach, which resulted in controlled flight into trees and terrain. Contributing to the accident was the student pilot's lack of total…NTSB WPR17LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · Honolulu, HIA total loss of engine power during initial climb for reasons that could not be determined due to impact and fire damage.NTSB ERA17CA218Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Honesdale, PAThe pilot’s failure to maintain directional control during crosswind conditions.