NTSB investigations: Allison 250 SER 250HP, OK

5 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

19722026

NTSB investigations: Allison 250 SER 250HP, OK per year, 1972–2026: 5 cases
1972	1
1981	1
1983	1
2011	1
2026	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" = 'OK' 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\" = 'OK' 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" = 'OK' 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 WPR26LA277Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206B III · Stonewall, OKThe pilot’s failure to maintain clearance from power lines while conducting a low-altitude aerial application.Jul 21, 2026 · N2193X · Substantial damage NTSB CEN11LA200Accident · No injuriesLimited investigationFinal reportHughes 369D · Henryetta, OKFailure of the cyclic control system for reasons undetermined.Feb 23, 2011 · N112AS · Substantial damage NTSB FTW84LA081Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Ardmore, OKThe plt stated that before he took off from Oklahoma city, OK, he called the Oklahoma city fss & obtained a wx briefing. The briefing called for light rain showers, minimum ceiling of 1800 ft, visibility of 3 to 5 miles & no chance of fog, except in low lying…Dec 2, 1983 · N2005A · Substantial damage NTSB FTW81FA023Accident · 5 fatalClosedBell 206B · Norman, OKJan 9, 1981 · N10785 · Destroyed NTSB FTW72AF079Accident · No injuriesClosedHiller Acft FH1100 · Yukon, OKMay 19, 1972 · N748FH · Destroyed