Skip to content

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

32 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

19712026

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" = 'PA' 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\" = 'PA' 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" = 'PA' 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 GAA15CA263Accident · No injuriesData collectionFinal reportPiper PA 28R-200 · Doylestown, PAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane. Contributing to the accident was the pilot's fatigue during the flight.Sep 7, 2015 · N1125X · Substantial damage NTSB ERA13LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Lock Haven, PAThe reinstallation of improper connecting rods at engine overhaul, which resulted in abnormal wear of the connecting rod bearings; while the bearings did not meet the manufacturer’s specifications, the use of the unapproved connecting rods more likely caused…Dec 23, 2012 · N2074T · Substantial damage NTSB NYC06FA156Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Philipsburg, PAThe pilot's failure to comply with the published instrument approach procedure, which resulted in controlled flight into trees. Factors in the accident were the low cloud ceiling, and dark night conditions.Jun 26, 2006 · N56246 · Destroyed NTSB NYC02LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Gettysburg, PAThe pilot's failure to accurately compute takeoff performance and his failure to establish a positive climb resulting in a collision with trees.Jun 11, 2002 · N9357N · Substantial damage NTSB NYC00LA098Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-200 · Lehighton, PAThe pilot's inadequate compensation for the crosswind. A factor in this accident was the gusty crosswind condition.Mar 26, 2000 · N55820 · Destroyed NTSB NYC97LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · West Chester, PAthe pilot's misjudgment of altitude and distance to the runway, which resulted in an undershoot and failure to reach the proper touchdown point. Rising terrain at the approach end of the runway was a related factor.Sep 6, 1997 · N4982S · Substantial damage NTSB NYC97LA089Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-200 · Pottstown, PAwas the flight instructor's diverted attention while standing on the wing behind a turning propeller, which resulted in his departure from the wing, forward into the turning propeller.May 11, 1997 · N56639 · Minor damage NTSB NYC97LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Thorndale, PAInadequate overhaul of the crankshaft that failed to detect fatigue cracks, which resulted in a total loss of engine power when the crankshaft separated in two.Jan 18, 1997 · N57010 · Substantial damage NTSB NYC96LA095Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-R200 · Forks Township, PAthe flight instructor's misjudgment of distance and altitude, and delay in performing remedial action.May 1, 1996 · N5030S · Substantial damage NTSB BFO95FA020Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Nesquehoning, PAthe non-instrument-rated pilot's poor in-flight decision to continue VFR flight into instrument meteorological conditions, at night, and his failure to maintain sufficient altitude to ensure clearance from obstructions/terrain. Related factors were the…Dec 13, 1994 · N33049 · Destroyed NTSB NYC82DA067Accident · No injuriesFinal reportPiper PA-28R-200 · Butler, PAApproximately 100 feet after touchdown a gust of wind lifted the left wing of the aircraft turning it into the wind. Directional control was lost and the aircraft collided with two parked aircraft. A PA-22, N54572, and an Ercoupe, N93552, both of which…Apr 1, 1982 · N2998R · Substantial damage NTSB NYC80FGM31Accident · No injuriesClosedPiper PA-28R · Monroeville, PASep 10, 1980 · N4822T · Substantial damage NTSB NYC80FHA10Accident · Minor injuriesClosedPiper PA-28R · Westrockhill, PAMay 3, 1980 · N5110S · Substantial damage NTSB NYC80FGT03Accident · No injuriesClosedPiper PA-28R · Still Creek, PANov 24, 1979 · N4524T · Substantial damage NTSB NYC78DHA32Accident · No injuriesClosedPiper PA-28 · Pottstown, PAAug 1, 1978 · N8669C · Substantial damage NTSB NYC78DHA13Accident · No injuriesClosedPiper PA-28R · E. Stroudsburg, PAJan 30, 1978 · N4081S · Substantial damage NTSB NYC78DHA08Accident · No injuriesClosedPiper PA-28R · Mt Pocono, PAJan 1, 1978 · N212BM · Substantial damage NTSB NYC78FA009Accident · 1 fatalClosedPiper PA-28R · North Wales, PANov 23, 1977 · N1018L · Destroyed NTSB NYC77FHD27Accident · Minor injuriesClosedPiper PA-28R · West Chester, PAAug 23, 1977 · N3932R · Substantial damage NTSB NYC77FGT10Accident · No injuriesClosedPiper PA-28R · Thomasville, PAMar 25, 1977 · N9495N · Substantial damage NTSB NYC77DHA08Accident · No injuriesClosedPiper PA-28R · Shultzville, PAOct 15, 1976 · N43731 · Substantial damage NTSB NYC76FGM14Accident · Minor injuriesClosedPiper PA-28R · Greenville, PADec 18, 1975 · N2766R · Substantial damage NTSB NYC76FGM16Accident · No injuriesClosedPiper PA-28R · Pittsburgh, PANov 30, 1975 · N3993X · Substantial damage NTSB NYC75FGM31Accident · Minor injuriesClosedPiper PA-28R · Butler, PAApr 2, 1975 · N56130 · 2 aircraft · Substantial damage NTSB NYC75FGM01Accident · No injuriesClosedPiper PA-28R · Pittsburgh, PAJul 24, 1974 · N4809T · Substantial damage NTSB NYC74FHA11Accident · Serious injuriesClosedPiper PA-28R · Lehighton, PAOct 8, 1973 · N3072R · Substantial damage NTSB NYC74FGT08Accident · No injuriesClosedPiper PA-28R · Deer Lake, PASep 21, 1973 · N2685R · Substantial damage NTSB NYC73FGM37Accident · No injuriesClosedPiper PA-28R · Washington, PAJun 11, 1973 · N4809T · Substantial damage NTSB NYC73FGT12Accident · No injuriesClosedPiper PA-28R · York Haven, PAMay 22, 1973 · N5012S · Substantial damage NTSB NYC73AN120Accident · 3 fatalClosedPiper PA-28 · Falls Creek, PAMar 6, 1973 · N2082T · Substantial damage NTSB NYC72FGM28Accident · No injuriesClosedPiper PA-28R · Central City, PAJan 16, 1972 · N2340T · Substantial damage NTSB NYC72AN051Accident · 1 fatalClosedPiper PA-28R · Washingtnville, PAOct 10, 1971 · N2941R · Destroyed