Skip to content

NTSB investigations, 1966, CT

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, CT per year, 1962–2026: 1,081 cases
1962	1
1964	32
1965	45
1966	50
1967	48
1968	34
1969	31
1970	34
1971	40
1972	31
1973	34
1974	24
1975	22
1976	18
1977	27
1978	26
1979	26
1980	21
1981	14
1982	22
1983	21
1984	33
1985	17
1986	23
1987	24
1988	17
1989	18
1990	17
1991	15
1992	21
1993	15
1994	13
1995	10
1996	14
1997	8
1998	16
1999	10
2000	9
2001	15
2002	12
2003	8
2004	13
2005	9
2006	7
2007	7
2008	9
2009	2
2010	4
2011	11
2012	6
2013	7
2014	5
2015	9
2016	8
2017	13
2018	8
2019	8
2020	5
2021	5
2022	5
2023	6
2024	6
2025	9
2026	3

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" = 'CT' 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\" = 'CT' 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" = 'CT' 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 NYC67I0096Incident · No injuriesClosedFairchild F-27 · Bridgeport, CTDec 29, 1966 · N2705J · No damage NTSB NYC67F0444Accident · No injuriesClosedCessna 150 · Broadbrook, CTDec 23, 1966 · N5558E · Substantial damage NTSB NYC67F0441Accident · No injuriesClosedPiper PA-23 · Waterford, CTDec 15, 1966 · N4249P · Substantial damage NTSB NYC67A0092Accident · 2 fatalClosedPiper PA-18 · North Canaan, CTDec 11, 1966 · N3697Z · 2 aircraft · Destroyed NTSB NYC67F0392Accident · Minor injuriesClosedPiper PA-22 · Voluntown, CTNov 26, 1966 · N3603A · Substantial damage NTSB NYC67D0454Accident · No injuriesClosedN.American T-28A · Windsor Lock, CTNov 22, 1966 · N101TZ · Substantial damage NTSB NYC67D0376Accident · No injuriesClosedCessna 150 · Burlington, CTNov 13, 1966 · N3992U · Substantial damage NTSB NYC67A0078Accident · 1 fatalClosedCessna 172G · Greenwich, CTNov 10, 1966 · N4194L · Destroyed NTSB NYC67D0360Accident · No injuriesClosedPiper PA-18 · Artford, CTNov 5, 1966 · N7585D · Substantial damage NTSB NYC67F0347Accident · Minor injuriesClosedPiper PA-20 · Dayville, CTOct 29, 1966 · N7337K · Substantial damage NTSB NYC67A0065Accident · 2 fatalClosedMooney M20C · Orange, CTOct 23, 1966 · N6277U · Destroyed NTSB NYC67D0313Accident · No injuriesClosedPiper PA-28 · Hartford, CTOct 6, 1966 · N7649W · Substantial damage NTSB NYC67D0307Accident · No injuriesClosedMooney M20C · Danbury, CTSep 30, 1966 · N2712W · Substantial damage NTSB NYC67A0054Accident · 1 fatalClosedPiper PA-32 · Hartford, CTSep 26, 1966 · N3625W · Substantial damage NTSB NYC67D0272Accident · No injuriesClosedPiper PA-28 · Plainville, CTSep 25, 1966 · N5674W · Substantial damage NTSB NYC67F0258Accident · No injuriesClosedCessna 172 · Plainville, CTSep 19, 1966 · N5190A · Substantial damage NTSB NYC67D0260Accident · No injuriesClosedLuscombe 8A · Enfield, CTSep 18, 1966 · N71411 · Substantial damage NTSB NYC67D0253Accident · No injuriesClosedCessna 172 · Stratford, CTSep 10, 1966 · N8445U · Substantial damage NTSB NYC67D0170Accident · No injuriesClosedCessna 150 · Westford, CTAug 28, 1966 · N7169X · Substantial damage NTSB NYC67D0195Accident · No injuriesClosedAeronca 7AC · Monroe, CTAug 19, 1966 · N83091 · Substantial damage NTSB NYC67A0034Accident · Serious injuriesClosedPiper PA-32 · Glenville, CTAug 19, 1966 · N3711W · Destroyed NTSB NYC67A0035Accident · 1 fatalClosedCessna 172G · Middletown, CTAug 15, 1966 · N6003R · Destroyed NTSB NYC67D0171Accident · No injuriesClosedPiper PA-17 · Burlington, CTAug 6, 1966 · N4664H · Substantial damage NTSB NYC67D0136Accident · Minor injuriesClosedCessna 150 · East Hampton, CTAug 4, 1966 · N5929T · Substantial damage NTSB NYC67D0127Accident · No injuriesClosedFryklund Aero S · Broadbrook, CTJul 30, 1966 · N10132 · Destroyed NTSB NYC67F0145Accident · Minor injuriesClosedBeech A23 · Rocky Hill, CTJul 27, 1966 · N8870M · Substantial damage NTSB NYC67D0131Accident · No injuriesClosedCessna 150 · Meriden, CTJul 27, 1966 · N4569U · Substantial damage NTSB NYC67D0105Accident · No injuriesClosedCessna 172 · Madison, CTJul 17, 1966 · N3597S · Substantial damage NTSB NYC67D0106Accident · No injuriesClosedBeech 23 · East Haddam, CTJul 15, 1966 · N1404L · Substantial damage NTSB NYC67D0052Accident · Minor injuriesClosedCessna 172 · Waterbury, CTJul 10, 1966 · N6013R · Substantial damage NTSB NYC67F0048Accident · Minor injuriesClosedCessna 150D · Plainvile, CTJul 3, 1966 · N4209U · Substantial damage NTSB NYC67D0026Accident · No injuriesClosedCessna 175 · Madison, CTJul 3, 1966 · N8395T · Substantial damage NTSB NYC67D0020Accident · No injuriesClosedCessna 172 · Ansonia, CTJun 9, 1966 · N3813L · Substantial damage NTSB NYC66F0686Accident · No injuriesClosedPiper PA28 · Hartford, CTJun 7, 1966 · N6937W · Substantial damage NTSB NYC67F0002Accident · Minor injuriesClosedCessna 172 · Northfield, CTJun 3, 1966 · N8790B · Substantial damage NTSB NYC66D0706Accident · No injuriesClosedBeech 23 · Burlington, CTJun 3, 1966 · N2375W · Substantial damage NTSB NYC66F0676Accident · No injuriesClosedCessna 170A · Meriden, CTMay 15, 1966 · N9181A · Substantial damage NTSB NYC66I0127Incident · No injuriesClosedLockheed L-1049 · Hartford, CTMay 6, 1966 · N6211C · No damage NTSB NYC66A0667Accident · Serious injuriesClosedPiper PA-28 · Willimantic, CTMay 2, 1966 · N4600R · Substantial damage NTSB NYC66D0615CaseClosedPiper PA-28 · Shelton, CTApr 17, 1966 NTSB NYC66D0611Accident · No injuriesClosedPiper PA-22 · Stratford, CTApr 10, 1966 · N6959B · Substantial damage NTSB NYC66D0581Accident · No injuriesClosedPiper PA-12 · So Woodstock, CTApr 8, 1966 · N3583M · Substantial damage NTSB NYC66D0563Accident · No injuriesClosedNavion B · Chester, CTApr 3, 1966 · N10003 · Substantial damage NTSB NYC66D0545Accident · Minor injuriesClosedAeronca 7AC · Woodbridge, CTMar 6, 1966 · N3103E · Substantial damage NTSB NYC66D0542Accident · No injuriesClosedPiper PA-22 · So Woodstock, CTFeb 27, 1966 · N5682Z · Substantial damage NTSB NYC66F0501Accident · No injuriesClosedBeechcraft S35 · Windsor Locks, CTFeb 26, 1966 · N2021W · Substantial damage NTSB NYC66F0525Accident · Serious injuriesClosedNavion B · Meriden, CTFeb 17, 1966 · N808 · Destroyed NTSB NYC66F0493Accident · No injuriesClosedBeechcraft C45H · Windsor Locks, CTFeb 9, 1966 · N168L · Substantial damage NTSB NYC66D0441Accident · No injuriesClosedPiper PA-22 · Hartford, CTJan 22, 1966 · N8546C · Substantial damage NTSB NYC66D0445Accident · No injuriesClosedStinson 108-3 · Hartford, CTJan 11, 1966 · N4213C · Substantial damage