OpenAirDocs.org

NTSB investigations: Pratt & Whitney R-985 series

60 cases on aircraft whose registry engine model is Pratt & Whitney R-985 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, 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52008')
      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.

NTSB DEN83LA170Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Page, NDWhile spraying at dusk, the plt was concerned about injuring a 'non-target crop' across the road to the south from the field that was being sprayed. He stated that an irrigation system was sitting pointed southwest, and that as he was entering a swath to the…Jun 29, 1983 · N6652Q · Substantial damageNTSB 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.…Oct 10, 1982 · N56772 · DestroyedNTSB FTW82DA257Accident · No injuriesFinal reportGrumman G-164A · Epps, LAThe pilot stated that while he was spraying crops, he looked into the cockpit during a turn to check the amount of solution that was remaining. He stated that when he looked up, he was too low to complete the turn and miss the trees. He went to full power and…Jul 1, 1982 · N6562 · Substantial damageNTSB MKC82DA098Accident · No injuriesFinal reportWeatherly 201A · Bronson, KSThe pilot reported that he was spraying over rolling terrain that was covered with trees. While on his last pass, he struck the top of a tree with his left wing. The aircraft became difficult to control, and the pilot elected to make a precautionary landing.…Jun 7, 1982 · N2934W · Substantial damageNTSB MKC82DA093Accident · Minor injuriesFinal reportGrumman G-164A · Red Cloud, NEThe aircraft struck the top wire of an electrical transmission line and crashed. The pilot reported that he misjudged the "wire distance" as he let down over a pond to begin a swath run. The pond was at the edge of the field that he was seeding. The pilot…Jun 1, 1982 · N5253 · DestroyedNTSB ATL82DA123Accident · No injuriesFinal reportCessna 172E · Marietta, GAThe Boeing A75N1 (stearman) pilot reported that a long final approach was flown to allow room for a twin engine aircraft to land in front of him. He continued landing, but did not see a beige colored Cessna 172 on the runway. He reported that the visibility…May 1, 1982 · N3715S · 2 aircraft · Substantial damageNTSB FTW82FRA19Accident · 1 fatalFinal reportBoeing A75 · Chapell Hill, TXDuring a pull-up from a swath run, the right wing of the aircraft struck the top of a 45 ft pecan tree. The lower right wing tip separated, and the aircraft rolled inverted and crashed.Apr 27, 1982 · N1774B · DestroyedNTSB SEA82FYM13Accident · Serious injuriesFinal reportWeatherly 201B · Kent, ORThe pilot reported that he was working off of a 1700 ft dirt strip with a rough surface and with a slight cross- wind. The elevation was about 2650 ft MSL and the temperature was approximately 70 degrees fahrenheit. The pilot initiated a takeoff with about…Apr 22, 1982 · N1262W · DestroyedNTSB FTW82FRG24Accident · Minor injuriesFinal reportBeech E18S · Charlotte, TXThe aircraft crashed during takeoff from a clearing on a ranch and then was abandoned. The aircraft landing gear struck a concrete trough for watering cattle. Drugs were found on board the aircraft.Mar 8, 1982 · N700W · Substantial damageNTSB FTW82FPA11Accident · No injuriesFinal reportBeech D18S · Dallas, TXDuring a night, ILS approach, the plane struck a powerline about two miles short of the runway after the pilot was provided a low altitude alert. The left engine lost power and was feathered. The pilot feared possible gear damage and left it extended. Unable…Feb 26, 1982 · N8517Z · Substantial damage