# NTSB investigations: Gates Learjet 35A: 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 NYC06FA137](https://openairdocs.org/ntsb/NYC06FA137.md): Gates Learjet 35A · Groton, CT · Accident · 2 fatal · Field investigation · Final report · Jun 2, 2006 · N182K · Destroyed
  > The crew's failure to properly monitor the airplane's altitude, which resulted in the captain's inadvertent descent of the airplane into water. Contributing to the accident were the foggy weather conditions, and the captain's decision to descend below the…
- [NTSB NYC97FA194](https://openairdocs.org/ntsb/NYC97FA194.md): Learjet 35A · Dorchester, NH · Accident · 2 fatal · Field investigation · Final report · Dec 24, 1996 · N388LS · Destroyed
  > The captain's failure to maintain situational awareness, which resulted in the airplane being outside the confines of the instrument approach; and the crew's misinterpretation of a step-down fix passage, which resulted in an early descent into rising terrain.…
- [NTSB ATL88MA184](https://openairdocs.org/ntsb/ATL88MA184.md): Learjet 35A · West Paterson, NJ · Accident · 4 fatal · Major investigation · Final report · May 24, 1988 · N500RW · Destroyed
  > Witnesses rpted a normal takeoff. Radar indicated the acft turned right as cleared and began cruise at 1900 ft, hdg nw at 235 KTS. 65 secs after calling clear of the control zone the acft's radar track ended. The acft was fragmented by theimpact with all flt…

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