Skip to content

NTSB investigations, 1967, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19632026

NTSB investigations, 1967, MA per year, 1963–2026: 2,104 cases
1963	3
1964	64
1965	78
1966	81
1967	71
1968	69
1969	56
1970	87
1971	63
1972	58
1973	72
1974	68
1975	72
1976	45
1977	51
1978	68
1979	34
1980	35
1981	43
1982	38
1983	41
1984	53
1985	38
1986	40
1987	54
1988	29
1989	25
1990	44
1991	26
1992	31
1993	31
1994	33
1995	21
1996	28
1997	21
1998	22
1999	21
2000	29
2001	23
2002	23
2003	22
2004	28
2005	18
2006	16
2007	19
2008	12
2009	14
2010	24
2011	18
2012	10
2013	10
2014	12
2015	10
2016	12
2017	10
2018	9
2019	9
2020	8
2021	10
2022	11
2023	6
2024	7
2025	10
2026	10

Where

Latest cases

Query with SQL

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") = 1967 AND c."eventStateOrRegion" = 'MA' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1967
    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.

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") = 1967
  AND c."eventStateOrRegion" = 'MA' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB NYC68A0081Accident · No injuriesClosedBeech 65-B80 · Beverly, MADec 20, 1967 · N207E · Substantial damage NTSB NYC68D0312Accident · No injuriesClosedBeech A23 · New Bedford, MADec 16, 1967 · N5784V · Substantial damage NTSB NYC68F0309Accident · Minor injuriesClosedPiper PA-28 · Danvers, MADec 9, 1967 · N4459J · Substantial damage NTSB NYC68D0307Accident · No injuriesClosedCessna 150F · Bedford, MADec 1, 1967 · N3590L · Substantial damage NTSB NYC68D0287Accident · No injuriesClosedPiper PA-28 · Chesterfield, MANov 26, 1967 · N3946K · Substantial damage NTSB NYC68D0295Accident · No injuriesClosedPiper PA-18 · Ayer, MANov 19, 1967 · N10131 · Substantial damage NTSB NYC68D0293Accident · No injuriesClosedPiper PA-18 · Orleans, MANov 19, 1967 · N9075H · Substantial damage NTSB NYC68I0067Incident · No injuriesClosedBoeing 707 · Boston, MANov 1, 1967 · N721PA · Minor damage NTSB NYC68D0323Accident · No injuriesClosedBeech S35 · East Boston, MAOct 31, 1967 · TG-MAF · Substantial damage NTSB NYC68F0277Accident · No injuriesClosedCessna 150 · Bedford, MAOct 25, 1967 · N6588F · Substantial damage NTSB NYC68F0264Accident · Minor injuriesClosedPiper PA-28 · Agawam, MAOct 24, 1967 · N5602W · Substantial damage NTSB NYC68D0214Accident · No injuriesClosedCessna 310 · East Boston, MAOct 15, 1967 · N7079L · Substantial damage NTSB NYC68F0306Accident · Serious injuriesClosedCessna 150 · Braintree, MAOct 14, 1967 · N7994E · Destroyed NTSB NYC68D0247Accident · No injuriesClosedSchweizer SGU-2 · Barre, MAOct 14, 1967 · N10357 · Substantial damage NTSB NYC68D0189Accident · No injuriesClosedPiper PA-28 · Hopedale, MAOct 5, 1967 · N6829W · Substantial damage NTSB NYC68D0168Accident · Minor injuriesClosedCessna 150 · Mansfield, MAOct 2, 1967 · N5841E · Destroyed NTSB NYC68D0216Accident · No injuriesClosedNardi FN333 · Boston, MASep 24, 1967 · N916NS · Substantial damage NTSB NYC68D0199Accident · No injuriesClosedCessna 150 · Monterey, MASep 21, 1967 · N8035S · Substantial damage NTSB NYC68F0304Accident · No injuriesClosedPiper PA-28 · Norwood, MASep 17, 1967 · N5670W · Destroyed NTSB NYC68F0190Accident · No injuriesClosedHelio Acft H-295 · Topsfield, MASep 15, 1967 · N269E · Substantial damage NTSB NYC68D0181Accident · No injuriesClosedPiper PA-28 · Beverly, MASep 8, 1967 · N4485J · Substantial damage NTSB NYC68D0139Accident · No injuriesClosedPiper PA-23 · Fitchburg, MASep 1, 1967 · N5930Y · Substantial damage NTSB NYC68A0032Accident · No injuriesClosedLockheed 10E · Humarock, MAAug 27, 1967 · N233PB · Substantial damage NTSB NYC68F0209Accident · No injuriesClosedPiper J3C-65 · Mashpee, MAAug 24, 1967 · N6362H · Substantial damage NTSB NYC68F0200Accident · Serious injuriesClosedPiper PA-28 · Brewster, MAAug 13, 1967 · N7843W · Destroyed NTSB NYC68D0106Accident · No injuriesClosedCessna 150 · Sterling Jct, MAAug 12, 1967 · N3063X · Substantial damage NTSB NYC68D0083Accident · No injuriesClosedCessna 172 · Newburyport, MAAug 6, 1967 · N5358R · Substantial damage NTSB NYC68A0019Accident · 2 fatalClosedMooney M20C · Yarmouth, MAAug 3, 1967 · N2950L · Destroyed NTSB NYC68D0068Accident · No injuriesClosedPiper PA-23 · Boston, MAJul 27, 1967 · N4330Y · Substantial damage NTSB NYC68F0157Accident · Serious injuriesClosedGrumman G-44 · E Freetown, MAJul 25, 1967 · N9207H · Substantial damage NTSB NYC68D0061Accident · No injuriesClosedCessna 180 · Bedford, MAJul 22, 1967 · N2788Q · Substantial damage NTSB NYC68F0058Accident · No injuriesClosedPiper PA-28 · Norwood, MAJul 20, 1967 · N4150J · Substantial damage NTSB NYC68F0302Accident · No injuriesClosedPiper PA-22 · Newburyport, MAJul 16, 1967 · N7639D · Substantial damage NTSB NYC68A0008Accident · 1 fatalClosedAeronca 7AC · Pembroke, MAJul 13, 1967 · N84425 · Destroyed NTSB NYC68D0060Accident · No injuriesClosedCessna 150 · Shirley, MAJul 11, 1967 · N3099X · Destroyed NTSB NYC68D0259Accident · No injuriesClosedCessna 170B · Chatham, MAJun 28, 1967 · N433W · Substantial damage NTSB NYC67A0188Accident · 2 fatalClosedPiper PA-28 · North Adams, MAJun 25, 1967 · N540W · Destroyed NTSB NYC68D0369Accident · No injuriesClosedAeronca 11AC · Sterling Jct, MAJun 18, 1967 · N9540E · Substantial damage NTSB NYC67A0183Accident · 1 fatalClosedPiper PA-22 · Plymouth, MAJun 18, 1967 · N7137B · Destroyed NTSB NYC67A0184Accident · Minor injuriesClosedBannick T · Agawam, MAJun 17, 1967 · N92862 · Substantial damage NTSB NYC68A0179Accident · No injuriesClosedBell 47H-1 · Canton, MAJun 15, 1967 · N8010E · Substantial damage NTSB NYC67A0176Accident · No injuriesClosedBeech J35 · Chatham, MAJun 9, 1967 · N8378D · Substantial damage NTSB NYC67F0688Accident · Serious injuriesClosedPiper PA-28 · Mendon, MAMay 18, 1967 · N8042W · Destroyed NTSB NYC67F0668Accident · No injuriesClosedPiper PA-28 · Norwood, MAMay 11, 1967 · N4540R · Substantial damage NTSB NYC67F0657Accident · Minor injuriesClosedCessna 150F · Shirley, MAApr 30, 1967 · N8948S · Destroyed NTSB NYC67A0152Accident · 4 fatalClosedBeech 23 · Naushon Isl, MAApr 30, 1967 · N8728M · Destroyed NTSB NYC67D0636Accident · No injuriesClosedPiper PA-28 · Northampton, MAApr 29, 1967 · N7916W · Substantial damage NTSB NYC67F0656Accident · Minor injuriesClosedPiper PA-28 · Norwood, MAApr 26, 1967 · N6758W · Destroyed NTSB NYC67I0138Incident · No injuriesClosedBoeing B-727 · Boston, MAApr 11, 1967 · N6731 · Minor damage NTSB NYC67D0623Accident · No injuriesClosedCessna 182 · Lexington, MAApr 11, 1967 · N2730Q · Substantial damage