NTSB investigations: Allison 250-C20 series
20 cases on aircraft whose registry engine model is Allison 250-C20 series, 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
| 1986 | 1 |
|---|---|
| 1993 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 4 |
| 2006 | 1 |
| 2007 | 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 ('03020')
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 ('03020')
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 CHI07LA193Accident · No injuriesLimited investigationFinal reportHughes 369D · Comfrey, MNThe loss of engine power due to the loose pressure line during aerial application maneuvers which resulted in a hard forced landing.NTSB NYC07LA149Accident · No injuriesLimited investigationFinal reportMesserschmitt BO-105 · Isla de Vieques, PRThe mechanic's failure to secure the engine governor locking hardware, which resulted in the right engine losing power.NTSB DEN06LA080Accident · No injuriesLimited investigationFinal reportGarlick Helicopters OH- 58C · Muddy Gap, WYthe loss of engine power for reasons undetermined. Contributing to the accident was the low altitude and rough uneven terrain.NTSB MIA04LA132Accident · No injuriesLimited investigationFinal reportBell 206L · Gulf of MexicoA loss of engine power for undetermined reasons while on short final to land on an oil platform in the Gulf of Mexico, which resulted in the pilot ditching the helicopter into the water.NTSB SEA04LA181Accident · No injuriesLimited investigationFinal reportHughes 369D · Cottage Grove, ORIn-flight loss of engine power during cruise for undetermined reasons.NTSB FTW04LA197Accident · Minor injuriesLimited investigationFinal reportBell 206B · East Cameron 13The loss of engine power due to fuel exhaustion. Contributing factors were the fuel quantity gauge's improper fuel level indication, missing instrument placard, company maintenance personnel's improper maintenance records, disregard for company procedures,…NTSB FTW04GA076Accident · Minor injuriesFinal reportSchweizer 269D · San Antonio, TXThe loss of engine power due to the axial movement of the compressor rotor blades contacting the compressor vanes resulting in a subsequent compressor stall. A contributing factor was the improper assembly of the compressor section during the engine overhaul…NTSB FTW03LA216Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Kisatchie, LAA loss of engine power due to water contamination in the fuel system.NTSB SEA03LA058Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Taholah, WAThe entanglement of the fuel quantity sender float in the start pump wiring within the fuel tank as a result of the wiring not being properly secured. This rendered the fuel gauge inaccurate and the low fuel warning light inoperative which led to fuel…NTSB FTW02LA117Accident · Minor injuriesLimited investigationFinal reportBell 206B · Walnut Hill, TXThe loss of engine power as a result of the backing off of the PC air line "B" nut due to the improper installation by the company maintenance personnel. Contributing factors were the inadequate preflight by the pilot and the lack of suitable terrain for the…NTSB FTW02LA102Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Oakley, UTThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN02LA013Accident · Serious injuriesLimited investigationFinal reportBell 206B · Bryce, UTloss of engine power for reasons undetermined. Contributing factors were the low airspeed and altitude at which to perform an autorotation.NTSB CHI01LA119Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Du Quoin, ILloss of engine power for undetermined reasons, the pilot operating the helicopter outside of the height-velocity curve, and the pilot's failure to maintain control of the helicopter during the emergency landing. Factors relating to the accident were the…NTSB SEA01LA024Accident · No injuriesLimited investigationFinal reportBell 206 B3 · Lake Kachess, WAThe pilot's failure to comply with the flight manual regarding the use of an induction system deflector kit (snow baffles) while operating in snow, and the ingestion of foreign material/snow that resulted in an engine flameout while hovering. A snow baffle…NTSB LAX99LA237Accident · No injuriesLimited investigationFinal reportHiller UH-12ET · Williams, CAThe pilot's inadequate preflight planning and verification that fuel was available for the intended flight. A factor was the fuel quantity false indication.NTSB MIA99FA158Accident · 1 fatalField investigationFinal reportHughes 369E · Intercession, FLThe pilot's improper fuel management that resulted in fuel exhaustion and a total loss of engine power.NTSB SEA98LA024Accident · No injuriesLimited investigationFinal reportBell 206L · Idaho Falls, IDloss of engine power for undetermined reason(s). A factor relating to the accident included a dirt berm/ridge in the field where the pilot executed the forced landing.NTSB MIA94LA116Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mayaguez, PRLoss of engine power for undetermined reasons which resulted in a descent and ditching.NTSB LAX93LA375Accident · 2 fatalLimited investigationFinal reportBell 206B · Pacific Ocean (Pacific Ocean)a loss of engine power for undetermined reasons.NTSB LAX87DUM01Accident · No injuriesFinal reportBell UH-1B · Calipatria, CADuring the initial climb at the beginning of an aerial application flight, the pilot made a climbing 180 degree right turn in the reverse direction when the rotor RPM began to drop. The pilot continued to raise collective, lost directional control and…