NTSB investigations: Allison 250 SER 400HP
21 cases on aircraft whose registry engine model is Allison 250 SER 400HP, where the first occurrence was “Loss of control - in flight”. 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
| 1985 | 1 |
|---|---|
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 1 |
| 1990 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 2001 | 2 |
| 2003 | 2 |
| 2004 | 2 |
| 2006 | 1 |
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 ('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\" = 250))
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" = 250))
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 NYC06LA062Accident · Serious injuriesLimited investigationFinal reportBell 206B · Big Creek, KYThe pilot's inadvertent settling with power during a descent. Contributing to the accident was mechanical turbulence in the lee of an obstruction in windy conditions.NTSB DEN04LA130Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Atlantic City, WYthe pilot's inability to maintain aircraft control, improper in-flight planning and decision making, and failure to compensate for wind conditions, resulting in collision with terrain. Contributing factors were the intentional low-level maneuver, and the wind…NTSB SEA04LA090Accident · No injuriesLimited investigationFinal reportBell 206B · Auburn, WALoss of control for undetermined reasons.NTSB NYC04LA039Accident · Minor injuriesLimited investigationFinal reportBell 206B · Cranston, RIThe pilot's inadvertent encounter with loss of tail rotor effectiveness. A factor was the wind change.NTSB LAX03CA279Accident · No injuriesData collectionFinal reportBell 206B · Long Beach, CAthe pilot's inadequate remedial action in response to a loss of tail rotor effectiveness.NTSB FTW01LA172Accident · Serious injuriesLimited investigationFinal reportBell 206-L1 · Wc 173the pilot's failure to maintain yaw control of the helicopter during approach.NTSB IAD01FA089Accident · 2 fatalField investigationFinal reportBell 206B · Baltimore, MDThe pilot's improper decision to maneuver in an environment conducive to a loss of tail rotor effectiveness, and his inadequate recovery from the resultant unanticipated right yaw.NTSB FTW97LA364Accident · Serious injuriesLimited investigationFinal reportBell 206B2 · Anahuac, TXthe pilot's inability to maintain control of the helicopter after encountering a dynamic rollover due to entanglement of the external load cable with the left landing gear skid.NTSB LAX97LA030Accident · Minor injuriesLimited investigationFinal reportBell 206B · Supai, AZimproper routing of the external cargo hoist cable (over helicopter skid), which resulted in lateral imbalance and roll-over of the helicopter, as weight on the cable became effective.NTSB NYC96LA167Accident · No injuriesLimited investigationFinal reportBell 206B · Starks, MEthe pilot's improper decision to operate at slow airspeed, and close to the critical relative wind azimuth area in gusty, variable winds, which resulted in an inadvertent loss of tail rotor effectiveness. The gusty crosswind and lack of a suitable terrain for…NTSB LAX96FA076Accident · 1 fatalField investigationFinal reportHughes 369D · Feather Falls, CAthe pilot's failure to jettison his external load after it came in contact with trees and terrain. The pilot's failure to maintain altitude/clearance above trees and hilly terrain was a related factor.NTSB ATL93FA127Accident · 1 fatalField investigationFinal reportHughes 369HS · Talladega, ALThe pilot's poor in-flight decision to land downwind in a confined area that was surrounded by high obstructions, and his failure to properly compensate for the tailwind condition. A factor related to the accident was: the pilot's lack of total experience in…NTSB LAX93LA258Accident · No injuriesLimited investigationFinal reportBell 206B3 · Stoneyford, CAthe pilot's inadequate compensation for the existing wind conditions during a hover operation. A factor in the accident was the high density altitude and the gusting, variable wind conditions.NTSB FTW90LA172Accident · Minor injuriesLimited investigationFinal reportBell B206BIII · Cameron, LAThe pilot's failure to jettison the external load.NTSB LAX88LA203Accident · Minor injuriesLimited investigationFinal reportBell 206B · Honolulu, HIDuring a sightseeing flt, just after take off, the helicopter began to spin to the right, the plt tried to correct the situation by applying left rudder. The helicopter continued to spin. The plt reduced the throttle and adjusted the collective. The spin…NTSB LAX88LA059Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Lihue, Kauai, HIPilot failure to maintain adequate main rotor RPM.NTSB LAX87LA179Accident · Minor injuriesLimited investigationFinal reportBell 206B-II · Yucaipa, CAA Bell 206B went out of control and crashed while lndg at a 5,720 ft high helipad. The plt indicated that he terminated the aprch at a 8-10 ft hover and began to spin to the right with full left pedal applied. After 1 1/2 to 2 turns the plt atmptd to fly out…NTSB FTW86LA130Accident · Serious injuriesLimited investigationFinal reportBell 206B · Conroe, TXThe pilot reported that he lost tail rotor control during the transition part of the takeoff. As the helicopter rotated to the right, the pilot reduced power and pulled in collective before impact. Examination of the tail rotor showed no evidence of any tail…NTSB LAX86FJA02Accident · 1 fatalFinal reportBell 206B · Pacific Ocean (Pacific Ocean)The plt was attempting to take off from the deck of a tuna boat when it contacted the side of the boat and sank in the Ocean. Post accident inspection revealed one of two nose tiedown straps had not been removed from the helicopter prior to the takeoff. The…NTSB FTW86LA041Accident · Minor injuriesLimited investigationFinal reportHughes 369D · New Boston, TXThe pilot experienced a tail rotor drive shaft flexible coupling failure when he pulled collective pitch to come to a hover before landing. The helicopter entered an uncontrollable right spin. During his haste to get the helicopter on the ground the pilot…NTSB NYC85FA245Accident · 1 fatalField investigationFinal reportBell 206B · Chalkhill, PAThe helicopter was being used on an external load operation with a 100 ft cable attached. When a 618 lb load was ready to be moved, the plt started the eng, lifted off & moved the helicopter to a hover over the load. The loaders hooked the load to the cable &…