Skip to content

NTSB investigations, 1966, 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, 1966, 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") = 1966 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\") = 1966
    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") = 1966
  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 NYC67F0400Accident · No injuriesClosedPiper PA-18 · Augusta, MEDec 18, 1966 · N1516A · Substantial damage NTSB NYC67F0368Accident · No injuriesClosedPiper PA-24 · Auburn, MEDec 5, 1966 · N7216P · Substantial damage NTSB NYC67F0391Accident · No injuriesClosedPiper J3C-65 · Farmington, MEDec 4, 1966 · N25972 · Substantial damage NTSB NYC67A0069Accident · 2 fatalClosedCessna 180 · Greenville, MEOct 28, 1966 · N5278E · Destroyed NTSB NYC67A0068Accident · Minor injuriesClosedCessna 182F · Augusta, MEOct 27, 1966 · N3517U · Substantial damage NTSB NYC67F0298Accident · No injuriesClosedPiper PA-30 · Augusta, MEOct 14, 1966 · N7106Y · Substantial damage NTSB NYC67F0263Accident · No injuriesClosedPiper PA-28 · Etna, MEOct 8, 1966 · N7565W · Substantial damage NTSB NYC67F0281Accident · Minor injuriesClosedPiper PA-22 · Sinclair, MESep 29, 1966 · N6900B · Destroyed NTSB NYC67D0243Accident · No injuriesClosedCessna 172 · Sunset, MEAug 31, 1966 · N4213L · Substantial damage NTSB NYC67D0186Accident · Minor injuriesClosedCessna 195 · Naples, MEAug 21, 1966 · N4745G · Substantial damage NTSB NYC67D0232Accident · No injuriesClosedPiper J3C-65 · Nahmakanta Lak, MEAug 12, 1966 · N20246 · Substantial damage NTSB NYC67F0147Accident · No injuriesClosedCessna 180F · West Dover, MEAug 7, 1966 · N1810 · Substantial damage NTSB NYC67D0185Accident · No injuriesClosedCessna 170 · Mexico, MEAug 6, 1966 · N2554V · Substantial damage NTSB NYC67F0104Accident · No injuriesClosedCessna 310F · Augusta, MEAug 3, 1966 · N6754X · Substantial damage NTSB NYC67F0148Accident · No injuriesClosedPiper PA-28 · Biddeford, MEJul 30, 1966 · N8514W · Substantial damage NTSB NYC67F0087Accident · No injuriesClosedCessna 205 · Kingfield, MEJul 17, 1966 · N1820Z · Substantial damage NTSB NYC67F0073Accident · No injuriesClosedCessna 150 · Scarboro, MEJul 17, 1966 · N6508T · Substantial damage NTSB NYC67D0103Accident · No injuriesClosedCessna 185 · Millinocket, MEJul 13, 1966 · N2568Z · Substantial damage NTSB NYC67F0086Accident · No injuriesClosedPiper PA-28 · Winterport, MEJul 11, 1966 · N6910W · Substantial damage NTSB NYC67F0032Accident · No injuriesClosedPiper J365 · Ft Kent, MEJul 10, 1966 · N30779 · Substantial damage NTSB NYC67D0180Accident · No injuriesClosedErco 415-C · Sanford, MEJul 10, 1966 · N99158 · Substantial damage NTSB NYC67D0063Accident · No injuriesClosedPiper PA-22 · Bristol, MEJul 7, 1966 · N5528Z · Substantial damage NTSB NYC67F0072Accident · No injuriesClosedPiper PA-30 · Auburn, MEJul 1, 1966 · N7673Y · Substantial damage NTSB NYC66A0143Accident · 2 fatalClosedCessna 180 · Onawa, MEJun 6, 1966 · N2165Z · Destroyed NTSB NYC67D0121Accident · No injuriesClosedPiper PA-18 · Greenville, MEMay 4, 1966 · CF-KLL · Substantial damage NTSB NYC66A0122Accident · 2 fatalClosedTaylorcraft DCO-65 · Bethel Maine, MEApr 23, 1966 · N46253 · Destroyed NTSB NYC66F0628Accident · No injuriesClosedBeechcraft A23 · Augusta, MEApr 17, 1966 · N3512R · Substantial damage NTSB NYC66F0578Accident · No injuriesClosedAero Cmdr 680E · Augusta, MEApr 7, 1966 · N6288B · Substantial damage NTSB NYC66F0531Accident · No injuriesClosedErcoupe 415-C · Waterville, MEFeb 22, 1966 · N2306H · Substantial damage NTSB NYC66F0520Accident · No injuriesClosedCessna 120 · Waldo, MEFeb 19, 1966 · N2773N · Substantial damage NTSB NYC66A0088Accident · 1 fatalClosedPiper PA-24 · Monticello, MEFeb 11, 1966 · N8514P · Destroyed NTSB NYC66F0482Accident · No injuriesClosedCessna 310B · Portland, MEJan 28, 1966 · N3310 · Substantial damage NTSB NYC66F0442Accident · No injuriesClosedCessna 172 · Houlton, MEJan 22, 1966 · N5400T · Substantial damage NTSB NYC66F0407Accident · No injuriesClosedPiper PA-28 · Millinocket, MEJan 4, 1966 · N6986W · Substantial damage