# NTSB investigations, 1977, 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 NYC78FNE04](https://openairdocs.org/ntsb/NYC78FNE04.md): Cessna 177 · Oxford, CT · Accident · No injuries · Closed · Dec 29, 1977 · N2293Y · Substantial damage
- [NTSB NYC78FNE03](https://openairdocs.org/ntsb/NYC78FNE03.md): Mooney M20 · New Haven, CT · Accident · Serious injuries · Closed · Dec 26, 1977 · N6806V · Substantial damage
- [NTSB NYC78FA016](https://openairdocs.org/ntsb/NYC78FA016.md): Piper PA-28 · Brooklyn, CT · Accident · 1 fatal · Closed · Dec 26, 1977 · N713FL · Substantial damage
- [NTSB NYC78FA015](https://openairdocs.org/ntsb/NYC78FA015.md): Beagle B206 · Greenwich, CT · Accident · 1 fatal · Closed · Dec 20, 1977 · N1008B · Destroyed
- [NTSB NYC78FA014](https://openairdocs.org/ntsb/NYC78FA014.md): Learjet 35 · Groton, CT · Accident · No injuries · Closed · Dec 14, 1977 · N971H · Substantial damage
- [NTSB NYC77FNE36](https://openairdocs.org/ntsb/NYC77FNE36.md): Piper PA-28 · Simsbury, CT · Accident · No injuries · Closed · Sep 19, 1977 · N5425F · Substantial damage
- [NTSB NYC77FNE35](https://openairdocs.org/ntsb/NYC77FNE35.md): Cessna 177R · Stratford, CT · Accident · Minor injuries · Closed · Sep 9, 1977 · N34095 · Substantial damage
- [NTSB NYC77FA090](https://openairdocs.org/ntsb/NYC77FA090.md): Piper PA-28R · Greenwich, CT · Accident · 2 fatal · Closed · Aug 31, 1977 · N3960X · Destroyed
- [NTSB NYC77FNE33](https://openairdocs.org/ntsb/NYC77FNE33.md): Cessna 180 · Waterford, CT · Accident · No injuries · Closed · Aug 25, 1977 · N1596C · Destroyed
- [NTSB NYC77FA078](https://openairdocs.org/ntsb/NYC77FA078.md): Beagle B.206S · Westport, CT · Accident · 2 fatal · Closed · Aug 11, 1977 · N850EX · Destroyed
- [NTSB NYC77FNE32](https://openairdocs.org/ntsb/NYC77FNE32.md): Cessna 150 · Enfield, CT · Accident · Minor injuries · Closed · Jul 25, 1977 · N1555Q · Substantial damage
- [NTSB NYC77FNE28](https://openairdocs.org/ntsb/NYC77FNE28.md): Hebel B-1 · Killingworth, CT · Accident · Serious injuries · Closed · Jul 2, 1977 · N1BF · Minor damage
- [NTSB NYC77FNE27](https://openairdocs.org/ntsb/NYC77FNE27.md): Mooney M20C · Portland, CT · Accident · Minor injuries · Closed · Jun 26, 1977 · N6928N · Substantial damage
- [NTSB NYC77FNE24](https://openairdocs.org/ntsb/NYC77FNE24.md): Cessna 120 · Woodbridge, CT · Accident · No injuries · Closed · Jun 26, 1977 · N1825V · Substantial damage
- [NTSB NYC77FNE26](https://openairdocs.org/ntsb/NYC77FNE26.md): Beech C23 · East Haddam, CT · Accident · Serious injuries · Closed · Jun 24, 1977 · N1921L · Destroyed
- [NTSB NYC77FNE23](https://openairdocs.org/ntsb/NYC77FNE23.md): Cessna 172M · Plainville, CT · Accident · No injuries · Closed · Jun 19, 1977 · N9574H · Substantial damage
- [NTSB NYC77FNE20](https://openairdocs.org/ntsb/NYC77FNE20.md): Piper PA-28 · Milford, CT · Accident · No injuries · Closed · May 22, 1977 · N9937W · Substantial damage
- [NTSB NYC77FNE18](https://openairdocs.org/ntsb/NYC77FNE18.md): Piper J3 · Fairfield, CT · Accident · Minor injuries · Closed · May 16, 1977 · N6661H · Substantial damage
- [NTSB NYC77FA038](https://openairdocs.org/ntsb/NYC77FA038.md): Piper PA-23 · Weathersfield, CT · Accident · 1 fatal · Closed · Apr 13, 1977 · N4483P · Destroyed
- [NTSB NYC77FA051](https://openairdocs.org/ntsb/NYC77FA051.md): Aero Comdr 500B · Bridgeport, CT · Accident · No injuries · Closed · Apr 12, 1977 · N471A · 2 aircraft · Substantial damage
- [NTSB NYC77FNE13](https://openairdocs.org/ntsb/NYC77FNE13.md): Cessna 172 · Chester, CT · Accident · No injuries · Closed · Apr 8, 1977 · N9920Q · Substantial damage
- [NTSB NYC77FNE14](https://openairdocs.org/ntsb/NYC77FNE14.md): Mitsubishi MU-2B · Bridgeport, CT · Accident · No injuries · Closed · Apr 6, 1977 · N234BC · Substantial damage
- [NTSB NYC77FNE11](https://openairdocs.org/ntsb/NYC77FNE11.md): Cessna 150M · Danbury, CT · Accident · Minor injuries · Closed · Mar 27, 1977 · N3686V · Substantial damage
- [NTSB NYC77FNE09](https://openairdocs.org/ntsb/NYC77FNE09.md): Piper PA-32 · Plainville, CT · Accident · No injuries · Closed · Mar 1, 1977 · N1458T · Substantial damage
- [NTSB NYC77FNE29](https://openairdocs.org/ntsb/NYC77FNE29.md): Cessna 150 · North Canaan, CT · Accident · No injuries · Closed · Feb 7, 1977 · N6930G · Substantial damage
- [NTSB NYC77FNE08](https://openairdocs.org/ntsb/NYC77FNE08.md): Ted Smith 601P · Meriden, CT · Accident · No injuries · Closed · Feb 5, 1977 · N1WC · Substantial damage
- [NTSB NYC77FNE07](https://openairdocs.org/ntsb/NYC77FNE07.md): Cessna 177 · Danbury, CT · Accident · Serious injuries · Closed · Jan 16, 1977 · N2288Y · 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") = 1977
  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=1977

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