Skip to content

NTSB investigations

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

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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."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.\"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."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 MIA85IA208Incident · No injuriesIncident investigationFinal reportCessna 402 · West Palm Bch, FLA Learjet 35 was cleared on to runway 09L and hold, the Learjet crew confirmed with the air traffic control tower personnel that te transmission was intended for them and taxied into position and held. Personnel on duty in the control tower then cleared a…Jul 5, 1985 · N68368 · 2 aircraft · No damage NTSB CHI85FA249Accident · Serious injuriesField investigationFinal reportBoeing 727 · South Haven, MIWhile en route on an IFR flt plan (1st officer at ctls), American flt 803 (a Boeing 727, N1965) bgn a dscnt fm FL 190 TO9000'. The seat belt sign was turned on at 18,000'. While dscndg btn cld layers, at aprx 13,000 to 12,000', the capt sawa Cessna 421C,…Jun 23, 1985 · N1965 · 2 aircraft · No damage NTSB LAX85IA175Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · San Jose, CAA Piper seminule was vectored to the final apch course & cleared for an ILS apch at 3000FT MSL. A DC-9, in trail at 5000FT MSL, was overtaking the seminule. The controller elected to change their sequence & cleared the seminule to climb to 4000FT MSL due to…Mar 16, 1985 · N2138G · 2 aircraft · No damage 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 NTSB MIA83LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe student pilot was practicing touch-and-go landings. After touching down on his first landing, he configured the aircraft for takeoff. Immediately after applying power, he observed another plane (unknown make & model) landing from the opposite direction.…Oct 3, 1982 · N93286 · Substantial damage NTSB ATL82FIG09Accident · 2 fatalFinal reportBellanca 7GCBC · Woodbine, MDAfter taking off from runway 21, the pilot made a left turn-out then reentered a downwind for runway 03. At about the same time, a Cessna 150 was departing from runway 21 and a glider entered the pattern to land on runway 03. Two witnesses observed the…Jun 18, 1982 · N5153X · Destroyed NTSB NYC82DA104Accident · No injuriesFinal reportPiper PA-22-160 · Red Hook, NYThe pilot flew to sky park airport to have radio work done on his aircraft. During arrival, he had no contact with UNICOM. He made a low pass over the airport, noted that the wind was light and elected to land on runway 19. As he was touching down, he…May 26, 1982 · N3128Z · Substantial damage NTSB SEA82FA052Accident · 1 fatalField investigationFinal reportCessna A152 · Bremerton, WAThe pilot took off downwind and against traffic in marginal weather conditions. No flight plan was filed and there was no record of a weather briefing. During departure, a near-miss occurred between N761QZ and a light twin-engine aircraft on an instrument…Apr 11, 1982 · N761QZ · Destroyed