Fatal NTSB investigations: Allison 250-C20 series, CA

9 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

19842026
Fatal NTSB investigations: Allison 250-C20 series, CA per year, 1984–2026: 9 cases
19841
19861
19891
19921
19951
19971
19991
20061
20221

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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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.

NTSB WPR22FA101Accident · 1 fatalClass 3 · FieldFinal reportMcdonnell Douglas 500N · Newport Beach, CAThe helicopter’s encounter with unanticipated right yaw during a low-altitude, low-airspeed, tight-radius orbit. Contributing to the accident was the pilot’s distraction during the orbit, which resulted in the loss of control, his fatigue due to his early…Feb 20, 2022 · N521HB · Substantial damageNTSB LAX06LA288Accident · 2 fatalLimited investigationFinal reportHughes 369D · Somis, CAThe pilot's inadequate visual lookout, which resulted in a collision with wires.Sep 6, 2006 · N812CE · Substantial damageNTSB LAX00GA025Accident · 2 fatalFinal reportMcDonnell Douglas 500N · San Jose, CAThe pilot's in-flight loss of control due to the failure and separation of the forward thruster control cable telescoping sleeve ball swivel fitting, which resulted in a stuck thruster and the entry into an uncontrollable yaw/spin. Also causal was the…Oct 25, 1999 · N904PD · DestroyedNTSB LAX97GA105Accident · 1 fatalFinal reportMcDonnell Douglas 369D · Santee, CASpatial disorientation and temporary visual impairment that led to a loss of aircraft control as result of difficulty to light adaptivity. Contributing was the crew coordination and inadequate night flight recurrency training.Feb 17, 1997 · N5200Y · Substantial damageNTSB 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…Sep 20, 1995 · N700TH · DestroyedNTSB LAX92FA088Accident · 5 fatalField investigationFinal reportBell 206BIII · Crockett, CAThe pilot's failure to maintain vigilant watch for obstructions while intentionally cruising slowly at a low altitude. A factor was the power line was supported by distant towers, and the line was not conspicuous.Jan 11, 1992 · N95AT · DestroyedNTSB LAX90FA060Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369E · Santa Rosa, CAThe pilot's improper preflight planning/decision which resulted in the loss of tail rotor effectiveness. Contributing to the accident was the pilot allowing the maximum gross weight of the aircraft to be exceeded, and the tailwind.Dec 29, 1989 · N1604L · DestroyedNTSB LAX86MA311Accident · 2 fatalMajor investigationFinal reportBell 206B · Alamo, CAWitnesses reported seeing the helicopter circle twice over a residence at an alt of aprx 50' AGL. Upon initiating the third turn the helicopter entered an abrupt 90 deg bank and nosed down to impact with the terrain. Exam of the helicopter failed to reveal…Aug 3, 1986 · N49606 · DestroyedNTSB LAX85FA036Accident · 2 fatalField investigationFinal reportBell 206B · Beaumont, CAApproximately one min before the accident the pilot contacted the tower at norton air force base for clearance through their traffic area. He reported initially that he was at 300 ft AGL. Seconds later he transmitted that he was at 100 ft over the freeway.…Oct 31, 1984 · N20DB · Destroyed