NTSB investigations: Piper PA-32-300, 1971

23 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, 1971 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\") = 1971
    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 ANC72AA032Accident · Minor injuriesClosedPiper PA-32 · Galena, AKDec 22, 1971 · N8942N · Substantial damageNTSB MKC72AK036Accident · No injuriesClosedPiper PA-32 · Topeka, KSDec 15, 1971 · N4105W · Substantial damageNTSB MIA72DKJ38Accident · No injuriesClosedPiper PA-32 · Atlantic Ocean (Atlantic Ocean)Dec 11, 1971 · N8965N · DestroyedNTSB FTW72AF030Accident · 7 fatalClosedPiper PA-32 · Wells, TXNov 28, 1971 · N8973N · DestroyedNTSB MKC72DCD47Accident · No injuriesClosedPiper PA-32 · Dubuque, IANov 17, 1971 · N4139W · Substantial damageNTSB MKC72DCD45Accident · No injuriesClosedPiper PA-32 · Ida Grove, IANov 14, 1971 · N4063R · Substantial damageNTSB LAX72AL032Accident · No injuriesClosedPiper PA-32 · Ventura, CANov 5, 1971 · N4245R · Substantial damageNTSB NYC72FID16Accident · No injuriesClosedPiper PA-32 · Lynchburg, VAOct 30, 1971 · N4129W · Substantial damageNTSB SEA72FYG18Accident · Serious injuriesClosedPiper PA-32 · College Pl, WAOct 26, 1971 · N5268S · DestroyedNTSB MKC72DCD38Accident · No injuriesClosedPiper PA-32 · Marshalltown, IAOct 13, 1971 · N4031R · Substantial damageNTSB CHI72DEA16Accident · No injuriesClosedPiper PA-32 · Anderson, INOct 6, 1971 · N8620N · Substantial damageNTSB LAX72FUG25Accident · No injuriesClosedPiper PA-32 · Rialto, CAOct 4, 1971 · N5219S · Substantial damageNTSB NYC72AN052Accident · No injuriesClosedPiper PA-32 · Fitchburg, MASep 9, 1971 · N294HA · 2 aircraft · Minor damageNTSB CHI72AC022Accident · 2 fatalClosedPiper PA-32 · Minford, OHSep 8, 1971 · N4026W · DestroyedNTSB LAX72FUJ40Accident · Minor injuriesClosedPiper PA-32 · Nogales, AZSep 2, 1971 · N4080W · Substantial damageNTSB MKC72AK012Accident · 1 fatalClosedPiper PA-32 · Andover, SDAug 11, 1971 · N4029R · DestroyedNTSB MKC72DCQ12Accident · No injuriesClosedPiper PA-32 · Emporia, KSJul 24, 1971 · N4105W · Substantial damageNTSB SEA71AS047Accident · 5 fatalClosedPiper PA-32 · Meacham, ORJun 14, 1971 · N4070W · DestroyedNTSB FTW71DQD23Accident · No injuriesClosedPiper PA-32 · Dell City, TXMay 21, 1971 · N4128R · Substantial damageNTSB MKC71FCJ63Accident · No injuriesClosedPiper PA-32 · Bloomfield, NEMay 14, 1971 · N4177W · Substantial damageNTSB DEN71FXT23Accident · No injuriesClosedPiper PA-32 · Provo, UTMay 1, 1971 · N4250R · Substantial damageNTSB MKC71FCD56Accident · No injuriesClosedPiper PA-32 · Grimes, IAFeb 10, 1971 · N4139W · Substantial damageNTSB SEA71AS032Accident · No injuriesClosedPiper PA-32 · Orofino, IDJan 7, 1971 · N4270R · Substantial damage