NTSB investigations: Pratt & Whitney R1340 series, 2006
17 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\") = 2006
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") = 2006
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 LAX07CA053Accident · No injuriesData collectionFinal reportNorth American AT-6C · Mojave, CAthe pilot's failure to maintain adequate clearance from a sign while performing a low altitude maneuver.NTSB ATL07CA018Accident · No injuriesData collectionFinal reportGrumman G-164B · Pine Hill, ALThe pilot's improper fuel management resulting in a total loss of engine power in cruise flight due to fuel exhaustion, subsequent forced landing to non suitable terrain, and an on-ground collision with tree stumps on the landing roll out.NTSB DFW06CA214Accident · No injuriesData collectionFinal reportAir Tractor 301 · Big Spring, TXA loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel the airplane. A contributing factor was the lack of suitable terrain for a forced landing.NTSB ANC06LA134Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Wainwright, AKThe pilot's failure to adequately compensate for wind conditions during the landing roll, which resulted in a loss of control, and subsequent collision with a ditch when the airplane departed the runway. A factor contributing to the accident was a crosswind.NTSB LAX06LA280Accident · No injuriesLimited investigationFinal reportSikorsky S-55 · Paramount, CAthe loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the landing.NTSB CHI06CA235Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164A · Gering, NEThe pilot's failure to maintain clearance from the power lines during the aerial application flight. Factors were the low altitude and power lines.NTSB ANC06LA103Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-3 · Juneau, AKThe pilot's failure to maintain altitude/clearance during approach, which resulted in the airplane impacting the surface of the water. Factors associated with the accident were the flat-light and glassy water conditions, which affected the pilot's ability to…NTSB CHI06CA222Accident · Minor injuriesData collectionFinal reportRockwell S2R · Park Rapids, MNA loss of engine power for undetermined reasons and the inadequate airspeed during the forced landing which resulted in a stall/mush. A factor was the low altitude at which the airplane was being operated.NTSB SEA06CA145Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Lamont, WAThe pilot's failure to maintain terrain clearance while maneuvering.NTSB NYC06LA180Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Vineland, NJA loss of engine power due to foreign object damage for undetermined reasons. Contributing to the accident was the furrowed field.NTSB CHI06CA195Accident · No injuriesData collectionFinal reportGrumman G-164A · Lakeview, MIA loss of engine power for undetermined reasons. A factor associated with the accident was the low altitude at which the airplane was being operated when the loss of engine power occurred.NTSB DEN06CA088Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164A · Cokeville, WYthe pilot's failure to maintain directional control resulting in a ground loop. Contributing factors included the high winds and crosswind.NTSB SEA06CA111Accident · No injuriesData collectionFinal reportNorth American SNJ-6 · American Falls, IDThe pilot's performance of low altitude flight and his failure to maintain clearance with a power line, which resulted in an in-flight collision with the power line.NTSB DFW06CA152Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Victoria, TXThe pilot's delay in aborting the takeoff which resulted in an overrun. A contributing factor was the unfavorable wind.NTSB SEA06CA117Accident · No injuriesData collectionFinal reportAyres S-2R · Grand View, IDThe pilot's inadvertent reduction of turbine engine power to the reverse position while landing on a desert road. A factor was the fence adjacent to the road.NTSB DFW06LA130Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · DeWitt, ARThe failure by both pilots to maintain adequate visual lookout and the Grumman G-164A pilot's impairment caused by the recent use of marijuana.NTSB ANC06CA039Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164A · Dixon, CAThe pilot's failure to attain altitude/clearance during takeoff/initial climb, which resulted in an in-flight collision with terrain. Factors associated with the accident were the pilot's inadequate evaluation of the weather, and unfavorable winds.