Skip to content

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

24 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

19722026

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" = 'NY' 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\" = 'NY' 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" = 'NY' 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 ERA22LA067Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Glens Falls, NYA total loss of engine power for reasons that could not be determined.Nov 19, 2021 · N2305T · Substantial damage NTSB ERA10FA074Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Wappinger, NYA total loss of engine power due to a delamination of the No. 3 connecting rod bearing. Contributing to the accident was the inadequate maintenance inspection of the engine oil system.Nov 22, 2009 · N345AT · Substantial damage NTSB NYC02LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Cattaraugus, NYA separation of the cylinder from the engine for undetermined reason(s). A factor was the hidden ground obstruction (hole) which the airplane struck during the landing roll.Nov 11, 2001 · N3057R · Substantial damage NTSB NYC97LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Frankfort, NYThe pilot's misjudgment of distance and speed on final approach, and his failure to attain the proper touchdown point during landing. A factor in the accident was the night light condition.Jun 28, 1997 · N8139C · Substantial damage NTSB NYC96LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lake Placid, NYthe pilot's failure to maintain directional control during the landing, and subsequently the airplane veered off the runway.Nov 25, 1995 · N5030S · Substantial damage NTSB NYC94LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · White Plains, NYThe partial loss of engine power as the result of a disconnected throttle cable, and the subsequent forced landing and ditching in water to avoid collision with trees.Apr 4, 1994 · N5335T · Substantial damage NTSB BFO93LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Babylon, NYThe loss of engine power due to the intake valve failure.Mar 22, 1993 · N56153 · Substantial damage NTSB NYC93LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Akron, NYThe failure of the pilot to compensate for adverse winds and wind shear. A factor related to the accident was the adverse wind conditions.Oct 2, 1992 · N9242K · Substantial damage NTSB BFO92LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Spencerport, NYThe pilot's inadequate flare which resulted in a hard landing.Jul 26, 1992 · N4389X · Substantial damage NTSB NYC90FA030Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · New Castle, NYThe pilot failed to maintain proper altitude and alignment with the ILS during the ILS approach and failed to perform the missed approach.Nov 16, 1989 · N55399 · Destroyed NTSB NYC86LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Westhampton Bch, NYThe instrument instructional flight returned to the airport late at night and successfully completed two instrument approaches with missed approaches. The pilots had been advised of a low layer of fog on the airport. On the third and final approach, after…Apr 15, 1986 · N4559X · Substantial damage NTSB NYC85LA114Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Montgomery, NYThe acft made a forced landing after the manifold pressure kept dropping. Some adjustment was made by throttle application and finally alt air was used. When the plt decided that the arpt could not be reached he landed on a highway. The left & nose gear…May 3, 1985 · N9439N · Substantial damage NTSB NYC84LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Monticello, NYAccording to the plt, he was flying instrument approaches to touch and go landings and neglected to extend the landing gear. The automatic gear extension system extended the left main gear before the acft landed.Sep 5, 1984 · N4363T · Substantial damage NTSB NYC81DHM08Accident · No injuriesClosedPiper PA-28R · La Grangeville, NYMay 27, 1981 · N74HB · Substantial damage NTSB NYC79FFA13Accident · No injuriesClosedPiper PA-28R · Utica, NYFeb 13, 1979 · N55069 · Substantial damage NTSB NYC78DHJ05Accident · No injuriesClosedPiper PA-28R · Amityville, NYJan 31, 1978 · N33770 · Substantial damage NTSB NYC78FFJ06Accident · No injuriesClosedPiper PA-28R · Binghampton, NYNov 9, 1977 · N43731 · Substantial damage NTSB NYC77FA098Accident · 2 fatalClosedPiper PA-28R · Montauk Point, NYSep 16, 1977 · N2375T · Destroyed NTSB NYC77FHG19Accident · No injuriesClosedPiper PA-28 · Amityville, NYMay 1, 1977 · N33770 · 2 aircraft · Substantial damage NTSB NYC75AN096Accident · 1 fatalClosedPiper PA-28R · Mastic, NYApr 5, 1975 · N55710 · Substantial damage NTSB NYC75FHJ16Accident · No injuriesClosedPiper PA-28R · N Amityville, NYOct 1, 1974 · N333RG · Substantial damage NTSB NYC75FFJ06Accident · Serious injuriesClosedPiper PA-28R · Skaneateles, NYAug 8, 1974 · N2604R · Substantial damage NTSB NYC75FFA25Accident · Serious injuriesClosedPiper PA-28R · Hoosick Falls, NYApr 5, 1974 · N15028 · Substantial damage NTSB NYC73AN063Accident · 1 fatalClosedPiper PA-28R · Mariaville, NYNov 4, 1972 · N3075R · Destroyed