NTSB investigations, CA

88 cases where the sequence of events included Other weather encounter.

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\" = '400' 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 GAA17CA118Accident · No injuriesData collectionFinal reportCessna 140 · Markleeville, CAThe pilot’s failure to maintain altitude during a low pass and the subsequent impact with a snow berm, which resulted in a nosed-over.Jan 17, 2017 · N5623C · Substantial damageNTSB WPR17FA029Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Glamis, CAThe pilot's improper decision to attempt a downwind landing and his failure to maintain adequate airspeed while maneuvering during a go-around and subsequent landing attempt, which resulted in exceedance of the airplane's critical angle of attack and an…Nov 25, 2016 · N88373 · Substantial damageNTSB GAA17CA082Accident · Serious injuriesData collectionFinal reportCameron A315 · Winters, CAThe passenger's improper egress from the balloon basket, which resulted in a serious injury.Nov 14, 2016 · N69520 · No damageNTSB WPR17FA008Accident · 1 fatalField investigationFinal reportCessna 182D · South Lake Tahoe, CAThe noninstrument-rated pilot's decision to depart on and continue a flight over mountainous terrain into forecast instrument metrological conditions, icing, and hazardous wind conditions that exceeded the airplanes performance capabilities and resulted in an…Oct 15, 2016 · N8718X · DestroyedNTSB 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 GAA16CA489Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G109 · Emigrant Gap, CAThe pilot's inappropriate decision to continue the flight into higher elevation under high-density altitude conditions, which degraded the glider's climb performance and resulted in impact with trees short of the intended runway.Sep 9, 2016 · N909G · 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 GAA16CA425Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · San Diego, CAThe pilot's failure to maintain directional control during landing with a crosswind.Aug 10, 2016 · N35451 · Substantial damageNTSB GAA16CA356Accident · Minor injuriesData collectionFinal reportCessna 182 · Llano, CAThe pilot's failure to attain an adequate airspeed and his intentional aerodynamic stall, which resulted in an impact with terrain and a post-impact fire.Jul 3, 2016 · N1642T · DestroyedNTSB 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 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 WPR16LA105Accident · Minor injuriesLimited investigationFinal reportBeech B24R · Groveland, CAThe pilot's decision to conduct an upslope, downwind takeoff combined with an improper flap setting, which resulted in the airplane's inability to clear trees beyond the runway end. The reason for the improper flap setting could not be determined.May 10, 2016 · N2052L · Substantial damageNTSB WPR16FA059Accident · 2 fatalField investigationFinal reportPiper PA 24-260 · Santa Rosa, CAThe pilot’s failure to maintain airplane control during an instrument approach in night instrument meteorological conditions, which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of recent experience in night…Jan 29, 2016 · N9362P · 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 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 GAA16CA002Accident · No injuriesData collectionFinal reportCessna 172 · Avalon, CAThe pilot's exceedance of the critical angle of attack in turbulent and downdraft conditions, which resulted in an aerodynamic stall and collision with terrain on final approach.Oct 1, 2015 · N4286Q · 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 GAA15CA106Accident · No injuriesData collectionFinal reportCessna 182Q · Palm Springs, CAThe pilot's improper landing flare which resulted in a hard landing and substantial damage to the firewall.Jun 3, 2015 · N759ZK · 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 WPR14LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAThe flight instructor’s inadequate compensation for the gusting crosswind conditions during landing, which resulted in a loss of airplane control.Dec 29, 2013 · N4936D · Substantial damageNTSB WPR14FA012Accident · 2 fatalField investigationFinal reportMooney M20E · Julian, CAThe pilot’s failure to maintain clearance from terrain while maneuvering to avoid clouds in mountainous terrain.Oct 9, 2013 · N7145U · DestroyedNTSB WPR13CA249Accident · No injuriesData collectionFinal reportBeech V35B · Kernville, CAThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions.May 26, 2013 · N7435B · Substantial damageNTSB WPR13CA088Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Rialto, CAThe pilot's failure to maintain airplane control while taxiing in gusting wind conditions.Jan 8, 2013 · N1254E · Substantial damageNTSB WPR12CA419Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · French Valley, CAThe pilot’s loss of directional control during a go-around following a sudden change in wind direction.Sep 14, 2012 · N7971W · Substantial damageNTSB WPR12CA273Accident · No injuriesData collectionFinal reportCessna 170B · Concord, CAThe pilot’s failure to maintain control of the airplane while landing in gusting crosswind conditions.Jun 21, 2012 · N1640D · Substantial damageNTSB WPR12LA285Accident · No injuriesLimited investigationFinal reportSchweizer SGS233 · Truckee, CAThe pilot's failure to maintain control of the glider while taking off with a gusting wind, which resulted in the glider impacting a runway sign.Jun 9, 2012 · N2061T · Substantial damageNTSB WPR11FA239Accident · 1 fatalField investigationFinal reportBrantly B-2B · Weaverville, CAThe student pilot's decision to fly in windy conditions that exceeded his capabilities, which resulted in his subsequent loss of helicopter control. Contributing to the accident was his lack of flight experience in the accident helicopter.May 27, 2011 · N222DW · Substantial damageNTSB WPR10LA271Accident · No injuriesLimited investigationFinal reportShaffer William C Quicksilver MX II SP · Visalia, CAThe pilot's inadequate compensation for the gusty crosswind conditions and failure to maintain runway alignment while landing.Jun 1, 2010 · N4399J · Substantial damageNTSB WPR10CA296Accident · No injuriesData collectionFinal reportCessna P210N · Petaluma, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll in gusty crosswind conditions.May 22, 2010 · N210SL · Substantial damageNTSB WPR10CA203Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Taft, CAThe pilot's loss of control during takeoff upon encountering a strong wind gust.Apr 11, 2010 · N2887P · Substantial damageNTSB WPR10CA038Accident · No injuriesData collectionFinal reportMooney M20F · Palm Springs, CAThe pilot's inadequate compensation for gusty crosswind conditions and his failure to maintain directional control.Oct 29, 2009 · N400EB · Substantial damageNTSB WPR09CA441Accident · No injuriesData collectionFinal reportCessna T210H · Avalon, CAThe pilot's failure to maintain airspeed during approach to landing, which resulted in a hard landing.Sep 5, 2009 · N2242R · Substantial damageNTSB WPR09CA129Accident · No injuriesData collectionFinal reportCessna T210 · Twentynine Palms, CAThe pilot's inadequate compensation for the gusting wind conditions.Feb 24, 2009 · N210NS · Substantial damageNTSB WPR09LA079Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Corona, CAThe pilot's inadequate compensation for the gusting wind conditions and failure to maintain directional control during the takeoff-initial climb.Jan 12, 2009 · N9694Y · Substantial damageNTSB WPR09CA020Accident · Serious injuriesData collectionFinal reportRoyse David Avid C Aerobat · Hollister, CAThe pilot's inadequate compensation for the wind conditions and failure to maintain airplane control during the landing flare. Contributing to the accident were the gusty wind conditions.Oct 21, 2008 · N967DR · Substantial damageNTSB SEA08CA199AccidentData collectionFinal reportCessna 177B · Truckee, CAThe pilot's improper decision to take off in a heavily loaded airplane under the ambient conditions that existed at the time. Contributing to the accident was the mountainous/hilly terrain, a high density altitude, gusty winds and downdrafts.Sep 14, 2008 · N30692 · Substantial damage