NTSB investigations, NC

91 cases where the sequence of events included Loss of control on ground.

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

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.Jul 18, 2015 · N5453V · Substantial damageNTSB GAA15CA190Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Greensboro, NCThe pilot's decision to continue the approach after realizing the intended parameters were not attainable, resulting in a runway over-shoot, a loss of control on the ground and the consequent collision with trees.Jul 18, 2015 · N96ML · Substantial damageNTSB 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.Jul 12, 2015 · N5618 · Substantial damageNTSB 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.May 30, 2015 · N2305J · Substantial damageNTSB GAA15CA061Accident · Minor injuriesData collectionFinal reportHughes TH 55 · Morganton, NCThe flight instructor's delayed flare during a simulated auto rotation, which resulted in a tail rotor strike and rollover.May 5, 2015 · N7089S · Substantial damageNTSB GAA15CA017Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Greensboro, NCThe pilot's failure to maintain directional/pitch control during final approach, resulting in a collision with terrain.Mar 18, 2015 · N43MT · Substantial damageNTSB ERA15LA051Accident · No injuriesLimited investigationFinal reportBell Bill Kitfox 6 · Columbus, NCA loss of directional control during landing for reasons that could not be determined based on the available information.Nov 13, 2014 · N524MB · Substantial damageNTSB ERA15CA027Accident · No injuriesData collectionFinal reportCessna A188B · Louisburg, NCThe pilot's failure to maintain directional control during takeoff.Oct 23, 2014 · N731PM · Substantial damageNTSB ERA15CA013Accident · No injuriesData collectionFinal reportChampion 7FC · Reidsville, NCThe pilot's failure to maintain directional control during landing roll in gusty wind conditions.Oct 10, 2014 · N7591B · Substantial damageNTSB 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.May 21, 2014 · N85TP · Substantial damageNTSB ERA14CA082Accident · No injuriesData collectionFinal reportCessna 182H · Littleton, NCThe pilot's failure to maintain directional control during takeoff.Dec 27, 2013 · N1833X · Substantial damageNTSB 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.Nov 24, 2013 · N4185L · Substantial damageNTSB 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.Oct 23, 2013 · N7257W · Substantial damageNTSB 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.Jul 8, 2013 · N6651K · Substantial damageNTSB ERA13CA141Accident · No injuriesData collectionFinal reportCessna 180 · Halifax, NCThe pilot's decision to land in gusty crosswind conditions, which resulted in a loss of airplane directional control during the landing roll.Feb 20, 2013 · N9411C · Substantial damageNTSB ERA12CA558Accident · No injuriesData collectionFinal reportBeech 35-C33 · Burlington, NCThe pilot's improper landing flare, which resulted in a hard landing.Aug 22, 2012 · N331DP · Substantial damageNTSB ERA12CA517Accident · No injuriesData collectionFinal reportAir Tractor AT-402B · Gum Neck, NCThe pilot's failure to maintain airplane control during the takeoff roll. Contributing to the accident was the rough condition of the runway.Aug 17, 2012 · N5127T · Substantial damageNTSB ERA12CA378Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD-55-1 · Mocksville, NCThe glider pilot's failure to attain and maintain directional control during takeoff.May 28, 2012 · N817V · Substantial damageNTSB ERA12FA225Accident · 5 fatalField investigationFinal reportCessna 501 · Franklin, NCThe pilot's failure to achieve a stabilized approach, resulting in a nose-first, bounced landing. Contributing to the accident was the pilot's activation of only one thrust reverser, resulting in asymmetrical thrust.Mar 15, 2012 · N7700T · Substantial damageNTSB ERA12CA215Accident · No injuriesData collectionFinal reportCessna 140A · Mooresville, NCThe separation of the left rudder cable turnbuckle and the pilot’s subsequent loss of directional control during landing.Mar 6, 2012 · N5693C · Substantial damageNTSB ERA12CA094Accident · No injuriesData collectionFinal reportNuse George F1H Rocket · Caroleen, NCThe pilot did not maintain directional control during takeoff at night due to his distraction with a dropped flashlight, and he delayed his decision to abort the takeoff.Dec 2, 2011 · N295JS · Substantial damageNTSB ERA12LA358Accident · No injuriesLimited investigationFinal reportCessna 182C · Efland, NCThe pilot’s loss of directional control during the landing roll, which resulted in a collision with a ditch.Oct 9, 2011 · N8527T · Substantial damageNTSB ERA11CA177Accident · No injuriesData collectionFinal reportQuist Kitfox · Indian Trail, NCThe pilot's failure to maintain directional control during an aborted landing, resulting in a runway excursion and collision with a vehicle.Mar 3, 2011 · N788Q · Substantial damageNTSB 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.Mar 2, 2011 · N23249 · Substantial damageNTSB ERA10CA480Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf 912 · Pleasant Garden, NCThe pilot's loss of directional control on takeoff during an encounter with a wind gust.Sep 15, 2010 · N377JA · No damageNTSB 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.Aug 27, 2010 · N3351Y · Substantial damageNTSB 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.Jul 12, 2010 · N527MJ · Substantial damageNTSB ERA10CA227Accident · No injuriesData collectionFinal reportMaule MX7 · Greenville, NCThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of experience in the make and model airplane.Apr 11, 2010 · N897DC · Substantial damageNTSB ERA10CA224Accident · Minor injuriesData collectionFinal reportPiper PA17 · Louisburg, NCThe pilot's failure to properly secure the airplane before attempting to hand-prop the engine.Apr 11, 2010 · N4699H · Substantial damageNTSB ERA10CA168Accident · No injuriesData collectionFinal reportAeronca 7AC · Roanoke Rapids, NCThe pilot’s failure to maintain directional control during a crosswind landing/rollout.Mar 7, 2010 · N84694 · Substantial damageNTSB ERA10LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Hatteras, NCThe pilot's inability to maintain directional control during an aborted takeoff for undetermined reasons.Dec 6, 2009 · N5319J · Substantial damageNTSB ERA09CA461Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Rockingham, NCThe pilot's failure to maintain directional control on landing roll out.Aug 11, 2009 · N817PA · Substantial damageNTSB ERA09CA375Accident · Minor injuriesData collectionFinal reportWaco UPF-7 · Manteo, NCThe pilot's improper decision to exit the airplane, with the engine operating. Contributing to the accident was the inadvertent throttle movement by the passenger.Jul 4, 2009 · N32132 · Substantial damageNTSB ERA09CA321Accident · No injuriesData collectionFinal reportCessna 150M · Zebulon, NCThe pilot’s failure to maintain directional control of the airplane during landing.May 30, 2009 · N7614U · Substantial damageNTSB 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.Nov 18, 2008 · N6913Z · Substantial damageNTSB ERA09CA008Accident · No injuriesData collectionFinal reportAviat A-1B · Mooresville, NCThe pilot's improper flare while landing. Contributing to the accident was the pilot's lack of recent experience.Oct 4, 2008 · N367SA · Substantial damageNTSB MIA08CA184Accident · No injuriesData collectionFinal reportGulfstream-Schweizer G-164B · Pantego, NCThe pilot's failure to maintain directional control on the landing roll out.Aug 29, 2008 · N8137K · Substantial damageNTSB NYC08CA269Accident · Minor injuriesData collectionFinal reportCessna 172M · Jefferson, NCA loss of directional control during the takeoff roll for undetermined reasons. Contributing to the severity of the event was the descending embankment adjacent to the runway.Aug 3, 2008 · N73594 · Substantial damageNTSB NYC08CA229Accident · No injuriesData collectionFinal reportPiper PA-18-105 · Fayetteville, NCThe pilot's failure to maintain directional control during the landing roll out.Jun 20, 2008 · N221T · Substantial damageNTSB MIA08CA112Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Roseboro, NCThe pilot's failure to maintain directional control of the airplane during takeoff roll.Jun 5, 2008 · N300PB · Substantial damageNTSB NYC08CA188Accident · No injuriesData collectionFinal reportPilatus PC-12 · Burnsville, NCThe pilot's failure to maintain directional control while landing. Contributing to the accident was the gusty wind conditions.May 22, 2008 · N522DJ · Substantial damage