NTSB investigations: Pratt & Whitney R1340 series
89 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series, where the first occurrence was “In flight collision with object”. 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
| 1982 | 4 |
|---|---|
| 1983 | 1 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 5 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 4 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 6 |
| 1998 | 6 |
| 1999 | 4 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52016')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52016')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 CHI07CA250Accident · Minor injuriesData collectionFinal reportGrumman G-164A · Vinton, IAThe pilot failed to maintain clearance from the power line while maneuvering during an aerial application flight. A factor was the power line.NTSB CHI07CA230Accident · Minor injuriesData collectionFinal reportGulfstream-Schweizer Gulfstream AM G-164B · Walnut Ridge, ARThe pilot's improper decision to takeoff with a tailwind which resulted in a collision with terrain immediately after liftoff. Factors contributing to the accident were the tailwind and the levee.NTSB CHI07CA220Accident · Minor injuriesData collectionFinal reportSchweizer G-164B · West Liberty, IAThe pilot's inadvertent encounter with birds immediately after takeoff and the resulting loss of engine power. Contributing factors were the fence and ditch encountered during the overrun.NTSB CHI07CA188Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Walkerville, ILThe altitude/clearance not maintained by the pilot during the aerial application flight. The corn was a contributing factor.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 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 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 CHI05LA211Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Buchanan, NDThe pilot failed to maintain obstacle clearance from the power lines. Factors included the glare on the windshield and the power lines.NTSB CHI05CA207Accident · No injuriesData collectionFinal reportAllied Ag Cat Productions G-164A · Trufant, MIThe pilot's inadequate visual lookout and not maintaining clearance from the watering pivot during the aerial application maneuver and the unsuitable terrain he encountered during the emergency landing. A factor was the sunglare encountered.NTSB CHI05CA183Accident · Serious injuriesData collectionFinal reportRockwell S-2R · Guelph, NDThe pilot's failure to maintain clearance to the guy wire during the agricultural application pass. Contributing factors were the guy wire, and low altitude flight.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 CHI04CA224Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Cambridge, KSThe pilot not jettisoning his chemical load during initial climb with the reported loss of airplane performance. Factors were the reported loss of aircraft performance and the tree.NTSB SEA04LA099Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Midvale, IDThe failure of the pilot to maintain clearance from the high tension powerline. A factor was the powerline.NTSB SEA04LA093Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Rexburg, IDThe pilot's failure to maintain clearance from an object while maneuvering during an aerial application flight. Contributing factors were the pilot's diverted attention and the irrigation pivot.NTSB FTW04LA132Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Donna, TXThe pilot's failure to maintain clearance from the high tension power lines.NTSB FTW04LA021Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · San Angelo, TXThe pilot's improper weather evaluation and the wrong runway selection. A contributing factor was the tailwind.NTSB CHI03LA261Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Aplington, IAThe pilot not maintaining proper altitude/clearance from the wire during the aerial application flight. The factor to the accident was the power line.NTSB CHI03LA243Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Mitchell, SDThe pilot's inadequate visual lookout and not maintaining clearance from the power line during the low level aerial application maneuver. A related factor was the power line.NTSB SEA03LA101Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Royal City, WAThe pilot's failure to maintain clearance from a 20 foot high post while applying chemicals to an agricultural field, which resulted in impact damage to the right main landing gear, and ultimately to a collapse of the subject gear during the subsequent…NTSB MIA03LA094Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT- 401 · Fellsmere, FLThe poor in-flight planning by the pilot-in-command for his overhsooting the pull-up following a spray pass resulting in the in-flight collision with trees then terrain. Contributing to the accident was sunglare that the pilot encountered during the spray…NTSB FTW02LA256Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Altus, OKthe pilot's failure to maintain clearance with electrical wires while maneuvering during an aerial application flight.NTSB FTW02LA245Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Hearne, TXThe pilot's failure to maintain clearance with a pump rig while maneuvering during an aerial application flight. A factor was the object.NTSB LAX02LA203Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Westmorland, CAThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight. A factor was the dark night condition.NTSB CHI02LA095Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164A · Cascade, IAThe pilot's inadequate preflight planning/preparation and his failure to maintain clearance with the wire. A factor associated with the accident was the wire that the airplane contacted.NTSB CHI01LA251Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · Pierre, SDclearance not obtained by the pilot. A contributing factor was the transmission line.NTSB CHI01LA195Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Ellinwood, KSThe pilot failed to see and avoid the guy wire during an aerial application flight. A factor associated with the accident was the guy wire.NTSB SEA01LA055Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Waitsburg, WAThe pilot's failure to maintain clearance from the power lines during a pull-up, resulting in an in-flight collision with the lines, loss of control and subsequent in-flight collision with terrain. Contributing factors were the power lines and the pilot's…NTSB SEA00LA148Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Brockway, MTThe pilot's failure to maintain clearance from power lines.NTSB FTW00LA162Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401B · Thibodaux, LAThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight. A factor was the sunglare on the windscreen.NTSB FTW99LA252Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Seminole, TXThe pilot's failure to maintain clearance with powerlines. A factor was the pilot's diverted attention to the light bar for the electronic swath guidance system installed in the airplane.NTSB FTW99LA239Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Hart, TXThe pilot's failure to maintain clearance with power lines.NTSB CHI99LA287Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Garden City, KSThe pilot's misjudging his pull-up maneuver resulting in contact with the wire. A contributing factor was the wire.NTSB MIA99LA160Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Orlando, FLThe pilots misjudgment of altitude during an attempted banner tow pick-up. This resulted in the banner becoming entangled around the main landing gear. The pilot made a go-around. On landing rollout the banner became entangled around a runway light, and the…NTSB SEA98FA164Accident · 2 fatalField investigationFinal reportNorth American SNJ-5C · Winlock, WAThe pilot's failure to maintain adequate altitude during attempted low-level aerobatics.NTSB CHI98LA306Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Kindred, NDthe pilot did not maintain clearance with obstructions along his flight path.NTSB LAX98LA240Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Tracy, CAThe failure of the pilot to maintain an adequate clearance with the telephone wires.NTSB LAX98LA238Accident · No injuriesLimited investigationFinal reportAyres S2R · Shafter, CAThe pilot's failure to maintain an adequate clearance from the irrigation standpipe due to glare from the rising sun.NTSB FTW98LA304Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Plainview, TXThe pilot's failure to maintain obstacle clearance during the aerial application flight. A factor was the transmission wire.NTSB SEA98LA080Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Idaho Falls, IDThe pilot's failure to maintain clearance from a power transmission line during an aerial application flight. Factors include a power line located just beyond the boundary of the field being sprayed, and the pilot's incorrect judgement of the distance between…NTSB FTW97LA336Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Muleshoe, TXfailure of the pilot to see the standpipe in time to avoid an accident (inadequate visual lookout), and his failure to maintain clearance with electrical wires, while maneuvering during an aerial application flight.NTSB CHI97LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Burlington, WIthe deer which contacted the airplane.NTSB MIA97LA210Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Woodeberry, TNin-flight collision with a fence during takeoff. Factors in this accident were the pilot's inadequate pre-flight by not calculating the total weight of the airplane, and high temperatures.NTSB MIA97LA208Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Altha, FLthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain control of the airplane.NTSB FTW97LA242Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edna, TXfailure of the pilot to maintain clearance from a guy wire, during a swath run.NTSB CHI97LA106Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Highmore, SDa premature lift-off of the airplane by the pilot in command.NTSB FTW96LA371Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Meadow, TXThe pilot's failure to maintain clearance from the transmission wire. A factor was the lack of suitable terrain for a forced landing.NTSB ATL96LA116Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Mayersville, MSfailure of the pilot to maintain adequate clearance from an object (vehicle) on the ground.NTSB FTW96LA236Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Dumas, ARFailure of all personnel concerned to identify the unsafe/hazardous condition, which resulted from a visual restriction, due to trees near the intersection of the road and runway.NTSB CHI95LA260Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A-450 · Grand Forks, NDthe pilot's failure to maintain clearance with transmission wires. A factor in the accident was the sunglare.NTSB MIA95LA180Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Clewiston, FLImproper weather evaluation by the pilot in command while attempting to takeoff with a quartering tailwind associated with a nearby thunderstorm and failure of the pilot to maintain directional control.