# NTSB investigations: Garrett TFE731 series, NC

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 ERA09CA122](https://openairdocs.org/ntsb/ERA09CA122.md): Dassault-Breguet Falcon 50 · Asheville, NC · Accident · No injuries · Data collection · Final report · Nov 24, 2008 · N200SG · Substantial damage
  > The pilot's failure to ensure that the airplane's wheels were properly secured before releasing the parking brake.
- [NTSB NYC08CA088](https://openairdocs.org/ntsb/NYC08CA088.md): Bombardier 35A · Charlotte, NC · Accident · No injuries · Data collection · Final report · Jan 30, 2008 · N55F · Substantial damage
  > The tug driver's failure to stop for a taxiway stop sign.
- [NTSB MIA00LA013](https://openairdocs.org/ntsb/MIA00LA013.md): British Aerospace HS 125-700A · Fayetteville, NC · Accident · No injuries · Limited investigation · Final report · Oct 19, 1999 · N34GG · Substantial damage
  > The overstress failure of the lugs of the cylinder head of the left main landing gear jack for undetermined reasons. Also, inability of the flight crew to extend the left main landing gear.

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

This list as a web page: https://openairdocs.org/ntsb?engine=29001&state=NC

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