# NTSB investigations: Piper PA-31-310, TX

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 CEN11LA574](https://openairdocs.org/ntsb/CEN11LA574.md): Piper PA-31-310 · Perryton, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 2011 · N46TB · Substantial damage
  > The explosion and subsequent fire in the airplane for undetermined reasons because an examination of the burned airplane could not identify any preaccident anomolies.
- [NTSB FTW89FA007](https://openairdocs.org/ntsb/FTW89FA007.md): Piper PA-31-350 · Edinburg, TX · Accident · No injuries · Field investigation · Final report · Oct 16, 1988 · N91BB · Destroyed
  > Acft experienced a double eng failure. Plt stated that immediately after the left eng failed, in climb to cruise, the acft rolled left, the stall warning activated, and the acft entered a left spiral. The rt eng failed during the two-turn spiral. Plt's…
- [NTSB FTW84LA138](https://openairdocs.org/ntsb/FTW84LA138.md): Piper PA-31 · Brownsville, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 17, 1984 · N7415L · Substantial damage
  > The plt was maneuvering for an ILS approach when he collided with the ground. He said he was distracted by the swinging CDI and was below the glide slope. He said he started to add power for a missed approach and the acft impacted the ground. A passenger said…
- [NTSB FTW82FRG21](https://openairdocs.org/ntsb/FTW82FRG21.md): Piper PA-31 · Port Mansfield, TX · Accident · 1 fatal · Final report · Jan 17, 1982 · N9181Y · Destroyed
  > The aircraft crashed and burned about 1/2 mile from the approach end of runway 12. A witness reported that "the plane just fell" while the pilot was making a sharp turn. An estimated 1500 lbs of marijuana was on board.
- [NTSB FTW77DA032](https://openairdocs.org/ntsb/FTW77DA032.md): Cessna 172 · Dallas, TX · Accident · No injuries · Closed · Jan 27, 1977 · N4634K · 2 aircraft · Substantial damage
- [NTSB FTW74FRG94](https://openairdocs.org/ntsb/FTW74FRG94.md): Piper PA-31 · D'Hanis, TX · Accident · No injuries · Closed · Jun 8, 1974 · N110BC · Substantial damage
- [NTSB FTW74FPA20](https://openairdocs.org/ntsb/FTW74FPA20.md): Piper PA-31 · Dallas, TX · Accident · No injuries · Closed · Mar 30, 1974 · N6754L · Minor damage
- [NTSB FTW71DQG41](https://openairdocs.org/ntsb/FTW71DQG41.md): Piper PA-31 · Midland, TX · Accident · No injuries · Closed · Oct 13, 1970 · N123SA · 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" = 'TX' 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 ('7103102'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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