# NTSB investigations: Piper PA-24-180, 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 NYC86FA096](https://openairdocs.org/ntsb/NYC86FA096.md): Piper PA-24-180 · Somers, CT · Accident · 5 fatal · Field investigation · Final report · Mar 31, 1986 · N6599P · Destroyed
  > The acft, on a night flt, was seen flying about 1 mi west of ellington arpt. A witness saw the acft flying north and just above the 800 ft high terrain. The acft was in a gradual descent and it appeared that it would not clear terrain ahead. Afterwards the…
- [NTSB NYC86LA055](https://openairdocs.org/ntsb/NYC86LA055.md): Piper PA-24 · Ellington, CT · Accident · No injuries · Limited investigation · Final report · Dec 28, 1985 · N7571P · Substantial damage
  > While on apch for landing, about 50 ft from the rwy, the landing gear contacted a bridge and the acft bounced into the air. Pwr was added at this time and again the acft bounced. The acft was then landed on the rwy and it skidded to a stop. The plt stated she…

## 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.aircraft_model_code IN ('7102403'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102403&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.