NTSB investigations: Pratt & Whitney R1340 series, TX
12 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series, where the first occurrence was “Loss of engine power”. 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 per year
| 1982 | 3 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1994 | 1 |
| 2001 | 1 |
| 2004 | 1 |
Where
Open the mapLatest cases
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\" = 'TX' 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')
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\" = 350))
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" = 'TX' 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')
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" = 350))
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 FTW04LA182Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Eagle Lake, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA209Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Eagle Lake, TXthe partial loss of engine power for an undetermined reason, which resulted in an in flight collision with trees and terrain.NTSB FTW94LA271Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Clint, TXThe power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW89DQG05Accident · No injuriesFinal reportSchweizer G-164A · Sunray, TXA total power loss for undetermined reasons. A factor was the rough uneven terrain in which the pilot had to make the forced landing.NTSB FTW89DRG05Accident · No injuriesFinal reportGrumman-Schweizer G-164 · Edcouch, TXLoss of engine power for an undetermined reason. The corn crop was a contributing factor.NTSB FTW88DRG07Accident · No injuriesFinal reportGrumman G-164A · Alamo, TXThe pilot experienced a total loss of engine power during climb when he made his initial power reduction. The power loss was accompanied by a loud bang. A severe postaccident ground fire melted a large portion of the engine. A partial engine teardown was…NTSB FTW87DRG05Accident · No injuriesFinal reportAero Commander S2R · La Joya, TXDuring an aerial application flight at a low altitude the aircraft's engine failed. A forced landing was made to a grassfield resulting in substantial damage to the aircraft. Disassembly of the engine revealed partial failure of the left magneto. The aircraft…NTSB FTW86LRG23Accident · No injuriesFinal reportNorth American Rockwell S2-R · Mercedes, TXThe acft experienced a complete loss of eng power at an alt of 200 ft AGL shortly after takeoff. The plt was forced to land against the rows in a muddy cotton field. Shortly after touchdown, the acft flipped over. The exact nature of the eng failure was not…NTSB FTW85LRA02Accident · Serious injuriesFinal reportAir Tractor AT301 · Anahuac, TXThe acft collided with the ground after the engine reportedly lost power for an undetermined reason. Due to the low altitude while applying fertilizer the acft had to be landed in the path of flt.NTSB FTW82DA286Accident · No injuriesFinal reportAir Tractor AT-301 · Rio Hondo, TXImmediately after takeoff, the engine lost power and a forced landing was made in a field of tall cotton. After landing in the cotton field with four-foot-high stalks, the pilot as unable to maintain directional control and the plane was substantially…NTSB FTW82DA202Accident · No injuriesFinal reportAir Tractor AT 301 · New Deal, TXThe pilot departed an ag strip with a heavily loaded aircraft. Reportedly, the elevation and temperature were 3338 ft and 87 deg. After climbing to about 45 ft AGL, he entered a right turn. At this time, he noticed engine roughness and a loss of manifold…NTSB FTW82DRG32Accident · Serious injuriesFinal reportAir Tractor 301 · Mcallen, TXThe pilot reported that the engine failed shortly after takeoff. The aircraft was substantially damaged when it hit a canal bank at the end of the airstrip. According to the operator, the blower section failed which resulted in the loss of power.