NTSB investigations: Allison 250 SER 400HP, 1986
5 cases on aircraft whose registry engine model is Allison 250 SER 400HP. 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
| 1969 | 2 |
|---|---|
| 1972 | 3 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 7 |
| 1976 | 7 |
| 1977 | 9 |
| 1978 | 8 |
| 1979 | 10 |
| 1980 | 16 |
| 1981 | 6 |
| 1982 | 7 |
| 1983 | 5 |
| 1984 | 3 |
| 1985 | 8 |
| 1986 | 5 |
| 1987 | 8 |
| 1988 | 3 |
| 1989 | 7 |
| 1990 | 7 |
| 1991 | 5 |
| 1992 | 2 |
| 1993 | 5 |
| 1994 | 3 |
| 1995 | 5 |
| 1996 | 7 |
| 1997 | 7 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 3 |
| 2001 | 5 |
| 2002 | 2 |
| 2003 | 6 |
| 2004 | 5 |
| 2005 | 4 |
| 2006 | 1 |
| 2007 | 4 |
| 2008 | 2 |
| 2009 | 2 |
| 2010 | 4 |
| 2011 | 4 |
| 2013 | 2 |
| 2015 | 5 |
| 2016 | 4 |
| 2018 | 1 |
| 2019 | 1 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 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\") = 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 ('03013', '03012'))
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 ('03013', '03012'))
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 FTW87LA016Accident · Minor injuriesLimited investigationFinal reportBell 206L · Galveston, TXThe plt was attempting to hover in a tailwind of 35 KTS which exceeded the acft manufacturers performance limitiations for operations in allowable relative wind. The plt lost control of the acft on lift-off. The acft rolled over and came to rest on its right…NTSB FTW86LA130Accident · Serious injuriesLimited investigationFinal reportBell 206B · Conroe, TXThe pilot reported that he lost tail rotor control during the transition part of the takeoff. As the helicopter rotated to the right, the pilot reduced power and pulled in collective before impact. Examination of the tail rotor showed no evidence of any tail…NTSB LAX86FJA02Accident · 1 fatalFinal reportBell 206B · Pacific Ocean (Pacific Ocean)The plt was attempting to take off from the deck of a tuna boat when it contacted the side of the boat and sank in the Ocean. Post accident inspection revealed one of two nose tiedown straps had not been removed from the helicopter prior to the takeoff. The…NTSB DEN86LA151Accident · Minor injuriesLimited investigationFinal reportBell 206B · Portal, NDThe plt reported that the acft hit wires at the end of a swath run. The pitch change link broke when the main rotor contacted the wires and the plt attempted to land. After touchdown, the helicopter rolled onto its side.NTSB FTW86LA041Accident · Minor injuriesLimited investigationFinal reportHughes 369D · New Boston, TXThe pilot experienced a tail rotor drive shaft flexible coupling failure when he pulled collective pitch to come to a hover before landing. The helicopter entered an uncontrollable right spin. During his haste to get the helicopter on the ground the pilot…