NTSB investigations: Allison 250 series, WA
11 cases on aircraft whose registry engine model is Allison 250 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
| 1974 | 1 |
|---|---|
| 1976 | 2 |
| 1978 | 1 |
| 1980 | 2 |
| 1982 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2009 | 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\" = 'WA' 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 ('03014', '03019'))
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" = 'WA' 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 ('03014', '03019'))
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 WPR09CA331Accident · Minor injuriesData collectionFinal reportBell 47G-3B-2 · Ocean Shores, WAThe pilot's failure to maintain clearance from the water while maneuvering due to the pilot's diverted attention.NTSB SEA94LA149Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy UH-12L4 · Clarkston, WADisconnection of the ballast bar aft retaining pin. Factor(s) were: tail rotor blade separation and reduced aircraft control.NTSB SEA94LA029Accident · No injuriesLimited investigationFinal reportBell 47G3B2 · Toledo, WATransmission shear bolts failed causing a loss of power to the rotor system, and the pilot encountered unsuitable terrain during his autorotation attempt.NTSB SEA90LA025Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Raymond, WALoss of engine power due to fatigue failure of the impeller. The helicopter was substantially damaged as a result of a roll-over on uneven terrain.NTSB SEA82DA164Accident · No injuriesFinal reportHiller-Soloy UH-12E · Spirit Lake, WAPilot performed autorotation from 2000 feet to check RPM. At 200-300 feet when collective was added power loss occurred. Aircraft landed hard and severed tail boom. Logging support operations.NTSB SEA81DYE08Accident · No injuriesClosedHiller Acft UH-12E · Forks, WANTSB SEA80DYE32Accident · Serious injuriesClosedHiller Acft UH-12E · Forks, WANTSB SEA78FYE16Accident · No injuriesClosedHiller Acft UH-12E · Forks, WANTSB SEA76DYE65Accident · Serious injuriesClosedHiller Acft UH-12E · Humptulips, WANTSB SEA76DYG44Accident · No injuriesClosedBell 47G-3B · Palouse, WANTSB SEA74DYG50Accident · Minor injuriesClosedBell 47G3B2 · Clarkston, WA