OpenAirDocs.org

Ground collision

Open the Markdown

NTSB defining event · CICTT: Ground Collision

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

All 500 cases618 anywhere in the sequence
Defining event in
500 cases
In the sequence of
618 cases
Fatal cases
12
NTSB code
200

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\" = '200' 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
  • Taxi149
  • Taxi-to runway103
  • Taxi-from runway100
  • Standing-engine(s) operating50
  • Landing-landing roll23
  • Standing-engine(s) start-up22
  • Standing21
  • Takeoff19
  • Prior to flight17
  • Landing14
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\" = '200' 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 · 500

NTSB ERA27FA004Accident · 1 fatalClass 3 · FieldInvestigation openHughes 269B · Lahmansville, WVOct 6, 2026 · N9390FNTSB WPR27LA010Accident · No injuriesLimited investigationInvestigation openCessna A185F · Madera, CAOct 1, 2026 · N185TTNTSB ERA26LA361Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-161 · Sarasota, FLSep 26, 2026 · N636FTNTSB ERA26LA344Accident · No injuriesClass 3 · LimitedPreliminary reportAerospatiale SA 315 · Workmore, GAOn September 18, 2026, at 1604 eastern daylight time, an Aerospatiale SA315B helicopter, N238HA was substantially damaged when it was involved in an accident near Workmore, Georgia. The pilot was not injured. The helicopter was operated as a Title 14 Code of…Sep 18, 2026 · N238HA · Substantial damageNTSB CEN26LA316Accident · No injuriesClass 3 · LimitedPreliminary reportBeech 99 · Belleville, MIOn September 10, 2026, about 1545 eastern daylight time, a Beech 99 airplane, N799CZ, and a Diamond DA20 airplane, N84VV were involved in a ground collision accident at the Willow Run Airport, Belleville, Michigan. N799CZ received minor damage and N84VV…Sep 10, 2026 · N799CZ · 2 aircraft · Minor damageNTSB DCA26WA345IncidentClass 5 · ForeignBoeing 787 · Singapore, SingaporeSep 3, 2026 · 9V-OJJ · Minor damageNTSB WPR26LA310Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172P · Gulfport, MSAug 21, 2026 · N5384K · Substantial damageNTSB DCA26WA312Incident · No injuriesClass 5 · ForeignBoeing 737 · Sepang, MalaysiaAug 15, 2026 · PK-GFRNTSB ERA26LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Morgantown, WVThe fuel truck driver’s distraction and inadequate visual lookout, which resulted in a collision with an airplane.Aug 9, 2026 · N6175G · Substantial damageNTSB WPR26LA299Accident · No injuriesClass 4 · LimitedInvestigation openJonker Sailplanes JS3 · Tehachapi, CAAug 8, 2026 · N9172T · 2 aircraft · Substantial damage
See all 500 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\" = '200')
  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.