# Fatal, Final 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 MIA03LA088](https://openairdocs.org/ntsb/MIA03LA088.md): Air Tractor 502B · Belle Glade, FL · Accident · 1 fatal · Limited investigation · Final report · Apr 8, 2003 · N6037H · 2 aircraft · Destroyed
  > The failure of both pilots to use on-board communication radios to advise takeoff and landing intentions, the reduction of visibility of the pilot-in-command of N6037H due to sun glare during takeoff, and the poor in-flight planning by the pilot-in-command of…
- [NTSB MIA00FA103](https://openairdocs.org/ntsb/MIA00FA103.md): Cessna 172K · Sarasota, FL · Accident · 4 fatal · Field investigation · Final report · Mar 9, 2000 · N79960 · 2 aircraft · Destroyed
  > The failure of the supervisor/ground controller and the local controller to provide effective separation between the accident airplanes on the runway, resulting in a collision during takeoff. Contributing to the accident was the failure of the pilot and…
- [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…
- [NTSB CHI94LA178](https://openairdocs.org/ntsb/CHI94LA178.md): Cessna 150L · Richmond, IN · Accident · 1 fatal · Limited investigation · Final report · May 28, 1994 · N153KA · 2 aircraft · Destroyed
  > Inadequate visual lookout by the pilots of both airplanes.

## 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."highestInjuryLevel" = 'Fatal'
  AND c."completionStatus" = 'Completed'
  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?fatal=1&occurrence=271&status=final

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
