Skip to content

NTSB investigations, 1971, 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 NYC72FNE19Accident · Minor injuriesClosedCessna 172F · Kent, CTDec 22, 1971 · N7857U · Substantial damage NTSB NYC72FNE20Accident · No injuriesClosedCessna 182L · Simsbury, CTDec 15, 1971 · N3366R · Destroyed NTSB NYC72FNE17Accident · No injuriesClosedCommonwlth 185 · Middlebury, CTDec 12, 1971 · N92914 · Substantial damage NTSB NYC72AN081Accident · 3 fatalClosedCessna 170 · Woodstock, CTDec 12, 1971 · N4016V · Substantial damage NTSB NYC72FNE16Accident · No injuriesClosedCessna 172D · Deep River, CTNov 14, 1971 · N8537X · Substantial damage NTSB NYC72FNE15Accident · No injuriesClosedAeronca 7DC · Oxford, CTNov 7, 1971 · N4493E · Substantial damage NTSB NYC72FNE13Accident · Minor injuriesClosedPiper J3C-65 · Durham, CTSep 29, 1971 · N88179 · Substantial damage NTSB NYC72FNE12Accident · Minor injuriesClosedBeech A-45 · Monroe, CTSep 19, 1971 · N450L · Substantial damage NTSB NYC72AN040Accident · No injuriesClosedBell 206A · Westport, CTSep 15, 1971 · N1409W · Substantial damage NTSB NYC72FNE09Accident · Minor injuriesClosedCessna 140A · Woodstock, CTSep 7, 1971 · N9622A · Substantial damage NTSB NYC72FNE10Accident · Minor injuriesClosedPiper PA-28 · Plainville, CTSep 4, 1971 · N1769T · Substantial damage NTSB NYC72FNE08Accident · Serious injuriesClosedPiper PA-28 · Danbury, CTAug 29, 1971 · N95409 · Destroyed NTSB NYC72AN029Accident · No injuriesClosedCessna 337D · Chester, CTAug 24, 1971 · N337LF · Substantial damage NTSB NYC72FNE06Accident · Minor injuriesClosedChampion 7EC · Sherman, CTAug 10, 1971 · N7520E · Substantial damage NTSB NYC72FNE04Accident · No injuriesClosedCessna 140 · Meriden, CTAug 8, 1971 · N2913N · Substantial damage NTSB NYC72FNE05Accident · No injuriesClosedBeech A23A · Oxford, CTAug 6, 1971 · N2326W · Substantial damage NTSB NYC72FNE03Accident · No injuriesClosedRotorway Scorpn · Westbrook, CTAug 1, 1971 · N8851 · Substantial damage NTSB NYC72AN011Accident · 2 fatalClosedPiper PA-30 · Madison, CTJul 26, 1971 · N643TT · Destroyed NTSB NYC72AN006Accident · Minor injuriesClosedDouglas DC-3 · Windsor Lks, CTJul 16, 1971 · N74844 · Substantial damage NTSB NYC72FNE02Accident · No injuriesClosedCommandaire 5C3 · Ellington, CTJul 15, 1971 · N925E · Substantial damage NTSB NYC71FNE42Accident · Minor injuriesClosedChampion 7KCAB · Oxford, CTJun 22, 1971 · N7500F · Substantial damage NTSB NYC71FNE46Accident · No injuriesClosedBrantly B-2A · Broad Brook, CTJun 16, 1971 · N6791D · Substantial damage NTSB NYC71DNE43Accident · Minor injuriesClosedCessna 172D · Danbury, CTJun 16, 1971 · N2733U · Substantial damage NTSB NYC71DNE40Accident · No injuriesClosedCessna 310 · Waterford, CTJun 13, 1971 · N5241A · Substantial damage NTSB NYC71DNE39Accident · No injuriesClosedPiper PA-28 · Plainville, CTJun 11, 1971 · N3981K · Substantial damage NTSB DCA71AZ009Accident · 28 fatalClosedConvair 580 · New Haven, CTJun 7, 1971 · N5832 · Destroyed NTSB NYC71FNE37Accident · 1 fatalClosedB.Jungmistr BU-133 · Plainville, CTJun 6, 1971 · N4767 · Destroyed NTSB NYC71IN115Incident · No injuriesClosedDouglas DC-9 · New Haven, CTJun 1, 1971 · N8924E · Minor damage NTSB NYC71FNE35Accident · No injuriesClosedBeech 95 · Willimantic, CTMay 29, 1971 · N8226D · Substantial damage NTSB NYC71DNE36Accident · Minor injuriesClosedCessna 172K · Willimantic, CTMay 29, 1971 · N7377G · Destroyed NTSB NYC71FNE34Accident · Minor injuriesClosedFlybaby 1A · Oxford, CTMay 20, 1971 · N3314 · Destroyed NTSB NYC71FNE33Accident · No injuriesClosedKitalina AFB · Waterford, CTMay 20, 1971 · N5577 · Substantial damage NTSB NYC71DNE31Accident · No injuriesClosedBeech A23-19 · Windsor Lks, CTApr 27, 1971 · N6949Q · Substantial damage NTSB NYC71DNE38Accident · No injuriesClosedCessna 172K · Hartford, CTApr 9, 1971 · N78638 · Substantial damage NTSB NYC71FNE30Accident · No injuriesClosedCessna 195 · Ansonia, CTApr 1, 1971 · N9330A · Substantial damage NTSB NYC71FFM27Incident · No injuriesClosedCessna 150 · Hartford, CTFeb 14, 1971 · N5801G · Minor damage NTSB NYC71FFM29Accident · No injuriesClosedCessna 150K · Oxford, CTFeb 6, 1971 · N6272G · Substantial damage NTSB NYC71DFM26Accident · No injuriesClosedBeech A23-19 · Simsbury, CTJan 24, 1971 · N3623Q · Substantial damage NTSB NYC71AN083Accident · Minor injuriesClosedHughes 269-B · New Haven, CTJan 23, 1971 · N9370F · Destroyed NTSB NYC71IN076Incident · No injuriesClosedCessna 150 · Danbury, CTJan 2, 1971 · N22785 · 2 aircraft · Minor damage