NTSB investigations: Pratt & Whitney R-985 series, IA
15 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 per year
| 1969 | 1 |
|---|---|
| 1970 | 1 |
| 1974 | 1 |
| 1980 | 1 |
| 1983 | 1 |
| 1990 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 1 |
| 2011 | 2 |
| 2021 | 1 |
| 2022 | 1 |
Where
Open the mapLatest 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\" = 'IA' 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" = 'IA' 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 CEN22LA354Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-301 · Lamoni, IAA loss of airplane performance for reasons that could not be determined.NTSB CEN21LA329Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Amana, IAThe loss of engine power for reasons that could not be determined.NTSB CEN11CA565Accident · No injuriesData collectionFinal reportWeatherly 201C · Bronson, IAThe pilot's failure to maintain clearance from terrain while maneuvering during an aerial application flight.NTSB CEN11CA497Accident · No injuriesData collectionFinal reportGrumman Schweizer G-164A · North English, IAThe pilot's improper flare which resulted in a hard landing.NTSB CHI07CA210Accident · No injuriesData collectionFinal reportBoeing A-75N1 · Oelwein, IAThe pilot's failure to maintain directional control of the airplane during a landing roll. Factors associated with the accident was the gusty crosswind condition and the corn crop.NTSB CHI06CA225Accident · No injuriesData collectionFinal reportWeatherly 620B · Sioux Center, IAThe pilot's mismanagement of the fuel system which resulted in the loss of engine power due to fuel starvation and his failure to maintain aircraft control during the subsequent forced landing. A factor to the accident was the soybean crop.NTSB CHI05LA214Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Marshalltown, IAThe loss of engine power for an undetermined reason. A factor was the corn crop.NTSB CHI05LA213Accident · Serious injuriesLimited investigationFinal reportWeatherly 620-B · Osage, IAThe partial loss of engine power for an undetermined reason. Contributing factors were the wires and the trees.NTSB CHI04LA220Accident · 1 fatalLimited investigationFinal reportAllied Ag Cat Productions G-164B · Moville, IAThe pilot's inadequate in-flight planning/decision by his failure to maintain obstacle clearance. Contributing factors were low altitude flying and the tree.NTSB CHI90LA206Accident · No injuriesLimited investigationFinal reportBeech D17S · Oelwein, IAInadequate visual outlook by the pilot in command.NTSB MKC83IA152Incident · No injuriesIncident investigationFinal reportBeech E18S · Cedar Rapids, IAThe tailwheel failed to extend fully due to a lack of lubrication. The acft was landed normally and the tailwheel collapsed.NTSB MKC80DA032Accident · No injuriesClosedBeech 18S · Cedar Rapids, IANTSB MKC75DCD24Accident · No injuriesClosedLockheed 12A · Osage, IANTSB MKC71AK016Accident · Serious injuriesClosedCessna 337C · Keokuk, IANTSB MKC70D0143Accident · No injuriesClosedBoeing A75 · Hawarden, IA