# NTSB investigations: Piper PA-30, 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 ERA09CA277](https://openairdocs.org/ntsb/ERA09CA277.md): Piper PA-30 · Great Barrington, MA · Accident · No injuries · Data collection · Final report · Apr 30, 2009 · N8034Y · Substantial damage
  > The pilot's improper decision to land with a tailwind.
- [NTSB NYC85LA193](https://openairdocs.org/ntsb/NYC85LA193.md): Piper PA-30 · Worcester, MA · Accident · No injuries · Limited investigation · Final report · Jul 24, 1985 · N999RH · Substantial damage
  > The instructor (CFI) & student were practicing touch-&-go landings. On the 4th landing, the apch & touchdown were made with full flaps extended. The CFI began to retract the flaps while the student applied full power for takeoff. The acft became airborne &…
- [NTSB NYC83LA021](https://openairdocs.org/ntsb/NYC83LA021.md): Piper PA-30 · Nantucket, MA · Accident · No injuries · Limited investigation · Final report · Nov 6, 1982 · N7689Y · Substantial damage
  > Pilot approached runway and right wing dropped. Pilot corrected with full power aileron and elevator. Aircraft yawed and rolled to left. Left wing hit and main gear collapsed. Aircraft groundlooped and stopped.
- [NTSB NYC81FNA03](https://openairdocs.org/ntsb/NYC81FNA03-122898.md): Piper PA-30 · Norwood, MA · Accident · Minor injuries · Closed · Oct 15, 1981 · N33JL · Destroyed
- [NTSB NYC78FNA19](https://openairdocs.org/ntsb/NYC78FNA19.md): Piper PA-30 · Marshfield, MA · Accident · No injuries · Closed · Apr 23, 1978 · N68Y · Substantial damage
- [NTSB NYC77FA058](https://openairdocs.org/ntsb/NYC77FA058.md): Piper PA-30 · Plymouth, MA · Accident · Serious injuries · Closed · May 20, 1977 · N8661Y · Substantial damage
- [NTSB NYC76DNA16](https://openairdocs.org/ntsb/NYC76DNA16.md): Piper PA-30 · Edgartown, MA · Accident · No injuries · Closed · Jul 3, 1975 · N7260Y · Substantial damage
- [NTSB NYC75FNE19](https://openairdocs.org/ntsb/NYC75FNE19.md): Piper PA-30 · Worcester, MA · Accident · No injuries · Closed · Nov 13, 1974 · N7283Y · Substantial damage
- [NTSB NYC74FNA05](https://openairdocs.org/ntsb/NYC74FNA05-130071.md): Piper PA-30 · Provincetown, MA · Accident · Serious injuries · Closed · Jul 13, 1974 · N9000R · Substantial damage
- [NTSB NYC67A0133](https://openairdocs.org/ntsb/NYC67A0133.md): Piper PA-30 · Edgartown, MA · Accident · 2 fatal · Closed · Mar 28, 1967 · N7801Y · Destroyed
- [NTSB NYC67D0418](https://openairdocs.org/ntsb/NYC67D0418.md): Piper PA-30 · Plymouth, MA · Accident · No injuries · Closed · Dec 13, 1966 · N7801Y · Substantial damage
- [NTSB UNK64X2532](https://openairdocs.org/ntsb/UNK64X2532.md): Piper PA30 · Fitchburg, MA · Accident · No injuries · Closed · Jun 28, 1964 · N7106Y · 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" = '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 ('7103002'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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