NTSB investigations: Piper PA-32-260, PA
17 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.
Cases per year
| 1966 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1996 | 2 |
| 2004 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('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" = '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 ('7103206'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 NYC04LA071Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Collegeville, PAThe pilot's failure to maintain clearance from trees during approach to the runway. Factors in the accident were the dark night and snowbank.NTSB NYC97FA025Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Felton, PAThe pilot's inadequate preflight planning and preparation, and his failure to refuel which resulted in fuel exhaustion and the subsequent collision with trees during the forced landing.NTSB NYC96LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Coatsville, PAloss of engine power for undetermined reason(s). Factors relating to the accident were: darkness, and the lack of suitable landing areas.NTSB NYC91FA194Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Monongahela, PAThe failure of the pilot to achieve a proper touchdown on the runway due to diverted attention, pressure, and other psychological condition.NTSB NYC91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Bally, PAThe pilot's improper recovery from a bounced landing and his failiure to maintain directional control.NTSB NYC83FA037Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Douglassville, PAAt aprx 1540 EST, the acft was dispatched to philadelphia, PA on a pax flt. After arriving, the plt remained there to pick up 4 other pax that were arriving at approx 2100 EST. At 2007, the plt received a partial wx brief & filed an IFR flt plan to rtn to…NTSB NYC81FA017Accident · 1 fatalClosedPiper PA-32 · Philadelphia, PANTSB NYC78DHD07Accident · No injuriesClosedPiper PA-32 · West Chester, PANTSB NYC78FGM01Accident · No injuriesClosedPiper PA-32 · Corry, PANTSB NYC76FHA05Accident · No injuriesClosedPiper PA-32 · Clifford, PANTSB NYC75DHD28Accident · No injuriesClosedPiper PA-32 · West Chester, PANTSB NYC72DHA23Accident · No injuriesClosedPiper PA-32 · Hamburg, PANTSB NYC72DGM17Accident · Minor injuriesClosedPiper PA-32 · Central City, PANTSB NYC70AN135Accident · 1 fatalClosedPiper PA-32 · Wilkes-Barre, PANTSB NYC70D0120Accident · No injuriesClosedPiper PA-32 · Berwick, PANTSB NYC69F0118Accident · Serious injuriesClosedPiper PA-32 · Morrisville, PANTSB NYC66F0622Accident · Minor injuriesClosedPiper PA-32 · Bethel Park, PA