NTSB investigations: Allison 250-C28 series

7 cases on aircraft whose registry engine model is Allison 250-C28 series, where the first occurrence was “Loss of control - in flight”. 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

19832026

NTSB investigations: Allison 250-C28 series per year, 1983–2026: 7 cases
1983	1
1988	1
2002	2
2003	1
2006	1
2007	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 ('03022', '03021') 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" = 250)) 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 ('03022', '03021')
      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\" = 250))
  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 ('03022', '03021')
    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" = 250))
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 DFW08FA053Accident · 1 fatalField investigationFinal reportBell 206L1 · Venice, LAThe pilot’s decision to continue to the destination landing platform in weather conditions below the company’s weather minimums and his failure to maintain aircraft control during the approach. Contributing to the passenger fatality and the severity of the…Dec 29, 2007 · N211EL · Destroyed NTSB CHI06FA110Accident · 1 fatalField investigationFinal reportMesserschmitt-Bolkow-Blohm BO 105LS A-3 · Green Bay, WIThe pilot's inadequate preflight check of the flight controls prior to takeoff and the directional contol not possible by the pilot. Additional causes were the improper installation of the anti-torque pedal cover by company personnel which blocked the flight…Apr 13, 2006 · N202LF · Substantial damage NTSB CHI03FA056Accident · 1 fatalField investigationFinal reportBell 206L-1 · B.S. 53, LAThe improper approach by the pilot and the settling with power encountered by the pilot.Jan 16, 2003 · N3194P · Destroyed NTSB CHI02FA288Accident · 4 fatalField investigationFinal reportBell 206L-1 · Doland, SDPilot spatial disorientation while flying in dark night conditions, resulting in a loss of aircraft control; and the company's inadequate remedial actions after identifying the pilot's night flying deficiency over areas without lighted references. A factor to…Sep 10, 2002 · N400SL · Destroyed NTSB DEN02LA044Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Salem, UTa loss of tail rotor effectiveness during takeoff. A contributing factor was the wind gusts.May 18, 2002 · N3894Q · Substantial damage NTSB CHI88FA079Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Taylorville, ILThe helicopter experienced a loss of control while in slow flight out of ground effect. The helicopter impacted the ground in a black plowed field during a period of low visibility due to snow. The occurrence happened in a remote area with few ground…Mar 18, 1988 · N5759H · Destroyed NTSB LAX83FA420Accident · 1 fatalField investigationFinal reportHughes 369HS · Ventura, CAThe helicopter was observed descending 'straight down' & 'nose first.' The wreckage was located about 200 yds offshore in about 30 ft of water. Witnesses stated that it was dark & hazy. They were able to see the acft lights, but not the stars. The plt did not…Sep 4, 1983 · N8500N · Destroyed