OpenAirDocs.org

Landing area undershoot

Open the Markdown

NTSB defining event · CICTT: Undershoot/Overshoot

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

All 133 cases201 anywhere in the sequence
Defining event in
133 cases
In the sequence of
201 cases
Fatal cases
3
NTSB code
370

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\" = '370' 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
  • Landing87
  • Landing-flare/touchdown40
  • Landing-landing roll4
  • Autorotation1
  • Emergency descent1
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\" = '370' 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 · 133

NTSB ERA26LA259Accident · Serious injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Hickman, KYThe pilot’s failure to maintain a proper glide path, which resulted in a runway undershoot.Jul 6, 2026 · N9103E · Substantial damageNTSB WPR26MA063Accident · 7 fatalClass 2 · MajorPreliminary reportCessna 550 · Statesville, NCOn December 18, 2025, at 1015 eastern standard time, a Cessna Citation 550, N257BW, was destroyed when it was involved in an accident near Statesville, North Carolina. The pilot and 6 passengers were fatally injured. The airplane was operated as a Title 14…Dec 18, 2025 · N257BW · Substantial damageNTSB DCA26WA031Incident · No injuriesClass 5 · ForeignBoeing 747 · N'Djamena, ChadNov 13, 2025 · ER-BAR · Minor damageNTSB ERA25LA363Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · White Plains, NYThe pilot’s failure to maintain proper glidepath during a night visual approach, which resulted in a collision with the runway lighting system. Contributing to the outcome was the pilot’s momentary disorientation due to glare from the runway approach lighting…Sep 23, 2025 · N47630 · Substantial damageNTSB CEN25LA406Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T34 · Beaman, IAThe pilot’s failure to maintain a proper glidepath during landing which resulted in a landing short of the runway.Aug 26, 2025 · N393KW · Substantial damageNTSB DCA25LA291Incident · No injuriesClass 3 · LimitedPreliminary reportAirbus A319 · Nashville, TNOn August 14, 2025, about 1724 central daylight time (CDT), Air Canada Rouge flight ROU1717, an Airbus A319 airplane, registration C-GSJB, touched down short of runway 20L while landing at the Nashville International airport (BNA), Nashville, TN. There were…Aug 14, 2025 · C-GSJB · No damageNTSB ERA25LA224Accident · No injuriesClass 4 · LimitedFinal reportShoemaker Ronald R Pazmany PL-2 · Reading, PAThe pilot’s failure to maintain a proper descent rate, resulting in a hard landing short of the runway and collapse of the right main landing gear.May 6, 2025 · N289RS · Substantial damageNTSB GAA25WA137Accident · Serious injuriesClass 5 · ForeignGulfstream Aerospace G-V · Cabo San Lucas, MexicoApr 10, 2025 · N1948Z · Substantial damageNTSB DCA25WA199IncidentClass 5 · ForeignBoeing 737-400 · Puerto Inírida, ColombiaApr 10, 2025 · HK5447NTSB CEN25LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 175A · Lakeview, ARThe pilot landed short of the runway.Mar 13, 2025 · N8000T · Substantial damage
See all 133 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\" = '370')
  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.