# Major NTSB investigations: Collision between aircraft (other than midair)

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 CHI05MA111](https://openairdocs.org/ntsb/CHI05MA111.md): McDonnell Douglas DC-9-51 · Minneapolis, MN · Accident · Serious injuries · Major investigation · Final report · May 11, 2005 · N763NC · 2 aircraft · Substantial damage
  > the Captain of the other aircraft's decision to shutdown the left engine during taxi with no hydraulic pressure on the right side hydraulic system to effectively operate the brakes, steering, or thrust reversers. A factor was the fatigue fracture of the…
- [NTSB DCA97MA009](https://openairdocs.org/ntsb/DCA97MA009.md): Beech 1900C · Quincy, IL · Accident · 14 fatal · Class 1 · Major · Final report · Nov 19, 1996 · N87GL · 2 aircraft · Destroyed
  > the failure of the pilots in the King Air A90 to effectively monitor the common traffic advisory frequency or to properly scan for traffic, resulting in their commencing a takeoff roll when the Beech 1900C (United Express flight 5925) was landing on an…
- [NTSB CHI95MA044](https://openairdocs.org/ntsb/CHI95MA044.md): Mcdonnell Douglas DC-9-82 · Bridgeton, MO · Accident · 2 fatal · Class 1 · Major · Final report · Nov 23, 1994 · N954U · 2 aircraft · Substantial damage
  > The Cessna 441 pilot's mistaken belief that his assigned departure runway was runway 30R, which resulted in his undetected entrance onto runway 30R, which was being used by the MD-82 for its departure. Contributing to the accident was the lack of Automatic…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 271)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.