NTSB investigations: Pratt & Whitney R1340 series, 2000, 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\") = 2000
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") = 2000
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 LAX00LA344Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Corcoran, CAThe pilot's inadequate preflight inspection and his failure to maintain directional control during takeoff. Factors were the pilot's failure to ensure that the fuel tank cover was replaced properly, fuel contamination of the windscreen, and the sun angle that…NTSB LAX00LA261Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gridley, CAA partial loss of engine power due to the failure of an exhaust valve during an aerial application flight.NTSB LAX00LA254Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6F · Grass Valley, CAfailure of the pilot to maintain directional control during the landing roll resulting in a collision with terrain.NTSB LAX00LA199Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Biggs, CAThe broken exhaust valve rocker arm of the number 3 cylinder that resulted in a total loss of engine power during an aerial application flight.NTSB LAX00LA162Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Lodi, CAA loss of engine power for undetermined reasons.