NTSB investigations: Pratt & Whitney R1340 series, AR
207 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\" = 'AR' 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" = 'AR' 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 MKC86LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Lake City, ARThe acft dptd the rwy normally to fertilize a nearby fld. The PIC stated that the acft lost pwr shortly into the climb and he had to make a forced lndg off airport. The PIC was unable to dump the load of fertilizer aboard before impact in a rice field. The…NTSB MKC86LA121Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Pocahontas, ARThe pilot stated that this was his third flight of the morning with a full load of fertilizer. Reportedly, he was in the process of aerial application, when the engine quit. He made a forced landing on a short field road. He further stated that the ground…NTSB MKC86LA102Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Almyra, ARThe plt stated that the landing was routine until he used the brakes. At this point the left wheel brake assembly came apart and the acft veered out of control off the right side of the rwy and into a ditch, where the left main landing gear collapsed. Post…NTSB MKC86LA061Accident · Minor injuriesLimited investigationFinal reportSchweizer G164-B · Colt, ARThis was a new acft which the owner was ferrying from the dealer to his private ag strip. The landing was made to the north on a half mile long grass strip and the wind was calm. The plt reports that the brakes were locked when the acft touched down and the…NTSB MKC85LA151Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Paragould, ARThe acft was being used in aerial application of ordram when engine failed. A hard landing resulted during the forced landing in an open fld. Investigation revealed the float needle seat ass'y backed out of the threads in the main body of the carburetor FAR…NTSB MKC85LA123Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paragould, ARPilot was seeding rice when the engine failed. Pilot attempted forced landing on gravel road and impacted a utility pole before touchdown. Acft destroyed by impact and post impact fire. The reason for the engine failure could not be determined.NTSB MKC85LA125Accident · No injuriesLimited investigationFinal reportSnow AT301 · Marianna, ARAfter departing the ag strip the plt rptd a vibrating engine which shook violently until finally quitting. The plt responded with an emergency landing attempt to a plowed bean field. The acft impacted the soft terrain at a high rate of speed where the acft…NTSB MKC85LA107Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Harrisburg, ARPlt reports that the lt wing of N4017N hit a dike in a ricefield while he was making a trim swath. There were no indications of equipment malfunction.NTSB MKC85LA068Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Bradley, ARThe plt said that after liftoff the acft encountered a gust of wind and the acft swerved off the airstrip into rough terrain.NTSB MKC85LA006Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cotton Plant, ARDuring aerial application flight, the engine master connecting rod failed. Forced landing was performed in a Cotton field. Acft nosed over during landing roll due to terrain conditions. Engine had 176 hours since major ovhl.NTSB MKC84LA269Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Weiner, ARThe plt was executing a turn around maneuver to continue spraying when the #2 cyl broke free from the eng & it completely shut down. The acft struck the levee of a bean field & flipped over, coming to rest in an inverted position. Post crash examination…NTSB MKC84LA250Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Swifton, ARDuring a swath run the #9 cylinder on the radial engine separated. A forced landing was made during which the acft landed in a levee and nosed over.NTSB MKC84LA222Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Stanford, ARWhen the pilot made his first swath run he flew over a set of wires, on the return run he went under the wires. The pilot said he hit his own prop wash and rolled enough for the wing tip to contact the wire.NTSB MKC84LA211Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Roe, ARAs a result of a supercharger failure, a partial power loss was experienced during a swath run. During the landing roll after a forced landing, the acft nosed over & came to rest inverted. An eng teardown revealed that both supercharger bearings had failed…NTSB MKC84LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Osceola, ARThe acft crashed into a levee in a rice field after losing engine power during a spray operation turn-around. The enginedid not quit entirely but lost enough power so that flt was not maintained. An inspection of the engine revealed a broked connecting rod.NTSB MKC84LA213Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillette, ARDuring swath run engine ran rough and could not sustain acft in flight. The plt made a forced landing in a soft freshly plowed field. The acft nosed over during the landing. Inspection of the acft revealed that one magneto was missing teethfrom the drive gear…NTSB MKC84LA210Accident · No injuriesLimited investigationFinal reportGrumman G164B · Mc Gehee, ARThe acft was engaged in an aerial application flt when the eng lost power. The plt made a forced landing in a bean field. During the landing roll, the acft struck a levee that was obscured by high vegetation & nosed over. A post-accident investigation…NTSB MKC84LA180Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Pocahontas, ARAbout 18 inches of one propeller blade separated in flight. The acft began to shake violently and the plt shutdown the engine. The aircraft crashed during the forced lndg. Metallurgical examination revealed features typical of fatique cracking over aprox 2/3…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 MKC84LA152Accident · No injuriesLimited investigationFinal reportAyres S2R · Wilmot, ARPlt stated a loss of pwr occurred shortly after takeoff at an alt of 100 ft AGL. The acft nosed over during the forced landing. Inspection of the engine revealed no pre-impact failue/malfunction.NTSB MKC84LA148Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Humnoke, ARPlt stated he noticed a vibration in the acft on two flts prior to the accident flt. Plt felt forward pressure on the stick so he attempted to trim the acft. The acft nosed forward colliding with the terrain. Inspection disclosed no preimpact…NTSB FTW83LA358Accident · No injuriesLimited investigationFinal reportRockwell S2R · Eudora, ARWhile dispensing fertilizer, oil suddenly covered the windshield & the eng began running at reduced power. The plt made an emergency landing in a water covered rice field where the wheels hit a levee & the acft nosed over. An exam revealed that the #1 exhaust…NTSB FTW83LA275Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Newport, ARAccording to the plt, after he took off, he was unable to maintain alt & began dumping his load of 1500 lbs of chemicals. He turned back toward the airstrip, but was forced to land short of a bean field. After touchdown, the acft rolled into a small drainage…NTSB FTW82DA279Accident · No injuriesFinal reportGrumman G-164B · Beedeville, ARThe pilot proceeded to the job site with a load of urea. He circled for about 15 minutes waiting for the flagmen to arrive, then elected to return to the airport. As he leveled the plane, he experienced a gradual loss of power and was unable to maintain…NTSB FTW82DA238Accident · No injuriesFinal reportRockwell Intl S-2R · Eudora, ARSince the aircraft had not flown for two months, the pilot was on a flight to check the systems before flying for hire. The pilot flew over an unpopulated area of the Mississippi river with clear water in the spray tanks. He stated that while he as spraying…NTSB FTW82DA237Accident · Minor injuriesFinal reportGrumman G164B · Beedeville, ARThe agricultural aircraft lost power during takeoff. The pilot jettisoned the load and made a forced landing in a rice field. During the landing, the aircraft nosed over in soft muddy terrain.NTSB FTW82DA187Accident · No injuriesFinal reportGrumman G-164A · Pine Bluff, ARDuring landing the right main landing gear dropped into a ditch alongside the runway and the aircraft nosed over.NTSB FTW82DA172Accident · No injuriesFinal reportGrumman G164B · Marvell, ARDuring an aerial application process the pilot allowed the aircraft to collide with a rice levy. The aircraft was destroyed and there were no injuries to the pilot.NTSB FTW81DPG70Accident · No injuriesClosedAir Tractor AT-301 · Lonoke, ARNTSB FTW81DPG58Accident · No injuriesClosedGrumman G-164A · Piggott, ARNTSB FTW81DPG47Accident · No injuriesClosedRockwell S2R · Dumas, ARNTSB FTW81FPG45Accident · 1 fatalClosedGrumman G-164A · Lonoke, ARNTSB FTW81DPG46Accident · No injuriesClosedGrumman G-164 · Holly Grove, ARNTSB FTW81FPG40Accident · No injuriesClosedGrumman G-164B · Wynne, ARNTSB FTW81FPG35Accident · 1 fatalClosedAyers S2R · West Bay, ARNTSB FTW81DPG34Accident · No injuriesClosedGrumman G-164B · Griffithville, ARNTSB FTW81DPG28Accident · No injuriesClosedGrumman G-164B · Lexa, ARNTSB FTW81DPG22Accident · No injuriesClosedGrumman G-164B · Coy, ARNTSB FTW81DPG01Accident · No injuriesClosedGrumman G-164A · Sherrill, ARNTSB FTW80DPG59Accident · Minor injuriesClosedSnow S2R · Cherry Valley, ARNTSB FTW80DPG54Accident · No injuriesClosedSnow S2R · Hickory Ridge, ARNTSB FTW80DPG53Accident · No injuriesClosedAyres S2R · Winchester, ARNTSB FTW80DPG50Accident · No injuriesClosedGrumman G-164A · Tuckerman, ARNTSB FTW80DPG46Accident · No injuriesClosedAir Tractor AT-301 · Palestine, ARNTSB FTW80DPG34Accident · No injuriesClosedGrumman G-164A · Conway, ARNTSB FTW80FPG29Accident · 1 fatalClosedGrumman G-164B · Minturn, ARNTSB FTW80DPG21Accident · No injuriesClosedGrumman G-164A · Scott, ARNTSB FTW79DPG83Accident · Minor injuriesClosedGrumman G-164B · Marion, ARNTSB FTW79FPG72Accident · No injuriesClosedGrumman G-164B · Amagon, ARNTSB FTW79DPG69Accident · No injuriesClosedGrumman G-164 · Griffithville, AR