# NTSB investigations: Pratt & Whitney R1340 series, 2004: In flight collision with object

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 LAX04CA323](https://openairdocs.org/ntsb/LAX04CA323.md): Aero Commander S2R · Firebaugh, CA · Accident · No injuries · Data collection · Final report · Sep 18, 2004 · N8822Q · Substantial damage
  > the failure of the pilot to maintain clearance from high tension wires in dark night conditions. The reason for the loss of engine power after the wire collision was not determined.
- [NTSB CHI04CA224](https://openairdocs.org/ntsb/CHI04CA224.md): Air Tractor AT-301 · Cambridge, KS · Accident · Minor injuries · Data collection · Final report · Aug 12, 2004 · N2353W · Substantial damage
  > The pilot not jettisoning his chemical load during initial climb with the reported loss of airplane performance. Factors were the reported loss of aircraft performance and the tree.
- [NTSB SEA04LA099](https://openairdocs.org/ntsb/SEA04LA099.md): Grumman G-164B · Midvale, ID · Accident · Serious injuries · Limited investigation · Final report · Jun 5, 2004 · N8440K · Destroyed
  > The failure of the pilot to maintain clearance from the high tension powerline. A factor was the powerline.
- [NTSB SEA04LA093](https://openairdocs.org/ntsb/SEA04LA093.md): Grumman G-164 · Rexburg, ID · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 2004 · N657Y · Substantial damage
  > The pilot's failure to maintain clearance from an object while maneuvering during an aerial application flight. Contributing factors were the pilot's diverted attention and the irrigation pivot.
- [NTSB FTW04LA132](https://openairdocs.org/ntsb/FTW04LA132.md): Air Tractor AT-301 · Donna, TX · Accident · Minor injuries · Limited investigation · Final report · May 21, 2004 · N3168H · Substantial damage
  > The pilot's failure to maintain clearance from the high tension power lines.

## 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") = 2004
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52016')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=52016&occurrence=220&year=2004

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