# NTSB investigations: Douglas DC-9-31, 1986

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 ATL86LA202](https://openairdocs.org/ntsb/ATL86LA202.md): Douglas DC-9-31 · Montgomery, AL · Accident · Serious injuries · Limited investigation · Final report · Jul 21, 1986 · N9332 · Minor damage
  > During flt, the acft encountered turbulence (turbc) while flying in the vicinity of a thunderstorm (tstm). During the occurrence, a flt attendant, who was serving beverages, sustained a fractured lumbar vertebrae. Radar data revealed the acft was about 4 mi…
- [NTSB CHI86MA142](https://openairdocs.org/ntsb/CHI86MA142.md): Mcdonnell Douglas DC-9-31 · Chicago, IL · Incident · No injuries · Major investigation · Final report · May 17, 1986 · N973VJ · 2 aircraft · Minor damage
  > U.S. Air flight 373 passed over American airlines flight 695 at the intersection of runways 32R and 4L while both aircraft were taking off. Both aircraft had been cleared for takeoff by the local controller at o'hare tower. The aircraft came within twenty…
- [NTSB DCA86AA018](https://openairdocs.org/ntsb/DCA86AA018.md): McDonnell Douglas DC-9-31 · Erie, PA · Accident · Minor injuries · Final report · Feb 21, 1986 · N961VJ · Substantial damage
  > Drg arrival, the crew of us air flt 499 lndd on rwy 24, which was cvrd with snw. Rprtdly, while lndg, the acft touched dwn aprx 1800 to 2000' bynd the displaced threshold. Altho armed, the spoilers did not auto-deploy, so the capt operatedthem manually. He…

## 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 year(c."eventDate") = 1986
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3022065'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3022065&year=1986

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