Skip to content

NTSB investigations, 1975, 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 NYC76FNA24Accident · No injuriesClosedPiper PA-28R · Fall River, MADec 31, 1975 · N9483N · Substantial damage NTSB NYC76DNA23Accident · No injuriesClosedMooney M-18C · Falmouth, MADec 27, 1975 · N4094 · Substantial damage NTSB NYC76AN061Accident · No injuriesClosedBeech E18S · Boston, MADec 24, 1975 · N911E · Substantial damage NTSB NYC76IN058Incident · No injuriesClosedPiper PA-23 · Boston, MADec 23, 1975 · N48PB · Minor damage NTSB NYC76FNE12Accident · Serious injuriesClosedAeronca 7AC · Charlton, MADec 7, 1975 · N1244E · Substantial damage NTSB NYC76FNA22Accident · Minor injuriesClosedPiper PA-28 · Malboro, MANov 29, 1975 · N693CA · Substantial damage NTSB NYC76FNA21Accident · Serious injuriesClosedGrumman G-44A · Haverhill, MANov 9, 1975 · N77K · Substantial damage NTSB NYC76FNA20Accident · Minor injuriesClosedAero Comdr 112A · Westwood, MAOct 26, 1975 · N1288J · Destroyed NTSB NYC76AN046Accident · 2 fatalClosedPiper PA-28 · Williamstown, MAOct 25, 1975 · N43452 · Destroyed NTSB CHI76IC032Incident · No injuriesClosedBoeing 747 · Boston, MAOct 21, 1975 · N4711U · Minor damage NTSB NYC76DNA18Accident · No injuriesClosedBeech B19 · Beverly, MAOct 16, 1975 · N9749L · Substantial damage NTSB NYC7LFNA17Accident · No injuriesClosedAeronca 15AC · Wareham, MAOct 5, 1975 · N1365H · Substantial damage NTSB NYC76FNE08Accident · 1 fatalClosedSchweizer SGS126 · Williamstown, MAOct 5, 1975 · N33906 · Destroyed NTSB NYC76FNE07Accident · No injuriesClosedSchweizer SGS233 · North Adams, MAOct 4, 1975 · N33981 · Substantial damage NTSB NYC76IN053Incident · No injuriesClosedPiper PA-34 · Boston, MASep 19, 1975 · N56121 · Minor damage NTSB NYC76DNA15Accident · No injuriesClosedFairchild 24 · Norfolk, MASep 7, 1975 · N46257 · Substantial damage NTSB NYC76AN030Accident · 3 fatalClosedBeech B95A55 · Hyannis, MASep 6, 1975 · N1426G · Destroyed NTSB NYC76FNE05Accident · No injuriesClosedThurston TSC-1A · Westboro, MASep 4, 1975 · N2011T · Substantial damage NTSB NYC76FNA14Accident · No injuriesClosedTaylorcraft BL-65 · Taunton, MASep 1, 1975 · N36314 · Substantial damage NTSB NYC76AN029Accident · No injuriesClosedCessna 150 · Fitchburg, MAAug 28, 1975 · N3888V · 2 aircraft · Substantial damage NTSB NYC76FNA13Accident · No injuriesClosedPiper PA-34 · Newburyport, MAAug 22, 1975 · N4519T · Substantial damage NTSB NYC75FNE04Accident · No injuriesClosedCessna 172M · Worthington, MAAug 17, 1975 · N12801 · Substantial damage NTSB NYC76FNA12Accident · No injuriesClosedEnstrom F28 · Falmouth, MAAug 16, 1975 · N9578 · Destroyed NTSB NYC76FNA11Accident · Serious injuriesClosedCessna 305A · Plymouth, MAAug 14, 1975 · N513G · Destroyed NTSB NYC76FNA09Accident · No injuriesClosedCessna 150 · Norwood, MAAug 9, 1975 · N7949F · Substantial damage NTSB NYC7LFNA10Accident · No injuriesClosedPiper PA-28 · Vineyard Haven, MAAug 8, 1975 · N55513 · Substantial damage NTSB NYC76AN022Accident · 1 fatalClosedCessna 182K · Provincetown, MAAug 8, 1975 · N2693Q · Destroyed NTSB NYC76FNE03Accident · Minor injuriesClosedPiper J-3 · S Deerfield, MAAug 3, 1975 · N7279H · Substantial damage NTSB NYC76DNA06Accident · No injuriesClosedCessna 337 · Provincetown, MAAug 3, 1975 · N574V · Substantial damage NTSB NYC76AN019Accident · 1 fatalClosedN.American SNJ-3 · Wilmington, MAAug 3, 1975 · N66233 · Destroyed NTSB NYC76ANA07Accident · Minor injuriesClosedGrum Amer AA1-B · Stow, MAAug 2, 1975 · N8877L · Substantial damage NTSB NYC76FNA08Accident · No injuriesClosedAmer Avco AA1-A · Ayer, MAAug 1, 1975 · N9406L · Substantial damage NTSB NYC76DNA03Accident · Minor injuriesClosedBellanca 7ECA · Martha Vinyard, MAJul 29, 1975 · N1816G · Destroyed NTSB NYC76FHA04Accident · 1 fatalClosedBede 4 · Seekonk, MAJul 26, 1975 · N4542 · Destroyed NTSB NYC76FNA02Accident · No injuriesClosedCessna 177RG · Marlboro, MAJul 24, 1975 · N2030Q · Substantial damage NTSB NYC76AN010Accident · No injuriesClosedCessna 402A · Hyannis, MAJul 18, 1975 · N4533Q · Substantial damage NTSB NYC76FNA01Accident · No injuriesClosedMooney M20F · Methuen, MAJul 8, 1975 · N9456V · Substantial damage NTSB NYC76AN006Accident · Serious injuriesClosedRaven S-50A · Foxboro, MAJul 5, 1975 · N71CT · Minor damage NTSB NYC76DNA16Accident · No injuriesClosedPiper PA-30 · Edgartown, MAJul 3, 1975 · N7260Y · Substantial damage NTSB NYC76AN001Accident · 1 fatalClosedPiper J3 · Stow, MAJul 3, 1975 · N2112M · Substantial damage NTSB NYC75FNE39Accident · Serious injuriesClosedSchweizer SGS233 · Sterling, MAJun 26, 1975 · N1222S · Substantial damage NTSB NYC75DNA48Accident · No injuriesClosedPiper PA-24 · Tewksbury, MAJun 24, 1975 · N5570P · Substantial damage NTSB NYC75FNA47Accident · No injuriesClosedPiper PA-28 · Bedford, MAJun 23, 1975 · N55498 · Substantial damage NTSB NYC75FNA46Accident · Serious injuriesClosedPiper PA-28 · Oak Bluffs, MAJun 22, 1975 · N9408T · Substantial damage NTSB NYC75FNE41Accident · No injuriesClosedBlanik L-13 · New Braintree, MAJun 21, 1975 · N2821H · Substantial damage NTSB NYC75AN119Accident · Minor injuriesClosedFairchild FH-227 · New Bedford, MAJun 13, 1975 · N378NE · Substantial damage NTSB NYC75AN116Accident · 1 fatalClosedN.American F-51D · Edgartown, MAJun 8, 1975 · N76AF · Destroyed NTSB NYC75AN110Accident · Minor injuriesClosedHughes 269B · Westfield, MAMay 28, 1975 · N103KC · Destroyed NTSB NYC7KFNA44Accident · Minor injuriesClosedHelio Acft H295 · Forge Village, MAMay 23, 1975 · N99PM · Substantial damage NTSB NYC75DNA41Accident · Minor injuriesClosedDehavilland DH 82A · Tewksbury, MAMay 23, 1975 · N8223 · Substantial damage