NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 NYC66D0416Accident · No injuriesClosedBeechcraft G35 · Mendon, MADec 31, 1965 · N4409D · DestroyedNTSB NYC66F0435Accident · No injuriesClosedErcoupe 415-D · Marlboro, MADec 30, 1965 · N1DA · Substantial damageNTSB NYC66D0414Accident · No injuriesClosedCessna 140 · Tewksbury, MADec 19, 1965 · N3083N · Substantial damageNTSB NYC66F0430Accident · Minor injuriesClosedPiper JC3-65 · Pepperell, MADec 18, 1965 · N33121 · Substantial damageNTSB NYC66F0389Accident · Minor injuriesClosedPiper PA-28 · Worcester, MADec 7, 1965 · N6596W · Substantial damageNTSB NYC66D0377Accident · No injuriesClosedCessna 180 · Rochester, MADec 4, 1965 · N9186T · Substantial damageNTSB NYC66D0406Accident · No injuriesClosedCessna 337 · Beverly, MADec 2, 1965 · N2225X · Substantial damageNTSB NYC66D0358Accident · No injuriesClosedCessna 150 · Falmouth, MANov 21, 1965 · N7728E · Substantial damageNTSB NYC66I0057Incident · No injuriesClosedBoeing 707 321B · Boston, MANov 20, 1965 · N798PA · No damageNTSB NYC66F0365Accident · No injuriesClosedPiper J3C-65 · Agawam, MANov 12, 1965 · N70596 · Substantial damageNTSB NYC66F0327Accident · No injuriesClosedPiper PA-28 · Brookfield, MANov 3, 1965 · N6235W · Substantial damageNTSB NYC66F0343Accident · Minor injuriesClosedPiper PA-28 · Lynn, MAOct 31, 1965 · N5373W · Substantial damageNTSB NYC66F0309Accident · No injuriesClosedPiper PA-22 · Northampton, MAOct 31, 1965 · N830MD · Substantial damageNTSB NYC66I0049Incident · No injuriesClosedDouglas DC-6 · Boston, MAOct 17, 1965 · N90748 · No damageNTSB NYC66F0293Accident · No injuriesClosedStinson 108-1 · Westfield, MAOct 8, 1965 · N97376 · Substantial damageNTSB NYC66F0274Accident · No injuriesClosedBeechcraft E50 · Hopedale, MASep 25, 1965 · N4395D · Substantial damageNTSB NYC66F0267Accident · No injuriesClosedCessna 150 · Beverly, MASep 22, 1965 · N7884E · Substantial damageNTSB NYC66F0219Accident · No injuriesClosedPiper PA-22 · Norwood, MASep 12, 1965 · N5959Z · Substantial damageNTSB NYC66F0210Accident · No injuriesClosedErcoupe 415C · Agawam, MASep 7, 1965 · N93674 · Substantial damageNTSB NYC66F0222Accident · No injuriesClosedCessna 170B · Norwood, MASep 4, 1965 · N2438D · Substantial damageNTSB NYC66F0220Accident · No injuriesClosedPiper PA-28 · Gr Barringtn, MASep 3, 1965 · N6586W · Substantial damageNTSB NYC66F0226Accident · No injuriesClosedPiper PA-28 · Lawrence, MAAug 31, 1965 · N5647W · Substantial damageNTSB NYC66F0168Accident · Minor injuriesClosedPiper J5A · Gardner, MAAug 25, 1965 · N40980 · Substantial damageNTSB NYC66D0167Accident · No injuriesClosedPiper PA-22 · Marlboro, MAAug 22, 1965 · N5674Z · Substantial damageNTSB NYC66F0189Accident · No injuriesClosedPiper PA-24 · Newburyport, MAAug 16, 1965 · N5034P · Substantial damageNTSB NYC66A0022Accident · No injuriesClosedDouglas DC-6A · Boston, MAAug 15, 1965 · N37595 · Substantial damageNTSB NYC66A0021Accident · 3 fatalClosedAeronca 15AC · Mashpee, MAAug 14, 1965 · N1375H · DestroyedNTSB NYC66F0183Accident · No injuriesClosedAeronca 11AC · Tewksbury, MAAug 11, 1965 · N3199E · Substantial damageNTSB NYC66F0175Accident · No injuriesClosedBeechcraft T-34A · Turner Falls, MAAug 11, 1965 · N8701R · Substantial damageNTSB NYC66F0158Accident · Serious injuriesClosedPiper PA-15 · Lowell, MAAug 10, 1965 · N4392H · DestroyedNTSB NYC66F0190Accident · No injuriesClosedBeechcraft C-45H · Nantucket, MAAug 8, 1965 · N160L · Substantial damageNTSB NYC66F0154Accident · Minor injuriesClosedPiper PA-28 · Lenox, MAAug 6, 1965 · N9029W · Substantial damageNTSB NYC66F0122Accident · Minor injuriesClosedChampion 7ECA · Norfolk, MAAug 1, 1965 · N2572F · Substantial damageNTSB NYC66D0145Accident · No injuriesClosedPiper J-3 · Cheshire, MAJul 31, 1965 · N42165 · Substantial damageNTSB NYC66D0130Accident · No injuriesClosedScheibe L-SPAT · Heath, MAJul 30, 1965 · N8752R · Substantial damageNTSB NYC66F0124Accident · No injuriesClosedPiper PA-18A · Southwick, MAJul 29, 1965 · N3707A · Substantial damageNTSB NYC66F0119Accident · 1 fatalClosedScheibe L-55 · New Braintre, MAJul 26, 1965 · N10110 · DestroyedNTSB NYC66D0135Accident · No injuriesClosedPiper PA-28 · Newburyport, MAJul 26, 1965 · N6084W · Substantial damageNTSB NYC66F0100Accident · No injuriesClosedPiper PA-28 · Taunton, MAJul 23, 1965 · N6510W · Substantial damageNTSB NYC66F0099Accident · No injuriesClosedLockheed 10A · East Boston, MAJul 19, 1965 · N38PB · Substantial damageNTSB NYC66D0055Accident · Minor injuriesClosedPiper PA-22 · Palmer, MAJul 13, 1965 · N7341D · Substantial damageNTSB NYC66F0091Accident · No injuriesClosedPiper J3C · Hopedale, MAJul 3, 1965 · N6213H · Substantial damageNTSB NYC65A0157Accident · No injuriesClosedAir & Space 18A · Pocasset, MAJun 28, 1965 · N6103S · Substantial damageNTSB NYC66D0036Accident · No injuriesClosedBeechcraft 23 · Tewksbury, MAJun 27, 1965 · N23441 · Substantial damageNTSB NYC66D0047Accident · No injuriesClosedStinson SM-8A · Provincetown, MAJun 20, 1965 · N205W · Substantial damageNTSB NYC66F0025Accident · No injuriesClosedCessna 195B · East Boston, MAJun 13, 1965 · N3070B · Substantial damageNTSB NYC66F0007Accident · Minor injuriesClosedAeronca 7AC · Hanson, MAJun 6, 1965 · N84436 · Substantial damageNTSB NYC66F0013Accident · No injuriesClosedPiper J-3 · Tewksbury, MAJun 3, 1965 · N186CM · Minor damageNTSB NYC65F0169Accident · No injuriesClosedPiper PA-22 · Danvers, MAMay 10, 1965 · N1849A · Substantial damageNTSB NYC65F0178Accident · No injuriesClosedLuscombe T8F · Shirley, MAMay 9, 1965 · N2058B · Substantial damage