NTSB investigations: Allison 250-C20 series
17 cases on aircraft whose registry engine model is Allison 250-C20 series, where the first occurrence was “In flight collision with terrain/water”. 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 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1999 | 3 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 3 |
| 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 ('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\" = 230))
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 ('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" = 230))
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 SEA06TA071Accident · No injuriesFinal reportBell 206B · Sprague, WAThe pilot's failure to maintain clearance from mountainous terrain while maneuvering. Mountainous terrain was a factor.NTSB SEA05CA200Accident · Minor injuriesData collectionFinal reportMcDonnell Douglas 369E · Medford, ORIn-flight collision with terrain during a precautionary landing. Factors include instrument meteorological conditions and pilot disorientation.NTSB MIA05LA088Accident · 1 fatalLimited investigationFinal reportSchweizer 269D · Atlantic Ocean (Atlantic Ocean)An inflight collision with the ocean for undetermined reasons.NTSB DFW05TA056Accident · Minor injuriesFinal reportSchweizer 269D · San Antonio, TXThe inadequate supervision and delayed remedial action by the flight instructor, which resulted in an inadvertent dynamic rollover.NTSB FTW04TA237Accident · 1 fatalFinal reportBell OH-58C · Beaumont, TX**This probable cause was modified on 2/22/2016. Please see the public docket for this accident for additional details.** The pilot's failure to maintain a safe altitude, resulting in collision with the water. A factor was the dark night.NTSB CHI04LA017Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Evansville, MNThe pilot's misjudgment of clearance from the surface of the lake during the aerial application pass. The low altitude operation, glassy water, and his visual perception were contributing factors.NTSB FTW02LA143Accident · Serious injuriesLimited investigationFinal reportBell 206B · Rosenberg, TXThe pilot's failure to maintain terrain clearance.NTSB SEA02FA008Accident · 3 fatalField investigationFinal reportBell 206L · Anchorage, AKThe pilot's failure to maintain clearance from the surface of an open body of water while intentionally attempting to maintain a very low altitude while in cruise flight. Factors include falling snow, low ceilings, whiteout/greyout conditions, and flat/glassy…NTSB CHI01LA327Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · Park Rapids, MNThe pilot not maintaining altitude/clearance when he maneuvered above the glassy lake. A factor to the accident was the glassy lake condition.NTSB CHI00FA020Accident · 2 fatalField investigationFinal reportBell 206B · Cottage Grove, MNUndetermined.NTSB LAX99LA292Accident · 2 fatalLimited investigationFinal reportHughes 369HS · Pohnpei (Pacific Ocean)An in-flight collision with the water for undetermined reasons.NTSB NYC99LA147Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · Tinicum, PAThe pilot's failure to maintain a proper altitude above the water.NTSB CHI97LA008Accident · No injuriesLimited investigationFinal reportHughes 369E · Hesston, KSthe pilot selected unsuitable terrain for landing. The factors involved were: an inoperative landing light, dusk light conditions, and the terrain condition.NTSB LAX95FA339Accident · 1 fatalField investigationFinal reportBell 206L-1 · Irvine, CAthe pilot's intentional VFR flight into IMC conditions and failure to maintain an adequate terrain clearance altitude, and the local controller's improper use of ATC procedure/technique. Factors in the accident were the helicopter's low fuel state and lack of…NTSB LAX93LA249Accident · No injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe failure of the pilot to maintain adequate ground obstruction clearance while engaged in a cattle herding operation.NTSB LAX87LA310Accident · Minor injuriesLimited investigationFinal reportBell 206B · Kailua-Kona, HIAs the helicopter was climbing over rising terrain at 300' to 400' AGL, the plt noted altimeter & airspeed indcns of 8700' & 60 mph. After climbing an adnl 2 min to aprx 10,000' (12,000' density alt), he noticed the rotor RPM was bleeding off. He made a 180…NTSB ANC82DA062Accident · 1 fatalFinal reportHughes 369D · Near Bornite, AKTwo workers were transported to a mine drilling site where the helicopter was landed on a man-made heli-pad. The heli-pad was an area about 50 ft long and 12 ft wide that had been cut into the side of a rocky hill. After off-loading the workers, the pilot…