# NTSB investigations, 1980, 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 NYC81FNE06](https://openairdocs.org/ntsb/NYC81FNE06.md): Piper PA-28 · Chester, CT · Accident · Serious injuries · Closed · Dec 12, 1980 · N6348R · Substantial damage
- [NTSB NYC81FNE05](https://openairdocs.org/ntsb/NYC81FNE05.md): Piper J-3 · Coventry, CT · Accident · Minor injuries · Closed · Dec 7, 1980 · N92654 · Substantial damage
- [NTSB NYC81IA015](https://openairdocs.org/ntsb/NYC81IA015.md): Nord 262A12 · Groton, CT · Incident · Minor injuries · Closed · Dec 3, 1980 · N26217 · Minor damage
- [NTSB NYC81FAMS1](https://openairdocs.org/ntsb/NYC81FAMS1.md): Piper PA-31 · Bridgeport, CT · Accident · 4 fatal · Closed · Nov 10, 1980 · N62987 · Destroyed
- [NTSB NYC81FNE02](https://openairdocs.org/ntsb/NYC81FNE02.md): Bellanca 7ECA · Winsor Locks, CT · Accident · No injuries · Closed · Nov 2, 1980 · N2684G · Substantial damage
- [NTSB NYC81FNE01](https://openairdocs.org/ntsb/NYC81FNE01.md): Beech C23 · Ellington, CT · Accident · No injuries · Closed · Oct 22, 1980 · N67168 · Substantial damage
- [NTSB NYC80DA074](https://openairdocs.org/ntsb/NYC80DA074.md): Piper PA-23 · Hartford, CT · Accident · No injuries · Closed · Aug 20, 1980 · N62656 · Substantial damage
- [NTSB NYC80FA068](https://openairdocs.org/ntsb/NYC80FA068.md): Cessna 172 · Burlington, CT · Accident · 3 fatal · Closed · Aug 11, 1980 · N737AD · Destroyed
- [NTSB NYC80DA067](https://openairdocs.org/ntsb/NYC80DA067.md): Hiller Acft UH-12C · Meriden, CT · Accident · Minor injuries · Closed · Aug 9, 1980 · N1042C · Substantial damage
- [NTSB NYC80FNE23](https://openairdocs.org/ntsb/NYC80FNE23.md): Cessna 152 · Berlin, CT · Accident · Serious injuries · Closed · Jul 19, 1980 · N24976 · Destroyed
- [NTSB NYC80FNE21](https://openairdocs.org/ntsb/NYC80FNE21.md): Cessna 150G · Franklin, CT · Accident · No injuries · Closed · Jul 5, 1980 · N8345J · Substantial damage
- [NTSB NYC80FNE20](https://openairdocs.org/ntsb/NYC80FNE20.md): Piper J3C-65 · Windham, CT · Accident · No injuries · Closed · Jul 4, 1980 · N98467 · Substantial damage
- [NTSB NYC80FNE19](https://openairdocs.org/ntsb/NYC80FNE19.md): Stinson 108-1 · Windham, CT · Accident · Serious injuries · Closed · Jun 26, 1980 · N1081S · Substantial damage
- [NTSB NYC80FNE16](https://openairdocs.org/ntsb/NYC80FNE16.md): Cessna 150 · Meriden, CT · Accident · No injuries · Closed · May 23, 1980 · N6204T · Substantial damage
- [NTSB NYC80FNE15](https://openairdocs.org/ntsb/NYC80FNE15.md): Mooney M20E · Danielson, CT · Accident · No injuries · Closed · May 5, 1980 · N7198V · Substantial damage
- [NTSB NYC80FA034](https://openairdocs.org/ntsb/NYC80FA034.md): Beech 95-C55 · Hartford, CT · Accident · No injuries · Closed · Apr 10, 1980 · N466AS · Substantial damage
- [NTSB NYC80FNE13](https://openairdocs.org/ntsb/NYC80FNE13.md): Temco GC-1B · Hartford, CT · Accident · Serious injuries · Closed · Mar 22, 1980 · N2445B · Substantial damage
- [NTSB NYC80FNE11](https://openairdocs.org/ntsb/NYC80FNE11.md): Robinson R-22 · Rocky Hill, CT · Accident · No injuries · Closed · Mar 17, 1980 · N9017Z · Substantial damage
- [NTSB NYC80FNE10](https://openairdocs.org/ntsb/NYC80FNE10.md): Cessna 150 · Waterford, CT · Accident · Minor injuries · Closed · Feb 8, 1980 · N61085 · Substantial damage
- [NTSB NYC80FNE09](https://openairdocs.org/ntsb/NYC80FNE09.md): Cessna 150 · Windsor Locks, CT · Accident · No injuries · Closed · Feb 1, 1980 · N704WG · Substantial damage
- [NTSB NYC80FNE08](https://openairdocs.org/ntsb/NYC80FNE08.md): Mooney M20E · Williamantic, CT · Accident · No injuries · Closed · Jan 5, 1980 · N9265V · 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") = 1980
  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=1980

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