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 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 FTW04IA043Incident · No injuriesIncident investigationFinal reportBell 206B · Venice, LAThe failure of the forward boost pump while in cruise flight while operating with less than 10 gallons of fuel onboard, which resulted in a loss of engine power. A factor was the inoperative forward fuel boost pump caution light switch.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 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 NYC03LA133Accident · Serious injuriesLimited investigationFinal reportMBB BO-105C · Buffalo, NYThe pilot's improper interpretation of a descent as a power loss and subsequent decision to autorotate, which resulted in a hard landing. A factor in the accident was the collective friction.NTSB CHI03LA062Accident · No injuriesLimited investigationFinal reportBell 206L-1 · West Plains, MOThe excessive descent rate that required an abrupt flare, resulting in the main rotor severing the tailboom.NTSB ANC03LA015Accident · 1 fatalLimited investigationFinal reportBell 206B · Kingman, AZThe pilot's failure to maintain altitude/clearance from obstacles during cruise flight, which resulted in the helicopter striking a transmission line, and subsequently the ground.NTSB SEA02LA172Accident · No injuriesLimited investigationFinal reportHughes 500 · Carnation, WAThe pilot's delayed power application during a practice power recovery autorotation.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 LAX01LA243Accident · No injuriesLimited investigationFinal reportBell 206B · San Francisco, CAThe failure of the accessory gearbox 2 1/2 bearing in fatigue resulting in the complete loss of engine power and a subsequent forced landing. The pilot's failure to maintain directional control during the autorotational flare maneuver is also causal. The…NTSB SEA01FA085Accident · No injuriesField investigationFinal reportMBB BO-105C · Medford, ORA leaking engine oil outlet line fitting in the #1 engine compartment, resulting in an oil fire in the engine compartment.NTSB IAD01LA041Accident · Minor injuriesLimited investigationFinal reportBell BH-206-B · Ringgold, VApilot's failure to properly control the helicopter during a slope landing, which resulted in a dynamic rollover.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 ANC00LA053Accident · No injuriesLimited investigationFinal reportBell 206B · Homer, AKThe pilot's misjudging the landing flare in whiteout/flat light conditions. Factors associated with the accident are the whiteout and flat lighting conditions.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 FTW00RA039Accident · 1 fatalForeign investigationBell 206-L1 · Cabinda, AngolaNTSB LAX99LA293Accident · No injuriesLimited investigationFinal reportBell 206B · Delhi, CAThe loss of engine power due to the pilot's inadequate preflight, which failed to detect water contamination of the fuel system. The operator's inadequate maintenance of the loose fitting fuel cap and the deformed filler opening, which allowed water to leak…NTSB ANC99TA090Accident · No injuriesFinal reportBell 206B · Deadhorse, AKA failure of the pilot-in-command to perform an adequate preflight inspection, and remove a rotor blade tie-down strap.NTSB SEA99LA082Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Southbend, WAThe complete loss of power, due to a failure of the compressor impeller disk. Factors include the low altitude of the helicopter at the time of the power loss, and the need to autorotate in a confined area.NTSB ANC98TA125Accident · No injuriesFinal reportBell 206B II · Chickaloon, AKA fracture of the main rotor drag pin assembly.NTSB LAX98LA139Accident · No injuriesLimited investigationFinal reportBell 206B · Grand Canyon, AZThe malfunction and erratic speed control of the engine's governor, and the flight instructor's delayed remedial action.NTSB FTW98LA187Accident · No injuriesLimited investigationFinal reportBell 206B · Cameron, LAThe loss of engine power for undetermined reasons and the pilot's improper flare which resulted in a hard landing.NTSB MIA98LA070Accident · No injuriesLimited investigationFinal reportBell 206B · Miami, FLThe pilot's improper use of flight controls (cyclic) while attempting a takeoff to a hover, which led to an on-ground loss of control (dynamic rollover).NTSB LAX98LA053Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369HS · Saipan, IndiaThe failure of the maintenance facility to comply with the service bulletins, which resulted in the development of a corrosion pit, subsequent leakage and failure of the acceleration bellows of the fuel control.NTSB ANC98TA011Accident · No injuriesFinal reportBell 206B · Anchorage, AKThe pilot's failure to maintain adequate rotor RPM during an autorotation landing.NTSB ANC98LA003Accident · No injuriesLimited investigationFinal reportBell 206-B2 · Sutton, AKThe pilot's failure to maintain clearance between the tail rotor and the external long line cable, and the subsequent entanglement of the tail rotor with the long line.NTSB IAD98FA005Accident · 4 fatalField investigationFinal reportBell 206B · Sago, WVThe improper overhaul of the turbine governor by the manufacturer, which resulted in the loss of power.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 LAX97LA317Accident · Minor injuriesLimited investigationFinal reportBell 206B · Napa, CAFailure of the pilot to perform an adequate preflight, which resulted in him failing to notice and release the tie down chains.NTSB SEA97LA118Accident · No injuriesLimited investigationFinal reportHughes 369D · Moclips, WAInadequate installation of the fuel control by company maintenance personnel and a loose nut on a line. A disconnected Pc line was a factor.NTSB IAD97FA032Accident · 3 fatalField investigationFinal reportMbb BO-105CBS · Penn Yan, NYthe pilot's failure to maintain altitude/clearance from the terrain. Factors relating to the accident were: the pilot's diverted attention to the GPS, darkness, low ceiling, rising terrain, and high wind condition.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 LAX96LA346Accident · No injuriesLimited investigationFinal reportBell 206B · Fillmore, CAthe flight instructor's inadequate supervision and delay in taking remedial action to stop the aircraft's lateral movement, which resulted in a dynamic rollover after touchdown.NTSB SEA96LA205Accident · No injuriesLimited investigationFinal reportBell 206B · Greybull, WYthe pilot's misjudged recovery (remedial action) from a simulated autorotation demonstration.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 ANC96LA111Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas MD369D · Healy, AKThe inadequate visual outlook by the pilots of both aircraft, and their failure to see and avoid the other aircraft. A factor associated with the accident was sunglare affecting the helicopter pilot's vision.NTSB ANC96LA097Accident · No injuriesLimited investigationFinal reportBell 206B · Juneau, AKThe pilot's failure to maintain proper alignment while lifting the helicopter to a hover and inducing a dynamic roll to avoid striking a passenger.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 SEA96LA025Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Scotts Mills, ORThe pilot's failure to maintain adequate clearance from the ground.NTSB FTW96LA054Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Leakey, TXimproper planning/decision by the pilot, by failing to ensure there was adequate fuel on board, which resulted in fuel exhaustion and a subsequent roll-over during a forced landing on hilly terrain. A factor relating to the accident was: downsloping terrain…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 ANC95LA112Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Bettles, AKFailure of the pilot to ensuring the sling cable was free of the skid before lifting off into a hover, which allowed the cable to become wrapped (entangled) around the skid.NTSB LAX95LA052Accident · No injuriesLimited investigationFinal reportBell 206B · Julian, CAthe failure of the pilot to maintain a proper alignment during hover in a mountainous area.NTSB ANC94LA110Accident · No injuriesLimited investigationFinal reportBell B-206 · Gustavus, AKThe pilot misjudged his distance/altitude from the landing area, and his lack of recent night flying experience. Factors which contributed to the accident were: the pilot's failure to assure that he would be landing with sufficient light, and the dusk/dark…NTSB CHI94LA161Accident · No injuriesLimited investigationFinal reportBell 206B · Winnebago, ILa wire strike due to failure to maintain proper altitude, and improper visual lookout by the pilot-in-command.NTSB CHI94GA038Accident · 1 fatalFinal reportHughes 369HS · Antonia, MOThe pilot's failure to maintain proper altitude. A factor was the dark night.NTSB ANC93T#A05Incident · No injuriesClass 3Final reportBell BH-206B · Kantishna, AKNTSB 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.