NTSB investigations: Allison 250-C30 series
8 cases on aircraft whose registry engine model is Allison 250-C30 series, where the first occurrence was “In flight collision with object”. 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
| 1999 | 2 |
|---|---|
| 2000 | 1 |
| 2002 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 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.\"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\" = 220))
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" = 220))
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 SEA06CA161Accident · No injuriesData collectionFinal reportBell 206L-3 · Salt Lake City, UTThe failure of the pilot to maintain clearance by allowing the helicopter to drift backwards, resulting in its tail rotor striking a hangar.NTSB DFW05CA213Accident · No injuriesData collectionFinal reportBell 206L · Gulf of MexicoThe pilot's failure to maintain clearance with a stationary object while landing.NTSB LAX04CA268Accident · No injuriesData collectionFinal reportMcDonnell Douglas 369FF · Lihue, HIThe pilot misjudging the clearance between the tree and the main rotor blades. Contributing factors to the accident were the high workload of the pilot and his lack of experience with bambi bucket operations.NTSB DEN02LA101Accident · Serious injuriesLimited investigationFinal reportBell 206L-III · Canon City, COthe pilot's failure to maintain clearance of a static wire, and the subsequent loss of aircraft control due to the main rotor pitch change tubes being severed.NTSB NYC02LA083Accident · No injuriesLimited investigationFinal reportBell 206-L3 · New York, NYThe pilot's improper flare while landing, which resulted in a collision with a concrete curb.NTSB SEA00TA182Accident · No injuriesFinal reportBell 206-L4 · Atlanta, IDThe pilot's failure to maintain clearance from an object. Trees and inadequate ground communications were a factor.NTSB SEA00LA020Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Neihart, MTClearance from an object was not maintained. Gusting wind conditions was a factor.NTSB FTW99LA077Accident · No injuriesLimited investigationFinal reportBell 206L-3 · West Delta 105bThe pilot's failure to maintain clearance with the oil platform's windsock on final approach to landing.