NTSB investigations, 1987
18 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\") = 1987
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") = 1987 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 BFO88IA012Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Baltimore, MDTwa 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 MIA88IA055Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Newark, NJAt 1710:53 EST, the LCL twr ctlr (lc) at the Newark intl arpt clrd Continental flt 321 (DC-9-82, N806NY) for takeoff on rwy 22L; 11 sec later, Continental flt 688 (Boeing 727, N577PE) rprtd 'left downwind for rwy 29.' Lc told flt 688 to 'maintain 1500 as you…NTSB CHI88IA015Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Chicago, ILThe south rwys (32L, 9R, & 4R) were being ctld by the south LCL ctlr (slc) & the north rwys (9L & 4L) were ctld by the north LCL ctlr (nlc). At 1543:26, slc told united flt 973 (Boeing 737) to hold on 32L & expect a 3 min delay bfr tkof. Air Wisconsin flt 954…NTSB MIA88IA020Incident · No injuriesIncident investigationFinal reportBoeing 727-214 · St CroixPaa flt was on visual apch and in contact with apch control who informed flt of two acft ahead also on visual apch. The controller offered vectors to clear traffic. Paa flt elected to continue current heading. The two preceding acft were on twr freq giving…NTSB LAX88IA009Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Ontario, CAFailure of the general aviation aircraft to visually identify the transport aircraft. Factures contributing to the incident were: failure of the general aviaiton aircraft to establish communications with ATC prior to entering the arsa and maintaining a poor…NTSB MIA87IA264Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Hampton, NYA full performance level controller (fpl ctlr) at sector 31 of boston ARTCC was giving familiarization training to another fpl ctlr to familiarize the trainee with a new area that had been transferred from new york ARTCC to boston ARTCC. Sector 31 was…NTSB ATL87LA236Accident · No injuriesLimited investigationFinal reportCessna A185F · Mt Airy, NCAfter Cessna 185, N3462Y, entered the traffic pattern for rwy 18, the UNICOM operator warned the plt of another acft in the pattern. The other acft was a Mooney mite, N4129. The Cessna plt contd his apch, but didn't see the Mooney mite until after the Cessna…NTSB LAX87IA304Incident · No injuriesIncident investigationFinal reportBoeing 737 · Santa Monica, CAThe plts of a Boeing 737 reported that a near-collision occurred aprx 2.5 miles east of the Santa Monica VOR while they were descending through an altitude of about 7400 ft MSL. The coplt saw the other acft first & took immediate evasive action. He estimated…NTSB NYC87IA227Incident · No injuriesIncident investigationFinal reportBoeing 747 · New York, NYAcft with similar call signs (twa flts 843H & 834; Boeing 747 & Boeing 727) apchd jfk intl arpt for ldg. Flt 843H was 22MIN late & flt 834 was 12 min early, causing same arr time. NY TRACON vctrd flt 834 bhnd flt 843H. While ctlg the acft, jfk final ctlr,…NTSB CHI87IA188Incident · No injuriesIncident investigationFinal reportBoeing 727-233 · Chicago, ILAir Canada flt 839 (Boeing 727, c-gyne) was depg Chicago o'hare intl arpt as Cessna 650 (citation), N20AT, was depg palwaukee (pwk) arpt, about 8 mi north of o'hare. Both flts tkof with IFR flt plans. Bfr the citation tkof, the pwk twr ctlr ctcd the TRACON…NTSB CHI87IA183Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILAfter ldg the co B727 was directed to make two right turns and follow an acft that had landed in front of him. The pilot made one right turn and taxied down an empty runway. This taxi route crossed an active runway. An aa#DC-10 on takeoff roll, at 110 knots,…NTSB NYC87IA199Incident · No injuriesIncident investigationFinal reportDouglas DC-10-30 · Atlantic Ocean (Atlantic Ocean)A Mcdonnell Douglas DC-10 (viasa flt 800) & an Airbus A310 (pan am flt 221) were involved in a near collision while on intl flts ovr the Atlantic Ocean on (airway) amber 300. Both acft were operg under IFR & were in a non-radar environmentw/o drct radio ctc…NTSB ATL87IA179Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Nashville, TNAt aprx 2211 CDT, delta flt 314 (Boeing 727, N482DA) was clrd to taxi to rwy 31 with info india. Info india indcd rwy 31WAS active. Soon thereafter, southwest flt 715 (Boeing 737, N50SW) reqd & recd taxi clnc to rwy 13 for tkof. To accommo-date incoming…NTSB DEN87IA145Incident · No injuriesIncident investigationFinal reportBoeing 727-251 · Casper, WYBoeing 727 (northwest flt 354) & USAF EC-135 (slum 51) were involved in a nr collision at FL 330. The mishap occurred asflt 354 was ene bnd on J-158 & slum 51 was flying on a radial-distance (r/d) flt pln, flying btn r/d pts south of J-158.as slum 51 apchd…NTSB CHI87IA135Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Chicago, ILAmerican flt 637 was on departure from Chicago-o'hare intl arpt (ord), climbing thru 7300' MSL, when it passed American flt 393 with aprx 500' vertical sepn & 1/4 mi horizontal sepn. This occurred after an air traffic assistant, who was working the clnc…NTSB NYC87IA118Incident · Minor injuriesIncident investigationFinal reportde Havilland DHC-7-102 · Wrightstown, NJRansom flt 444 (DHC-7) rprtd a near collision with USAF C-141 (gleek 41) as flt 444 was at 5000' & gleek 41 was clbg to 7500' fm a combat aircrew training (cat) mnvr. Flt 444 was under IFR ctl of mcguire afb rapcon; gleek 41 was VFR, rcvg radar adzys fm…NTSB CHI87IA109Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Chicago, ILA united airlines Boeing 727 domestic passenger flight was holding short of runway 32L at the Chicago-o'hare international airport awaiting clearance for an intersection takeoff. A northwest airlines Boeing 747 international passenger flight was holding in…NTSB CHI87IA112Incident · No injuriesIncident investigationFinal reportDassault-Breguet 50 · Cleveland, OHAn opnl error developed as a falcon 50, N52DC, was proceeding se toward the dryer VOR at FL290 & northwest flt 427 was proceeding westbound at the same alt toward the same fix (dryer VOR). When the full performance lvl (fpl) controller (ctlr) saw the…