# NTSB investigations: Rockwell International 114: 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 LAX03FA166](https://openairdocs.org/ntsb/LAX03FA166.md): Rockwell 114 · Bishop, CA · Accident · 4 fatal · Field investigation · Final report · May 26, 2003 · N4730W · Destroyed
  > The pilot's failure to maintain an adequate airspeed while maneuvering close to the ground over mountainous terrain in a high density altitude environment near the upper performance capability of the airplane, which resulted in an inadvertent stall/mush into…
- [NTSB BFO90FA050](https://openairdocs.org/ntsb/BFO90FA050.md): Rockwell 114 · Anawalt, WV · Accident · 4 fatal · Field investigation · Final report · May 30, 1990 · N5803N · Destroyed
  > Failure of the pilot to maintain proper altitude and clearance above the terrain. Factors related to the accident were: darkness, mountainous terrain, and low ceiling.
- [NTSB NYC86FA199](https://openairdocs.org/ntsb/NYC86FA199.md): Rockwell 114 · Bedford, PA · Accident · 4 fatal · Field investigation · Final report · Aug 4, 1986 · N5766N · Destroyed
  > The acft nearing the close of a x-country flight had requested a decent to start an approach to land at its final destination. ATC had granted the request, but stated to the pilot that he most remain VFR, the pilot acknowledged the clearance. Acft was located…

## 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 ('7630314')
    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=7630314&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.