NTSB investigations: Allison 250-C20 series, 1994
13 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\") = 1994
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") = 1994
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 ANC95LA014Accident · No injuriesLimited investigationFinal reportBell 206B · Kenai, AKThe pilot's failure to follow the information in the flight manual concerning the use of the particle separator kit and deflector kit when operating in falling snow. Factors were the rough terrain in the forced landing area and no installation of the…NTSB SEA95LA013Accident · No injuriesLimited investigationFinal reportHiller UH-12E4 · Morton, WAA leak in the fuel filler cap and water in the fuel system. A factor to the accident was: inadequate preflight.NTSB NYC95LA009Accident · 1 fatalLimited investigationFinal reportAerospatiale AS-355 · Jonesville, VAThe pilot's failure to maintain clearance from the power lines.NTSB LAX94LA352Accident · Minor injuriesLimited investigationFinal reportHughes 369E · Volcano, HIthe pilot's failure to maintain adequate main rotor rpm and the resultant inadvertent skid contact with the ground.NTSB FTW94T#A01Accident · No injuriesClass 3Final reportBell 206A · Estes Park, CONTSB LAX94LA241Accident · No injuriesLimited investigationFinal reportHughes 369D · Kaneohe, HIthe operator's and pilot's failure to ensure that the cargo net containing empty paper bags was sufficiently ballasted to prevent it from flying up into the tail rotor.NTSB MIA94LA144Accident · Minor injuriesLimited investigationFinal reportBell 206B · St. Petersburg, FLThe failure of the number five bearing, shaft, or thomas coupling for undetermined reasons. Contributing to the accident was the pilot-in-command's delayed response in conducting the emergency procedure by not reducing the throttle to idle position, and…NTSB SEA94LA109Accident · Minor injuriesLimited investigationFinal reportBell 206B · Summerville, ORThe pilot did not maintain clearance from the wires. The overcast sky condiiton was a factor.NTSB MIA94LA116Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mayaguez, PRLoss of engine power for undetermined reasons which resulted in a descent and ditching.NTSB SEA94LA094Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Rimrock, WAFuel exhaustion, the pilot in command's failure to refuel the aircraft, and the inability to successfully execute an auto- rotation landing because of the low altitude.NTSB FTW94LA110Accident · No injuriesLimited investigationFinal reportBell 206B · Belen, NMThe hard landing due to a delayed flare and improper touchdown. A factor was the loss of engine power.NTSB MIA94WA094Accident · Serious injuriesForeign investigationBell 206BIII · Corozal, HondurasNTSB FTW94LA061Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Mason, TXLoss of aircraft control for an undetermined reason.