NTSB investigations: Piper PA-32-260, NE

10 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

19672026

NTSB investigations: Piper PA-32-260, NE per year, 1967–2026: 10 cases
1967	2
1969	1
1970	1
1974	1
1975	1
1978	1
1979	1
1983	1
1992	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" = 'NE' 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\" = 'NE' 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" = 'NE' 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 CHI92LA135Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Sidney, NEWas an inadvertent stall/mush during landing by the pilot. A factor related to the accident was lack of recent total experience.Apr 26, 1992 · N3811W · Substantial damage NTSB MKC84LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Schuyler, NEWhile descending toward the planned destination, the eng began running rough & the plt attempted to improve the eng's performance by using carburetor heat. He made a localizer-only apch, but was unable to see the rwy at the min descent alt. A missed apch was…Dec 20, 1983 · N43302 · Substantial damage NTSB MKC79DCJ34Accident · No injuriesClosedPiper PA-32 · Hay Springs, NEAug 11, 1979 · N3397W · Substantial damage NTSB MKC79FA012Accident · 3 fatalClosedPiper PA-32 · Virginia, NEDec 18, 1978 · N4757S · Destroyed NTSB MKC76DCJ12Accident · No injuriesClosedPiper PA-32 · Ravenna, NESep 3, 1975 · N3233W · Substantial damage NTSB MKC75DCJ28Accident · No injuriesClosedPiper PA-32 · York, NESep 15, 1974 · N3332W · Substantial damage NTSB MKC70DCJ31Accident · No injuriesClosedPiper PA-32 · Taylor, NEJun 19, 1970 · N3332W · Substantial damage NTSB MKC69A0045Accident · 6 fatalClosedPiper PA-32 · Anselmo, NEJan 11, 1969 · N3452W · Destroyed NTSB MKC68D0351Accident · No injuriesClosedPiper PA-32 · Beaver City, NENov 22, 1967 · N3483W · Substantial damage NTSB MKC67A0058Accident · No injuriesClosedPiper PA-32 · Omaha, NEApr 13, 1967 · N3235W · Substantial damage