NTSB investigations: Piper PA-32-300, 1972

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

19672026
NTSB investigations: Piper PA-32-300, 1972 per year, 1967–2026: 767 cases
196713
196813
196915
197024
197123
197222
197322
197429
197531
197629
197723
197834
197923
198028
198117
198220
198315
198411
198523
198610
198712
198819
198925
19908
199112
199213
199317
199411
199510
199610
199713
199811
199910
200012
200112
200211
200310
20045
20059
20069
20075
20086
20092
20102
20113
20127
20132
20144
20155
20164
20174
201811
20194
20207
20212
202212
20238
20249
20253
20263

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\") = 1972
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103212'))
  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.

NTSB DEN73AD029Accident · 7 fatalClosedPiper PA-32 · Kearney, NEDec 28, 1972 · N8915N · DestroyedNTSB MKC73AK046Accident · 2 fatalClosedPiper PA-32 · Great Bend, KSDec 23, 1972 · N5263S · DestroyedNTSB FTW73AF024Accident · 2 fatalClosedPiper PA-32 · Laredo, TXDec 8, 1972 · N5229S · DestroyedNTSB NYC73DNC40Accident · No injuriesClosedPiper PA-32 · Ludlow, VTNov 25, 1972 · N4026R · Substantial damageNTSB NYC73FGM13Accident · Serious injuriesClosedPiper PA-32 · Roaring Spring, PANov 22, 1972 · N8672N · Substantial damageNTSB ANC73AA034Accident · No injuriesClosedPiper PA-32 · Pilot Point, AKNov 19, 1972 · N4074R · Substantial damageNTSB MKC73DCQ19Accident · No injuriesClosedPiper PA-32 · Pittsburg, KSOct 18, 1972 · N4005R · Substantial damageNTSB FTW73AF011Accident · 6 fatalClosedPiper PA-32 · Norman, OKSep 30, 1972 · N8662N · DestroyedNTSB LAX73OLO05Accident · No injuriesClosedPiper PA-32 · Mulege, MexicoSep 18, 1972 · N5252S · Substantial damageNTSB SEA73FYE14Accident · Minor injuriesClosedPiper PA-32 · Olympia, WASep 11, 1972 · N4281R · Substantial damageNTSB OAK73FVW07Accident · No injuriesClosedPiper PA-32 · Las Vegas, NVSep 9, 1972 · N2843T · Substantial damageNTSB CHI73FEI07Accident · Minor injuriesClosedPiper PA-32 · Northfield, OHAug 20, 1972 · N4367T · Substantial damageNTSB NYC73FNA12Accident · Serious injuriesClosedPiper PA-32 · Nantucket, MAAug 13, 1972 · N4196R · Substantial damageNTSB MKC73DCQ08Accident · No injuriesClosedPiper PA-32 · Marysville, KSJul 24, 1972 · N4279R · Substantial damageNTSB NYC73DNA04Accident · No injuriesClosedPiper PA-32 · Warwick, RIJul 13, 1972 · N4088W · Substantial damageNTSB DEN72AD060Accident · 6 fatalClosedPiper PA-32 · Glenwood, NMJun 22, 1972 · N4278R · DestroyedNTSB MKC72AK063Accident · No injuriesClosedPiper PA-32 · Poplar Bluff, MOMay 25, 1972 · N4001R · Substantial damageNTSB NYC72FFA36Accident · No injuriesClosedPiper PA-32 · Cooperstown, NYApr 28, 1972 · N4066W · Substantial damageNTSB MKC72DCQ51Accident · No injuriesClosedPiper PA-32 · Elkhart, KSApr 21, 1972 · N4108R · Substantial damageNTSB FTW72DPD36Accident · No injuriesClosedPiper PA-32 · Cross Plains, TXApr 6, 1972 · N8954N · Substantial damageNTSB FTW72DPM20Accident · No injuriesClosedPiper PA-32 · Grove, OKFeb 26, 1972 · N2772P · Substantial damageNTSB MIA72DLD36Accident · No injuriesClosedPiper PA-32 · Sumterville, FLJan 15, 1972 · N5201S · Substantial damage