NTSB investigations: Allison 250-C20 series, 2005
14 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\") = 2005
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") = 2005
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 LAX06LA015Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Avalon, CAthe pilot's failure to maintain an adequate visual lookout and obstacle clearance altitude, which resulted in a collision with power lines. Factors in the accident were the position of the sun relative to the helicopter's flight path, which lessoned the…NTSB SEA05MA202Accident · 3 fatalMajor investigationFinal reportAgusta A109A II · Edmonds, WALoss of control for an undetermined reason during maneuvering flight, which resulted in an in-flight collision with water.NTSB SEA05CA200Accident · Minor injuriesData collectionFinal reportMcDonnell Douglas 369E · Medford, ORIn-flight collision with terrain during a precautionary landing. Factors include instrument meteorological conditions and pilot disorientation.NTSB CHI05CA271Accident · No injuriesData collectionFinal reportBell 206B · Elk Point, SDThe loss of directional control for undetermined reasons which led to the pilot not being able to maintain clearance from the embankment during the forced landing. The rising embankment was a factor.NTSB DFW05LA239Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Orleans, LAThe pilot's failure to maintain directional control after encountering a loss of tail rotor effectiveness. A contributing factor was the lack of suitable terrain.NTSB LAX05LA289Accident · Serious injuriesLimited investigationFinal reportBell 206B · Long Beach, CAthe pilot's decision not to release the banner when it became entangled on itself, which resulted in the banner tow rope becoming ensnarled with the tail rotor system.NTSB DFW05LA252Accident · Minor injuriesLimited investigationFinal reportBell 206B · Myrtle Grove, LAThe pilot's loss of control in flight for undetermined reasons.NTSB DFW05CA172Accident · Serious injuriesData collectionFinal reportGarlick Helicopters OH-58A+ · Graham, TXThe pilot's failure to maintain clearance with the wire while maneuvering during an aerial application flight. Low altitude flight is a contributing factor.NTSB MIA05LA095Accident · Serious injuriesLimited investigationFinal reportBell 206B · Coral Springs, FLThe pilot encountered dynamic rollover while lifting off from an area in the everglades with 6-7 foot tall sawgrass nearby.NTSB MIA05LA088Accident · 1 fatalLimited investigationFinal reportSchweizer 269D · Atlantic Ocean (Atlantic Ocean)An inflight collision with the ocean for undetermined reasons.NTSB ANC05CA049Accident · No injuriesData collectionFinal reportBell 206B · Elim, AKThe pilot's continued flight into adverse weather conditions, and his failure to maintain adequate clearance while maneuvering, which resulted in an in-flight collision with terrain. Factors associated with the accident are flat light, whiteout conditions,…NTSB DFW05FA086Accident · 3 fatalField investigationFinal reportBell 206B-3 · Shelbyville, TXThe pilot's failure to maintain altitude and clearance for undetermined reasons.NTSB NYC05CA047Accident · No injuriesData collectionFinal reportBell 206B · Lancaster, PAThe pilot's loss of lateral control while attempting to transition to a hover from the ground. A factor was the bright sunlight conditions.NTSB DFW05TA056Accident · Minor injuriesFinal reportSchweizer 269D · San Antonio, TXThe inadequate supervision and delayed remedial action by the flight instructor, which resulted in an inadvertent dynamic rollover.