NTSB investigations: Allison 250 SER 250HP
12 cases on aircraft whose registry engine model is Allison 250 SER 250HP, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1996 | 2 |
| 2003 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03002', '03003')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351))
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 ('03002', '03003')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351))
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 FTW04FA029Accident · 1 fatalField investigationFinal reportBell 407 · High Island 573The loss of engine power due to the failure of the 3rd stage turbine wheel and subsequent catastrophic failure of the turbine assembly.NTSB LAX97LA039Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Hana, HIsubsequent failure of the spur adapter gearshaft (SAG), after 'retaining ring to compressor impeller machining' occurred and allowed the SAG to shift aft. The mechanism which induced the ring to impeller machining was not determined. Mountainous terrain in…NTSB MIA96LA180Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pigeon Forge, TNfatigue failure of the engine PC line, induced by damage from improper installation, which resulted in a loss of engine power and an autorotative landing to unsuitable terrain.NTSB FTW93LA228Accident · No injuriesLimited investigationFinal reportBell 206B · Pearland, TXPilot's failure to maintain proper rotor RPM, the delayed flare, and improper touchdown. Factors were total failure of the power turbine due to oil starvation to the #8 bearing assembly.NTSB FTW90LA096Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · E. Island Blk15The loss of continuity in the compressor section of the engine due to a fatique failure of the spur adapter gear shaft.NTSB SEA88FA050Accident · Serious injuriesField investigationFinal reportBell 206A · Roseburg, ORWhile hovering at 200' AGL, the eng lost power & the plt entered an autorotation. He maneuvered to avoid trees & landed amid tree stumps in a logging clear cut area. An investigation revealed the 1st stage turbine wheel had failed. The wheel exited the eng &…NTSB BFO87FA057Accident · 3 fatalField investigationFinal reportBell 206B · Washington, DCThe helicopter was on a LCL photography (sight-seeing) flt. While hovering at aprx 200' abv the potomac river, the eng lost pwr. The plt initiated an autorotation & deployed the emerg floats. Subsequently, the helicopter impacted in the river & rolled ovr,…NTSB FTW84LA414Accident · No injuriesLimited investigationFinal reportBell 206L-1 · West Delta 105While in cruise flt, total pwr loss was experienced. Plt setup autorotative water landing, deployed emergency floats. Right float was not fully inflated by water touchdown, acft rolled right to inverted position. Eng teardown revealed carbon buildup between…NTSB NYC84FA009Accident · 1 fatalField investigationFinal reportBell 206B III · Hudson, NHThe plt was on a flt to pick up film for a tv station. While en route, he made a mayday call to the manchester control tower. According to witnesses, the acft was proceeding in a northerly direction at about 700 to 1000 ft AGL when they heard a 'muffled pop.'…NTSB SEA83LA205Accident · Minor injuriesLimited investigationFinal reportHughes 369B · Cougar, WAThe aircraft collided with trees and terrain during a forced landing attempt following an in-flight power loss. Subsequent engine teardown revealed failure of several components.NTSB ANC83LA138Accident · No injuriesLimited investigationFinal reportHughes 369D · Mcgrath, AKThe plt stated that he was flying straight & level at aprx 700 ft AGL, when the eng-out light illuminated. He began an autorotation to a ridgeline. During the landing, the main rotor blades contacted the tail boom & severed it from the main fuselage. An…NTSB SEA82DA137Accident · No injuriesFinal reportHughes 369D · Shelton, WADuring a sight seeing flight the pilot smelled a burning odor and prepared to make a precautionary off-airport landing. Shortly thereafter, engine RPM decayed and an autorotative landing was effected on a dirt road. On touchdown, the main rotor blades flexed…