NTSB investigations: Allison 250 SER 250HP, 1983
9 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\") = 1983
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") = 1983
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 DEN84FA038Accident · Serious injuriesField investigationFinal reportBell 206B · Ft. Morgan, COThe helicopter was owned & operated by a tv station & was being used for transportation to a news event. While en route, clouds & reduced visibility due to fog were encountered. The plt elected to land in a field covered with powdered snow. During the…NTSB FTW84LA081Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Ardmore, OKThe plt stated that before he took off from Oklahoma city, OK, he called the Oklahoma city fss & obtained a wx briefing. The briefing called for light rain showers, minimum ceiling of 1800 ft, visibility of 3 to 5 miles & no chance of fog, except in low lying…NTSB NYC84FA009Accident · 1 fatalField investigationFinal reportBell 206B III · Hudson, NHThe plt was on a flt to pick up film for a tv station. While en route, he made a mayday call to the manchester control tower. According to witnesses, the acft was proceeding in a northerly direction at about 700 to 1000 ft AGL when they heard a 'muffled pop.'…NTSB SEA83LA205Accident · Minor injuriesLimited investigationFinal reportHughes 369B · Cougar, WAThe aircraft collided with trees and terrain during a forced landing attempt following an in-flight power loss. Subsequent engine teardown revealed failure of several components.NTSB DEN83LA200Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Tucker, UTThe helicopter was being used on a seismic data acquistion operation. While landing by a road in mountainous terrain at an elevation of aprx 8400 ft, the helicopter was observed to approach to a hover over the roadway. A considerable amount of dust was blown…NTSB ANC83LA138Accident · No injuriesLimited investigationFinal reportHughes 369D · Mcgrath, AKThe plt stated that he was flying straight & level at aprx 700 ft AGL, when the eng-out light illuminated. He began an autorotation to a ridgeline. During the landing, the main rotor blades contacted the tail boom & severed it from the main fuselage. An…NTSB FTW83LA132Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Shipshoal 295Reportedly, the winds were variable a 2 to 4 KTS as the plt began his approach to an off-shore oil rig. He stated that he chose to terminate the landing from a 4 ft hover. At aprx 15 ft above & 5 ft short of the helipad, the helicopter began to drop at an…NTSB ANC83FA032Accident · 1 fatalField investigationFinal reportBell 206B · Cordova, AKThe helicopter was on a rescue/recovery flt for the Alaska state troopers with the plt & a state trooper on board. They departed in variable wx conditions to rescue the plt of another acft. Reportedly, snow was falling in the search area & the winds were…NTSB SEA83FA040Accident · No injuriesField investigationFinal reportBell 206B · Newport, ORThe helicopter was lifting off when the left skid stuck in the dirt. The acft did a dynamic rollover when the left skid remained stuck as the pilot attempted to takeoff. The pilot had just on-loaded two passengers both on the left side. Weather was not a…