Skip to content

NTSB investigations: Pratt & Whitney R-985 series, WI

28 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.

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."eventStateOrRegion" = 'WI' 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

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\" = 'WI' 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" = 'WI' 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

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 CEN21LA333Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Baraboo, WIThe pilot’s failure to maintain clearance from the fence while on final approach.Jul 23, 2021 · N51CF · Substantial damage NTSB CEN18LA360Accident · No injuriesLimited investigationFinal reportStearman A75N1(PT17) · Kenosha, WIThe failed retaining bolt and cracked backing plate, which resulted in a shift of the brake lining to contact the brake drum and a subsequent wheel lock when the brakes were applied.Aug 31, 2018 · N64604 · Substantial damage NTSB CEN15LA399Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Hancock, WIThe in-flight failure of the left wing lower forward attach point under normal loading conditions due to corrosion and fatigue cracking in the center section hinge brackets. Contributing to the accident was the operator's inadequate maintenance and overweight…Aug 26, 2015 · N2005C · Destroyed NTSB CHI03LA274Accident · No injuriesLimited investigationFinal reportBoeing A-75 · La Crosse, WIThe total loss of engine power due to a fatigue fracture of the engine's crankshaft. A factor was the corn crop.Aug 20, 2003 · N806RB · Substantial damage NTSB CHI97LA242Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Lone Rock, WIa locked right brake which resulted in the pilot's inability to maintain direction control of the airplane during the landing roll.Jul 30, 1997 · N75939 · Substantial damage NTSB CHI96LA252Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · East Troy, WIcorrosion and fracture of the rudder control horn.Jul 21, 1996 · N58712 · Substantial damage NTSB CHI92DEP04Accident · Minor injuriesFinal reportGrumman 164A · Elkhorn, WIThe pilot-in-command's inadequate compensation for wind conditions.Aug 31, 1992 · N48635 · Destroyed NTSB CHI91DEP12Accident · No injuriesFinal reportSchweizer G-164-A · Elkhorn, WIThe pilot in command's failure to maintain adequate altitude.Aug 20, 1991 · N48635 · Substantial damage NTSB CHI90LA072Accident · No injuriesLimited investigationFinal reportBeech E18S · Oak Creek, WIImproper planning/decision by the pilot. Factors related to the accident were: the adverse weather conditions, accumulation of structural and/or induction ice, and dark night.Jan 25, 1990 · N48K · Substantial damage NTSB CHI85LA324Accident · No injuriesLimited investigationFinal reportBoeing E75 · Delavan, WIThe acft nosed over during a forced lndg after the eng quit. The plt said he ran out of fuel.Jul 30, 1985 · N5191N · Substantial damage NTSB CHI85LA327Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Fond Du Lac, WIThe plt had accurued aprx 12 hrs of flying time on the day of the accident. During the final landing the acft touched down at the rwy mid-point and bounced. The acft then struck a rwy light and veered off the rwy paved surface into soft sod. The plt attempted…Jul 27, 1985 · N5604V · Substantial damage NTSB CHI80DEP32Accident · No injuriesClosedStearman A75-N1 · City Point, WIMay 23, 1980 · N63111 · Substantial damage NTSB CHI78FEP45Accident · Minor injuriesClosedSnow S2C · Bancroft, WIJul 11, 1978 · N1638S · Destroyed NTSB CHI78FER01Accident · No injuriesClosedBeech D18S · Osceola, WIOct 30, 1977 · N273C · Substantial damage NTSB CHI76DEP13Accident · Minor injuriesClosedStearman A75N1 · Portage, WIAug 11, 1975 · N55891 · Destroyed NTSB CHI76DEP06Accident · No injuriesClosedStearman A75N1 · Alma Center, WIJul 22, 1975 · N55898 · Substantial damage NTSB CHI75AC060Accident · No injuriesClosedBeech G18S · Oshkosh, WIMar 4, 1975 · N188X · Substantial damage NTSB CHI75DEP24Accident · No injuriesClosedBoeing A75 · Lone Rock, WISep 8, 1974 · N55898 · Substantial damage NTSB CHI75FEP19Accident · 1 fatalClosedBoeing A75N1 · Plover, WISep 1, 1974 · N60334 · Destroyed NTSB CHI75DEP16Accident · No injuriesClosedBoeing A75N1 · Friendship, WIAug 17, 1974 · N61836 · Destroyed NTSB CHI74FEP49Accident · No injuriesClosedBoeing A75N1 · Lone Rock, WIJun 13, 1974 · N111Q · Substantial damage NTSB CHI71FDJ03Accident · Minor injuriesClosedBeech C-18 · Waukesha, WIJul 10, 1970 · N2391C · Substantial damage NTSB CHI70A0023Accident · 1 fatalClosedBeech D18S · Madison, WINov 1, 1969 · N106H · Destroyed NTSB MKC70A0018Accident · No injuriesClosedBeech E18S · Ashland, WIOct 12, 1969 · N3785B · Substantial damage NTSB CHI68D0276Accident · No injuriesClosedLockheed 12A · Montello, WIAug 10, 1967 · N4001 · Substantial damage NTSB CHI67A0101Accident · No injuriesClosedBeech C-45H · Janesville, WIMar 3, 1967 · N9966Z · Substantial damage NTSB CHI67F0189Accident · No injuriesClosedBeech D18S · Janesville, WISep 8, 1966 · N156NA · Substantial damage NTSB UNK64X3494Accident · No injuriesClosedBoeing A75N1 · Delavan, WIAug 20, 1964 · N63695 · Destroyed