NTSB investigations: Piper J3C-65, 1977

28 cases on aircraft the registry lists as Piper J3C-65. 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

19642026
NTSB investigations: Piper J3C-65, 1977 per year, 1964–2026: 1,194 cases
196491
196562
196688
196758
196856
196966
197049
197144
197230
197328
197423
197531
197639
197728
197823
197922
198018
198118
198212
198314
198420
198522
198619
198713
198818
19897
199011
199113
199212
19938
199410
199510
199618
199710
199811
199913
200010
200110
20024
20039
20045
20054
20068
200710
200810
20097
20109
20117
20124
20133
201410
20154
20177
20185
20199
20204
202110
20225
20237
20247
20254
20267

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\") = 1977
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7100510'))
  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 FTW78FRJ08Accident · 1 fatalClosedPiper J-3 · Farmerville, LANov 27, 1977 · N88338 · DestroyedNTSB FTW78DRJ06Accident · No injuriesClosedPiper J3C · Pineville, LANov 2, 1977 · N71022 · Substantial damageNTSB MIA78DLD06Accident · No injuriesClosedPiper J3 · Ft Pierce, FLOct 23, 1977 · N70701 · Substantial damageNTSB FTW78DRD06Accident · No injuriesClosedPiper J3C-65 · Baton Rouge, LAOct 23, 1977 · N70273 · Substantial damageNTSB IAD78FA006Accident · 1 fatalClosedPiper J-3 · Pulaski, TNOct 22, 1977 · N98067 · DestroyedNTSB LAX77FUQ45Accident · No injuriesClosedPiper J3C-65 · Pacoima, CAAug 24, 1977 · N6513H · Substantial damageNTSB FTW77FRD42Accident · Serious injuriesClosedPiper J3-C65 · Beaux Bridge, LAJul 31, 1977 · N71024 · DestroyedNTSB IAD77DID23Accident · Minor injuriesClosedPiper J3C-65 · Woolwine, VAJul 3, 1977 · N7157H · Substantial damageNTSB FTW77FPJ28Accident · Minor injuriesClosedPiper J3C-65 · Yukon, OKJul 3, 1977 · N87791 · Substantial damageNTSB ANC77DAG89Accident · No injuriesClosedPiper J-3 · Homer, AKJul 3, 1977 · N71081 · Substantial damageNTSB FTW77FRA27Accident · 2 fatalClosedPiper J3C-65 · Waller, TXJun 19, 1977 · N38101 · 2 aircraft · DestroyedNTSB MIA77DLD66Accident · No injuriesClosedPiper J3 · Bartow, FLJun 14, 1977 · N98606 · Substantial damageNTSB ANC77DAG66Accident · No injuriesClosedPiper J-3 · Kenai, AKJun 11, 1977 · N6505H · Substantial damageNTSB SEA77FTA21Accident · No injuriesClosedPiper J3C-65 · Scobey, MTJun 6, 1977 · N35214 · Substantial damageNTSB MKC77DTG08Accident · No injuriesClosedPiper J-3 · Kenmare, NDJun 5, 1977 · N32668 · Substantial damageNTSB CHI77FEV26Accident · Serious injuriesClosedPiper J-3 · Manito, ILJun 4, 1977 · N70907 · Substantial damageNTSB FTW77FPM10Accident · 1 fatalClosedPiper J-3 · Jay, OKMay 24, 1977 · N6355H · DestroyedNTSB FTW77FPD24Accident · Minor injuriesClosedPiper J3C-65 · Roanoke, TXMay 21, 1977 · N5341N · Substantial damageNTSB NYC77FNE18Accident · Minor injuriesClosedPiper J3 · Fairfield, CTMay 16, 1977 · N6661H · Substantial damageNTSB SEA77DYM31Accident · No injuriesClosedPiper J-3 · Yacolt, WAMay 14, 1977 · N42448 · DestroyedNTSB SEA77FTA16Accident · No injuriesClosedPiper J3 · Otter, MTApr 23, 1977 · N70209 · Substantial damageNTSB MIA77FKT63Accident · Serious injuriesClosedPiper J-3 · Moore Haven, FLApr 16, 1977 · N42684 · Substantial damageNTSB MIA77FKJ30Accident · Minor injuriesClosedPiper J3 · Graysville, ALApr 16, 1977 · N30451 · Substantial damageNTSB MIA77DKJ31Accident · Serious injuriesClosedPiper J-3 · Mobile, ALApr 16, 1977 · N65881 · Substantial damageNTSB MIA77DLD37Accident · Minor injuriesClosedPiper J-3 · Okeechobee, FLMar 20, 1977 · N92025 · DestroyedNTSB NYC77FHM11Accident · Minor injuriesClosedPiper J-3 · Warwick, NYMar 6, 1977 · N92404 · Substantial damageNTSB CHI77FEM14Accident · Minor injuriesClosedPiper J-3 · Steuben, MIJan 30, 1977 · N98761 · Substantial damageNTSB NYC77FA028Accident · 1 fatalClosedPiper J3C65 · Duanesburg, NYJan 15, 1977 · N87955 · Substantial damage