NTSB investigations, 2017, CA

28 cases where the sequence of events included Runway excursion.

Cases per year

20082026
NTSB investigations, 2017, CA per year, 2008–2026: 286 cases
200812
200925
201026
201115
201214
201316
201416
201521
201622
201728
201820
201919
20207
20213
20226
20237
202415
20255
20269

Latest cases

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 year(c.\"eventDate\") = 2017
    AND 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 WPR18CA059Accident · No injuriesData collectionFinal reportCessna 182 · Santa Ana, CAThe pilot’s failure to follow ground control instructions and to see and avoid ground obstacles while taxiing.Dec 26, 2017 · N698MC · Substantial damageNTSB GAA18CA076Accident · No injuriesData collectionFinal reportCessna 152 · Fullerton, CAThe student pilot’s failure to maintain directional control during takeoff.Nov 30, 2017 · N417CB · Substantial damageNTSB GAA18CA050Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Rosamond, CAThe pilot’s failure to maintain directional control during the landing roll.Nov 19, 2017 · N69656 · Substantial damageNTSB WPR18LA015Accident · No injuriesLimited investigationFinal reportSchweizer G 164B · Tracy, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.Oct 24, 2017 · N8494K · Substantial damageNTSB GAA18CA018Accident · No injuriesData collectionFinal reportAeronca 7DC · Salinas, CAThe pilot’s failure to maintain directional control during landing with a tailwind.Oct 22, 2017 · N83512 · Substantial damageNTSB WPR18LA012Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22T · San Carlos, CAThe pilot's failure to follow the Before-Takeoff checklist and properly set the flaps before takeoff, which altered the airplane’s flight characteristics, and the pilot’s failure to recognize the problem and abort the takeoff in a timely manner, which…Oct 21, 2017 · N3636E · Substantial damageNTSB GAA18CA010Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Brawley, CAThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Oct 11, 2017 · N80060 · Substantial damageNTSB GAA17CA538Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Santa Ynez, CAThe pilot’s improper landing flare in gusting wind conditions, which resulted in a hard, bounced landing.Sep 11, 2017 · N4465F · Substantial damageNTSB GAA17CA558Accident · No injuriesData collectionFinal reportBellanca 14 19 · Redding, CAThe pilot’s failure to maintain directional control during the landing roll.Aug 27, 2017 · N36KC · Substantial damageNTSB 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 damage