NTSB investigations, NC
93 cases where the sequence of events included Runway excursion.
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.\"eventStateOrRegion\" = 'NC' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'NC' AND c."eventCountry" = 'USA' 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 GAA16CA183Accident · Minor injuriesData collectionFinal reportPiper PA22 · Pantego, NCA loss of directional control during the takeoff roll in gusting wind conditions, which resulted in a runway excursion, a nose over, and an impact with terrain. Contributing to the accident was the pilot's decision to takeoff in gusting crosswind conditions.NTSB GAA16CA082Accident · No injuriesData collectionFinal reportAeronca 7BCM · Reidsville, NCThe pilot's loss of pitch control while maneuvering at low altitude, which resulted in a collision with terrain, a left main landing gear collapse, and runway excursion.NTSB ERA16LA059Accident · No injuriesLimited investigationFinal reportPacific Aerospace 750XL · Raeford, NCThe pilot's failure to obtain the proper touchdown point and speed during a precautionary landing with the engine shut down. Contributing to the accident was an erroneous engine torque indication, which led the pilot to shut the engine down, for reasons that…NTSB ERA15CA320Accident · Minor injuriesData collectionFinal reportSanderson Herbert H SHA Glasair · Bladenboro, NCThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a ditch.NTSB GAA15CA212Accident · Minor injuriesData collectionFinal reportMain Air Rapier · Reidsville, NCThe student pilot landed with variable wind conditions, which resulted in an in-flight loss of control and subsequent impact with terrain.NTSB GAA15CA192Accident · No injuriesData collectionFinal reportCessna R172K · Fairfield, NCThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and impact with terrain.NTSB GAA15CA185Accident · No injuriesData collectionFinal reportBarron Starduster SA 300 · Whiteville, NCThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a collision with terrain.NTSB ERA15LA244Accident · No injuriesLimited investigationFinal reportRaddatz Steve RV 8 · Monroe, NCThe pilot's failure to maintain directional control during the landing.NTSB GAA15CA115Accident · Minor injuriesData collectionFinal reportSmiley James E RAG Wing RW-6 · Mocksville, NCThe pilot's loss of directional control during takeoff, which resulted in a runway excursion and impact with a building.NTSB GAA15CA098Accident · No injuriesData collectionFinal reportSchweizer SGS 1 26B · Mocksville, NCThe glider pilot over-ran the runway and impacted a structure after encountering a strong updraft on short final.NTSB GAA15CA072Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA40 · Fuquay-Varina, NCThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway overrun.NTSB ERA15CA154Accident · No injuriesData collectionFinal reportBeech 58 · Monroe, NCThe pilot's failure to maintain a proper glidepath and failure to perform a go-around once a safe landing could not accomplished, which resulted in a landing area overshoot and runway excursion.NTSB ERA15CA086Accident · No injuriesData collectionFinal reportCessna 310N · Liberty, NCThe pilot's improper landing flare, which resulted in a hard landing and collapse of the left main landing gear.NTSB ERA14CA373Accident · Minor injuriesData collectionFinal reportPiper PA-46-350P · Statesville, NCThe pilot's failure to maintain a proper glide path and airspeed on final approach, which resulted in a long landing and runway excursion.NTSB ERA14CA270Accident · No injuriesData collectionFinal reportWonder Michael S Harmon Rocket · Winston Salem, NCThe pilot's failure to maintain directional control during landing in a gusty crosswind which resulted in a runway excursion and collision with terrain.NTSB ERA14LA072Accident · No injuriesLimited investigationFinal reportCessna 182T · Burlington, NCA loss of airplane control during takeoff for reasons that could not be determined due to the postaccident condition of the elevator control system.NTSB ERA14LA071Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Monroe, NCThe pilot’s operation of the airplane with underinflated tires, which resulted in the right tire’s failure during takeoff and a subsequent runway excursion.NTSB ERA14CA017Accident · Serious injuriesData collectionFinal reportBeech A36 · Burnsville, NCThe pilot's failure to achieve a proper touchdown point during landing, which resulted in a runway excursion.NTSB ERA14LA022Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Franklin, NCThe failure of the left main landing gear brake line during landing due to the loss of hydraulic fluid. Contributing to the accident was a fatigue crack through the brake line that had formed due to contact with a swaged sleeve as a result of exfoliation…NTSB ERA13CA393Accident · No injuriesData collectionFinal reportCessna 172E · Apex, NCThe pilot's failure to attain the proper touchdown point on the runway, which resulted in a runway overrun and subsequent aircraft noseover.NTSB ERA13LA318Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Beaufort, NCA failure of the right brake for reasons that could not be determined because a postaccident examination of the brake could not be performed.NTSB ERA13CA206Accident · Minor injuriesData collectionFinal reportPoole Robert C JR Van's · Salisbury, NCThe pilot's improper landing flare, which resulted in a hard landing, and his subsequent decision to exit the paved runway onto the soft terrain.NTSB ERA13LA095Accident · No injuriesLimited investigationFinal reportCessna 150J · Indian Trail, NCThe flight instructor’s failure to maintain adequate glidepath and airspeed control during short final approach and the airplane’s improper touchdown point, which resulted in a runway overrun.NTSB ERA12CA558Accident · No injuriesData collectionFinal reportBeech 35-C33 · Burlington, NCThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA12CA464Accident · No injuriesData collectionFinal reportPiper PA32-301FT · Brevard, NCThe pilot’s failure to execute a go-around following an approach that was high and fast, which resulted in a runway overrun.NTSB ERA12CA310Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Burlington, NCThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB ERA12CA160Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Raleigh, NCThe pilot's loss of directional control while landing in gusting wind conditions.NTSB ERA12CA040Accident · No injuriesData collectionFinal reportEngineering & Research 415-C · Mebane, NCThe pilot's delay in aborting the takeoff.NTSB ERA11CA346Accident · No injuriesData collectionFinal reportCessna 177 · Boone, NCThe pilot's delay in executing a go-around.NTSB ERA11CA181Accident · Minor injuriesData collectionFinal reportCessna 172K · Ocracoke, NCThe pilot’s inadequate flare and failure to regain control of the airplane while attempting to recover from bounced landing.NTSB ERA11CA174Accident · Serious injuriesData collectionFinal reportPiper J3C-65 · Maysvile, NCThe pilot-rated passenger’s loss of directional control during takeoff and the pilot’s delayed remedial action, which resulted in a runway excursion and collision with trees.NTSB ERA11LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Dublin, NCThe pilot’s improper touchdown speed which resulted in a runway overrun. Contributing to the accident was the undetermined malfunction of the airspeed indicator.NTSB ERA11FA001Accident · Minor injuriesField investigationFinal reportCessna 550 · Manteo, NCThe pilot-in-command's failure to maintain proper airspeed and his failure to initiate a go-around, which resulted in the airplane touching down too fast on a short, wet runway and a subsequent runway overrun. Contributing to the accident was the copilot's…NTSB ERA10LA504Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Mocksville, NCThe pilot’s failure to attain the proper touchdown point, following a loss of engine power due to carburetor icing.NTSB ERA10CA448Accident · No injuriesData collectionFinal reportCessna 182E · Edenton, NCThe pilot's inadequate compensation for crosswind conditions while landing, which resulted in a loss of directional control.NTSB ERA10FA356Accident · 1 fatalField investigationFinal reportCirrus SR20 · Chapel Hill, NCThe pilot's improper recovery from a bounced landing and subsequent improper go-around procedure, which resulted in a loss of directional control, runway excursion, and collision with a tree.NTSB ERA10CA168Accident · No injuriesData collectionFinal reportAeronca 7AC · Roanoke Rapids, NCThe pilot’s failure to maintain directional control during a crosswind landing/rollout.NTSB ERA10LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Hatteras, NCThe pilot's inability to maintain directional control during an aborted takeoff for undetermined reasons.NTSB ERA09CA461Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Rockingham, NCThe pilot's failure to maintain directional control on landing roll out.NTSB ERA09CA395Accident · Minor injuriesData collectionFinal reportPiper PA-28-235 · Rutherford, NCThe pilot's failure to maintain adequate airspeed while performing a go-around which resulted in a stall.NTSB ERA09CA065Accident · No injuriesData collectionFinal reportPiper PA46 · Oak Island, NCThe pilot's failure to maintain directional control during takeoff. Contributing to the accident were gusting crosswinds.NTSB MIA08CA184Accident · No injuriesData collectionFinal reportGulfstream-Schweizer G-164B · Pantego, NCThe pilot's failure to maintain directional control on the landing roll out.NTSB MIA08CA157Accident · No injuriesData collectionFinal reportCessna 172 · Wingate, NCThe student pilot's failure to maintain control of the airplane during a go-around.