NTSB investigations: Allison 250-C20 series, 2012
6 cases on aircraft whose registry engine model is Allison 250-C20 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
| 1973 | 2 |
|---|---|
| 1974 | 1 |
| 1975 | 2 |
| 1978 | 1 |
| 1979 | 3 |
| 1980 | 3 |
| 1981 | 5 |
| 1982 | 2 |
| 1983 | 2 |
| 1984 | 7 |
| 1985 | 6 |
| 1986 | 6 |
| 1987 | 6 |
| 1988 | 5 |
| 1989 | 7 |
| 1990 | 6 |
| 1991 | 5 |
| 1992 | 9 |
| 1993 | 7 |
| 1994 | 13 |
| 1995 | 10 |
| 1996 | 10 |
| 1997 | 10 |
| 1998 | 4 |
| 1999 | 16 |
| 2000 | 13 |
| 2001 | 13 |
| 2002 | 14 |
| 2003 | 19 |
| 2004 | 15 |
| 2005 | 14 |
| 2006 | 12 |
| 2007 | 19 |
| 2008 | 5 |
| 2009 | 10 |
| 2010 | 4 |
| 2011 | 4 |
| 2012 | 6 |
| 2013 | 9 |
| 2014 | 11 |
| 2015 | 5 |
| 2016 | 2 |
| 2017 | 9 |
| 2018 | 10 |
| 2019 | 2 |
| 2020 | 5 |
| 2021 | 6 |
| 2022 | 7 |
| 2023 | 3 |
| 2024 | 5 |
| 2026 | 2 |
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\") = 2012
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03020'))
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") = 2012
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03020'))
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 WPR13CA057Accident · Minor injuriesData collectionFinal reportHughes 369D · Sheridan, ORThe pilot’s failure to prevent the helicopter from entering a vortex ring state (settling with power) condition during an external load operation, which resulted in the helicopter’s main rotor blades impacting the truck.NTSB CEN13FA009Accident · 1 fatalField investigationFinal reportBell 206B · Crowley, LAThe pilot’s failure to maintain clearance from the broadcast tower guy-wires.NTSB WPR12LA328Accident · Serious injuriesLimited investigationFinal reportHughes Helicopters 369E · The Dalles, ORThe loss of engine power due to fuel starvation, which resulted from the fuel tank supply pickup becoming unported while the helicopter was pulling power lines.NTSB CEN12FA321Accident · 1 fatalField investigationFinal reportBell 206-L4 · (Gulf of Mexico)The pilot’s failure to maintain clearance from an obstacle while landing on an obstructed helipad, which resulted in a collision and loss of control. Contributing to the accident was the failure of the helipad owner to mark the helipad closed and the failure…NTSB CEN12CA319Accident · Serious injuriesData collectionFinal reportHughes 369HS · Delavan, MNThe pilot’s failure to maintain clearance with power lines during an aerial application flight.NTSB WPR12LA125Accident · No injuriesLimited investigationFinal reportAerospatiale AS 355F1 · Makakilo City, HIA partial loss of engine power while maneuvering over rough/uneven terrain that was precipitated by the failure of a 3rd stage turbine blade as a result of high-cycle fatigue.