Final NTSB investigations: Piper PA-32-260, 2012

2 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

19652026
Final NTSB investigations: Piper PA-32-260, 2012 per year, 1965–2026: 677 cases
19654
196628
196732
196838
196934
197029
197137
197224
197326
197432
197524
197626
197727
197814
197918
198014
198113
19827
198317
198410
19854
19867
198711
198811
198912
19908
19917
19928
19935
199411
19959
19968
19977
19984
19997
20005
20016
20024
20036
20046
20052
20065
20074
20089
20092
20101
20115
20122
20132
20142
20153
20161
20174
20181
20198
20205
20217
20224
20234
20244
20251
20261

Latest 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 year(c.\"eventDate\") = 2012
    AND c.\"completionStatus\" = 'Completed'
    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.