Skip to content

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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" DESC

Run 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 MKC83LA149Accident · No injuriesLimited investigationFinal reportHughes 369HS · Springfield, MOThe plt reported that he had made a practice autorotation with a full power recovery & was landing when the accident occurred. He said the helicopter touched down hard, tail 1st, and rocked forward. The helicopter remained upright, but the main rotors struck…Jul 9, 1983 · N500PA · Substantial damage NTSB ANC83FA066Accident · Serious injuriesField investigationFinal reportBell 206B · Stony River, AKThe plt was on an external load operation with a 100 ft long line. The long line had 4 remote hooks, of which, 3 had cable bags attached. While waiting for the 4th bag to be filled, he decided to land in an open area. He set the external load down & laid the…Apr 6, 1983 · N376KA · Substantial damage NTSB FTW83LA099Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Grand Isle B43qDue to the location of a gas separator, the plt started to takeoff from an oil rig platform with a left cross- wind at aprx 30 KTS, gusting 35 to 40 KTS. After lifting off to a hover, wind gusts were encountered. The plt reported that the acft turned 10 to 15…Jan 27, 1983 · N5012T · Substantial damage NTSB DEN83FA045Accident · 1 fatalField investigationFinal reportBell 206B III · Sula, MTThe helicopter crashed tail low and rolled over in an open field during marginal weather. The pilot was flying on an expired student certificate and expired medical. According to a pilot who had worked with him the pilot had no helicopter rating. Witnesses…Jan 6, 1983 · N55LW · Substantial damage NTSB ATL82DA257Accident · No injuriesFinal reportBell 206L · Greenville, SCThe pilot reported that he was making an approach to a new helipad that was still under construction when he felt a severe vibration. After landing and shutdown, he discovered that the tail rotor had struck the glass cover of a heliport perimeter light.Aug 30, 1982 · N403DC · Substantial damage NTSB FTW82DA323Accident · Serious injuriesFinal reportBell 206B · Grand Isle, LAThe pilot was approaching an offshore platform for landing at about 100 ft AGL when he felt the helicopter shudder. He also heard an engine-out horn and a low-rotor-rpm warning. He turned away from the platform, popped the emergency floats and initiated an…Aug 8, 1982 · N59504 · Destroyed NTSB ANC82DA039Accident · No injuriesFinal reportHughes 369HS · Tok, AKThe pilot was conducting a non-revenue, sling-load operation on mt neuberer, while donating his services to Tok community tv, inc. he stated that he was lifting three empty propane bottles from a snow field when he noticed the auto relight lamp flash. He…May 4, 1982 · N9239F · Substantial damage NTSB SEA82DA055Accident · No injuriesFinal reportHughes 500C · Darrington, WADuring an approach to a 9100 foot high snow covered landing site the wind shifted to a tailwind condition. The pilot elected to continue and attempted a skid on landing. While skidding through the snow the left skid impacted rising terrain underneath a 12…Apr 19, 1982 · N9131F · Substantial damage NTSB LAX82DA140Accident · 3 fatalFinal reportHughes 369HS · 8 S. Of Page, AZThe aircraft was number two in a trail of three helicopters flying up the Colorado river at marble canyon to page, AZ when it struck an aerial cableway stretching across the river, 22 ft above the water. Witnesses stated that after the collision the…Apr 18, 1982 · N4EE · Destroyed NTSB FTW82DA075Accident · 2 fatalFinal reportBell 206B · High Island BlkThe aircraft was low on the approach and during the flare, the vertical fin and tail boom contacted the safety netting extending beyond the boundaries of the platform landing area. The aircraft then settled back off the platform with one main rotor blade…Mar 2, 1982 · N63AL · Destroyed NTSB DEN82DA037Accident · No injuriesFinal reportBell 206B III · Alma, COThe pilot reported that before the accident, the flight had been uneventful and all instruments were reading normal except the tot gauge. Reportedly, it was indicating 750 degrees, which was about 100 degrees higher than normal for his power setting of 70%…Mar 1, 1982 · N580P · Substantial damage NTSB LAX82DUM05Accident · Minor injuriesClosedHughes 369 · Winterhaven, CADec 4, 1981 · N58184 · Destroyed NTSB DEN82DTM06Accident · No injuriesClosedBell 206B · Fruitland, UTDec 3, 1981 · N4717R · Substantial damage NTSB DEN82FTI02Accident · No injuriesClosedBell 206B · Whitehall, MTOct 25, 1981 · N90142 · Substantial damage NTSB FTW81FRD27Accident · Minor injuriesClosedBell 206B · Plaquemire, LAJun 3, 1981 · N90332 · Destroyed NTSB ANC81FA055Accident · Minor injuriesClosedHughes 369D · Glennallen, AKMay 25, 1981 · N211EH · Substantial damage NTSB LAX81DVA27Accident · No injuriesClosedHughes 369D · Madera, CAMar 9, 1981 · N8681F · Substantial damage NTSB FTW81DA014Accident · 1 fatalClosedBell 206B3 · Cameron, LADec 2, 1980 · N5003Q · Destroyed NTSB DEN80FTE04Accident · No injuriesClosedHughes 369D · Alma, COOct 27, 1980 · N58216 · Substantial damage NTSB LAX80FA136Accident · 1 fatalClosedHughes 369HS · Las Vegas, NVAug 26, 1980 · N9144F · Substantial damage NTSB ANC80DA083Accident · Minor injuriesClosedHughes 500C · Sitka, AKAug 12, 1980 · N9052F · Substantial damage NTSB ANC80DA080Accident · No injuriesClosedHughes 369 · Kivalina, AKAug 2, 1980 · N50SC · Substantial damage NTSB FTW80FPA16Accident · No injuriesClosedBell 206B · Dallas, TXJul 13, 1980 · N2771S · Substantial damage NTSB ATL80FIJ06Accident · Serious injuriesClosedBell 206B · Pennington Gap, VAJul 10, 1980 · N90162 · Destroyed NTSB SEA80FYM40Accident · Minor injuriesClosedHiller Acft FH1100 · Albany, ORJun 4, 1980 · N92484 · Substantial damage NTSB LAX80DVA44Accident · No injuriesClosedBell 206B · Firebaugh, CAMay 31, 1980 · N59543 · Substantial damage NTSB MIA80DA059Accident · 1 fatalClosedBell 206B · Malabar, FLMay 3, 1980 · N5004U · No damage NTSB LAX80FVG36Accident · No injuriesClosedHughes 369HS · Georgetown, CAApr 29, 1980 · N8316F · Destroyed NTSB LAX80DUJ45Accident · Minor injuriesClosedBell 206B · Ashfork, AZApr 10, 1980 · N777PS · Destroyed NTSB FTW80DRD19Accident · Minor injuriesClosedBell 206B · Venice, LAMar 11, 1980 · N16966 · Destroyed NTSB SEA80FYM17Accident · No injuriesClosedHughes 369HS · Siletz, ORFeb 21, 1980 · N9219F · Substantial damage NTSB SEA80DYE14Accident · No injuriesClosedHughes 369 · Redmond, WAFeb 16, 1980 · N9205F · Substantial damage NTSB LAX80FA036CaseClosedHughes 369D · June Lakes, CAJan 20, 1980 · N8354F NTSB FTW79DRD49Accident · Minor injuriesClosedBell 206B · Intracstl City, LAAug 8, 1979 · N90171 · Substantial damage NTSB LAX79FA064Accident · Minor injuriesClosedBell 206B · Grand Canyon, AZAug 3, 1979 · N8533F · Substantial damage NTSB SEA80FYM54Accident · Minor injuriesClosedHughes 369D · Bay City, ORJul 25, 1979 · N58184 · Substantial damage NTSB FTW79DRD44Accident · No injuriesClosedBell 206B · Bell Rose, LAJun 17, 1979 · N4830 · Substantial damage NTSB FTW79DA085Accident · Serious injuriesClosedBell 206B · Morgan City, LAJun 3, 1979 · N14852 · Destroyed NTSB CHI79FEX26Accident · No injuriesClosedBell 206-11 · Indianapolis, INMay 28, 1979 · N27554 · Substantial damage NTSB SEA79FYP17Accident · Minor injuriesClosedHughes 369D · Spokane, WAMay 9, 1979 · N8601F · Substantial damage NTSB LAX79FVA11Accident · Minor injuriesClosedBell 206 · Long Beach, CAApr 8, 1979 · N4790R · Substantial damage NTSB DEN79FTE19Accident · No injuriesClosedHughes 500D · Marble, COJan 21, 1979 · N8306F · Substantial damage NTSB OAK79DXQ10Accident · No injuriesClosedHughes 369C · Minden, NVJan 4, 1979 · N9141F · Substantial damage NTSB OAK79FVD01Accident · Serious injuriesClosedHughes 500D · Garberville, CAOct 19, 1978 · N58183 · Destroyed NTSB LAX78FUM34Accident · No injuriesClosedBell 206B · Holtville, CAAug 18, 1978 · N16733 · Substantial damage NTSB FTW78FA066Accident · 1 fatalClosedBolkow BO-105 · Cameron, LAAug 13, 1978 · N17235 · Destroyed NTSB MKC78FER81Accident · Serious injuriesClosedHughes 369HS · Sauk Centre, MNJul 28, 1978 · N9199F · Destroyed NTSB MIA78FA109Accident · Serious injuriesClosedSikorsky S76A · W Palm Beach, FLJul 28, 1978 · N763SA · Substantial damage NTSB OAK78FJA08Accident · Minor injuriesClosedBell 206B · Mauna Kea, HIJun 12, 1978 · N59622 · Substantial damage NTSB FTW78FPA21Accident · No injuriesClosedBell 206B · Mc Kinney, TXApr 16, 1978 · N23JH · Substantial damage