NTSB investigations: Allison 250 SER 250HP, CA
19 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 | 1 |
| 1970 | 1 |
| 1972 | 2 |
| 1980 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 2006 | 1 |
| 2008 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2025 | 1 |
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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
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 WPR25LA078Accident · No injuriesClass 4 · LimitedFinal reportBell 206A · Lemoore, CAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.NTSB WPR16LA125Accident · No injuriesLimited investigationFinal reportBell 206 · Bishop, CAThe pilot’s improper preflight weather planning, fuel planning, and fuel management, which resulted in fuel starvation and a loss of engine power. Contributing to the severity of the accident was the pilot's initiation of the landing flare at a high altitude,…NTSB WPR13FA119Accident · 3 fatalField investigationFinal reportBell 206B · Acton, CAThe pilot's decision to conduct a flight in dark night conditions with an illuminated cockpit light that degraded his visibility and his ability to identify and arrest the helicopter's descent while maneuvering, which resulted in controlled flight into…NTSB WPR12LA426Accident · No injuriesLimited investigationFinal reportBell 206 - B · Mammoth Lakes, CAThe pilot’s inability to maintain sufficient main rotor rpm while maneuvering in high density altitude conditions, which resulted in a precautionary landing and subsequent rollover.NTSB SEA08CA091Accident · No injuriesData collectionFinal reportBell 206B · Oxnard, CAThe pilot's failure to maintain clearance with terrain during an aerial application.NTSB LAX06LA220Accident · Minor injuriesLimited investigationFinal reportBell 206B · Chino Hills, CAA loss of aircraft control for undetermined reasons.NTSB LAX95LA310Accident · No injuriesLimited investigationFinal reportBell 206BIII · Carmel Valley, CAthe pilot's failure to maintain an adequate clearance from obstructions while hovering.NTSB LAX90FA268Accident · No injuriesField investigationFinal reportBell 206B · Quincy, CAAn unidentified contaminate lodged in the fuel governor.NTSB LAX88LA304Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Barrett Junct., CAWhile descending into a canyon, the aircraft struck powerlines, went into an uncontrolled descent and collided with the terrain. The pilot stated that he could not see the powerlines and that his visibility was restricted by the sun. All four passengers…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…NTSB LAX86LA226Accident · Minor injuriesLimited investigationFinal reportBell 206B · Los Angeles, CADuring a x-wind takeoff the downwind skid contacted the landing pad and the helicopter rolled over to the right. One person on the ground was injured by flying debris.NTSB LAX82FA014Accident · 1 fatalClosedBell 206B · Napa, CANTSB LAX80DVG39Accident · Minor injuriesClosedHughes 369D · Yountville, CANTSB OAK73DVM05Accident · Minor injuriesClosedBell 206B · Salinas, CANTSB LAX72FUG63Accident · No injuriesClosedBell 206A · La Verne, CANTSB OAK71DVG45Accident · No injuriesClosedHiller Acft FH1100 · Burney, CANTSB OAK69D0208Accident · Serious injuriesClosedHiller Acft FH1100 · Storrie, CANTSB LAX68A0009Accident · No injuriesClosedBell 206A · Carpinteria, CA