NTSB investigations: Pratt & Whitney R1340 series, LA
120 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.
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.\"eventStateOrRegion\" = 'LA' 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" = 'LA' 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" 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 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 FTW88DRD17Accident · No injuriesFinal reportSchweizer G-164A · Mangham, LAThe ag airplane was spraying cotton when the engine started to vibrate. Pilot pulled airplane up and vibration was so bad power had to be reduced. Pilot made a forced landing in a muddy field. The left wing caught in tall grass and airplane cartwheeled. Pilot…NTSB FTW88DRD06Accident · No injuriesFinal reportGrumman G-164A · Abbeville, LAThe ag plt had finished spreading his load of chemicals & was landing when the left brake failed to operate. He started to apply pwr for a go-around, but the eng coughed & did not respond properly. The plt then closed the throttle & appliedrgt brake to avoid…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 FTW87DRD08Accident · No injuriesFinal reportGrumman G-164A · Lacassine, LAThe pilot stated the aircraft's tail wheel broke during the takeoff roll causing the aircraft to veer to the right. The right wing contacted a small tree and the right main gear wheel dropped into a ditch which was parallel with the runway. Directional…NTSB FTW87DRD07Accident · No injuriesFinal reportGrumman G-164B · Chenneyville, LAThe engine experienced a total loss of power due to a failed #1 connecting rod. During the forced landing the left wing contacted cotton plants which caused the aircraft to veer left and flip inverted.NTSB FTW87DRD03Accident · Serious injuriesFinal reportSikorsky S-55C · Kurthwood, LAThe engine surged and subsequently lost power during low altitude cruise flight above a dense forest. The pilot autorotated into the trees and then fell through onto the ground. Post accident examination revealed water contamination in the fuel system.NTSB FTW86FRD11Accident · No injuriesFinal reportGrumman G-164A · Crowley, LAThe acft crashed into wires and a house during an attempted forced landing. The plt was preparing to do rice seeding when the eng began to backfire & lose power. The plt was trying to return to the ag strip when the eng quit and he was forced to land. Eng…NTSB FTW86LRD06Accident · No injuriesFinal reportAir Tractor AT301 · Gilbert, LAOn January 29, 1986, an airtractor AT310, N5218S, owned by halcom flying service, was substantially damaged due to a fire which occurred during an attempted engine start. N5218S was to be flown to another location for maintenance purposes.NTSB FTW86FRD01Accident · No injuriesFinal reportNorth American AT6G · Jennings, LAThe acft contacted a ditch and nosed down during an overrun landing. The acft was in a flt of 3 AT6'S landing at the arpt for a fly-in. N104DC touched down on the 2000 ft freshly mowed grass strip aprx 500 to 600 ft from the end. The plt stated the…NTSB FTW84LA262Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bell City, LAA propeller counterweight bearing shaft failed after takeoff at max gross weight. A vibration occurred & the plt began dumping his load, but he was unable to maintain altitude. The aircraft landed in soft mud and nosed over when it collided with a rice levee…NTSB FTW84LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kinder, LAThe plt reported after the accident that he was dispensing fertilizer and had just flown through a heavy rain shower when the engine began to lose power. A forced landing was made in a flooded rice field and the acft nosed over. The pilot stated that he was…NTSB FTW84LA225Accident · No injuriesLimited investigationFinal reportGrumman G164A · Fenton, LAThe acft, while maneuvering at low alt, hit the ground and flipped inverted. The plt reported encountering a strong downdraft over a wooded area and in maneuvering to avoid the trees, the acft settled to the ground. The plt reported winds from 225 degrees at…NTSB FTW84LA185Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Eunice, LAThe plt reported that the engine lost power on takeoff and return to the rwy was not possible, so he landed on the edge of a pond. A post accident investigaiton revealed a crack in the #7 cyl head between the spark plug holes. The engine had just gotten a…NTSB FTW84LA145Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Abbeville, LAThe plt was employed as a professional corporate & charter plt; however, he had not flown agricultural acft in several years. He had receently purchased half interest in the air sevice & was on his 1st refresher flt since then. While the plt was practicing a…NTSB FTW83LA446Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Napoleonville, LAThe acft dragged a wing in the sugarcane crop during a start of a swath run. According to the operator the plt was looking at a map as he approached the run. After the wing dragged the acft yawed 90 degrees and settled into the crop. The engine and right main…NTSB FTW83LA402Accident · No injuriesLimited investigationFinal reportGrumman G-164B · North Lacassine, LAThe plt reported that during the landing, the left wing struck tall grass at the side of the strip & the acft swerved to the left. He tried to correct the situation by applying right braking action, but his braking was ineffective on wet grass. Subsequently,…NTSB FTW83LA366Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Jennings, LAThe acft nosed over during a forced landing after the engine quit shortly after takeoff. The main landing gear mired in soft plowed earth and the acft nosed over during landing. The takeoff gross weight was 5290 lbs. After the accident the engine tear down…NTSB FTW83LA267Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Kinder, LAThe acft collided with a tree and a levee during takeoff. The plt said the wind had shifted before or during takeoff andthe acft at rotation felt as if it stalled. The acft failed to clear a small tree and then was forced into a levee. The acft nosed over…NTSB FTW83LA239Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hayes, LAThe acft ran off the rt side of the rwy and collided with a dirt embankment drng lndg roll. Brake fluid was found on the l main gear following the accd. Investigation revealed the source of the leak to be a popped o-ring in the brake actuating cylinder.NTSB FTW83LA209Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Cheneyville, LAAccording to the operator, the brakes failed during landing causing the acft to ground loop off of the rwy. He also stated that postcrash investigation revealed a broken brake line on the right brake which he suspects was an act of sabotage by an unknown…NTSB FTW82DA350Accident · No injuriesFinal reportAir Tractor AT-301 · Winnesboro, LAThe pilot was circling the field during alignment for his initial swath run when the aircraft engine failed. During the forced landing the aircraft nosed over and the pilot exited the aircraft without turning off any switches. He stated that fuel was leaking…NTSB FTW82DA239Accident · No injuriesFinal reportGrumman G-164A · Jennings, LAThe pilot had just finished spraying and was on his way back to the airport when the engine failed. A field with grass was selected for an emergency landing. During the landing roll, the aircraft encountered ruts and nosed over. The operator reported that the…NTSB FTW82DA236Accident · No injuriesFinal reportAyres S-2R · Edgerly, LAAfter takeoff with a load of fertilizer, the aircraft lost power and a forced landing was made which resulted in damage to the aircraft. The cause of the engine malfunction was not determined.NTSB FTW82DA089Accident · No injuriesFinal reportRockwell S-2R · Oberlin, LAAs the pilot was completing a spray run, he started to close the hopper, but it felt to him that the handle had broken. He looked inside the cockpit momentarily. When he looked back outside, the aircraft had begun a descent. It was too close to the ground to…NTSB FTW81FRJ32Accident · Serious injuriesClosedGrumman G-164B · Mer Rouge, LANTSB FTW81DRD23Accident · No injuriesClosedGrumman G-164A · Kinder, LANTSB FTW80DRD51Accident · No injuriesClosedGrumman G-164A · Kinder, LANTSB FTW80FRJ22Accident · No injuriesClosedAero-Comdr S-2R · Cheneyville, LANTSB FTW80DRD05Accident · No injuriesClosedAero-Comdr S2R · Vinton, LANTSB FTW79DRJ21Accident · No injuriesClosedBoeing A75N1 · Tallulah, LANTSB FTW79DRD43Accident · No injuriesClosedGrumman G-164A · Kinder, LANTSB FTW79DRD39Accident · No injuriesClosedGrumman G-164A · Pine Island, LANTSB FTW79FRD30Accident · No injuriesClosedGrumman G164 · Leblanc, LANTSB FTW78DRD33Accident · No injuriesClosedGrumman G-164A · Basile, LANTSB FTW78DRD29Accident · No injuriesClosedGrumman G-164A · Iota, LANTSB FTW78FRD27Accident · No injuriesClosedGrumman G-164 · Elton, LANTSB FTW78FRJ11Accident · No injuriesClosedGrumman G-164A · Cloutierville, LANTSB FTW77DRJ21Accident · Serious injuriesClosedMurrayair MA-1 · Coushatta, LANTSB FTW77DRJ09Accident · No injuriesClosedGrumman G-164A · Bastrop, LANTSB FTW77FRD32Accident · No injuriesClosedGrumman G-164A · Iota, LANTSB FTW77FRD31Accident · No injuriesClosedGrumman G-164A · Lake Arthur, LANTSB FTW77DRD16Accident · No injuriesClosedGrumman G-164A · Eunice, LANTSB FTW76DRJ42Accident · No injuriesClosedGrumman G-164A · Lake Providnce, LANTSB FTW76FRD42Accident · Serious injuriesClosedGrumman G-164A · Elton, LANTSB FTW76FRD05Accident · No injuriesClosedGrumman G-164A · Erath, LANTSB FTW75FRD52Accident · Minor injuriesClosedGrumman G-164A · Iowa, LANTSB FTW75FRD53Accident · No injuriesClosedGrumman G-164A · Welsh, LANTSB FTW75FRD49Accident · No injuriesClosedGrumman G-164A · Abbeville, LANTSB FTW75FRD48Accident · No injuriesClosedGrumman G-164A · Mermentau, LA