# Fatal NTSB investigations: Piper PA-24: 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 LAX00FA302](https://openairdocs.org/ntsb/LAX00FA302.md): Piper PA-24 · Independence, CA · Accident · 1 fatal · Field investigation · Final report · Aug 16, 2000 · N300P · Substantial damage
  > The pilot's failure to maintain terrain clearance. Factors included night conditions, cockpit lighting, which compromised the pilot's night vision, and drug impairment.
- [NTSB LAX99FA316](https://openairdocs.org/ntsb/LAX99FA316.md): Piper PA-24-180 · June Lake, CA · Accident · 2 fatal · Field investigation · Final report · Sep 18, 1999 · N5673P · Destroyed
  > The pilot's continued VFR flight into known instrument meteorological conditions, including icing, which resulted in an in-flight collision with mountainous terrain.
- [NTSB FTW95FA075](https://openairdocs.org/ntsb/FTW95FA075.md): Piper PA-24-250 · Van Horn, TX · Accident · 2 fatal · Field investigation · Final report · Dec 27, 1994 · N8112P · Destroyed
  > The pilot's failure to maintain proper altitude. Factors were reduced light conditions, clouds, and the pilot's premature descent.
- [NTSB LAX93FA024](https://openairdocs.org/ntsb/LAX93FA024.md): Piper PA-24-180 · Kelso, CA · Accident · 2 fatal · Field investigation · Final report · Oct 31, 1992 · N7902P · Destroyed
  > The pilot's poor preflight planning; his inadequate weather evaluation; and his intentional VFR flight into instrument meteorological conditions. Contributing to the accident was the turbulence, rain and low clouds.
- [NTSB DEN89FA208](https://openairdocs.org/ntsb/DEN89FA208.md): Piper PA-24-180 · Grantsville, UT · Accident · 2 fatal · Field investigation · Final report · Sep 7, 1989 · N7835P · Destroyed
  > Improper in-flight planning/decision by the pilot, by entering a box canyon with insufficient altitude to assure a safe exit. Contributing factors were: box canyon, rising terrain, and high density altitude.

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102402')
    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?fatal=1&model=7102402&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
