NTSB investigations, 1976, MA

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19632026
NTSB investigations, 1976, MA per year, 1963–2026: 2,104 cases
19633
196464
196578
196681
196771
196869
196956
197087
197163
197258
197372
197468
197572
197645
197751
197868
197934
198035
198143
198238
198341
198453
198538
198640
198754
198829
198925
199044
199126
199231
199331
199433
199521
199628
199721
199822
199921
200029
200123
200223
200322
200428
200518
200616
200719
200812
200914
201024
201118
201210
201310
201412
201510
201612
201710
20189
20199
20208
202110
202211
20236
20247
202510
202610

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\") = 1976
    AND c.\"eventStateOrRegion\" = 'MA' AND c.\"eventCountry\" = 'USA'
  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 NYC77FA022Accident · 2 fatalClosedPiper PA-23 · Danvers, MADec 21, 1976 · N66HR · DestroyedNTSB NYC77FNA07Accident · Serious injuriesClosedTed Smith 601 · Framingham Ctr, MADec 12, 1976 · N90337 · DestroyedNTSB NYC76DNA04Accident · No injuriesClosedPiper PA-24 · Chatham, MANov 20, 1976 · N9258P · Substantial damageNTSB NYC77DNA03Accident · No injuriesClosedAero Comdr 560A · Provincetown, MANov 9, 1976 · CFMLQ · Substantial damageNTSB NYC77FNE02Accident · Serious injuriesClosedSchweizer SGS233 · Pittsfield, MAOct 17, 1976 · N33977 · DestroyedNTSB NYC77FNA01Accident · No injuriesClosedEvans VP1 · Stow, MAOct 11, 1976 · N106JM · Substantial damageNTSB NYC76FNA54Accident · No injuriesClosedPiper PA-12 · Pembroke, MASep 26, 1976 · N3913M · Substantial damageNTSB NYC76FNA52Accident · No injuriesClosedCessna 172 · Middleboro, MASep 12, 1976 · N80420 · Substantial damageNTSB NYC76FNA51Accident · No injuriesClosedStearman A75 · Norwood, MASep 9, 1976 · N145N · Substantial damageNTSB NYC76DNA53Accident · No injuriesClosedCessna 172K · Methuen, MASep 9, 1976 · N78179 · Substantial damageNTSB NYC76FNE33Accident · Serious injuriesClosedSchweizer SGS126 · Sterling, MAAug 21, 1976 · N1106S · Substantial damageNTSB NYC76FNE31Accident · Serious injuriesClosedLake LA-4 · Grt Barrington, MAAug 10, 1976 · N39359 · Substantial damageNTSB NYC76AN119Accident · Serious injuriesClosedCessna U206F · Tuckernuck Is, MAAug 5, 1976 · N35919 · Substantial damageNTSB NYC76AN117Accident · No injuriesClosedBeech 65 · Bedford, MAJul 27, 1976 · N12 · Substantial damageNTSB NYC76FNA46Accident · No injuriesClosedPiper PA-32 · Tewksbury, MAJul 26, 1976 · N3893W · Substantial damageNTSB NYC76FNA45Accident · No injuriesClosedCessna 150L · Freetown, MAJul 25, 1976 · N6754G · Substantial damageNTSB NYC76DNA44Accident · Minor injuriesClosedCessna 140 · Norfolk, MAJul 20, 1976 · N72708 · Substantial damageNTSB NYC76FNE29Accident · No injuriesClosedCessna 150J · Southbridge, MAJul 18, 1976 · N60412 · Substantial damageNTSB NYC76AN111Accident · 1 fatalClosedPiper PA-28R · Bedford, MAJul 16, 1976 · N3298R · Substantial damageNTSB NYC76FNA47Accident · No injuriesClosedGrum Amer AA-5 · Stow, MAJul 14, 1976 · N8899L · Substantial damageNTSB NYC76FNE27Accident · Serious injuriesClosedGlobe GC-1B · Gardner, MAJul 5, 1976 · N78315 · DestroyedNTSB NYC76FNA41Accident · No injuriesClosedPiper PA-18 · Chatham, MAJul 3, 1976 · N6989D · Substantial damageNTSB NYC76DNA40Accident · Minor injuriesClosedCessna 150 · Shirley, MAJun 27, 1976 · N3883J · Substantial damageNTSB NYC76AN105Accident · 4 fatalClosedCessna 172 · Turo, MAJun 26, 1976 · CF-QNG · DestroyedNTSB NYC76FNE24Accident · Minor injuriesClosedCessna 150G · Westboro, MAJun 7, 1976 · N8347G · Substantial damageNTSB NYC76AM1O2Accident · 2 fatalClosedBeech B35 · Hyannis, MAJun 6, 1976 · N8919A · DestroyedNTSB NYC76FNE22Accident · Minor injuriesClosedMooney M20C · Westboro, MAMay 30, 1976 · N6793N · Substantial damageNTSB NYC76FNE20Accident · No injuriesClosedPiper PA-12 · Pittsfield, MAMay 23, 1976 · N4054M · Substantial damageNTSB NYC76DNA39Accident · No injuriesClosedStinson 108-3 · Oak Bluffs, MAMay 23, 1976 · N6275M · Substantial damageNTSB NYC76FNA38Accident · No injuriesClosedCessna 150H · Shirley, MAMay 13, 1976 · N7169S · Substantial damageNTSB NYC76DNA35Accident · No injuriesClosedCessna 150 · Norfolk, MAApr 20, 1976 · N63439 · Substantial damageNTSB NYC76DNA34Accident · No injuriesClosedPiper PA-16 · Bedford, MAApr 16, 1976 · N5855H · Substantial damageNTSB NYC76DNA33Accident · No injuriesClosedMooney M20C · Bedford, MAApr 2, 1976 · N9788M · Substantial damageNTSB NYC76DNA32Accident · No injuriesClosedCessna 411A · Stow, MAMar 28, 1976 · N251WW · Substantial damageNTSB NYC76FNE19Accident · No injuriesClosedCessna 150 · Worcester, MAMar 25, 1976 · N8353J · Substantial damageNTSB NYC76FNA31Accident · Minor injuriesClosedCessna 172 · Tewksbury, MAMar 21, 1976 · N12401 · DestroyedNTSB NYC76AN087Accident · 2 fatalClosedCessna 150L · Plymouth, MAMar 5, 1976 · N19398 · Substantial damageNTSB NYC76FNE15Accident · No injuriesClosedCessna 172K · Orange, MAFeb 28, 1976 · N15000 · Substantial damageNTSB NYC76AN078Accident · Serious injuriesClosedPiper PA-23 · Ludlow, MAFeb 12, 1976 · N7RW · Substantial damageNTSB NYC76FNE14Accident · No injuriesClosedCessna 172 · Worcester, MAFeb 4, 1976 · N84183 · Substantial damageNTSB NYC76FNA29Accident · No injuriesClosedGrum Amer AA1-B · Billerica, MAFeb 1, 1976 · N6205L · Substantial damageNTSB NYC76FNA28Accident · Serious injuriesClosedPiper PA-28 · Norfolk, MAJan 31, 1976 · N1NS · Substantial damageNTSB NYC76FNA27Accident · No injuriesClosedPiper PA-23 · Bedford, MAJan 17, 1976 · N3006P · Substantial damageNTSB NYC76FNE13Accident · No injuriesClosedCessna 172L · Worcester, MAJan 14, 1976 · N3967Q · Substantial damageNTSB NYC76DNA25Accident · No injuriesClosedErco 415-C · Tauton, MAJan 10, 1976 · N99494 · Substantial damage