NTSB investigations, CA

379 cases where the sequence of events included Loss of control on ground.

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\" = '230' 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 GAA16CA197Accident · Minor injuriesData collectionFinal reportBellanca 7ECA · Ramona, CAThe pilot's failure to maintain directional control during takeoff in variable wind conditions.Apr 23, 2016 · N8654V · 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 GAA16CA121Accident · No injuriesData collectionFinal reportGlines Kenneth Tailwind W 8 · Big Bear, CAThe pilot's inadvertent landing off the left side of the snow-covered runway, resulting in a ground loop and nose over.Jan 25, 2016 · N1983T · 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 GAA16CA049Accident · No injuriesData collectionFinal reportCurtiss Wright Travel Air · Carlsbad, CAThe pilot's failure to maintain directional control during the landing roll, resulting in a ground-loop, and substantial damage to the right wing and wing strut.Nov 14, 2015 · N9872 · Substantial damageNTSB WPR16LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172S · San Jose, CAThe pilot's failure to maintain directional control during the landing roll at night, which resulted in a runway excursion.Nov 8, 2015 · N21679 · 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 WPR16LA004Accident · Serious injuriesLimited investigationFinal reportSilvaire Luscombe 8F · Georgetown, CAThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.Oct 7, 2015 · N9918C · Substantial damageNTSB GAA16CA010Accident · No injuriesData collectionFinal reportGrosch Starduster TOO SA 30 · Lincoln, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop, left main landing gear collapse, and the left wing striking the runway.Oct 4, 2015 · N2RG · 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 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 damageNTSB GAA15CA200Accident · No injuriesData collectionFinal reportRobinson Helicopter R-22 · Corona, CAThe flight instructor's delayed remedial action to arrest the descent rate, which resulted in a running landing, the left skid catching rough terrain, and the main rotor blades impacting the ground.Jul 23, 2015 · N520NS · Substantial damageNTSB 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 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 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 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 WPR15TA002Accident · No injuriesFinal reportRockwell International 690B · Grass Valley, CAThe pilot’s unstabilized approach and failure to go around and his subsequent failure to maintain directional control during the landing roll.Oct 4, 2014 · N700PQ · 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 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 WPR14CA328Accident · No injuriesData collectionFinal reportBeech A36 - Undesignat · San Carlos, CAThe pilot's failure to maintain directional control during taxi.Jul 30, 2014 · N17856 · 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 WPR14CA241Accident · No injuriesData collectionFinal reportCessna 180H · Hesperia, CAThe pilot's failure to maintain directional control during the landing roll.Jun 7, 2014 · N73BT · 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 WPR14CA200Accident · No injuriesData collectionFinal reportCessna 180 · Cameron Park, CAThe pilot's failure to maintain directional control during landing which resulted in a ground-loop and nose over.May 21, 2014 · N2443C · Substantial damageNTSB WPR14CA184Accident · No injuriesData collectionFinal reportCessna 180D · Murieta, CAThe pilot's loss of directional control during takeoff. Contributing to the accident was the pilot's failure to abort the takeoff at the initial veer off.May 3, 2014 · N8603X · Substantial damageNTSB WPR14CA175Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Monterey, CAThe sport pilot's failure to maintain aircraft control during taxi as a result of improperly manipulating the engine power.Apr 28, 2014 · N923LA · Substantial damageNTSB WPR14LA146Accident · No injuriesLimited investigationFinal reportColumbia Aircraft Mfg LC42 550FG · Truckee, CAThe pilot’s failure to maintain directional control during both the landing and the subsequent attempted go-around.Mar 21, 2014 · N112FP · 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 WPR14CA139Accident · No injuriesData collectionFinal reportBayer Oscar Starduster SA300 · San Luis Obispo, CAThe pilot's inadequate flare, which resulted in a bounced landing and subsequent loss of aircraft control during landing.Mar 19, 2014 · N490B · 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 WPR14CA083Accident · No injuriesData collectionFinal reportCessna 195A · Salinas, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Dec 31, 2013 · N369JJ · Substantial damageNTSB WPR14CA064Accident · No injuriesData collectionFinal reportPiper PA 16 · San Carlos, CAThe pilot's failure to maintain directional control during the landing roll.Dec 8, 2013 · N6913 · Substantial damageNTSB WPR14CA053Accident · No injuriesData collectionFinal reportCessna 152 · Livermore, CAThe student pilot's failure to maintain directional control during the landing roll.Nov 13, 2013 · N821EB · 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 WPR14CA033Accident · No injuriesData collectionFinal reportTecnam P92 · Watsonville, CAThe pilot's failure to maintain directional control during landing.Oct 22, 2013 · N137LM · Substantial damageNTSB WPR14CA017Accident · No injuriesData collectionFinal reportBeller Quicksilver Mxlii · Orland, CAThe pilot's failure to maintain aircraft control during taxi with a strong gusting wind condition which resulted in the airplane nosing over.Oct 14, 2013 · N75556 · 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 WPR13CA356Accident · No injuriesData collectionFinal reportCessna 170B · San Carlos, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Aug 3, 2013 · N8249A · 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 WPR13CA268Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Truckee, CAThe pilot’s failure to maintain aircraft control during landing in gusting wind conditions.Jun 11, 2013 · N377BB · 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 damage