OpenAirDocs.org

Collision during takeoff/land

Open the Markdown

NTSB defining event · CICTT: Collision During Takeoff/Land

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

All 808 cases1,309 anywhere in the sequence
Defining event in
808 cases
In the sequence of
1,309 cases
Fatal cases
127
NTSB code
490

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\" = '490' 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
  • Takeoff260
  • Landing135
  • Initial climb100
  • Approach-VFR pattern final70
  • Landing-landing roll57
  • Approach-VFR go-around49
  • Landing-aborted after touchdown37
  • Approach34
  • Landing-flare/touchdown28
  • Takeoff-rejected takeoff25
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\" = '490' 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 · 808

NTSB CEN27LA021Accident · 1 fatalClass 3 · LimitedInvestigation openPiper J3C-65 · Boonville, INOct 18, 2026 · N88218NTSB WPR27LA004Accident · No injuriesClass 4 · LimitedInvestigation openHead Balloons AX8-88B · Albuquerque, NMOct 3, 2026 · N4502A · Substantial damageNTSB CEN27LA002Accident · Minor injuriesClass 4 · LimitedInvestigation openPost Thorp T-18 · Brazil, INOct 3, 2026 · N763LG · Substantial damageNTSB WPR27LA009Accident · Serious injuriesLimited investigationInvestigation openCessna 172N · Knights Landing, CAOct 1, 2026 · N75513NTSB ERA26LA362Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-140 · Canon, GASep 22, 2026 · N3713K · Substantial damageNTSB WPR26LA361Accident · No injuriesClass 4 · LimitedInvestigation openCessna U206G · Stony River, AKSep 21, 2026 · N1797R · Substantial damageNTSB WPR26LA353Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 182P · Warren, IDSep 20, 2026 · N7337N · Substantial damageNTSB WPR26LA349Accident · Minor injuriesClass 4 · LimitedInvestigation openCameron Balloons US A-400 · Angwin, CASep 19, 2026 · N65573 · Substantial damageNTSB ANC26FA091Accident · 4 fatalClass 3 · FieldPreliminary reportPiper PA-24-260 · Seldovia, AKOn August 26, 2026 about 1317 Alaska daylight time, a Piper PA-24-260 airplane, N9485P, was substantially damaged when it was involved in an accident near Seldovia, Alaska. The pilot and three passengers were fatally injured. The airplane was operated as a…Aug 26, 2026 · N9485P · Substantial damageNTSB WPR26LA307Accident · Serious injuriesClass 4 · LimitedInvestigation openCirrus Design SF50 · Driggs, IDAug 14, 2026 · N71KD · Substantial damage
See all 808 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\" = '490')
  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.