NTSB investigations: Piper PA-32-260, NY

15 cases on aircraft the registry lists as Piper PA-32-260. 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

NTSB investigations: Piper PA-32-260, NY per year, 1965–2026: 15 cases
1965	1
1967	2
1971	2
1972	1
1974	1
1975	1
1982	1
1991	1
1993	1
1996	1
2007	1
2013	1
2020	1

Where

Open the map

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 ('7103206')) 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 ('7103206'))
  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 ('7103206'))
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 ERA20CA282Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA32 · Montauk, NYThe pilot's improper recovery from a bounced landing and failure to maintain directional control, which resulted in a runway excursion and collision with trees.Aug 10, 2020 · N4817S · Substantial damage NTSB ERA13LA121Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Yonkers, NYA partial loss of engine power for reasons that could not be determined because examination of the engine and associated components did not reveal any mechanical malfunction or failure that would have precluded normal operation.Jan 27, 2013 · N1967E · Substantial damage NTSB NYC07FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-32-260 · Westhampton, NYUndetermined. The airplane remains missing.Aug 25, 2007 · N5067T · Destroyed NTSB IAD97LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Claverack, NYloss of engine power for undetermined reasons.Dec 4, 1996 · N3324W · Substantial damage NTSB BFO93LA031Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Hudson, NYFailure of the pilot to maintain directional control, which resulted in an advertent ground swerve. The snowbank was a related factor.Feb 20, 1993 · N999HF · Substantial damage NTSB NYC91FA099Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Naples, NYFlight by the pilot into known icing conditions, which resulted in structural (wing) ice and subsequent loss of aircraft control. The weather condition was a related factor.Apr 2, 1991 · N3667W · Destroyed NTSB NYC82FFJ12Accident · Minor injuriesFinal reportPiper PA-32 · Syracuse, NYThe pilot took off on a VFR flight plan with a litter patient and 3 other passengers onboard. The right main fuel tank was used for about the first 30 minutes of flight, then the pilot switched to the left main tank. While en route, an IFR flight plan was…Mar 12, 1982 · N260BB · Substantial damage NTSB NYC75FFJ22Accident · No injuriesClosedPiper PA-32 · Ovid, NYApr 18, 1975 · N3337W · Substantial damage NTSB NYC74DFA26Accident · No injuriesClosedPiper PA-28 · Camp Drum, NYApr 11, 1974 · N5545J · Substantial damage NTSB NYC73DFA03Accident · No injuriesClosedPiper PA-32 · Delhi, NYJul 1, 1972 · N3701W · Substantial damage NTSB NYC71DFA46Accident · No injuriesClosedPiper PA-32 · Cairo, NYJan 11, 1971 · N4862S · Substantial damage NTSB NYC71FFJ22Accident · No injuriesClosedPiper PA-32 · Seneca Falls, NYJan 2, 1971 · N3810W · Substantial damage NTSB NYC68F0213Accident · Minor injuriesClosedPiper PA-32 · Montour Falls, NYSep 30, 1967 · N3861W · Substantial damage NTSB NYC68A0031Accident · 6 fatalClosedPiper PA-32 · City Island, NYAug 27, 1967 · N3381W · Destroyed NTSB NYC66F0422Accident · Serious injuriesClosedPiper PA-32 · Frewsberg, NYDec 8, 1965 · N3298W · Destroyed