NTSB investigations: Allison 250-C20 series, 1986
6 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\") = 1986
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") = 1986
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 LAX87DUM01Accident · No injuriesFinal reportBell UH-1B · Calipatria, CADuring the initial climb at the beginning of an aerial application flight, the pilot made a climbing 180 degree right turn in the reverse direction when the rotor RPM began to drop. The pilot continued to raise collective, lost directional control and…NTSB NYC87LA030Accident · Serious injuriesLimited investigationFinal reportBell 206B · Staten Island, NYThe on-demand cargo flight encountered a bird strike enroute from new jersey to jamaica, new york. The pilot received serious injury to the eye and checkbone but was able to accomplish an emergency landing in a parking lot without further damage or injury.NTSB LAX86MA311Accident · 2 fatalMajor investigationFinal reportBell 206B · Alamo, CAWitnesses reported seeing the helicopter circle twice over a residence at an alt of aprx 50' AGL. Upon initiating the third turn the helicopter entered an abrupt 90 deg bank and nosed down to impact with the terrain. Exam of the helicopter failed to reveal…NTSB LAX86LA155Accident · No injuriesLimited investigationFinal reportBell 206B · Huntington Bch, CAA Bell 206B collided with a berm after an eng failure while departing a helipad. The plt indicated he had just departed the helipad at night and at aprx 50 ft AGL the eng failed. The acft vertical fin hit the berm causing the tail boom to bend aft of the…NTSB LAX86FA106Accident · 1 fatalField investigationFinal reportBell 206B · Young, AZThe plt & his daughter planned to fly to their ranch for the purpose of hiring a manager. Upon arriving at their destination ground fog prevailed. The plt, familiar with the area, attempted to find an area where he could descend below the fog. The fog was at…NTSB LAX86LA091Accident · Minor injuriesLimited investigationFinal reportBell 206B-3 · Waimea, HIWhile on a local flt, the plt descended to aprx 500 ft AGL and flew the helicopter along a coastal area. He reported the helicopter suddenly lost power and he initiated an autorotative landing to the beach where the helicopter 'had a hard landing.' An exam…