NTSB investigations: Pratt & Whitney R-985 series, CA
310 cases on aircraft whose registry engine model is Pratt & Whitney R-985 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, newest first
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.\"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 ('52008'))
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."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 ('52008'))
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 LAX91LA186Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Madera, CAFailure of the pilot to maintain adequate clearance from the guy wire.NTSB LAX91LA088Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Merced, CAA disoriented and intoxicated automobile driver entering the runway in front of the departing aircraft.NTSB LAX90LA221Accident · Serious injuriesLimited investigationFinal reportGrumman G21A · Long Beach, CAThe pilot's failure to retract the landing gear resulting in an inadvertent wheels-down landing in water. In addition, a loss of elevator control was encountered due to a stress corrosion failure of an elevator control cable turnbuckle as a result of…NTSB LAX90DVA03Accident · Serious injuriesFinal reportNaval Aircraft Factory N3N-3 · Madera, CAThe pilot inadvertently descending into the ground. Contributing to the accident was the inflight opening of the hopper lid which partially obscured the pilot's vision.NTSB LAX89DUM04Accident · No injuriesFinal reportBeech D175 · El Cajon, CAInadequate visual lookout by the pilot of the other aircraft (N9645H).NTSB LAX89LA218Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Trinity Center, CAAn interruption of fuel to the engine for undetermined reasons.NTSB LAX89DVA06Accident · Serious injuriesFinal reportGrumman G-164A · Riverdale, CAInadequate visual lookout by the pilot, when he diverted his attention. The power line was a related factor.NTSB LAX89LA008Accident · No injuriesLimited investigationFinal reportCessna 182A · Visalia, CAA Cessna 182A & a Boeing A75 collided on the rwy. The pilot of the Boeing stated that he was doing touch & go ldgs & had the ldg Cessna in sight. The Boeing plt then lost site of the Cessna after it touched down on rwy 30. The Boeing plt assumed the Cessna…NTSB LAX88DVA15Accident · No injuriesFinal reportSchweizer G-164A · Laton, CANTSB LAX88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Los Angeles, CAWhile taxiing after landing, N911E was instructed to taxi to a position and hold, en route to that position, the acft collided with N75397 that was also holding in the same position. The plt of N911E stated that he did not see the acft due to moisture that…NTSB LAX87LA346Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Lakeport, CAThe pilot stated that the aircraft groundlooped during landing roll just as the tailwheel touched down. There were no reported mechanical problems and winds were light and variable. However, the pilot stated that he thought he felt a gustof wind.NTSB LAX87DVA12Accident · No injuriesFinal reportGrumman G164B · Buttonwillow, CADuring an aerial application flight, after pulling out of a pass over a field the plt heard a loud bang followed by severe engine vibration. The acft lost power and the pilot made a forced landing in a plowed field. During the landing roll the acft nosed…NTSB LAX87LA302Accident · No injuriesLimited investigationFinal reportBeech C-45H · Auburn, CAThe aircraft collided with a ditch after a loss of control during landing rollout. The pilot indicated that during the landing roll the aircraft veered left. Attempted braking action was ineffective. The aircraft had a history of brake problems. The acft had…NTSB LAX87LA265Accident · No injuriesLimited investigationFinal reportBeech D18S · Riverside, CAThe acft had not been flown for svrl years & was on a flt to ferry it to another location. While cruising at 7500', the plt decided to start using aux fuel. Shortly after moving the fuel selectors to the aux psn, both engs lost power & would not restart. The…NTSB LAX87FA040Accident · Serious injuriesField investigationFinal reportBoeing A75N1 · Corona, CAThe plt of N621SR said that as he entered the pattern downwind he saw only one low wing acft which was just turning final for rwy 25. On short final the plt said he noticed the wing and cockpit of the other acft in his left side periphial vision one second…NTSB LAX86DVA05Accident · No injuriesFinal reportGrumman G164A · Snelling, CAThe plt stated he had just lifted off during takeoff when the eng quit. The acft then stalled, hitting a canal and shearing off the main landing gear. The plt stated that a broken fuel line is suspect due to the sudden stoppage and intense ground fire. The…NTSB LAX86FVA03Accident · Minor injuriesFinal reportSchweizer G164A · Wasco, CAThe acft went off the left side of rwy during a downwind landing. The ag plts made a practice of landing downwind to speed up turn-around time. They relied on their brakes to maintain control. The acc acfts brake pads were worn and the rt brake was fluid…NTSB LAX86FA014Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Schellville, CAThe acft crashed while attempting a slow roll immediately after departing from rwy 34 at the sonoma valley arpt. The plt stated to witnesses that he liked to roll his acft after takeoff. Witnesses indicated the acft became airborne after a 300 to 400 ft…NTSB LAX85LA138Accident · No injuriesLimited investigationFinal reportBeech BE-18 · Santa Maria, CAThe plt reptd that during the landing rollout on rwy 30, a gust of wind caused the acft right wing to lift. The plt was unable to correct the uplifting wing and the acft entered into a left groundloop maneuver & exited the rwy. The local controller reported…NTSB LAX85LA113Accident · Minor injuriesLimited investigationFinal reportFairchild M-62C · Ballico, CAAt the conclusion of a local aerial application flt, acft experienced a loss of power and collided with trees during the subsequent forced landing. Examinaton of the aircraft revealed a broken fuel feed line aft of the wobble pump and no fuel in the lines or…NTSB LAX84LA398Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Tracy, CADuring the landing roll, the acft ran off the side of the rwy. The plt stated that he landed with a slight tailwind.NTSB LAX84LA245Accident · No injuriesLimited investigationFinal reportBeech E18S · Buellton, CAThese acft collided in flt while being ferried. The weather was VMC. N8711 was damaged substantially and N753CW receivedminor damage. Both acft landed at santa ynez arpt where N8711 lost control during rollout and ran off the rwy. N753CW was landed with the…NTSB LAX84IA219Incident · No injuriesIncident investigationFinal reportBeech C-45G · Ontario, CAA Beech E18S, N3657G, operating as federal express flt 954L, was cleared for takeoff on rwy 8L after a Boeing 747, N8172G, operating as interflight 429, was cleared to cross the same rwy. The Boeing 747'S cargo included race horses. The Boeing crew were…NTSB LAX84LA084Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Madera, CAAt about 75 ft AGL in a procedure turnaround the acft stalled & collided with orange trees.NTSB LAX83LA324Accident · Minor injuriesLimited investigationFinal reportBoeing IB75A · Tracy, CAAccording to the operator, the pilot lost directional control about 1200 ft down the rwy, lifted off prematurely and was unable to clear trees in an almond orchard at the end ofthe rwy. Initial impact occurred 120 ft north of the rwy centerline.NTSB LAX83LA200Accident · No injuriesLimited investigationFinal reportBeech E-18S · Davis, CAWhile in flt on a parachute jumping mission, a fire erupted in the right eng area & a precautionary landing was made. An exam revealed that the float fulcrum screw, pn 13773, on the stromberg carburetor had backed out & allowed fuel to escape into the exhaust…NTSB LAX83LA172Accident · Minor injuriesLimited investigationFinal reportGrumman American G164-B · Near Madera, CAThe acft hit a chuck hole in high grass during takeoff roll from a field for an aerial application mission. The left landing gear separated from the acft. The weather was VMC and no flight plan was filed. The pilot sustained minor injuries. The flight was…NTSB LAX83FUG02Accident · No injuriesFinal reportWaco SRE · Redlands, CADuring landing into a sun low on the horizon the acft drifted left & touched down slightly off the rwy. The left gear caught a construction hole & sheared off. The acft went out of control & struck a rock pile shearing the right gear off. The rwy recently had…NTSB LAX83LVD01Accident · Minor injuriesFinal reportBoeing A75 · Ft. Bragg, CAThe pilot reported that he was long and fast on his landing approach, so he decided to go around. Due to a noise sensitivity problem in the area, he elected not to use full throttle. Subsequently, the aircraft hit the tops of trees at the end of the runway.…NTSB LAX82DA265Accident · No injuriesFinal reportAir Tractor AT-301 · San Joaquin, CAThe aircraft engine started running rough on a ferry flight and the pilot decided to make a precautionary landing in a cotton field. During the landing the aircraft nosed over.NTSB LAX82DVA15Accident · No injuriesFinal reportBoeing N2S-1-A-75A · Madera, CAThe pilot was on a flight to practice aerial application maneuvers. He reported that while landing, he applied excessive brake pressure and the plane nosed over on its back.NTSB LAX82FA224Accident · No injuriesField investigationFinal reportBeech H-18 · Fresno, CAJust after lift-off from rwy 29R, the acft began to pitch up. As the pitch-up progressed, the plt applied right aileron & full right rudder. The acft responded by rolling to the right with the nose falling thru. Subsequently, the plt was able to pull out…NTSB LAX82DVG24Accident · Minor injuriesFinal reportBoeing A75 · Maxwell, CADuring the takeoff roll from a local farm strip, the aircraft veered to the right and went off the runway. The pilot reported that the plane went into a small ditch and flipped over. No mechanical failures were reported.NTSB LAX82DA116Accident · No injuriesFinal reportHoward DGA-15P · Livermore, CADuring landing roll the aircraft swerved to the right. The pilot countered with left aileron, rudder, and brake but the right wing came up, the turn tightened, and the left main gear collapsed.NTSB LAX81IA015Incident · No injuriesClosedBeech D18S · Long Beach, CANTSB LAX81DVM31Accident · No injuriesClosedBoeing A75 · Greenfield, CANTSB LAX81DUG38Accident · No injuriesClosedBoeing B75N1 · Chino, CANTSB LAX81DVG36Accident · No injuriesClosedGrumman G-164 · Durham, CANTSB LAX81DVG27Accident · No injuriesClosedGrumman G164 · Maxwell, CANTSB LAX81DVA29Accident · No injuriesClosedGrumman G-164B · Farmington, CANTSB LAX81FA126Accident · 1 fatalClosedBeech TC-45J · San Clement Is, CANTSB LAX81FA042Accident · 2 fatalClosedBeech H18 · Newhall, CANTSB LAX80FVM41Accident · No injuriesClosedBoeing A75N1 · Watsonville, CANTSB LAX80FVD31Accident · Minor injuriesClosedBeech D-17S · San Rafael, CANTSB LAX80DUG30Accident · Minor injuriesClosedHoward DGA-15 · Murrieta, CANTSB LAX80DUM09Accident · No injuriesClosedBoeing A75N1 · Ramoa, CANTSB LAX80DUG12Accident · No injuriesClosedBeech E18S · Laverne, CANTSB LAX80FVM06Accident · 1 fatalClosedBoeing A75N1 · Paicines, CANTSB LAX79FVA02Accident · Serious injuriesClosedGrumman G-164A · Madera, CANTSB LAX79FA086Accident · No injuriesClosedBoeing A75N1 · Castaic, CA