NTSB investigations: Allison 250-C20 series, AZ
7 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
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1999 | 1 |
| 2000 | 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\" = 'AZ' 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 ('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 c."eventStateOrRegion" = 'AZ' 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 ('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 LAX00LA156Accident · No injuriesLimited investigationFinal reportBell 407 · Grand Canyon, AZThe failure and subsequent disintegration of the oil cooler fan forward hanger bearing.NTSB LAX99FA136Accident · 1 fatalField investigationFinal reportBell 206B · Grand Canyon, AZThe failure of the flight crew to properly preflight the helicopter and to detect and remove accumulated snow from the engine inlets and plenum chamber. Factors in the accident were the clouded plenum chamber inspection window and the failure of preceding…NTSB LAX92T#A03Accident · No injuriesClass 3Final reportMcdonnell Douglas 369D · Mesa, AZNTSB LAX90T#A08Accident · No injuriesClass 3Final reportBell 206B · San Carlos, AZNTSB LAX87LA157Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Phoenix, AZDuring factory flt training, prior to delivery of the new helicopter to the owner, the CFI said he asked the student to perform a series of emergency procedures which included quick stops from an initial takeoff followed by hovering autorotations. The CFI…NTSB LAX86FA106Accident · 1 fatalField investigationFinal reportBell 206B · Young, AZThe plt & his daughter planned to fly to their ranch for the purpose of hiring a manager. Upon arriving at their destination ground fog prevailed. The plt, familiar with the area, attempted to find an area where he could descend below the fog. The fog was at…NTSB LAX84FA405Accident · 2 fatalField investigationFinal reportHughes 369D · Mesa, AZThe helicopter experienced a main rotor drive system disconnect, an uncontrolled descent & subsequent inflight collision with terrain in a hilly desert area. This was the third & last in a planned series of marketing demo flts conducted for three USMC…