NTSB investigations, VA

78 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\" = 'VA' 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 ERA15CA121Accident · No injuriesData collectionFinal reportAutogyro Calidus · Crozet, VAThe pilot's improper control inputs which resulted in a loss of control and rollover during the takeoff roll.Feb 4, 2015 · N595X · Substantial damageNTSB ERA14CA447Accident · No injuriesData collectionFinal reportCub Crafters CC11 100 · Culpepper, VAThe failure of both pilots to maintain directional control during landing.Sep 19, 2014 · N749KY · Substantial damageNTSB ERA14CA240Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Norfolk, VAThe student pilot's failure to maintain directional control during takeoff.May 14, 2014 · N32002 · Substantial damageNTSB ERA14CA097Accident · No injuriesData collectionFinal reportCessna 195B · Winchester, VAThe pilot's attempt to avoid a deer on the runway, which resulted in loss of aircraft control, a runway excursion, and collision with a runway sign.Jan 19, 2014 · N1960C · Substantial damageNTSB ERA14CA033Accident · No injuriesData collectionFinal reportStinson SR 5A · Manassas, VAThe pilot's inadvertent application of only one brake during landing roll, resulting in a ground loop and runway excursion.Oct 29, 2013 · N14163 · Substantial damageNTSB ERA13CA438Accident · No injuriesData collectionFinal reportCessna 182P · Newport News, VAThe pilot's failure to maintain directional control during landing resulting in a runway excursion.Sep 18, 2013 · N58482 · Substantial damageNTSB ERA13CA419Accident · No injuriesData collectionFinal reportPiper PA28 151 · Abingdon, VAThe failure of the pilot to maintain directional control during a crosswind landing resulting in collision with terrain and aft displacement of the nose landing gear.Sep 13, 2013 · N4379F · Substantial damageNTSB ERA13LA418Accident · No injuriesLimited investigationFinal reportFleet 7 · Louisa, VAMaintenance personnel’s improper service, adjustment, and inspection of the brakes, which resulted in a runway excursion and subsequent noseover.Sep 7, 2013 · N9433 · Substantial damageNTSB ERA12CA496Accident · Minor injuriesData collectionFinal reportCessna 172S · Culpeper, VAThe pilot’s failure to maintain directional control during an attempted takeoff.Aug 3, 2012 · N6276Z · Substantial damageNTSB ERA12CA288Accident · No injuriesData collectionFinal reportCessna 180J · Abingdon, VAThe passenger’s inadvertent blockage of the rudder pedals, which resulted in the pilot’s inability to maintain directional control during the landing roll.Apr 17, 2012 · N180BA · Substantial damageNTSB ERA12CA213Accident · No injuriesData collectionFinal reportZenair CH 2000 · Warrenton, VAThe student pilot's failure to follow instruction and to relinquish control of the airplane to the flight instructor in a timely manner, which resulted in a runway excursion.Feb 13, 2012 · N200ZA · Substantial damageNTSB ERA12LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Norfolk, VAThe pilot's inability to maintain directional control during takeoff for undetermined reasons. Contributing to the accident was the pilot's delayed decision to abort the takeoff.Oct 5, 2011 · N180RN · Substantial damageNTSB ERA11CA488Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Leesburg, VAThe pilot did not follow the engine start checklist.Sep 10, 2011 · N878AC · Substantial damageNTSB ERA11LA466Accident · No injuriesLimited investigationFinal reportPiper PA46 · Manasses, VAAn undetermined nose landing gear steering anomaly or anomalies, which resulted in the pilot's inability to maintain directional control of the airplane during the landing rollout. The damage to the nose landing gear precluded a determination of the cause of…Aug 19, 2011 · N133SR · Substantial damageNTSB ERA11CA053Accident · No injuriesData collectionFinal reportLuscombe 8A · Hot Springs, VAThe pilot's inadequate compensation for the crosswind during landing.Nov 6, 2010 · N71102 · Substantial damageNTSB ERA10CA500Accident · No injuriesData collectionFinal reportBoeing A75N1 · Bealeton, VAThe pilot under instruction’s improper recovery from a bounced landing and the flight instructor’s delayed remedial action, which resulted in a ground loop and collision with trees.Sep 24, 2010 · N65648 · Substantial damageNTSB ERA10TA429Accident · No injuriesFinal reportBell UH1H · Warrenton, VAThe pilot receiving instruction's failure to maintain a proper pitch attitude during the practice autorotation maneuver.Aug 16, 2010 · UNREG · Substantial damageNTSB ERA10CA329Accident · No injuriesData collectionFinal reportNorth American SNJ-4 · Suffolk, VAThe pilot's failure to maintain directional control during the landing.Jun 17, 2010 · N43NA · Substantial damageNTSB ERA09LA528Accident · No injuriesLimited investigationFinal reportMooney M20K · Farmville, VAThe pilot’s failure to maintain directional control during the landing rollout.Sep 18, 2009 · N999DJ · Substantial damageNTSB ERA09CA463Accident · No injuriesData collectionFinal reportAmerican Legend AL3C · Warrenton, VAThe pilot's improper application of brakes during the landing rollout.Aug 15, 2009 · N3737G · Substantial damageNTSB ERA09CA430Accident · No injuriesData collectionFinal reportCessna 172N · Manassas, VAThe student pilot’s failure to maintain directional control during takeoff.Jul 30, 2009 · N733BS · Substantial damageNTSB ERA09CA422Accident · Minor injuriesData collectionFinal reportDart GW · Warrenton, VAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the wet turf landing surface.Jul 25, 2009 · N20930 · Substantial damageNTSB ERA09CA405Accident · No injuriesData collectionFinal reportPiper PA28 · Blacksburg, VAThe pilot's failure to maintain directional control during the takeoff roll.Jul 14, 2009 · N7418W · Substantial damageNTSB ERA09CA374Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Quinton, VAA loss of directional control on landing for undetermined reasons.Jun 29, 2009 · N38978 · Substantial damageNTSB ERA09CA365Accident · No injuriesData collectionFinal reportCessna 172H · Lovingston, VAThe pilot's failure to maintain directional control during takeoff.Jun 20, 2009 · N1664F · Substantial damageNTSB ERA09LA330Accident · No injuriesLimited investigationFinal reportYakovlev/Day YAK-11 · Culpeper, VAThe pilot’s failure to maintain directional control during landing.Jun 8, 2009 · N7YK · Substantial damageNTSB ERA09LA111Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works SportCruiser · Emporia, VAThe student pilot's failure to maintain directional control during the landing. Contributing to the accident was the improperly marked airspeed indicator and the airplane manufacturer's improper airspeed information.Dec 23, 2008 · N524SC · Substantial damageNTSB NYC08LA247Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Culpeper, VAThe pilot's failure to maintain directional control of the airplane while landing in a quartering tailwind.Jul 12, 2008 · N1066M · Substantial damage