# Final NTSB investigations: Honeywell TFE731-5BR

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 WPR20LA109](https://openairdocs.org/ntsb/WPR20LA109.md): Raytheon Hawker 800XP · Scottsdale, AZ · Accident · No injuries · Class 3 · Limited · Final report · Mar 14, 2020 · N100AG · Substantial damage
  > The pilot’s inability to maintain directional control during landing for undetermined reasons, which resulted in a runway excursion.
- [NTSB CEN15IA014](https://openairdocs.org/ntsb/CEN15IA014.md): Raytheon Hawker · Denver, CO · Incident · No injuries · Incident investigation · Final report · Oct 15, 2014 · N694ES · Minor damage
  > The failure of the main landing gear tire, which resulted in separation of the servo block and subsequent total loss of all hydraulic system pressure and prevented the landing gear from extending before landing.

## 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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('33851'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=33851&status=final

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