# NTSB investigations: North American AT-6G, FL

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 ERA10FA342](https://openairdocs.org/ntsb/ERA10FA342.md): North American AT-6 · Destin, FL · Accident · 2 fatal · Field investigation · Final report · Jul 2, 2010 · N92778 · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and spin. Contributing to the accident was the pilot's improper decision to perform the maneuvers at a low altitude and over water.
- [NTSB MIA83LA033](https://openairdocs.org/ntsb/MIA83LA033.md): North American AT-6G · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Nov 20, 1982 · N7618C · Substantial damage
  > During landing, the left main landing gear collapsed. Inspection showed the strut had separated in the uppermost component containing the downlock ear that is threaded into the upper barrel of the shock strut. Examination of the assembly showed evidence of a…

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

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

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