NTSB investigations, CA

286 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\" = 'CA' 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 WPR17LA165Accident · No injuriesClass 3 · LimitedFinal reportLake LA 4 · Byron, CAThe pilot’s failure to activate the hydraulic system during the approach, and his failure to ensure that the landing gear was down and locked before touchdown. Contributing to the accident was the pilot's decision to operate the airplane with an inoperative…Jul 25, 2017 · N7628L · Substantial damageNTSB WPR17LA160Accident · No injuriesLimited investigationFinal reportCessna 182L · Arbuckle, CAThe pilot’s delayed decision to abort the takeoff and his failure to properly conduct a rejected takeoff, which resulted in a runway overrun.Jul 22, 2017 · N42143 · Substantial damageNTSB GAA17CA384Accident · Minor injuriesData collectionFinal reportCessna P210 · Willits, CAThe pilot’s failure to maintain directional control while landing in gusting wind conditions. Contributing to the accident was the pilot’s failure to go around after the unstabilized approach.Jul 4, 2017 · N66NF · Substantial damageNTSB GAA17CA377Accident · No injuriesData collectionFinal reportPiper PA 22-150 · Mammoth Lakes, CAThe pilot’s failure to maintain directional control during the landing roll.Jul 1, 2017 · N1737P · Substantial damageNTSB GAA17CA372Accident · No injuriesData collectionFinal reportCessna 172RG · El Cajon, CAThe pilot's failure to extend the landing gear with sufficient time to allow the landing gear to fully extend and the flight instructor's failure to visually check to see if the right main landing gear were extended.Jun 20, 2017 · N5424V · Substantial damageNTSB GAA17CA354Accident · No injuriesData collectionFinal reportPiper PA28 · Big Bear, CAThe pilot’s improper landing flare, which resulted in a hard landing and a subsequent loss of directional control.Jun 4, 2017 · N9238W · Substantial damageNTSB GAA17CA315Accident · No injuriesData collectionFinal reportCessna T182 · San Carlos, CAThe pilot's incorrect landing flare, which resulted in a hard, bounced landing.Jun 3, 2017 · N6259T · Substantial damageNTSB WPR17LA112Accident · Minor injuriesLimited investigationFinal reportCessna 175 · El Monte, CAThe flight instructor's delayed remedial action, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall and loss of control. Contributing to the accident was the student pilot's failure to maintain runway alignment…May 27, 2017 · N6832D · Substantial damageNTSB GAA17CA310Accident · No injuriesData collectionFinal reportCessna A185 · Fall River Mills, CAThe pilot’s failure to maintain directional control during the landing roll.May 27, 2017 · N2262T · Substantial damageNTSB GAA17CA303Accident · No injuriesData collectionFinal reportDehavilland DHC 6 · Perris, CAThe prospective pilot’s improper landing flare and the pilot’s delayed remedial action to initiate a go-around, which resulted in a runway excursion.May 24, 2017 · N708PV · Substantial damageNTSB GAA17CA280Accident · Minor injuriesData collectionFinal reportWeaver Stanley R/Robinson Scot Vans RV-8 · Vacaville, CAThe pilot’s failure to maintain directional control while landing in crosswind conditions.May 15, 2017 · N184ME · Substantial damageNTSB GAA17CA270Accident · No injuriesData collectionFinal reportCessna A185 · Columbia, CAThe pilot’s failure to maintain directional control in tailwind and crosswind conditions.May 9, 2017 · N185RX · Substantial damageNTSB GAA17CA242Accident · No injuriesData collectionFinal reportNorth American SNJ · Van Nuys, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll with a quartering tailwind.Apr 20, 2017 · N7969C · Substantial damageNTSB WPR17FA077Accident · 1 fatalField investigationFinal reportChallenger II · Oakdale, CAThe pilot's failure to attain a proper touchdown point and his subsequent loss of directional control during landing for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would…Mar 11, 2017 · N2621T · Substantial damageNTSB GAA17CA148Accident · Serious injuriesData collectionFinal reportBeech A23 · Beckwourth, CAThe student pilot’s inadvertent use of the control yoke to correct for a drift and his subsequent failure to maintain directional control during takeoff.Feb 14, 2017 · N425RS · Substantial damageNTSB GAA17CA113Accident · No injuriesData collectionFinal reportAeronca 7AC · Compton, CAThe pilot’s failure to maintain runway alignment during landing in gusting crosswind conditions, which resulted in an off-runway landing in soft dirt and a nose-over.Jan 15, 2017 · N1659E · Substantial damageNTSB GAA17CA114Accident · No injuriesData collectionFinal reportBeech B200 · Coalinga, CAThe pilot’s failure to maintain directional control during takeoff.Jan 14, 2017 · N795DE · Substantial damageNTSB WPR17LA051Accident · No injuriesLimited investigationFinal reportCessna 421C · Jackson, CAThe failure of the right main landing gear torque link bolt in overstress, which resulted in the collapse of the landing gear during the landing roll.Jan 7, 2017 · N71RC · Substantial damageNTSB WPR17LA048Accident · No injuriesLimited investigationFinal reportSchosanski John H Cozy MK IV R · Napa, CAA partial loss of power due to missing apex seals.Jan 4, 2017 · N4518S · Substantial damageNTSB GAA17CA078Accident · No injuriesData collectionFinal reportLancair LC41 550FG · Redding, CAThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.Nov 22, 2016 · N169WT · Substantial damageNTSB GAA17CA071Accident · No injuriesData collectionFinal reportCessna 120 · Lincoln, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.Nov 14, 2016 · N120MD · Substantial damageNTSB GAA17CA056Accident · No injuriesData collectionFinal reportBeech 76 · Davis, CAThe pilot's failure to maintain directional control during a simulated left engine failure during takeoff. Also causal to the accident was the flight instructor's delayed remedial action to maintain directional control and reduce the right engine mixture…Nov 5, 2016 · N6703L · Substantial damageNTSB GAA17CA049Accident · No injuriesData collectionFinal reportAviat A-1C · Placerville, CAThe pilot’s failure to maintain directional control of the airplane during landing in gusty crosswind conditions.Oct 24, 2016 · N331MA · Substantial damageNTSB GAA17CA029Accident · No injuriesData collectionFinal reportAirplane Factory Sling · Torrance, CAThe student pilot's improper landing flare in crosswind conditions, which resulted in a porpoised hard landing and a runway excursion.Oct 3, 2016 · N232SL · Substantial damageNTSB GAA16CA511Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper landing flare, which resulted in a hard, bounced landing.Sep 18, 2016 · N7560D · Substantial damageNTSB GAA16CA465Accident · No injuriesData collectionFinal reportCessna TR182 · South Lake Tahoe, CAThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a nose over. Contributing to the accident was the pilot's failure to remove the carburetor heat during the attempted go-around in high…Sep 5, 2016 · N738GK · Substantial damageNTSB GAA16CA464Accident · No injuriesData collectionFinal reportNorth American SNJ · Perris, CAThe pilot's inability to compensate for a dust devil during an aborted landing, which resulted in the left wing contacting the ground, a runway excursion, and the airplane coming to rest in a nose-down attitude.Sep 3, 2016 · N7296C · Substantial damageNTSB GAA16CA449Accident · Minor injuriesData collectionFinal reportCessna 182 · Fallbrook, CAThe flight instructor's failure to go-around and the subsequent long landing and his failure to maintain directional control, which resulted in a runway excursion.Aug 24, 2016 · N4810N · Substantial damageNTSB GAA16CA416Accident · No injuriesData collectionFinal reportCessna 172 · Palm Springs, CAThe student pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and a nose over in rough terrain.Aug 3, 2016 · N5203H · Substantial damageNTSB WPR16CA147Accident · No injuriesData collectionFinal reportStinson L 5G · Beckwourth, CAThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the check pilot's failure to act in a timely manner to prevent the airplane from departing the runway.Jun 25, 2016 · N2581B · Substantial damageNTSB GAA16CA289Accident · No injuriesData collectionFinal reportAmerican AA 1A · Lone Pine, CAThe pilot's incorrect brake and power application during landing, which resulted in a runway overrun, collision with a dirt berm, nose gear collapse, and nose-over.Jun 5, 2016 · N6391L · Substantial damageNTSB GAA16CA311Accident · Minor injuriesData collectionFinal reportChampion Aeronca 7AC · Groveland, CAThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and a collision with a concrete barrier wall.May 27, 2016 · N2675E · Substantial damageNTSB WPR16FA115Accident · No injuriesField investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Santa Monica, CAA partial loss of engine power during takeoff due to vapor lock. Contributing to the accident was the student pilot's failure to notice that the engine had exceeded multiple temperature limits and that the fuel flow had become erratic during an extended…May 22, 2016 · N1111X · Substantial damageNTSB GAA16CA249Accident · No injuriesData collectionFinal reportBoeing B75 · El Cajon, CAThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and nose over.May 20, 2016 · N61445 · Substantial damageNTSB GAA16CA247Accident · No injuriesData collectionFinal reportCessna 182 · Redding, CAThe student pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and nose over.May 19, 2016 · N7610S · Substantial damageNTSB GAA16CA242Accident · Minor injuriesData collectionFinal reportVan B Anthony Zodiac · Grass Valley, CAThe pilot's failure to maintain a stabilized approach and landing, which resulted in a hard landing, loss of directional control, runway excursion, and collision with a parked airplane.May 17, 2016 · N99SZ · DestroyedNTSB WPR16LA108Accident · Minor injuriesLimited investigationFinal reportCessna 180 · California City, CAA directional upset on landing due to a thermally induced atmospheric disturbance, which the pilot was unable to successfully counter due to improperly set rudder travel limits.May 13, 2016 · N9370C · Substantial damageNTSB GAA16CA211Accident · No injuriesData collectionFinal reportCessna 152 · Hayward, CAThe student pilot's high descent rate during the landing flare, which resulted in a hard landing, nose landing gear collapse, and runway excursion during an aborted landing.Apr 28, 2016 · N6427Q · Substantial damageNTSB WPR16LA092Accident · No injuriesLimited investigationFinal reportCessna 421C · Death Valley, CAA runway overrun for reasons that could not be determined based on the available information.Apr 13, 2016 · N21SG · Substantial damageNTSB WPR16CA077Accident · No injuriesData collectionFinal reportStinson 108 3 · Livermore, CAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was maintenance personnel's failure to detect the worn tailwheel assembly during the airplane's annual inspection.Feb 25, 2016 · N862C · Substantial damageNTSB WPR16LA061Accident · No injuriesLimited investigationFinal reportCessna 210 · Lodi, CAThe pilot's failure to attain a proper touchdown point, which led to a runway excursion.Jan 26, 2016 · N7316E · Substantial damageNTSB GAA16CA091Accident · No injuriesData collectionFinal reportCessna 177 · Grass Valley, CAThe pilot's loss of directional control during the touchdown and the subsequent attempted aborted landing which resulted in a runway excursion and impact with terrain.Dec 28, 2015 · N29533 · Substantial damageNTSB GAA16CA089Accident · No injuriesData collectionFinal reportWaco YMF · Fullerton, CAThe pilot's failure to maintain directional control during the landing roll.Dec 25, 2015 · N99Y · Substantial damageNTSB GAA16CA085Accident · No injuriesData collectionFinal reportKelm David Kitfox 7 · Tracy, CAThe pilot's failure to maintain pitch control during the landing, which resulted in a hard landing, runway excursion and impact with terrain.Dec 12, 2015 · N35KF · Substantial damageNTSB GAA16CA069Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Mammoth, CAThe pilot's decision to takeoff in high crosswind conditions resulting in the inability to maintain an adequate crosswind correction, consequently failing to maintain directional control and departing the runway, and subsequently colliding with fixed airfield…Dec 3, 2015 · N546C · Substantial damageNTSB GAA16CA065Accident · Minor injuriesData collectionFinal reportCessna T210N · Avalon, CAThe pilot's delay in aborting the landing, resulting in a runway overrun and nose over.Nov 29, 2015 · N99210 · Substantial damageNTSB GAA16CA030Accident · No injuriesData collectionFinal reportMcpherson John G Pietenpol Aircamper · Placerville, CAThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and an impact with terrain.Oct 23, 2015 · N169JG · Substantial damageNTSB GAA16LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Redding, CAThe pilot’s improper decision to land the airplane on a short runway with a tailwind and his subsequent delayed decision to abort the landing.Oct 3, 2015 · N7837X · Substantial damageNTSB GAA15CA276Accident · No injuriesData collectionFinal reportPiper PA 28 · Van Nuys, CAThe pilot's failure to compensate for turbulence during the landing flare, which resulted in a hard landing and runway excursion.Sep 24, 2015 · N8258S · Substantial damageNTSB GAA15CA244Accident · No injuriesData collectionFinal reportJoe Salomone Super CUB SQ2 · Truckee, CAThe pilot's loss of directional control during the takeoff roll, which resulted in a runway excursion, ground loop, and impact with terrain. Contributing to the accident was the pilot's lack of experience from the back seat.Sep 1, 2015 · N786AB · Substantial damage