# NTSB investigations: North American AT-6D, TX

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 CEN22LA187](https://openairdocs.org/ntsb/CEN22LA187.md): North American AT-6D · Fredericksburg, TX · Accident · No injuries · Class 3 · Limited · Final report · Apr 30, 2022 · N29947 · Substantial damage
  > A total loss of engine power due to a failure of the No. 1 cylinder.
- [NTSB FTW93LA075](https://openairdocs.org/ntsb/FTW93LA075.md): North American AT-6D · Fort Worth, TX · Accident · No injuries · Limited investigation · Final report · Jan 23, 1993 · N101NZ · Substantial damage
  > The pilot's failure to compensate for the crosswind. A factor was the crosswind.
- [NTSB FTW84FA206](https://openairdocs.org/ntsb/FTW84FA206.md): North American AT-6D · Cypress, TX · Accident · 2 fatal · Field investigation · Final report · Apr 21, 1984 · N10605 · Destroyed
  > The acft crashed while spinning after only a few minutes flt. The acft had just been flown by another plt for aprx 20 minutes just prior to the accident flt. This plt/owner said the acft operated in a trouble free manner. During the accident flt the plt made…
- [NTSB FTW82DA384](https://openairdocs.org/ntsb/FTW82DA384.md): North American AT-6D · Houston, TX · Accident · No injuries · Final report · Sep 19, 1982 · N29944 · Destroyed
  > The aircraft began to drift left during takeoff. The pilot decided to lift off and correct the drift in the air. He corrected with right bank and the wing dragged on the ground the aircraft cartwheeled in the grass adjacent to the runway and came to rest…
- [NTSB UNK64X1480](https://openairdocs.org/ntsb/UNK64X1480.md): No American SNJ5 · Ft Worth, TX · Accident · Minor injuries · Closed · Apr 27, 1964 · N7979C · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?model=6400416&state=TX

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