NTSB investigations, VA

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

NTSB 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 ERA13CA371Accident · No injuriesData collectionFinal reportCessna 172S · Manassas, VAThe student pilot’s improper recovery from a bounced landing.Aug 22, 2013 · N740SP · Substantial damageNTSB ERA13CA090Accident · No injuriesData collectionFinal reportAmerican AA-5 · Hot Springs, VAThe pilot’s failure to maintain airplane control while attempting to land in crosswind conditions.Dec 20, 2012 · N5813L · 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 ERA12CA110Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Farmville, VAThe pilot did not maintain the proper approach path, which resulted in a runway undershoot.Dec 16, 2011 · N788SR · Substantial damageNTSB ERA12LA100Accident · No injuriesLimited investigationFinal reportSigmon Harvey E Vans RV 6 · Abingdon, VAThe failure of the Pitts pilot to see and avoid the RV-6 that had landed ahead. Contributing to the accident was the Pitts pilot's inability to hear the RV-6 pilot's radio calls due to the lack of a radio in the Pitts.Nov 6, 2011 · N62HS · 2 aircraft · 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 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 ERA11CA452Accident · Minor injuriesData collectionFinal reportPiper PA-28-236 · Front Royal, VAThe pilot’s failure to attain the proper touchdown point.Aug 14, 2011 · N4341M · Substantial damageNTSB ERA11CA455Accident · No injuriesData collectionFinal reportG-Dawg Just Acft Highlander · Abingdon, VAThe pilot's inadequate compensation for wind conditions during the aborted takeoff.Aug 13, 2011 · N376CG · Substantial damageNTSB ERA10CA497Accident · Minor injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · New Castle, VAThe pilot's delayed decision to abort the takeoff, which resulted in a collision with terrain.Sep 22, 2010 · N8001J · Substantial damageNTSB ERA10CA334Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Gordonsville, VAThe student pilot’s failure to maintain directional control, and his excessive braking during the landing rollout.Jun 26, 2010 · N1516B · 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 ERA10LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Luray, VAThe pilot's premature rotation and liftoff and her subsequent failure to recognize and correct for the influence of ground effect on the airplane's takeoff performance.Nov 8, 2009 · N738CD · 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 ERA09CA430Accident · No injuriesData collectionFinal reportCessna 172N · Manassas, VAThe student pilot’s failure to maintain directional control during takeoff.Jul 30, 2009 · N733BS · 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 ERA09CA365Accident · No injuriesData collectionFinal reportCessna 172H · Lovingston, VAThe pilot's failure to maintain directional control during takeoff.Jun 20, 2009 · N1664F · Substantial damageNTSB NYC08LA323Accident · No injuriesLimited investigationFinal reportBeech A200 · Bridgewater, VAThe pilot's decision to land with a tailwind on a short, wet runway, resulting in landing long and runway overrun. Contributing to the accident was the operator’s lack of standard operating procedures for test flights.Sep 25, 2008 · N30W · 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 damageNTSB CHI08LA143Accident · No injuriesLimited investigationFinal reportBeech A36 · Norfolk, VAThe failure of the left main landing gear tire for undetermined reasons.May 24, 2008 · N4605M · Substantial damageNTSB NYC08LA099Accident · No injuriesLimited investigationFinal reportBeechcraft 390 · Leesburg, VAThe airplane's runway excursion during landing roll following an encounter with ice. Contributing to the accident was the ice-covered runway, and the airport personnel's lack of knowledge regarding the runway condition.Feb 13, 2008 · N16DK · Substantial damage