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 WPR24LA007Accident · No injuriesClass 4 · LimitedFinal reportScott And Laura Hoisington CCX-2000 · South Lake Tahoe, CAThe pilot’s loss of directional control during landing roll, which resulted in a ground loop and collision with terrain.Oct 5, 2023 · N531SL · Substantial damageNTSB WPR24LA003Accident · No injuriesClass 3 · LimitedFinal reportCessna 340A · Hayward, CAThe pilot’s sudden incapacitation from effects of a previously undiagnosed underlying heart disease, which resulted in his loss of control of the airplane and subsequent impact with terrain.Oct 2, 2023 · N121CB · Substantial damageNTSB WPR23LA359Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · San Diego, CAThe pilot’s failure to maintain directional control during landing in gusty wind conditions that resulted in a ground loop.Sep 27, 2023 · N9128K · Substantial damageNTSB WPR23LA355Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Woodland, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.Sep 7, 2023 · N234RA · Substantial damageNTSB WPR23LA312Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Dixon, CAThe pilot’s loss of directional control after striking an unidentified object during landing on an unimproved runway, and his subsequent use of excessive braking that resulted in a nose-over.Aug 9, 2023 · N50443 · Substantial damageNTSB WPR23LA253Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Novato, CAThe pilot's failure to maintain directional control of the airplane during the landing roll for a touch and go, which resulted in a collision with terrain.Jun 30, 2023 · N372AH · Substantial damageNTSB WPR23LA235Accident · No injuriesClass 4 · LimitedFinal reportJohn Topliff PA18-200EXP · Truckee, CAThe pilot’s loss of directional control on landing roll out, during variable wind conditions.Jun 21, 2023 · N356AW · Substantial damageNTSB WPR23LA229Accident · No injuriesClass 3 · LimitedFinal reportCessna 305C (0-1E) · Big Bear City, CAThe pilot’s failure to maintain directional control of the airplane during takeoff.Jun 17, 2023 · N62TX · Substantial damageNTSB WPR23LA216Accident · No injuriesClass 3 · LimitedFinal reportCessna 172R · Santa Monica, CAA failure of the nose wheel upper torque link bolt, which resulted in a loss of steering control. Contributing to the accident were maintenance personnel’s failure to inspect and replace the fractured bolt and the pilot’s oversight of the bolt during his…Jun 5, 2023 · N819KS · Substantial damageNTSB WPR23LA300Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tracy, CAThe pilot’s failure to maintain directional control during the landing roll after encountering a wind gust.May 17, 2023 · N2771C · Substantial damageNTSB WPR23LA181Accident · No injuriesClass 4 · LimitedFinal reportSteven Radenbaugh JA35 Superstol · Moorpark, CAThe pilot’s failure to maintain control of the airplane during an off airport precautionary landing. Contributing to the accident was the pilot’s decision to continue the flight with a possible mechanical malfunction.May 6, 2023 · N799CP · Substantial damageNTSB WPR23LA174Accident · No injuriesClass 4 · LimitedFinal reportCessna T210N · San Luis Obispo, CAThe pilot’s failure to maintain directional control during the landing roll.May 2, 2023 · N29TR · Substantial damageNTSB WPR23LA165Accident · No injuriesClass 4 · LimitedFinal reportOneal J R/Oneal R C EDI Express · Tracy, CAThe pilot’s failure to maintain directional control during the takeoff roll.Apr 24, 2023 · N92734 · Substantial damageNTSB WPR23LA161Accident · No injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Concord, CAThe pilot’s failure to maintain directional control of the airplane during a landing in gusting wind conditions.Apr 14, 2023 · N80922 · Substantial damageNTSB WPR23LA124Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Van Nuys, CAThe pilots failure to maintain directional control during takeoff.Mar 10, 2023 · N73726 · Substantial damageNTSB WPR23LA119Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Fullerton, CAThe student pilot's failure to maintain control of the airplane during the landing roll and the flight instructor’s delayed remedial action, which resulted in an impact with an obstacle.Feb 15, 2023 · N8318C · Substantial damageNTSB WPR23LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 195A · Calexico, CAThe pilot’s failure to maintain directional control during the landing roll in gusting wind.Jan 20, 2023 · N95U · Substantial damageNTSB WPR23LA050Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Long Beach, CAThe pilot’s failure to maintain directional control during landing.Oct 26, 2022 · N75321 · Substantial damageNTSB WPR23LA014Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Petaluma, CAThe pilot’s failure to maintain directional control during landing in gusting wind.Oct 15, 2022 · N42PT · Substantial damageNTSB WPR23LA008Accident · No injuriesClass 4 · LimitedFinal reportSeabourn Scott R CCK-2000 · Clarksburg, CAThe pilot's failure to maintain directional control during the landing roll with a gusting quartering tailwind.Oct 1, 2022 · N699X · Substantial damageNTSB WPR22LA369Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Maxwell, CAThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion.Sep 10, 2022 · N7550B · Substantial damageNTSB WPR22FA338Accident · 2 fatalClass 3 · FieldFinal reportCzech Sport Piper Sport · Santa Monica, CAThe pilot’s inability to maintain control of the airplane during the landing flare due to the passenger’s excessive control inputs, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall.Sep 8, 2022 · N126WK · DestroyedNTSB WPR22LA252Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · San Martin, CAThe pilot’s failure to maintain directional control during landing.Jul 14, 2022 · N9802E · Substantial damageNTSB WPR22LA232Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-235 · Copperopolis, CAThe pilot’s failure to maintain lateral control of the airplane during takeoff in gusting wind.Jun 11, 2022 · N13ZF · Substantial damageNTSB WPR22FA198Accident · 1 fatalClass 3 · FieldFinal reportBeech 77 · Hemet, CAThe student pilot’s failure to maintain clearance from a cinderblock wall while performing a go-around.Jun 7, 2022 · N18244 · Substantial damageNTSB WPR22LA191Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Carlsbad, CAThe pilot’s failure to maintain directional control of the airplane during takeoff.May 30, 2022 · N722PA · Substantial damageNTSB WPR22LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Franklin, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.May 12, 2022 · N23FG · Substantial damageNTSB WPR22LA163Accident · No injuriesClass 3 · LimitedFinal reportTextron T206H · Santa Barbara, CAThe loss of directional control for undetermined reasons. Contributing was the overstress fracture of the nose gear upper trunnion brace attach point.Apr 21, 2022 · N20617 · Substantial damageNTSB WPR22LA134Accident · Minor injuriesClass 4 · LimitedFinal reportAutogyro Cavalon · El Monte, CAThe pilot’s diverted attention during landing, which resulted in a loss of directional control.Mar 23, 2022 · N1688B · Substantial damageNTSB WPR22LA111Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Banning, CAThe solo student pilot's improper landing flare and bounced landing, which resulted in a runway excursion and impact with a parked vehicle and hanger.Feb 26, 2022 · N9010H · Substantial damageNTSB WPR22LA110Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL11C-100 · Placerville, CALoss of directional control during landing with a tailwind.Feb 19, 2022 · N800SW · Substantial damageNTSB WPR22LA093Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Chemehuevi Valley, CAThe student pilot’s loss of directional control during takeoff.Feb 8, 2022 · N6496L · Substantial damageNTSB WPR22LA085Accident · No injuriesClass 4 · LimitedFinal reportUniversal Stinson 108-2 · Byron, CAThe pilot’s inadequate flare and loss of directional control during landing which resulted in a runway excursion. Contributing to the accident was the instructor’s delayed remedial action.Jan 27, 2022 · N9433K · Substantial damageNTSB WPR22LA070Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Mojave, CAThe pilot’s failure to maintain airplane control during an encounter with a wind gust during taxi.Dec 31, 2021 · N89084 · Substantial damageNTSB WPR22LA051Accident · No injuriesClass 4 · LimitedFinal reportTravel Air 4-D · Riverside, CAThe pilot's failure to abort a high-speed taxi in time before the airplane exited the end of the airstrip which resulted in the pilot’s over application of the brakes and subsequent nose over.Nov 30, 2021 · N476N · Substantial damageNTSB WPR22LA008Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Garberville, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent collision with an unoccupied parked airplane.Oct 4, 2021 · N3453K · Substantial damageNTSB WPR21LA349Accident · No injuriesClass 4 · LimitedFinal reportBeech D17S · San Diego / El Cajon, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll with a crosswind, which resulted in a runway excursion and subsequent collision with runway signage.Sep 21, 2021 · N1196V · Substantial damageNTSB WPR21LA282Accident · No injuriesClass 4 · LimitedFinal reportJabiru USA Sport J230-SP · Oceano, CAThe pilot’s failure to maintain directional control after landing fast and hard which damaged the right main landing gear wheel pant which lodged under the wheel.Jun 5, 2021 · N733J · Substantial damageNTSB WPR21LA217Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Carlsbad, CAThe student pilot’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control.May 31, 2021 · N47UP · Substantial damageNTSB WPR21LA199Accident · Minor injuriesClass 4 · LimitedFinal reportHarry Crosby RV-6 · Byron, CAThe pilot’s failure to maintain directional control of the airplane during takeoff while operating in gusting wind conditions, which resulted in a runway excursion and subsequent collision with terrain.May 18, 2021 · N16CX · Substantial damageNTSB WPR21LA197Accident · No injuriesClass 4 · LimitedFinal reportStearman 4E · Porterville, CAThe pilot’s loss of directional control while landing, which resulted in a landing gear collapse.May 17, 2021 · N663K · Substantial damageNTSB WPR21LA221Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2010 · Truckee, CAThe pilot’s improper flare during a landing attempt in crosswind conditions, which resulted in a bounced landing and impact with the ground.May 12, 2021 · N2010P · Substantial damageNTSB WPR21LA187Accident · No injuriesClass 4 · LimitedFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Sacramento, CAThe pilot’s failure to maintain directional control during landing in gusty wind conditions which resulted in a runway excursion and collision with terrain.May 9, 2021 · N104GX · Substantial damageNTSB WPR21LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · San Bernardino, CAThe pilot’s improper landing flare, which resulted in a hard landing and his subsequent inadequate pitch and airplane control during a go around which resulted in a nose landing gear collapse.May 8, 2021 · N54PW · Substantial damageNTSB WPR21LA167Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Petaluma, CAThe pilot's failure to maintain directional control while landing in gusting wind conditions, which resulted in a ground loop.Mar 27, 2021 · N712YP · Substantial damageNTSB WPR21LA125Accident · No injuriesClass 4 · LimitedFinal reportPhillip B Rolls Pitts 12-EH · Red Bluff, CAThe pilot's failure to maintain directional control during a landing, which resulted in a ground loop and subsequent nose over.Mar 8, 2021 · N54LM · Substantial damageNTSB WPR21LA126Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 190 · Camarillo, CAThe failure of the pilot to maintain directional control of the airplane during the landing roll which resulted in a runway excursion and subsequent nose over.Mar 7, 2021 · N190RC · Substantial damageNTSB WPR21LA106Accident · No injuriesClass 4 · LimitedFinal reportJabiru SP 250 · Thermal, CAThe pilot’s loss of directional control during landing in gusting wind conditions, which resulted in a runway excursion and nose over.Feb 5, 2021 · N7850K · Substantial damageNTSB WPR21LA076Accident · No injuriesClass 4 · LimitedFinal reportExtra Flugzeugbau EA 300/L · Santa Monica, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.Jan 3, 2021 · N52NL · Substantial damageNTSB WPR21LA049Accident · No injuriesClass 3 · LimitedFinal reportRonald A Gawer RV-12 · Byron, CAThe total loss of engine power due to a fatigue fracture of the crankshaft.Nov 6, 2020 · N975G · Substantial damage