Skip to content

NTSB investigations, 2023

35 cases where the defining event was Runway excursion.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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" = '300') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = '300')
  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.

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" = '300')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB GAA24WA054Accident · No injuriesClass 5 · ForeignCessna A188 · Ipiranga do Norte, BrazilNov 30, 2023 · SCF-PP · Substantial damage NTSB ERA24LA012Accident · No injuriesClass 3 · LimitedFinal reportBeech 300 · Atlanta, GAThe pilot’s failure to maintain a proper approach speed, which resulted in a runway overrun. Contributing to the runway overrun were the pilot’s application of full reverse at an airspeed higher than that allowed by the system, which added power and forward…Oct 18, 2023 · N93GA · Substantial damage NTSB GAA24WA008AccidentClass 4 · ForeignLearjet 45 · Veracruz, MexicoOct 4, 2023 · XA-JAO NTSB DCA23WA453IncidentClass 5 · ForeignBoeing 777 · Thalang - Phuket, ThailandSep 15, 2023 · RA--73141 · Minor damage NTSB ANC23LA073Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Beluga, AKThe pilot’s delayed go-around decision with insufficient runway remaining.Sep 10, 2023 · N124UA · Substantial damage NTSB CEN23LA403Accident · No injuriesClass 3 · LimitedFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Wheeling, ILA loss of braking effectiveness during landing for reasons that could not be determined, which resulted in a runway excursion.Aug 21, 2023 · N39TT · Substantial damage NTSB WPR23LA363Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Needles, CAAn encounter with windshear during the initial climb after takeoff, resulting in a loss of control and a subsequent hard landing.Aug 13, 2023 · N2957N · Substantial damage NTSB WPR23LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Marysville, CAThe flight instructor’s failure to monitor the airplane’s speed during a high-speed taxi, resulting in a runway excursion.Aug 10, 2023 · N20268 · Substantial damage NTSB GAA23WA241AccidentClass 5 · ForeignCessna 208 · Limpopo Province, South AfricaAug 7, 2023 · ZS-JEM · Minor damage NTSB DCA23WA398Incident · No injuriesClass 5 · ForeignBoeing 747-481F · Ningbo, ChinaAug 7, 2023 · N401KZ · No damage NTSB ERA23LA298Accident · Serious injuriesClass 3 · LimitedFinal reportDouglas A-4K · MCAS Cherry Point, NCThe pilot’s failure to identify and appropriately respond to an anomalous nose-down trim condition during the takeoff roll, which resulted in his decision to eject and the airplane’s subsequent runway excursion.Jul 12, 2023 · N143EM · Substantial damage NTSB CEN23LA282Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-46-600TP · Brookshire, TXOn July 4, 2023, about 1911 central daylight time, a Piper PA-46-600TP airplane, N600BJ, was substantially damaged when it was involved in an accident at Houston Executive Airport, (TME), Brookshire, Texas. The pilot and passenger were not injured. The…Jul 5, 2023 · N600BJ · Substantial damage NTSB WPR23LA254Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MX7-180C · Belgrade, MTThe pilot’s failure to maintain directional control during landing with a quartering tailwind, which resulted in a runway excursion and nose over.Jul 4, 2023 · N3171H · Substantial damage NTSB DCA23WA345OccurrenceClass 5 · ForeignBoeing 777 · Dhaka, BangladeshJun 28, 2023 · HZ-AK28 · No damage NTSB GAA23WA167Accident · No injuriesClass 5 · ForeignSocata TBM 700 · Narsarsuaq, GreenlandJun 17, 2023 · N44WN · Substantial damage NTSB ERA23LA294Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA50 · Wagener, SCThe pilot’s decision to take off from a short, grass runway in gusting wind conditions, resulting in a rejected takeoff and runway excursion.Jun 13, 2023 · OE-DSD · Substantial damage NTSB DCA23WA317IncidentClass 5 · ForeignBoeing 737 · Perth Airport, AustraliaJun 11, 2023 · VH-IWQ · No damage NTSB ERA23LA261Accident · No injuriesClass 3 · LimitedFinal reportDassault-Breguet Falcon 10 · Panama City, FLThe flight crew’s failure to appropriately configure the airplane for landing, which resulted in a failed attempt to utilize the thrust reversers during landing and the inability to stop the airplane using its brakes due to increased forward thrust.…Jun 7, 2023 · N87RT · Substantial damage NTSB DCA23WA325IncidentClass 5 · ForeignBoeing 747 · Bangkok, ThailandMay 29, 2023 · B-2425 · Minor damage NTSB ERA23FA235Accident · No injuriesClass 3 · FieldFinal reportHonda HA-420 · Summerville, SCThe pilot’s improper calculation of the airplane’s landing approach speed and required landing distance, which resulted in the airplane touching down fast with inadequate runway available, and a subsequent runway excursion.May 18, 2023 · N255HJ · Substantial damage NTSB DCA23WA367Incident · No injuriesClass 5 · ForeignEmbraer 195 · Salvador, BrazilMay 10, 2023 · PS-AED · Minor damage NTSB GAA23WA144AccidentClass 5 · ForeignBeechcraft C90 · Bareilly, IndiaMay 2, 2023 · VT-RSL · Substantial damage NTSB ERA23LA215Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402A · Good Hope, ALThe pilot’s decision to land on a runway where there was insufficient clearance from obstructions (wheat crop) to operate safely.Apr 24, 2023 · N623LA · Substantial damage NTSB ERA23LA193Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · West Mifflin, PAThe student pilot’s decision to abort the takeoff and land on the runway without sufficient runway remaining, which resulted in a runway overrun.Apr 10, 2023 · N476TA · Substantial damage NTSB ERA23LA189Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Ft. Lauderdale, FLThe pilot’s ineffective use of the airplane’s brakes, which resulted in a runway overrun.Apr 9, 2023 · N404PJ · Substantial damage NTSB DCA23WA204Incident · No injuriesClass 5 · ForeignBombardier BD500 · Riga, LatviaMar 8, 2023 · YL-AAP NTSB GAA23WA088AccidentClass 5 · ForeignCessna 337G · Itzehoe, GermanyFeb 28, 2023 · N337BQ · Substantial damage NTSB WPR23LA108Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Lander, WYThe pilot’s failure to maintain directional control during landing.Feb 7, 2023 · N4045R · Substantial damage NTSB GAA23WA064Accident · No injuriesClass 5 · ForeignLearjet 60 · Buenos Aires, ArgentinaFeb 2, 2023 · LV-JJQ · Substantial damage NTSB ANC23LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna 207 · Newtok, AKThe pilot’s failure to maintain directional control while landing with a crosswind on an ice-covered runway, resulting in a loss of control and subsequent impact with a snowbank. A factor was the check airman’s inadequate supervision.Feb 2, 2023 · N9996M · Substantial damage NTSB DCA23WA143IncidentClass 5 · ForeignBoeing 777-319ER · Auckland, New ZealandJan 27, 2023 · ZK-OKN · Minor damage NTSB ERA23LA112Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-31-350 · Middlefield, OHA runway overrun during a precautionary landing following a total loss of right engine power due to detonation and subsequent oil starvation. Contributing was the pilot’s failure to lower the flaps and the excessive airspeed at touchdown.Jan 18, 2023 · N101MA · Substantial damage NTSB ANC23LA018Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-180 · Glennallen, AKThe pilot’s failure to maintain airspeed during a drag maneuver, which resulted in an overrun and subsequent impact with terrain.Jan 13, 2023 · N5373Y · Substantial damage NTSB WPR23LA089Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-C55 · Yelm, WAThe pilot’s failure to attain a proper touchdown point during landing with a tailwind which resulted in a runway over run. Contributing to the accident was a wet runway.Jan 12, 2023 · N225V · Substantial damage NTSB DCA23WA127IncidentClass 5 · ForeignAirbus A330-323 · Amsterdam, NetherlandsJan 12, 2023 · N802NW · Minor damage