NTSB investigations, 2023

7 cases where the defining event was Landing area overshoot.

Cases per year

20082026
NTSB investigations, 2023 per year, 2008–2026: 234 cases
200818
200912
201024
201120
201218
201310
201413
201510
201610
201710
20187
20193
20208
202111
202213
20237
202415
202516
20269

Latest 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 year(c.\"eventDate\") = 2023
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '380')
  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.

NTSB CEN24LA072Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Red Lake, MNThe pilot’s inadequate landing surface evaluation and failure to stop the airplane on the frozen lake, which resulted the airplane continuing into a crack in the ice.Dec 19, 2023 · N46056 · Substantial damageNTSB CEN24LA037Accident · Minor injuriesClass 3 · LimitedFinal reportCharles L. Hayes Lancair IVP Turbine · McKinney, TXThe pilot’s failure to attain the proper touchdown point during landing, which resulted in a runway excursion and collision with terrain and a vehicle.Nov 11, 2023 · N751HP · Substantial damageNTSB GAA24WA031AccidentClass 5 · ForeignLearjet 35 · Cuernavaca, MexicoNov 1, 2023 · XA-IRE · DestroyedNTSB ERA24LA031Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Ocklawaha, FLThe pilot’s failure to attain a proper touchdown point which resulted in a runway overrun and subsequent impact with a fence.Oct 29, 2023 · N9159W · Substantial damageNTSB ERA24LA029Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Elmira, NYThe pilot’s failure to attain a proper glidepath for a landing on the intended runway, which resulted in an off-airport landing and impact with soft terrain.Oct 28, 2023 · N17903 · Substantial damageNTSB GAA23WA187Accident · No injuriesClass 5 · ForeignGippsland GA8 · Rat Island, AustraliaApr 6, 2023 · VH-TBU · Substantial damageNTSB GAA23WA089Accident · No injuriesClass 5 · ForeignBeecraft SKA350 · Catarman National Airport, PhilippinesJan 17, 2023 · RP-C6198 · Substantial damage