# NTSB investigations: Air Tractor AT-400, CA

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 LAX98LA233](https://openairdocs.org/ntsb/LAX98LA233.md): Air Tractor AT-400 · Tranquillity, CA · Accident · No injuries · Limited investigation · Final report · Jul 17, 1998 · N2373V · Substantial damage
  > The pilot's failure to detect and avoid a set of wires during a night aerial application flight. Factors in the accident were the pilot's failure to perform an adequate preflight inspection of the field to determine obstruction locations and the dark night…
- [NTSB LAX92LA227](https://openairdocs.org/ntsb/LAX92LA227.md): Air Tractor AT 400 · Lemoore, CA · Accident · No injuries · Limited investigation · Final report · Jun 2, 1992 · N7307V · Destroyed
  > The pilot's failure to observe the presence of an obstacle in the field. Factors which contributed to the accident were the dark nighttime light condition, and the small size and color of the obstacle which decreased the conspicuity of the object.

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

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

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