# NTSB investigations: Piper PA-34-200, 1983

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 NYC84FA032](https://openairdocs.org/ntsb/NYC84FA032.md): Beech K35 · Stockholm, NJ · Accident · 2 fatal · Field investigation · Final report · Nov 18, 1983 · N106Q · 2 aircraft · Destroyed
  > At 1455 EST, a Beech K35 (bonanza), N106Q, & a Piper PA-34-200, N56670, collided while the acft were flying over the vicinity of the sparta VORTAC. The bonanza plt was on a local flt while the PA-34 was on multi-eng training flt. The student in the PA-34…
- [NTSB FTW84LAMS1](https://openairdocs.org/ntsb/FTW84LAMS1.md): Piper PA-34-200 · Gulf Of Mexico · Accident · 1 fatal · Final report · Oct 9, 1983 · N4437T · Destroyed
  > The acft disappeared on a flt over a part of the Gulf Of Mexico south of corpus christi in an area of thunderstorm activity. The storms were densely packed and it was considered unlikely that VFR flt could be conducted in the area. Theaccident acft was in…
- [NTSB FTW83FA149](https://openairdocs.org/ntsb/FTW83FA149.md): Piper PA-34-200 · Kingston, OK · Accident · 3 fatal · Field investigation · Final report · Mar 12, 1983 · N43480 · Destroyed
  > The acft rolled right after a premature liftoff due to a dip in the rwy. The acft continued to roll right until it impacted a 6 degree slope in a 100 degree nose down attitude. Investigation revealed that the right engine had suffered a power loss due to a…

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

This list as a web page: https://openairdocs.org/ntsb?model=7103405&year=1983

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