NTSB investigations: Pratt & Whitney R1340 series, 1985
6 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 | 10 |
|---|---|
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 6 |
| 1986 | 4 |
| 1987 | 5 |
| 1988 | 5 |
| 1989 | 7 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 7 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 7 |
| 1999 | 6 |
| 2000 | 4 |
| 2001 | 8 |
| 2002 | 6 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 7 |
| 2006 | 4 |
| 2007 | 6 |
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 year(c.\"eventDate\") = 1985
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 year(c."eventDate") = 1985
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 LAX85LA360Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Tolleson, AZAccording to the pilot,the engine lost partial power while in cruise flt. He selected a cotton field in which to make a precautionary lng. The aircraft over shot the intended landing area and impacted a utility pole. The collision ruptured the fuel system and…NTSB SEA85LA146Accident · No injuriesLimited investigationFinal reportGrumman 164B · Twin Falls, IDA partial loss of power occurred during aerial application due to a crack around one of the cylinders. While the plt was attempting to dump chemicals, the acft settled onto the ground tearing off the rt main gear. The plt then flew on to Twin Falls to land.…NTSB MKC85LA123Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paragould, ARPilot was seeding rice when the engine failed. Pilot attempted forced landing on gravel road and impacted a utility pole before touchdown. Acft destroyed by impact and post impact fire. The reason for the engine failure could not be determined.NTSB MKC85LA125Accident · No injuriesLimited investigationFinal reportSnow AT301 · Marianna, ARAfter departing the ag strip the plt rptd a vibrating engine which shook violently until finally quitting. The plt responded with an emergency landing attempt to a plowed bean field. The acft impacted the soft terrain at a high rate of speed where the acft…NTSB FTW85LRA02Accident · Serious injuriesFinal reportAir Tractor AT301 · Anahuac, TXThe acft collided with the ground after the engine reportedly lost power for an undetermined reason. Due to the low altitude while applying fertilizer the acft had to be landed in the path of flt.NTSB ATL85FLT04Accident · No injuriesFinal reportGrumman AG-CAT-G-114 · Madisonville, TNThe acft crashed in an open pasture after loss of power following a takeoff from an adjacent pasture. The acft had expereinced a power loss a few minutes earlier which had forced the plt to make an emergengy lndg. After grnd checking the powerplant the plt…