NTSB investigations: Allison 250-C30 series, 2006
10 cases on aircraft whose registry engine model is Allison 250-C30 series. 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
| 1978 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 1 |
| 1989 | 1 |
| 1992 | 3 |
| 1994 | 5 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 4 |
| 2000 | 4 |
| 2001 | 6 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 6 |
| 2006 | 10 |
| 2007 | 2 |
| 2008 | 2 |
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 6 |
| 2012 | 1 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 2 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 4 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 3 |
| 2026 | 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 year(c.\"eventDate\") = 2006
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03015'))
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 year(c."eventDate") = 2006
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03015'))
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 DFW07LA011Accident · Minor injuriesLimited investigationFinal reportSikorsky S-76A++ · Eugene Isl 259The flight crew's failure to maintain clearance with the water and their diverted attention to secondary tasks while preparing to land. Contributing factor were the low ceilings and the heavy rains restricting their visibility.NTSB SEA06CA161Accident · No injuriesData collectionFinal reportBell 206L-3 · Salt Lake City, UTThe failure of the pilot to maintain clearance by allowing the helicopter to drift backwards, resulting in its tail rotor striking a hangar.NTSB DEN06LA096Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Taos, NMthe loss of tail rotor effectiveness during landing, and the pilot's delayed remedial action to counteract a right yaw, which resulted in a loss of directional control and collision with terrain. A contributing factor was the pilot's failure to perform…NTSB SEA06LA121Accident · Minor injuriesLimited investigationFinal reportBell 206L · Vernal, UTThe loss of tail rotor effectiveness during an attempted precationary landing after a takeoff over uneven, sloping, brush-covered terrain. Factors include the pilot using the wrong performance chart while completing his preflight performance calculations, the…NTSB DFW06IA151Incident · Serious injuriesIncident investigationFinal reportBell 206L-1 · South Pass 57 (Gulf of Mexico)The passenger's failure to follow procedures associated with operations in the vicinity of the helicopter and his failure to see/avoid the tail rotor of the helicopter.NTSB ANC06LA066Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Juneau, AKThe pilot's failure to maintain adequate altitude/clearance from terrain while maneuvering in adverse weather conditions. Factors associated with the accident are the pilot's decision to continue flight into adverse weather, fog, whiteout and flat light…NTSB DFW06IA145Incident · 1 fatalIncident investigationFinal reportBell 206L-3 · Grand Isle 43AAThe pilot's incapacitation and death due to pre-existing cardiac disease.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 LAX06LA098Accident · No injuriesLimited investigationFinal reportEurocopter AS350D · Kahului, HIA total loss of engine power due to the internal effects on the bearings consistent with an operating event of insufficient oil supply. Contributing to the accident was the pilot’s improper flare during the autorotative descent.NTSB DFW06CA058Accident · No injuriesData collectionFinal reportBell 206L-4 · Fort Worth, TXThe flight instructors failure to maintain main rotor RPM and improper flare, which resulted in a hard landing.