Skip to content

NTSB investigations, 1968, MA

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 NYC69D0289Accident · No injuriesClosedCessna 172H · East Boston, MADec 24, 1968 · N1682F · Substantial damage NTSB NYC69F0285Accident · No injuriesClosedBeech E18S · Boston, MADec 19, 1968 · N2630K · Substantial damage NTSB NYC69F0258Accident · 1 fatalClosedBensen B-8 · Marion, MANov 23, 1968 · N59284 · Destroyed NTSB NYC69D0277Accident · No injuriesClosedBell 47G-5 · Rochester, MANov 23, 1968 · N7815S · Substantial damage NTSB NYC69F0302Accident · No injuriesClosedPiper PA-23 · Agawam, MANov 19, 1968 · N3263P · Substantial damage NTSB NYC69D0253Accident · No injuriesClosedPiper PA-28 · Tewksbury, MANov 19, 1968 · N6986W · Substantial damage NTSB NYC69D0254Accident · No injuriesClosedStinson 108-1 · Shirley, MANov 16, 1968 · N9154K · Substantial damage NTSB NYC69D0255Accident · No injuriesClosedPiper PA-28 · Norwood, MANov 15, 1968 · N1660J · Substantial damage NTSB NYC69F0269Accident · Serious injuriesClosedBell 206A · Hampden, MANov 14, 1968 · N3523T · Destroyed NTSB NYC69A0050Accident · 2 fatalClosedAmer Avco AA-1 · Westwood, MANov 2, 1968 · N5608L · Destroyed NTSB NYC69A0048Accident · 2 fatalClosedPiper PA-12 · Millbury, MAOct 27, 1968 · N3927M · Destroyed NTSB NYC69F0227Accident · No injuriesClosedCessna 150F · Bedford, MAOct 23, 1968 · N8748G · Substantial damage NTSB NYC69F0256Accident · Serious injuriesClosedPiper J3 · Shirley, MAOct 20, 1968 · N42841 · Substantial damage NTSB NYC69A0043Accident · No injuriesClosedPiper PA-24 · Northampton, MASep 29, 1968 · N8127P · Substantial damage NTSB NYC69F0219Accident · Serious injuriesClosedCherokee II · Barre, MASep 16, 1968 · N8722E · Substantial damage NTSB NYC69A0031Accident · No injuriesClosedPiper PA-23 · Westfield, MASep 11, 1968 · N6591Y · Substantial damage NTSB NYC69D0202Accident · No injuriesClosedBeech 23 · Worcester, MAAug 31, 1968 · N3623G · Substantial damage NTSB NYC69D0159Accident · No injuriesClosedAeronca L-16A · Turners Fall, MAAug 31, 1968 · N1317V · Substantial damage NTSB NYC69A0023Accident · 1 fatalClosedCessna 120 · Braintree, MAAug 24, 1968 · N76424 · Destroyed NTSB NYC69F0141Accident · No injuriesClosedBeech 95-B55 · Fitchburg, MAAug 22, 1968 · N620G · Substantial damage NTSB NYC69D0138Accident · No injuriesClosedCessna 182 · Northampton, MAAug 21, 1968 · N3538F · Substantial damage NTSB NYC69A0020Accident · Minor injuriesClosedTaylorcraft BC12-D · Barre Plains, MAAug 18, 1968 · N43118 · 2 aircraft · Substantial damage NTSB NYC69F0120Accident · No injuriesClosedAeronca 7AC · Amesbury, MAAug 11, 1968 · N1700E · Substantial damage NTSB NYC69D0137Accident · Minor injuriesClosedPiper PA-28 · Southbridge, MAAug 11, 1968 · N5282W · Substantial damage NTSB NYC69A0017Accident · Minor injuriesClosedBoeing 727 · Boston, MAAug 7, 1968 · N7419U · Substantial damage NTSB NYC69F0115Accident · 1 fatalClosedBensen B-8M · Turners Fall, MAAug 4, 1968 · N8200 · Destroyed NTSB NYC69A0015Accident · No injuriesClosedCessna 337B · New Bedford, MAAug 1, 1968 · N2397S · Destroyed NTSB NYC69D0122Accident · No injuriesClosedCessna 150 · Ipswich, MAJul 30, 1968 · N8353J · Substantial damage NTSB NYC69D0057Accident · No injuriesClosedPiper PA-28 · Pembroke, MAJul 29, 1968 · N4150J · Substantial damage NTSB NYC69F0087Accident · No injuriesClosedBeech 95 · Fall River, MAJul 20, 1968 · N275Q · Substantial damage NTSB NYC69D0062Accident · Minor injuriesClosedPiper PA-28 · Edgartown, MAJul 17, 1968 · N7304W · Substantial damage NTSB NYC69D0074Accident · Minor injuriesClosedTaylorcraft BCS-65 · Agawam, MAJul 13, 1968 · N36014 · Substantial damage NTSB NYC69F0061Accident · Minor injuriesClosedCessna 175 · Marlboro, MAJul 12, 1968 · N9472B · Destroyed NTSB NYC69A0008Accident · 2 fatalClosedHelio H-391B · Royalston, MAJul 10, 1968 · N28B · 2 aircraft · Destroyed NTSB NYC69D0026Accident · No injuriesClosedCessna 172 · Norwood, MAJul 6, 1968 · N5838A · Substantial damage NTSB NYC69A0006Accident · 1 fatalClosedBeech T-34A · Newburyport, MAJul 6, 1968 · N5598A · Destroyed NTSB NYC69D0083Accident · No injuriesClosedCessna 182 · Mansfield, MAJul 5, 1968 · N42578 · Substantial damage NTSB NYC69D0075Accident · No injuriesClosedMooney M20F · Falmouth, MAJul 3, 1968 · N6393Q · Substantial damage NTSB NYC69D0102Accident · No injuriesClosedAeronca 65-CA · E.Brookfield, MAJun 18, 1968 · N36875 · Substantial damage NTSB NYC68I0131Incident · No injuriesClosedAero Comdr 500B · Marthas Vnyd, MAJun 13, 1968 · N6367U · Minor damage NTSB NYC69D0018Accident · No injuriesClosedBeech A23-19 · Oxford, MAMay 30, 1968 · N5759V · Substantial damage NTSB NYC68A0123Accident · 1 fatalClosedCessna 411 · Watertown, MAMay 29, 1968 · N7341U · Destroyed NTSB NYC68D0509Accident · No injuriesClosedCessna 185E · Fairhaven, MAMay 26, 1968 · N4705Q · Substantial damage NTSB NYC68D0482Accident · No injuriesClosedBeech A23A · Hyannis, MAMay 25, 1968 · N7961L · Substantial damage NTSB NYC69D0036Accident · No injuriesClosedCessna 180 · Orange, MAMay 8, 1968 · N2484C · Substantial damage NTSB NYC68F0489Accident · No injuriesClosedCessna 210-5 · Westboro, MAMay 5, 1968 · N8435Z · Substantial damage NTSB NYC68F0476Accident · No injuriesClosedCessna 170B · Hinsdale, MAMay 5, 1968 · N2208D · Substantial damage NTSB NYC68F0470Accident · No injuriesClosedCessna 140 · Norwood, MAMay 3, 1968 · N72827 · Substantial damage NTSB NYC68D0462Accident · No injuriesClosedTaylorcraft BC12D1 · Mansfield, MAApr 28, 1968 · N44184 · Substantial damage NTSB NYC68F0454Accident · No injuriesClosedCessna 150 · Winchendon, MAApr 22, 1968 · N8058S · Substantial damage