# NTSB investigations: Piper PA-31T: In flight collision with terrain/water

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 FTW02LA076](https://openairdocs.org/ntsb/FTW02LA076.md): Piper PA-31T · Hobbs, NM · Accident · Serious injuries · Limited investigation · Final report · Feb 5, 2002 · N794CA · Destroyed
  > the pilot's failure to maintain the proper glidepath during the instrument approach. Contributing factors were the dark night light conditions and the pilot's diverted attention.
- [NTSB BFO94LA045](https://openairdocs.org/ntsb/BFO94LA045.md): Piper PA-31T · Norwood, MA · Accident · Minor injuries · Limited investigation · Final report · Feb 21, 1994 · N777JM · Substantial damage
  > The pilot's failure to attain alignment with the centerline of the runway, and his failure to execute a missed approach. Factors which contributed to the accident were: the dark night, the pilot's improper decision to initiate the approach in below-minimum…
- [NTSB LAX92FA120](https://openairdocs.org/ntsb/LAX92FA120.md): Piper PA-31T-II · Big Bear, CA · Accident · 7 fatal · Field investigation · Final report · Feb 17, 1992 · N60AW · Destroyed
  > The pilot's poor judgement in continuing visual flight into instrument meteorological conditions, in mountainous terrain obscured by clouds. Factors in the accident were: the pilot's failure to obtain a preflight weather briefing, the weather conditions, and…
- [NTSB NYC87LA113](https://openairdocs.org/ntsb/NYC87LA113.md): Piper PA-31T · Lawrence, MA · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 1987 · N200FD · Destroyed
  > The crew of the PA-31T cheyenne had made one missed approach and the co-pilot was calling out the altitudes to the pilot. The pilot's reply to the co-pilot was that he was just going to descend to 400 ft. the approach minimums were published for an mda of 660…
- [NTSB ATL85FA256](https://openairdocs.org/ntsb/ATL85FA256.md): Piper PA-31T · Flat Rock, NC · Accident · 5 fatal · Field investigation · Final report · Aug 24, 1985 · N600CM · Destroyed
  > Acft hit northwest side of ridge in level attitude,cruise speed,heading southeast. Conditions were dark night and the cloud ceiling was about 40 feet above the ridge. Pilot received wx brief before take off and en route which reported a ceiling of 10,000 feet…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103124')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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