Skip to content

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

21 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

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" = 'NJ' 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\" = 'NJ' 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" = 'NJ' 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 ERA17LA110Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Bayonne, NJMaintenance personnel’s incorrect installation of the No. 3 cylinder’s hydraulic valve tappet plunger, which resulted in a failure of the No. 3 cylinder’s intake valve and the subsequent partial loss of engine power.Feb 19, 2017 · N15745 · Substantial damage NTSB ERA10LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hammonton, NJA total loss of engine power due to a blocked fuel vent.Nov 21, 2009 · N909CW · Substantial damage NTSB ERA10FA062Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Dennisville, NJThe non-instrument-rated pilot's decision to depart into known instrument meteorological conditions, which resulted in his spatial disorientation and overcontrol of the airplane and the subsequent in-flight structural failure. Contributing to the accident was…Nov 14, 2009 · N4499T · Substantial damage NTSB NYC06CA210Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · West Milford, NJThe pilot's inadequate compensation for the wind conditions, which resulted in a hard landing. A factor was the wind.Aug 23, 2006 · N4583T · Substantial damage NTSB IAD02LA006Accident · No injuriesLimited investigationFinal reportPiper PA-28-200 · Farmingdale, NJthe flight instructor's delayed remedial action to correct the pilot's lack of directional control during landing. A factor was the crosswind.Oct 25, 2001 · N1585X · Substantial damage NTSB NYC00LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mount Holly, NJEngine failure due to the disconnection of the intake manifold from the #3 cylinder, as a result of improper maintenance.Feb 16, 2000 · N4531F · Substantial damage NTSB NYC99LA203Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Berlin, NJA loss of engine power for undetermined reason(s).Aug 16, 1999 · N2721R · Substantial damage NTSB BFO92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Manville, NJThe pilot's failure to maintain obstacle clearance.Mar 21, 1992 · N9348N · Substantial damage NTSB NYC88LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Old Bridge, NJThe flight made a normal approach and touched down on runway 24. As the pilot applied pwr for takeoff due to the hazardous runway conditions, the pilot lost directional control and the left main landing gear impacted plowed snow at the edge of the runway.Jan 10, 1988 · N9317N · Substantial damage NTSB NYC84LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mount Holly, NJAccording to the plt, a windshear was encountered during the final approach at approximately 100 ft AGL. The acft descended rapidly and bounced at the approach end of the rwy, ascended approximately 30 ft into the air, landed again striking the left wing on…Mar 23, 1984 · N41724 · Substantial damage NTSB NYC83LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Teterboro, NJAcft collided with taxiway sign collapsing the right landing gear.May 18, 1983 · N2308T · Substantial damage NTSB NYC81DHD35Accident · No injuriesClosedPiper PA-28R · Robbinsville, NJAug 7, 1981 · N3978X · Substantial damage NTSB NYC80FHA12Accident · No injuriesClosedPiper PA-28 · Pittstown, NJMay 2, 1980 · N212BM · Substantial damage NTSB NYC78DHD02Accident · Minor injuriesClosedPiper PA-28R · Lakewood, NJDec 26, 1977 · N55846 · Substantial damage NTSB NYC77FHM23Accident · Minor injuriesClosedPiper PA-28R · Fairfield, NJAug 21, 1977 · N8591N · Substantial damage NTSB NYC75FHD43Accident · Serious injuriesClosedPiper PA-28R · Lindenwold, NJMay 7, 1975 · N41331 · Destroyed NTSB NYC75AN012Accident · 4 fatalClosedPiper PA-28R · Toms River, NJJul 25, 1974 · N43100 · 2 aircraft · Destroyed NTSB NYC74AN112Accident · 2 fatalClosedPiper PA-28R · Sparta, NJJun 18, 1974 · N2716R · Destroyed NTSB NYC74FHD35Accident · Minor injuriesClosedPiper PA-28 · Bridgeport, NJApr 29, 1974 · N56192 · Substantial damage NTSB NYC71FHD12Accident · Serious injuriesClosedPiper PA-28R · Marlton, NJJul 28, 1970 · N2997R · Destroyed NTSB NYC70F0023Accident · No injuriesClosedPiper PA-28R · Clifton, NJJun 4, 1969 · N9493N · Substantial damage