OpenAirDocs.org

NTSB investigations: Pratt & Whitney R1340 series, AR

7 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

19842026

Where

Open the map

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 c.\"eventStateOrRegion\" = 'AR' 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')
      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 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.Jul 23, 2007 · N8402K · Substantial damageNTSB 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.Jun 4, 1996 · N3646X · Substantial damageNTSB FTW93LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stuttgart, ARPilot's failure to maintain clearance from the electrical wires.May 26, 1993 · N8405K · DestroyedNTSB MKC88LA126Accident · No injuriesLimited investigationFinal reportRockwell S2R · England, ARThe plt said he had been flying under power lines during an aerial application operation, and while performing his downwind pass, an updraft caused him to collide with the bottom wires. He lost control of the aircraft and collided with the terrain.Jul 15, 1988 · N4186X · Substantial damageNTSB MKC88LA108Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Wynne, ARFollowing the takeoff from a private strip near Wynne, Arkansas, the pilot reported that he failed to establish and maintain an adequate angle of climb with the heavily loaded condition of the aircraft. The aircraft impacted trees in the flight path, then…Jun 6, 1988 · N9695 · Substantial damageNTSB MKC87LA050Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A-600 · Hazen, ARThe pilot stated that he had flown six loads of wheat seeds and was returning to a private airstrip for another load when he ran out of daylight while on final approach to a landing. During the time he was considering the option of a rejected landing and a…Feb 14, 1987 · N5495 · DestroyedNTSB MKC84LA166Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Pocahontas, ARThe plt said he was making a cleanup swath & encountered spray from the previous swath run. The spray contains a dye which covered the windshield & obscured the plt's vision. The plt said he pulled up at the end of the field but failed to clear the trees.…Jun 10, 1984 · N8896Q · Substantial damage