Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 NYC73FNA33Accident · No injuriesClosedEnstrom F-28A · Marshfield, MADec 23, 1972 · N4879 · Substantial damage NTSB NYC73DNA32Accident · No injuriesClosedTaylorcraft BL1265 · E.Falmouth, MADec 19, 1972 · N34035 · Destroyed NTSB NYC73FNE13Accident · No injuriesClosedCessna 170 · Turner Falls, MADec 18, 1972 · N2587V · Substantial damage NTSB NYC73FNE11Accident · No injuriesClosedPiper PA-28 · Oxford, MADec 9, 1972 · N613FL · Substantial damage NTSB NYC73FNA31Accident · Minor injuriesClosedCessna 150K · Middleboro, MANov 19, 1972 · N6294G · Substantial damage NTSB NYC73AN068Accident · Serious injuriesClosedCessna 172E · Tewksbury, MANov 19, 1972 · N5603T · 2 aircraft · Substantial damage NTSB NYC73FNA30Accident · No injuriesClosedAmer Avco AA1A · Haverhill, MANov 12, 1972 · N6378L · Substantial damage NTSB NYC72FNA29Accident · No injuriesClosedCessna 310I · New Bedford, MAOct 25, 1972 · N922GB · Substantial damage NTSB NYC73DNA28Accident · No injuriesClosedPiper PA-28 · Taunton, MAOct 14, 1972 · N98289 · Substantial damage NTSB NYC73DNA25Accident · No injuriesClosedCessna 182 · Falmouth, MAOct 10, 1972 · N9211G · Substantial damage NTSB NYC73FNA23Accident · Minor injuriesClosedMooney M20E · Lexington, MAOct 9, 1972 · N6938U · Substantial damage NTSB NYC72DNA24Accident · No injuriesClosedCessna 180 · Chatham, MAOct 9, 1972 · N481D · Substantial damage NTSB NYC73FNA22Accident · No injuriesClosedCessna 150 · Bedford, MAOct 4, 1972 · N6346G · Substantial damage NTSB NYC73DNA27Accident · Minor injuriesClosedPiper PA-22 · Edgartown, MASep 24, 1972 · N4692Z · Destroyed NTSB NYC73FNA20Accident · No injuriesClosedCessna 177 · Oak Bluffs, MASep 8, 1972 · N34201 · Substantial damage NTSB NYC73DNA21Accident · No injuriesClosedAmer Avco AA-1 · Hopedale, MAAug 23, 1972 · N9413L · Substantial damage NTSB NYC73FNA14Accident · No injuriesClosedBlanik L-13 · Plymouth, MAAug 20, 1972 · N11YA · Substantial damage NTSB NYC73DNA13Accident · No injuriesClosedCessna 150J · Middleboro, MAAug 17, 1972 · N60248 · Substantial damage NTSB NYC73AN029Accident · 2 fatalClosedBrantly B-2B · Duxbury, MAAug 15, 1972 · N2254U · Destroyed NTSB NYC73AN028Accident · 5 fatalClosedCessna 172I · Hopedale, MAAug 15, 1972 · N752ST · Destroyed NTSB NYC73FNA12Accident · Serious injuriesClosedPiper PA-32 · Nantucket, MAAug 13, 1972 · N4196R · Substantial damage NTSB NYC73FNA11Accident · Serious injuriesClosedCessna 177 · Nantucket, MAAug 10, 1972 · N3225T · Substantial damage NTSB NYC73IN023Incident · No injuriesClosedAerostar 601 · Boston, MAAug 3, 1972 · N7450S · Minor damage NTSB NYC73FNA09Accident · Serious injuriesClosedPiper PA-28 · Haverhill, MAAug 2, 1972 · N5813U · Destroyed NTSB NYC73FNA08Accident · No injuriesClosedCessna 150 · Norwood, MAJul 30, 1972 · N5907G · Substantial damage NTSB NYC73AN018Accident · 2 fatalClosedTaylorcraft L-2B · No.Andover, MAJul 30, 1972 · N47120 · Destroyed NTSB NYC73DNA06Accident · No injuriesClosedAmer Avco AA1 · Mansfield, MAJul 28, 1972 · N9382L · Substantial damage NTSB NYC73FNA07Accident · No injuriesClosedCessna 150L · Chatham, MAJul 24, 1972 · N16007 · Substantial damage NTSB NYC73FNE03Accident · Minor injuriesClosedCessna 172E · Sterling, MAJul 14, 1972 · N3689S · Destroyed NTSB NYC73FNA03Accident · No injuriesClosedPiper J3C-65 · Halifax, MAJul 8, 1972 · N42186 · Substantial damage NTSB NYC72FNA02Accident · No injuriesClosedBoeing A75 · Wareham, MAJul 7, 1972 · N1419M · Substantial damage NTSB NYC73FNA01Accident · No injuriesClosedCessna 182B · Concord, MAJul 5, 1972 · N2524G · Substantial damage NTSB NYC73IN002Incident · No injuriesClosedDouglas DC-8 · Ea.Boston, MAJul 2, 1972 · HB-IDG · Minor damage NTSB NYC73FNE02Accident · Minor injuriesClosedPiper PA-28 · Fitchburg, MAJul 2, 1972 · N601FL · Substantial damage NTSB NYC73DNA05Accident · No injuriesClosedCessna 150J · Groton, MAJul 2, 1972 · N5549G · Substantial damage NTSB NYC72DNA48Accident · Minor injuriesClosedPiper PA-12 · Falmouth, MAJun 26, 1972 · N2468M · Substantial damage NTSB NYC72DNA47Accident · Minor injuriesClosedAeronca 7BCM · Norfolk, MAJun 24, 1972 · N1965E · Substantial damage NTSB NYC72FNA45Accident · No injuriesClosedPiper PA-24 · Hopedale, MAJun 17, 1972 · N7825P · Substantial damage NTSB NYC72FNA43Accident · Minor injuriesClosedCessna 180 · Concord, MAJun 11, 1972 · N1798C · Substantial damage NTSB NYC72FNA42Accident · No injuriesClosedPiper PA-24 · Hopedale, MAJun 11, 1972 · N1Q · Substantial damage NTSB NYC72FNA44Accident · No injuriesClosedLuscombe 8A · Marshfield, MAJun 2, 1972 · N71827 · Substantial damage NTSB NYC72IN145Incident · No injuriesClosedBoeing 747 · Boston, MAMay 24, 1972 · N743PA · Minor damage NTSB NYC72FNA41Accident · Serious injuriesClosedBell 47D · Accord, MAMay 12, 1972 · N177B · Destroyed NTSB NYC72FNA38Accident · No injuriesClosedPiper PA-28R · Plymouth, MAApr 29, 1972 · N7530J · Substantial damage NTSB NYC72FNA39Accident · No injuriesClosedPiper PA-28 · Brockton, MAApr 24, 1972 · N5396S · Substantial damage NTSB NYC72AN122Accident · 1 fatalClosedPiper PA-23 · Acton, MAApr 6, 1972 · N6342L · Destroyed NTSB NYC72DNE33Accident · No injuriesClosedPiper PA-28 · Westboro, MAApr 1, 1972 · N696FL · Substantial damage NTSB NYC72FNA37Accident · Serious injuriesClosedPiper PA-24 · Marshfield, MAMar 11, 1972 · N6322P · Substantial damage NTSB NYC72FNE30Accident · No injuriesClosedCessna 150H · Sterling, MAMar 9, 1972 · N6455S · Substantial damage NTSB NYC72AN104Accident · 2 fatalClosedCessna 421B · East Boston, MAMar 2, 1972 · N456CB · Destroyed