Skip to content

NTSB investigations: Allison 250 SER 250HP, LA

18 cases on aircraft whose registry engine model is Allison 250 SER 250HP. 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

19752026

Where

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 ('03002', '03003')) 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 ('03002', '03003'))
  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 ('03002', '03003'))
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 CEN22LA009Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Gonzales, LAThe student pilot’s failure to compensate for an unanticipated right yaw, which resulted in a loss of tail rotor effectiveness and helicopter control.Oct 6, 2021 · N373SP · Substantial damage NTSB CEN17LA174Accident · No injuriesLimited investigationFinal reportBell 407 · Venice, LAAn in-flight separation of the tip block from the tail rotor blade due to an inadequate blade repair, which resulted in a rotor imbalance sufficient to crack the gearbox attachment studs and gearbox support assembly, and inadequate postrepair test procedures,…May 2, 2017 · N457PH · Substantial damage NTSB DFW05CA044Accident · No injuriesData collectionFinal reportBell B206L-1 · Patterson, LAThe loss of engine power due to fuel starvation resulting from the pilot's failure to activate the fuel boost pumps prior to takeoff. A contributing factor was that the helicopter was at an airspeed and altiutude combination (below height/velocity curve)…Dec 9, 2004 · N5007F · Substantial damage NTSB FTW04FA186Accident · 1 fatalField investigationFinal reportBell 206 L-1 · Cameron, LAThe helicopter's in-flight collision with water for undetermined reasons.Jul 17, 2004 · N1078C · Destroyed NTSB CHI03FA259Accident · 3 fatalField investigationFinal reportBell 206L-3 · E.I. 276, LAThe inadequate compensation for crosswind conditions and the directional control not obtained/maintained by the pilot during takeoff. Contributing factors were the crosswind and the planned approach to position the helicopter with a crosswind in order to…Aug 13, 2003 · N41128 · Substantial damage NTSB FTW97LA326Accident · No injuriesLimited investigationFinal reportBell 206B · Oak Grove, LAThe disconnect of the #5 tail rotor drive segment due to the debonding of the joint between the shaft tube and the flange fitting. Factors were the improper bead blasting of the tail rotor drive segment by an unknown maintenance personnel, and the lack of…Aug 23, 1997 · N7929J · Substantial damage NTSB FTW95LA032Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ruston, LAThe pilot's improper handling of the helicopter after an apparent loss of power during a practice autorotation.Oct 27, 1994 · N206SF · Substantial damage NTSB FTW94LA093Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · Lake Charles, LAThe failure of the pilot to adequately perform a preflight. A factor was the soft terrain.Mar 10, 1994 · N57340 · Substantial damage NTSB FTW85LA089Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Houma, LAThe plt departed into known bad wx with low ceilings and poor visibility. Very shortly after takeoff the plt elected to return to the arpt. During a descending right turn the plt broke out of IMC at a very low altitude. He pulledcollective but still landed…Dec 28, 1984 · N1075Y · Substantial damage NTSB FTW82FRJ17Accident · Serious injuriesFinal reportBell 206B · Jamestown, LAThe pilot was conducting aerial burning operations over a wooded area when he heard a loud bang from the engine area of the helicopter. At that time, the helicopter was approximately 20 ft above the tallest tree in the area with the aerial torch burning. The…Aug 27, 1982 · N5754P · Destroyed NTSB FTW81DA081Accident · Minor injuriesClosedBell 206L-1 · Leeville, LAApr 25, 1981 · N5000Y · Substantial damage NTSB FTW80FA111Accident · Minor injuriesClosedSikorsky S-76 · Patterson, LASep 3, 1980 · N766AL · Destroyed NTSB FTW80FA030Accident · 1 fatalClosedBell 206B · Montegut, LAJan 3, 1980 · N30TA · 2 aircraft · Destroyed NTSB FTW79DRD09Accident · Minor injuriesClosedBell 206B · Lutcher, LANov 25, 1978 · N33TA · Substantial damage NTSB FTW77FA062Accident · No injuriesClosedBolkow BO-105 · Cameron, LAJun 20, 1977 · N152BB · Substantial damage NTSB FTW77DRD21Accident · Minor injuriesClosedBell 206B · Cameron, LAMay 7, 1977 · N7902J · Substantial damage NTSB FTW76AF101Accident · 1 fatalClosedBolkow BO105C · Intracoastal, LAJun 13, 1976 · N149BB · Substantial damage NTSB FTW76FRD16Accident · No injuriesClosedBell 206B · Morgan City, LANov 2, 1975 · N7847S · Substantial damage