NTSB investigations: Allison 250 SER 400HP, LA

18 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 per year

19772026

NTSB investigations: Allison 250 SER 400HP, LA per year, 1977–2026: 18 cases
1977	3
1978	1
1979	3
1980	2
1981	1
1982	1
1984	1
1989	1
1990	2
1998	1
2003	1
2004	1

Where

Open the map

Latest cases

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."eventStateOrRegion" = 'LA' 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

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\" = 'LA' 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" = 'LA' 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

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 FTW04FA168Accident · 3 fatalField investigationFinal reportBell 206-L1 · Vermillion Bay, LAThe pilot's continued flight into adverse weather conditions resulting in a loss of control. Contributing factors were the prevailing thunderstorms and the pilot's inadequate in flight preparation and planning.Jun 24, 2004 · N5006F · Destroyed 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.Nov 25, 2003 · N125TA · Minor damage 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.Apr 17, 1998 · N59604 · Substantial damage 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.Sep 21, 1990 · N71552 · Substantial damage NTSB FTW90LA172Accident · Minor injuriesLimited investigationFinal reportBell B206BIII · Cameron, LAThe pilot's failure to jettison the external load.Aug 30, 1990 · N59558 · Substantial damage 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…Aug 19, 1989 · N5006N · Substantial damage 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.Sep 4, 1984 · N4830 · Destroyed 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 FTW81FRD27Accident · Minor injuriesClosedBell 206B · Plaquemire, LAJun 3, 1981 · N90332 · Destroyed NTSB FTW81DA014Accident · 1 fatalClosedBell 206B3 · Cameron, LADec 2, 1980 · N5003Q · Destroyed NTSB FTW80DRD19Accident · Minor injuriesClosedBell 206B · Venice, LAMar 11, 1980 · N16966 · Destroyed NTSB FTW79DRD49Accident · Minor injuriesClosedBell 206B · Intracstl City, LAAug 8, 1979 · N90171 · 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 FTW78FA066Accident · 1 fatalClosedBolkow BO-105 · Cameron, LAAug 13, 1978 · N17235 · Destroyed NTSB FTW77FA060Accident · Minor injuriesClosedBolkow BO-105 · Intracstl Cy, LAJun 7, 1977 · N90754 · Substantial damage NTSB FTW77DRD12Accident · No injuriesClosedBell 206B · Leeville, LAApr 22, 1977 · N65AL · Minor damage NTSB FTW77FA044Accident · 1 fatalClosedBell 206B · Intracoastal C, LAMar 17, 1977 · N90071 · Destroyed