NTSB investigations: Allison 250 SER 400HP, 1987
8 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\") = 1987
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") = 1987
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 LAX88LA059Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Lihue, Kauai, HIPilot failure to maintain adequate main rotor RPM.NTSB SEA88LA016Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Turner, ORWhile on a short cross country flight the pilot encountered a rain storm and low clouds. The pilot made a 180 degree turn and then elected to make a precautionary landing in a field. Although the pilot visually inspected the area prior to landing, he did not…NTSB FTW87FA198Accident · No injuriesField investigationFinal reportBell 206B · Pledger, TXWhile cruising at 900' AGL, the plt noted a hvy shudder flwd by a grinding noise, loud 'bang' & a low rotor RPM signal. He made an autorotation to a road, but drg touchdown, the main rotor blades flexed dwn & severed the tail boom. An exam revealed the main…NTSB LAX87LA179Accident · Minor injuriesLimited investigationFinal reportBell 206B-II · Yucaipa, CAA Bell 206B went out of control and crashed while lndg at a 5,720 ft high helipad. The plt indicated that he terminated the aprch at a 8-10 ft hover and began to spin to the right with full left pedal applied. After 1 1/2 to 2 turns the plt atmptd to fly out…NTSB SEA87LA079Accident · No injuriesLimited investigationFinal reportHughes 369HS · Yakima, WASix miles from the airport, at cruise, the engine ceased operating due to fuel exhaustion. The plt had noticed the low fuel warning light on 10 minutes prior to the engine failure but elected to continue his flight. Autorotation was made from 1,000 feet AGL…NTSB MKC87IA070Incident · No injuriesIncident investigationFinal reportAgusta A109 · Lincoln, NEThe PIC stated that he was ground taxiing the helo to the ramp area at duncan aviation to shutdown for refueling. During the taxi, the PIC heard a loud 'bang' eminating fm the rear of the helo. The PIC lowered collective pitch and no further noise was heard…NTSB LAX87LA161Accident · 1 fatalLimited investigationFinal reportBell 206B · Kona, HIThe pilot picked up two of the passengers at a resort hotel and then flew to kailua-Kona airport (koa). After hot refueling the helicopter with the two passengers on board, two more passengers boarded the helicopter and then the flight departed koa. When the…NTSB SEA87LA059Accident · No injuriesLimited investigationFinal reportBell 206B-III · Dayton, WAPlt lifted off with fertilizer bucket on 3-FT external hook. As fwd motion commenced, acft settled slightly, dragging bucket on ground and tipping it over. Plt attempted to recover by backing up, but skid caught on bucket, causing loss of control.