# NTSB investigations: Air Tractor AT-602, 2008

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 DFW08CA104](https://openairdocs.org/ntsb/DFW08CA104.md): Air Tractor AT-602 · Paragould, AR · Accident · Serious injuries · Data collection · Final report · Apr 20, 2008 · N8517M · Substantial damage
  > The pilot's failure to maintain clearance from electrical wires while maneuvering. Contributing to the accident were binding of the elevator control, inadvertent stall and trees.
- [NTSB DEN08GA076](https://openairdocs.org/ntsb/DEN08GA076.md): Air Tractor AT-602 · Fort Carson, CO · Accident · 1 fatal · Final report · Apr 16, 2008 · N602AA · Destroyed
  > The pilot's failure to maintain aircraft control following the jettison of the load during an aerial fire flighting mission, which resulted in an inadvertent stall and impact with terrain. Contributing to the accident were the improperly configured aircraft…
- [NTSB DFW08CA084](https://openairdocs.org/ntsb/DFW08CA084.md): Air Tractor AT602 · Back Gate, AR · Accident · No injuries · Data collection · Final report · Mar 13, 2008 · N602KP · Substantial damage
  > The pilot's failure to maintain directional control of the aircraft. A contributing factor was the wet, grass runway.

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

This list as a web page: https://openairdocs.org/ntsb?model=0390309&year=2008

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