NTSB investigations: Allison 250-C20 series

372 cases on aircraft whose registry engine model is Allison 250-C20 series. 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 ('03020'))
  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.

NTSB FTW97FA121Accident · 1 fatalField investigationFinal reportMBB BO-105S · Lena, LAThe pilot's continued VFR flight into instrument meteorological conditions, and his subsequent loss of aircraft control due to spatial disorientation. Factors were the pilot not following company procedures and directives, the low ceiling, and the dark night…Mar 14, 1997 · N7161J · DestroyedNTSB LAX97LA120Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD 369HS · Pacific Ocean (Pacific Ocean)A loss of engine power due to a deteriorated compressor air seal, which resulted from inadequate maintenance inspection of the helicopter to detect corrosion in the compressor case while being operated in a marine environment.Mar 11, 1997 · N95MS · DestroyedNTSB LAX97GA105Accident · 1 fatalFinal reportMcDonnell Douglas 369D · Santee, CASpatial disorientation and temporary visual impairment that led to a loss of aircraft control as result of difficulty to light adaptivity. Contributing was the crew coordination and inadequate night flight recurrency training.Feb 17, 1997 · N5200Y · Substantial damageNTSB NYC97LA041Accident · No injuriesLimited investigationFinal reportBell 206A · Linden, NJthe pilot allowing the rotor RPM to decay and his failure to take remedial action in time to recover the autorotation.Jan 3, 1997 · N555SJ · Substantial damageNTSB SEA97LA032Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Forks, WAfuel contamination, which resulted in loss of engine power. Factors relating to the accident included: improper servicing of the helicopter, and a lack of suitable terrain for an emergency landing due to the proximity of trees.Nov 16, 1996 · N5225C · Substantial damageNTSB FTW97LA030Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Creole, LAthe pilot's inadequate preflight by failing to remove the 100 foot long line and the external cargo basket from the helicopter before takeoff, and/or his failure to ensure that clearance/altitude was maintained from the fence.Oct 31, 1996 · N2043B · Substantial damageNTSB CHI97LA008Accident · No injuriesLimited investigationFinal reportHughes 369E · Hesston, KSthe pilot selected unsuitable terrain for landing. The factors involved were: an inoperative landing light, dusk light conditions, and the terrain condition.Oct 15, 1996 · N504AP · Substantial damageNTSB MIA96TA236Accident · No injuriesFinal reportBell 206B III · Flamingo, FLthe wire strike protection guide became entangled in a mangrove branch which resulted in helicopter control not being maintained.Sep 30, 1996 · N2113Z · Substantial damageNTSB SEA96LA165Accident · 1 fatalLimited investigationFinal reportBell 206B · Warren, IDthe pilot's improper remedial action after helicopter's right skid became snagged by a log that was used in the construction of a temporary landing site. Factors relating to the accident were: the pilot's selection of an unsuitable landing area, inadequate…Jul 24, 1996 · N750LT · DestroyedNTSB ANC96TA092Accident · No injuriesFinal reportHughes 369D · Ketchikan, AKThe pilot's failure to maintain control of the helicopter. The pilot's selection of unsuitable terrain for landing was a factor in the accident.Jun 26, 1996 · N5125Q · Substantial damageNTSB FTW96LA274Accident · No injuriesLimited investigationFinal reportHughes 369HE · Las Cruces, NMthe pilot's failure to maintain clearance between the tail rotor and a fence while hovering.Jun 24, 1996 · N521TC · Substantial damageNTSB FTW96LA147Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · Houma, LAthe pilot's attempted maneuver which exceeded the dynamic capability of the helicopter.Mar 12, 1996 · N115FH · Substantial damageNTSB LAX96LA104Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kamuela, HIfailure of the nose case (No.1) bearing resulting in oil starvation.Feb 1, 1996 · N90194 · Substantial damageNTSB MIA96WA070Accident · Minor injuriesForeign investigationBell 206 · Exuma, BahamasJan 20, 1996 · N87JH · Substantial damageNTSB FTW96FA028Accident · 2 fatalField investigationFinal reportMbb BO-105S · League City, TXthe pilot's failure to maintain aircraft control. Factors were the pilot's lack of total experience in the MBB BO-105 helicopter and the dark night light conditions.Oct 26, 1995 · N105AG · DestroyedNTSB LAX95FA339Accident · 1 fatalField investigationFinal reportBell 206L-1 · Irvine, CAthe pilot's intentional VFR flight into IMC conditions and failure to maintain an adequate terrain clearance altitude, and the local controller's improper use of ATC procedure/technique. Factors in the accident were the helicopter's low fuel state and lack of…Sep 20, 1995 · N700TH · DestroyedNTSB FTW95IA397Incident · No injuriesIncident investigationFinal reportMBB BO-105C · Lafayette, LAa short in the 'jam proof system' solenoid valve which prevented activation of the backup hydraulic system and resulting in a cyclic hardover. Factors were the contaminated hydraulic fluid and the resulting jammed actuator (longitudinal control slider).Sep 18, 1995 · N91070 · No damageNTSB NYC95LA198Accident · Minor injuriesLimited investigationFinal reportBell 206B · Bingham, MEthe pilot's inadequate landing flare resulting in a hard landing and roll over, and a subsequent collision with trees.Aug 18, 1995 · N16915 · DestroyedNTSB ANC95LA115Accident · Minor injuriesLimited investigationFinal reportBell 206B · Talkeetna, AKThe inadvertent restriction of the anti-torque pedal by the pilot's foot, while the pilot (an incomplete paraplegic) was attempting to land.Jul 26, 1995 · N85CA · Substantial damageNTSB SEA95LA139Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Orting, WAThe pilot's failure to see and avoid the cable.Jul 4, 1995 · N9196F · Substantial damageNTSB FTW95TA228Accident · No injuriesFinal reportBell 206B-III · Meeker, COFailure by the pilot to maintain control of the aircraft during landing. A factor was soft terrain.Jun 2, 1995 · N85RP · Substantial damageNTSB SEA95GA062Accident · No injuriesFinal reportBell 206 · Dillon, MTThe pilot's selection of a landing site that was not suitable to support the weight of the helicopter. Factors include terrain covered with soft snow.Feb 24, 1995 · N2277T · Substantial damageNTSB MIA95LA078Accident · No injuriesLimited investigationFinal reportHughes 500C · Key Largo, FLThe pilot's misjudgment of altitude and failure to apply collective cushioning pitch during an autorotation resulting in a hard landing. Contributing to the accident was a total loss of engine power due to a loose coupling B-nut on the pneumatic fuel control…Feb 20, 1995 · N7172Z · Substantial damageNTSB FTW95LA099Accident · No injuriesLimited investigationFinal reportMBB BO-105S · Cameron 278bThe pilot's failure to remove the tiedoown during the preflight and an inadequate preflight.Jan 23, 1995 · N51948 · Substantial damageNTSB ANC95LA014Accident · No injuriesLimited investigationFinal reportBell 206B · Kenai, AKThe pilot's failure to follow the information in the flight manual concerning the use of the particle separator kit and deflector kit when operating in falling snow. Factors were the rough terrain in the forced landing area and no installation of the…Dec 4, 1994 · N3179X · Substantial damageNTSB SEA95LA013Accident · No injuriesLimited investigationFinal reportHiller UH-12E4 · Morton, WAA leak in the fuel filler cap and water in the fuel system. A factor to the accident was: inadequate preflight.Oct 28, 1994 · N80NW · Substantial damageNTSB NYC95LA009Accident · 1 fatalLimited investigationFinal reportAerospatiale AS-355 · Jonesville, VAThe pilot's failure to maintain clearance from the power lines.Oct 15, 1994 · N5787A · DestroyedNTSB LAX94LA352Accident · Minor injuriesLimited investigationFinal reportHughes 369E · Volcano, HIthe pilot's failure to maintain adequate main rotor rpm and the resultant inadvertent skid contact with the ground.Sep 4, 1994 · N279F · Substantial damageNTSB FTW94T#A01Accident · No injuriesClass 3Final reportBell 206A · Estes Park, COJun 26, 1994 · N7881S · Substantial damageNTSB LAX94LA241Accident · No injuriesLimited investigationFinal reportHughes 369D · Kaneohe, HIthe operator's and pilot's failure to ensure that the cargo net containing empty paper bags was sufficiently ballasted to prevent it from flying up into the tail rotor.Jun 7, 1994 · N4943T · Substantial damageNTSB MIA94LA144Accident · Minor injuriesLimited investigationFinal reportBell 206B · St. Petersburg, FLThe failure of the number five bearing, shaft, or thomas coupling for undetermined reasons. Contributing to the accident was the pilot-in-command's delayed response in conducting the emergency procedure by not reducing the throttle to idle position, and…May 19, 1994 · N72Z · Substantial damageNTSB SEA94LA109Accident · Minor injuriesLimited investigationFinal reportBell 206B · Summerville, ORThe pilot did not maintain clearance from the wires. The overcast sky condiiton was a factor.Apr 25, 1994 · N35BL · DestroyedNTSB MIA94LA116Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mayaguez, PRLoss of engine power for undetermined reasons which resulted in a descent and ditching.Apr 10, 1994 · N39125 · Substantial damageNTSB SEA94LA094Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Rimrock, WAFuel exhaustion, the pilot in command's failure to refuel the aircraft, and the inability to successfully execute an auto- rotation landing because of the low altitude.Apr 1, 1994 · N5211R · Substantial damageNTSB FTW94LA110Accident · No injuriesLimited investigationFinal reportBell 206B · Belen, NMThe hard landing due to a delayed flare and improper touchdown. A factor was the loss of engine power.Mar 27, 1994 · N2779B · Substantial damageNTSB MIA94WA094Accident · Serious injuriesForeign investigationBell 206BIII · Corozal, HondurasMar 10, 1994 · N5239Y · Substantial damageNTSB FTW94LA061Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Mason, TXLoss of aircraft control for an undetermined reason.Jan 1, 1994 · N7092Q · DestroyedNTSB LAX94LA041Accident · 2 fatalLimited investigationFinal reportHughes 369D · Pacific Ocean (Pacific Ocean)An undetermined event that resulted in the accident.Nov 7, 1993 · N5172K · DestroyedNTSB FTW93GA269Accident · No injuriesFinal reportBell 206B · Wht Sands Mr, NMThe pilot's failure to land an adequate distance away from the unsecured parachute.Sep 29, 1993 · N39049 · Substantial damageNTSB LAX93LA375Accident · 2 fatalLimited investigationFinal reportBell 206B · Pacific Ocean (Pacific Ocean)a loss of engine power for undetermined reasons.Sep 22, 1993 · N285CA · DestroyedNTSB LAX93LA319Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Dixon, CAthe failure of the pilot to visually detect and avoid the guy wire.Aug 11, 1993 · N100LM · DestroyedNTSB LAX93LA249Accident · No injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe failure of the pilot to maintain adequate ground obstruction clearance while engaged in a cattle herding operation.Jun 11, 1993 · N1113L · Substantial damageNTSB FTW93TA#03Accident · No injuriesFinal reportBell 206B · Dallas, TXMar 16, 1993 · N3211N · Substantial damageNTSB LAX93LA132Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe pilots failure to maintain an adequate visual lookout for obstructions while performing a low altitude surveillance operation in a mountainous area, and, his failure to select an altitude sufficient to ensure clearance from all potential obstacles.Feb 22, 1993 · N58240 · Substantial damageNTSB LAX93LA044Accident · No injuriesLimited investigationFinal reportHughes 369D · Carlsbad, CAFailure of the overrunning clutch assembly bearing for undetermined reasons.Nov 16, 1992 · N220AL · Substantial damageNTSB NYC92WA186Accident · 4 fatalForeign investigationMcdonnell Douglas 500E · Niagara Falls, CanadaSep 29, 1992 · N588DB · 2 aircraft · DestroyedNTSB NYC92T#A01Accident · No injuriesClass 3Final reportMBB BO-105CBS · Brooklyn, NYJul 27, 1992 · N729RJ · Substantial damageNTSB LAX92T#A05Accident · No injuriesClass 3Final reportMcDonnell Douglas 369E · San Diego, CAMay 12, 1992 · N16069 · Substantial damageNTSB SEA92LA088Accident · No injuriesLimited investigationFinal reportHughes 369E · Hillsboro, ORThe pilot in command's excessive application of collective.May 1, 1992 · N5211Y · Substantial damageNTSB FTW92GA080Accident · No injuriesFinal reportBell 206B III · Falfurrias, TXThe pilot's failure to maintain directional control due to his ability to maintain an adequate visual lookout being restricted. Factors were the observer's delay in informing the pilot of the rearward drift and the dark night conditions.Mar 3, 1992 · N3201R · Substantial damage