Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 NYC74DNA29Accident · No injuriesClosedCessna 180 · Stow, MADec 23, 1973 · N1607C · Substantial damage NTSB DCA74AZ014Accident · Serious injuriesClosedDouglas DC-10 · Boston, MADec 17, 1973 · EC-CBN · Substantial damage NTSB NYC74FNA28Accident · No injuriesClosedCessna 150L · Lawrence, MADec 2, 1973 · N7529G · Substantial damage NTSB NYC74DNA27Accident · No injuriesClosedBeech 35C33A · Hyannis, MANov 22, 1973 · N7978M · Substantial damage NTSB NYC74AN043Accident · 4 fatalClosedCessna 402B · W Stockbrdge, MANov 16, 1973 · N50YL · Destroyed NTSB NYC74DNA25Accident · No injuriesClosedAmer Avco AA-1A · Bedford, MANov 13, 1973 · N9411L · Substantial damage NTSB NYC74DNA26Accident · Minor injuriesClosedPiper PA-22 · Stow, MANov 4, 1973 · N5269Z · Substantial damage NTSB DCA74AZ016Accident · 3 fatalClosedBoeing 707 · Boston, MANov 3, 1973 · N458PA · Destroyed NTSB NYC74FNA24Accident · No injuriesClosedLake LA-4 · Norwood, MAOct 27, 1973 · N7631L · Substantial damage NTSB NYC74DNA22Accident · No injuriesClosedCessna 177RG · Mansfield, MAOct 22, 1973 · N1991Q · Substantial damage NTSB NYC74AN033Accident · 3 fatalClosedPiper PA-23 · Spencer, MAOct 10, 1973 · N4745P · Destroyed NTSB NYC74DNA19Accident · No injuriesClosedBeech P35 · Plymouth, MAOct 6, 1973 · N1754G · Substantial damage NTSB NYC74DNA18Accident · Minor injuriesClosedChampion 7ECA · Malboro, MAOct 6, 1973 · N5116T · Destroyed NTSB NYC74DNA20Accident · No injuriesClosedPiper PA-28R · Marlboro, MASep 26, 1973 · N2279T · Substantial damage NTSB NYC74AN030Accident · 1 fatalClosedBeech 95-B55 · East Boston, MASep 23, 1973 · N8437N · Destroyed NTSB NYC74AN029Accident · 1 fatalClosedCessna 172K · Becket, MASep 22, 1973 · N78638 · Destroyed NTSB NYC74FNE07Accident · No injuriesClosedPiper PA-28 · Worcester, MASep 19, 1973 · N15531 · Substantial damage NTSB NYC74IN026Incident · No injuriesClosedLear 24 · Boston, MASep 18, 1973 · N7HA · Minor damage NTSB NYC74DNE06Accident · No injuriesClosedCessna 150 · Orange, MASep 16, 1973 · N18637 · Substantial damage NTSB NYC74DNA21Accident · No injuriesClosedChampion 7AC · Tewksbury, MASep 16, 1973 · N1816G · Substantial damage NTSB NYC74FNE04Accident · No injuriesClosedNoorduyn UC-64A · Orange, MASep 10, 1973 · N7990K · Substantial damage NTSB NYC74FNA16Accident · No injuriesClosedCessna 206 · East Boston, MASep 9, 1973 · N50463 · Substantial damage NTSB NYC74FNA17Accident · No injuriesClosedCessna 182 · Bedford, MASep 8, 1973 · N92153 · Substantial damage NTSB NYC74FNA15Accident · No injuriesClosedCessna 172L · Stow, MASep 7, 1973 · N6061Y · Substantial damage NTSB NYC74FNA14Accident · Minor injuriesClosedPiper PA-28 · Danvers, MASep 3, 1973 · N9572J · Substantial damage NTSB NYC74FNA12Accident · Minor injuriesClosedAmer Avco AA1-B · Tewksbury, MAAug 30, 1973 · N6273L · Substantial damage NTSB NYC74AN019Accident · 3 fatalClosedBeech 23 · Scituate, MAAug 30, 1973 · N7681R · Destroyed NTSB NYC74AN017Accident · 2 fatalClosedPiper PA-12 · Haverhill, MAAug 19, 1973 · N4192M · Destroyed NTSB NYC74FNE03Accident · No injuriesClosedCessna 150 · Westfield, MAAug 16, 1973 · N19488 · Substantial damage NTSB NYC74FNE02Accident · No injuriesClosedCessna 150F · Wendell, MAAug 13, 1973 · N8860G · Substantial damage NTSB NYC74FNA10Accident · No injuriesClosedLet Blanik L-13 · Pepperell, MAAug 4, 1973 · N93220 · Substantial damage NTSB NYC74FNA06Accident · Serious injuriesClosedPiper PA-28 · N.Andover, MAAug 4, 1973 · N15807 · Substantial damage NTSB NYC74FNA07Accident · No injuriesClosedPiper PA-24 · Vineyard Hav, MAJul 31, 1973 · N8659P · Substantial damage NTSB DCA74AZ004Accident · 88 fatalClosedDouglas DC-9 · Boston, MAJul 31, 1973 · N975NE · Destroyed NTSB NYC74DNA09Accident · No injuriesClosedBeech C18S · W.Falmouth, MAJul 30, 1973 · N44565 · Destroyed NTSB NYC74FNA05Accident · No injuriesClosedPiper PA-32 · Plymouth, MAJul 24, 1973 · N4213R · Substantial damage NTSB NYC74AN005Accident · 1 fatalClosedPiper PA-28 · Martha Vinyd, MAJul 10, 1973 · N2679T · Substantial damage NTSB NYC74FNA02Accident · No injuriesClosedPiper PA-24 · Chatham, MAJul 7, 1973 · N7462P · Substantial damage NTSB NYC74FNA01Accident · No injuriesClosedCessna 177RG · New Bedford, MAJul 7, 1973 · N1945Q · Substantial damage NTSB NYC74AN004Accident · 5 fatalClosedCessna 172L · Douglas, MAJul 1, 1973 · N19663 · Substantial damage NTSB NYC73FNA53Accident · No injuriesClosedBeech B23 · Danvers, MAJun 28, 1973 · N7617R · Substantial damage NTSB NYC73FNE36Accident · No injuriesClosedCessna 310Q · Westfield, MAJun 26, 1973 · N7667Q · Substantial damage NTSB NYC73FNE35Accident · No injuriesClosedViking B-8 · Westboro, MAJun 24, 1973 · N753Y · Substantial damage NTSB NYC73AN152Accident · No injuriesClosedDouglas DC-8 · Boston, MAJun 15, 1973 · HP-IDK · Substantial damage NTSB NYC73FNA52Accident · No injuriesClosedCessna 195B · Chatham, MAJun 14, 1973 · N2109C · Substantial damage NTSB NYC74FNA04Accident · No injuriesClosedBensen B8M · Plymouth, MAJun 3, 1973 · N6026 · Substantial damage NTSB NYC73AN148Accident · 2 fatalClosedBeech D18S · Feeding Hill, MAJun 2, 1973 · N8615A · Destroyed NTSB NYC73FNA50Accident · No injuriesClosedCessna 310C · Hyannis, MAMay 30, 1973 · N6727T · Substantial damage NTSB NYC73DNA49Accident · No injuriesClosedPiper J-3 · N.Andover, MAMay 27, 1973 · N42739 · Substantial damage NTSB NYC73FNE33Accident · No injuriesClosedCessna 150L · Northamton, MAMay 13, 1973 · N18678 · Substantial damage