# Final 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'
  AND c."completionStatus" = 'Completed'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?state=CT&status=final&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
