OpenAirDocs.org

Landing gear collapse

Open the Markdown

NTSB defining event · CICTT: Abnormal Runway Contact

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

All 648 cases1,787 anywhere in the sequence
Defining event in
648 cases
In the sequence of
1,787 cases
Fatal cases
1
NTSB code
094

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\" = '094' 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 roll316
  • Landing126
  • Landing-flare/touchdown107
  • Takeoff30
  • Taxi-from runway20
  • Taxi17
  • Taxi-to runway11
  • Taxi-into takeoff position7
  • Takeoff-rejected takeoff6
  • Pushback/towing2
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\" = '094' 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 · 648

NTSB ERA26LA357Accident · No injuriesClass 4 · LimitedInvestigation openGrumman American Avn. GA-7 · Knoxville, TNSep 30, 2026 · N384MA · Substantial damageNTSB ERA26LA354Accident · No injuriesClass 3 · LimitedPreliminary reportCostruzioni Aeronautiche Tecnam P92 Tail Dragger · Toughkenamon, PAOn September 29, 2026, about 0945 eastern daylight time, a special light-sport Costruzioni Aeronautiche Tecnam P92 Tail Dragger, N575TA, was substantially damaged when it was involved in an accident near Toughkenamon, Pennsylvania. The pilot was not injured.…Sep 29, 2026 · N575TA · Substantial damageNTSB CEN26LA329Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-181 · Mason, MISep 26, 2026 · N8086G · Substantial damageNTSB ERA26LA360Accident · No injuriesClass 4 · LimitedInvestigation openCessna 421B · Nashville, TNSep 25, 2026 · N421FA · Substantial damageNTSB ERA26LA349Accident · No injuriesClass 3 · LimitedInvestigation openBeech 200 · Dothan, ALSep 19, 2026 · N621JGNTSB WPR26LA340Accident · No injuriesClass 3 · LimitedPreliminary reportCessna P210N · San Luis Obispo, CAOn September 13, 2026, about 1515 Pacific daylight time, a Cessna P210N airplane, N4617W, was substantially damaged when it was involved in an accident near San Luis Obispo, California. The pilot, pilot-rated-passenger, and a passenger were not injured. The…Sep 13, 2026 · N4617W · Substantial damageNTSB WPR26LA343Accident · No injuriesClass 4 · LimitedInvestigation openAerovodochody L-29 Delfin · Roswell, NMSep 12, 2026 · N29AD · Substantial damageNTSB ANC26LA104Accident · No injuriesClass 4 · LimitedInvestigation openTaylorcraft BL-65 · Ninilchik, AKSep 11, 2026 · N22619 · Substantial damageNTSB WPR26LA334Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech 200 · Roswell, NMOn September 8, 2026, about 0044 mountain daylight time, N393JW, a Beech 200, was substantially damaged when it was involved in an accident near Roswell, New Mexico. The two pilots and two of the medical crew members were not injured, a third medical crew…Sep 8, 2026 · N393JW · Substantial damageNTSB ANC26LA099Accident · No injuriesClass 4 · LimitedInvestigation openMaule M-5-210C · Venetie, AKAug 31, 2026 · N420KB · Substantial damage
See all 648 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\" = '094')
  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.