# NTSB investigations, 1978, 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 NYC79FNE02](https://openairdocs.org/ntsb/NYC79FNE02.md): Beech V35A · Chester, CT · Accident · Minor injuries · Closed · Dec 8, 1978 · N7125N · Destroyed
- [NTSB NYC79FA015](https://openairdocs.org/ntsb/NYC79FA015.md): Beech C55 · Enfield, CT · Accident · 3 fatal · Closed · Dec 7, 1978 · N82V · Destroyed
- [NTSB NYC79FA014](https://openairdocs.org/ntsb/NYC79FA014.md): Aerostar 601P · Hartford, CT · Accident · 3 fatal · Closed · Nov 28, 1978 · N8999A · Destroyed
- [NTSB NYC79FA002](https://openairdocs.org/ntsb/NYC79FA002.md): Boeing E-75 · East Gramby Ct, CT · Accident · 1 fatal · Closed · Oct 7, 1978 · N1395V · Substantial damage
- [NTSB NYC78FA097](https://openairdocs.org/ntsb/NYC78FA097.md): Cessna 172M · Windsor Locks, CT · Accident · 1 fatal · Closed · Sep 20, 1978 · N20285 · Destroyed
- [NTSB NYC78FNE32](https://openairdocs.org/ntsb/NYC78FNE32.md): Piper PA-18 · Canaan, CT · Accident · Minor injuries · Closed · Sep 9, 1978 · N5980D · Substantial damage
- [NTSB NYC78FNE34](https://openairdocs.org/ntsb/NYC78FNE34.md): Piper PA-16 · N.Stonington, CT · Accident · Minor injuries · Closed · Sep 2, 1978 · N5791H · Substantial damage
- [NTSB NYC78FNE30](https://openairdocs.org/ntsb/NYC78FNE30.md): Cessna 152 · East Hampton, CT · Accident · No injuries · Closed · Aug 6, 1978 · N714UP · Substantial damage
- [NTSB NYC78FNEZB](https://openairdocs.org/ntsb/NYC78FNEZB.md): Cessna 172 · Plainville, CT · Accident · No injuries · Closed · Jul 29, 1978 · N5497V · Substantial damage
- [NTSB NYC78FNE29](https://openairdocs.org/ntsb/NYC78FNE29.md): Cessna 172 · Essex, CT · Accident · No injuries · Closed · Jul 29, 1978 · N1641V · Substantial damage
- [NTSB NYC78FNE24](https://openairdocs.org/ntsb/NYC78FNE24.md): Cessna 150 · Woodstock, CT · Accident · No injuries · Closed · Jul 1, 1978 · N4583U · Substantial damage
- [NTSB NYC78FNE23](https://openairdocs.org/ntsb/NYC78FNE23.md): Aeronca 11AC · Fairfield, CT · Accident · No injuries · Closed · Jun 26, 1978 · N86013 · Substantial damage
- [NTSB NYC78FA064](https://openairdocs.org/ntsb/NYC78FA064.md): Beech 18 · Windsor Locks, CT · Accident · Minor injuries · Closed · Jun 19, 1978 · N10VT · Destroyed
- [NTSB NYC78FA063](https://openairdocs.org/ntsb/NYC78FA063.md): Beech 95 · Waterford, CT · Accident · 1 fatal · Closed · Jun 8, 1978 · N2714Y · Substantial damage
- [NTSB NYC78FNE20](https://openairdocs.org/ntsb/NYC78FNE20.md): Bellanca 8KCAB · Simsbury, CT · Accident · Minor injuries · Closed · Apr 29, 1978 · N9178L · Substantial damage
- [NTSB NYC78FNE19](https://openairdocs.org/ntsb/NYC78FNE19.md): Cessna 140 · Plainville, CT · Accident · No injuries · Closed · Apr 29, 1978 · N9949 · Substantial damage
- [NTSB NYC78FA046](https://openairdocs.org/ntsb/NYC78FA046.md): Piper PA-28 · Danbury, CT · Accident · 1 fatal · Closed · Apr 29, 1978 · N7126W · Destroyed
- [NTSB NYC78FNE18](https://openairdocs.org/ntsb/NYC78FNE18.md): Cessna 177 · Hartford, CT · Accident · No injuries · Closed · Apr 12, 1978 · N42118 · Substantial damage
- [NTSB NYC78FNE17](https://openairdocs.org/ntsb/NYC78FNE17.md): Cessna 172M · East Windsor, CT · Accident · No injuries · Closed · Apr 1, 1978 · N12219 · Substantial damage
- [NTSB NYC78FNE16](https://openairdocs.org/ntsb/NYC78FNE16.md): Piper PA-28R · Oxford, CT · Accident · Serious injuries · Closed · Mar 31, 1978 · N47568 · Destroyed
- [NTSB NYC78FNE15](https://openairdocs.org/ntsb/NYC78FNE15.md): Beech 24R · Madson, CT · Accident · Serious injuries · Closed · Mar 24, 1978 · N2186W · Substantial damage
- [NTSB NYC78FNE10](https://openairdocs.org/ntsb/NYC78FNE10.md): Elci JD2FF · Waterford, CT · Accident · Minor injuries · Closed · Feb 26, 1978 · N776Y · Substantial damage
- [NTSB NYC78FNE09](https://openairdocs.org/ntsb/NYC78FNE09.md): Piper PA-32 · Meriden, CT · Accident · No injuries · Closed · Feb 23, 1978 · N32919 · Substantial damage
- [NTSB NYC78FA027](https://openairdocs.org/ntsb/NYC78FA027.md): Piper PA-32R · Danbury, CT · Accident · 1 fatal · Closed · Feb 10, 1978 · N47574 · Destroyed
- [NTSB NYC78FNE06](https://openairdocs.org/ntsb/NYC78FNE06.md): Piper PA-28 · Stratford, CT · Accident · No injuries · Closed · Jan 29, 1978 · N7906W · Substantial damage
- [NTSB NYC78FNE05](https://openairdocs.org/ntsb/NYC78FNE05.md): Piper PA-28R · Ellington, CT · Accident · No injuries · Closed · Jan 22, 1978 · N7445J · 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") = 1978
  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=1978

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