NTSB investigations: Allison 250-C30 series
13 cases on aircraft whose registry engine model is Allison 250-C30 series, where the first occurrence was “Loss of control - in flight”. 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
| 1984 | 2 |
|---|---|
| 1989 | 1 |
| 1994 | 3 |
| 1998 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 2 |
Where
Latest 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03015')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03015')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 NYC08FA071Accident · 3 fatalField investigationFinal reportBell 206L-3 · Cherokee, ALThe pilot's failure to maintain control of the helicopter during an out-of-ground-effect hover. Contributing to the accident was a loss of tail rotor effectiveness.NTSB DFW07LA169Accident · No injuriesLimited investigationFinal reportBell 206L-3 · High Island 138The loss of control as result of the pilot's failure to maintain rotor RPM during takeoff.NTSB DEN06LA096Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Taos, NMthe loss of tail rotor effectiveness during landing, and the pilot's delayed remedial action to counteract a right yaw, which resulted in a loss of directional control and collision with terrain. A contributing factor was the pilot's failure to perform…NTSB SEA06LA121Accident · Minor injuriesLimited investigationFinal reportBell 206L · Vernal, UTThe loss of tail rotor effectiveness during an attempted precationary landing after a takeoff over uneven, sloping, brush-covered terrain. Factors include the pilot using the wrong performance chart while completing his preflight performance calculations, the…NTSB CHI05CA156Accident · Minor injuriesData collectionFinal reportBell 206L-3 · Algonac, MIThe pilot not maintaining helicopter control, the loss of tail rotor effectiveness he encountered, and his not maintaining clearance from objects during the approach. Factor were the low altitude, the transmission lines, and the garage.NTSB FTW01LA176Accident · No injuriesLimited investigationFinal reportSikorsky SK-76A · New Iberia, LAthe loss of control while maneuvering for undetermined reasons.NTSB FTW98TA328Accident · Minor injuriesFinal reportBell 206L-3 · Reklaw, TXThe pilot's failure to maintain proper alignment in that the external load was not centered during sling operation, which resulted in entanglement of the load with the landing gear, and the loss of aircraft control.NTSB FTW94FA274Accident · No injuriesField investigationFinal reportBell 230 · Albert Lea, MNThe pilot's failure to execute the proper approach and the ensuing settling with power. Factors were the tailwind, and the congestion around the airport.NTSB FTW94GA232Accident · 3 fatalFinal reportBell 206L-3 · Mimbres, NMThe pilot's improper decision to attempt to hover out of ground effect under adverse conditions while exceeding the maximum allowable weight for that maneuver. Factors in the accident were: high density altitude and the tailwind.NTSB FTW94LA071Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Cascade, COThe pilot's improper in-flight planning which resulted in the aircraft's yaw performance being exceeded. A factor was the high density altitude.NTSB DEN89MA130Accident · 4 fatalMajor investigationFinal reportBell 206L-3 · Big Timber, MTFailure of the pilot to maintain control of the aircraft during takeoff, due to spatial disorientation, which resulted in a collision with the terrain. Contributing factors were: dark night, pilot's visual perception, inadequate initial training of the pilot…NTSB DEN85LA053Accident · Minor injuriesLimited investigationFinal reportBell 206-L3 · Jackson, WYPlt had landed on prepared area (snow packed down by heli ski guide) to embark ski passengers. On departure plt lifted to hover, turned to desired hdg and initiated forward transition. As acft passed boundry of packed snow, rotor wash picked up soft loose…NTSB DEN84LA093Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Lake City, COThe helicopter took off in marginal VMC conditions at close to conditions requiring maximum performance for takeoff. The plt attempted to hover at 90 percent RPM waiting he said 'for a breeze'. The hover stirred up snow causing a whiteout and loss of visual…