NTSB investigations: Pratt & Whitney R1340 series, 2022
10 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 | 15 |
|---|---|
| 1965 | 17 |
| 1966 | 16 |
| 1967 | 24 |
| 1968 | 10 |
| 1969 | 19 |
| 1970 | 16 |
| 1971 | 20 |
| 1972 | 20 |
| 1973 | 33 |
| 1974 | 32 |
| 1975 | 44 |
| 1976 | 49 |
| 1977 | 44 |
| 1978 | 50 |
| 1979 | 50 |
| 1980 | 42 |
| 1981 | 52 |
| 1982 | 42 |
| 1983 | 35 |
| 1984 | 42 |
| 1985 | 36 |
| 1986 | 37 |
| 1987 | 34 |
| 1988 | 42 |
| 1989 | 36 |
| 1990 | 34 |
| 1991 | 30 |
| 1992 | 28 |
| 1993 | 29 |
| 1994 | 40 |
| 1995 | 35 |
| 1996 | 31 |
| 1997 | 23 |
| 1998 | 31 |
| 1999 | 30 |
| 2000 | 26 |
| 2001 | 30 |
| 2002 | 30 |
| 2003 | 22 |
| 2004 | 27 |
| 2005 | 20 |
| 2006 | 17 |
| 2007 | 24 |
| 2008 | 33 |
| 2009 | 25 |
| 2010 | 24 |
| 2011 | 29 |
| 2012 | 16 |
| 2013 | 14 |
| 2014 | 16 |
| 2015 | 13 |
| 2016 | 19 |
| 2017 | 11 |
| 2018 | 12 |
| 2019 | 14 |
| 2020 | 6 |
| 2021 | 11 |
| 2022 | 10 |
| 2023 | 14 |
| 2024 | 12 |
| 2025 | 9 |
| 2026 | 4 |
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\") = 2022
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") = 2022
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 CEN23LA063Accident · No injuriesClass 4 · LimitedFinal reportRockwell International S2R-G6 · Mission, TXThe pilot's failure to maintain clearance from an electrical box.NTSB WPR22LA293Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Circle, MTThe loss of engine power due to carburetor ice. Contributing to the accident was the pilot’s failure to use carburetor heat.NTSB CEN22LA349Accident · No injuriesClass 3 · LimitedFinal reportSchweizer G-164B · Knox, INA partial loss of engine power for undetermined reasons.NTSB ERA22LA297Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman G-164A · Hopewell Township, NJA partial loss of engine power while maneuvering at low altitude due to a failure of the airplane’s supercharger.NTSB ERA22LA224Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-301 · Somerville, TNThe inadequate inspection and maintenance of the engine exhaust system, which resulted in an in-flight fire.NTSB CEN22LA193Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6D · Huntington, INLoss of directional control during landing that resulted in an impact with terrain.NTSB ERA22LA214Accident · No injuriesClass 4 · LimitedFinal reportNorth American SNJ-6 · Greenwood, SCThe loss of directional control due to a fractured tailwheel steering linkage assembly.NTSB CEN22LA187Accident · No injuriesClass 3 · LimitedFinal reportNorth American AT-6D · Fredericksburg, TXA total loss of engine power due to a failure of the No. 1 cylinder.NTSB CEN22LA157Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT-401 · Rayville, LAA loss of engine power for a reason that could not be determined based on available information.NTSB CEN22LA101Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6C · San Antonio, TXThe pilot’s loss of directional control during landing.