# NTSB investigations, CT NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 19 of 22 · 1,081 cases ## Cases, newest first - [NTSB NYC68F0403](https://openairdocs.org/ntsb/NYC68F0403.md): Cessna 177 · Windsor Lock, CT · Accident · No injuries · Closed · Mar 6, 1968 · N2980X · Substantial damage - [NTSB NYC68D0387](https://openairdocs.org/ntsb/NYC68D0387.md): Piper PA-24 · Stratford, CT · Accident · No injuries · Closed · Feb 23, 1968 · N870W · Substantial damage - [NTSB NYC68D0407](https://openairdocs.org/ntsb/NYC68D0407.md): Cessna 182 · Plainville, CT · Accident · No injuries · Closed · Feb 15, 1968 · N2751Q · Substantial damage - [NTSB NYC68D0358](https://openairdocs.org/ntsb/NYC68D0358.md): Cessna 210 · Hartford, CT · Accident · No injuries · Closed · Jan 21, 1968 · N1854Z · Substantial damage - [NTSB NYC68D0327](https://openairdocs.org/ntsb/NYC68D0327.md): Cessna 150 · Plainville, CT · Accident · No injuries · Closed · Jan 6, 1968 · N3790J · Substantial damage - [NTSB NYC68F0322](https://openairdocs.org/ntsb/NYC68F0322.md): Cessna 150G · Hartford, CT · Accident · No injuries · Closed · Dec 20, 1967 · N3237J · Substantial damage - [NTSB NYC68D0310](https://openairdocs.org/ntsb/NYC68D0310.md): Cessna 172 · Groton, CT · Accident · No injuries · Closed · Dec 17, 1967 · N5329T · Substantial damage - [NTSB NYC68A0079](https://openairdocs.org/ntsb/NYC68A0079.md): Piper PA-28 · Bridgeport, CT · Accident · 4 fatal · Closed · Dec 16, 1967 · N9736J · Destroyed - [NTSB NYC68F0282](https://openairdocs.org/ntsb/NYC68F0282.md): Cessna 150F · Plainville, CT · Accident · No injuries · Closed · Nov 5, 1967 · N8218F · Substantial damage - [NTSB NYC68F0280](https://openairdocs.org/ntsb/NYC68F0280.md): Cessna 150F · Plainville, CT · Accident · Serious injuries · Closed · Nov 5, 1967 · N6694F · Substantial damage - [NTSB NYC68D0258](https://openairdocs.org/ntsb/NYC68D0258.md): Beech A23 · Burlington, CT · Accident · No injuries · Closed · Oct 25, 1967 · N1421L · Substantial damage - [NTSB NYC68D0246](https://openairdocs.org/ntsb/NYC68D0246.md): Cessna 182 · Windsor Lock, CT · Accident · No injuries · Closed · Oct 23, 1967 · N2704Q · Substantial damage - [NTSB NYC68D0235](https://openairdocs.org/ntsb/NYC68D0235.md): Aeronca 7CCM · Hartford, CT · Accident · Serious injuries · Closed · Oct 13, 1967 · N1318V · Substantial damage - [NTSB NYC68D0245](https://openairdocs.org/ntsb/NYC68D0245.md): Mooney M20B · Fairfield, CT · Accident · No injuries · Closed · Sep 30, 1967 · N74514 · Substantial damage - [NTSB NYC68A0050](https://openairdocs.org/ntsb/NYC68A0050.md): Piper PA-23 · New London, CT · Accident · No injuries · Closed · Sep 24, 1967 · N4900P · Substantial damage - [NTSB NYC68D0149](https://openairdocs.org/ntsb/NYC68D0149.md): Cessna 172E · Ea.Hampton, CT · Accident · Serious injuries · Closed · Sep 2, 1967 · N5308T · Substantial damage - [NTSB NYC68A0034](https://openairdocs.org/ntsb/NYC68A0034.md): Sikorsky S-51 · Wndsor Locks, CT · Accident · No injuries · Closed · Aug 29, 1967 · N13301 · Substantial damage - [NTSB NYC68F0159](https://openairdocs.org/ntsb/NYC68F0159.md): Cessna 150E · Terryville, CT · Accident · No injuries · Closed · Aug 20, 1967 · N4018U · Substantial damage - [NTSB NYC68F0147](https://openairdocs.org/ntsb/NYC68F0147.md): Piper PA-23 · Hartford, CT · Accident · No injuries · Closed · Aug 17, 1967 · N4416P · Substantial damage - [NTSB NYC68D0163](https://openairdocs.org/ntsb/NYC68D0163.md): Piper PA-28 · East Haddam, CT · Accident · No injuries · Closed · Aug 5, 1967 · N6079W · Substantial damage - [NTSB NYC68D0084](https://openairdocs.org/ntsb/NYC68D0084.md): Piper PA-12 · Monroe, CT · Accident · No injuries · Closed · Aug 5, 1967 · N3177M · Substantial damage - [NTSB NYC68D0105](https://openairdocs.org/ntsb/NYC68D0105.md): Cessna 182 · Canaan, CT · Accident · No injuries · Closed · Aug 4, 1967 · N3094Q · Substantial damage - [NTSB NYC68A0023](https://openairdocs.org/ntsb/NYC68A0023.md): Cessna 182K · Trumbull, CT · Accident · 4 fatal · Closed · Aug 4, 1967 · N3025Q · Destroyed - [NTSB NYC68D0062](https://openairdocs.org/ntsb/NYC68D0062.md): Corbin Ace D · Newton, CT · Accident · No injuries · Closed · Jul 27, 1967 · N8751R · Substantial damage - [NTSB NYC68A0017](https://openairdocs.org/ntsb/NYC68A0017.md): Piper PA-28 · Bridgeport, CT · Accident · 2 fatal · Closed · Jul 27, 1967 · N7865W · Destroyed - [NTSB NYC68A0003](https://openairdocs.org/ntsb/NYC68A0003.md): Stinson 108-3 · Woodstock, CT · Accident · 2 fatal · Closed · Jul 6, 1967 · N595C · Destroyed - [NTSB NYC68D0045](https://openairdocs.org/ntsb/NYC68D0045.md): Cessna 150D · East Hampton, CT · Accident · Minor injuries · Closed · Jul 4, 1967 · N5929T · Substantial damage - [NTSB NYC68D0054](https://openairdocs.org/ntsb/NYC68D0054.md): Cessna 150 · Ellington, CT · Accident · No injuries · Closed · Jul 2, 1967 · N2211J · Substantial damage - [NTSB NYC68D0056](https://openairdocs.org/ntsb/NYC68D0056.md): Stearman PT-17 · Meriden, CT · Accident · No injuries · Closed · Jul 1, 1967 · N1350M · Substantial damage - [NTSB NYC68D0012](https://openairdocs.org/ntsb/NYC68D0012.md): Cessna 182 · Chester, CT · Accident · No injuries · Closed · Jun 9, 1967 · N8967X · Substantial damage - [NTSB NYC67D0703](https://openairdocs.org/ntsb/NYC67D0703.md): Beech 35-B33 · Windsor Lks, CT · Accident · No injuries · Closed · Jun 5, 1967 · N1589S · Substantial damage - [NTSB NYC67A0170](https://openairdocs.org/ntsb/NYC67A0170.md): Piper PA-18S · Westbrook, CT · Accident · 1 fatal · Closed · May 28, 1967 · N3901Z · Destroyed - [NTSB NYC67D0676](https://openairdocs.org/ntsb/NYC67D0676.md): Piper PA-12 · Burlington, CT · Accident · No injuries · Closed · May 21, 1967 · N3840M · Substantial damage - [NTSB NYC67D0663](https://openairdocs.org/ntsb/NYC67D0663.md): Piper PA-28 · Plainville, CT · Accident · No injuries · Closed · May 13, 1967 · N9068J · Substantial damage - [NTSB NYC67D0681](https://openairdocs.org/ntsb/NYC67D0681.md): Cessna 150 · Plainville, CT · Accident · No injuries · Closed · May 11, 1967 · N3790J · Substantial damage - [NTSB NYC67F0654](https://openairdocs.org/ntsb/NYC67F0654.md): Cessna 310D · New Haven, CT · Accident · No injuries · Closed · Apr 29, 1967 · N6980T · Substantial damage - [NTSB NYC67D0643](https://openairdocs.org/ntsb/NYC67D0643.md): Piper PA-30 · Woodstock, CT · Accident · No injuries · Closed · Apr 21, 1967 · N7455Y · Substantial damage - [NTSB NYC67F0589](https://openairdocs.org/ntsb/NYC67F0589.md): Cessna 172 · Plainville, CT · Accident · No injuries · Closed · Apr 9, 1967 · N5519R · 2 aircraft · Substantial damage - [NTSB NYC67A0149](https://openairdocs.org/ntsb/NYC67A0149.md): Brantly B-2B · Burlington, CT · Accident · No injuries · Closed · Apr 8, 1967 · N2191U · Substantial damage - [NTSB NYC67D0602](https://openairdocs.org/ntsb/NYC67D0602.md): Cessna 172 · New Haven, CT · Accident · No injuries · Closed · Apr 3, 1967 · N1592Y · Substantial damage - [NTSB NYC67F0593](https://openairdocs.org/ntsb/NYC67F0593.md): Cessna 182F · Madison, CT · Accident · No injuries · Closed · Apr 2, 1967 · N3335U · Substantial damage - [NTSB NYC67F0586](https://openairdocs.org/ntsb/NYC67F0586.md): Cessna 337B · Windsor Loks, CT · Accident · No injuries · Closed · Mar 30, 1967 · N5428S · Substantial damage - [NTSB NYC67D0575](https://openairdocs.org/ntsb/NYC67D0575.md): Cessna 150 · Williamantic, CT · Accident · No injuries · Closed · Mar 28, 1967 · N8896G · Substantial damage - [NTSB NYC67F0568](https://openairdocs.org/ntsb/NYC67F0568.md): Cessna 150 · Simsbury, CT · Accident · No injuries · Closed · Mar 20, 1967 · N8317J · Substantial damage - [NTSB NYC67D0559](https://openairdocs.org/ntsb/NYC67D0559.md): Mooney M20E · Plainville, CT · Accident · No injuries · Closed · Mar 20, 1967 · N9307M · Substantial damage - [NTSB NYC67F0566](https://openairdocs.org/ntsb/NYC67F0566.md): Cessna 150G · Newtown, CT · Accident · No injuries · Closed · Mar 19, 1967 · N3371J · Substantial damage - [NTSB NYC67D0546](https://openairdocs.org/ntsb/NYC67D0546.md): Piper PA-28 · Hartford, CT · Accident · No injuries · Closed · Mar 16, 1967 · N9124W · Substantial damage - [NTSB NYC67D0526](https://openairdocs.org/ntsb/NYC67D0526.md): Piper PA-24 · Madison, CT · Accident · No injuries · Closed · Feb 22, 1967 · N6164P · Substantial damage - [NTSB NYC67F0527](https://openairdocs.org/ntsb/NYC67F0527.md): Piper PA-28 · Cheshire, CT · Accident · Serious injuries · Closed · Feb 21, 1967 · N6370R · Destroyed - [NTSB NYC67D0506](https://openairdocs.org/ntsb/NYC67D0506.md): Beech 23 · Danbury, CT · Accident · No injuries · Closed · Feb 5, 1967 · N5996S · Substantial damage Next page: https://openairdocs.org/ntsb.md?state=CT&page=20 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```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 c."eventStateOrRegion" = 'CT' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?page=19&state=CT --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.