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 ATL94LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Maryville, TNThe pilot's inadequate inflight planning, which resulted in fuel exhaustion prior to reaching the planned destination.NTSB FTW94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fredericksburg, TXThe pilot's utilization of unsuitable terrain for takeoff.NTSB FTW94FA014Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Texarkana, ARThe pilot's continued VFR flight into instrument meteorological conditions. Factors that contributed to the accident were: the pilot's failure to obtain a weather briefing, the existing weather, his lack of instrument flying experience, and the dark night…NTSB CHI94LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Cheboygan, MIInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to and inadequate supply of fuel. Factors related to the accident were: the lack of suitable terrain for a forced landing, and trees in the emergency landing area.NTSB LAX93LA373Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lompoc, CAwas fuel starvation. A factor in the accident was the mechanic's inadequate inspection of the airplane.NTSB ATL93LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Roxboro, NCThe pilot's inadequate compensation for the wind conditions at the time of the takeoff. Factors were the wind gusts and windshear existing at the airport.NTSB ATL93FA150Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stone Mountain, GAThe pilot-in-command's improper use of the aircraft stabilator during the takeoff, and his failure to maintain airspeed, which resulted in an inadvertant stall. A factor was the high obstructions (trees) located near the departure end of the runway.NTSB BFO93LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28 · New Carlisle, OHThe pilot's delay in aborting the takeoff, and his failure to maintain directional control during the aborted takeoff.NTSB FTW93LA247Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grand Prairie, TXThe fuel exhaustion induced power loss, the pilot's miscalculation of the amount of fuel required for the flight, and his failure to refuel. Factors were the dark night conditions and the lack of suitable terrain onto which a forced landing could be executed.NTSB CHI93LA326Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Marshall, MNThe pilot's improper decision to depart after receiving a weather briefing which forecasted IMC en route and his loss of aircraft control due to spatial disorientation.NTSB BFO93FA138Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Clearfield, PAThe pilot's failure to maintain airspeed during the go-around.NTSB CHI93LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sparta, MIthe separation of the rear landing light gasket into the air induction path.NTSB BFO93LA134Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Belmar, NJThe pilot's inadequate compensation for wind and failure to maintain directional control during landing. Other related factors were the crosswind and the ravine.NTSB ATL93FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Clayton, ALInadequate maintenance and inspection of the carburetor by maintenance personnel.NTSB NYC93LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Louisville, KYA partial power loss of undetermined origin while operating over unsuitable terrain.NTSB SEA93LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wendover, UTThe student pilot's selection of a closed runway for landing. Factors contributing to the accident were the student pilot's anxiety and the rough landing surface.NTSB FTW93LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hondo, TXThe pilot's improper evaluation of the weather which led to the downwind takeoff. Factors were the windshift and the tailwind.NTSB NYC93LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Gordonsville, VAWas a power loss due to fuel contamination, after the pilot refueled from cans and did not filter the fuel according to recommendations.NTSB BFO93LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Canton, KYThe pilot's inadequate preflight planning when determining his fuel load, which led to an exhaustion of the airplane's fuel supply.NTSB CHI93FA171Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Hubbardston, MIThe pilot's failure to maintain airspeed due to alcohol impairment while maneuvering at low altitude.NTSB BFO93LA085Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Paintsville, KYFailure of the pilot to maintain adequate altitude or clearance from the terrain. Factors related to the accident were the unfavorable wind condition and the proximity of the hill to the runway.NTSB LAX93LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Reedley, CAA failure of the pilot to maintain proper runway alignment and improper remedial action during the balked landing. A factor in the accident was a lack of total aeronautical experience.NTSB CHI93FA161Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Paoli, INThe pilot-in-command's inadequate preflight preparations and his failure to maintain airspeed. Factors were the instructor's inadequate training of the pilot-in-command, unqualified maintenance personnel's inadequate inspection of the aircraft and the…NTSB DEN93FA042Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Falcon, COInadequate supervision of the student pilot by the flight instructor. Factors were: IMC weather conditions, dark night, inaccurate weather evaluation by both the flight instructor and student pilot, and inadequate training of the student pilot.NTSB BFO93FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edgewater, MDThe pilot's improper in-flight planning/decision after selecting the wrong runway for a precautionary landing , which resulted in an inadvertent descent into transmission lines, while attempting to maneuver back to the runway. Factors related to the accident…NTSB MIA93FA082Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Kissimmee, FLThe pilot-in-command's attempt to climb at a high pitch attitude after takeoff and his failure to maintain airspeed which resulted in a stall mush condition until the aircraft descended to the ground. Contributing to the accident was the pilot-in-command's…NTSB CHI93FA103Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Newton, IAVFR flight into IMC conditions. Factors related to the accident were fog, and the pilot's lack of total instrument time.NTSB MIA93LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bunnell, FLThe rupture of the oil cooler line at the adel clamp for undetermined reasons, resulting in a loss of engine oil, and a subsequent engine seizure.NTSB MIA93FA058Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Brilliant, ALThe pilot-in-command's intentional flight into adverse weather which resulted in a loss of control. In addition, the pilot was overconfident in his ability. Factors which contributed to the accident were the weather conditions and the dark night.NTSB FTW93LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Slaton, TXThe total loss of engine power due to fuel starvation as a result of improper fuel tank selection. A factor the unsuitable terrain.NTSB LAX93LA059Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lost Hills, CAThe pilot's poor preflight planning/preparation, poor fuel consumption calculations, and delay in effecting any remedial action. Contributing to this accident was the pilot inadvertently becoming Lost/disoriented and the dark night.NTSB BFO93LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Caldwell, NJInadequate supervision by the instructor, and his delay in initiating a go around.NTSB CHI93FA038Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Brookfield, WISpatial disorientation, and failure to maintain proper glidepath.NTSB BFO93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Griswold, CTThe pilot's improper planning or decision, by not either using all available runway or making a go around. The wet grass condition of the airstrip was a related factor.NTSB CHI93LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ames, IAThe pilot exceeded the aircraft's maximum gross weight limitation which resulted in the failure to obtain a proper climb rate after takeoff.NTSB NYC93LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Woodstown, PAThe pilot's improperly planned approach and delayed decision to initiate a go-around, which resulted in a touchdown too FAR down the runway and the subsequent collision with a ditch. A factor related to the accident was the pilot's lack of recent flight…NTSB NYC93LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Grove City, PAThe pilot raised the flaps prematurely, resulting in an inadvertent stall at to low an altitude to allow recovery.NTSB LAX93FA011Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Rosemead, CAThe pilot's poor preflight planning/preparation and intentional flight into instrument meteorological conditions. Factors relating to this accident were the prevailing low ceiling and fog.NTSB FTW92LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sallisaw, OKTotal loss of power from a seized oil pump and resulting oil starvation to the engine. Factors were the noncompliance with an engine service bulletin and the dark night condition.NTSB MIA92LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Oak Hill, FLFailure of the pilot-in-command to level off during the simulated forced landing.NTSB LAX92LA369Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Atwater, CAThe partial loss of engine power for undetermined reasons and the pilots failure to attain the proper touchdown point during the subsequent forced landing attempt back on the runway. Factors in the accident were the tail wind condition encountered during the…NTSB CHI92LA255Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Marseilles, ILThe pilot-in-command's failure to abort the takeoff. A factor was the partial loss of engine power.NTSB ATL92LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Greensboro, NCThe failure of the pilot in command to maintain control of the airplane, and his improper use of the rudder during a go-around.NTSB SEA92LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pacific City, ORThe pilot selected the wrong runway relative to the wind and then delayed in aborting the landing. The tailwind was a factor.NTSB ATL92LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocracoke, NCThe student pilot's failure to maintain directional control during the landing roll. Factors were the pilot's lack of recent total experience, and the crosswind conditions, and the dirt bank adjacent to the runway.NTSB FTW92LA191Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · N. Little Rock, ARThe pilot's inadvertent entry into a stall.NTSB FTW92LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rector, ARThe pilot's premature liftoff.NTSB CHI92LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Rockford, ILThe flight instructor's premature liftoff. Related factors are the instructor's lack of total experience in the accident make and model airplane, and the unsuitable terrain encountered during the roll-out.NTSB NYC92LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Danville, NYThe decision by the pilot to land during a heavy rain shower, which resulted in a long landing, and his attempted takeoff with insufficient available runway and subsequent loss of airplane control.NTSB SEA92LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Monarch, MTThe pilot in command's disregard of the weather forecast and failure to maintain clearance with trees/terrain. Factors contributing to the accident were: hilly/mountainous terrain, weather conditions: rain, low ceilings and downdrafts, trees and the pilot in…