OpenAirDocs.org

Fatal NTSB investigations: Allison 250-C20 series

8 cases on aircraft whose registry engine model is Allison 250-C20 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

19842026

Where

Open the map

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.\"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')
      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.

NTSB 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 DEN02FA065Accident · 2 fatalField investigationFinal reportBell 206BIII · Raton, NMThe pilot's failure to maintain clearance of the static wire. Factors were the static wire, and the glaring sunlight condition.Jun 27, 2002 · N2779B · DestroyedNTSB DEN02GA016Accident · 3 fatalFinal reportHughes 369E · Park City, UTthe pilot's inadequate visual lookout, resulting in an inflight collision with powerlines. Contributing factors were the fog and the powerlines.Dec 27, 2001 · N280SP · DestroyedNTSB DEN00FA082Accident · 2 fatalField investigationFinal reportMcDonnell Douglas 369E · Bloomfield, NMThe pilot's intentional buzzing (low level flying), and his failure to maintain clearance with the static wire. A factor was his physical impairment by a contraindicated drug controlled substance.May 2, 2000 · N1606K · DestroyedNTSB NYC95LA009Accident · 1 fatalLimited investigationFinal reportAerospatiale AS-355 · Jonesville, VAThe pilot's failure to maintain clearance from the power lines.Oct 15, 1994 · N5787A · 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 SEA85FA104Accident · 2 fatalField investigationFinal reportHughes 369D · Spokane, WAThe helicopter was on a flt to a tv station to transport a tv camera man & his gear. The regular plt for this trip was unable to fly, so another was retained for the flt. This was his 1st flt to the station. Helicopter operations at the tv station were…May 5, 1985 · N8365F · 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