# NTSB investigations, MD: Near collision between aircraft

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 OPS08IA002](https://openairdocs.org/ntsb/OPS08IA002.md): Bombardier CRJ1 · Baltimore, MD · Incident · No injuries · Incident investigation · Final report · Dec 3, 2007 · N781CA · 2 aircraft · No damage
  > The probable cause of this incident is local controller's failure of maintaining awareness of the situation and failing to provide the appropriate separation between the two aircraft operating on intersecting runways. Providing separation between aircraft is…
- [NTSB BFO88IA012](https://openairdocs.org/ntsb/BFO88IA012.md): Mcdonnell Douglas DC-9-32 · Baltimore, MD · Incident · No injuries · Incident investigation · Final report · Dec 5, 1987 · N924L · 2 aircraft · No damage
  > Twa flt 388 (DC-9, N924L) was in clouds climbing to 7000' when Baltimore (bwi) TRACON adzd that an acft (Piper PA-28R) was straight ahead at 3 mi dscndg fm 6700'. Flt 388 had passed 6000' & the capt requested a traffic avoidance vector. The TRACON ctlr…
- [NTSB ATL82FIG09](https://openairdocs.org/ntsb/ATL82FIG09.md): Bellanca 7GCBC · Woodbine, MD · Accident · 2 fatal · Final report · Jun 18, 1982 · N5153X · Destroyed
  > After taking off from runway 21, the pilot made a left turn-out then reentered a downwind for runway 03. At about the same time, a Cessna 150 was departing from runway 21 and a glider entered the pattern to land on runway 03. Two witnesses observed the…

## 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."eventStateOrRegion" = 'MD' AND c."eventCountry" = 'USA'
  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" = 280)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=280&state=MD

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