NTSB investigations: Allison 250 SER 400HP, Outside the U.S.
7 cases on aircraft whose registry engine model is Allison 250 SER 400HP. 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.
Cases per year
| 1991 | 1 |
|---|---|
| 1997 | 1 |
| 1999 | 1 |
| 2010 | 1 |
| 2015 | 1 |
| 2019 | 1 |
| 2022 | 1 |
Latest cases
Query with SQL
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.\"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 ('03013', '03012'))
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."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 ('03013', '03012'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 GAA22WA099Incident · No injuriesClass 5 · ForeignHughes 369HS · Panama City, PanamaNTSB ERA19WA176Accident · 2 fatalForeign investigationBell 206 · La Vega, Dominican RepublicNTSB WPR15LA257Accident · 1 fatalLimited investigationFinal reportHughes 369HS · Manra Island, KiribatiA The loss of helicopter control for reasons that could not be determined asbecause the helicopter sank in the oceanwater and was not recovered.NTSB CEN10WA273Accident · 4 fatalForeign investigationFairchild Hiller FH-1100 · Görkwitz, GermanyNTSB FTW00RA039Accident · 1 fatalForeign investigationBell 206-L1 · Cabinda, AngolaNTSB LAX98LA053Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369HS · Saipan, IndiaThe failure of the maintenance facility to comply with the service bulletins, which resulted in the development of a corrosion pit, subsequent leakage and failure of the acceleration bellows of the fuel control.NTSB LAX91LA172Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Papua, Papua New GuineaThe loss of control of the helicopter due to a restriction of the cyclic control system.