Skip to content

NTSB investigations: Pratt & Whitney WJR-B-S-T

24 cases on aircraft whose registry engine model is Pratt & Whitney WJR-B-S-T. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 ('52007')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('52007'))
  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 ('52007'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 GAA15CA145Accident · No injuriesData collectionFinal reportBeech D17S · Idaho Falls, IDWhile taxiing as a flight of two, the pilot of the blue Beechcraft became distracted and impacted the red Beechcraft which had stopped.Jun 28, 2015 · N114H · 2 aircraft · Substantial damage NTSB SEA00LA036Accident · No injuriesLimited investigationFinal reportBeech D18S · Everett, WALoss of aircraft control during initial climb for undetermined reasons.Jan 11, 2000 · N1827M · Substantial damage NTSB ATL87LA144Accident · No injuriesLimited investigationFinal reportSpartan 7W · Sumter, SCThe plt reported that the airplane began to turn to the left after ldg when the tailwheel touched down; subsequent efforts to counteract the turn were not successful. The airplane ran off the side of the rwy and hit a depression in the terrain, collapsing the…Apr 25, 1987 · N13PH · Substantial damage NTSB FTW83LA219Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Iowa, LAThe acft nosed over during an off arpt landing. The plt stated that he was landing to check his aerial application load and talk to a farmer. During touchdown the main landing gear dug into the soft ground and the acft nosed over.May 4, 1983 · N65361 · Substantial damage NTSB ANC78FAA07Accident · No injuriesClosedHoward,Dee DGA15P · Fairbanks, AKApr 19, 1978 · N9125H · Substantial damage NTSB FTW76FRD10Accident · No injuriesClosedBoeing A75 · Lake Charles, LASep 29, 1975 · N4912N · Substantial damage NTSB FTW75OPG89Accident · No injuriesClosedBeech D18S · Jalisco, MexicoMay 3, 1975 · N64R · Destroyed NTSB FTW74DRD49Accident · No injuriesClosedBoeing A75N1 · Edgerly, LAJun 12, 1974 · N65361 · Substantial damage NTSB CHI74FEG06Accident · No injuriesClosedHoward DGA-15 · Amelia, OHSep 3, 1973 · N5450N · Substantial damage NTSB FTW72FPM04Accident · No injuriesClosedBeech D18S · Jenks, OKAug 9, 1971 · N80385 · Substantial damage NTSB FTW71DPG05Accident · No injuriesClosedBoeing E75N1 · Wabash, ARJul 29, 1970 · N75676 · Substantial damage NTSB IAD70A0036Accident · No injuriesClosedBeech D18S · Friendship Apt, MDDec 31, 1969 · N80385 · Substantial damage NTSB MIA70F0088Accident · 1 fatalClosedBoeing A75N1 · Eufaula, ALJul 25, 1969 · N49982 · Destroyed NTSB FTW70F0055Accident · Serious injuriesClosedBoeing E75 · Ganado, TXJun 17, 1969 · N5328N · Substantial damage NTSB FTW70D0067Accident · No injuriesClosedBoeing B75N1 · Edna, TXJun 7, 1969 · N75261 · Substantial damage NTSB FTW67D0651Accident · No injuriesClosedBoeing B75N-1 · Crowley, LAJun 9, 1967 · N75261 · Substantial damage NTSB LAX67F0453Accident · No injuriesClosedHoward DGA-15 · Phoenix, AZMay 16, 1967 · N22424 · Substantial damage NTSB FTW67F0387Accident · Minor injuriesClosedBoeing A75N1 · Bay City, TXMar 31, 1966 · N4894N · Substantial damage NTSB FTW66F0069Accident · Minor injuriesClosedBoeing D-75N1 · Snow Lake, ARApr 2, 1965 · N53544 · Substantial damage NTSB UNK64X3696Accident · No injuriesClosedBoeing B75N1 · W Helena, ARAug 31, 1964 · N57943 · Substantial damage NTSB UNK64X2084Accident · No injuriesClosedNavy N3N · Gilbert, AZJun 3, 1964 · N45217 · Substantial damage NTSB UNK64X1422Accident · Minor injuriesClosedBoeing A75N1 · Gueydan, LAApr 23, 1964 · N49717 · Substantial damage NTSB UNK64X1412Accident · No injuriesClosedStearman A75N1 · Magnet, TXApr 22, 1964 · N4894N · Substantial damage NTSB UNK64X0888Accident · Minor injuriesClosedBoeing D75 · Kilgore, TXMar 11, 1964 · N17674 · Substantial damage