Skip to content

NTSB investigations, 1980, 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, 1980, 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") = 1980 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\") = 1980
    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") = 1980
  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 NYC81FNE07Accident · No injuriesClosedPiper PA-28 · Westfield, MADec 20, 1980 · N4232F · Substantial damage NTSB NYC81FA034Accident · No injuriesClosedVolmer 1 · Norfolk, MADec 13, 1980 · N31037 · 2 aircraft · Substantial damage NTSB NYC81FNA05Accident · No injuriesClosedPiper PA-28 · Norwood, MADec 11, 1980 · N16421 · Substantial damage NTSB NYC81FNA03Accident · No injuriesClosedCessna 172 · Mansfield, MANov 27, 1980 · N12706 · Substantial damage NTSB NYC81FA014Accident · 1 fatalClosedGlobe GC-1B · West Tisbury, MANov 25, 1980 · N80674 · Destroyed NTSB NYC81FNE04Accident · 1 fatalClosedCessna C-172N · Sterling, MANov 22, 1980 · N3043E · Destroyed NTSB NYC81FNE03Accident · No injuriesClosedAerostar 601P · Worcester, MANov 18, 1980 · N6075U · Substantial damage NTSB NYC80FNA01Accident · No injuriesClosedBeech T-34A · Plymouth, MANov 6, 1980 · N45RD · Substantial damage NTSB NYC81FA003Accident · No injuriesClosedCessna 500 · Plymouth, MAOct 10, 1980 · N8JG · Substantial damage NTSB NYC81DA004Accident · No injuriesClosedCessna 150H · West Groton, MAOct 9, 1980 · N22746 · Substantial damage NTSB NYC80FNA26Accident · Serious injuriesClosedPiper PA-28 · Hanson, MASep 24, 1980 · N5910F · Destroyed NTSB NYC80FNA25Accident · No injuriesClosedN American T-28 · Dedham, MAAug 28, 1980 · N14145 · Substantial damage NTSB NYC80FA079Accident · No injuriesClosedCessna 305 · Newburyport, MAAug 27, 1980 · N5168G · Substantial damage NTSB NYC80DNA23Accident · Minor injuriesClosedBLN Works FF-7 · Edgartown, MAAug 23, 1980 · N4039Q · Substantial damage NTSB NYC80FA069Accident · 2 fatalClosedCessna 401B · Tewksbury, MAAug 12, 1980 · N2ST · Destroyed NTSB NYC80FNA21Accident · No injuriesClosedPiper PA-28R · Edgartown, MAAug 11, 1980 · N74HB · Substantial damage NTSB NYC80IA066Incident · No injuriesClosedConvair 580 · Boston, MAAug 7, 1980 · N588PL · Minor damage NTSB NYC80FNA19Accident · No injuriesClosedCessna 150 · Middleboro, MAAug 3, 1980 · N9295U · Substantial damage NTSB NYC80FNA18Accident · No injuriesClosedCessna 172 · Halifax, MAAug 3, 1980 · N1489E · Substantial damage NTSB NYC80DA063Accident · No injuriesClosedBeech B19 · Tewksbury, MAJul 31, 1980 · N6650R · Substantial damage NTSB NYC80FNE22Accident · Minor injuriesClosedBeech B23 · Hopedale, MAJul 26, 1980 · N6089N · Substantial damage NTSB NYC80DA058Accident · No injuriesClosedVarga 2150A · Marlboro, MAJul 16, 1980 · N8419J · Substantial damage NTSB NYC80DNA16Accident · No injuriesClosedPiper PA-28 · Oak Bluffs, MAJul 12, 1980 · N9858W · Substantial damage NTSB MKC80IA052Incident · No injuriesClosedBeech 99 · Boston, MAJul 8, 1980 · N100WP · Minor damage NTSB NYC80FNA15Accident · No injuriesClosedPiper PA-23 · Norwood, MAJun 23, 1980 · N129RM · Substantial damage NTSB NYC80FNE18Accident · Serious injuriesClosedCessna 172M · Worcester, MAJun 14, 1980 · N64238 · Destroyed NTSB NYC80FA045Accident · 4 fatalClosedCessna 210E · Provincetown, MAJun 14, 1980 · N4919U · Destroyed NTSB NYC80DNA13Accident · No injuriesClosedCessna 305A · Plymouth, MAJun 13, 1980 · N22SU · Substantial damage NTSB NYC80FNE17Accident · No injuriesClosedPiper PA-28 · Hampden, MAMay 28, 1980 · N21480 · Substantial damage NTSB NYC80FNA12Accident · No injuriesClosedBell 47G · Middleborough, MAMay 28, 1980 · N2277W · Substantial damage NTSB NYC80FA065Accident · No injuriesClosedVarga 2150A · Marlboro, MAMay 26, 1980 · N8419J · Substantial damage NTSB NYC80FNE14Accident · Serious injuriesClosedSchemp STD-CR · North Adams, MAMay 4, 1980 · N15WB · Substantial damage NTSB NYC80FNA10Accident · Minor injuriesClosedBell 47G-3B · Plymouth, MAMar 20, 1980 · N7943J · Substantial damage NTSB NYC80DNA11Accident · No injuriesClosedCessna 152 · Plymouth, MAMar 19, 1980 · N25589 · Substantial damage NTSB NYC80FNE12Accident · No injuriesClosedCessna 150 · Hardwick, MAMar 17, 1980 · N9283U · Substantial damage