NTSB investigations: Allison 250 SER 250HP, 1987
8 cases on aircraft whose registry engine model is Allison 250 SER 250HP. 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
| 1967 | 1 |
|---|---|
| 1968 | 3 |
| 1969 | 4 |
| 1970 | 9 |
| 1971 | 3 |
| 1972 | 9 |
| 1973 | 6 |
| 1974 | 2 |
| 1975 | 4 |
| 1976 | 1 |
| 1977 | 5 |
| 1978 | 2 |
| 1979 | 5 |
| 1980 | 8 |
| 1981 | 13 |
| 1982 | 9 |
| 1983 | 9 |
| 1984 | 10 |
| 1985 | 4 |
| 1986 | 5 |
| 1987 | 8 |
| 1988 | 6 |
| 1989 | 5 |
| 1990 | 10 |
| 1991 | 1 |
| 1993 | 6 |
| 1994 | 6 |
| 1995 | 1 |
| 1996 | 5 |
| 1997 | 3 |
| 1998 | 6 |
| 1999 | 8 |
| 2000 | 4 |
| 2001 | 3 |
| 2002 | 6 |
| 2003 | 6 |
| 2004 | 5 |
| 2005 | 4 |
| 2006 | 6 |
| 2007 | 3 |
| 2008 | 5 |
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 3 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 2 |
| 2019 | 1 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 4 |
| 2025 | 4 |
| 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\") = 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 ('03002', '03003'))
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 ('03002', '03003'))
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 BFO87FA057Accident · 3 fatalField investigationFinal reportBell 206B · Washington, DCThe helicopter was on a LCL photography (sight-seeing) flt. While hovering at aprx 200' abv the potomac river, the eng lost pwr. The plt initiated an autorotation & deployed the emerg floats. Subsequently, the helicopter impacted in the river & rolled ovr,…NTSB FTW87LA194Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Eugene IslandThe acft experienced a main rotor blade strike during takeoff from an offshore platform. The rotor blade struck the underside of a cable raceway on a drilling rig that was situated adjacent to the platform helideck. The raceway was 9 feet laterally and 22…NTSB BFO87LA047Accident · Minor injuriesLimited investigationFinal reportHiller FH-1100 · Capron, VAThe plt made a 60 mph power descent landing apch. When the helicopter descended to a height of about 10 ft AGL, the plt raised collective and applied left rudder pressure. The helicopter abruptly turned right. According to the plt, the helicopter did not…NTSB LAX87LA199Accident · 2 fatalLimited investigationFinal reportHughes 369D · TamuningsA Hughes 369D, operated off of a fishing vessel, went out of control and crashed in the pacific ocean, nr guam. The accident was witnessed by the ship's captain. His statement indicated one of the main rotor blades separated in flt while the helo was orbiting…NTSB MIA87LA133Accident · Minor injuriesLimited investigationFinal reportBell 206L · Miami, FLUnlicensed pilot lost control of helicopter while in hover while attempting to steal the helicopter. The aircraft crashed to earth and rolled over. The pilot was on probation for attempting to steal a helicopter on a previous occasion. The plt received minor…NTSB MIA87LA106Accident · Minor injuriesLimited investigationFinal reportHughes 364HS · Opa Locka, FLThe pilot of the helicopter was executing a normal approach to the ground when as he neared the ground the ventral fin struck the ground. The tail rotor driveshaft re-centered and the pilot thought the accompanying shudder was a tail rotor failure, and landed…NTSB LAX87LA140Accident · No injuriesLimited investigationFinal reportHughes 269D · Palmdale, CADuring an external load operation, the engine lost power. The aircraft collided with the terrain and rolled over. Inspection of the engine revealed an overtemperature to the first and second stage turbine wheel airfoils.NTSB LAX87LA099Accident · No injuriesLimited investigationFinal reportHughes 369D · Lemon Cove, CAThe plt rprtd that while at 100 to 150 ft AGL on an apch to land, the eng lost pwr as though it had flamed out. He entered an autorotation, but was unable to reach the helipad. Subsequently, the helicopter landed in trees & was badly dmgd. Drg the…