NTSB investigations: Pratt & Whitney R1340 series, LA
10 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 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 3 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2007 | 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\" = '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')
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" = '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')
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 DFW07LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Oak Grove, LAA complete loss of power due to failure of the impeller drive gear train and displacement of the blower spring drive mechanism, which resulted in seizure of the propeller shaft/crankshaft. Also causal was the failure of the phenolic separator bracket of the…NTSB FTW04LA091Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Plain Dealing, LAA loss of engine power due to undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA204Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Winnsboro, LAThe pilot's inadequate inflight planning, which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA152Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hathaway, LAthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA209Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW89DRD12Accident · No injuriesFinal reportSchweizer G-164B · Donaldsonville, LALoss of engine power for undetermined reasons. A contributing factor was the soft terrain.NTSB FTW89DRD11Accident · No injuriesFinal reportSchweizer G-164A · Lake Arthur, LALoss of engine power for undetermined reasons. The high weeds (vegetation) & levee (dirt bank) were considered to be related factors.NTSB FTW89DRD07Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Morse, LALoss of engine power for an undetermined reason. The soft terrain was a contributing factor.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 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.