NTSB investigations, 1986
10 cases where the first occurrence was “Near collision between aircraft”.
Cases per year
| 1982 | 4 |
|---|---|
| 1984 | 8 |
| 1985 | 3 |
| 1986 | 10 |
| 1987 | 18 |
| 1988 | 14 |
| 1989 | 12 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 5 |
| 2007 | 10 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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 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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ATL87IA020Incident · No injuriesIncident investigationFinal reportBoeing 727-227 · Livingston, TNThe braniff and united Boeing 727 jetliners were approaching 'swapp' intersection on converging jetways at their proper assigned alt of 35,000'. The controller was in the process of issuing radar vectors to assure proper lateral separation when the control…NTSB ANC87IA012Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10 · Adak, AKA canadian pacific Mcdonnell Douglas DC-10 (flt 3), cg-cpj, & a reeve aleutian Boeing 727 (flt 724), N832, were clrd to fly at FL 290 on 2 different airways. The airways crossed at picum intxn, ovr the bearing sea. While traveling in nrly opposite drctns at…NTSB LAX87IA027Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Los Angeles, CADrg arr, united flt 282 (Boeing 727, N7255U) was vectored by Los Angeles (lax) TRACON for an ILS rwy 25L apch. While in a dscndg turn at 2100' MSL to intercept the ILS LOC at 2000', the capt saw a helicopter (hel) ahead & pulled up. He estdhis acft passed w/i…NTSB CHI86IA225Incident · No injuriesIncident investigationFinal reportBoeing 727-25 · Evansville, INAfter the aircrew of eastern flt 254 (a Boeing 727, N8107N) had landed on rwy 22 at night & was slowing, the tower controller (ctlr) instructed them to 'turn right on taxiway bravo, if able, hold short of rwy 18 and remain this frequency.' The crew of flt 254…NTSB CHI86MA216Incident · No injuriesMajor investigationFinal reportBoeing 737-222 · Lansing, MIPiedmont flt PI255 (a Boeing 737, N749N) was dscndg in visual conds on an IFR clnc when it & a twin commanche (Piper PA-30, N7399Y) converged & passed within a rprtd 50 to 100 ft of each other. The near collision occurred as the PA-30 was cruising westbound…NTSB BFO86IA031Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Calverton, NYN1031T a DC-9-31, was in a descent for landing at jamaica, NY. The captain reported he heard a noise that he thought was a failing cabin door pressure seal and advised the copilot. The copilot indicated he thought the noise was the soundof a jet eng. Between…NTSB CHI86MA142Incident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-9-31 · Chicago, ILU.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 LAX86MA151Incident · No injuriesMajor investigationFinal reportBoeing 727-231 · Cincinnati, OHIndianapolis ctr (ctlr-a) clrd sluff 11 (S-11), a flt of 4 ANG A-7'S, to clb to FL210. Later, ctlr-a told S-11 to chg freq (to york low sector, ctlr-b). S-11 chgd freq, but neither S-11 nor ctlr-b established rdo contact with each other until S-11 had contd…NTSB ATL86IA100Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Nasville, TNA nr midair collision occurred aprx 38 mi se of the nashville metro arpt as a Boeing 737, piedmont flt 488, was dscndg thru aprx 12,000' & a flt of 4 F-4'S, call sign peach 41, were joining. Flt 488 was inbnd to nashville on an IFR clnc & memphis ARTCC had…NTSB SEA86FA052Accident · 1 fatalField investigationFinal reportCessna 195 · Black Diamond, WARadar track shows C195 plt was descending into congested airspace at about 192 mph, above max structural cruise speed of 178 mph, less than 1 min from traffic pattern entry. Radar data and witness confirm a second acft in proximity, engaged in aerobatics.…