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 GAA15CA207Accident · No injuriesData collectionFinal reportCessna 170B · Rosamond, CAThe pilot's failure to maintain directional control during the takeoff roll, resulting in a collision with terrain.Jul 16, 2015 · N8028A · Substantial damageNTSB GAA15CA150Accident · Minor injuriesData collectionFinal reportCessna TR182 · Rio Vista, CAThe pilot's use of improper procedures during an aborted landing, resulting in a runway excursion and a collision with a canal.Jun 30, 2015 · N739WW · Substantial damageNTSB GAA15CA149Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Novato, CAThe pilot's improper pitch control which resulted in a bounced landing, runway excursion, and collision with terrain.Jun 28, 2015 · N9069J · Substantial damageNTSB GAA15CA113Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Bakersfield, CAThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion, and a collision with terrain.Jun 9, 2015 · N8372 · Substantial damageNTSB WPR15LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA30 - NO Series · Red Bluff, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and collision with terrain.Mar 19, 2015 · N8403Y · Substantial damageNTSB GAA15CA021Accident · No injuriesData collectionFinal reportCessna 182M · Ramona, CAThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.Mar 8, 2015 · N2030M · Substantial damageNTSB GAA15CA001Accident · No injuriesData collectionFinal reportWaco UPF 7 · Rio Vista, CAThe pilot's failure to maintain directional control during the landing roll.Mar 6, 2015 · N32063 · Substantial damageNTSB GAA15CA006Accident · No injuriesData collectionFinal reportChampion 7EC · Upland, CAThe pilot's failure to maintain directional control during landing.Mar 5, 2015 · N8905R · Substantial damageNTSB WPR15CA114Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Camarillo, CAThe pilot's failure to maintain directional control during the landing roll.Feb 22, 2015 · N4155U · Substantial damageNTSB WPR15IA105Incident · No injuriesIncident investigationFinal reportEvo13 Lancair Evolution · San Carlos, CAThe collapse of the nose landing gear (NLG) due to the separation of the right trunnion pin from the NLG strut as a result of reverse-bending fatigue.Feb 15, 2015 · N3WB · Minor damageNTSB WPR15CA100Accident · Minor injuriesData collectionFinal reportCessna U206 - G · Kernville, CAThe pilot's inadequate flare and failure to maintain airplane control during the landing with a tailwind which resulted in a bounce, long landing, and subsequent runway excursion.Feb 9, 2015 · CFGQQ · Substantial damageNTSB WPR15LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Jackson, CAThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion.Jan 10, 2015 · N2229C · Substantial damageNTSB WPR15CA066Accident · No injuriesData collectionFinal reportFerdon Thorp T 18 · San Rafael, CAThe pilot's delayed decision to abort the takeoff. Contributing to the accident are an inadequate modification to the seat position, and the pilot's failure to check flight controls for freedom and correct movement.Dec 20, 2014 · N25VP · Substantial damageNTSB WPR15LA042Accident · No injuriesLimited investigationFinal reportCessna U206G · La Verne, CAThe pilot's loss of directional control during the landing roll for reasons that could not be determined, because postaccident examination of the nosewheel assembly revealed no anomalies that would have precluded normal operation.Nov 15, 2014 · N9420R · Substantial damageNTSB WPR15CA041Accident · No injuriesData collectionFinal reportChampion 7ECA · San Diego, CAThe pilot's failure to maintain directional control of the airplane during takeoff roll.Nov 14, 2014 · N2563F · Substantial damageNTSB WPR14CA399Accident · No injuriesData collectionFinal reportCessna 172N · Thermal, CAThe student pilot's failure to maintain directional control during landing after an encounter with a dust devil.Sep 30, 2014 · N738TJ · Substantial damageNTSB WPR14CA365Accident · Minor injuriesData collectionFinal reportEaland Charles Lionheart · Santa Maria, CAThe pilot's inadequate landing flare and subsequent loss of directional control during the landing roll.Sep 5, 2014 · N15TE · Substantial damageNTSB WPR14CA364Accident · No injuriesData collectionFinal reportFlight Design Ctls LSA · Grass Valley, CAThe pilot's inadequate flare which resulted in a loss of aircraft control during landing.Sep 3, 2014 · N245LS · Substantial damageNTSB WPR14CA334Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 SP · Bakersfield, CAThe pilot's failure to maintain an adequate approach which resulted in a long landing and runway overrun.Aug 8, 2014 · N526FL · Substantial damageNTSB WPR14CA299Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Hoopa, CAThe pilot's inadequate approach and excessive airspeed which resulted in a long landing and subsequent runway overrun onto rough terrain.Jul 18, 2014 · N528DC · Substantial damageNTSB WPR14CA268Accident · Minor injuriesData collectionFinal reportCessna L19 - A · Firebaugh, CAThe pilot's inadequate compensation for the wind conditions in the landing area, which resulted in a loss of directional control and encounter with soft terrain and vegetation.Jun 25, 2014 · N5264G · Substantial damageNTSB WPR14LA250Accident · No injuriesLimited investigationFinal reportCessna 172RG · Alturas, CAThe airplane’s failure to attain rotation speed during the takeoff roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the…Jun 19, 2014 · N6091R · Substantial damageNTSB WPR14CA215Accident · No injuriesData collectionFinal reportPiper PA28R - 201T · Novato, CAThe pilot's failure to maintain directional control during landing roll with a crosswind, which resulted in a runway excursion and impact with terrain.May 27, 2014 · N222RS · Substantial damageNTSB WPR14CA210Accident · No injuriesData collectionFinal reportMeyers OTW 160 · Tehachapi, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent collision with a fence.May 26, 2014 · N34341 · Substantial damageNTSB WPR14LA141Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Porterville, CAThe student pilot’s failure to maintain directional control during takeoff.Mar 20, 2014 · N817EV · Substantial damageNTSB WPR14LA130Accident · No injuriesLimited investigationFinal reportGrumman G164 - A · Caruthers, CAAn undetected fatigue crack in the landing gear leg, which initiated at an electrical arc-induced damage site of undetermined origin and resulted in landing gear failure. Contributing to the severity of damage to the airplane was the close proximity of an…Feb 28, 2014 · N72ES · Substantial damageNTSB WPR14CA122Accident · No injuriesData collectionFinal reportCessna 172M · Ramona, CAThe student pilot's inadequate flare and failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.Feb 25, 2014 · N91712 · Substantial damageNTSB WPR14CA095Accident · No injuriesData collectionFinal reportHallendorf Tom RV 6 · Sacramento, CAThe pilot's failure to maintain directional control during landing roll in gusty wind conditions.Jan 12, 2014 · N6888 · Substantial damageNTSB WPR14CA043Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA 5B · Avalon, CAThe pilot's failure to maintain aircraft control while landing with a tailwind.Nov 3, 2013 · N1550R · Substantial damageNTSB WPR14CA026Accident · No injuriesData collectionFinal reportCessna T210 - H · Lodi, CAThe student pilot's inadequate flare and failure to maintain directional control during landing.Oct 23, 2013 · N6942R · Substantial damageNTSB WPR13FA430Accident · 4 fatalField investigationFinal reportCessna 525A · Santa Monica, CAThe pilot’s failure to adequately decrease the airplane’s ground speed or maintain directional control during the landing roll, which resulted in a runway excursion and collision with an airport sign and structure and a subsequent postcrash fire.Sep 30, 2013 · N194SJ · DestroyedNTSB WPR13CA426Accident · No injuriesData collectionFinal reportPiper PA28 - 161 · Lancaster, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.Sep 21, 2013 · N6313C · Substantial damageNTSB WPR13CA413Accident · No injuriesData collectionFinal reportCessna T310R · San Luis Obispo, CAThe pilot's inadvertent action of retracting the landing gear instead of the flaps during the landing roll, which resulted in the right main landing gear collapsing.Sep 16, 2013 · N712SB · Substantial damageNTSB WPR13CA357Accident · No injuriesData collectionFinal reportChampion 7EC · Sonoma, CAThe pilot's failure to maintain directional control during the landing roll.Aug 2, 2013 · N4738E · Substantial damageNTSB WPR13CA328Accident · No injuriesData collectionFinal reportCessna 172S · Redlands, CAThe student pilot's improper flare and unsuccessful attempt to correct a bounced landing, which resulted in the overrun landing.Jul 15, 2013 · N625SP · Substantial damageNTSB WPR13CA276Accident · No injuriesData collectionFinal reportGary W Bettis Harmon Rocket II · South Lake Tahoe, CAThe pilot's failure to maintain directional control during landing with a crosswind.Jun 17, 2013 · N91GB · Substantial damageNTSB WPR13CA260Accident · No injuriesData collectionFinal reportWampach Murphy Moose · Galt, CAThe pilot's improper landing flare, which resulted in an abnormal runway contact.Jun 1, 2013 · N331RW · Substantial damageNTSB WPR13CA255Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Martin, CAThe pilot’s failure to maintain directional control during the landing roll.May 31, 2013 · N5032G · Substantial damageNTSB WPR13CA232Accident · No injuriesData collectionFinal reportCessna 195A · San Carlos, CAThe pilot’s failure to maintain directional control during the landing roll.May 16, 2013 · N4026A · Substantial damageNTSB WPR13CA166Accident · No injuriesData collectionFinal reportBellanca 7ECA · Sonoma, CAThe student pilot’s failure to maintain directional control during the touchdown and landing roll.Mar 16, 2013 · N8564V · Substantial damageNTSB WPR13LA145Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Kernville, CAThe pilot’s application of excessive pitch and his failure to achieve adequate airspeed during the go-around attempt, which resulted in an aerodynamic stall.Mar 11, 2013 · N427GE · Substantial damageNTSB WPR13CA146Accident · Minor injuriesData collectionFinal reportWaco UPF-7 · Paso Robles, CAThe pilot's failure to adequately compensate for crosswind conditions, which resulted in a loss of directional control during the landing roll.Mar 11, 2013 · N29969 · Substantial damageNTSB WPR13LA112Accident · No injuriesLimited investigationFinal reportCessna 305A · Camarillo, CAA tailwheel vibration upon touchdown and the subsequent loss of directional control for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.Feb 2, 2013 · N342FS · Substantial damageNTSB WPR13CA089Accident · Minor injuriesData collectionFinal reportStribling James L RV4 · Georgetown, CAThe pilot’s improper landing flare and failure to maintain directional control during landing.Jan 8, 2013 · N70AC · Substantial damageNTSB WPR13CA039Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Carlsbad, CAThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with parked aircraft. Contributing to the accident was the pilot's lack of experience in the airplane make/model.Nov 11, 2012 · N153TB · Substantial damageNTSB WPR13CA024Accident · No injuriesData collectionFinal reportCessna 170A · Calexico, CAThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion.Oct 27, 2012 · N1332D · Substantial damageNTSB WPR12CA354Accident · No injuriesData collectionFinal reportPiper PA-22 · Napa, CAThe pilot's inadequate landing flare, which resulted in a bounced landing and subsequent loss of directional control during the landing roll.Aug 12, 2012 · N3580A · Substantial damageNTSB WPR12CA352Accident · No injuriesData collectionFinal reportCessna 180 · Upland, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.Aug 12, 2012 · N2927K · Substantial damageNTSB WPR12CA330Accident · No injuriesData collectionFinal reportAlon A2 · Compton, CAThe pilot's failure to maintain directional control during landing.Jul 28, 2012 · N5486E · Substantial damageNTSB WPR12LA315Accident · No injuriesLimited investigationFinal reportPiper PA-32S-300 · Adelanto, CAThe pilot’s failure to maintain directional control during the aborted takeoff, which was aborted due to fuel starvation as a result of an inadvertent in-flight activation of the fuel drain activation lever by the passenger. Contributing to the accident was…Jul 20, 2012 · N5212S · Substantial damage