NTSB investigations: Piper PA-32-260, SC

13 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

19682026

NTSB investigations: Piper PA-32-260, SC per year, 1968–2026: 13 cases
1968	2
1970	2
1975	1
1976	1
1977	1
1980	2
1989	1
2000	1
2020	1
2021	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" = 'SC' 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\" = 'SC' 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" = 'SC' 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 ERA21LA344Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Spartanburg, SCThe flight instructor’s improper fuel management, which resulted in fuel starvation and a total loss of engine power.Aug 28, 2021 · N3862W · Substantial damage NTSB ERA21LA054Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Greenville, SCA partial loss of engine power due to the pilot’s delayed application of carburetor heat, which resulted in carburetor icing.Nov 24, 2020 · N5566J · Substantial damage NTSB ATL01LA012Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Florence, SCLoss of engine power due to carburetor icing, which resulted in a emergency landing into rough uneven terrain.Nov 29, 2000 · N6YB · Substantial damage NTSB ATL89LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Kershaw, SCFatigue failure of the crankshaft dowel pin. Factors related to the accident were: failure of maintenance personnel to follow the applicable service bulletin and darkness.Mar 21, 1989 · N390G · Substantial damage NTSB ATL81FA019Accident · 5 fatalClosedPiper PA-32 · Hilton Head, SCNov 30, 1980 · N3242W · 2 aircraft · Destroyed NTSB MIA80FA046Accident · 3 fatalClosedPiper PA-28 · Florence, SCMar 10, 1980 · N1438X · Destroyed NTSB MIA77FLG38Accident · No injuriesClosedPiper PA-32 · Beaufort, SCSep 25, 1977 · N7744J · Substantial damage NTSB MIA76FLG31Accident · No injuriesClosedPiper PA-32 · Simpsonville, SCMay 12, 1976 · N41579 · Substantial damage NTSB MIA76FLG02Accident · No injuriesClosedPiper PA-32 · Beech Island, SCJul 4, 1975 · N121MB · Substantial damage NTSB MIA71FLG11Accident · Minor injuriesClosedPiper PA-32 · Newberry, SCSep 28, 1970 · N3399W · Destroyed NTSB MIA70DLG02Accident · No injuriesClosedPiper PA-32 · Bamberg, SCFeb 5, 1970 · N3278W · Substantial damage NTSB MIA69D0366Accident · No injuriesClosedPiper PA-32 · Walterboro, SCDec 28, 1968 · N3256W · Substantial damage NTSB MIA69A0021Accident · 6 fatalClosedPiper PA-32 · Charleston, SCOct 7, 1968 · N3583W · Destroyed