NTSB investigations, NY

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations, NY per year, 1982–2026: 7 cases
1982	1
1986	1
1987	2
1989	2
2007	1

Where

Open the map

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" = 'NY' 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\" = 'NY' 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" = 'NY' 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 OPS07IA007Incident · No injuriesIncident investigationFinal reportBoeing 737 · New York City, NYATC - The incident occurred because the ground controller instructed COM5196 to cross runway 22, without approval from the local controller, resulting in a loss of separation with DAL1238 that was landing on the same runway.Jul 5, 2007 · N737DA · 2 aircraft · No damage NTSB NYC89IA222Incident · No injuriesIncident investigationFinal reportCessna 421C · New York, NYFailure of the liberty sector controller to advise pan am flight 542 of the presence of the Cessna 421 and/or restrict the climb of flight 542 until it had passed the Cessna, and failure of the pan am aircrew to see the Cessna in adequate time to avoid a near…Apr 23, 1989 · N247CB · 2 aircraft · No damage NTSB NYC89IA123Incident · No injuriesIncident investigationFinal reportFairchild Swearingen SA-227AC · New York, NYThe failure of the swearingen flight crew to properly identify the airplane they were to follow, prior to accepting the visual approach to runway 31R.Apr 23, 1989 · N3044J · 2 aircraft · No damage 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…Sep 29, 1987 · N8864E · 2 aircraft · No damage 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,…Aug 9, 1987 · N93109 · 2 aircraft · No damage 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…May 30, 1986 · N1310T · 2 aircraft · No damage 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