Skip to content

NTSB investigations, 1965, 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, 1965, 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") = 1965 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\") = 1965
    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") = 1965
  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 NYC66D0399Accident · No injuriesClosedPiper PA-28 · Hartford, CTDec 23, 1965 · N7649W · Substantial damage NTSB NYC66D0396Accident · No injuriesClosedPiper PA-22 · Danbury, CTDec 20, 1965 · N4967Z · Substantial damage NTSB NYC66F0375Accident · No injuriesClosedCessna T-50 · Jewett City, CTNov 25, 1965 · N58309 · Substantial damage NTSB NYC66F0368Accident · No injuriesClosedPiper PA-28 · Deep River, CTNov 21, 1965 · N5642W · Substantial damage NTSB NYC66F0370Accident · Serious injuriesClosedPiper PA-22 · Greenwich, CTNov 6, 1965 · N5752Z · Destroyed NTSB NYC66F0284Accident · No injuriesClosedCessna 150 · Danbury, CTOct 26, 1965 · N6293T · Substantial damage NTSB NYC66D0292Accident · No injuriesClosedCessna 150 · Hartford, CTOct 24, 1965 · N3545J · Substantial damage NTSB NYC66D0301Accident · No injuriesClosedMooney M20C · Danbury, CTOct 12, 1965 · N5834Q · Substantial damage NTSB NYC66D0294Accident · No injuriesClosedPiper PA-28 · Hartford, CTOct 10, 1965 · N6937W · Substantial damage NTSB NYC66A0047Accident · 4 fatalClosedStinson SR-7 · New Haven, CTOct 10, 1965 · N16113 · Destroyed NTSB NYC66F0244Accident · No injuriesClosedCessna 172 · Harwinton, CTOct 3, 1965 · N7459T · Substantial damage NTSB NYC66A0010Accident · 3 fatalClosedPiper PA-22 · E.Hartford, CTSep 26, 1965 · N8120C · Destroyed NTSB NYC66F0234Accident · No injuriesClosedBeechcraft C-45H · Groton, CTSep 13, 1965 · N135L · Substantial damage NTSB NYC66D0231Accident · No injuriesClosedCessna 172 · Litchfield, CTSep 9, 1965 · N8790B · Substantial damage NTSB NYC66F0201Accident · Minor injuriesClosedBeechcraft 35 · Monroe, CTAug 25, 1965 · N3249V · Substantial damage NTSB NYC66D0177Accident · No injuriesClosedBellanca 14-19 · So Canaan, CTAug 18, 1965 · N9809B · Substantial damage NTSB NYC66F0069Accident · No injuriesClosedCessna 172F · E Killingly, CTJul 13, 1965 · N5551R · Substantial damage NTSB NYC66F0108Accident · Serious injuriesClosedAero Cmdr 560 · Danbury, CTJul 12, 1965 · N2654B · Substantial damage NTSB NYC66F0082Accident · No injuriesClosedBeechcraft 35 · Hardwinton, CTJul 9, 1965 · N3329V · Substantial damage NTSB NYC66F0056Accident · Minor injuriesClosedMiniplane DSA-1 · New Haven, CTJul 3, 1965 · N9155R · Substantial damage NTSB NYC66F0032Accident · Serious injuriesClosedPiper J3 · East Windsor, CTJul 2, 1965 · N92699 · Substantial damage NTSB NYC66D0073Accident · No injuriesClosedCessna 170B · Hartford, CTJun 30, 1965 · N113E · Substantial damage NTSB NYC66F0092Accident · Serious injuriesClosedPiper PA23 · New Haven, CTJun 29, 1965 · N5253Y · Destroyed NTSB NYC65A0152Accident · 1 fatalClosedCessna 170 · E.Haddam, CTJun 20, 1965 · N3506D · Substantial damage NTSB NYC66F0024Accident · No injuriesClosedCessna 182A · Stratford, CTJun 3, 1965 · N2014G · Substantial damage NTSB NYC65F0212Accident · Serious injuriesClosedAeronca 7AC · Plymouth, CTMay 22, 1965 · N2615E · Substantial damage NTSB NYC65F0193Accident · No injuriesClosedErcoupe 415C · East Haven, CTMay 6, 1965 · N93991 · Substantial damage NTSB NYC65F0185Accident · No injuriesClosedPiper PA-23 · New Haven, CTApr 24, 1965 · N5604Y · Substantial damage NTSB NYC65F0103Accident · No injuriesClosedCessna 150 · Plainville, CTApr 6, 1965 · N6401T · Substantial damage NTSB NYC65F0114Accident · No injuriesClosedPiper PA-28 · New Haven, CTApr 3, 1965 · N6405W · Substantial damage NTSB NYC65F0056Accident · No injuriesClosedBeechraft 35-33 · Bethany, CTMar 7, 1965 · N928T · Substantial damage NTSB NYC65F0049Accident · No injuriesClosedPiper PA-22 · Willimantic, CTFeb 28, 1965 · N5538Z · Substantial damage NTSB NYC65F0027Accident · No injuriesClosedPiper PA22 · Danbury, CTFeb 15, 1965 · N5162Z · Substantial damage NTSB NYC65F0013Accident · No injuriesClosedPiper PA22 · Ansonia, CTFeb 14, 1965 · N1455A · Substantial damage NTSB NYC65F0020Accident · No injuriesClosedCessna 170B · Ansonia, CTFeb 13, 1965 · N8161A · Substantial damage NTSB UNK65X1404Accident · No injuriesClosedPiper PA22 · Woodstock, CTFeb 7, 1965 · N5989D · Substantial damage NTSB NYC65F0007Accident · No injuriesClosedCessna 180 · Roxbury, CTFeb 4, 1965 · N2961A · Substantial damage NTSB NYC65F0067Accident · No injuriesClosedCessna 172 · Bolton, CTFeb 1, 1965 · N7771U · Substantial damage NTSB NYC65F0021Accident · No injuriesClosedCessna 150 · Williamantic, CTJan 29, 1965 · N7348X · Substantial damage NTSB UNK65X1365Accident · No injuriesClosedPiper PA28 · Plainville, CTJan 28, 1965 · N6068W · Substantial damage NTSB UNK65X1350Accident · No injuriesClosedPiper PA23 · Windsor Locks, CTJan 26, 1965 · N4941P · Substantial damage NTSB UNK65X1332Accident · No injuriesClosedCommonwlth 185 · Meriden, CTJan 22, 1965 · N93250 · Substantial damage NTSB NYC65A0097Accident · Minor injuriesClosedSikorsky S61N · Stratford, CTJan 21, 1965 · N92866 · Substantial damage NTSB NYC65A0095Accident · Serious injuriesClosedConvair CV-440 · Windsor Lock, CTJan 18, 1965 · N4406 · No damage NTSB UNK65X1211Accident · No injuriesClosedCessna 150B · Thomaston, CTJan 1, 1965 · N7325X · Substantial damage