NTSB investigations: Pratt & Whitney R1340 series, 1993, CA
8 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
Latest 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\") = 1993
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") = 1993
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 LAX94LA063Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Santa Paula, CAwas the failure of the needle valve pin assembly in the airplane's carburetor. A factor which contributed to the accident was the lack of suitable terrain for the emergency landing.NTSB LAX94LA019Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Arvin, CAthe loss of power for undetermined reasons.NTSB LAX93LA327Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dos Palos, CAThe failure of the master rod which resulted in a complete loss of engine power and subsequent forced landing. The irrigation ditch was a factor in this accident.NTSB LAX93LA303Accident · No injuriesLimited investigationFinal reportAyres S2R · Stratford, CAThat the pilot misjudged the airplane's altitude. Factors relating to this accident were the pilot's fatigue and the light conditions.NTSB LAX93LA200Accident · 1 fatalLimited investigationFinal reportGrumman 164A · Biggs, CAFailure of the number 2 engine cylinder. A factor related to the accident was the lack of altitude for the pilot to make a successfull forced landing.NTSB LAX93LA189Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Sacramento, CAfailure of the pilot in command to maintain adequate airspeed during a low altitude maneuvering turn which resulted in an inadvertent stall.NTSB LAX93LA167Accident · Serious injuriesLimited investigationFinal reportAero Commander ST-R · San Jose, CAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.NTSB LAX93LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lost Hills, CAThe pilot's inability to maintain directional control during the landing roll out due to a binding left brake master cylinder.