OpenAirDocs.org

Air traffic event

Open the Markdown

NTSB defining event · CICTT: Air Traffic

CICTT occurrence categories (PDF)CICTT phases of flight (PDF)

All 83 cases115 anywhere in the sequence
Defining event in
83 cases
In the sequence of
115 cases
Fatal cases
0
NTSB code
100

NTSB has coded findings and defining events since 2008. Earlier cases used its older occurrence and cause codes, so they aren’t counted here.

When and where

In green, cases where it was the defining event; in gray, cases where it came elsewhere in the sequence. The map shows the cases where it was the defining event. Events are coded with the final report, so the latest years are incomplete.

Cases per year

2008Defining eventElsewhere in the sequence2026

Where

Open the map
Query with SQL
duckdb -csv -c "SELECT year(c.\"eventDate\") AS year, count(DISTINCT e.case_mkey) AS cases,
    count(DISTINCT e.case_mkey) FILTER (WHERE e.\"isDefiningEvent\") AS defining
  FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = e.case_mkey
  WHERE e.\"tier2Number\" = '100' AND e.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")
  GROUP BY 1
  ORDER BY 1"

Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

In these cases

Phase of flight
  • Takeoff19
  • Approach12
  • Approach-IFR final approach8
  • Enroute-cruise6
  • Enroute6
  • Initial climb6
  • Taxi-into takeoff position6
  • Landing-landing roll4
  • Landing4
  • Approach-VFR go-around4
In the probable cause
Aircraft models

Aircraft matched to the registry by N-number and date.

Query with SQL
duckdb -csv -c "WITH defining AS (SELECT * FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"tier2Number\" = '100' AND \"isDefiningEvent\")
  SELECT * FROM (
  SELECT 'Phase of flight' AS kind, e.\"tier1Number\" AS code, max(e.\"eventTier1Name\") AS name, count(DISTINCT e.case_mkey) AS cases
  FROM defining e
  GROUP BY ALL
  UNION ALL
  SELECT 'Finding in the probable cause', left(f.\"findingCode\", 8), max(f.\"tier4Name\"), count(DISTINCT f.case_mkey)
  FROM defining e JOIN 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f ON f.case_mkey = e.case_mkey AND f.aircrafts_position = e.aircrafts_position AND f.\"inProbableCause\"
  WHERE f.\"findingCode\" GLOB '[0-9][0-9]*'
  GROUP BY ALL
  UNION ALL
  SELECT 'Aircraft model', a.aircraft_model_code, any_value(concat_ws(' ', m.manufacturer, m.model)), count(DISTINCT e.case_mkey)
  FROM defining e JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = e.case_mkey AND a.position = e.aircrafts_position
  LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = a.aircraft_model_code
  WHERE a.aircraft_model_code IS NOT NULL
  GROUP BY ALL
  )
  QUALIFY row_number() OVER (PARTITION BY kind ORDER BY cases DESC) <= 10
  ORDER BY kind, cases DESC"

Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

Newest cases · 83

NTSB DCA26WA343IncidentForeign investigationAirbus A320 · Mascot, AustraliaAug 24, 2026 · VH-VFX · 2 aircraftNTSB DCA26WA344IncidentForeign investigationBoeing 737 · Mascot, AustraliaAug 16, 2026 · VH-IXJNTSB DCA26WA347IncidentClass 5 · ForeignBoeing 737-8 · Fresno, CAAug 9, 2026 · N173AM · No damageNTSB OPS26LA063IncidentClass 3 · LimitedPreliminary reportSikorsky VH3D · Washington, DCOn August 4, 2026, about 1434 eastern daylight time (EDT), Marine One (VM1) a Sikorsky VH-3D, and Envoy Air flight 3742 (ENY3742), an Embraer E-170, were involved in a loss of separation about 2 miles north of Ronald Reagan Washington National Airport (DCA),…Aug 4, 2026 · MILITARY - VM1 · 2 aircraft · No damageNTSB DCA26WA291OccurrenceClass 5 · ForeignBoeing 737 · Mascot, AustraliaJul 26, 2026 · VH-XZG · 2 aircraft · No damageNTSB DCA26WA297IncidentClass 5 · ForeignBoeing 737 · Barcelona, SpainJul 11, 2026 · SP-RNT · 2 aircraft · No damageNTSB DCA27WA008IncidentClass 5 · ForeignBoeing 737 · Brazzaville, Congo - KinshasaJun 27, 2026 · 5N-NGANTSB DCA26WA254IncidentClass 5 · ForeignBoeing 787 · Ar Rumays, OmanJun 26, 2026 · A4O-SF · 2 aircraftNTSB DCA26LA242Incident · No injuriesClass 3 · LimitedPreliminary reportAirbus Industrie A319-114 · Boston, MAOn June 20, 2026, about 1134 eastern daylight time (EDT), Delta Air Lines flight 2351 (DAL2351), an Airbus A319, and American Airlines flight 3161 (AAL3161), a Boeing 737-800, were involved in a runway incursion that resulted in a go-around of DAL2351 at…Jun 20, 2026 · N328NB · 2 aircraft · No damageNTSB DCA26WA228Incident · No injuriesClass 5 · ForeignBombardier CL600 2E25 · Manises, SpainMay 8, 2026 · EC-MJP · No damage
See all 83 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 c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '100')
  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.