NTSB investigations: Allison 250-C20 series, 2006
12 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\") = 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 ('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") = 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 ('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 LAX07CA034Accident · No injuriesData collectionFinal reportBell 206B · Boulder City, NVthe pilot's inadequate planning and decision in his failure to reduce the engine throttle to ground idle prior to exiting the helicopter.NTSB LAX06LA288Accident · 2 fatalLimited investigationFinal reportHughes 369D · Somis, CAThe pilot's inadequate visual lookout, which resulted in a collision with wires.NTSB LAX06TA259Accident · No injuriesFinal reportHughes 369D · Lahaina, HIthe pilot's failure to shut down the engine prior to exiting the helicopter resulting in the tail rotor contacting the ground. A contributing factor was the gusting wind conditions present at the accident site.NTSB ANC06CA122Accident · No injuriesData collectionFinal reportBell 206B · Orlando, FLThe pilot's failure to refuel the helicopter prior to the accident flight, which resulted in a loss of engine power during cruise flight, and a hard landing.NTSB NYC06TA190Accident · Minor injuriesFinal reportMD Helicopter 500N · Louisville, KYThe pilot's failure to maintain control of the helicopter and the flight instructor's inadequate supervision, which resulted in a hard landing and subsequent rollover.NTSB SEA06LA135Accident · No injuriesLimited investigationFinal reportHughes 369D · Moab, UTThe failure of the collective bungee support bracket due to non-compliance with a service information notice, which resulted in the pilot executing a precautionary autorotative landing. A contributing factor was the lack of suitable terrain for the landing.NTSB DEN06LA080Accident · No injuriesLimited investigationFinal reportGarlick Helicopters OH- 58C · Muddy Gap, WYthe loss of engine power for reasons undetermined. Contributing to the accident was the low altitude and rough uneven terrain.NTSB NYC06LA122Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Mattituck, NYA loss of engine power due to undetermined reasons.NTSB LAX06LA161Accident · Minor injuriesLimited investigationFinal reportBell 206B3 · Fallbrook, CAFailure of the engine to transmission drive shaft forward coupling due to overheating from lack of lubrication. The cause of the lack of lubrication was a result of improper maintenance. A factor was the trees.NTSB DFW06CA112Accident · No injuriesData collectionFinal reportBell 206B · Vinita, OKThe pilot's improper pre-flight planning, which resulted in a total loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA06TA071Accident · No injuriesFinal reportBell 206B · Sprague, WAThe pilot's failure to maintain clearance from mountainous terrain while maneuvering. Mountainous terrain was a factor.NTSB MIA06LA044Accident · Minor injuriesLimited investigationFinal reportMBB BO-105S · Ponce, PRA loose B-nut on the PC line connecting the power turbine governor (PTGOV) to the fuel control unit (FCU) that created a leak and caused the engine to roll back to an idle condition, causing a low hydraulic system pressure and subsequent control lock. A…