Skip to content

NTSB investigations, 1984

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

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 year(c."eventDate") = 1984 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 year(c.\"eventDate\") = 1984
    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") = 1984
  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 BFO85IA056Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · New Orleans, LADuring arrival, a Boeing 747, registration number d-abyp, lufthansa flight 5432, was vectored for an ILS localizer backcourse apch to rwy 19 at the new orlean intl arpt. While on the apch at 2000 ft MSL, the aircrew were instructed by the arrival controller…Dec 20, 1984 · DABYP · 2 aircraft · No damage NTSB DCA85IA003Incident · No injuriesIncident investigationFinal reportBoeing VC-137B-BN · Seattle, WADuring arrival, a Boeing VC-137B-BN, USAF #58-6970, operating as air force 2 (AF-2), was cleared for a localizer back- course apch. At 1442:49, TRACON advised AF-2 of traffic at its 10 o'clock position at 2 mi, alt unkn. At 1443:11, TRACON advised AF-2 the…Oct 18, 1984 · USAF · 2 aircraft · No damage NTSB FTW85IA011Incident · No injuriesIncident investigationFinal reportCessna Citation 550 · Houston, TXN3322L inadvertently crossed the active rwy 04 at the time N107T became airborne on takeoff from that rwy. A near miss occurred as the captain and 1st officer of N107T observed N3322L on the rwy and made a max performance climb over the top of N3322L. N3322L…Oct 8, 1984 · N107T · 2 aircraft · No damage NTSB FTW84LA359Accident · Serious injuriesLimited investigationFinal reportMaule M6-235 · Corpus Christi, TXOn a heading of 165 deg at 3,500 ft the plt saw another acft at the same altitude on a collision course. Evasive action was taken by pushing the nose over forcing both occupants into the cabin overhead. According to the plt, both seatbelts and shoulder…Aug 18, 1984 · N5648D · No damage NTSB DCA84IA030Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Marietta, GAEastern airlines flt 92, a Boeing 727, N8840E, and an air force-KC-135, reg #60-0330, call sign fowl 24, were involved in a near collision while both acft were maintaining FL350. The captain of flt 92 reported that during the occurrence, the KC-135 passed…Jul 16, 1984 · N8840E · 2 aircraft · No 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 NTSB LAX84IA219Incident · No injuriesIncident investigationFinal reportBeech C-45G · Ontario, CAA Beech E18S, N3657G, operating as federal express flt 954L, was cleared for takeoff on rwy 8L after a Boeing 747, N8172G, operating as interflight 429, was cleared to cross the same rwy. The Boeing 747'S cargo included race horses. The Boeing crew were…Mar 15, 1984 · N3657G · No damage NTSB MIA84IA054Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-30 · Atlantic Ocean (Atlantic Ocean)Acft nearly collided with paa N82NA at FL370 about 200 mi east of miami when acft passed about 300 ft from each other ina nonradar environment. Both acft were at their assigned flight level & were operating on routes approved & issued by miami ARTCC. The D72…Jan 1, 1984 · N82NA · 2 aircraft · No damage