NTSB investigations: Pratt & Whitney R1340 series, AR
12 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series, where the first occurrence was “Loss of engine power(partial) - 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 | 1 |
|---|---|
| 1984 | 4 |
| 1988 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1998 | 1 |
| 2000 | 1 |
Where
Latest 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\" = 'AR' 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\" = 352))
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" = 'AR' 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" = 352))
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 FTW00LA097Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Gillett, ARThe cracked #8 cylinder resulting in failure of the cylinder. A factor was the plowed/furrowed terrain.NTSB FTW98LA259Accident · No injuriesLimited investigationFinal reportAyres S2R · Watson, ARThe partial loss of engine power due to the disconnection of the propeller governor control as a result of the stripped threads on the propeller governor control push-pull rod. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA301Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Cash, AREngine power loss due to partial failure of one magneto combined with total failure of the other magneto. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA282Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Newport, ARA disconnected throttle push pull rod, due to inadequate maintenance. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB FTW94LA238Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Winchester, ARThe loss of power due to the number one cylinder head cracking. A factor was the lack of suitable terrain for the forced landing.NTSB FTW90DPG13Accident · No injuriesFinal reportGrumman G-164A · Luxora, ARA partial power loss due to failure of the number five connecting rod. A factor was the soft terrain in which the forced landing was made.NTSB MKC88LA161Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillett, ARWhile en route to engage in an aerial application operation, the plt said the engine began to misfire and cut out. Unable to correct the malfunction, the plt dumped his chemical load and began returning to the departure airstrip. En route, he felt he would…NTSB MKC84LA250Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Swifton, ARDuring a swath run the #9 cylinder on the radial engine separated. A forced landing was made during which the acft landed in a levee and nosed over.NTSB MKC84LA211Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Roe, ARAs a result of a supercharger failure, a partial power loss was experienced during a swath run. During the landing roll after a forced landing, the acft nosed over & came to rest inverted. An eng teardown revealed that both supercharger bearings had failed…NTSB MKC84LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Osceola, ARThe acft crashed into a levee in a rice field after losing engine power during a spray operation turn-around. The enginedid not quit entirely but lost enough power so that flt was not maintained. An inspection of the engine revealed a broked connecting rod.NTSB MKC84LA213Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillette, ARDuring swath run engine ran rough and could not sustain acft in flight. The plt made a forced landing in a soft freshly plowed field. The acft nosed over during the landing. Inspection of the acft revealed that one magneto was missing teethfrom the drive gear…NTSB FTW83LA358Accident · No injuriesLimited investigationFinal reportRockwell S2R · Eudora, ARWhile dispensing fertilizer, oil suddenly covered the windshield & the eng began running at reduced power. The plt made an emergency landing in a water covered rice field where the wheels hit a levee & the acft nosed over. An exam revealed that the #1 exhaust…