NTSB investigations: Allison 250 SER 400HP
231 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, newest first
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'))
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'))
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 FTW93LA090Accident · Minor injuriesLimited investigationFinal reportBell 206B · Oklahoma City, OKThe passengers inadvertent control interference. A factor was the pilot's inadequate supervision of the passengerNTSB 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 ANC92LA090Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-500D · Polk Inlet, AKThe pilot's failure to follow proper procedure and the company's inadequate procedures and directives. A factor was the uneven terrain.NTSB FTW91LA121Accident · No injuriesLimited investigationFinal reportBell 206B · Freeport, TXThe pilot's failure to maintain sufficient rotor RPM during the autorotation. Factors were the fuel exhaustion induced power loss due to the pilot's improper pre-flight inspection.NTSB LAX91LA205Accident · Minor injuriesLimited investigationFinal reportBell 206 · Searchlight, NVCannot be determined in that the helicopter was stolen and the certainty of the resulting damage to the helicopter may have been intentional or accidental.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 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 BFO91LA036Accident · No injuriesLimited investigationFinal reportHughes 369HS · Columbia, MDThe pilot's inadequate visual lookout, which resulted in his failure to see-and-avoid the obstruction (fence post).NTSB FTW90GA185Accident · No injuriesFinal reportHughes 369HS · New Orleans, LAThe pilot's failure to maintain rotor RPM. A factor in the accident was the lose of engine power due to fuel starvation.NTSB FTW90LA172Accident · Minor injuriesLimited investigationFinal reportBell B206BIII · Cameron, LAThe pilot's failure to jettison the external load.NTSB NYC90LA189Accident · Serious injuriesLimited investigationFinal reportBell 206 · Athens, OHThe pilot's failure to visually acquire and maintain clearance from the powerline(s). Contributing to the accident was the adverse weather conditions.NTSB SEA90LA081Accident · 1 fatalLimited investigationFinal reportHughes 369D · Kelso, WAFailure of the pilot to keep the external load clear of obstacles (trees). Factors related to the accident were: failure of the pilot and ground crewman to follow safety procedures, and the proximity of the trees.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 LAX90TL#03Accident · Minor injuriesClass 3Final reportBell 206B · La Verne, CANTSB FTW90LA095Accident · No injuriesLimited investigationFinal reportHughes 369HS · Junction, TXThe pilot in command's inadequate execution of the autorotation following a engine failure which resulted from his failure to refuel the aircraft with the proper grade of fuel when he ran short during the flight.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 FTW89LA150Accident · No injuriesLimited investigationFinal reportBell 206B · Oak Grove, LAPilot's improper emergency procedures and flare that led to a hard landing and roll over. Factors in the accident were the pilot's decision to initiate an autorotation following an undetermined event and failure to maintain directional control during the…NTSB NYC89LA171Accident · No injuriesLimited investigationFinal reportHughes 369HS · Niagara Falls, NYFailure of the pilot to see and avoid the cables.NTSB FTW89FA075Accident · No injuriesField investigationFinal reportBell 206B · West CameronInadequate maintenance/inspection of the aircraft fuel system by company maintenance personnel and fuel contamination, which resulted in a partial loss of engine power. Related factors were: a binding (stuck) fuel filter cap bypass valve and partial failure…NTSB DEN89FA101Accident · No injuriesField investigationFinal reportBell 206B-III · Park City, UTAn encounter with strong down-slope winds and gusts during a critiacal phase of flight which caused power required to exceed power available. Contributing factors to the accident was the downhill terrain and the downdraft conditions.NTSB ATL89FA112Accident · Serious injuriesField investigationFinal reportBell 206B · Atlanta, GAFatigue failure of the engine spur adapter gearshaft in an area where there was a lack of lubrication (oil starvation) due to a partially blocked oil delivery tube. Contributing factors were: inattentive maintenance or servicing of the aircraft by unknown…NTSB DEN89LA059Accident · No injuriesLimited investigationFinal reportBell 206B III · Park City, UTThe selection of an unsuitable landing site by the pilot, resulting in tail rotor contact with the terrain and shearing of the tail rotor driveshaft.NTSB MIA89LA024Accident · Minor injuriesLimited investigationFinal reportBell 206L · St. ThomasThe plt autorotated the helicopter into the water after a loss of power while transitioning from fwd flight to a hover. While landing with the emergency floats armed, he attempted to deploy the floats but was unable. The plt & pax evacuated. The helicopter…NTSB FTW88LA153Accident · No injuriesLimited investigationFinal reportBell 206B · Pearland, TXThe helicopter was at 300 feet AGL, making an approach after a maintenance test flight, when the engine overtemped and engine power was lost. During the autorotation landing, the helicopter touched down hard. The acft eng began to decelerate prior to…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 SEA88LA016Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Turner, ORWhile on a short cross country flight the pilot encountered a rain storm and low clouds. The pilot made a 180 degree turn and then elected to make a precautionary landing in a field. Although the pilot visually inspected the area prior to landing, he did not…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 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 SEA87LA079Accident · No injuriesLimited investigationFinal reportHughes 369HS · Yakima, WASix miles from the airport, at cruise, the engine ceased operating due to fuel exhaustion. The plt had noticed the low fuel warning light on 10 minutes prior to the engine failure but elected to continue his flight. Autorotation was made from 1,000 feet AGL…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 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 SEA87LA059Accident · No injuriesLimited investigationFinal reportBell 206B-III · Dayton, WAPlt lifted off with fertilizer bucket on 3-FT external hook. As fwd motion commenced, acft settled slightly, dragging bucket on ground and tipping it over. Plt attempted to recover by backing up, but skid caught on bucket, causing loss of control.NTSB FTW87LA016Accident · Minor injuriesLimited investigationFinal reportBell 206L · Galveston, TXThe plt was attempting to hover in a tailwind of 35 KTS which exceeded the acft manufacturers performance limitiations for operations in allowable relative wind. The plt lost control of the acft on lift-off. The acft rolled over and came to rest on its right…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 DEN86LA151Accident · Minor injuriesLimited investigationFinal reportBell 206B · Portal, NDThe plt reported that the acft hit wires at the end of a swath run. The pitch change link broke when the main rotor contacted the wires and the plt attempted to land. After touchdown, the helicopter rolled onto its side.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 &…NTSB SEA85LA214Accident · Minor injuriesLimited investigationFinal reportBell 206BII · Atlanta, IDA loss of pwr occurred shortly before touchdown. The left skid struck a rock during touchdown causing the acft to roll onto its right side. Twenty-five flt hrs prior to this flt an identical situation occurred and a loose air line to the fuel control was…NTSB CHI85LA303Accident · No injuriesLimited investigationFinal reportBell 206BII · Farmington, MNDuring maneuvering to ld in an uncultivated fld the tail rotor struck a fence post,from a dismantled fence,that was concealed by high weeds. One tail rotor blade was separated,the pilot lost control,and on touchdown the helicopter rolled over.NTSB ATL85FA170Accident · 2 fatalField investigationFinal reportBell 206L · Duluth, GAAfter loading a seriously burned patient in the helicopter, the plt started the eng & lifted off from the hospital parking lot. Immediately after lift-off, he started forward translational flt. About 65 ft from the lift-off point, an advancing main rotor…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 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 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 LAX85FA101Accident · Minor injuriesField investigationFinal reportBell 206B · Trimmer, CAThe plt stated the helicopter lost pwr during cruise when he attempted to add pwr to climb. He stated that N2 decreased along with the activation of visual and audio engine out warnings. An autorotation was performed to a road, however, the helicopter slid…NTSB LAX84LA488Accident · Serious injuriesLimited investigationFinal reportBell 206B · Paso Robles, CAPlt stated that after receiving a special VFR clearence he took off to spray a nearby field. He continued to state that he 'made a couple of circuits over the field, observed the telephone wires and began spraying. After performing 2 or 3 passes I hit some…NTSB FTW84LA378Accident · Minor injuriesLimited investigationFinal reportBell 206B · Houma, LAThe helicopter was on a cargo, non scheduled air taxi flight when the plt smelled smoke. A precautionary landing was made on a beach after which the acft was destroyed by fire.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 ANC84LA012Accident · Serious injuriesLimited investigationFinal reportBell 206-B · Kodiak, AKWhile inspecting a transmission wire tower, the left skid became entangled with the power line guide. This pulled the helicopter out of CG. While the plt was trying to correct the problem, the m/r blade contacted the tower & struck the tail boom separating…