NTSB investigations, CA

106 cases where the sequence of events included Miscellaneous/other.

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\" = '900' 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 GAA17CA204Accident · Minor injuriesData collectionFinal reportCessna 170 · Death Valley, CAThe pilot’s improper compensation for crosswind conditions during the landing flare and his subsequent failure to maintain directional control during the landing.Mar 26, 2017 · N9953A · Substantial damageNTSB GAA17CA184Accident · No injuriesData collectionFinal reportCSP Leasing Cavalon · Santa Maria, CAThe student pilot’s improper landing flare and subsequent failure to maintain crosswind correction during landing in crosswind conditions.Mar 10, 2017 · N425AG · 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 GAA16CA520Accident · No injuriesData collectionFinal reportCessna 182 · Lakeport, CAThe pilot's delayed action to add power during the approach, which resulted in an impact with terrain prior to the approach end of the runway.Sep 29, 2016 · N2613G · Substantial damageNTSB GAA16LA525Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Davis, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and noseover. Contributing to the accident was the failure of the seatbelt anchor bracket.Sep 18, 2016 · N76284 · Substantial damageNTSB GAA16CA408Accident · No injuriesData collectionFinal reportBell Helicopter Textron 206 · Modesto, CAThe pilot's failure to maintain pitch control during an autorotation, which resulted in abnormal ground contact and main rotor contact with the tail boom. Contributing to the accident was the low fuel level which resulted in fuel starvation and a loss of…Jul 30, 2016 · N206LW · 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 WPR16LA132Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · El Centro, CAA loss of main rotor rpm and airframe vibration for reasons that could not be determined based on the available information, which resulted in a forced landing to sloping terrain and the helicopter rolling over.Jun 28, 2016 · N8325X · Substantial damageNTSB GAA16CA339Accident · Minor injuriesData collectionFinal reportHughes 269B · Princeton, CAThe uncertificated pilot's failure to maintain pitch and directional control, which resulted in an impact with terrain and a rollover.Jun 21, 2016 · N941BD · 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 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 WPR16LA093Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Avalon, CAThe pilot's failure to maintain a proper approach path on landing because he failed to familiarize himself with the airport's unique approach hazards and recommended procedures before the flight. Also causal was the pilot's failure to recognize the airplane's…Apr 17, 2016 · N7133G · DestroyedNTSB GAA16CA143Accident · Minor injuriesData collectionFinal reportBell 47 · Agua Dulce, CAThe pilot's failure to set the appropriate collective friction prior to releasing the collective in flight, which resulted in decreased main rotor pitch, settling with power, and an impact with terrain.Mar 2, 2016 · N568TB · Substantial damageNTSB WPR16LA075Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R66 · Torrance, CAA vibration of the helicopter, which resulted in an autorotation to soft terrain and subsequent impact of the tail boom with the main rotor. The reason for the vibration could not be determined because postaccident examination revealed no malfunctions or…Feb 23, 2016 · N266RH · Substantial damageNTSB WPR16LA070Accident · Serious injuriesLimited investigationFinal reportAerostar International RX8 · Petaluma, CAThe pilot's inadequate compensation for wind during the landing approach, which resulted in the balloon’s basket impacting a metal fence and a passenger sustaining serious injuries.Feb 13, 2016 · N3647A · Minor damageNTSB WPR16LA058Accident · No injuriesLimited investigationFinal reportCessna 340A · Bakersfield, CAMaintenance personnel’s repeated failure to re-rig the main landing gear (MLG) in accordance with the airplane manufacturer's service manual requirements, which resulted in the collapse of the right MLG.Jan 27, 2016 · N346MC · Substantial damageNTSB WPR16LA019Accident · No injuriesLimited investigationFinal reportAmerican Eurocopter AS350B3 · Folsom, CAThe flight instructor's failure to perform simulated engine failure training in accordance with manufacturer guidance, including his improper recovery from the maneuver, which resulted in an overshoot of the intended landing zone when the engine did not…Oct 24, 2015 · N911WL · Substantial damageNTSB WPR14TA370Accident · No injuriesFinal reportEurocopter AS 350 B3 · Lincoln, CAThe failure of the engine to provide sufficient power when commanded by the pilot during the power recovery phase of a practice autorotation for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or…Sep 5, 2014 · N217HP · Substantial damageNTSB WPR14CA363Accident · Serious injuriesData collectionFinal reportHughes 369D · Willows, CAThe pilot's failure to adequately secure cargo (a jacket), which resulted in the jacket exiting the cabin compartment and colliding with the tail rotor during cruise flight.Sep 2, 2014 · N516PJ · Substantial damageNTSB WPR14FA282Accident · 3 fatalField investigationFinal reportPiper PA 28R-180 · Lake Elsinore, CAThe pilot's failure to maintain airplane control when the landing gear unintentionally extended while maneuvering at low altitude and airspeed, which increased the airplane’s drag and decreased its ability to climb over the rising terrain.Jul 6, 2014 · N3723T · DestroyedNTSB WPR14LA257Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Agua Dulce, CAThe pilot's decision to continue the takeoff from the upsloping runway with full-flap deflection in high density altitude conditions, which led to a decreased climb rate and impact with terrain.Jun 20, 2014 · N4606L · Substantial damageNTSB WPR13LA398Accident · Serious injuriesLimited investigationFinal reportStrong Dream Machine · Bieber, CAThe pilot’s inability to maintain aircraft control during takeoff after several suspension lines became entangled in, and were subsequently severed by, the propeller blades.Sep 3, 2013 · N9032Y · Substantial damageNTSB WPR13LA385Accident · Minor injuriesLimited investigationFinal reportRobert Golding Tbirdii · Bakersfield, CAThe failure of the two pilots to adequately planflight, particularly regarding their roles and responsibilities, which resulted in their failure to maintain sufficient altitude to clear power lines during a low pass.Aug 24, 2013 · N31683 · Substantial damageNTSB WPR13FA386Accident · Serious injuriesField investigationFinal reportPiper PA 28 · Tehachapi, CAThe pilot's failure to conduct predeparture airplane performance planning for a departure from a high density altitude location, which resulted in his selection of a flightpath toward rising terrain that the airplane was not capable of outclimbing.Aug 24, 2013 · N32582 · Substantial damageNTSB WPR13CA278Accident · No injuriesData collectionFinal reportCessna 180 · Nervino, CAThe pilot’s decision to takeoff from an area off the runway surface which resulted in a collision with an object.Jun 7, 2013 · N1677C · Substantial damageNTSB WPR13FA264Accident · Minor injuriesField investigationFinal reportRobinson Helicopter R44 II · Los Angeles, CAThe pilot’s loss of helicopter control following a precautionary landing, which resulted in a dynamic rollover.Jun 6, 2013 · N915BW · Substantial damageNTSB WPR13FA076Accident · 3 fatalField investigationFinal reportMckenzie Lancair IV-P Turbine · Lakeside, CAThe pilot’s failure to maintain airspeed while attempting a visual climb through a broken cloud layer, which resulted in a stall/spin.Dec 29, 2012 · N5M · Substantial damageNTSB WPR12LA433Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Firebaugh, CAThe pilot’s decision to continue the takeoff after the engine stopped producing its full-rated torque while operating in high-density altitude conditions and his subsequent failure to maintain clearance from the power transmission wires.Sep 22, 2012 · N4556S · Substantial damageNTSB WPR12CA387Accident · No injuriesData collectionFinal reportCroman SH-3H · Covelo, CAThe pilot’s failure to maintain clearance from a tree during an aerial firefighting flight.Sep 1, 2012 · N611CK · Substantial damageNTSB WPR12CA270Accident · No injuriesData collectionFinal reportFisher Harold R 320 · Adelanto, CAThe pilot's failure to maintain clearance from a fence during takeoff initial climb. Contributing to the accident was the pilot's decision to not use all of the runway distance available for takeoff and the high density altitude.Jun 17, 2012 · N686KB · Substantial damageNTSB WPR12LA220Accident · 1 fatalLimited investigationFinal reportGrumman G 164D · Nicolaus, CAThe pilot’s failure to maintain airplane control during a low-altitude maneuver.May 21, 2012 · N8267K · Substantial damageNTSB WPR12FA044Accident · 1 fatalField investigationFinal reportMooney M20M · Pomona, CAThe pilot’s failure to maintain sufficient altitude to clear obstructions while maneuvering on the base leg of the traffic pattern for landing.Nov 18, 2011 · N741SB · Substantial damageNTSB WPR12LA022Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas 500D · Colusa, CAA total loss of engine power while maneuvering at low altitude for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation. Contributing to the accident severity was the…Oct 27, 2011 · N61PJ · Substantial damageNTSB WPR11FA474Accident · 1 fatalField investigationFinal reportPoe G L/Poe S Y 540 · Chualar, CAThe pilot’s incapacitation due either to g-induced loss of consciousness alone or in combination with a cardiac arrhythmia. Contributing to the accident was the pilot’s use of several medications.Sep 30, 2011 · N42GP · Substantial damageNTSB WPR11LA416Accident · 1 fatalLimited investigationFinal reportLuscombe 8 · Lincoln, CAThe passenger's accidental fall while turning the propeller by hand to start the engine.Aug 18, 2011 · N45725 · No damageNTSB WPR11CA376Accident · No injuriesData collectionFinal reportCessna 172P · San Diego, CAThe student pilot's failure to maintain clearance from obstacles while taxiing.Aug 14, 2011 · N216AF · Substantial damageNTSB WPR11CA341Accident · No injuriesData collectionFinal reportCliff Starduster II SA300 · San Jose, CAThe pilot's decision to not follow the designated taxiway, and failure to maintain clearance from a sign.Jul 19, 2011 · N411TM · Substantial damageNTSB WPR11FA316Accident · 4 fatalField investigationFinal reportMooney M20F · Watsonville, CAThe pilot's decision to take off toward a nearby low cloud layer and the subsequent turn, stall, and spin during the pilot’s attempt to avoid the cloud layer. Contributing to the accident was the pilot's failure to avoid the stall. His ability to avoid the…Jul 8, 2011 · N7759M · Substantial damageNTSB WPR11LA220Accident · No injuriesLimited investigationFinal reportMD Helicopter 369D · Columbia, CAThe loss of power transmission to the main rotor for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation of the helicopter.May 13, 2011 · N124AL · Substantial damageNTSB WPR10LA458Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mammoth, CADynamic rollover of the helicopter during a precautionary landing.Sep 16, 2010 · N2153S · Substantial damageNTSB WPR10IA430Incident · Minor injuriesIncident investigationFinal reportAirbus A320-232 · Sacramento, CAThe first officer’s inadvertent activation of the parking brake in flight, which led to the airplane abruptly stopping and all four of its main landing gear tires deflating, and his use of a nonstandard procedure to cancel the airplane's monitoring alert…Aug 26, 2010 · N590JB · Minor damageNTSB WPR10CA382Accident · No injuriesData collectionFinal reportBoeing PT-13B · Santa Rosa, CAThe failure of the pilot of another airplane to maintain clearance while taxiing.Jul 31, 2010 · N46590 · 2 aircraft · Minor damageNTSB WPR10FA324Accident · 1 fatalField investigationFinal reportCessna 182P · Avalon, CAThe pilot's incapacitation due to a heart attack, which resulted in a loss of airplane control.Jul 1, 2010 · N222CG · Substantial damageNTSB WPR10LA200Accident · No injuriesLimited investigationFinal reportBell 222U · Santa Maria, CAThe pilot's inadequate preflight inspection to ensure that all tie-down straps were removed prior to flight. Contributing to the accident was the pilot's improper management of sleep opportunities during the preceding rest period, which likely contributed to…Apr 9, 2010 · N222UT · Substantial damageNTSB WPR10CA035Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Angwin, CAThe pilot's failure to properly identify the runway surface for takeoff and his subsequent failure to abort the takeoff when he realized he was not on the runway. Contributing to the accident was the pilot’s failure to select the appropriate radio frequency…Oct 30, 2009 · N1721T · Substantial damageNTSB WPR10CA037Accident · No injuriesData collectionFinal reportSocata TB200 · Edwards, CAThe pilot's improper flare resulting in a hard landing. Contributing to the accident was the sunglare.Oct 24, 2009 · N3052N · Substantial damageNTSB WPR09LA436Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Torrance, CAA main rotor overspeed due to the pilot’s failure to maintain rotor RPM within allowable limits during a practice autorotation.Sep 3, 2009 · N8361X · Substantial damageNTSB WPR09TA356Accident · 1 fatalFinal reportBell 212 · Willow Creek, CAThe rappeller's failure to properly latch the rappelling harness to the rappelling assembly before exiting the helicopter.Jul 21, 2009 · N212HP · No damageNTSB WPR09FA234Accident · 2 fatalField investigationFinal reportUpton Bakeng Duce · Ramona, CAAn in-flight separation of the right wing, which resulted from the pilot's performance of a maneuver that produced aerodynamic loads that exceeded the wing spar’s degraded strength. The wing spar strength degradation was due to the builder's failure to comply…May 9, 2009 · N86YP · Substantial damageNTSB WPR09IA187Incident · No injuriesIncident investigationFinal reportLiberty Aerospace Liberty XL-2 · Camarillo, CAThe cruise flight separation of the canopy door. Contributing to the incident was the pilot's failure to ensure that the left side door was securely closed prior to takeoff.Apr 5, 2009 · N519XL · Minor damage