NTSB investigations: Pratt & Whitney R1340 series, 2005
7 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
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 year(c.\"eventDate\") = 2005
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") = 2005
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 SEA05LA192Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Chehalis, WAThe pilot's failure to follow the checklist to switch to the fullest fuel tank prior to departure which resulted in fuel starvation and a loss of engine power during the initial takeoff climb. Subsequently, the aircraft landed hard damaging the landing gear…NTSB CHI05LA229Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Marshalltown, IAThe loss of engine power for undetermined reasons during initial climb and the unsuitable landing area encountered by the pilot during a forced landing.NTSB NYC05LA129Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Penn Yan, NYThe loss of engine power due to a fatigue fractured pushrod.NTSB DFW05CA177Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164C · Gillett, ARThe loss of engine power resulting from a disconnected discharge pressure line at the fuel control unit. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA05LA126Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Mountain Home, IDThe pilot's inadequate in-flight decision by failing to refuel resulting in fuel exhaustion during cruise flight and the loss of engine power. A vehicle was a factor in the on ground collision.NTSB DFW05CA166Accident · No injuriesData collectionFinal reportRockwell International S-2R · Watson, ARThe loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB DFW05CA094Accident · No injuriesData collectionFinal reportGrumman G-164A · Tuckerman, ARThe loss of engine power as result of the failure of the number nine cylinder.