# NTSB investigations: Piper PA-34-200T, MA

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 NYC99LA195](https://openairdocs.org/ntsb/NYC99LA195.md): Piper PA-34-200T · Chatham, MA · Accident · No injuries · Limited investigation · Final report · Aug 10, 1999 · N31743 · Substantial damage
  > The pilot's improper flare and improper recovery from a bounced landing.
- [NTSB NYC97FA173](https://openairdocs.org/ntsb/NYC97FA173.md): Piper PA-34-200T · Hancock, MA · Accident · 1 fatal · Field investigation · Final report · Aug 29, 1997 · N40AB · Destroyed
  > The pilot's failure to maintain adequate terrain clearance and the proper altitude. Contributing was mountainous terrain.
- [NTSB NYC86LA058](https://openairdocs.org/ntsb/NYC86LA058.md): Piper PA-28R-200 · Boston, MA · Accident · Serious injuries · Limited investigation · Final report · Jan 7, 1986 · N1468X · No damage
  > The pilot was attempting to start the aircraft for a cross country flight. The weather was cold. Initially. The pilot stated the engine started but stopped. The pilot pulled key from ignition, pulled back throttle and closed the mixture before exiting 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" = 'MA' 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 ('7103406'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7103406&state=MA

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