Skip to content

NTSB investigations, 2023

152 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
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 CEN24LA078Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 210M · Gulfport, MSThe pilot’s failure to maintain directional control during the go-around with a crosswind.Dec 23, 2023 · N6PD · Substantial damage NTSB ERA24LA070Accident · No injuriesClass 3 · LimitedFinal reportBeech A24 · Miami, FLA partial loss of engine power during initial climb for undetermined reasons, resulting in a forced landing.Dec 18, 2023 · N52LV · Substantial damage NTSB CEN24LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Stephenville, TXThe pilot’s failure to maintain directional control during landing that resulted in an impact with terrain.Dec 17, 2023 · N4501E · Substantial damage NTSB ERA24LA064Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Sidney, OHThe pilots’ improper landing flare, which resulted in a hard landing, runway excursion, and subsequent impact with a terminal sign and taxi light.Dec 12, 2023 · N6643H · Substantial damage NTSB CEN24LA059Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Lubbock, TXThe pilot’s failure to maintain directional control during the landing that resulted in a runway excursion, an impact with a runway sign, and a nose gear collapse.Dec 10, 2023 · N8538N · Substantial damage NTSB CEN24LA056Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Fordyce, ARThe pilot’s failure to attain a proper touchdown point following an unidentified electrical system failure and subsequent partial loss of engine power, which resulted in a runway overrun and impact with terrain. Contributing to the accident was the pilot’s…Dec 5, 2023 · N600VS · Substantial damage NTSB WPR24LA046Accident · Serious injuriesClass 3 · LimitedFinal reportCessna P210N · Big Bear, CAA loss of engine power during the initial climb for undetermined reasons, which resulted in an aborted takeoff and runway excursion.Dec 2, 2023 · N7LV · Substantial damage NTSB GAA24WA054Accident · No injuriesClass 5 · ForeignCessna A188 · Ipiranga do Norte, BrazilNov 30, 2023 · SCF-PP · Substantial damage NTSB ERA24LA051Accident · No injuriesClass 3 · LimitedFinal reportLancair 235 · Stuart, FLA landing gear collapse due to a hydraulic fluid leak in the landing gear system.Nov 28, 2023 · N235N · Substantial damage NTSB CEN24LA043Accident · No injuriesClass 4 · LimitedFinal reportBearhawk Four · Eau Claire, WIThe pilot’s failure to maintain directional control during landing.Nov 21, 2023 · N274LC · Substantial damage NTSB ERA24LA044Accident · Minor injuriesClass 4 · LimitedFinal reportAero Commander 112 · Saluda, SCThe pilot’s failure to maintain directional control of the airplane during an aborted landing in crosswind conditions. Contributing to the accident was the flight instructor’s inadequate remedial action.Nov 19, 2023 · N1143J · Substantial damage NTSB CEN24LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C · Buffalo, MNThe pilot's failure to maintain directional control during the landing roll with a quartering headwind.Nov 17, 2023 · N30494 · Substantial damage NTSB 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 damage NTSB ERA24LA033Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Orlando, FLA partial loss of engine power during initial climb after takeoff for undetermined reasons.Nov 10, 2023 · N91PF · Substantial damage NTSB CEN24LA032Accident · Minor injuriesClass 4 · LimitedFinal reportTom Hodgson 29 · Kokomo, INThe pilot’s failure to maintain directional control during the landing roll.Nov 5, 2023 · N29XB · Substantial damage NTSB ERA24LA086Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Morganton, NCThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and an impact with the runway’s precision approach path indicator (PAPI) lights.Oct 22, 2023 · N5954Q · Substantial damage NTSB ERA24LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Jackson, TNThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a runway excursion.Oct 20, 2023 · N9101J · Substantial damage NTSB WPR24LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Bandera, WAThe pilot’s decision to land at a closed water-soaked grass runway, which resulted in a runway excursion.Oct 18, 2023 · N734LJ · 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 CEN24LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Denton, TXThe student pilot’s failure to maintain directional control while landing with a tailwind.Oct 13, 2023 · N6605J · Substantial damage NTSB ERA24LA004Accident · No injuriesClass 4 · LimitedFinal reportMichael J Wright SA300 · Georgetown, KYThe pilot’s failure to maintain directional control of the airplane during the landing roll in gusting a gusting crosswind, resulting in a runway excursion and nose over.Oct 8, 2023 · N27MW · Substantial damage NTSB ERA24LA005Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · Harrisonburg, VAThe pilot’s inadequate compensation for the prevailing wind conditions, which resulted in a loss of control and subsequent runway excursion.Oct 7, 2023 · N13BF · Substantial damage NTSB GAA24WA008AccidentClass 4 · ForeignLearjet 45 · Veracruz, MexicoOct 4, 2023 · XA-JAO NTSB ERA24LA002Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Gallipolis, OHA collapse of the nose landing gear during landing, which resulted in a runway excursion and collision with an approach lighting system.Oct 2, 2023 · N7461W · Substantial damage NTSB CEN24LA001Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 23 · Waupaca, WIThe pilot’s failure to maintain directional control during the go-around, that resulted in a runway excursion and an impact with terrain.Oct 1, 2023 · N1963F · Substantial damage NTSB ERA23LA387Accident · No injuriesClass 4 · LimitedFinal reportJohn W Moll Vans RV-7 · Liberty, SCThe pilot’s failure to maintain directional control during the takeoff roll which resulted in a runway excursion and substantial damage to the left wing and left horizontal stabilizer.Sep 29, 2023 · N557JM · Substantial damage NTSB CEN23LA425Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802 · Herington, KSThe design of the spray valve control lever, which restricted the range of the left rear rudder and brake pedal and resulted in a loss of control during landing.Sep 28, 2023 · N445HA · Substantial damage NTSB CEN23LA417Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28RT-201 · Chesterfield, MOThe partial retraction of the right main and nose landing gear during landing rollout for undetermined reasons.Sep 23, 2023 · N2242N · Substantial damage NTSB CEN23LA421Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Midland, TXThe student pilot’s improper landing flare, which resulted in a hard, bounced landing, and the nose landing gear collapse.Sep 22, 2023 · N391SP · Substantial damage NTSB ERA23LA375Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Winston-Salem, NCThe pilot’s loss of directional control upon landing which resulted in substantial damage to the left wing and left horizontal stabilizer.Sep 18, 2023 · N1451U · Substantial damage NTSB CEN23LA420Accident · No injuriesClass 4 · LimitedFinal reportCessna 150K · South Saint Paul, MNThe pilot’s inadvertent brake application during takeoff which resulted in a loss of directional control and runway excursion. Contributing to the accident was the pilot’s improper seat position.Sep 17, 2023 · N6398G · Substantial damage 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 CEN23LA400Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Eden Prairie, MNThe pilot’s failure to maintain directional control during a landing with a left crosswind.Sep 3, 2023 · N5254D · Substantial damage NTSB CEN23LA380Accident · No injuriesClass 4 · LimitedFinal reportCessna 182T · Klein, TXThe pilot’s failure to maintain directional control during the crosswind landing.Aug 23, 2023 · N908VA · Substantial damage NTSB WPR23LA321Accident · No injuriesClass 3 · LimitedFinal reportCessna T210M · Napa, CAInsufficient hydraulic pressure to the landing gear system following the completion of the emergency gear extension checklist, which resulted in the main landing gear collapsing during landing. Contributing to the accident was a loss of electrical power for…Aug 21, 2023 · N6535B · Substantial damage NTSB ERA23LA343Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-17 · Millbrook, NYThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.Aug 21, 2023 · N4814H · 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 CEN23LA375Accident · No injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Rice, MNThe pilot’s failure to maintain directional control during the landing roll with a left crosswind.Aug 21, 2023 · N943QC · Substantial damage NTSB CEN23LA386Accident · Serious injuriesClass 4 · LimitedFinal reportSilverlight AR-1 · Granbury, TXThe pilot’s improper takeoff procedure which resulted in a loss of control during takeoff.Aug 20, 2023 · N57AR · Substantial damage NTSB CEN23LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 150D · New Haven, INThe pilot’s loss of directional control while landing, which resulted in a runway excursion, impact with corn stalks, and subsequent nose over.Aug 20, 2023 · N4150U · Substantial damage NTSB WPR23LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Moab, UTThe pilot’s loss of directional control during landing, which resulted in a ground loop.Aug 15, 2023 · N9977N · 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 GAA23WA236Accident · No injuriesClass 5 · ForeignCessna 350 · Barcelona, SpainAug 11, 2023 · N1097L · Substantial damage NTSB CEN23LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna A188B · Chillicothe, MOThe pilot’s decision to operate the airplane with a known tailwheel anomaly, which resulted in a loss of directional control.Aug 11, 2023 · N9237R · 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 CEN23LA362Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Harvard, ILThe pilot’s failure to maintain directional control during takeoff that resulted in a runway excursion and an impact with the cornfield.Aug 10, 2023 · N2351A · 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 GAA23WA232Accident · No injuriesClass 5 · ForeignCessna 180H · Lolland, DenmarkAug 5, 2023 · N9902V · Substantial damage