NTSB investigations: Allison 250-C28 series, LA
7 cases on aircraft whose registry engine model is Allison 250-C28 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
| 1982 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2007 | 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\" = 'LA' 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 ('03022', '03021'))
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" = 'LA' 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 ('03022', '03021'))
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 CEN25FA281Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron 206L-1 · Thibodaux, LAThe pilot’s failure to maintain clearance to powerlines during an agricultural application pass.NTSB DFW08FA053Accident · 1 fatalField investigationFinal reportBell 206L1 · Venice, LAThe pilot’s decision to continue to the destination landing platform in weather conditions below the company’s weather minimums and his failure to maintain aircraft control during the approach. Contributing to the passenger fatality and the severity of the…NTSB DFW05CA088Accident · Serious injuriesData collectionFinal reportBell B-206L-1 · Galliano, LAThe pilot's abrupt input of the collective while the main rotor RPM was at idle, which resulted in a separation of the tail boom.NTSB CHI03FA056Accident · 1 fatalField investigationFinal reportBell 206L-1 · B.S. 53, LAThe improper approach by the pilot and the settling with power encountered by the pilot.NTSB FTW88DRD10Accident · No injuriesFinal reportBell 206L-1 · Houma, LAShortly after liftoff, the helicopter experienced a power loss at 300 feet. During the emergency landing in a wet swampy area with very high vegetation, the helicopter landed hard, and the main rotor blades struck the tailboom. At a post accident inspection,…NTSB FTW87LA195Accident · No injuriesLimited investigationFinal reportBell 206L-1 · New Iberia, LACrew performing practice touchdown autorotations during a trng flt. On 4th autorotation, acft touched down with excess grnd speed and skidded for approx 75' on the wet, soft grass. When crew applied power back to flight RPM they heard a grinding sound and…NTSB FTW82DA144Accident · No injuriesFinal reportBell 206L-1 · Cameron, LAN2138Y departed Cameron, LA after refueling en route to an offshore rig. Shortly after departure, while over water, the aircraft began to yaw and vibrate severely. The pilot stated that the tail rotor pedals "kicked" hard when additional power was applied.…