Skip to content

NTSB investigations, IL

23 cases where the first occurrence was “Near collision between aircraft”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19842026

Where

Latest cases

Query with 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" = 'IL' 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

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 c.\"eventStateOrRegion\" = 'IL' 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"

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 c."eventStateOrRegion" = 'IL' 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

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 OPS06IA008Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Chicago, ILThe failure of the ORD tower south local controller to monitor Atlas Air flight 6972 on arrival to runway 14R and subsequently clearing United Airlines flight 1015 for takeoff on intersecting runway 27L causing a loss of separation between the two aircraft.Jul 24, 2006 · N315UA · 2 aircraft · No damage NTSB OPS06IA007Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Chicago, ILThe probable cause of this incident was the ORD tower local controller's failure to provide sufficient separation between two aircraft departing intersecting runways. Contributing to the incident was the ORD local monitor's failure to monitor the situating…Mar 23, 2006 · N309UA · 2 aircraft · No damage NTSB OPS06IA006Incident · No injuriesIncident investigationFinal reportAirbus Industrie 319 · Chicago, ILThe probable cause of the incident was the local controller's failure to ensure proper separation between Lufthansa flight 437 and Chautauqua (CHQ) flight 7826. Contributing was the failure of the local monitor to monitor the situation and advise the local…Mar 21, 2006 · D-APAC · 2 aircraft · No damage NTSB CHI00IA248Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-2000 · Chicago, ILthe improper takeoff clearance issued by the local controller.Aug 6, 2000 · N269AE · 2 aircraft · No damage NTSB CHI97IA164Incident · No injuriesIncident investigationFinal reportDouglas DC-10-30F · Chicago, ILthe lack of communications to assure safe operations between aircraft on a non-movement area.Jun 10, 1997 · N302FE · No damage NTSB CHI95IA095Incident · No injuriesIncident investigationFinal reportBoeing 747-136 · Chicago, ILthe North Local Controller's failure to issue a clearance which would ensure separation between the two airplanes and the North Local Control Monitor's failure to adequately back up the controller. Factors were the complexity of the airport operations and…Feb 26, 1995 · GAWNM · No damage NTSB CHI93IA167Incident · No injuriesIncident investigationFinal reportCessna 550 · West Chicago, ILInadequate control tower service by the local air traffic controller by providing conflicting clearances to the pilots of two aircraft.May 10, 1993 · N41SM · No damage NTSB CHI92LA259Accident · No injuriesLimited investigationFinal reportMooney 20F · Lacon, ILThe pilot's failure to recognize that the runway he selected for landing was closed. Factors which contributed to the accident were: the pilot's anxiety following the near-collision, and his limited ability to detect the orange-colored marking.Aug 29, 1992 · N3486N · Substantial damage NTSB CHI92IA061Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-30 · Chicago, ILThe local controller's not understanding read back of radio communications. Factors include the pilot-in-command of flight 73 not understanding verbal instructions; local controller not visually identifying the aircraft; and inadequate surveillance (FAA) in…Dec 23, 1991 · N142AA · 2 aircraft · No damage NTSB CHI89IA144Incident · No injuriesIncident investigationFinal reportDornier DO-228 · Chicago, ILPoor lookout by the crew of the Dornier and the baron.Jul 9, 1989 · N263MC · No damage NTSB CHI89IA143Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Chicago, ILPoor lookout by the crew of the DC-9 and the Cessna pilot.Jul 9, 1989 · N939ML · No damage NTSB CHI89IA054Incident · No injuriesIncident investigationFinal reportShort Brothers SD360 · Chicago, ILThe PIC followed a clearance intended for another airplane.Mar 8, 1989 · N366MQ · No damage NTSB MIA88IA168Incident · No injuriesIncident investigationFinal reportPiper PA-42-720 · Chicago, ILCondor flt 610 (Mcdonnell Douglas DC-10, german registration: dadso) was aprx 2 hrs late as the flt crew members were preparing to takeoff. Subsequently, flt 610 was clrd for takeoff with instructions to cross the 5 DME (on the standard instrument…May 11, 1988 · N900MP · 2 aircraft · No damage NTSB MIA88IA167Incident · No injuriesIncident investigationFinal reportBeech 200 · Chicago, ILMidway flt 172 (Mcdonnell Douglas DC-9, N1065T) was on an IFR departure from Chicago midway arpt at the same time that Beech 200, N981LL, was on an IFR arrival for a visual apch to merrill c meigs arpt, although both were in VMC. Previously, o'hare TRACON had…May 10, 1988 · N981LL · 2 aircraft · No damage NTSB CHI88IA074Incident · No injuriesIncident investigationFinal reportSwearingen SA226T · Chicago, ILThe TRACON supervisor failed to comply with the established visual minima criteria and his incorrect issuance of a visual approach to an arriving aircraft.Mar 7, 1988 · N600TA · 2 aircraft · No damage NTSB CHI88IA073Incident · No injuriesIncident investigationFinal reportBoeing 747-227B · Chicago, ILFailure of the tower cab supervisor to assure that coordination between the south local controller and north local controller had been completed. A factor is the failure of FAA tower management to insure there were personnel manning the cab coordinator…Feb 19, 1988 · N635US · 2 aircraft · No damage 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…Oct 29, 1987 · N305UA · 2 aircraft · No damage 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…Aug 8, 1987 · CGYNE · 2 aircraft · No damage 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,…Aug 3, 1987 · N113AA · 2 aircraft · No damage 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…May 30, 1987 · N224AA · No damage 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…Apr 7, 1987 · N7258U · No damage 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…May 17, 1986 · N973VJ · 2 aircraft · Minor damage NTSB ATL84IA160Incident · No injuriesIncident investigationFinal reportDouglas DC-9-32 · Mount Vernon, ILKansas city ARTCC (zkc) had cleared ozark flt 709 (a DC-9, N923L) to cruise at FL270. While proceeding ese near the edgeof the zkc area, the DC-9 converged on zorro 11 (a flt of 3 F-4'S). The F-4'S had been cleared by indianaplolis ARTCC (zid) to proceed…May 4, 1984 · N923L · No damage