# NTSB investigations, 1975, 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.

## Latest cases

- [NTSB NYC76FNE10](https://openairdocs.org/ntsb/NYC76FNE10.md): Cessna 172F · Stratford, CT · Accident · Minor injuries · Closed · Nov 28, 1975 · N8456U · Substantial damage
- [NTSB NYC76FNE09](https://openairdocs.org/ntsb/NYC76FNE09.md): Cessna 195B · Madison, CT · Accident · Minor injuries · Closed · Oct 2, 1975 · N4321N · Substantial damage
- [NTSB NYC76FNE06](https://openairdocs.org/ntsb/NYC76FNE06.md): Schweizer SGS233 · Plymouth, CT · Accident · No injuries · Closed · Sep 28, 1975 · N33988 · Substantial damage
- [NTSB NYC76AN031](https://openairdocs.org/ntsb/NYC76AN031.md): Raven S55A · Greenwich, CT · Accident · No injuries · Closed · Sep 7, 1975 · N51508 · No damage
- [NTSB NYC76AN023](https://openairdocs.org/ntsb/NYC76AN023.md): Cessna 172M · Stamford, CT · Accident · 1 fatal · Closed · Aug 17, 1975 · N22234 · Destroyed
- [NTSB NYC76AN013](https://openairdocs.org/ntsb/NYC76AN013.md): Cessna 150 · Broad Brook, CT · Accident · 1 fatal · Closed · Jul 27, 1975 · N1286Q · Substantial damage
- [NTSB NYC76FNE01](https://openairdocs.org/ntsb/NYC76FNE01.md): Piper J-3 · Canaan, CT · Accident · Minor injuries · Closed · Jul 12, 1975 · N24881 · Substantial damage
- [NTSB NYC76AN002](https://openairdocs.org/ntsb/NYC76AN002.md): Cessna 150 · Marlborough, CT · Accident · No injuries · Closed · Jul 5, 1975 · N3874V · 2 aircraft · Substantial damage
- [NTSB NYC75FNE02](https://openairdocs.org/ntsb/NYC75FNE02-201285.md): Piper PA-28 · Ansonia, CT · Accident · No injuries · Closed · Jul 2, 1975 · N98267 · Substantial damage
- [NTSB NYC75FNE40](https://openairdocs.org/ntsb/NYC75FNE40.md): Champion 7GCBA · Waterbury, CT · Accident · No injuries · Closed · Jun 23, 1975 · N1880G · Substantial damage
- [NTSB NYC75FNE38](https://openairdocs.org/ntsb/NYC75FNE38.md): Beech B19 · Barkhamsted, CT · Accident · Minor injuries · Closed · May 29, 1975 · N73AK · Destroyed
- [NTSB NYC75AN112](https://openairdocs.org/ntsb/NYC75AN112.md): Beech A45 · Southport, CT · Accident · 2 fatal · Closed · May 29, 1975 · N1061X · Destroyed
- [NTSB NYC75FNE35](https://openairdocs.org/ntsb/NYC75FNE35.md): Piper PA-28 · Danielson, CT · Accident · No injuries · Closed · May 13, 1975 · N95011 · Substantial damage
- [NTSB NYC75FNE33](https://openairdocs.org/ntsb/NYC75FNE33.md): Bellanca 8KCAB · Simsbury, CT · Accident · Minor injuries · Closed · Apr 26, 1975 · N9178L · Substantial damage
- [NTSB NYC75FNE32](https://openairdocs.org/ntsb/NYC75FNE32.md): Cessna A150L · Simsbury, CT · Accident · No injuries · Closed · Apr 5, 1975 · N6503F · Substantial damage
- [NTSB NYC75AN095](https://openairdocs.org/ntsb/NYC75AN095.md): Bell 206B · Shelton, CT · Accident · 2 fatal · Closed · Mar 25, 1975 · N83176 · Destroyed
- [NTSB NYC75FNE29](https://openairdocs.org/ntsb/NYC75FNE29.md): Messerschmt ME109 · Oxford, CT · Accident · No injuries · Closed · Feb 28, 1975 · N90605 · Substantial damage
- [NTSB NYC75FNE27](https://openairdocs.org/ntsb/NYC75FNE27-201266.md): Cessna 172 · Plymouth, CT · Accident · No injuries · Closed · Feb 15, 1975 · N7205E · Substantial damage
- [NTSB NYC75AN082](https://openairdocs.org/ntsb/NYC75AN082.md): Bell 206A · Milford, CT · Accident · 1 fatal · Closed · Feb 1, 1975 · N4726R · Destroyed
- [NTSB NYC75FNE26](https://openairdocs.org/ntsb/NYC75FNE26.md): Beech A23 · Simsbury, CT · Accident · Serious injuries · Closed · Jan 22, 1975 · N6949Q · Substantial damage
- [NTSB NYC75AN080](https://openairdocs.org/ntsb/NYC75AN080.md): Cessna 210 · Middlebury, CT · Accident · 1 fatal · Closed · Jan 11, 1975 · N54CB · Destroyed
- [NTSB NYC75AN079](https://openairdocs.org/ntsb/NYC75AN079.md): Piper PA-23 · Stratford, CT · Accident · 1 fatal · Closed · Jan 10, 1975 · N4322Y · Substantial damage

## 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 year(c."eventDate") = 1975
  AND 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?state=CT&year=1975

---
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.
