Fatal NTSB investigations: Piper PA-28R-200, TX

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

Cases per year

19702026
Fatal NTSB investigations: Piper PA-28R-200, TX per year, 1970–2026: 17 cases
19701
19731
19752
19762
19771
19831
19861
19871
19901
19961
19971
19981
20051
20071
20161

Latest cases

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

NTSB CEN17FA063Accident · 3 fatalField investigationFinal reportPiper PA28R · McKinney, TXThe other pilot's use of an alternate traffic pattern entry procedure, which resulted in his inability to see and avoid the airplane, which was flying the preferred traffic pattern, and the subsequent midair collision.Dec 31, 2016 · N4407T · 2 aircraft · DestroyedNTSB DFW08FA031Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Ranger, TXThe pilot's intentional performance of aerobatic maneuvers that exceeded the design limits of the airplane structure.Nov 15, 2007 · N55307 · DestroyedNTSB DFW05FA099Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Jefferson, TXThe pilot's failure to maintain clearance from an unmarked transmission line. A contributing factor was the low altitude flight.Apr 10, 2005 · N2981R · DestroyedNTSB FTW99FA021Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Conroe, TXThe pilot's inadequate in-flight planning/decision which resulted in a loss of engine power due to fuel exhaustion. Factors were the dark night light conditions prevailing for the ensuing forced landing and the pilot's lack of experience in the make and model…Nov 8, 1998 · N4726R · Substantial damageNTSB FTW97FA122Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Westminster, TXThe pilot's failure to maintain clearance during an intentional low altitude maneuver. A factor was the transmission line.Mar 15, 1997 · N6219J · Substantial damageNTSB FTW97FA044Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Fort Worth, TXthe pilots' continued descent of the aircraft below decision height. Factors contributing to the accident were the fog, the dark night illumination, one of the pilot's impairment due to use of marihuana, and both pilots' fatigue.Nov 20, 1996 · N1394T · DestroyedNTSB FTW91FA010Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Kingsland, TXThe pilot's failure to avoid flying into the mountain.Oct 26, 1990 · N41586 · DestroyedNTSB FTW88FA038Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Burnet, TXThe pilot arrived in the area of his planned destination and completed the outbound and inbound procedure turns for the NDB runway 17 approach without reported incident. Almost immediately thereafter, the aircraft impacted a large oak tree about 15 feet AGL…Dec 19, 1987 · N33007 · DestroyedNTSB FTW87FA029Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Petersburg, TXAcft impacted in a 95 deg nose down attitude following a loss of control in IMC conditions while the non-instrument rated pvt plt was being vectored to the final app crs. Plt had filed IFR and had experienced difficulties thru out the flt. As he was given…Dec 7, 1986 · N4475F · DestroyedNTSB FTW83FA253Accident · 1 fatalField investigationFinal reportPiper PA28R200 · Decatur, TXAfter landing due to poor wx the pilot obtained a wx briefing during which he was told of a long line of thunderstorms 150 miles wide covering the area in which he was located. The pilot departed & then attempted to land at an airport 15 miles away in gusty…May 30, 1983 · N41761 · DestroyedNTSB UNK77X0104Accident · 1 fatalClosedPiper PA-28 · Gruver, TXApr 21, 1977 · N276V · DestroyedNTSB FTW77FA005Accident · 1 fatalClosedPiper PA-28R · Elmendorf, TXOct 18, 1976 · N5348T · DestroyedNTSB FTW76AF065Accident · 4 fatalClosedPiper PA-28R · Mont Belview, TXFeb 15, 1976 · N1542X · DestroyedNTSB FTW76AF051Accident · 1 fatalClosedPiper PA-28R · Abernathy, TXDec 23, 1975 · N16479 · DestroyedNTSB FTW75AF072Accident · 1 fatalClosedPiper PA-28R · Jasper, TXJun 13, 1975 · N5065S · DestroyedNTSB FTW73AF038Accident · 1 fatalClosedPiper PA-28R · Whiteface, TXJan 20, 1973 · N490CC · DestroyedNTSB FTW70AF047Accident · 4 fatalClosedPiper PA-28R · Stonewall, TXJan 9, 1970 · N3035R · Destroyed