NTSB investigations: Allison 250-C20 series, 2005
6 cases on aircraft whose registry engine model is Allison 250-C20 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 | 1 |
|---|---|
| 1985 | 2 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 3 |
| 1991 | 2 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 2000 | 4 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 3 |
| 2004 | 4 |
| 2005 | 6 |
| 2006 | 1 |
| 2007 | 1 |
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 year(c.\"eventDate\") = 2005
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')
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 year(c."eventDate") = 2005
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')
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 SEA05MA202Accident · 3 fatalMajor investigationFinal reportAgusta A109A II · Edmonds, WALoss of control for an undetermined reason during maneuvering flight, which resulted in an in-flight collision with water.NTSB CHI05CA271Accident · No injuriesData collectionFinal reportBell 206B · Elk Point, SDThe loss of directional control for undetermined reasons which led to the pilot not being able to maintain clearance from the embankment during the forced landing. The rising embankment was a factor.NTSB DFW05LA239Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Orleans, LAThe pilot's failure to maintain directional control after encountering a loss of tail rotor effectiveness. A contributing factor was the lack of suitable terrain.NTSB LAX05LA289Accident · Serious injuriesLimited investigationFinal reportBell 206B · Long Beach, CAthe pilot's decision not to release the banner when it became entangled on itself, which resulted in the banner tow rope becoming ensnarled with the tail rotor system.NTSB DFW05LA252Accident · Minor injuriesLimited investigationFinal reportBell 206B · Myrtle Grove, LAThe pilot's loss of control in flight for undetermined reasons.NTSB DFW05FA086Accident · 3 fatalField investigationFinal reportBell 206B-3 · Shelbyville, TXThe pilot's failure to maintain altitude and clearance for undetermined reasons.