NTSB investigations: Allison T63 series, CA
11 cases on aircraft whose registry engine model is Allison T63 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
| 1998 | 1 |
|---|---|
| 1999 | 1 |
| 2000 | 1 |
| 2005 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2012 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 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\" = 'CA' 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 ('03031'))
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" = 'CA' 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 ('03031'))
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 WPR22LA140Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Merced, CAThe pilot’s failure to see and avoid wires while conducting an aerial application flight, which resulted in a wire strike and ground impact.NTSB WPR22LA032Accident · No injuriesClass 4 · LimitedFinal reportBell OH-58A · Holtville, CAThe pilot’s failure to maintain helicopter control after becoming spatially disoriented when the helicopter entered low-level haze/fog.NTSB WPR20CA092Accident · No injuriesData collectionFinal reportBell OH 58A · Colexico, CAThe pilot's failure to arrest the descent rate while maneuvering at low altitude, which resulted in impact with terrain.NTSB WPR12LA371Accident · Serious injuriesLimited investigationFinal reportArrow Falcon Exporters OH58 · Escalon, CAThe pilot’s failure to maintain clearance from trees during a low-altitude agricultural application, which resulted in a loss of control and impact with the ground.NTSB WPR12LA096Accident · No injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58A · Brawley, CAThe failure of the main rotor mast due to fatigue cracks that originated from corrosion pits. Contributing to the accident was the operator’s failure to adhere to the manufacturer’s recommended overhaul interval for the main rotor mast.NTSB WPR10LA126Accident · Serious injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58A · Escalon, CAA loss of engine power during cruise flight due to the fatigue failure of the pneumatic fuel-to-governor control line. Also causal was the inadequate installation of the pneumatic line by maintenance personnel, and the pilot’s decision to continue flight with…NTSB LAX08CA054Accident · No injuriesData collectionFinal reportBell OH-58A · Brawley, CAThe pilot's failure to maintain clearance from obstacles. A factor in the accident was the dark night conditions.NTSB LAX05FA264Accident · 1 fatalField investigationFinal reportSan Joaquin Helicopters OH-58A+ · Lancaster, CAThe pinion to turbine shaft coupling failed in fatigue due to a misaligned turbine shaft, which resulted in a loss of engine power.NTSB LAX00LA076Accident · Minor injuriesLimited investigationFinal reportBell OH-58C · Brawley, CAThe fuel system contamination that resulted in a loss of engine power during aerial application and a subsequent collision with the ground.NTSB LAX99LA319Accident · No injuriesLimited investigationFinal reportBell OH58A · Salinas, CAThe pilot's failure to maintain an adequate clearance from all ground obstacles during a low altitude aerial application flight.NTSB LAX98LA134Accident · Minor injuriesLimited investigationFinal reportBell OH-58A · Huron, CAA loss of engine power due to deteriorated O-ring seals in the fuel boost pump, which allowed air to enter the fuel lines. Factors in the accident were the inadequate manufacturer's inspection criteria for the fuel boost pump O-ring seals and the resulting…