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 MIA92LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Miami, FLTotal loss of engine power due to improper placement of the fuel selector by the pilot-in-command following partial loss of engine power due to partial blockage of a fuel line. Contributing to the accident was the dark night condition and improper maintenance…NTSB CHI92LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Osage City, KSThe pilot's failure to maintain directional control. Factors in the accident were the rough/uneven runway surface and the inadequate maintenance of the runway surface.NTSB CHI92LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140D · Markham, ILThe result of an inadequate annual inspection by other maintenance personnel and, as a result, a total failure of the throttle linkage. A factor was the pilot overshot his intended emergency landing area, due to excessive speed.NTSB ATL92FA076Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Young Harris, GAThe failure of the pilot to maintain clearance from terrain. Factors in the accident were the dark night, rain, and mountainous terrain.NTSB NYC92FA073Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Paris, OHThe failure of the pilot to maintain directional control which resulted in the airplane flying over higher terrain with a climb rate that was insufficient to clear the obstacles. Factors related to the accident were the pilot's lack of total experience and…NTSB LAX92LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Woodland, CAThe company maintenance personnel's inadequate 100-hour inspection and failure to replace the oil line. Contributing to the accident was the rupture of the oil line and the ditch that traversed the emergency landing area.NTSB CHI92LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Sandstone, MNThe collision with the deer, the damage to the gascolator which resulted from the collision and the pilot's decision to abort the landing after the collision.NTSB FTW92LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Denton, TXFouled spark plugs, loose spark plug ignition lead, exhaust leak, and cylinder leak. Factors were an inadequate annual inspection, poor maintenance, and operation by the pilot with known mechanical deficiencies.NTSB SEA92LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Newberg, ORA poorly planned final approach. Factors in the accident were: proper glidepath was not maintained and inadequate remedial action.NTSB ATL92FA032Accident · Serious injuriesField investigationFinal reportPiper PA 28-140 · Blythe, GAThe pilot's failure to apply carburetor heat during the before takeoff check as part of the ground check. A factor was weather conditions favorable for the formation of carburetor ice.NTSB DEN92LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Yuma, COThe pilot's failure to maintain aircraft control. Factors were: an improper flare and lack of total flight time.NTSB NYC92LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Goshen, NYThe loss of engine power resulting from the ingestion of a foreign object into the carburetor and the subsequent forced landing in trees. A factor related to the accident was the maintenance performed on the airplane by unauthorized personnel.NTSB MIA92LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lawrenceville, GAThe separation of numbers 1,2, and 3 connecting rods for undetermined reasons resulting in loss of engine power.NTSB CHI92LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Carthage, MOContinued flight by the pilot into known icing conditions, and his improper planning/decision, which resulted in an overrun of the runway after he diverted to an alternate airport. The adverse weather condition, icy runway, and chain link fence near the end…NTSB LAX92LA023Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Chiriaco Summit, CAThe delayed actions of the pilot-in-command in selecting a go-around ND subsequent loss of directional control which resulted in the airplane drifting off the runway centerline and colliding with terrain. Contributing to the accident was failure of the pilot…NTSB DEN92LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Berryville, ARA power loss for undetermined reasons. Factors were: incorrect fuel, improper maintenance, and inadequate maintenance inspection interval.NTSB CHI92FA013Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Lafayette, INFailure of the pilot to compensate for wind conditions during initial climb. Factors associated with the accident are crosswind conditions and a dark night light condition.NTSB SEA92LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Renton, WAA loss of engine power for undetermined reasons and unsuitable terrain available for a forced landing.NTSB MIA92LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tylertown, MSOil fouling of the windshield due to a loose engine oil seal. A factor was the pilot's preexisting vision impairment.NTSB BFO92FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Chesapeake Bay, MDUndetermined. The aircraft wreckage has not been located.NTSB LAX92LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Santa Rosa, CAThe failure of the student pilot to maintain control of the aircraft during a recovery from a bounced landing.NTSB MIA92LA001Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Brooksville, FLThe pilot's inadvertent flight into IMC conditions, and his selection of unsuitable terrain for his attempted precautionary landing.NTSB MIA91FA227Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · West Palm Beach, FLThe pilot's improper use of the mixture control in that he failed to place it in full rich condition prior to takeoff. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB ATL91LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Greenville, SCThe dual student's improper positioning of the fuel tank selector handle, and the cfi's inadequate supervision of her student. A factor in this accident was: the cfi's lack of experience as a flight instructor.NTSB NYC91LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Johnstown, PAA collision with a deer while landing. A factor related to the accident was night conditions which restricted the pilot's view of the deer until it was within the illumination of the landing light.NTSB NYC91LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Somerville, NJAn off airport landing in unsuitable terrain following a power loss due to oil exhaustion. A factor related to the accident was the operators decision not to follow the recommendations of the Piper cherokee service manual.NTSB ATL91LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tullahoma, TNAn engine power loss for undetermined reasons.NTSB MIA91FA210Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Miami, FLThe failure of the pilot to adequately drain the fuel system of water. A contributing factor was the pilot's decision to continue the takeoff with a known deficiency. The pilot's selection of a forced landing area was poor in that a better landing area was…NTSB MIA91IA201Incident · No injuriesIncident investigationFinal reportPiper PA-28-140 · Clearwater, FLTotal loss of engine power due to fuel starvation caused by improper fuel tank selector position by the pilot-in-command. Contributing to the incident was the pilot's total lack of experience.NTSB NYC91FA205Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Wawayanda, NYThe pilot started a spin maneuver at too low an altitude to allow recovery. A factor in the accident was scattered clouds at 2500 feel MSL.NTSB CHI91LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Manning, IAThe pilot's improper selection of fuel tanks and improper in-flight emergency procedure by the pilot.NTSB CHI91LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Maple Lake, MNDirectional control was not maintained by the pilot. A factor related to the accident was the pilot's lack of total experience.NTSB SEA91FA170Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Driggs, IDThe pilot's poor inflight decision and his improper compensation for wind. Factors were rising, mountainous terrain; high, gusty winds; and a high density altitude.NTSB SEA91LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bryce Canyon, UTThe pilot's entry into a stall/mush condition shortly after take off. Contributing to the accident was the high density altitude.NTSB LAX91LA279Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Flagstaff, AZFailure of the pilot-in-command to properly lock the engine primer control which resulted in an over rich fuel to air mixture and subsequent loss of engine power.NTSB CHI91LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Vermillion, SDThe pilot's decision to operate the airplane with known deficiencies and an improper landing flare. Related factors are the use of automobile fuel, extreme temperatures and overshooting the planned landing approach.NTSB NYC91LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Endicott, NYThe failure of the pilot to attain the proper airspeed during an aborted landing, which resulted in a stall and loss of airplane control. Factors related to the accident were: the loss of directional control during landing, and the lack of recent flight…NTSB MIA91LA177Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Bay Saint Louis, MSLoss of control in flight due to premature flare by the pilot resulting in inadvertent stall/mush, and failure of the pilot to recover from the bounced landing.NTSB LAX91LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Pacoima, CAThe pilot's improper preflight planning/preparation and his failure to attain the proper altitude.NTSB CHI91LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grass Lake, MIA ruptured oil cooler line. A factor associated with the accident was the lack of suitable terrain for the precautionary landing.NTSB CHI91LA170Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Albany, MNThe cfi's failure to take timely and proper remedial action when the student pilot lost directional control during the takeoff roll. Factors in the accident are the tall grass edging the runway, and the student pilot's lack of total experience.NTSB LAX91LA226Accident · Serious injuriesLimited investigationFinal reportPiper PA28-140 · Truckee, CAThe failure of the pilot to maintain airspeed and the inadvertent entry into a stall mush which led to a loss of control and an uncontrolled descent. Factors in the accident were: the pilot's poor preflight planning and the high density altitude.NTSB ATL91FA099Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Surf Side Beach, SCThe improper preflight inspection of the aircraft by the pilot, in that he failed to turn the aircraft fuel selector 'on' prior to starting the engine. A factor in the accident was the aircraft fuel selector valve leaking enough fuel to the engine in the…NTSB FTW91FA084Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Folsom, LAThe inadvertent stall. Factors were the pilot's poor judgement in performing the buzzing maneuver and his lack of experience.NTSB MIA91LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Flamingo, FLPartial loss of engine power due to failure of the no. 3 cylinder exhaust valve for undetermined reasons. Contributing to the accident was lack of suitable terrain during the forced landing.NTSB CHI91LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hibbing, MNThe student pilot's improper flare of the airplane and the cfi's failure to maintain directional control during the recovery. A factor was the soft terrain.NTSB LAX91LA166Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Carefree, AZInadequate supervision by the certified flight instructor (CFI), an inadequate visual lookout by both pilots.NTSB FTW91LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tulsa, OKThe pilot's failure to maintain airspeed and altitude on final approach.NTSB FTW91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Davant, LAThe power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ANC91LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Talkeetna, AKWas the pilot-in-command's improper in-flight planning and decision. Contributing to the accident was the pilot's failure to refuel the airplane prior to the cross-country flight.