# NTSB investigations: Piper PA-36-375, 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 FTW97LA105](https://openairdocs.org/ntsb/FTW97LA105.md): Piper PA-36-375 · Danevang, TX · Accident · No injuries · Limited investigation · Final report · Feb 18, 1997 · N7167E · Substantial damage
  > The utility's company failure to notify affected parties of the downed line, and the pilot's failure to maintain clearance with the downed wire. A factor was the downed wire.
- [NTSB FTW86LQG16](https://openairdocs.org/ntsb/FTW86LQG16.md): Piper PA-36-375 · Plainview, TX · Accident · No injuries · Final report · Aug 11, 1986 · N2370X · Substantial damage
  > The pilot stated that he ran out of fuel as he was returning from an agricultural application flight. While landing in cotton rows, the gear collapsed and the aircraft was substantially damaged.
- [NTSB FTW82FQG15](https://openairdocs.org/ntsb/FTW82FQG15.md): Piper PA-36 · Floydada, TX · Accident · 1 fatal · Final report · Mar 4, 1982 · N2394Y · Destroyed
  > The aircraft crashed about 500 ft north of the field that was being sprayed. After impact, it traveled about 90 ft on a heading of 060 degrees. Green glass fragments were found at the initial impact point as well as propeller slash marks that were nearby. No…
- [NTSB FTW82FPD09](https://openairdocs.org/ntsb/FTW82FPD09.md): Piper PA-36-375 · Saint Jo, TX · Accident · 1 fatal · Final report · Feb 20, 1982 · N3802E · Destroyed
  > After taking off to the south, the plane was observed to climb to about 300 ft AGL, then turn to the southwest. P0WER was reduced, and within three to five miles, the aircraft was turned back toward the airstrip. While approaching the airstrip at about 500 ft…

## 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 ('7103620'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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