OpenAirDocs.org

NTSB investigations: Pratt & Whitney R1340 series, TX

15 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series, where the first occurrence was “In flight collision with object”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases per year

19822026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "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.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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB FTW04LA132Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Donna, TXThe pilot's failure to maintain clearance from the high tension power lines.May 21, 2004 · N3168H · Substantial damageNTSB FTW04LA021Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · San Angelo, TXThe pilot's improper weather evaluation and the wrong runway selection. A contributing factor was the tailwind.Nov 12, 2003 · N1361E · Substantial damageNTSB FTW02LA245Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Hearne, TXThe pilot's failure to maintain clearance with a pump rig while maneuvering during an aerial application flight. A factor was the object.Aug 30, 2002 · N9193Y · Substantial damageNTSB FTW99LA252Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Seminole, TXThe pilot's failure to maintain clearance with powerlines. A factor was the pilot's diverted attention to the light bar for the electronic swath guidance system installed in the airplane.Sep 3, 1999 · N7362 · DestroyedNTSB FTW99LA239Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Hart, TXThe pilot's failure to maintain clearance with power lines.Aug 25, 1999 · N15119 · Substantial damageNTSB FTW98LA304Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Plainview, TXThe pilot's failure to maintain obstacle clearance during the aerial application flight. A factor was the transmission wire.Jul 8, 1998 · N2325G · Substantial damageNTSB FTW97LA336Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Muleshoe, TXfailure of the pilot to see the standpipe in time to avoid an accident (inadequate visual lookout), and his failure to maintain clearance with electrical wires, while maneuvering during an aerial application flight.Aug 30, 1997 · N9807 · Substantial damageNTSB FTW97LA242Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edna, TXfailure of the pilot to maintain clearance from a guy wire, during a swath run.Jun 30, 1997 · N4396S · Substantial damageNTSB FTW96LA371Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Meadow, TXThe pilot's failure to maintain clearance from the transmission wire. A factor was the lack of suitable terrain for a forced landing.Sep 3, 1996 · N3166H · Substantial damageNTSB FTW95LA028Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Lubbock, TXThe pilot's failure to maintain clearance with the irrigation equipment. A factor was pilot fatigue.Oct 21, 1994 · N8523S · Substantial damageNTSB FTW93LA173Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Ganado, TXThe pilot's failure to maintain clearance with the power linesJun 2, 1993 · N6752Q · DestroyedNTSB FTW91DRG03Accident · Serious injuriesFinal reportGrumman G-164A · Weslaco, TXFailure of the pilot to maintain clearance.Jun 8, 1991 · N7445 · DestroyedNTSB FTW84LA274Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · San Benito, TXAt the beginning of the initial swath run the acft collided with power lines. The power lines remained attached to the acft throughout the uncontrolled descent into a cotton field.Jun 16, 1984 · N8594S · Substantial damageNTSB FTW82DRA22Accident · Serious injuriesFinal reportGrumman G-164 · Hardin, TXThe pilot reported that he struck power lines while flying under them during a swath run. Also, he indicated that a thunderstorm was rapidly approaching the field at the time the accident occurred.Jun 25, 1982 · N8354K · Substantial damageNTSB FTW82FRA20Accident · Serious injuriesFinal reportRockwell Intl S-2R · Alvin, TXThe pilot's father reported that he and his son were en route in separate aircraft to apply fertilizer to a rice field. He noticed his son dive from 500 ft to about 100 ft where the aircraft struck the top ground wires of a transmission line. The plane…May 3, 1982 · N8456V · Destroyed