NTSB investigations: Allison 250 SER 400HP

7 cases on aircraft whose registry engine model is Allison 250 SER 400HP, where the first occurrence was “Roll over”. 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 SER 400HP per year, 1983–2026: 7 cases
1983	2
1993	1
1994	1
1996	1
1997	1
2001	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 ('03013', '03012') 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" = 380)) 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 ('03013', '03012')
      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\" = 380))
  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 ('03013', '03012')
    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" = 380))
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 IAD01LA041Accident · Minor injuriesLimited investigationFinal reportBell BH-206-B · Ringgold, VApilot's failure to properly control the helicopter during a slope landing, which resulted in a dynamic rollover.Apr 8, 2001 · N17HA · Substantial damage NTSB LAX97LA317Accident · Minor injuriesLimited investigationFinal reportBell 206B · Napa, CAFailure of the pilot to perform an adequate preflight, which resulted in him failing to notice and release the tie down chains.Sep 8, 1997 · N770GG · Substantial damage NTSB LAX96LA346Accident · No injuriesLimited investigationFinal reportBell 206B · Fillmore, CAthe flight instructor's inadequate supervision and delay in taking remedial action to stop the aircraft's lateral movement, which resulted in a dynamic rollover after touchdown.Sep 30, 1996 · N59576 · Substantial damage NTSB LAX95LA052Accident · No injuriesLimited investigationFinal reportBell 206B · Julian, CAthe failure of the pilot to maintain a proper alignment during hover in a mountainous area.Dec 15, 1994 · N37AJ · Substantial damage NTSB FTW93LA090Accident · Minor injuriesLimited investigationFinal reportBell 206B · Oklahoma City, OKThe passengers inadvertent control interference. A factor was the pilot's inadequate supervision of the passengerFeb 23, 1993 · N224TV · Substantial damage NTSB ANC83FA066Accident · Serious injuriesField investigationFinal reportBell 206B · Stony River, AKThe plt was on an external load operation with a 100 ft long line. The long line had 4 remote hooks, of which, 3 had cable bags attached. While waiting for the 4th bag to be filled, he decided to land in an open area. He set the external load down & laid the…Apr 6, 1983 · N376KA · Substantial damage NTSB FTW83LA099Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Grand Isle B43qDue to the location of a gas separator, the plt started to takeoff from an oil rig platform with a left cross- wind at aprx 30 KTS, gusting 35 to 40 KTS. After lifting off to a hover, wind gusts were encountered. The plt reported that the acft turned 10 to 15…Jan 27, 1983 · N5012T · Substantial damage