NTSB investigations: Allison 250 SER 400HP
14 cases on aircraft whose registry engine model is Allison 250 SER 400HP, where the first occurrence was “Airframe/component/system failure/malfunction”. 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 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 2 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2000 | 2 |
| 2005 | 2 |
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 ('03013', '03012')
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\" = 130))
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 ('03013', '03012')
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" = 130))
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 LAX06IA011Incident · No injuriesIncident investigationFinal reportHughes 369D · Kahului, HIThe fatigue cracking and failure of the tail rotor control rod during cruise flight, which resulted in a hard landing during the precautionary landing.NTSB DEN05TA119Accident · Serious injuriesFinal reportHughes 369HS · Albuquerque, NMthe bullet(s), which severed the helicopter's left tail rotor pedal. Contributing factors were the severed anti-torque pedal and the unsuitable terrain for landing.NTSB DEN01LA012Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Mesa Verde, COThe manufacturer's use of improper materials, and inadequate quality control of the tail rotor blades during the manufacturing process, which resulted in fatigue failure of the blade.NTSB LAX00LA103Accident · No injuriesLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)An unknown mechanical malfunction that resulted in a precautionary landing at sea and the subsequent sinking of the helicopter by an ocean swell.NTSB ANC98TA125Accident · No injuriesFinal reportBell 206B II · Chickaloon, AKA fracture of the main rotor drag pin assembly.NTSB SEA96LA025Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Scotts Mills, ORThe pilot's failure to maintain adequate clearance from the ground.NTSB ANC92FA159Accident · Serious injuriesField investigationFinal reportHughes 369D · Nunavaugaluk Lk, AKThe separation of the tail rotor abrasion strip and the subsequent total loss of the tail rotor. Factors contributing to the accident were: insufficient manufacturer's maintenance design changes, inadequate aircraft equipment design by the manufacturer and…NTSB LAX91LA172Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Papua, Papua New GuineaThe loss of control of the helicopter due to a restriction of the cyclic control system.NTSB NYC90FA029Accident · 2 fatalField investigationFinal reportHughes 369HS · North Adams, MAFailure of the pilot-in-command (PIC) to assure proper rotor RPM and proper operation of the flight controls during an approach in gusty wind conditions. A factor related to the accident was: the pic's lack of experience in the type of operation.NTSB FTW87FA198Accident · No injuriesField investigationFinal reportBell 206B · Pledger, TXWhile cruising at 900' AGL, the plt noted a hvy shudder flwd by a grinding noise, loud 'bang' & a low rotor RPM signal. He made an autorotation to a road, but drg touchdown, the main rotor blades flexed dwn & severed the tail boom. An exam revealed the main…NTSB MKC87IA070Incident · No injuriesIncident investigationFinal reportAgusta A109 · Lincoln, NEThe PIC stated that he was ground taxiing the helo to the ramp area at duncan aviation to shutdown for refueling. During the taxi, the PIC heard a loud 'bang' eminating fm the rear of the helo. The PIC lowered collective pitch and no further noise was heard…NTSB SEA85LA053Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Taholah, WAThe acft had lifted off during an external load operation when the plt felt a 'vibration/shudder'. The right skid contacted the ground and the helicopter rolled over during an attempt to maneuver the helicopter away from ground personnel. Inspection revealed…NTSB LAX84LA314Accident · No injuriesLimited investigationFinal reportHughes 369D · Honolulu, HIThe helicopter experienced a tail rotor failure shortly after departing the airport on a VFR local sling loading flt. The plt stated that, 'at approx 500 ft asl on climb out experienced sudden, severe vibration. Made a 180 degree turn to return to airport &…NTSB FTW82DA323Accident · Serious injuriesFinal reportBell 206B · Grand Isle, LAThe pilot was approaching an offshore platform for landing at about 100 ft AGL when he felt the helicopter shudder. He also heard an engine-out horn and a low-rotor-rpm warning. He turned away from the platform, popped the emergency floats and initiated an…