NTSB investigations: Piper PA-28R-200, NC

25 cases on aircraft the registry lists as Piper PA-28R-200. 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-200, NC per year, 1969–2026: 25 cases
1969	1
1970	1
1973	2
1975	1
1976	1
1977	2
1978	2
1979	1
1980	2
1982	1
1984	1
1985	1
1987	1
1988	2
1992	1
1995	1
1997	1
2004	1
2010	1
2020	1

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" = 'NC' 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 ('7102811')) 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\" = 'NC' 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 ('7102811'))
  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" = 'NC' 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 ('7102811'))
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 ERA20LA302Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Fletcher, NCA partial loss of engine power for reasons that could not be determined based on available evidence.Aug 27, 2020 · N9341N · Substantial damage NTSB ERA10LA370Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · New Bern, NCInadequate quality control at the fuel servo overhaul facility, which resulted in contamination of the fuel servo and a subsequent loss of engine power due to fuel starvation.Jul 20, 2010 · N8900E · Substantial damage NTSB ATL04CA091Accident · Minor injuriesData collectionFinal reportPiper PA-28R-200 · Delco, NCThe flight instructor's improper fuel management resulting in a loss of engine power due to fuel starvation. A factor was the flight instructor's failure to use the checklist.Apr 24, 2004 · N32891 · Substantial damage NTSB ATL97LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Winston Salem, NCthe pilot's inadequate compensation for wind conditions and failure to maintain directional cntrol of the airplane, which resulted in a ground swerve and collapse of the right main landing gear. The crosswind was a related factor.Feb 12, 1997 · N15013 · Substantial damage NTSB ATL95FA128Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCThe pilot's failure to follow proper IFR procedures by descending below the decision height. Factors relating to the accident were the weather conditions and the dark night.Jul 5, 1995 · N15743 · Destroyed NTSB ATL92FA047Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCThe failure of the pilot to follow instrument landing procedures by descending below the glide path of the instrument landing system. Factors in the accident were the low ceilings and fog at the airport at the time of the accident.Feb 19, 1992 · N33464 · Substantial damage NTSB ATL88FA185Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCA Piper PA-28R (lead acft, N44018) & a Cessna 172 (#2 acft, N737GU) were departing Raleigh-durham arpt on a formation flt to petersburg, VA. The Cessna plt (wingman) rprtd that drg takeoff & initial climb, the lead acft bgn to accelerate ahead of him. The…May 26, 1988 · N44018 · 2 aircraft · Destroyed NTSB ATL88FA081Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Barnardsville, NCJan 18, 1988 · N55WP · Destroyed NTSB ATL87FA174Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Asheville, NCDuring a personal night x-country VFR flight over mountainous terrain the plt was informed by ATC that vip level 3 and 4 thunderstorms were positioned across the intended flt path. The 128 hour non-instrument rated private plt acknowledged and continued the…Jun 19, 1987 · N900AJ · Destroyed NTSB ATL85FMG08Accident · Serious injuriesFinal reportPiper PA-28R-200 · Shuffletown, NCThe acft contacted a fence during a forced landing following a loss of pwr. The flt orginated at grand ledge, MI, at 1100 EST and an unscheduled landing was made at adrian, MI, because of wx. The flt departed adrian, MI, at 1320 EDT. The plt reported that…Sep 6, 1985 · N6102J · Destroyed NTSB ATL84IA135Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Clayton, NCDuring flt, the plt & a passenger noted a loss of eng power accompanied by a metallic sound. Subsequently, a wheels-up forced landing was made in a plowed field. An eng teardown revealed that the crankshaft, p/n 54297-1, had failed from fatigue. A…Mar 30, 1984 · N4999S · Minor damage NTSB ATL82DA028Accident · No injuriesFinal reportPiper PA-28R-200 · Gastonia, NCDuring flight, the engine surged and the propeller speed went to 3000 RPM. The pilot retarded the prop control, and maintained 2400 RPM. He proceeded to the Gastonia airport and landed without further incident. A ground run-up was made and all instruments and…Jan 5, 1982 · N2139T · Substantial damage NTSB ATL80FA097Accident · 1 fatalClosedPiper PA-28R · Troy, NCSep 11, 1980 · N4809T · Destroyed NTSB IAD80FLJ11Accident · No injuriesClosedPiper PA-28R · Raleigh Durham, NCMar 14, 1980 · N3061R · Substantial damage NTSB IAD79FLJ13Accident · Serious injuriesClosedPiper PA-28R · Raliegh, NCAug 21, 1979 · N3080R · Destroyed NTSB IAD78FA099Accident · 2 fatalClosedPiper PA-28R · Bolton, NCAug 26, 1978 · N41786 · Destroyed NTSB IAD78DKM07Accident · Serious injuriesClosedPiper PA-28 · West Jefferson, NCJan 20, 1978 · N44673 · Destroyed NTSB IAD77FLJ34Accident · Minor injuriesClosedPiper PA-28 · Beaufort, NCAug 22, 1977 · N33867 · 2 aircraft · Substantial damage NTSB IAD77JKM21Accident · No injuriesClosedPiper PA-28 · Greensboro, NCMay 8, 1977 · N56313 · Substantial damage NTSB IAD76FKM25Accident · Serious injuriesClosedPiper PA-28R · Banner Elk, NCJan 20, 1976 · N33314 · Destroyed NTSB IAD76DKM17Accident · No injuriesClosedPiper PA-28R · Winston Salem, NCNov 6, 1975 · N16361 · Substantial damage NTSB IAD74DKM12Accident · No injuriesClosedPiper PA-28R · Brevard, NCAug 18, 1973 · N22DB · Substantial damage NTSB IAD73FLJ28Accident · Serious injuriesClosedPiper PA-28R · Nags Head, NCApr 21, 1973 · N1262T · Destroyed NTSB IAD70AI052Accident · 1 fatalClosedPiper J3C-65 · Asheboro, NCMar 22, 1970 · N1112X · Destroyed NTSB IAD70F0065Accident · No injuriesClosedPiper PA-28R · Statesville, NCSep 16, 1969 · N9302N · Substantial damage