NTSB investigations, CA

359 cases where the sequence of events included Loss of control in flight.

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\" = '240' 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 WPR15FA021Accident · 2 fatalField investigationFinal reportSlingsby T67M 260 · Ridgecrest, CAThe pilots' failure to recover from a spin for reasons that could not be determined based on available information. Contributing to the student's fatal injury was his delayed egress from the airplane below the specified egression altitude.Oct 24, 2014 · N456FR · Substantial damageNTSB WPR15FA016Accident · 1 fatalField investigationFinal reportSonex Sonex Trigear · Fawnskin, CAThe pilot's failure to maintain airspeed after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall/spin at low altitude. Contributing to the accident was the airplane's reduced climb…Oct 20, 2014 · N91922 · Substantial damageNTSB WPR14CA397Accident · No injuriesData collectionFinal reportPiper PA 24-250 · Rancho Murieta, CAThe student pilot's failure to maintain adequate airspeed during takeoff and the certified flight instructors delayed remedial action, which resulted in the stall.Sep 28, 2014 · N8129P · 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 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 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 WPR14LA361Accident · Serious injuriesLimited investigationFinal reportTravel Air C 4000 · Williams, CAThe failure of the elevator control tube due to corrosion, which resulted in a loss of elevator control and collision with terrain.Aug 30, 2014 · N9952 · Substantial damageNTSB WPR14CA354Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe student pilot's failure to maintain helicopter control during a practice hover. Contributing to the accident was the flight instructor's delayed remedial reaction.Aug 24, 2014 · N341SL · Substantial damageNTSB WPR14FA324Accident · Serious injuriesField investigationFinal reportS.N.I.A.S. AS350B · Tahoma, CAThe pilot's loss of helicopter control due to settling with power while maneuvering for takeoff.Aug 1, 2014 · N3597T · Substantial damageNTSB WPR14FA320Accident · 1 fatalField investigationFinal reportMooney M20L - NO Series · San Diego, CAThe pilot's failure to achieve climb performance and maintain sufficient airspeed during a go-around, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's failure…Jul 31, 2014 · N147MP · Substantial damageNTSB WPR14CA292Accident · Serious injuriesData collectionFinal reportJonker Sailplanes JS1-C · Truckee, CAThe pilot's failure to maintain aircraft control in gusting wind conditions while on final approach to the runway.Jul 14, 2014 · N501WG · Substantial damageNTSB WPR14FA258Accident · 1 fatalField investigationFinal reportParker Loehle Mustang T5151 · Livermore, CAAn in-flight fire of unknown origin for reasons that could not be determined because of impact damage and postimpact fire damage.Jun 22, 2014 · N518BC · DestroyedNTSB WPR14FA239Accident · 2 fatalField investigationFinal reportAmerican AA-1A · El Mirage, CAThe pilot's loss of airplane control while intentionally maneuvering close to the ground, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering an accelerated stall.Jun 9, 2014 · N9454L · DestroyedNTSB WPR14FA234Accident · 2 fatalField investigationFinal reportPiper J3C · Paso Robles, CAThe pilot's steep right turn shortly after takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Jun 7, 2014 · N24918 · Substantial damageNTSB WPR14LA173Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 600N · Adelanto, CAThe commercial pilot’s improper control inputs, which resulted in a loss of helicopter control during takeoff.Apr 27, 2014 · N606BP · Substantial damageNTSB WPR14TA149Accident · No injuriesFinal reportBell OH-58A · Tehachapi, CAThe pilot's decision to attempt a mission at night with known en route weather conditions below operating minimums, likely due to self-induced pressure, and then continue flight beyond the alternate landing airport as weather conditions deteriorated, which…Mar 27, 2014 · N497E · Substantial damageNTSB WPR14FA127Accident · 1 fatalField investigationFinal reportPiper PA 46 350P · Truckee, CAThe pilot’s failure to properly execute the missed approach in instrument conditions. Contributing to the accident were the pilot’s lack of instrument proficiency, as demonstrated by his failure to execute the required procedure turn to align with the final…Mar 3, 2014 · N9281F · 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 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 WPR14FA078Accident · 2 fatalField investigationFinal reportCessna 172K · Fresno, CAThe pilot’s failure to maintain adequate clearance from trees while on approach, which subsequently led to a loss of airplane control. Also causal was the pilot’s continued operation of the airplane at night with a diagnosed medical condition that degraded…Dec 27, 2013 · N251JM · DestroyedNTSB WPR14CA070Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Jose, CAThe flight instructor's failure to correct for the student pilot's loss of aircraft control in a timely manner during takeoff. Contributing to the accident was the instructor's inability to see the taxiway sign from the rear seat.Dec 15, 2013 · N53893 · Substantial damageNTSB WPR14CA016Accident · No injuriesData collectionFinal reportChampion 7ECA · Willows, CAThe pilot's failure to maintain sufficient altitude while flying low over a field which resulted in a loss of aircraft control and collision with terrain.Oct 12, 2013 · N9599S · Substantial damageNTSB WPR13CA428Accident · Minor injuriesData collectionFinal reportCessna 182Q · Big Bear, CAThe pilot's failure to maintain a stabilized landing approach, which resulted in a collision with a fence short of the runway.Sep 28, 2013 · N759UP · 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 WPR13FA388Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Desert Center, CAThe pilot's abrupt maneuver, which resulted in an accelerated stall and a loss of airplane control at low altitude.Aug 26, 2013 · N61VT · Substantial damageNTSB WPR13FA370Accident · 2 fatalField investigationFinal reportChampion 7GCAA · Paradise, CAThe pilot's failure to maintain airplane control during low-altitude maneuvering after encountering an updraft.Aug 13, 2013 · N9607S · DestroyedNTSB WPR13CA367Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Hesperia, CAThe pilot’s failure to maintain sufficient airspeed on final approach to landing which resulted in an inadvertent stall.Aug 11, 2013 · N7720P · Substantial damageNTSB WPR13LA347Accident · 1 fatalLimited investigationFinal reportAirborne Windsports PTY Edge XT-912-L · Red Bluff, CAThe pilot's failure to properly secure himself in the cockpit with the seat belt, which resulted in his inability to control the airplane after takeoff.Jul 29, 2013 · N123FJ · DestroyedNTSB WPR13FA335Accident · 1 fatalField investigationFinal reportMooney M20C · South Lake Tahoe, CAThe pilot’s decision to turn into rising terrain that would have required performance in excess of the airplane’s maximum climb rate to clear after taking off at a high density altitude.Jul 22, 2013 · N6709U · Substantial damageNTSB WPR13LA314Accident · Serious injuriesLimited investigationFinal reportLuy Wayman Lockwood Aircam · Groveland, CAThe pilot’s inadequate compensation for a crosswind and failure to maintain airplane control during a go-around.Jul 7, 2013 · N94C · Substantial damageNTSB WPR13LA313Accident · 1 fatalLimited investigationFinal reportNorth Wing Uum Sport X2 · Parker Dam, CAThe student pilot’s abrupt maneuver to avoid transmission wires, which resulted in his loss of airplane control. Contributing to the accident were the pilot’s decision to perform a low-altitude flight, his distracted attention, and his failure to monitor the…Jul 7, 2013 · N467YN · Substantial damageNTSB WPR13CA301Accident · No injuriesData collectionFinal reportCessna 170B · Fallbrook, CAThe pilot’s failure to maintain adequate airspeed during the takeoff, and his loss of aircraft control during the subsequent stall recovery.Jun 30, 2013 · N2600D · Substantial damageNTSB WPR13FA269Accident · 2 fatalField investigationFinal reportGraves SH-2F · Montague, CAThe pilot’s failure to maintain airplane control while maneuvering for reasons that could not be determined during postaccident testing and examination, which resulted in a stall and subsequent spin.Jun 12, 2013 · N15GG · DestroyedNTSB WPR13CA257Accident · Serious injuriesData collectionFinal reportCessna 182P · Bridgeport, CAThe pilot's distracted attention while on final approach which resulted in his failure to maintain adequate airspeed and subsequent loss of aircraft control.Jun 2, 2013 · N21231 · Substantial damageNTSB WPR13FA236Accident · 2 fatalField investigationFinal reportCessna 170B · Auburn, CAThe pilot's failure to maintain airplane control during approach to landing, which resulted in an inadvertent stall and subsequent spin.May 19, 2013 · N2865C · Substantial damageNTSB WPR13LA233Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164D · Butte City, CAThe pilot's failure to maintain airplane control after an encounter with wake turbulence while maneuvering at low altitude. Contributing to the accident was the pilot’s fatigue due to extended hours of wakefulness and high workload.May 16, 2013 · N83110 · Substantial damageNTSB WPR13FA234Accident · 1 fatalField investigationFinal reportCessna 421C · Floriston, CAThe pilot's failure to maintain airplane control during descent while operating in instrument meteorological conditions.May 16, 2013 · N421W · DestroyedNTSB WPR13CA172Accident · No injuriesData collectionFinal reportWaco YMF-3 · Thermal, CAThe pilot’s failure to maintain directional control while landing in a gusting crosswind.Mar 30, 2013 · N14080 · Substantial damageNTSB WPR13CA160Accident · No injuriesData collectionFinal reportHughes 269C · Rialto, CAThe student pilot’s failure to maintain helicopter control while maneuvering in a hover.Mar 25, 2013 · N90570 · Substantial damageNTSB WPR13CA164Accident · No injuriesData collectionFinal reportPiper PA-30 · Fullerton, CAThe pilot receiving instruction’s failure to maintain airplane control during takeoff and the flight instructor’s delayed remedial action.Mar 23, 2013 · N7497Y · Substantial damageNTSB WPR13FA086Accident · 2 fatalField investigationFinal reportBeech V35A · Woody, CAAn in-flight encounter with icing conditions during descent, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall followed by an in-flight breakup.Jan 7, 2013 · N35SD · DestroyedNTSB WPR13CA065Accident · No injuriesData collectionFinal reportBellanca 7ECA · Tehachapi, CAThe non-instrument-rated pilot's continued descent into instrument meteorological conditions during the landing approach and his loss of situational awareness, which resulted in a collision with terrain.Dec 8, 2012 · N8595V · Substantial damageNTSB WPR13FA037Accident · 2 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAThe pilot's failure to regain airplane control following a sudden rapid descent during cruise, which resulted in an in-flight breakup. Contributing to the accident was the pilot's decision to make the flight with a failed vacuum pump, particularly at high…Nov 11, 2012 · N700EM · 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 WPR13FA022Accident · 2 fatalField investigationFinal reportBehne Glasair III · Byron, CAThe pilot's failure to maintain control of the airplane while maneuvering, which resulted in a stall and subsequent spin.Oct 23, 2012 · N655DB · DestroyedNTSB 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 WPR12LA417Accident · Minor injuriesLimited investigationFinal reportSeymour Skyranger · Perris, CAA loss of aircraft control during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Sep 13, 2012 · N936LS · Substantial damageNTSB WPR12LA407Accident · 1 fatalLimited investigationFinal reportMoore Edward R MXS · Borrego Springs, CAThe pilot’s inability to maintain control of the airplane following the loss of aileron and elevator control due to the forward flight control torque tube assembly’s detachment from the forward bearing. Contributing to the accident was the inadequate…Sep 8, 2012 · N21MX · Substantial damageNTSB WPR12LA359Accident · Serious injuriesLimited investigationFinal reportFechtner KR-2 · Tehachapi, CAThe pilot's failure to maintain control of the airplane during the approach to the airport.Aug 14, 2012 · N37686 · Substantial damageNTSB WPR12FA339Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Truckee, CAThe pilot’s failure to maintain control of the airplane during initial climb. Contributing to the accident was the pilot’s impairment by prescription pain medication.Aug 2, 2012 · N8218P · Substantial damage