NTSB investigations: Piper PA-32-300, 1970

24 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, 1970 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\") = 1970
    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 ANC71AA033Accident · No injuriesClosedPiper PA-32 · Chignik, AKDec 16, 1970 · N4035W · Substantial damageNTSB FTW71DRG54Accident · No injuriesClosedPiper PA-32 · Mountain Home, TXDec 4, 1970 · N8997N · Substantial damageNTSB IAD71DHD31Accident · No injuriesClosedPiper J5A · Smyrna, DENov 22, 1970 · N28196 · Substantial damageNTSB CHI71FBM10Accident · Minor injuriesClosedPiper PA-32 · South Bend, INNov 21, 1970 · N4167R · DestroyedNTSB CHI71DBA20Accident · No injuriesClosedPiper PA-32 · Indianapolis, INNov 16, 1970 · N4149W · Substantial damageNTSB OAK71FVW17Accident · No injuriesClosedPiper PA-32 · Pahrump, NVNov 13, 1970 · N4036W · DestroyedNTSB MKC71AK025Accident · 2 fatalClosedPiper PA-32 · Shakopee, MNNov 1, 1970 · N4150R · DestroyedNTSB OAK71AP021Accident · No injuriesClosedPiper PA-32 · San Francisco, CAOct 27, 1970 · N4144R · Substantial damageNTSB FTW71DRG33Accident · No injuriesClosedPiper PA-32 · Pericos, MexicoOct 6, 1970 · N8919N · DestroyedNTSB CHI71FBJ27Accident · No injuriesClosedPiper PA-32 · Lansing, MISep 7, 1970 · N5251S · Substantial damageNTSB LAX71FUA12Accident · No injuriesClosedPiper PA-32 · Sj Capstrno, CAAug 8, 1970 · N8944N · Substantial damageNTSB LAX71DVA26Accident · No injuriesClosedPiper PA-32 · Caborca, MexicoJul 17, 1970 · N8993N · DestroyedNTSB SEA70DDG15Accident · No injuriesClosedPiper PA-32 · Three Forks, MTJun 30, 1970 · N4193W · Substantial damageNTSB CHI70IC089Incident · No injuriesClosedPiper PA-32 · Columbus, OHJun 6, 1970 · N4023W · No damageNTSB ANC70AA093Accident · No injuriesClosedPiper PA-32 · Peterson Pt, AKJun 2, 1970 · N4035W · Substantial damageNTSB SEA70DVQ09Accident · No injuriesClosedPiper PA-32 · Mckenzie Br., ORMay 25, 1970 · N4171R · Substantial damageNTSB OAK70DVG23Accident · No injuriesClosedPiper PA-32 · Calistoga, CAMay 14, 1970 · N4054R · Substantial damageNTSB DEN70FXT08Accident · No injuriesClosedPiper PA-32 · Woods Cross, UTApr 30, 1970 · N4088R · Substantial damageNTSB OAK70DVA11Accident · No injuriesClosedPiper PA-32 · Turlock, CAApr 19, 1970 · N4087R · Substantial damageNTSB LAX70AL061Accident · 6 fatalClosedPiper PA-32 · Colrado Cty, AZMar 26, 1970 · N4121R · DestroyedNTSB DEN70DXD17Accident · No injuriesClosedPiper PA-32 · Akron, COMar 22, 1970 · N4064R · Substantial damageNTSB LAX70AL058Accident · 5 fatalClosedPiper PA-32 · Pima, AZMar 13, 1970 · N4244R · DestroyedNTSB LAX70DUJ08Accident · No injuriesClosedPiper PA-32 · Pima, AZFeb 2, 1970 · N4293R · Substantial damageNTSB MKC70FCJ04Accident · No injuriesClosedPiper PA-32 · Oneill, NEJan 27, 1970 · N8955N · Substantial damage