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(total) - mech failure/malf”. 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
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1990 | 1 |
| 1992 | 2 |
| 1996 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2004 | 1 |
| 2005 | 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\" = 351))
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" = 351))
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 DFW05IA222Incident · No injuriesIncident investigationFinal reportAir Tractor AT-401 · Winnie, TXThe loss of engine power due to the failure of the second-stage turbine wheel as a result of low cycle fatigue.NTSB FTW04LA227Accident · No injuriesLimited investigationFinal reportGrumman 164B · East Bernard, TXThe loss of engine power as result of the failure of the number four cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA156Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Sabinal, TXa loss of engine power due to a crack in the #9 cylinder, which result in the failure of the connecting rod during the aerial application flight. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA168Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Garwood, TXthe loss of engine power in cruise flight as a result of the failure of the right magneto. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA159Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Garwood, TXThe failure of the supercharger seal resulting in the loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA341Accident · No injuriesLimited investigationFinal reportAyres S-2R · Wharton, TXtotal loss of engine power due to a fractured torque sensor shaft. Factors relating to the accident were: the obstructions (fence and trees) in the emergency landing area.NTSB FTW92LA094Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe loss of engine power due to rocker arm failure. A factor was the unsuitable terrain.NTSB FTW92LA085Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Valley Mills, TXPower loss due inadequate maintenance and the resultant multiple maintenance discrepancies. A factor was the wet terrain.NTSB FTW90DRA04Accident · No injuriesFinal reportGrumman 164A · Garwood, TXFailure of the number 8 cylinder.NTSB FTW85LA017Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Seminole, TXThe plt reported that while on a local flt the engine 'blew up' & he made an emergency landing. He stated that the windshield was covered with oil & he could not see to flare the acft & landed hard. Inspection revealed a failure of the #4 rod at the master…NTSB FTW83LA404Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Katy, TXThe acft was damaged in a forced landing following engine failure after takeoff. The plt stated that a supercharger bearing failure caused the engine to fail. During the landing in a flooded rice field the landing gear collapsed.NTSB FTW83LA320Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Dayton, TXThe agricultural acft crashed 100 ft short of the rwy after the engine failed. The plt said the engine lost power and RPM so he decided to return to the airstrip after dumping his chemical load. The engine failed completely short of the rwy. The acft hit a…