NTSB investigations, NV

63 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\" = 'NV' 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 WPR11CA030Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Pahrump, NVThe pilot's inadvertent activation of brakes upon touchdown, resulting in a loss of directional control.Oct 27, 2010 · N7807D · Substantial damageNTSB WPR10CA254Accident · No injuriesData collectionFinal reportBoeing B75 · Yerington, NVThe pilot's inadequate compensation for the crosswind condition, resulting in the loss of directional control during the landing roll.May 22, 2010 · N1193N · Substantial damageNTSB WPR10CA052Accident · No injuriesData collectionFinal reportNorth American T6-G · Carson City, NVThe pilot's failure to maintain directional control during landing.Nov 8, 2009 · N48N · Substantial damageNTSB WPR10LA040Accident · Serious injuriesLimited investigationFinal reportHallbauer Dragonfly Mark II · Las Vegas, NVThe CFI's failure to maintain directional control of the airplane during takeoff.Oct 30, 2009 · N555RX · Substantial damageNTSB WPR10CA017Accident · No injuriesData collectionFinal reportCessna 182F · Elko, NVThe pilot's failure to maintain directional control while taking off in known gusty wind conditions.Oct 12, 2009 · N3567Y · Substantial damageNTSB WPR09CA404Accident · No injuriesData collectionFinal reportJabiru J230-SP · Reno, NVThe pilot’s failure to maintain directional control throughout the takeoff roll.Aug 18, 2009 · N690J · Substantial damageNTSB WPR09LA401Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gerlach, NVThe pilot’s delay in aborting the takeoff, resulting in a runway excursion.Aug 9, 2009 · N32105 · Substantial damageNTSB WPR09LA457Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Ely, NVThe pilot's failure to maintain directional control during the landing roll.Jul 28, 2009 · N555Q · Substantial damageNTSB WPR09LA354Accident · Serious injuriesLimited investigationFinal reportLeider T-18 · Carson City, NVThe pilot’s failure to maintain directional control during landing.Jul 18, 2009 · N37GL · Substantial damageNTSB WPR09CA240Accident · No injuriesData collectionFinal reportFagan BearHawk · Hadley, NVThe pilot's inadequate compensation for the gusting crosswinds during takeoff.May 12, 2009 · N232PF · Substantial damageNTSB WPR09CA131Accident · No injuriesData collectionFinal reportCessna TR182 · Amargosa Valley, NVThe pilot's failure to maintain adequate airspeed and runway alignment.Feb 27, 2009 · N2518S · Substantial damageNTSB WPR09CA109Accident · No injuriesData collectionFinal reportSeher Bearhawk · Reno, NVThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during takeoff. Contributing to the accident were a crosswind and the pilot's delayed decision to abort the takeoff.Feb 5, 2009 · N846BH · Substantial damageNTSB WPR09CA007Accident · No injuriesData collectionFinal reportCessna T206H · Henderson, NVThe pilot's inadequate compensation for the crosswind conditions.Oct 9, 2008 · N206TT · Substantial damage