NTSB investigations: Allison 250 SER 250HP

8 cases on aircraft whose registry engine model is Allison 250 SER 250HP, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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

19822026

NTSB investigations: Allison 250 SER 250HP per year, 1982–2026: 8 cases
1982	1
1983	1
1984	2
1989	1
1990	1
1993	1
1999	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03002', '03003') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353)) 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 ('03002', '03003')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
  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 ('03002', '03003')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 MIA00FA003Accident · 2 fatalField investigationFinal reportBell 206B · Centreville, ALThe pilot's inadequate preflight inspection of the helicopter's fuel system resulting in an in-flight loss of engine power due to fuel exhaustion as a result of overboard porting of fuel when the airframe fuel filter was left in the 'drain and locked'…Oct 5, 1999 · N1285S · Destroyed NTSB ATL94LA014Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 Soloy · Atmore, ALThe pilot's inadequate pre-flight inspection. Factors were the lack of a filter on the refueling pump which would preclude water passage, and the high trees.Nov 12, 1993 · N3078G · Substantial damage NTSB LAX90FA268Accident · No injuriesField investigationFinal reportBell 206B · Quincy, CAAn unidentified contaminate lodged in the fuel governor.Jul 25, 1990 · N2292W · Substantial damage NTSB NYC89LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Nanuet, NYInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.Aug 10, 1989 · N16929 · Substantial damage NTSB DEN84FA142Accident · Serious injuriesField investigationFinal reportHughes 369D · Meeker, CODuring slow (35-40 KTS) cruise flt at about 50 ft AGL in mountainous terrain for wildlife survey, pwr loss occurred. Auto systems briefly restored pwr, followed by a ttl loss. Plt executed emergency autorotation into trees on sloping terrain. Investigation…May 2, 1984 · N1090A · Substantial damage NTSB DEN84LA075Accident · No injuriesLimited investigationFinal reportHughes 369HS · Buffalo, WYThe helicopter lost power a few minutes after takeoff and made a forced landing. The acft had been refueled from a fuel truck shortly before takeoff. Samples of fuel from the acft and the fuel truck were examined and found to contain water.Jan 27, 1984 · N4507C · Substantial damage NTSB ANC83FA032Accident · 1 fatalField investigationFinal reportBell 206B · Cordova, AKThe helicopter was on a rescue/recovery flt for the Alaska state troopers with the plt & a state trooper on board. They departed in variable wx conditions to rescue the plt of another acft. Reportedly, snow was falling in the search area & the winds were…Jan 13, 1983 · N74PR · Destroyed NTSB SEA82FYM16Accident · Minor injuriesFinal reportHughes 369D · Birkenfeld, ORThe pilot stated that the fuel gauge indicated 150 lbs of fuel remaining when he began the flight. Since the drop point was within 2 to 3 minutes of the departure point, he elected to proceed without refueling. While hovering and being guided into the drop…May 19, 1982 · N1096L · Substantial damage