NTSB investigations: Pratt & Whitney R1340 series, LA
9 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 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\" = '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\" = 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" = '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" = 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 FTW04CA246Accident · No injuriesData collectionFinal reportGrumman G-164A · Gilbert, LAThe failure of a piston connecting rod for undetermined reasons resulting in the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA107Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Ferriday, LAthe failure of the number three cylinder exhaust rocker arm, resulting in a total loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA178Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Grand Coteau, LAthe loss of engine power while maneuvering, which resulted from a fractured #4 cylinder head at the exhaust valve rocker arm boss. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA074Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Rayville, LAThe loss of engine power due to a crack in the #6 cylinder. A factor was the lack of suitable terrain for the forced landing.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 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 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 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…