NTSB investigations: Allison 250 SER 250HP
14 cases on aircraft whose registry engine model is Allison 250 SER 250HP, where the first occurrence was “Loss of engine power”. 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 | 3 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2006 | 2 |
Where
Latest 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\" = 350))
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" = 350))
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 SEA06LA124Accident · No injuriesLimited investigationFinal reportHughes 369D · Salt Lake City, UTA loss of rotor rpm for undetermined reasons, resulting in a hard landing on top of the commercial building over which the helicopter was working.NTSB DFW06CA142Accident · Serious injuriesData collectionFinal reportBell 47G-4A · Sheridan, ARThe pilot's inadequate fuel management, which resulted in fuel exhaustion and a subsequent loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA017Accident · Serious injuriesLimited investigationFinal reportBell 206B · S.Timbelier 187The loss of engine power for undetermined reasons.NTSB SEA02LA135Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Medford, ORPower loss during cruise flight for undetermined reasons. Factors include mountainous terrain and trees.NTSB MIA99LA107Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Opp, ALa loss of engine power due to the failure of the engine to transmission drive shaft flex coupling, resulting in an in-flight collision with a vehicle.NTSB SEA99FA018Accident · Minor injuriesField investigationFinal reportHughes 369D · Taholah, WATurbine wheel failure as the result of a low-cycle fatigue crack that initiated in a beyond-limits grinding gouge. Factors include improper maintenance by unknown parties and tree stumps that prohibited a successful emergency landing.NTSB FTW95LA032Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ruston, LAThe pilot's improper handling of the helicopter after an apparent loss of power during a practice autorotation.NTSB ANC93FA064Accident · Serious injuriesField investigationFinal reportFairchild FH-1100 · Malina Bay, AKThe installation of a bogus transmission to engine driveshaft. The failure of the company maintenance personnel to comply with the service bulletins and letters was a factor.NTSB NYC89LA126Accident · Minor injuriesLimited investigationFinal reportBell 206A · Bedminster, NJOff airport landing in unsuitable terrain due to an undetermined power loss.NTSB LAX87LA099Accident · No injuriesLimited investigationFinal reportHughes 369D · Lemon Cove, CAThe plt rprtd that while at 100 to 150 ft AGL on an apch to land, the eng lost pwr as though it had flamed out. He entered an autorotation, but was unable to reach the helipad. Subsequently, the helicopter landed in trees & was badly dmgd. Drg the…NTSB MKC85LA207Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Ashland, KSThe helicopter lost power and made a hard forced landing in a backyard. There were no leaks in the fuel system but the fuel tank was found to be empty. The owner states that even though the fuel tank was found to be empty after the accident, the fuel quantity…NTSB ATL82DLQ08Accident · Serious injuriesFinal reportBell 206B · 2nm Sw Of Lynch, KYThe pilot was on a flight to spray powerline right-of-ways with defoliant. During climb, near a 3500 foot ridgeline, the aircraft began to spin to the right. The pilot took corrective action but was not able to stop the spin. The pilot did not have sufficient…NTSB FTW82FA204Accident · 2 fatalField investigationFinal reportBell 206B · Fairfield, TXWitnesses observed the helicopter flying northbound while traveling parallel and just east of a north-south highway. Reportedly, it enter an autorotative landing approach, crossed over the highway and impacted in an open field on a westerly heading after…NTSB SEA82FA070Accident · Minor injuriesField investigationFinal reportHughes 369D · 6nm Sse Wrangel, AKThe pilot reported that the aircraft was on a reconnaissance flight to survey a proposed powerline project. He reported that during the flight, the engine flamed out and an autorotation was initiated. He maneuvered the helicopter to land in a clearance, but…