NTSB investigations: Pratt & Whitney R1340 series, MS
14 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
| 1986 | 1 |
|---|---|
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 2 |
| 1998 | 3 |
| 1999 | 1 |
| 2001 | 3 |
| 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\" = 'MS' 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" = 'MS' 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 DFW07LA187Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Cary, MSThe total loss of engine power due to a power turbine failure. Contributing to the accident were the lack of suitable terrain available to pilot for the forced landing and the low altitude.NTSB ATL01LA100Accident · No injuriesLimited investigationFinal reportRockwell S2R · Bentonia, MSThe loss of engine power due to the loss of throttle cable continunity. The throttle cable linkage was worn beyond servicable limits. A factor was uneven terrain at the emergency landing site.NTSB ATL01LA099Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Batesville, MSThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for an emergency landing.NTSB MIA01LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Poplarville, MSa loss of engine power due to a cracked number 2 cylinder which resulted in a forced landing, subsequent impact with the runway, departure from the runway down an embankment, soft terrain and nose over.NTSB MIA99LA203Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Drew, MSa loss of engine power due to the failure of cylinder No. 4 boss, which was caused by fatigue cracking, resulting in a forced landing in marshy terrain and subsequent nose over.NTSB ATL98LA117Accident · No injuriesLimited investigationFinal reportAir Tractor 401 · Holly Bluff, MSThe malfunction of the carburetor which resulted in improper fuel flow to the engine.NTSB MIA98LA201Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Belzoni, MSThe malfunction in the engine blower section, resulting in oil starvation, the seizure of the engine.NTSB MIA98LA181Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Rich, MSa loss of engine power for an undetermined reason, resulting in a forced landing and subsequent impact with rough terrain.NTSB MIA94LA172Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Rolling Fork, MSThe loss of engine power for undetermined causes. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB MIA94LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Walls, MSThe partial loss of engine power for undetermined reasons. The sandy terrain was a factor.NTSB MIA91LA101Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Avon, MSLoss of engine power for undetermined reasons during a turn while on an aerial application flight. Contributing to the accident was failure of the left magneto due to failure of a phenolic gear which drives the rotating magnet.NTSB MIA89LA157Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Arcola, MSThe circumferential on the number 2 cylinder which resulted in a loss of engine power.NTSB MIA87LA142Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Dundee, MSThe plt stated that when reversing direction after an aerial application maneuver the eng quit. He then landed the acft in a creek due to insufficient altitude to clear trees that were in the flight path. Upon touchdown the acft nosed over and came to rest…NTSB MIA87LA012Accident · No injuriesLimited investigationFinal reportAyres SR-2-600 · Glen Allan, MSShortly after takeoff the pilot stated the engine failed and he executed a forced landing. Post accident examination revealed no fuel in the aircraft fuel system.