NTSB investigations: Pratt & Whitney R1340 series, 2004, 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\") = 2004
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") = 2004
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 LAX04CA323Accident · No injuriesData collectionFinal reportAero Commander S2R · Firebaugh, CAthe failure of the pilot to maintain clearance from high tension wires in dark night conditions. The reason for the loss of engine power after the wire collision was not determined.NTSB LAX04LA267Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Richvale, CAthe loss of engine power during takeoff due to the engine's deteriorated fuel control unit's inner drive shaft bearing. The reason for the bearing's deteriorated condition could not be determined.NTSB LAX04CA154Accident · Minor injuriesData collectionFinal reportAyres S-2R · Los Banos, CAthe pilot's failure to maintain proper runway alignment due to visual restrictions from the light condition, resulting in a nose over. Factors in the accident were the dusk light conditions and sun glare.NTSB LAX04CA153Accident · No injuriesData collectionFinal reportAyres S2R-600 · Calipatria, CAthe failure of ground personnel to refuel the airplane with the proper fuel grade/octane, resulting in the airplane's loss of engine power. Also causal was the pilot's failure to detect the fuel problem during a preflight inspection.NTSB LAX04LA126Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Tracy, CAA loss of engine power for undetermined reasons during cruise flight.