Skip to content

NTSB investigations: Piper PA-28-180, KY

22 cases on aircraft the registry lists as Piper PA-28-180. 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

19662026

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 ('7102808')) 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 ('7102808'))
  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 ('7102808'))
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 ERA23LA199Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Somerset, KYThe pilot’s failure to maintain control of the airplane during the takeoff, which resulted in a runway excursion and collision with an airport navigation antenna.Apr 8, 2023 · N2448R · Substantial damage NTSB ERA12CA277Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Georgetown, KYThe pilot's failure to maintain control of the airplane after engine start.Apr 10, 2012 · N9518J · Substantial damage NTSB ERA10CA214Accident · Serious injuriesData collectionFinal reportPiper PA28 · Louisville, KYA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.Apr 7, 2010 · N4247T · Substantial damage NTSB ERA10FA148Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Springfield, KYThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion, and the pilot's impairment due to alcohol. Contributing to the accident was the Federal Aviation Administration's failure to adequately oversee…Feb 23, 2010 · N7778W · Substantial damage NTSB BFO92LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Glasgow, KYDeer on the runway. Other related factor ws a dark night.Jan 2, 1992 · N40799 · Substantial damage NTSB ATL88FA138Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Bowling Green, KYPilot called fss on wrong freq. Another pilot answered & pilot req fss freq. He then called fss, rpted eng quit. Witness heard 'eng starting' momentarily overhead, watched acft pitch over, dive to gnd & impact with no attempt to flare for lnding. Pitch trim…Apr 11, 1988 · N32911 · Destroyed NTSB ATL87LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hazard, KYThe plt observed the rear of the upper engine cowling lift up shortly after takeoff and he became concerned that the cowling might come off the airplane during flight. The pilot attempted to maneuver the airplane back to the airport to land, the airplane…Jun 16, 1987 · N8021W · Substantial damage NTSB ATL85LA235Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Burnsdie, KYThe acft bounced during touchdown on a grass airstrip and veered off the left side of the rwy. Before proper alignment was gained the left wing struck a parked acft and both acft incurred substantial damage.Aug 3, 1985 · N4884L · Substantial damage NTSB ATL80FA078Accident · 3 fatalClosedPiper PA-28 · Pikeville, KYJul 26, 1980 · N8357W · Destroyed NTSB IAD80FA042Accident · 1 fatalClosedPiper PA-28 · Bowling Green, KYApr 22, 1980 · N32992 · Destroyed NTSB IAD80FA040Accident · 4 fatalClosedPiper PA-28 · Falmouth, KYApr 20, 1980 · N8907J · Destroyed NTSB IAD77FA034Accident · 3 fatalClosedPiper PA-28 · Glasgow, KYApr 13, 1977 · N7165W · Destroyed NTSB IAD76DLQ31Accident · No injuriesClosedPiper PA-28 · Frakes, KYAug 21, 1976 · N7709W · Substantial damage NTSB CHI72FLQ04Accident · No injuriesClosedPiper PA-28 · Somerset, KYAug 24, 1971 · N7977N · Substantial damage NTSB CHI71AC069Accident · No injuriesClosedPiper PA-28 · Louisville, KYMar 29, 1971 · N8878J · Destroyed NTSB CHI71FGJ03Accident · Serious injuriesClosedPiper PA-28 · Okolona, KYAug 20, 1970 · N2493R · Destroyed NTSB CHI71DGJ07Accident · No injuriesClosedPiper PA-28 · Hebbardsville, KYJul 13, 1970 · N2422Y · Substantial damage NTSB CHI70DGJ05Accident · No injuriesClosedPiper PA-28 · Glasgow, KYJan 22, 1970 · N2052R · Substantial damage NTSB CHI70D0216Accident · No injuriesClosedPiper PA-28 · Georgetown, KYSep 5, 1969 · N8477W · Substantial damage NTSB CHI69F0110Accident · No injuriesClosedPiper PA-28 · Hebron, KYJul 27, 1968 · N7326W · Substantial damage NTSB CHI68D0566Accident · No injuriesClosedPiper PA-28 · Madisonville, KYFeb 3, 1968 · N9708J · Substantial damage NTSB CHI67F0177Accident · Serious injuriesClosedPiper PA-28 · Williamstown, KYAug 21, 1966 · N9401J · Destroyed