# NTSB investigations: Continental A&C75 series, 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 NYC86FNE02](https://openairdocs.org/ntsb/NYC86FNE02.md): Folsom Sonerai II · Middlebury, CT · Accident · No injuries · Final report · Mar 1, 1986 · N27EF · Substantial damage
  > The plt reported that the acft was slow to climb after takeoff and had reached an alt of only 100' AGL at the end of the 5000' lond rwy. The plt continued to state the acft was unable to clear rising terrain aprx 1/2 mile from the arpt. The acft contacted the…
- [NTSB NYC85FNE02](https://openairdocs.org/ntsb/NYC85FNE02.md): Earl F. Folsom Sonerai II · Waterbury, CT · Accident · No injuries · Final report · Aug 2, 1985 · N27EF · Substantial damage
  > The homebuilt sonerai ii made an off airport landing 3 minutes after takeoff. The aircraft received substantial damage and the sole occupant was uninjured. Post crash examination of the aircraft showed the fuel tank was empty. However, there was fuel in the…
- [NTSB NYC81FNE31](https://openairdocs.org/ntsb/NYC81FNE31.md): Erco 415-D · Danbury, CT · Accident · No injuries · Closed · Sep 12, 1981 · N99436 · 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 NYC75FNE11](https://openairdocs.org/ntsb/NYC75FNE11.md): Erco 415-C · Ansonia, CT · Accident · Minor injuries · Closed · Sep 22, 1974 · N320D · Substantial damage
- [NTSB NYC73FNE32](https://openairdocs.org/ntsb/NYC73FNE32.md): Erco 415-D · Waterford, CT · Accident · Minor injuries · Closed · Apr 30, 1973 · N99416 · Substantial damage
- [NTSB NYC72FNE13](https://openairdocs.org/ntsb/NYC72FNE13.md): Piper J3C-65 · Durham, CT · Accident · Minor injuries · Closed · Sep 29, 1971 · N88179 · Substantial damage
- [NTSB NYC67A0092](https://openairdocs.org/ntsb/NYC67A0092.md): Piper PA-18 · North Canaan, CT · Accident · 2 fatal · Closed · Dec 11, 1966 · N3697Z · 2 aircraft · Destroyed
- [NTSB NYC65F0193](https://openairdocs.org/ntsb/NYC65F0193.md): Ercoupe 415C · East Haven, CT · Accident · No injuries · Closed · May 6, 1965 · N93991 · Substantial damage
- [NTSB UNK64X0775](https://openairdocs.org/ntsb/UNK64X0775.md): Ercoupe 415C · Harwington, CT · Accident · No injuries · Closed · Mar 1, 1964 · N93584 · 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 c."eventStateOrRegion" = 'CT' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17005'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17005&state=CT

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