Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 NYC69F0268Accident · Serious injuriesClosedPiper PA-22 · Phippsburg, MENov 3, 1968 · N5042Z · Substantial damage NTSB NYC69F0238Accident · No injuriesClosedCessna 170 · Auburn, MENov 3, 1968 · N2621V · Substantial damage NTSB NYC69F0228Accident · No injuriesClosedCessna 140A · Monroe, MEOct 30, 1968 · CF-KMM · Substantial damage NTSB NYC69A0049Accident · Minor injuriesClosedBeech 95-D55 · Waterville, MEOct 29, 1968 · N304HA · Destroyed NTSB NYC69D0251Accident · No injuriesClosedPiper PA-22 · Wiscasset, MEOct 27, 1968 · N4724Z · Substantial damage NTSB NYC69A0038Accident · 2 fatalClosedPiper PA-22 · Bath, MESep 20, 1968 · N5861Z · Destroyed NTSB NYC69F0199Accident · No injuriesClosedBeech H35 · Augusta, MESep 19, 1968 · N7914D · Substantial damage NTSB NYC69D0167Accident · Minor injuriesClosedAeronca O-58B · N.New Portland, MESep 7, 1968 · N46058 · Substantial damage NTSB NYC69F0124Accident · Minor injuriesClosedLuscombe 8A · Fryeburg, MESep 4, 1968 · N2107K · Destroyed NTSB NYC69F0135Accident · No injuriesClosedCessna 170 · Turner, MESep 2, 1968 · N4226V · Substantial damage NTSB NYC69D0168Accident · No injuriesClosedPiper PA-25 · Bridgton, MESep 2, 1968 · N8941W · Substantial damage NTSB NYC69D0175Accident · No injuriesClosedFardy Baby C · Brunswick, MESep 1, 1968 · N6547D · Substantial damage NTSB NYC69D0136Accident · No injuriesClosedTaylorcraft BC12-D · Norway, MESep 1, 1968 · N43989 · Substantial damage NTSB NYC69D0177Accident · No injuriesClosedPitts Spec SC-1 · Sanford, MEAug 31, 1968 · N4111 · Substantial damage NTSB NYC69D0188Accident · Minor injuriesClosedPiper PA-28 · Jackman, MEAug 25, 1968 · N8543W · Substantial damage NTSB NYC69D0153Accident · No injuriesClosedCessna 172 · Lincoln, MEAug 25, 1968 · N2633U · Substantial damage NTSB NYC69A0021Accident · Serious injuriesClosedDouglas DC-8 · Presque Isle, MEAug 14, 1968 · N812PA · No damage NTSB NYC69D0108Accident · Minor injuriesClosedCessna 120 · Turner, MEJul 28, 1968 · N4033N · Substantial damage NTSB NYC69D0107Accident · No injuriesClosedCessna 140 · Vinalhaven, MEJul 27, 1968 · N72786 · Substantial damage NTSB NYC69F0090Accident · No injuriesClosedCessna 150 · Portland, MEJul 26, 1968 · N8602S · Substantial damage NTSB NYC69D0081Accident · No injuriesClosedPiper PA-28 · Union, MEJul 15, 1968 · N7567W · Substantial damage NTSB NYC69D0091Accident · No injuriesClosedErco 415-C · Mexico, MEJul 14, 1968 · N99269 · Substantial damage NTSB NYC69D0065Accident · No injuriesClosedCessna 140 · Bethel, MEJul 11, 1968 · N1885V · Substantial damage NTSB NYC69F0010Accident · No injuriesClosedCessna 150 · Pittsfield, MEJun 16, 1968 · N8105F · Substantial damage NTSB NYC69D0031Accident · No injuriesClosedCessna 172 · Meddybemps, MEJun 16, 1968 · N8549U · Substantial damage NTSB NYC68F0490Accident · No injuriesClosedThurston TSC-1A · Sanford, MEJun 8, 1968 · N1968T · Substantial damage NTSB NYC68D0480Accident · No injuriesClosedPiper PA-28 · Fort Kent, MEMay 24, 1968 · N3924K · Substantial damage NTSB NYC69F0030Accident · No injuriesClosedPiper PA-23 · Houlton, MEMay 17, 1968 · CF-CCC · Substantial damage NTSB NYC68F0440Accident · Serious injuriesClosedPiper J3C · Topsham, MEApr 13, 1968 · N42821 · Substantial damage NTSB NYC68A0113Accident · 2 fatalClosedLake LA-4 · Sanford, MEMar 29, 1968 · N7601L · Destroyed NTSB NYC68D0402Accident · No injuriesClosedAeronca 7AC · Madawaska, MEMar 23, 1968 · N2338E · Substantial damage NTSB NYC68D0400Accident · No injuriesClosedPiper PA-28 · Waterville, MEMar 14, 1968 · N5716W · Substantial damage NTSB NYC68D0399Accident · No injuriesClosedCessna 150 · Caribou, MEFeb 28, 1968 · N6580F · Substantial damage NTSB NYC68A0103Accident · 3 fatalClosedPiper PA-28 · Auburn, MEFeb 28, 1968 · N4761L · Destroyed NTSB NYC68F0371Accident · No injuriesClosedBeech 35 · Old Town, MEFeb 25, 1968 · N3114V · Substantial damage NTSB NYC68F0367Accident · No injuriesClosedMooney M20C · Augusta, MEFeb 4, 1968 · N7874V · Substantial damage NTSB NYC68D0356Accident · No injuriesClosedCessna 140 · Milo, MEJan 20, 1968 · N89261 · Substantial damage NTSB NYC68D0338Accident · No injuriesClosedLuscombe 8F · Trenton, MEJan 14, 1968 · N9903C · Substantial damage