Skip to content

NTSB investigations: Piper PA-28-235, NY

17 cases on aircraft the registry lists as Piper PA-28-235. 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

19652026

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 ('7102810')) 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 ('7102810'))
  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 ('7102810'))
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 NYC95LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Poestenkill, NYthe pilot's decision to continue an approach during which the airplane was high and fast, and his improper recovery from a bounced landing. The pilot's failure to use the seat belt was a factor.Jul 22, 1995 · N9390W · Substantial damage NTSB NYC87FA021Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Jamestown, NYThe non-inst rated plt had received a telephone wx briefing prior to the planned flt. Marginal VFR wx was forecast for the route with vis 1/8 mile and fog. The acft was located aprx 24 hrs later in a heavily wooded area about 200 yds east of and parallel to…Oct 18, 1986 · N33808 · Destroyed NTSB NYC86LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Westport, NYThe Piper PA-28-235 made an off airport landing at night in conditions of reduced visibility, with rain, gusty winds and thunderstorms in the area. The aircraft received substantial damage and the pilot received serious injuries. Post crash examination of the…Jun 17, 1986 · N9094W · Substantial damage NTSB NYC86LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Mttituck, NYPilot states on landing flair the aircraft was tracking on a 190 degree heading for rwy 29 winds were from 260 pt 20 KTS on flair acft drifted approx 16 ft to the left and left wide extended beyond rwy making contact with shrubbry on the edge of the rwy. Acft…Dec 26, 1985 · N9409W · Substantial damage NTSB NYC85LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Batavia, NYThe acft was substantially damaged during a forced landing following a loss of pwr on initial takeoff climb. The plt reported that at an alt of aprx 100 ft AGL, the eng quit operating. A forced landing was made 100 yrds off the end of rwy 28. Inspection of…May 30, 1985 · N8966W · Substantial damage NTSB NYC81DFA05Accident · No injuriesClosedPiper PA-28 · Accord, NYNov 9, 1980 · N9392W · Substantial damage NTSB NYC78FA030Accident · Minor injuriesClosedPiper PA-28 · Farmingdale, NYMar 8, 1978 · N9394W · Substantial damage NTSB NYC76DHM03Accident · No injuriesClosedPiper PA-28 · Pawling, NYJun 6, 1975 · N8537W · Substantial damage NTSB NYC75FFJ03Accident · No injuriesClosedPiper PA-28 · Holley, NYJul 26, 1974 · N9047W · Substantial damage NTSB NYC74DFA14Accident · No injuriesClosedPiper PA-28 · Glens Falls, NYOct 8, 1973 · N8549W · Substantial damage NTSB NYC72FHJ20Accident · No injuriesClosedPiper PA-28 · Montauk, NYMay 27, 1972 · N9366W · Substantial damage NTSB NYC70AN114Accident · 2 fatalClosedPiper PA-28 · Spring Valley, NYApr 19, 1970 · N9411W · Destroyed NTSB NYC69F0201Accident · No injuriesClosedPiper PA-28 · Canandaigua, NYSep 22, 1968 · N8809W · Substantial damage NTSB NYC69A0030Accident · 2 fatalClosedCessna 402 · Flushing, NYSep 8, 1968 · N8283F · 2 aircraft · Substantial damage NTSB NYC67A0045Accident · 1 fatalClosedPiper PA-28 · Flushing, NYSep 5, 1966 · N8754W · Substantial damage NTSB NYC66F0428Accident · No injuriesClosedPiper PA-28 · Montour Falls, NYDec 22, 1965 · N9055W · Substantial damage NTSB NYC66D0016Accident · Minor injuriesClosedPiper PA-28 · Herrings, NYJun 12, 1965 · N8681W · Destroyed