Skip to content

NTSB investigations: Piper PA-28-140, KY

38 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19682026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'KY' AND c."eventCountry" = 'USA' AND 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

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.\"eventStateOrRegion\" = 'KY' AND c.\"eventCountry\" = 'USA'
    AND 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."eventStateOrRegion" = 'KY' AND c."eventCountry" = 'USA'
  AND 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

Run 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 ERA23LA105Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Paris, KYThe pilot’s loss of control after encountering changing wind conditions during the initial climb, which resulted in descent and collision with terrain.Jan 5, 2023 · N6111W · Substantial damage NTSB GAA18CA307Accident · No injuriesData collectionFinal reportPiper PA28 · Butler, KYThe pilot’s improper fuel management, which resulted in fuel starvation.May 27, 2018 · N95410 · Substantial damage 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.Aug 23, 2014 · N41224 · Substantial damage NTSB ERA11CA013Accident · Minor injuriesData collectionFinal reportPiper PA28 · Louisville, KYThe pilot's inadequate preflight fuel planning, which resulted in fuel exhaustion and loss of engine power.Oct 8, 2010 · N57302 · Substantial damage NTSB NYC06CA149Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Louisville, KYThe pilot's failure to maintain directional control during landing. A factor in the accident was the wet grassy runway.Jun 18, 2006 · N4812T · Substantial damage NTSB NYC01LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Elizabethtown, KYThe pilot's failure to maintain directional control during the takeoff roll.May 12, 2001 · N6899W · Substantial damage NTSB NYC94LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Falls Of Rough, KYThe pilot's inadequate tiedown and starting procedure which resulted in a runaway aircraft, which subsequently collided with a building.Mar 3, 1994 · N4487J · Substantial damage NTSB NYC93LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Louisville, KYA partial power loss of undetermined origin while operating over unsuitable terrain.Jun 20, 1993 · N1698J · Substantial damage 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.May 17, 1993 · N6943W · Substantial damage 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.May 13, 1993 · N6001U · Destroyed NTSB ATL89LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Deane, KYWhile en route to wise, Virginia from richmond, Kentucky on a pleasure flight, the airplane collided with trees on rockhouse mountain. The airplane was substantially damaged and the pilot and passenger were seriously injured. The fuel selector was found…Nov 9, 1988 · N98185 · Destroyed NTSB ATL87DLQ04Accident · No injuriesFinal reportPiper PA-28-140 · Falmouth, KYThe plt, with a pax, had been making touch and go landings at the LCL apt for about 40 min. The final t.o. was preceded by a full stop ldg. Shortly after lift off, the plt reptd that the acft lost pwr and he was unable to clear a tree at the top of a ridge…Aug 9, 1987 · N15468 · Destroyed NTSB ATL87LA216Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Eubank, KYThe plt reptd that he was planning a refuel stop at short airport near Eubank, KY. Short is a private strip and the owner stated that he did not have fuel available. The pilot reptd that when he was about five minutes away, the engine 'quit and he was unable…Jul 18, 1987 · N1324T · Substantial damage NTSB ATL85LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Nicholasville, KYThe acft crashed into a sewage treatment plant during an emergency landing after fuel exhaustion while on a personal flt. The plt indicated that the flt was 4 hours 10 minutes long. The acft fuel capacity is listed as 38 gals usable. The acft is certified for…Nov 26, 1984 · N4343F · Substantial damage NTSB ATL84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Somerset, KYDuring a x-wind landing the acft veered off the left side of the rwy contacting a wind sock tower with the left wing. The plt reported the airspeed on final was excessive and an over compensation was made for the x-wind during the landing. The plt reported…Sep 5, 1984 · N4825T · Substantial damage NTSB ATL81FA016Accident · 2 fatalClosedPiper PA-28 · Hopkinsville, KYNov 5, 1981 · N8227C · Destroyed NTSB ATL81FLQ13Accident · Serious injuriesClosedPiper PA-28 · Providence, KYMar 28, 1981 · N7241F · Substantial damage NTSB ATL80FLQ28Accident · Minor injuriesClosedPiper PA-28 · Morehead, KYSep 14, 1980 · N6481W · Destroyed NTSB IAD80FLQ17Accident · No injuriesClosedPiper PA-28 · Anchorage, KYApr 20, 1980 · N1744J · Substantial damage NTSB IAD77FLQ19Accident · Minor injuriesClosedPiper PA28 · Glasgow, KYJul 8, 1977 · N32285 · Substantial damage NTSB IAD76DLQ27Accident · No injuriesClosedPiper PA-28 · Williamsburg, KYJul 8, 1976 · N44534 · Substantial damage NTSB IAD76FLQ23Accident · No injuriesClosedPiper PA-28 · Richmond, KYJun 5, 1976 · N32219 · Substantial damage NTSB IAD76FLQ21Accident · No injuriesClosedPiper PA-28 · Jeffersontown, KYMay 1, 1976 · N7214F · Substantial damage NTSB IAD76DLQ06Accident · Minor injuriesClosedPiper PA-28 · Lake City, KYAug 4, 1975 · N9621W · Substantial damage NTSB IAD74FL043Accident · No injuriesClosedPiper PA-28 · Cynthiana, KYJun 22, 1974 · N563FL · Substantial damage NTSB IAD74DLQ37Accident · No injuriesClosedPiper PA-28 · Monticello, KYMay 27, 1974 · N55605 · Substantial damage NTSB CHI72DLQ43Accident · No injuriesClosedPiper PA-28 · Murray, KYJun 5, 1972 · N5990U · Substantial damage NTSB CHI72FLQ38Accident · No injuriesClosedPiper PA-28 · Georgetown, KYMay 18, 1972 · N2682T · Substantial damage NTSB CHI72AC069Accident · 3 fatalClosedPiper PA-28 · Walton, KYMar 4, 1972 · N98038 · Destroyed NTSB CHI72AC066Accident · 1 fatalClosedPiper PA-28 · Albany, KYFeb 16, 1972 · N1754T · Destroyed NTSB CHI72FLQ20Accident · No injuriesClosedPiper PA-28 · Elizabethtown, KYNov 14, 1971 · N7254F · Substantial damage NTSB CHI72AC028Accident · 1 fatalClosedPiper PA-28 · Adolphus, KYSep 25, 1971 · N9935W · Destroyed NTSB CHI70F0239Accident · Minor injuriesClosedPiper PA-28 · Frankfort, KYSep 3, 1969 · N1514J · Substantial damage NTSB CHI70D0023Accident · No injuriesClosedPiper PA-28 · Hardinsburg, KYJun 7, 1969 · N1520J · Substantial damage NTSB CHI69F0262Accident · Serious injuriesClosedPiper PA-28 · Burgin, KYSep 3, 1968 · N7016R · Destroyed NTSB CHI69A0004Accident · 1 fatalClosedPiper PA-28 · Hazard, KYJul 4, 1968 · N9804W · Destroyed NTSB CHI69D0035Accident · Minor injuriesClosedPiper PA-28 · Lewisburg, KYJun 12, 1968 · N4215J · Destroyed NTSB CHI68D0697Accident · No injuriesClosedPiper PA-28 · Cropper, KYApr 21, 1968 · N1514J · Substantial damage