NTSB investigations: Allison 250-C30 series
6 cases on aircraft whose registry engine model is Allison 250-C30 series, where the first occurrence was “Loss of engine power”. 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
| 1992 | 1 |
|---|---|
| 2001 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03015')
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\" = 350))
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 ('03015')
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" = 350))
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 DFW06FA083Accident · 2 fatalField investigationFinal reportBell 206L-1 · Patterson, LAThe improper installation of an engine fuel line fitting by other maintenance personnel, which resulted in a loose fitting and a loss of engine power during cruise flight. Factors associated with the accident are a tailwind, and the lack of a suitable site…NTSB DFW05MA230Accident · Serious injuriesMajor investigationFinal reportSikorsky S76 · Gulf of Mexico, TXThe pilots' delayed response to the No. 1 engine fire warning and the loss of power to both engines, which occurred for undetermined reasons. The pilots' delayed response was most likely due to stress and fatigue. Contributing to the delay of the initiation…NTSB LAX04LA216Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Palmdale, CAThe momentary loss of engine power for undetermined reasons.NTSB FTW04LA088Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · W. Cameron 149A partial loss of engine power due to undetermined reasons. A contributing factor was the emergency floats not being deployed.NTSB FTW02LA019Accident · Serious injuriesLimited investigationFinal reportBell 206L-3 · East Cameron 78The hard landing due to the pilot's failure to maintain proper main rotor rpm. Contributing factors were the loss of engine power for undetermined reasons, and the pilot's failure to deploy the emergency floats.NTSB FTW92LA166Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ponca City, OKThe pilot's failure to maintain main rotor RPM. A factor was the contaminated fuel.