Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 NYC68F0322Accident · No injuriesClosedCessna 150G · Hartford, CTDec 20, 1967 · N3237J · Substantial damage NTSB NYC68D0310Accident · No injuriesClosedCessna 172 · Groton, CTDec 17, 1967 · N5329T · Substantial damage NTSB NYC68A0079Accident · 4 fatalClosedPiper PA-28 · Bridgeport, CTDec 16, 1967 · N9736J · Destroyed NTSB NYC68F0282Accident · No injuriesClosedCessna 150F · Plainville, CTNov 5, 1967 · N8218F · Substantial damage NTSB NYC68F0280Accident · Serious injuriesClosedCessna 150F · Plainville, CTNov 5, 1967 · N6694F · Substantial damage NTSB NYC68D0258Accident · No injuriesClosedBeech A23 · Burlington, CTOct 25, 1967 · N1421L · Substantial damage NTSB NYC68D0246Accident · No injuriesClosedCessna 182 · Windsor Lock, CTOct 23, 1967 · N2704Q · Substantial damage NTSB NYC68D0235Accident · Serious injuriesClosedAeronca 7CCM · Hartford, CTOct 13, 1967 · N1318V · Substantial damage NTSB NYC68D0245Accident · No injuriesClosedMooney M20B · Fairfield, CTSep 30, 1967 · N74514 · Substantial damage NTSB NYC68A0050Accident · No injuriesClosedPiper PA-23 · New London, CTSep 24, 1967 · N4900P · Substantial damage NTSB NYC68D0149Accident · Serious injuriesClosedCessna 172E · Ea.Hampton, CTSep 2, 1967 · N5308T · Substantial damage NTSB NYC68A0034Accident · No injuriesClosedSikorsky S-51 · Wndsor Locks, CTAug 29, 1967 · N13301 · Substantial damage NTSB NYC68F0159Accident · No injuriesClosedCessna 150E · Terryville, CTAug 20, 1967 · N4018U · Substantial damage NTSB NYC68F0147Accident · No injuriesClosedPiper PA-23 · Hartford, CTAug 17, 1967 · N4416P · Substantial damage NTSB NYC68D0163Accident · No injuriesClosedPiper PA-28 · East Haddam, CTAug 5, 1967 · N6079W · Substantial damage NTSB NYC68D0084Accident · No injuriesClosedPiper PA-12 · Monroe, CTAug 5, 1967 · N3177M · Substantial damage NTSB NYC68D0105Accident · No injuriesClosedCessna 182 · Canaan, CTAug 4, 1967 · N3094Q · Substantial damage NTSB NYC68A0023Accident · 4 fatalClosedCessna 182K · Trumbull, CTAug 4, 1967 · N3025Q · Destroyed NTSB NYC68D0062Accident · No injuriesClosedCorbin Ace D · Newton, CTJul 27, 1967 · N8751R · Substantial damage NTSB NYC68A0017Accident · 2 fatalClosedPiper PA-28 · Bridgeport, CTJul 27, 1967 · N7865W · Destroyed NTSB NYC68A0003Accident · 2 fatalClosedStinson 108-3 · Woodstock, CTJul 6, 1967 · N595C · Destroyed NTSB NYC68D0045Accident · Minor injuriesClosedCessna 150D · East Hampton, CTJul 4, 1967 · N5929T · Substantial damage NTSB NYC68D0054Accident · No injuriesClosedCessna 150 · Ellington, CTJul 2, 1967 · N2211J · Substantial damage NTSB NYC68D0056Accident · No injuriesClosedStearman PT-17 · Meriden, CTJul 1, 1967 · N1350M · Substantial damage NTSB NYC68D0012Accident · No injuriesClosedCessna 182 · Chester, CTJun 9, 1967 · N8967X · Substantial damage NTSB NYC67D0703Accident · No injuriesClosedBeech 35-B33 · Windsor Lks, CTJun 5, 1967 · N1589S · Substantial damage NTSB NYC67A0170Accident · 1 fatalClosedPiper PA-18S · Westbrook, CTMay 28, 1967 · N3901Z · Destroyed NTSB NYC67D0676Accident · No injuriesClosedPiper PA-12 · Burlington, CTMay 21, 1967 · N3840M · Substantial damage NTSB NYC67D0663Accident · No injuriesClosedPiper PA-28 · Plainville, CTMay 13, 1967 · N9068J · Substantial damage NTSB NYC67D0681Accident · No injuriesClosedCessna 150 · Plainville, CTMay 11, 1967 · N3790J · Substantial damage NTSB NYC67F0654Accident · No injuriesClosedCessna 310D · New Haven, CTApr 29, 1967 · N6980T · Substantial damage NTSB NYC67D0643Accident · No injuriesClosedPiper PA-30 · Woodstock, CTApr 21, 1967 · N7455Y · Substantial damage NTSB NYC67F0589Accident · No injuriesClosedCessna 172 · Plainville, CTApr 9, 1967 · N5519R · 2 aircraft · Substantial damage NTSB NYC67A0149Accident · No injuriesClosedBrantly B-2B · Burlington, CTApr 8, 1967 · N2191U · Substantial damage NTSB NYC67D0602Accident · No injuriesClosedCessna 172 · New Haven, CTApr 3, 1967 · N1592Y · Substantial damage NTSB NYC67F0593Accident · No injuriesClosedCessna 182F · Madison, CTApr 2, 1967 · N3335U · Substantial damage NTSB NYC67F0586Accident · No injuriesClosedCessna 337B · Windsor Loks, CTMar 30, 1967 · N5428S · Substantial damage NTSB NYC67D0575Accident · No injuriesClosedCessna 150 · Williamantic, CTMar 28, 1967 · N8896G · Substantial damage NTSB NYC67F0568Accident · No injuriesClosedCessna 150 · Simsbury, CTMar 20, 1967 · N8317J · Substantial damage NTSB NYC67D0559Accident · No injuriesClosedMooney M20E · Plainville, CTMar 20, 1967 · N9307M · Substantial damage NTSB NYC67F0566Accident · No injuriesClosedCessna 150G · Newtown, CTMar 19, 1967 · N3371J · Substantial damage NTSB NYC67D0546Accident · No injuriesClosedPiper PA-28 · Hartford, CTMar 16, 1967 · N9124W · Substantial damage NTSB NYC67D0526Accident · No injuriesClosedPiper PA-24 · Madison, CTFeb 22, 1967 · N6164P · Substantial damage NTSB NYC67F0527Accident · Serious injuriesClosedPiper PA-28 · Cheshire, CTFeb 21, 1967 · N6370R · Destroyed NTSB NYC67D0506Accident · No injuriesClosedBeech 23 · Danbury, CTFeb 5, 1967 · N5996S · Substantial damage NTSB NYC67D0482Accident · No injuriesClosedPiper PA-28 · Hartford, CTJan 31, 1967 · N6937W · Substantial damage NTSB NYC67D0472Accident · Minor injuriesClosedCessna 172 · Trumbull, CTJan 22, 1967 · N8280U · Substantial damage NTSB NYC67F0458Accident · No injuriesClosedBeech 95-B55 · Hartford, CTJan 9, 1967 · N8990A · Substantial damage