Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 NYC78FA017Accident · 2 fatalClosedHughes 269B · Quincy, MADec 27, 1977 · N9364F · Destroyed NTSB NYC78FNE01Accident · No injuriesClosedGrum Amer AA5-A · Sterling, MADec 24, 1977 · N9961U · Substantial damage NTSB NYC78FA011Accident · 1 fatalClosedCessna 206 · Taunton, MANov 30, 1977 · N2119F · Destroyed NTSB NYC78FA006Accident · 2 fatalClosedPorterfield 35W · Ft Devens, MANov 12, 1977 · N19448 · Destroyed NTSB NYC77FNA02Accident · No injuriesClosedPiper PA-30 · Plymouth, MAOct 31, 1977 · N7895Y · Substantial damage NTSB NYC78FNA04Accident · No injuriesClosedCessna 150 · Mansfield, MAOct 29, 1977 · N9470U · Substantial damage NTSB NYC78DNA01Accident · No injuriesClosedCessna 172 · Chatham, MAOct 5, 1977 · N76050 · Substantial damage NTSB NYC78DNA07Accident · No injuriesClosedCessna 182C · Pepperell, MAOct 2, 1977 · N8776T · Substantial damage NTSB NYC77FNA34Accident · No injuriesClosedCessna 182P · Mansfield, MASep 18, 1977 · N52793 · Substantial damage NTSB NYC77IA097Incident · No injuriesClosedMorane 235E · Plymouth, MASep 16, 1977 · F-ODFV · Minor damage NTSB NYC77FNA32Accident · No injuriesClosedAeronca 7AC · Stow, MASep 4, 1977 · N84453 · Substantial damage NTSB NYC77FNA31Accident · Serious injuriesClosedGrum Amer AA1B · Tewksbury, MAAug 29, 1977 · N8980L · Substantial damage NTSB NYC77FNE34Accident · Minor injuriesClosedNoorduyn UC64A · New Salem, MAAug 28, 1977 · N69795 · Destroyed NTSB NYC77FNA29Accident · No injuriesClosedPiper PA-28 · Chatham, MAAug 23, 1977 · N1526X · Substantial damage NTSB NYC77DNA33Accident · No injuriesClosedCitabria 7ECA · Race Point, MAAug 9, 1977 · N5171X · Destroyed NTSB NYC77FNE31Accident · Minor injuriesClosedCessna 150 · Hampden, MAJul 31, 1977 · N11109 · Substantial damage NTSB NYC77FNA25Accident · Serious injuriesClosedPiper PA-28 · Edgartown, MAJul 30, 1977 · N57363 · Substantial damage NTSB NYC77IA074Incident · Minor injuriesClosedDouglas DC-10 · Boston, MAJul 28, 1977 · N121AA · Minor damage NTSB NYC77FNA30Accident · No injuriesClosedStinson 108-3 · Marshfield, MAJul 27, 1977 · N584C · Substantial damage NTSB NYC77DNA24Accident · No injuriesClosedAero Comdr 100 · Hyannis, MAJul 26, 1977 · N2948T · Substantial damage NTSB NYC77DNA26Accident · No injuriesClosedBellanca 7GCBC · New Bedford, MAJul 16, 1977 · N53824 · Substantial damage NTSB NYC77FNA22Accident · No injuriesClosedPiper PA-18 · Oak Bluffs, MAJul 15, 1977 · N8975D · Destroyed NTSB NYC77DNA21Accident · No injuriesClosedCessna 310Q · Provincetown, MAJul 14, 1977 · N69684 · Destroyed NTSB NYC77FNE30Accident · No injuriesClosedPiper PA-32 · New Marlboroug, MAJul 11, 1977 · N3737W · Substantial damage NTSB NYC77FA070Accident · 3 fatalClosedPiper PA-28R · Hingham, MAJul 8, 1977 · N5275S · Destroyed NTSB NYC77FNA24Accident · No injuriesClosedCessna 310D · Norwood, MAJul 6, 1977 · N6758T · Substantial damage NTSB NYC77FNE25Accident · Minor injuriesClosedCessna 172 · Oxford, MAJun 28, 1977 · N79142 · Substantial damage NTSB NYC77FNE22Accident · 1 fatalClosedPiper PA-25 · Amherst, MAJun 20, 1977 · N6063Z · Destroyed NTSB NYC77FA064Accident · 2 fatalClosedErco 415C · New Bedford, MAJun 15, 1977 · N3762H · Destroyed NTSB NYC77FNA19Accident · Serious injuriesClosedCessna 207 · Vineyard Haven, MAJun 14, 1977 · N1718U · Substantial damage NTSB NYC77FA066Accident · 2 fatalClosedCessna 172K · Nantucket, MAJun 13, 1977 · N79005 · Destroyed NTSB NYC77FA063Accident · 1 fatalClosedBellanca 8KCAB · Haverhill, MAJun 7, 1977 · N86770 · Substantial damage NTSB NYC77DNA18Accident · No injuriesClosedCessna 206 · Boston, MAJun 3, 1977 · N4656Q · Substantial damage NTSB NYC77DNA17Accident · No injuriesClosedCessna 150 · Haverhill, MAMay 22, 1977 · N714SS · Substantial damage NTSB NYC77FNE19Accident · No injuriesClosedCassutt 3 · Gardner, MAMay 21, 1977 · N164 · Substantial damage NTSB NYC77FA058Accident · Serious injuriesClosedPiper PA-30 · Plymouth, MAMay 20, 1977 · N8661Y · Substantial damage NTSB NYC77FNE17Accident · No injuriesClosedLake LA-4 · Ashburnham, MAApr 30, 1977 · N5013L · Substantial damage NTSB NYC77FNA16Accident · No injuriesClosedCessna 172 · Marlboro, MAApr 23, 1977 · N79879 · Substantial damage NTSB NYC77FNE15Accident · No injuriesClosedCessna 150 · Turner Falls, MAApr 11, 1977 · N51343 · Substantial damage NTSB NYC77FNA15Accident · No injuriesClosedPiper PA-24 · Plymouth, MAApr 10, 1977 · N5855P · Substantial damage NTSB NYC77FA050Accident · Serious injuriesClosedConvair 240 · Hyannis, MAApr 9, 1977 · N10AV · Destroyed NTSB NYC77FNE12Accident · Minor injuriesClosedLuscombe 8C · Pittsfield, MAMar 27, 1977 · N28725 · Substantial damage NTSB NYC77DNA14Accident · No injuriesClosedCessna 150 · Hanson, MAMar 27, 1977 · N8717S · Substantial damage NTSB NYC77FNA13Accident · No injuriesClosedCessna 182 · Boston, MAMar 13, 1977 · N42264 · Substantial damage NTSB NYC77FA036Accident · 1 fatalClosedCessna 150M · Fitchburg, MAMar 12, 1977 · N8650U · Substantial damage NTSB NYC77FNE10Accident · No injuriesClosedCessna 150 · Hopedale, MAMar 3, 1977 · N714CP · Substantial damage NTSB NYC77DNA12Accident · No injuriesClosedGrum Amer AA-1B · Tewksbury, MAFeb 10, 1977 · N6325L · Substantial damage NTSB NYC77FNA11Accident · No injuriesClosedCessna 172M · Plymouth, MAFeb 6, 1977 · N9654Q · Substantial damage NTSB NYC77FNAL0Accident · No injuriesClosedBeech E18S · Boston, MAJan 31, 1977 · N8111 · Substantial damage NTSB NYC77FNA09Accident · Minor injuriesClosedCessna 172M · N.Andover, MAJan 16, 1977 · N64264 · Substantial damage