Fatal NTSB investigations: Allison 250-C20 series, 2000
4 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
| 1982 | 2 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 5 |
| 2000 | 4 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 2 |
| 2009 | 1 |
| 2010 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 1 |
| 2017 | 1 |
| 2018 | 4 |
| 2021 | 3 |
| 2022 | 1 |
| 2024 | 1 |
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\") = 2000
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2000
AND c."highestInjuryLevel" = 'Fatal'
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 MIA01FA006Accident · 1 fatalField investigationFinal reportAerospatiale AS-355-F2 · Burlington, NCThe mechanics failure to comply with manufacturers instructions for correction of a illuminated main rotor gearbox oil pressure warning light resulting in the helicopter being dispatched on a ferry flight with a failed main rotor gearbox oil pump, failure of…NTSB LAX00MA273Accident · 7 fatalMajor investigationFinal reportAerospatiale AS 355F1 · Kahului, Maui, HIThe pilot's inadequate decision by which he continued visual flight rules flight into instrument meteorological conditions. Also causal was his failure to maintain terrain clearance resulting in a collision with mountainous terrain. A contributing factor was…NTSB DEN00FA082Accident · 2 fatalField investigationFinal reportMcDonnell Douglas 369E · Bloomfield, NMThe pilot's intentional buzzing (low level flying), and his failure to maintain clearance with the static wire. A factor was his physical impairment by a contraindicated drug controlled substance.NTSB FTW00FA091Accident · 4 fatalField investigationFinal reportEurocopter BO105S-CBS-5 · Dalhart, TXThe pilot's failure to maintain control of the helicopter as a result of his continued flight into known adverse weather conditions. Factors were the dark night light condition, fog, low ceiling, and the pilot's lack of total instrument flight time.