NTSB investigations: Allison 250 series, OR

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19782026

NTSB investigations: Allison 250 series, OR per year, 1978–2026: 14 cases
1978	1
1979	2
1980	1
1981	1
1982	1
1986	1
1993	2
2004	1
2010	1
2012	1
2014	1
2020	1

Where

Open the map

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" = 'OR' 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

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

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 WPR20LA224Accident · 1 fatalClass 3 · LimitedFinal reportHiller UH 12D · Mehama, ORAn in-flight separation of a tail rotor blade due to fatigue cracking and overstress, which resulted in a loss of directional control and subsequent ground impact.Jul 17, 2020 · N2297W · Destroyed NTSB WPR14CA280Accident · No injuriesData collectionFinal reportBell 47G · Gaston, ORThe pilot's inability to maintain control of the helicopter as a result of a hydraulic hose becoming entangled around the right skid.Jul 3, 2014 · N684PC · Substantial damage NTSB WPR12LA347Accident · Minor injuriesLimited investigationFinal reportHiller UH-12D · Deer Island, ORA loss of helicopter control while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Aug 7, 2012 · N47035 · Substantial damage NTSB WPR10CA470Accident · No injuriesData collectionFinal reportBell 47G · Gaston, ORThe pilot's failure to maintain tail rotor clearance while landing on a transport trailer positioned on an uneven surface.Sep 26, 2010 · N7860S · Substantial damage NTSB SEA05FA004Accident · No injuriesField investigationFinal reportMaule MT-7-420 · Bend, ORLoss of engine power during takeoff climb for undetermined reasons. Rough terrain was a factor.Oct 8, 2004 · N186SB · Substantial damage NTSB SEA94LA039Accident · No injuriesLimited investigationFinal reportHiller-Soloy UH-12D · Sublimity, ORFuel exhaustion due to inadequate preflight and refueling not acomplished.Dec 7, 1993 · N2297W · Substantial damage NTSB SEA94LA037Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Sublimity, ORThe pilot's failure to maintain clearance from unmarked transmission wires. Factors include the pilot's inadequate visual lookout, and unmarked wires in the area of operation.Nov 26, 1993 · N59366 · Substantial damage NTSB SEA86FA039Accident · 1 fatalField investigationFinal reportHiller-Soloy UH-12E · Horton, ORThe fork connecting the rotorcraft's blue blade to the main rotor hub separated after a long term fatigue crack had spread through more than 60% of the fork circumference. The operator failed to carry out the appropriate inspection of the fork unit as…Jan 16, 1986 · N40290 · Destroyed NTSB SEA82FYM11Accident · Minor injuriesFinal reportHiller UH-12E · Mount Angle, ORThe aircraft was being used on an external load operation. On his fourth load, the pilot was to transport a 1190 lb electric pump and fan from the back of a pickup truck. While preparing to lift the load, the pilot was not satisfied with its position. He…Mar 8, 1982 · N59366 · Destroyed NTSB SEA82DYM07Accident · No injuriesClosedHiller Acft UH-12E · Nashville, ORDec 3, 1981 · N161HA · Substantial damage NTSB SEA80DYM55Accident · No injuriesClosedHiller Acft UH-12E · Tillamook, ORAug 19, 1980 · N59366 · Substantial damage NTSB SEA79FYM32Accident · No injuriesClosedHiller Acft UH-12E · Independence, ORMay 11, 1979 · N161HA · Substantial damage NTSB SEA79DYM23Accident · No injuriesClosedHiller Acft UH-12E · Friend, ORMar 24, 1979 · N175HA · Substantial damage NTSB SEA78FYK06Accident · 1 fatalClosedHiller UH-12E · Reedsport, ORJan 20, 1978 · N65149 · Minor damage