# NTSB investigations: Folsom Earl E SONERAI II

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…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('056595E'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=056595E

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