Skip to content

Final NTSB investigations: Pratt & Whitney R1340 series, ND

24 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

19842026

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" = 'ND' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' 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\" = 'ND' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
    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" = 'ND' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
  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 CEN23LA347Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401 · Jamestown, NDThe pilot’s failure to maintain proper airspeed after liftoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.Aug 3, 2023 · N6015W · Substantial damage NTSB CEN19LA156Accident · No injuriesClass 3 · LimitedFinal reportRockwell S 2R · Oakes, NDThe failure of the helical cam gear of the engine assembly due to fatigue cracks in the gear teeth, which resulted in a total loss of engine power.May 25, 2019 · N4907X · Substantial damage NTSB CEN16LA314Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Valley City, NDThe pilot's inadequate preflight inspection and fuel planning, which resulted in a loss of engine power due to fuel exhaustion.Aug 5, 2016 · N5599X · Substantial damage NTSB CEN11LA598Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edgeley, NDThe loss of engine power for reasons that could not be determined because postaccident examination of the airplane and engine did not reveal any anomalies that would have precluded normal operation.Aug 13, 2011 · N73071 · Substantial damage NTSB CEN11CA570Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Minot, NDThe pilot's failure to maintain directional control during the crosswind landing, resulting in a ground loop.Aug 3, 2011 · N8764S · Substantial damage NTSB CEN10CA412Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Edmore, NDThe pilot's selection of unsuitable terrain for landing.Jul 17, 2010 · N8774S · Substantial damage NTSB CHI07CA209Accident · Serious injuriesData collectionFinal reportAir Tractor AT-301 · Lignite, NDThe pilot's poor in-flight planning and failure to maintain control of the airplane when he encountered his own vortex turbulence at a low altitude.Jul 15, 2007 · N8841S · Substantial damage NTSB CHI07LA162Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Watford City, NDThe agricultural pilot's failure to maintain clearance from the terrain while maneuvering to avoid power lines. The power lines were a contributing factor in the accident.Jun 5, 2007 · N8835Q · Destroyed NTSB CHI05LA211Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Buchanan, NDThe pilot failed to maintain obstacle clearance from the power lines. Factors included the glare on the windshield and the power lines.Aug 4, 2005 · N6858Q · Destroyed NTSB CHI05LA188Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Langdon, NDThe pilot's failure to maintain clearance from the terrain while attempting an abrupt turning maneuver at a low altitude.Jul 15, 2005 · N3159N · Destroyed NTSB CHI05CA183Accident · Serious injuriesData collectionFinal reportRockwell S-2R · Guelph, NDThe pilot's failure to maintain clearance to the guy wire during the agricultural application pass. Contributing factors were the guy wire, and low altitude flight.Jul 12, 2005 · N4232X · Substantial damage NTSB CHI02LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Langdon, NDThe pilot did not maintain directional control while taxiing. A contributing factor was the wind gust condition present at the time of the accident.Jun 5, 2002 · N7835 · Destroyed NTSB CHI99LA258Accident · Serious injuriesLimited investigationFinal reportAir Tractor 401B · Mccanna, NDthe inadvertent stall by the pilot.Jul 24, 1999 · N6006A · Substantial damage NTSB CHI99LA215Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Page, NDthe pilot's failure to compensate for the wind conditions. Factors were the sudden windshift and the crops.Jul 3, 1999 · N6633K · Substantial damage NTSB CHI98LA305Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edgeley, NDThe pilot's failure to maintain flying airspeed resulting in a stall/mush condition during the initial climb. Contributing factors were the high density altitude, high aircraft weight, and pilot's delayed jettison of the load, as well as the roadway and crop.Aug 9, 1998 · N4443S · Substantial damage NTSB CHI98LA306Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Kindred, NDthe pilot did not maintain clearance with obstructions along his flight path.Aug 8, 1998 · N5524X · Destroyed NTSB CHI98LA301Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · La Moure, NDa loss of engine power due to undetermined reasons.Aug 4, 1998 · N8693H · Substantial damage NTSB CHI98LA241Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Fort Ransom, NDA loss of engine power due to fuel exhaustion. Factors contributing to this accident were the pilot's failure to ensure the airplane had enough fuel to complete the flight, and the fence.Jul 7, 1998 · N4232X · Substantial damage NTSB CHI95LA260Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A-450 · Grand Forks, NDthe pilot's failure to maintain clearance with transmission wires. A factor in the accident was the sunglare.Aug 5, 1995 · N7994 · Substantial damage NTSB CHI92DTG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Alice, NDComplete loss of engine power as a result of the partial failure of four pistons.Sep 10, 1992 · N8823S · Substantial damage NTSB CHI91DTG07Accident · No injuriesFinal reportAyres S2R · Drayton, NDMisjudged clearance by the pilot. A factor related to the accident is overconfidence in personal ability.Aug 7, 1991 · N4010H · Substantial damage NTSB CHI91DTG06Accident · No injuriesFinal reportAyres S2R · Drayton, NDThat the pilot did not perform any preflight planning, and did not use the aircraft performance data.Jul 20, 1991 · N8988Q · Substantial damage NTSB DEN86LA174Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · La Moure, NDAccording to the plt, during a swath run, the acft he was piloting encountered 'bad air' and descended until the wings and wheels contacted the crop of grain he was spraying. The plt stated the acft stalled and contacted the ground.Jun 24, 1986 · N6838Q · Substantial damage NTSB DEN84LA206Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wyndmere, NDSod was worn from the middle of the strip & the strip was wet. Therefore, the plt elected to use the left side of the sod strip for takeoff. During the takeoff roll, the left spray boom dragged into wheat that was growing beside the rwy & the acft veered…Jul 1, 1984 · N4638 · Substantial damage