# Major NTSB investigations: Allison 250-C20 series

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB SEA05MA202](https://openairdocs.org/ntsb/SEA05MA202.md): Agusta A109A II · Edmonds, WA · Accident · 3 fatal · Major investigation · Final report · Sep 30, 2005 · N655GS · Destroyed
  > Loss of control for an undetermined reason during maneuvering flight, which resulted in an in-flight collision with water.
- [NTSB LAX00MA273](https://openairdocs.org/ntsb/LAX00MA273.md): Aerospatiale AS 355F1 · Kahului, Maui, HI · Accident · 7 fatal · Major investigation · Final report · Jul 21, 2000 · N510TG · Destroyed
  > The pilot's inadequate decision by which he continued visual flight rules flight into instrument meteorological conditions. Also causal was his failure to maintain terrain clearance resulting in a collision with mountainous terrain. A contributing factor was…
- [NTSB LAX86MA311](https://openairdocs.org/ntsb/LAX86MA311.md): Bell 206B · Alamo, CA · Accident · 2 fatal · Major investigation · Final report · Aug 3, 1986 · N49606 · Destroyed
  > Witnesses 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…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
  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
```

This list as a web page: https://openairdocs.org/ntsb?engine=03020&major=1

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.