NTSB investigations: Piper PA-28R-180, GA

14 cases on aircraft the registry lists as Piper PA-28R-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

19692026

NTSB investigations: Piper PA-28R-180, GA per year, 1969–2026: 14 cases
1969	1
1970	1
1972	1
1973	1
1975	1
1976	1
1981	1
1982	2
1992	1
1995	1
2008	1
2013	2

Where

Open the map

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" = 'GA' 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 ('7102809')) 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\" = 'GA' 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 ('7102809'))
  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" = 'GA' 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 ('7102809'))
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 ERA14FA002Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Tifton, GAThe noninstrument-rated pilot’s improper decision to continue visual flight rules flight into known instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.Oct 18, 2013 · N11ML · Destroyed NTSB ERA13LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Winder, GAA total loss of engine power due to a cracked fuel pump line fitting O-ring seal at the inlet to the engine driven fuel pump. Contributing to the accident was the failure of the aircraft operator to comply with the engine manufacturer’s recommended time…Jan 12, 2013 · N3898T · Substantial damage NTSB CHI08LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Wrightsville, GAThe pilot's failure to maintain control during takeoff. Contributing to the accident were the gusty winds.May 18, 2008 · N4553J · Substantial damage NTSB MIA96LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Covington, GAthe pilot's failure to divert to an alternate airport after recognizing a low fuel state existed and his delay to declare an emergency with ATC. Contributing to the accident was the unsuitable terrain encountered during the forced landing.Oct 13, 1995 · N3250R · Substantial damage NTSB ATL93FA026Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Blairsville, GAThe pilot's decision to continue the flight into adverse weather conditions which resulted in the inflight collision with high terrain. Factors were high wind and rain.Nov 20, 1992 · N7684J · Destroyed NTSB ATL82DA192Accident · No injuriesFinal reportPiper PA-28-180R · Carrollton, GADuring cruise flight the pilot smelled oil followed shortly thereafter by the engine oil pressure going to zero and then the engine failing. The pilot made a forced landing in a field where the left main gear collapsed after contacting a rock. Investigation…Jul 9, 1982 · N7550J · Substantial damage NTSB ATL82FA039Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Blairsville, GAThe aircraft departed atlanta, GA on a flight with no flight plan to an intended final destination of morristown, TN. However, during a weather briefing, the pilot had inquired about the tri-cities airport at bristol, TN. While en route, the aircraft crashed…Jan 18, 1982 · N4583J · Destroyed NTSB ATL81FA088Accident · 1 fatalClosedPiper PA-28R · Beach, GAJul 4, 1981 · N4512J · Destroyed NTSB MIA76AM062Accident · 4 fatalClosedPiper PA-28R · Kennesaw, GAFeb 12, 1976 · N3954T · Destroyed NTSB MIA76FKG37Accident · No injuriesClosedPiper PA-28R · Brunswick, GANov 29, 1975 · N3874T · Substantial damage NTSB MIA74AM011Accident · 2 fatalClosedPiper PA-28R · Nahunta, GAAug 1, 1973 · N10JJ · Destroyed NTSB MIA72FKG77Accident · No injuriesClosedPiper PA-28 · Fairburn, GAMar 1, 1972 · N4625J · Substantial damage NTSB MIA71FKG22Accident · Minor injuriesClosedPiper PA-28R · East Point, GAAug 20, 1970 · N3207R · Substantial damage NTSB MIA69D0399Accident · No injuriesClosedPiper PA-28 · Macon, GAFeb 2, 1969 · N7680J · Substantial damage