NTSB investigations: Allison 250-C20 series, 2007
19 cases on aircraft whose registry engine model is Allison 250-C20 series. 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
| 1973 | 2 |
|---|---|
| 1974 | 1 |
| 1975 | 2 |
| 1978 | 1 |
| 1979 | 3 |
| 1980 | 3 |
| 1981 | 5 |
| 1982 | 2 |
| 1983 | 2 |
| 1984 | 7 |
| 1985 | 6 |
| 1986 | 6 |
| 1987 | 6 |
| 1988 | 5 |
| 1989 | 7 |
| 1990 | 6 |
| 1991 | 5 |
| 1992 | 9 |
| 1993 | 7 |
| 1994 | 13 |
| 1995 | 10 |
| 1996 | 10 |
| 1997 | 10 |
| 1998 | 4 |
| 1999 | 16 |
| 2000 | 13 |
| 2001 | 13 |
| 2002 | 14 |
| 2003 | 19 |
| 2004 | 15 |
| 2005 | 14 |
| 2006 | 12 |
| 2007 | 19 |
| 2008 | 5 |
| 2009 | 10 |
| 2010 | 4 |
| 2011 | 4 |
| 2012 | 6 |
| 2013 | 9 |
| 2014 | 11 |
| 2015 | 5 |
| 2016 | 2 |
| 2017 | 9 |
| 2018 | 10 |
| 2019 | 2 |
| 2020 | 5 |
| 2021 | 6 |
| 2022 | 7 |
| 2023 | 3 |
| 2024 | 5 |
| 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\") = 2007
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03020'))
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") = 2007
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03020'))
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 CHI08CA021Accident · Minor injuriesData collectionFinal reportBell 206B-III · Medora, NDThe pilot failed to maintain clearance from the fence while maneuvering at a low altitude, which resuled in the helicopter rolling over and impacting the terrain. A factor associated with the accident was the fence.NTSB SEA07CA256Accident · Minor injuriesData collectionFinal reportRogerson Hiller RH-1100 · Stanwood, WAThe pilot's failure to execute a go-around and his failure to reduce his groundspeed to zero prior to touching down on the rough/uneven terrain. Factors include the momentary restriction of a flight control, rough/uneven terrain, and a tailwind.NTSB LAX07LA270Accident · 1 fatalLimited investigationFinal reportHughes 369D · Ellensburg, WAThe passenger's inadequate visual lookout and failure to maintain clearance from the rotating main rotor disc while the helicopter was hovering. An uphill terrain condition was a factorNTSB NYC07LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Warrenton, VAThe flight instructor's failure to maintain adequate rotor rpm during touchdown.NTSB DEN07LA132Accident · Minor injuriesLimited investigationFinal reportBell 206B · Broomfield, COThe pilot's failure to maintain control of the helicopter, resulting in an inadvertent dynamic rollover.NTSB CHI07CA244Accident · Minor injuriesData collectionFinal reportBell 206B · Columbia, MOThe pilot's failure to maintain control of the helicopter, which resulted in impact with terrain during takeoff. A factor in the accident was the tall grass.NTSB SEA07CA200Accident · Minor injuriesData collectionFinal reportBell 206B II · Sheep Mountain, MTThe external load net, attached directly to the cargo hook without the use of a long line, oscillated and made contact with the tail rotor system while maneuvering.NTSB CHI07LA193Accident · No injuriesLimited investigationFinal reportHughes 369D · Comfrey, MNThe loss of engine power due to the loose pressure line during aerial application maneuvers which resulted in a hard forced landing.NTSB ATL07GA087Accident · Serious injuriesFinal reportBell 206B · Cedartown, GAThe pilot's failure to maintain control of the helicopter while maneuvering. Contributing to the accident were strong gusty winds.NTSB SEA07CA139Accident · No injuriesData collectionFinal reportHughes 369D · Torrance, CAThe pilot's loss of helicopter control while maneuvering at low altitude, which resulted in a hard landing. The wind gusts were a contributing factor.NTSB NYC07LA149Accident · No injuriesLimited investigationFinal reportMesserschmitt BO-105 · Isla de Vieques, PRThe mechanic's failure to secure the engine governor locking hardware, which resulted in the right engine losing power.NTSB LAX07CA177Accident · Minor injuriesData collectionFinal reportMD Helicopters 500-E · Yerington, NVThe failure of the student and instructor to maintain an adequate main rotor rpm, and the instructor’s inadequate in-flight supervision while conducting a low-level simulated emergency procedure, which resulted in a hard landing.NTSB MIA07FA098Accident · 1 fatalField investigationFinal reportHughes 369A · Moulton, ALThe separation of a main rotor blade from its tension torsion bar for an undetermined reason.NTSB DFW07LA109Accident · Minor injuriesLimited investigationFinal reportBell 206B · E. Cameron 219The pilot's failure to establish a climb and maintian directional control of the helicopter while departing the offshore platform.NTSB SEA07LA108Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Kahuku, HIFatigue cracking of the oil line from the engine gearbox to the oil pressure gauge, which resulted in loss of engine lubricating oil, leading to seizure of the power turbine.NTSB NYC07CA084Accident · Minor injuriesData collectionFinal reportBell 206B · Lewes, DEThe pilot's inadequate visual lookout, which resulted in an in flight collision with utility wires during takeoff, and a subsequent impact with terrain.NTSB SEA07CA069Accident · No injuriesData collectionFinal reportBell 206 B3 · Custer, MTThe pilot’s failure to maintain clearance between the tail rotor of his helicopter and a piece of farm equipment during the landing sequence.NTSB ANC07LA022Accident · No injuriesLimited investigationFinal reportHughes 369D · Gustavus, AKThe inadequate clearance from a tranquilized moose while hovering in ground effect, and the operator's inadequate procedures for such operations, which resulted in an in-flight collision with the moose. Factors associated with the accident were the moose, a…NTSB LAX07CA072Accident · Minor injuriesData collectionFinal reportBell Helicopter 206BIII · Springville, CAThe pilot's failure to maintain terrain/obstacle clearance while maneuvering. Factors were the mountainous terrain, trees, and low-altitude flight maneuvers.