NTSB investigations: Pratt & Whitney R1340 series, GA
11 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 | 3 |
|---|---|
| 1985 | 2 |
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2003 | 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\" = 'GA' 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" = 'GA' 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 ATL03LA122Accident · No injuriesLimited investigationFinal reportAir Tractor AT401B · Girard, GAA loss of engine power due to the failure of the internal supercharger blower seals.NTSB MIA96LA122Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Edison, GAFailure of the mounting studs for the No. 4 cylinder, which resulted in separation of the cylinder and loss of engine power. The lack of suitable terrain for a forced landing was a related factor.NTSB ATL95LA169Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Plains, GAFailure of the number four cylinder rocker arm housing and pin, which resulted in a closed exhaust valve and loss of engine power.NTSB ATL94LA128Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Smithville, GAThe failure of # 2 cylinder head.NTSB ATL91LA059Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Pavo, GAThe failure of the no. 2 exhaust valve and cylinder head, which resulted in a total loss of engine power. A factor in the accident was the collision with a road sign during the forced landing.NTSB ATL89DKG05Accident · Minor injuriesFinal reportGrumman G-164A · Dawson, GAFailure of the number three cylinder head.NTSB MIA85LA222Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Colquitt, GAThe aircraft was substantially damaged and the pilot uninjured when the aircraft flipped upside down in a field during a forced landing in an open field following engine failure. A post accident examination of the engine revealed the number seven cylinder…NTSB ATL85LKG04Accident · No injuriesFinal reportAero Commander S2R · Leslie, GAThe acft lost power en route to spray crops & crash landed in a wooded area. The acft had flown only 2 miles when the power loss occurred. During the post accident investigation an exam of the powerplant & systems revealed that the supercharger had a loose…NTSB ATL83LA326Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hatley, GAThe pilot reported that while spraying a cotton field at aprx 60 feet AGL when the engine made a popping sound and then lost power. The pilot landed in a cotton field where the aircraft rolled over on its back and was destroyed by the post impact fire.…NTSB ATL83LA225Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Fort Valley, GAThe eng quit at 200 ft AGL as the plt was returning to a strip. A forced landing was made in a wheat field & the acft rolled through a narrow tree line. The carb float was found cracked & leaking.NTSB ATL83LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Blakely, GAShortly after takeoff, the eng sputtered, lost power & belched black & gray smoke. The plt was unable to get the acft to maintain altidude. Also, he was unable to reach an open field, so he landed on the tops of trees. An investigation revealed that the front…