Skip to content

NTSB investigations, 1979, MA

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 NYC80FNA06Accident · Minor injuriesClosedCessna 177RG · Mashpee, MADec 18, 1979 · N35106 · Substantial damage NTSB NYC80FNE06Accident · No injuriesClosedPiper PA-28 · Westfield, MADec 15, 1979 · N4525F · No damage NTSB NYC80DNA05Accident · No injuriesClosedCessna 172K · Bedford, MADec 8, 1979 · N79883 · Substantial damage NTSB NYC80FNA04Accident · Minor injuriesClosedCessna 182P · Marlboro, MANov 4, 1979 · N5639J · Substantial damage NTSB NYC80FA008Accident · 1 fatalClosedCessna 152 · New Bedford, MAOct 31, 1979 · N757ZW · Destroyed NTSB UNK80X0101Accident · 1 fatalClosedNavion G · Concord, MAOct 28, 1979 · N2412T · Destroyed NTSB NYC80FNE01Accident · Minor injuriesClosedPiper PA-32S · W.Springfield, MAOct 20, 1979 · N5223S · Substantial damage NTSB NYC80FNA02Accident · No injuriesClosedCessna 150H · Norton, MAOct 19, 1979 · N7001S · Substantial damage NTSB NYC80FNA01Accident · No injuriesClosedCessna 172E · So.Weymouth, MAOct 11, 1979 · N15138 · Substantial damage NTSB NYC79FNA30Accident · No injuriesClosedPiper PA-28 · Marlboro, MASep 26, 1979 · N29010 · Substantial damage NTSB NYC79AA106Accident · Minor injuriesClosedMcdonnell Douglas DC9 · Boston, MAa fatigue fracture of the aft cabin pressure bulkhead which resulted in a rapid decompression of the aircraft's cabin area. This fracture initiated from a crack below the aft bulkhead access door which was discernible on the X-rays taken during the aircraft's…Sep 17, 1979 · CF-TLU · Substantial damage NTSB NYC79FNE20Accident · 1 fatalClosedPiper PA-25 · Lee, MASep 5, 1979 · N6505Z · Destroyed NTSB NYC79FNA31Accident · No injuriesClosedCessna 150L · Tewksbury, MAAug 31, 1979 · N18585 · Substantial damage NTSB NYC79FNA29Accident · No injuriesClosedCessna 172N · Newburyport, MAAug 26, 1979 · N734QZ · Substantial damage NTSB NYC79FNA28Accident · No injuriesClosedBellanca 8GCBC · Plymouth, MAAug 18, 1979 · N50548 · Substantial damage NTSB NYC79DA077Accident · No injuriesClosedPiper PA-18 · Chatam, MAAug 15, 1979 · N8478Y · Destroyed NTSB NYC79FNA26Accident · No injuriesClosedCessna 150 · North Andover, MAJul 30, 1979 · N10796 · Substantial damage NTSB NYC79FNA24Accident · No injuriesClosedCessna 305A · Quincy, MAJul 21, 1979 · N5284G · Substantial damage NTSB NYC79DA060Accident · No injuriesClosedCessna 402 · Nantucket, MAJul 19, 1979 · N5419M · Substantial damage NTSB NYC79FNA21Accident · No injuriesClosedCessna 150M · Middleboro, MAJul 10, 1979 · N66349 · Substantial damage NTSB NYC79FNA20Accident · Minor injuriesClosedPiper PA-24 · Marshfield, MAJul 8, 1979 · N9041P · Substantial damage NTSB NYC79FNA19Accident · No injuriesClosedCiciora T-18 · West Tisbury, MAJul 4, 1979 · N64628 · Substantial damage NTSB NYC79DNA18Accident · No injuriesClosedPiper PA-22 · Boston, MAJun 27, 1979 · N733AP · Substantial damage NTSB DCA79AA019Accident · 1 fatalClosedDehavilland DHC-6 · Hyannis, MAJun 17, 1979 · N383EX · Destroyed NTSB NYC79FNA17Accident · Minor injuriesClosedStarduster SA-300 · Boxboro, MAJun 7, 1979 · N33MH · Substantial damage NTSB NYC79FNA16Accident · No injuriesClosedMiniplane DSA-1 · Boxboro, MAJun 3, 1979 · N13G · Substantial damage NTSB NYC79DNA15Accident · No injuriesClosedCessna 172 · Marlboro, MAApr 11, 1979 · N5451H · Substantial damage NTSB NYC79FNE12Accident · No injuriesClosedPiper PA-28 · Chicopee, MAMar 17, 1979 · N2163T · Substantial damage NTSB NYC79FNE08Accident · No injuriesClosedDuster BJ-1B · North Adams, MAFeb 17, 1979 · N12GT · Substantial damage NTSB NYC79FNA13Accident · No injuriesClosedCessna 500 · Boston, MAFeb 7, 1979 · N186MW · Substantial damage NTSB NYC79FNA12Accident · No injuriesClosedCessna 172 · Boston, MAJan 29, 1979 · N9701T · Substantial damage NTSB NYC79FNA11Accident · Minor injuriesClosedCessna 172 · Lawrence, MAJan 17, 1979 · N8958V · Substantial damage NTSB NYC79FA017Accident · 5 fatalClosedPiper PA-31 · Templeton, MAJan 11, 1979 · N33TN · 2 aircraft · Destroyed NTSB NYC79FNE05Accident · No injuriesClosedCessna 150 · Hardwick, MAJan 6, 1979 · N1153Y · Substantial damage