Skip to content

NTSB investigations, 1972, ME

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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

19622026

NTSB investigations, 1972, ME per year, 1962–2026: 1,006 cases
1962	1
1964	27
1965	19
1966	34
1967	29
1968	38
1969	17
1970	13
1971	28
1972	40
1973	32
1974	23
1975	25
1976	26
1977	32
1978	25
1979	27
1980	21
1981	17
1982	18
1983	17
1984	22
1985	15
1986	16
1987	14
1988	15
1989	16
1990	12
1991	19
1992	20
1993	22
1994	19
1995	12
1996	14
1997	7
1998	10
1999	13
2000	12
2001	15
2002	10
2003	10
2004	12
2005	9
2006	14
2007	9
2008	13
2009	14
2010	10
2011	16
2012	11
2013	8
2014	8
2015	4
2016	7
2017	8
2018	4
2019	11
2020	6
2021	3
2022	5
2023	6
2024	9
2025	8
2026	9

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" = 'ME' 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\" = 'ME' 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" = 'ME' 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 NYC73AN089Accident · 2 fatalClosedCessna 170A · Turner, MEDec 27, 1972 · N1452D · Destroyed NTSB NYC73DNC41Accident · No injuriesClosedCessna 150 · Brewer, MEDec 2, 1972 · N17046 · Substantial damage NTSB NYC73DNC42Accident · No injuriesClosedLuscombe 8F · Turner, MENov 25, 1972 · N1553B · Substantial damage NTSB NYC73DNC38Incident · No injuriesClosedPiper PA-23 · Stonington, MENov 21, 1972 · N5933Y · Minor damage NTSB NYC73DNC37Incident · Minor injuriesClosedCessna 172 · Waterville, MEOct 27, 1972 · N1747F · Minor damage NTSB NYC73DNC36Accident · Minor injuriesClosedAeronca 7AC · Northeast Hbr, MEOct 27, 1972 · N3088E · Substantial damage NTSB NYC73FNC34Accident · No injuriesClosedPiper PA-30 · Pittsfield, MEOct 26, 1972 · N7283Y · Substantial damage NTSB NYC73FNC33Accident · No injuriesClosedSikorsky S-55B · Bridgton, MEOct 26, 1972 · N6734 · Substantial damage NTSB NYC73DNC35Accident · Minor injuriesClosedCessna 150 · Rockland, MEOct 26, 1972 · N5664E · Destroyed NTSB NYC73FNC31Accident · No injuriesClosedPiper PA-28R · East Corinth, MEOct 14, 1972 · N4694J · Substantial damage NTSB NYC73FNC27Accident · Minor injuriesClosedPiper PA-20 · Hampden, MEOct 8, 1972 · N1556A · Destroyed NTSB NYC73INO53Incident · No injuriesClosedCessna 195 · Ellsworth, MEOct 3, 1972 · N9879A · Minor damage NTSB NYC73AN047Accident · 1 fatalClosedBell H-13G · Readfield, MESep 27, 1972 · N64816 · Substantial damage NTSB NYC73FNC30Accident · No injuriesClosedCessna 150 · Turner, MESep 20, 1972 · N6354G · Substantial damage NTSB NYC73DNC25Accident · Minor injuriesClosedCessna 185C · Skinner, MESep 13, 1972 · N5858T · Destroyed NTSB NYC73FNC22Accident · Serious injuriesClosedCessna 150 · Pittsfield, MESep 5, 1972 · N7728E · Substantial damage NTSB NYC73FNC19Accident · No injuriesClosedCessna 182 · Sanford, MEAug 31, 1972 · N5610B · Substantial damage NTSB NYC73AN038Accident · No injuriesClosedCessna 182A · Thomaston, MEAug 26, 1972 · N4874D · Destroyed NTSB NYC73FNC29Accident · Serious injuriesClosedSchleicher KA-6 · Farmingdale, MEAug 19, 1972 · N4333 · Substantial damage NTSB NYC73DNC18Accident · Minor injuriesClosedPiper PA-22 · Tenants Harbor, MEAug 13, 1972 · N4776Z · Substantial damage NTSB NYC73FNC14Accident · No injuriesClosedCessna 210D · Oxford, MEJul 29, 1972 · N3940Y · Substantial damage NTSB NYC73DNC07Incident · No injuriesClosedBeagle B206S · Machias, MEJul 24, 1972 · N1885S · Minor damage NTSB NYC73DNC05Accident · Minor injuriesClosedBoeing A-75 · Minot, MEJul 23, 1972 · N57849 · Substantial damage NTSB NYC73DNC17Accident · Minor injuriesClosedBoeing E75 · Ft.Fairfield, MEJul 18, 1972 · N9058H · Substantial damage NTSB NYC73DNC13Accident · No injuriesClosedPiper PA-28 · Monticello, MEJul 18, 1972 · N9430J · Substantial damage NTSB NYC73AN010Accident · 4 fatalClosedCessna T337D · Belfast, MEJul 14, 1972 · N86018 · Destroyed NTSB NYC73FNC06Accident · No injuriesClosedPiper PA-24 · Wiscasset, MEJul 8, 1972 · N666TS · Substantial damage NTSB NYC73DNC03Accident · No injuriesClosedBell 47D1 · Readfield, MEJul 6, 1972 · N10193 · Substantial damage NTSB NYC73FNC02Accident · No injuriesClosedCessna 205 · Fayette, MEJul 5, 1972 · N100QP · Substantial damage NTSB NYC72FNC53Accident · Serious injuriesClosedCessna 170B · Greenville, MEJun 21, 1972 · N2592C · Destroyed NTSB NYC72DNC52Accident · No injuriesClosedCessna 182C · N.New Portland, MEMay 27, 1972 · N8951T · Substantial damage NTSB NYC72FNC42Accident · Serious injuriesClosedStinson 108-3 · Princeton, MEApr 30, 1972 · N6070M · Substantial damage NTSB NYC72FNC40Accident · Minor injuriesClosedCessna 175 · Old Town, MEApr 30, 1972 · N7543M · Substantial damage NTSB NYC72FNC36Accident · No injuriesClosedCessna 195A · Biddeford, MEApr 9, 1972 · N1513D · Substantial damage NTSB NYC72DNC37Accident · No injuriesClosedCessna 150 · Auburn, MEApr 9, 1972 · N3610J · Substantial damage NTSB NYC72DNC39Accident · No injuriesClosedPiper PA-18 · Clinton, MEMar 30, 1972 · N4275Z · Substantial damage NTSB NYC72FNC32Accident · No injuriesClosedCessna 180H · Chamberlain, MEMar 16, 1972 · N91309 · Substantial damage NTSB NYC72DNC30Accident · Minor injuriesClosedBeech 58 · Millinocket, MEMar 7, 1972 · N4626A · Substantial damage NTSB NYC72DNC29Accident · No injuriesClosedPiper PA-28 · Auburn, MEFeb 25, 1972 · N9514W · Substantial damage NTSB NYC72FNC21Incident · 1 fatalClosedStinson 108-3 · Princeton, MEJan 7, 1972 · N6070M · Minor damage