NTSB investigations: Pratt & Whitney R1340 series
89 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, newest first
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.\"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.
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."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" DESCRun 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 CHI95LA163Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · E. Grand Forks, MNThe pilot's failure to maintain clearance with the wires.NTSB 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.NTSB CHI94LA292Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Clifton, ILthe pilots failure to keep visual contact with and to avoid unmarked powerlines adjacent to the crop field he was spraying.NTSB MIA93LA176Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Immokalee, FLThe pilot-in-command's failure to maintain airspeed (vs) while maneuvering resulting in a stall/mush.NTSB LAX93LA303Accident · No injuriesLimited investigationFinal reportAyres S2R · Stratford, CAThat the pilot misjudged the airplane's altitude. Factors relating to this accident were the pilot's fatigue and the light conditions.NTSB FTW93LA173Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Ganado, TXThe pilot's failure to maintain clearance with the power linesNTSB FTW93LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stuttgart, ARPilot's failure to maintain clearance from the electrical wires.NTSB FTW92DRD05Accident · Minor injuriesFinal reportGrumman G-164 · Thibodaux, LAThe pilot's failure to maintain clearance from the wires.NTSB LAX92LA219Accident · No injuriesLimited investigationFinal reportGrumman G-164C · Butte City, CAThe pilot's failure to follow normal procedures by selecting the wrong runway. Contributing to this accident was the pilot's premature lift off and the existing tailwind.NTSB MIA91LA183Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Greenwood, FLThe inadequate preflight which resulted in debris in the cockpit which reduced the pilot's visual lookout. Unsuitable terrain encountered during the landing was a factor.NTSB FTW91DRG03Accident · Serious injuriesFinal reportGrumman G-164A · Weslaco, TXFailure of the pilot to maintain clearance.NTSB DEN91LA077Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Ville Platte, LAPremature pull up from an aerial application swath run resulting in a collision with an electrical transmission line.NTSB CHI90DEE07Accident · Minor injuriesFinal reportSchweizer G-164B · Deer Grove, ILThe pilot's inadequate visual lookout, resulting in collision with a power line.NTSB LAX90LA004Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Pacoima, CAThe pilot's misjudgement of the proper altitude and distance from the runway during a night approach.NTSB FTW88DRD18Accident · Serious injuriesFinal reportGrumman G-164A · Rayne, LAAt the end of a swath run, the ag pilot pulled the airplane up and to the left to start a turn-around. The upper left wing struck a steel guy-cable of a 300 foot tower. The airplane made several turns of an inverted flat-spin before water impact into an eight…NTSB LAX88DUM05Accident · No injuriesFinal reportAir Tractor AT-301 · Niland, CAJust after takeoff, the pilot made a right turn to locate the ground flaggers and to avoid transmission wires. The pilot, unable to locate the flaggers, initiated a climb to avoid wires and rising terrain. However, the airplane did not gain sufficient…NTSB MKC88LA126Accident · No injuriesLimited investigationFinal reportRockwell S2R · England, ARThe plt said he had been flying under power lines during an aerial application operation, and while performing his downwind pass, an updraft caused him to collide with the bottom wires. He lost control of the aircraft and collided with the terrain.NTSB MKC88LA108Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Wynne, ARFollowing the takeoff from a private strip near Wynne, Arkansas, the pilot reported that he failed to establish and maintain an adequate angle of climb with the heavily loaded condition of the aircraft. The aircraft impacted trees in the flight path, then…NTSB FTW88DRD02Accident · No injuriesFinal reportGrumman G-164A · Jennings, LAThe ag airplane was spraying over a rice field and was making a turn-around when the airplane settled into small trees and bushes. No problems were found with the airplane or powerplant.NTSB LAX87DVA11Accident · 1 fatalFinal reportRockwell S-2R · Mendota, CAThe ground flagman reported the pilot had just completed spraying the bean field. The pilot was in the process of doing a touch-up application when he flew under the power lines. The airplane right wing contacted the lowest of the 4 powerlines, rolled…NTSB ATL87DEI08Accident · Minor injuriesFinal reportGrumman G-164A · Bucyrus, OHAs the plt was apchg a field to spread fertilizer, the acft collided with a tree & crashed to the ground. The plt received a head injury & said he could not recall the acdnt. According to hospital records, he was suffering from pneumonia & had a 101 deg temp…NTSB DEN87LA102Accident · Minor injuriesLimited investigationFinal reportAero Commander S-2D · Columbus, NMThe plt departed deming, NM and flew to a ranch 15 mi n of Columbus, NM, to position the acft for aerial spraying that day. It was still dark when the plt made his apch to a road paralleled by power lines on the left and telephone cable marker posts on the…NTSB MKC87LA050Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A-600 · Hazen, ARThe pilot stated that he had flown six loads of wheat seeds and was returning to a private airstrip for another load when he ran out of daylight while on final approach to a landing. During the time he was considering the option of a rejected landing and a…NTSB FTW87DPJ01Accident · No injuriesFinal reportSnow AT-301 · Hennessey, OKThe acft collided with a street sign during takeoff. Unablt to maintain flight, the plt landed the acft in a field collapsing the right landing gear.NTSB MIA87FA015Accident · 1 fatalField investigationFinal reportde Havilland DHC-3 · San Juan, PRWitnesses stated that the acft used most of the rwy to takeoff, reached an aprx altitude of 60 feet, then pulled up to clear an embankment. However, the acft struck a tall palm tree & crashed between 2 roads, near an intersection, where the roads merged. The…NTSB SEA86LA243Accident · 1 fatalLimited investigationFinal reportGrumman G164A-450 · Orovado, NVPower lines were inadvertently struck in flight while maneuvering during aerial application. After striking the power lines the aircraft descended to the ground where a fire erupted and the aircraft was then destroyed by fire.NTSB DEN86FA231Accident · 2 fatalField investigationFinal reportNorth American AT-6D · Redcliff, COA husband & wife rprtd that the acft flew near their house at a very low alt, then climbed in the direction of the sun to clear over a bridge. Moments later, the acft collided with power lines that were suspended between 2 towers. The towers were located atop…NTSB CHI86FEX07Accident · Minor injuriesFinal reportAir Tractor AT301 · Bruceville, INThe acft collided with trees during a pull-up at the end of a swath run. During the collision the rt wing tip separated from the acft and the acft rolled hitting the ground with the rt wing first which started a cartwheel. Investigation revealed that the acft…NTSB LAX85LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Williams Afb, AZAfter making his first swath run,during the hours of darkness,the pilot became disorented and flew into an area with tall electrical transmission lines. He descended into trees beneath the lines in his attempt to miss them.NTSB DEN85LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Platte, SDWhile the plt was spraying a field, the landing gear of the acft struck the center pivot of an irrigation structure. Later, when the acft was landed, the gear collapsed.NTSB ATL84LA256Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Adams, TNAfter completing a spray run the plt climbed to 75 ft AGL to fly aprx 2 miles to the next field. The elevation of the destination field was higher than the last one sprayed; no estimate of elevation change was provided. While attempting to climb over a hill…NTSB LAX84LA379Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Stanfield, AZThe plt was maneuvering to start another field when the acft's left wing hit the roof of the ground flagging vehicle. The acft then collided with the ground.NTSB 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.NTSB MKC84LA166Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Pocahontas, ARThe plt said he was making a cleanup swath & encountered spray from the previous swath run. The spray contains a dye which covered the windshield & obscured the plt's vision. The plt said he pulled up at the end of the field but failed to clear the trees.…NTSB LAX83LA115Accident · No injuriesLimited investigationFinal reportGrumman G164A · Mendota, CAThe acft collided with wires and crashed during and aerial application flight. The acft stalled after hitting the wires with the left wing and was out of control when it hit the ground and nosed over. The pilot said he had 3 miles visibility. He was also…NTSB 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.NTSB LAX82DVG26Accident · No injuriesFinal reportGrumman G-164 · Williams, CAThe pilot was applying a granular herbicide to a rice field with low voltage wires on the west border and high voltage lines located diagonally across the field. During a pass from west to east, he crossed over the low voltage wires and lowered the nose to…NTSB LAX82DA194Accident · Minor injuriesFinal reportGrumman G-164A · Woodland, CAThe aircraft collided with wires and crashed during a crop dusting operation. The aircraft hit wires during a turn at the end of a swath run.NTSB 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…