# NTSB investigations: Piper PA-31T, OR

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 LAX93IA029](https://openairdocs.org/ntsb/LAX93IA029.md): Piper PA-31T-620 · Medford, OR · Incident · No injuries · Incident investigation · Final report · Nov 5, 1992 · N131AF · No damage
  > Fatigue failure of the elevator control tube rod end bearing resulting in a loss of elevator control.
- [NTSB SEA88LA184](https://openairdocs.org/ntsb/SEA88LA184.md): Piper PA-31T-620 · Eugene, OR · Accident · No injuries · Limited investigation · Final report · Sep 23, 1988 · N234K · Substantial damage
  > Plt had IFR clrnc and was on ILS approach in VMC above thin fog layer at night. Plt had visual contact with runway environment but collided with 10 foot tall ILS middle marker antenna/building 1/2 mile from runway threshold, separating left main lndg gear and…

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

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

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