# Fatal NTSB investigations: Gates Lear Jet 35

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 DCA00MA005](https://openairdocs.org/ntsb/DCA00MA005.md): Learjet 35 · Aberdeen, SD · Accident · 6 fatal · Class 1 · Major · Final report · Oct 25, 1999 · N47BA · Destroyed
  > Incapacitation of the flight crewmembers as a result of their failure to receive supplemental oxygen following a loss of cabin pressurization, for undetermined reasons.
- [NTSB FTW85FA081](https://openairdocs.org/ntsb/FTW85FA081.md): Gates Learjet 35 · Waco, TX · Accident · 1 fatal · Field investigation · Final report · Dec 20, 1984 · N95TC · Destroyed
  > No evidence of preimpact mechanical failure or malfunction was noted during wreckage examination. The FAA operations inspector who was on board at the time of the accident stated there were no aircraft problems involved. The PIC, who wasin the process of…

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

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=5170600

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