NTSB investigations
401 cases where the sequence of events included Landing area overshoot.
Cases, newest first
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '380' 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 c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '380' 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 GAA24WA288Accident · No injuriesClass 5 · ForeignCessna 208 · Migori, KenyaNTSB ERA24LA368Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Shelter Island, NYThe pilot’s failure to attain a proper touchdown point while landing, which resulted in a runway overrun.NTSB ERA24LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Medina, OHThe student pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun and subsequent noseover.NTSB CEN24LA309Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Salem, INThe pilot’s excessive airspeed during a landing, which resulted in a runway overrun and collision with terrain.NTSB ERA24LA321Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Pisgah Forest, NCThe pilot’s failure to maintain proper altitude and airspeed on final approach, resulting in a runway excursion and substantial damage to the airplane.NTSB ANC24LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Koliganek, AKThe pilot's improper landing flare and an improper recovery from a bounced landing, resulting in a loss of directional control, and a subsequent nose over.NTSB WPR24LA229Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · San Diego, CAA failure of the No. 2 cylinder due to fatigue cracking as the result of an undersized fillet radius around the edge of the cylinder head dome.NTSB WPR24LA208Accident · Minor injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Yellow Pine, IDThe pilot’s failure to attain a proper touchdown point during landing and his subsequent excessive use of brakes.NTSB WPR24LA166Accident · No injuriesClass 4 · LimitedFinal reportThomas J Spencer RV-10 · Snohomish, WAThe pilot’s failure to attain a proper touchdown point during landing with a tailwind which resulted in a runway overrun.NTSB WPR24LA151Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman G164 · Maxwell, CAThe pilot’s failure to ascertain a proper touchdown point and late decision to initiate a go-around, which resulted in a subsequent collision with vegetation.NTSB CEN24LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Davis, OKThe pilot’s failure to maintain proper airspeed on approach which resulted in an extended touchdown, bounced landing, and runway overrun.NTSB WPR24LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna 182B · Challis, IDThe pilot’s failure to attain a proper touchdown point during landing which resulted in a runway excursion and subsequent nose over.NTSB ENG24WA020Incident · No injuriesClass 5 · ForeignDe Havilland DHC8 · La Villiaze, United KingdomNTSB ERA24LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Ridgeway, VAThe pilot's failure to attain a proper touchdown point while landing, which resulted in a runway overrun.NTSB ERA24LA140Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Logan, WVThe pilot’s delayed decision to perform a go-around while attempting to land on a wet runway with a tailwind, which resulted in a runway overrun and collision with trees.NTSB WPR24LA087Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20K · Burley, IDThe failure of the pilot to fly a stabilized approach during an emergency landing with a tailwind, which resulted in a bounced landing and subsequent runway excursion during the landing roll. Contributing to the accident was the pilot’s inadequate preflight…NTSB ERA24LA101Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150M · Franklin, PAThe pilots’ inadequate preflight fuel planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.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.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.NTSB GAA24WA031AccidentClass 5 · ForeignLearjet 35 · Cuernavaca, MexicoNTSB 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.NTSB 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.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…NTSB GAA23WA187Accident · No injuriesClass 5 · ForeignGippsland GA8 · Rat Island, AustraliaNTSB GAA23WA089Accident · No injuriesClass 5 · ForeignBeecraft SKA350 · Catarman National Airport, PhilippinesNTSB ANC23LA014Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Anchorage, AKThe pilot’s failure to maintain directional control of the airplane during landing.NTSB WPR23LA028Accident · No injuriesClass 3 · LimitedFinal reportEclipse Aerospace EA500 · Mesa, AZMaintenance personnel’s failure to properly align the right brake wheel speed transducer, which rendered the right wheel brake ineffective during landing, and the pilot’s subsequent failure to follow the correct procedures to restore braking action during the…NTSB DCA23WA029Accident · No injuriesClass 5 · ForeignAirbus A330 · Mactan-Cebu, PhilippinesNTSB ERA23LA004Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Coleman, FLThe pilot's failure to maintain an appropriate final approach airspeed, which resulted in a runway excursion and impact with a fence.NTSB ANC22LA075Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180H · McCarty, AKThe pilot’s failure to initiate a go around maneuver when the airplane past the intended touch down point.NTSB ANC22LA071Accident · No injuriesClass 4 · LimitedFinal reportStinson 10A · Port Alsworth, AKThe pilot's delayed decision to execute a go-around maneuver while landing with a tailwind into a short strip, which resulted in a runway overrun and subsequent loss of control.NTSB CEN22LA411Accident · No injuriesClass 4 · LimitedFinal reportCessna T210L · Atoka, OKThe pilot's failure to land the airplane within the desired touchdown zone, which resulted in a long landing and collision with a fence.NTSB GAA22WA312Accident · No injuriesClass 5 · ForeignCessna 172P · Mukuchi - Sangar, RussiaNTSB ERA22LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Barnstable, MAThe pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun in gusting wind conditions.NTSB ERA22LA302Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502B · Center Cross, VAA loss of engine power for reasons that could not be determined.NTSB ERA22LA306Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24 · New Shoreham, RIThe pilot’s failure to attain a proper touchdown point, resulting in a runway excursion.NTSB ERA22LA202Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Fountain Inn, SCThe pilot’s failure to obtain the proper touchdown point during landing, which resulted in a runway overrun and collision with a fence.NTSB ERA22LA190Accident · No injuriesClass 4 · LimitedFinal reportTextron 525B · Caldwell, NJThe flight crew’s failure to attain a proper touchdown point during landing, which resulted in an overrun of the runway and collision with terrain.NTSB ANC22LA029Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Beluga, AKThe pilot’s excessive touchdown speed, which resulted in a long landing and impact with terrain.NTSB ERA22FA141Accident · 1 fatalClass 3 · FieldFinal reportExtra NG · St. Augustine, FLThe pilot’s excessive airspeed during landing, which resulted in a runway excursion and collision with terrain. Contributing to the accident was the loss of engine power for undetermined reasons and contributing to the severity of the accident were the…NTSB ERA22LA127Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210N · Honesdale, PAThe pilot’s failure to attain the proper touchdown point, which resulted in a runway overrun and collision with terrain.NTSB ERA22LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Hazleton, PAThe pilot’s failure to maintain proper airspeed on approach in tailwind conditions, which resulted in an extended touchdown, bounced landing, and runway excursion.NTSB ERA22LA079Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA46 · Cornelia, GAThe pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion and collision with terrain.NTSB WPR22LA039Accident · No injuriesClass 3 · LimitedFinal reportIai 1125 Westwind Astra · North Las Vegas, NVThe pilot landed long and failed to deploy the thrust reversers, which resulted in a runway overrun and impact with terrain. Contributing to the accident was the pilot’s decision to operate the airplane as a single pilot instead of the required minimum crew…NTSB ERA22LA042Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Flemingsburg, KYThe pilot’s failure to obtain the proper touchdown point or go-around, which resulted in a runway excursion.NTSB ERA22LA016Accident · Serious injuriesClass 3 · LimitedFinal reportKitfox IV · North Canaan, CTThe pilot's mismanagement of the airplane's altitude, airspeed, and course during a forced landing following a partial loss of engine power, which resulted in collision with trees and terrain. Contributing was the pilot’s inadvertent omission of stowing the…NTSB CEN21LA458Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182E · Troup, TXThe pilot’s failure to maintain directional control during landing with a variable gusting wind and his decision not to perform a go-around that resulted an overrun and impact with a fence and trees.NTSB ANC21LA088Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a loss of directional control and nose over.NTSB DCA21WA217IncidentClass 5 · ForeignBoeing 737 · Darwin, AustraliaNTSB ERA21LA316Accident · No injuriesClass 3 · LimitedFinal reportSocata TBM-700 C2 · Mount Pleasant, SCThe pilot’s decision to continue an unstable approach, which resulted in a runway excursion.