NTSB investigations: Allison 250 SER 250HP, 1990
10 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\") = 1990
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") = 1990
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 FTW91LA023Accident · No injuriesLimited investigationFinal reportBell 206L-1 · W.Cameron 266Failure of the helicopter's aft landing gear crosstube assembly due to fatigue.NTSB SEA91LA023Accident · No injuriesLimited investigationFinal reportHughes 369D · Mulina, ORIn-flight collision with a rebounding long-line, which caused main-rotor RPM decay and tail-boom separation, compromising the pilot's ability to successfully accomplish an attempted autorotation.NTSB ANC91FA001Accident · Serious injuriesField investigationFinal reportHughes 500D · Kennsington, AKThe loss of control during takeoff due to dynamic rollover. Contributing to the accident was the pilot-in-command's selection of an uneven landing area.NTSB LAX90FA268Accident · No injuriesField investigationFinal reportBell 206B · Quincy, CAAn unidentified contaminate lodged in the fuel governor.NTSB LAX90FA230Accident · No injuriesField investigationFinal reportHughes 369D · Hanapepe, HIFailure of pilot of the photographing helicopter to maintain clearance and avoid collision.NTSB FTW90LA096Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · E. Island Blk15The loss of continuity in the compressor section of the engine due to a fatique failure of the spur adapter gear shaft.NTSB FTW90LA083Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pearland, TXDynamic rollover resultant from improper takeoff techniques used by the rated pilot, and inadequate supervision by the company check pilot.NTSB SEA90TL#01Accident · No injuriesClass 3Final reportBell 206 · Cougar, WANTSB NYC90LA072Accident · Minor injuriesLimited investigationFinal reportBell 206B · Norwood, MAImproper planning/decision by the pilot. The turbulence was a related factor.NTSB CHI90TL#03Accident · Serious injuriesClass 3Final reportBell 206B · Fort Thompson, SD