Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 NYC69D0293Accident · No injuriesClosedCessna 140 · Danbury, CTDec 31, 1968 · N2208V · Substantial damage NTSB NYC69F0301Accident · No injuriesClosedAeronca 11AC · Burlington, CTDec 27, 1968 · N9702E · Substantial damage NTSB NYC69F0295Accident · No injuriesClosedBeech 35-B33 · Meriden, CTDec 25, 1968 · N1783G · Substantial damage NTSB NYC69D0275Accident · Minor injuriesClosedPiper PA-28 · Chester, CTNov 28, 1968 · N8891W · Substantial damage NTSB NYC69D0263Accident · No injuriesClosedCessna 150E · Hartford, CTNov 21, 1968 · N4018U · Substantial damage NTSB NYC69F0252Accident · Serious injuriesClosedPiper PA-28 · Glastonbury, CTOct 30, 1968 · N3728K · Substantial damage NTSB NYC69D0213Accident · No injuriesClosedPiper PA-28 · E Hampton, CTSep 29, 1968 · N7280J · Substantial damage NTSB NYC69A0039Accident · 2 fatalClosedPiper J3C-65 · North Canaan, CTSep 22, 1968 · N70708 · Destroyed NTSB NYC69F0165Accident · Serious injuriesClosedBeech 23 · Danbury, CTSep 2, 1968 · N8727M · Destroyed NTSB NYC69D0160Accident · Minor injuriesClosedPiper J3C-65 · Woodstock, CTSep 1, 1968 · N42392 · Substantial damage NTSB NYC69D0096Accident · No injuriesClosedAlon A-2 · Ellington, CTAug 2, 1968 · N5608F · Substantial damage NTSB NYC69A0014Accident · No injuriesClosedPiper PA-28 · East Hampton, CTAug 1, 1968 · N9311J · Substantial damage NTSB NYC69A0012Accident · 1 fatalClosedCessna 150 · East Hampton, CTJul 31, 1968 · N8121S · Destroyed NTSB NYC69D0095Accident · No injuriesClosedPiper PA-28 · Ansonia, CTJul 24, 1968 · N5257W · Substantial damage NTSB NYC69D0121Accident · No injuriesClosedBeech B95A · Stratford, CTJul 22, 1968 · N1383Z · Substantial damage NTSB NYC69F0078Accident · No injuriesClosedPiper PA-28 · Danbury, CTJul 7, 1968 · N4397J · 2 aircraft · Substantial damage NTSB NYC68A0137Accident · 2 fatalClosedCessna 411 · Groton, CTJun 17, 1968 · N4955T · Destroyed NTSB NYC69F0033Accident · Serious injuriesClosedPiper PA-28 · Branford, CTJun 9, 1968 · N4455J · Destroyed NTSB NYC68F0502Accident · No injuriesClosedCessna 150 · Torrington, CTJun 7, 1968 · N3992U · Substantial damage NTSB NYC68F0506Accident · Serious injuriesClosedCessna 150 · Mansfield, CTJun 5, 1968 · N8112S · Substantial damage NTSB NYC69F0011Accident · Minor injuriesClosedBeech C-45H · Hartford, CTJun 3, 1968 · N4000Y · Destroyed NTSB NYC68A0127Accident · 1 fatalClosedCessna 140 · Woodstock, CTJun 3, 1968 · N76263 · Destroyed NTSB NYC68A0122Accident · 4 fatalClosedNavion A · Greenwich, CTMay 26, 1968 · N4918K · Destroyed NTSB NYC68D0479Accident · No injuriesClosedCessna 172 · East Windsor, CTApr 28, 1968 · N6882A · Substantial damage NTSB NYC68F0446Accident · No injuriesClosedPiper PA-23 · Windsor Lks, CTApr 14, 1968 · N4329Y · Substantial damage NTSB NYC68D0432Accident · No injuriesClosedPiper PA-28 · Waterford, CTApr 8, 1968 · N9245J · Substantial damage NTSB NYC68D0426Accident · No injuriesClosedCessna 150 · Thompson, CTApr 2, 1968 · N8345J · Substantial damage NTSB NYC68D0422Accident · No injuriesClosedBeech A-23 · Stratford, CTMar 30, 1968 · N1426L · Substantial damage NTSB NYC68A0112Accident · 1 fatalClosedBeech 95-B55 · Windsor Lock, CTMar 25, 1968 · N3030Q · Destroyed NTSB NYC68F0403Accident · No injuriesClosedCessna 177 · Windsor Lock, CTMar 6, 1968 · N2980X · Substantial damage NTSB NYC68D0387Accident · No injuriesClosedPiper PA-24 · Stratford, CTFeb 23, 1968 · N870W · Substantial damage NTSB NYC68D0407Accident · No injuriesClosedCessna 182 · Plainville, CTFeb 15, 1968 · N2751Q · Substantial damage NTSB NYC68D0358Accident · No injuriesClosedCessna 210 · Hartford, CTJan 21, 1968 · N1854Z · Substantial damage NTSB NYC68D0327Accident · No injuriesClosedCessna 150 · Plainville, CTJan 6, 1968 · N3790J · Substantial damage