NTSB investigations: Allison 250 SER 400HP, HI
15 cases on aircraft whose registry engine model is Allison 250 SER 400HP. 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
| 1972 | 1 |
|---|---|
| 1976 | 1 |
| 1978 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 2 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 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.\"eventStateOrRegion\" = 'HI' AND c.\"eventCountry\" = 'USA'
AND 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'))
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."eventStateOrRegion" = 'HI' AND c."eventCountry" = 'USA'
AND 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'))
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 LAX04FA329Accident · 5 fatalClass 1 · FieldFinal reportBell 206B · Kalaheo, HIThe pilot's decision to continue flight under visual flight rules into an area of turbulent, reduced visibility weather conditions, which resulted in the pilot's spatial disorientation and loss of control of the helicopter. Contributing to this accident was…NTSB LAX03FA241Accident · 5 fatalField investigationFinal reportBell 206B · Waialeale,Kauai, HIThe pilot's failure to maintain adequate terrain clearance/altitude while descending over mountainous terrain, and his continued flight into adverse weather. Factors contributing to the accident were clouds and a low ceiling.NTSB LAX96LA009Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Hana, HIthe loss of engine power due to inadequate maintenance inspection of the fuel system which permitted air to enter the engine fuel supply. A factor in the accident was the pilot's improper execution of the autorotation landing.NTSB LAX91LA198Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Keanae, HIThe total failure in fatigue of the helicopter's spur adapter gearshaft. A contributing factor was related to the lack of a suitable emergency landing site.NTSB LAX90LA162Accident · No injuriesLimited investigationFinal reportHughes 369C · Kahului, HIThe pilots failure to ensure that adequate room existed to position the helicopter on the landing platform. Contributing to the accident was the failure of ground personnel to ensure that hazards to the landing helicopter were clear of the landing area.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 LAX87LA161Accident · 1 fatalLimited investigationFinal reportBell 206B · Kona, HIThe pilot picked up two of the passengers at a resort hotel and then flew to kailua-Kona airport (koa). After hot refueling the helicopter with the two passengers on board, two more passengers boarded the helicopter and then the flight departed koa. When the…NTSB LAX85FA217Accident · Minor injuriesField investigationFinal reportBell 206-L1 · Kailua/Kona, HIA revenue sight-seeing helicopter flight operating under 14 CFR 91 collided with lava rock while attempting a forced landing on the summit of muana loa volcano after a partial loss of power. The pilot stated that while in a shallow downwind turn at aprx 200…NTSB LAX85LA116Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Makakilo, HIOn an air taxi flt, after landing at a prearranged site the plt signaled to his 3 pax to board the helicopter. As the pax attempted to board from the right side of the acft, the rotor blades went out of track/phase. The acft began uncontrollable bouncing up…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 OAK78FJA08Accident · Minor injuriesClosedBell 206B · Mauna Kea, HINTSB OAK76FJA25Accident · Minor injuriesClosedHughes 369 · Haena Kauai, HINTSB OAK73FJA09Accident · No injuriesClosedBell 206A · Kaimuki, HI