NTSB investigations: Pratt & Whitney R1340 series, 2011, CA
5 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series. 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
| 1964 | 6 |
|---|---|
| 1965 | 4 |
| 1966 | 5 |
| 1967 | 7 |
| 1968 | 1 |
| 1969 | 2 |
| 1971 | 3 |
| 1972 | 4 |
| 1973 | 3 |
| 1974 | 6 |
| 1975 | 4 |
| 1976 | 11 |
| 1977 | 9 |
| 1978 | 16 |
| 1979 | 9 |
| 1980 | 11 |
| 1981 | 15 |
| 1982 | 5 |
| 1983 | 8 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 6 |
| 1988 | 6 |
| 1989 | 7 |
| 1990 | 5 |
| 1991 | 4 |
| 1992 | 5 |
| 1993 | 8 |
| 1994 | 7 |
| 1995 | 6 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 6 |
| 1999 | 3 |
| 2000 | 5 |
| 2001 | 1 |
| 2002 | 5 |
| 2003 | 2 |
| 2004 | 5 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 3 |
| 2010 | 5 |
| 2011 | 5 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 5 |
| 2018 | 3 |
| 2019 | 4 |
| 2020 | 2 |
| 2021 | 3 |
| 2023 | 2 |
| 2024 | 4 |
| 2025 | 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 year(c.\"eventDate\") = 2011
AND c.\"eventStateOrRegion\" = 'CA' 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'))
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") = 2011
AND c."eventStateOrRegion" = 'CA' 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'))
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 WPR11LA320Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Yuba City, CAHigh-cycle fatigue on the 1st-stage compressor blade retaining ring, which resulted in the ring’s fracture and a subsequent loss of engine power.NTSB WPR11LA279Accident · Serious injuriesLimited investigationFinal reportRockwell International S-2R · Brawley, CAThe partial loss of engine power shortly after takeoff, which likely resulted from the failure of the piston connecting rod in cylinder number 3 due to hydraulic lock in that cylinder.NTSB WPR11LA273Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Marysville, CAThe separation of the right main landing gear during takeoff, due to fatigue.NTSB WPR11CA198Accident · No injuriesData collectionFinal reportGrumman G-164 · Princeton, CAThe pilot’s failure to maintain adequate airspeed while maneuvering, resulting in an aerodynamic stall and collision with terrain.NTSB WPR11CA128Accident · No injuriesData collectionFinal reportSchweizer G-164B · Buttonwillow, CAThe pilot's failure to maintain clearance from an irrigation vent pipe.