NTSB investigations: Allison 250-C20 series, 1996
10 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\") = 1996
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") = 1996
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 SEA97LA032Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Forks, WAfuel contamination, which resulted in loss of engine power. Factors relating to the accident included: improper servicing of the helicopter, and a lack of suitable terrain for an emergency landing due to the proximity of trees.NTSB FTW97LA030Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Creole, LAthe pilot's inadequate preflight by failing to remove the 100 foot long line and the external cargo basket from the helicopter before takeoff, and/or his failure to ensure that clearance/altitude was maintained from the fence.NTSB CHI97LA008Accident · No injuriesLimited investigationFinal reportHughes 369E · Hesston, KSthe pilot selected unsuitable terrain for landing. The factors involved were: an inoperative landing light, dusk light conditions, and the terrain condition.NTSB MIA96TA236Accident · No injuriesFinal reportBell 206B III · Flamingo, FLthe wire strike protection guide became entangled in a mangrove branch which resulted in helicopter control not being maintained.NTSB SEA96LA165Accident · 1 fatalLimited investigationFinal reportBell 206B · Warren, IDthe pilot's improper remedial action after helicopter's right skid became snagged by a log that was used in the construction of a temporary landing site. Factors relating to the accident were: the pilot's selection of an unsuitable landing area, inadequate…NTSB ANC96TA092Accident · No injuriesFinal reportHughes 369D · Ketchikan, AKThe pilot's failure to maintain control of the helicopter. The pilot's selection of unsuitable terrain for landing was a factor in the accident.NTSB FTW96LA274Accident · No injuriesLimited investigationFinal reportHughes 369HE · Las Cruces, NMthe pilot's failure to maintain clearance between the tail rotor and a fence while hovering.NTSB FTW96LA147Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · Houma, LAthe pilot's attempted maneuver which exceeded the dynamic capability of the helicopter.NTSB LAX96LA104Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kamuela, HIfailure of the nose case (No.1) bearing resulting in oil starvation.NTSB MIA96WA070Accident · Minor injuriesForeign investigationBell 206 · Exuma, Bahamas