# NTSB investigations: Piper PA-28R-201, 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 ERA19LA149](https://openairdocs.org/ntsb/ERA19LA149.md): Piper PA28R · Meriden, CT · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 11, 2019 · N38658 · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB NYC88FA229](https://openairdocs.org/ntsb/NYC88FA229.md): Piper PA-28R-201 · Pomfret, CT · Accident · 4 fatal · Field investigation · Final report · Aug 28, 1988 · N3478M · Destroyed
  > The Piper arrow PA-28R-201, had asked ATC for vectors to windam airport. After being vectored the pilot requested his distance from the airport. He was told that he was 12 miles from the airport, the pilot then decided to descend. ATC advised the pilot to…
- [NTSB NYC86LA051](https://openairdocs.org/ntsb/NYC86LA051.md): Piper PA-28R-201 · Bristol, CT · Accident · No injuries · Limited investigation · Final report · Dec 21, 1985 · N61260 · Substantial damage
  > The acft was on a return flight back to teterboro when an eng failure occurred for unknown reasons. The plt requested vectors to the nearest arpt which was robertson but he was not able to reach it. A forced landing resulted in an open fld during which the…
- [NTSB NYC84FA129](https://openairdocs.org/ntsb/NYC84FA129.md): Piper PA-28R-201 · Burlington, CT · Accident · 1 fatal · Field investigation · Final report · Apr 14, 1984 · N9487C · Destroyed
  > The acft crashed in a steep right descending turn shortly after takeoff. The student plt flying the acft had been scheduled to fly that day but the instructor canceled the flt on account of weather. The acft was seen taxiing out ABOUT1230. After takeoff 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."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 ('7102816', '7102833'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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