OpenAirDocs.org

Nose over/nose down

Open the Markdown

NTSB defining event · CICTT: Abnormal Runway Contact

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

All 468 cases2,287 anywhere in the sequence
Defining event in
468 cases
In the sequence of
2,287 cases
Fatal cases
10
NTSB code
096

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\" = '096' 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
  • Landing-landing roll267
  • Landing81
  • Landing-flare/touchdown42
  • Takeoff29
  • Takeoff-rejected takeoff18
  • Taxi12
  • Taxi-from runway8
  • Other3
  • Landing-aborted after touchdown3
  • Taxi-into takeoff position3
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\" = '096' 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 · 468

NTSB WPR27LA003Accident · No injuriesClass 4 · LimitedInvestigation openMaule M-5-235C · Agua Dulce, CAOct 3, 2026 · N56328 · Substantial damageNTSB WPR26LA350Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-12 · Salem, ORSep 20, 2026 · N4139M · Substantial damageNTSB WPR26LA351Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180 · Medford, ORSep 19, 2026 · N4722B · Substantial damageNTSB WPR26LA366Accident · No injuriesClass 4 · LimitedInvestigation openAbbott Dudley L Levitator · Skwentna, AKSep 15, 2026 · N1027Y · Substantial damageNTSB WPR26LA348Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18-150 · Roundup, MTSep 15, 2026 · N4500W · Substantial damageNTSB ANC26LA102Accident · No injuriesClass 4 · LimitedInvestigation openCessna 170B · Willow, AKSep 11, 2026 · N2525D · Substantial damageNTSB WPR26LA336Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18-150 · Moses Lake, WASep 10, 2026 · N9678P · Substantial damageNTSB ANC26LA101Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18A 150 · Palmer, AKSep 10, 2026 · N7795D · Substantial damageNTSB ANC26LA100Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA12 · Arctic Village, AKSep 10, 2026 · N2945M · Substantial damageNTSB ANC26LA094Accident · Minor injuriesClass 4 · LimitedInvestigation openCessna 180A · Cordova, AKAug 30, 2026 · N5399D · Substantial damage
See all 468 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\" = '096')
  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.