Skip to content

NTSB investigations: Pratt & Whitney R1340 series, KS

22 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19692026

Where

Latest cases

Query with 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" = 'KS' 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')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'KS' 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'))
  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.

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" = 'KS' 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'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CEN17LA163Accident · No injuriesLimited investigationFinal reportGrumman Schweizer G-164 · Palmer, KSA crack in the cylinder of the radial engine, which resulted in a loss of engine power and a forced landing on unsuitable terrain.Apr 17, 2017 · N9533 · Substantial damage NTSB CEN14CA427Accident · Serious injuriesData collectionFinal reportAir Tractor AT 401B · Cimarron, KSThe pilot's failure to maintain clearance from the antenna guy wire during an aerial application pass.Aug 13, 2014 · N9071Z · Substantial damage NTSB DFW08CA156Accident · No injuriesData collectionFinal reportAyres S-2R · McDonald, KSThe pilot's failure to maintain aircraft control during the takeoff. Contributing to the accident was the soft terrain.May 25, 2008 · N4002R · Substantial damage NTSB DFW08CA086Accident · No injuriesData collectionFinal reportAir Tractor At-301 · Plains, KSA loss of engine power as a result of a blocked carburetor. A factor was the lack of suitable terrain for the forced landing.Mar 26, 2008 · N4427S · Substantial damage NTSB CHI04CA224Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Cambridge, KSThe 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.Aug 12, 2004 · N2353W · Substantial damage NTSB CHI03LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Seneca, KSThe pilot's failure to maintain directional control while landing. Factors contributing to the accident were the collapse of the left main landing gear strut and the ditch.May 29, 2003 · N29SK · Substantial damage NTSB CHI02LA206Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401B · Pratt, KSThe pilot's failure to maintain terrain clearance. A factor was low altitude flight.Jul 22, 2002 · N60747 · Substantial damage NTSB CHI01LA195Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Ellinwood, KSThe pilot failed to see and avoid the guy wire during an aerial application flight. A factor associated with the accident was the guy wire.Jul 2, 2001 · N4549E · Substantial damage NTSB CHI99LA287Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Garden City, KSThe pilot's misjudging his pull-up maneuver resulting in contact with the wire. A contributing factor was the wire.Aug 11, 1999 · N4923X · Substantial damage NTSB CHI97LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Prairie View, KSan undetermined event, which resulted in loss of engine power. Factors relating to the accident were: an automobile, which prevented the pilot from landing on a road; and a dirt bank (terrace) in the emergency landing area.May 9, 1997 · N7859 · Substantial damage NTSB CHI96LA258Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Liberal, KSthe pilot did not maintain aircraft control. A factor was a low altitude flight maneuver was performed.Jul 28, 1996 · N8837S · Destroyed NTSB CHI96LA265Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Macksville, KSfailure of the pilot to allow the airplane to achieve sufficient airspeed for takeoff, and the resultant loss of aircraft control. Factors relating to the accident were: the rough runway, and the mound of dirt at the end of the runway.Jul 27, 1996 · N4630 · Substantial damage NTSB CHI96LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ness City, KSthe failure of a counterweight bolt in the propeller for reasons undetermined. Factors were the wet landing area and the encounter with unsuitable terrain during the forced landing.Jun 26, 1996 · N8883S · Substantial damage NTSB CHI95LA198Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Hoxie, KSthe loss of engine power due to the loose nut on the adjustment screw and the jammed exhaust valve on the number three cylinder. A factor in the accident was the ditch.Jun 11, 1995 · N23477 · Substantial damage NTSB CHI94LA106Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Sublette, KSthe commercial pilot's failure to maintain clearance from terrain. Related factors are sun glare and rising terrain.Mar 15, 1994 · N9686 · Substantial damage NTSB CHI91DCQ07Accident · No injuriesFinal reportGrumman G-164A · Sharon Springs, KSAircraft takeoff performance exceeded and disregard of performance data by the pilot. A factor associated with the accident is high density altitude.Jul 19, 1991 · N7964 · Substantial damage NTSB MKC90LA128Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ulysses, KSFailure of the powerplant cylinder and stall/mush encountered by the pilot in command.Jun 15, 1990 · N3650Z · Substantial damage NTSB MKC86LA165Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hugoton, KSThe PIC stated that the eng quit on takeoff abt 100 feet abv the gnd and 200 yds past the departure end of the rwy. The PIC stated that he had no warning prior to the engine quitting. The acft dscnd to the gnd, impacted hard and subsequently flipped over…Aug 2, 1986 · N8677H · Substantial damage NTSB MKC85LA184Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT301 · Oakley, KSN8541S collided with a fence and crashed while attempting a forced landing. The plt reports that it took longer than expected to dispense his chemical load and he was critically low on fuel when he departed the working area for the arpt. He got to within 2…Aug 13, 1985 · N8541S · Substantial damage NTSB MKC84LA231Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Garden City, KSThe plt stated that after the acft was fueled he failed to visually check the fuel tanks and just assumed both tanks were full. He stated the left fuel gage had been inoperative above 1/2 tank of fuel. During a spray run, when the right tank reached 1/4, he…Jul 24, 1984 · N3669X · Substantial damage NTSB MKC77FCQ44Accident · No injuriesClosedGrumman G-164A · Junction City, KSJun 27, 1977 · N5396 · Substantial damage NTSB MKC70F0198Accident · Serious injuriesClosedBoeing A75N1 · Basehor, KSJul 6, 1969 · N61673 · Substantial damage