NTSB investigations, CA

104 cases where the sequence of events included Abnormal runway contact.

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\" = '090' 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 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 WPR16FA157Accident · 1 fatalField investigationFinal reportArion Lightning LS-1 · Van Nuys, CAThe pilot's loss of airplane control due to an exceedance of the airplane's critical angle of attack, which resulted in an accelerated stall and subsequent impact with a building. Contributing to the accident was the pilot's unreported physiological…Aug 2, 2016 · N341AL · 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 GAA16CA209Accident · No injuriesData collectionFinal reportCessna 152 · Palo Alto, CAThe student pilot's decision to takeoff in wind conditions that exceeded his certificated flight instructor's maximum wind endorsement, and the student pilot's failure to maintain pitch control during the touchdown, resulting in abnormal runway contact, and…Apr 30, 2016 · N94565 · Substantial damageNTSB GAA16CA211Accident · No injuriesData collectionFinal reportCessna 152 · Hayward, CAThe student pilot's high descent rate during the landing flare, which resulted in a hard landing, nose landing gear collapse, and runway excursion during an aborted landing.Apr 28, 2016 · N6427Q · Substantial damageNTSB GAA16CA202Accident · No injuriesData collectionFinal reportCessna 172 · Camarillo, CAThe student pilot's incorrect pitch control input, resulting in a porpoise during landing and substantial damage to the airplane's firewall.Apr 20, 2016 · N6616D · Substantial damageNTSB GAA16CA151Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Riverside, CAThe student pilot's incorrect action performance by not applying sufficient pressure to the right anti-torque pedal, resulting in an uncontrollable left yaw, and ground impact.Mar 17, 2016 · N9076U · 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 GAA15CA239Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Susanville, CAThe pilot's failure to maintain airspeed control during the landing in gusty wind conditions, resulting in an abnormal runway contact, and collision with terrain.Aug 26, 2015 · N1417X · 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 GAA15CA149Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Novato, CAThe pilot's improper pitch control which resulted in a bounced landing, runway excursion, and collision with terrain.Jun 28, 2015 · N9069J · 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 GAA15LA092Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Fresno, CAThe failure of the nose landing gear (NLG) leg due to fatigue fractures, which resulted in the NLG collapsing during landing.May 24, 2015 · N642JB · Substantial damageNTSB GAA15CA063Accident · Minor injuriesData collectionFinal reportCessna 172P · Los Angeles, CAThe student pilot's failure to maintain attitude control during the landing flare, resulting in a hard landing.Apr 30, 2015 · N65813 · 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 WPR15CA031Accident · No injuriesData collectionFinal reportSIAI Marchetti S211 · Borrego Valley, CAThe private pilot's premature landing flare and the flight instructor's delayed remedial action, which resulted in a hard landing.Oct 24, 2014 · N211JY · Substantial damageNTSB WPR15CA028Accident · No injuriesData collectionFinal reportCessna 172 - S · Hawthorne, CAThe pilot's improper flare which resulted in a loss of aircraft control and subsequent hard landing.Oct 23, 2014 · N564AT · 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 WPR14CA379Accident · No injuriesData collectionFinal reportCessna 152 · Santa Rosa, CAThe student pilot's inadequate flare resulted in a hard landing.Sep 1, 2014 · N67367 · Substantial damageNTSB WPR14CA351Accident · No injuriesData collectionFinal reportCessna 172S · Santa Ynez, CAThe student pilot's inadequate flare and loss of aircraft control during landing, which resulted in multiple bounces.Aug 16, 2014 · N10033 · Substantial damageNTSB WPR14CA295Accident · No injuriesData collectionFinal reportCessna R182 · El Monte, CAThe failure of the right main landing gear pivot assembly. Contributing to the accident was the owner's failure to perform an inspection of the assembly in accordance with the manufacturer's service bulletin.Jul 18, 2014 · N7571T · Substantial damageNTSB WPR14CA293Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Marysville, CAThe pilot's failure to adequately monitor the environmental conditions to assure the aircraft performance would afford an uneventful takeoff with the loading conditions. Contributing to the accident were the pilot's inability to jettison the load due to the…Jul 14, 2014 · N48475 · 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 WPR14CA039Accident · No injuriesData collectionFinal reportYuneec Yuneec · Upland, CAThe pilot's improper flare, which resulted in a loss of aircraft control and hard landing.Nov 1, 2013 · N400XW · Substantial damageNTSB WPR13CA260Accident · No injuriesData collectionFinal reportWampach Murphy Moose · Galt, CAThe pilot's improper landing flare, which resulted in an abnormal runway contact.Jun 1, 2013 · N331RW · Substantial damageNTSB WPR13CA166Accident · No injuriesData collectionFinal reportBellanca 7ECA · Sonoma, CAThe student pilot’s failure to maintain directional control during the touchdown and landing roll.Mar 16, 2013 · N8564V · Substantial damageNTSB WPR13CA104Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Torrance, CAThe pilot’s improper landing flare, which resulted in a bounced landing.Jan 15, 2013 · N5384W · Substantial damageNTSB WPR13CA089Accident · Minor injuriesData collectionFinal reportStribling James L RV4 · Georgetown, CAThe pilot’s improper landing flare and failure to maintain directional control during landing.Jan 8, 2013 · N70AC · Substantial damageNTSB WPR13CA055Accident · No injuriesData collectionFinal reportPiper PA18 · Needles, CAThe flight instructor, while demonstrating a water landing to the pilot receiving instruction, did not maintain proper alignment with the landing surface, which resulted in a hard landing.Nov 24, 2012 · N2224 · Substantial damageNTSB WPR13CA021Accident · No injuriesData collectionFinal reportPiper PA24 · Lake Tahoe, CAThe pilot's failure to ensure that the landing gear was extended before landing.Oct 21, 2012 · N7950P · Substantial damageNTSB WPR12CA435Accident · No injuriesData collectionFinal reportPiper PA24 · Madera, CAThe student's and flight instructor’s failure to ensure that the landing gear was extended prior to landing.Sep 20, 2012 · N8648P · Substantial damageNTSB WPR12CA330Accident · No injuriesData collectionFinal reportAlon A2 · Compton, CAThe pilot's failure to maintain directional control during landing.Jul 28, 2012 · N5486E · Substantial damageNTSB WPR12CA310Accident · No injuriesData collectionFinal reportPiper PA-46 · Delano, CAThe pilot's failure to extend the landing gear before touchdown. Contributing to the accident was the pilot's failure to perform the appropriate checklist due to distractions posed by another airplane inbound to the same airport and a cluttered radio…Jul 17, 2012 · N558RW · Substantial damageNTSB WPR12CA268Accident · Minor injuriesData collectionFinal reportCessna 182P · Woodland, CAThe pilot's failure to maintain a proper descent path during the approach to land, which resulted in a hard, bounced landing, and his improper retraction of the flaps during the subsequent attempted go-around.Jun 17, 2012 · N7437Q · Substantial damageNTSB WPR12LA104Accident · No injuriesLimited investigationFinal reportBeech G18 · Hollister, CAThe pilot’s failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall and a subsequent hard landing, loss of directional control, and ground loop.Feb 14, 2012 · VH-NWB · Substantial damageNTSB WPR11CA445Accident · No injuriesData collectionFinal reportAero SP Z O O AT-4 LSA · San Diego, CAThe pilot's improper recovery from a bounced landing and failure to maintain control during an attempted go-around.Sep 10, 2011 · N334RA · Substantial damageNTSB WPR11LA443Accident · No injuriesLimited investigationFinal reportCessna 152 · Redlands, CAThe flight instructor’s delayed remedial action and failure to maintain airplane control while performing a simulated aborted landing.Sep 6, 2011 · N4649L · Substantial damageNTSB WPR11TA274Accident · No injuriesFinal reportBell 206B · Franklin, CAThe student pilot's failure to maintain rotor rpm during the practice autorotation.Jun 21, 2011 · N38EA · Substantial damageNTSB WPR11LA273Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Marysville, CAThe separation of the right main landing gear during takeoff, due to fatigue.Jun 21, 2011 · N3627G · Substantial damageNTSB WPR11LA216Accident · No injuriesLimited investigationFinal reportDralle RV-8 · Livermore, CAThe pilot's decision to exit the runway while still traveling at an excessive speed and his subsequent loss of directional control.May 1, 2011 · N998RV · Substantial damageNTSB WPR11CA057Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Fullerton, CAThe pilot's improper flare during landing.Nov 24, 2010 · N459CT · Substantial damageNTSB WPR10LA445Accident · Serious injuriesLimited investigationFinal reportMorehead KR-2 · Rancho Murieta, CAThe pilot’s improper flare and recovery from a bounced landing.Sep 2, 2010 · N522PC · Substantial damageNTSB WPR10CA392Accident · No injuriesData collectionFinal reportCessna 172P · San Jose, CAThe pilot’s improper flare and inadequate recovery from a bounced landing.Aug 8, 2010 · N64204 · Substantial damageNTSB WPR10CA351Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Fullerton, CAThe pilot’s improper flare and inadequate bounced landing recovery, which resulted in a hard landing and porpoise down the runway.Jul 15, 2010 · N8337A · Substantial damageNTSB WPR10CA350Accident · No injuriesData collectionFinal reportCessna 170 · Truckee, CAThe pilot’s failure to maintain directional control during an aborted landing, resulting in a collision with obstacles.Jul 14, 2010 · N3967V · Substantial damageNTSB WPR10CA263Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAThe pilot's improper recovery from a bounced landing.May 25, 2010 · N69254 · Substantial damageNTSB WPR10CA190Accident · No injuriesData collectionFinal reportCessna T210N · Truckee, CAThe pilot's failure to identify the snow-covered runway, which resulted in an off-runway landing and subsequent collision with a berm.Apr 3, 2010 · N4137C · Substantial damageNTSB WPR10CA178Accident · No injuriesData collectionFinal reportHardie James D KIT FOX XL · Willows, CAThe pilot’s improper flare, resulting in a bounced landing and ground loop.Mar 24, 2010 · N42JH · Substantial damageNTSB WPR10CA065Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe flight instructor's failure to arrest the helicopter's descent and to maintain lateral control during a hovering autorotation practice.Nov 25, 2009 · N505LA · Substantial damageNTSB WPR09CA466Accident · Minor injuriesData collectionFinal reportBeech A23-19 · Tehachapi, CAThe pilot's failure to attain an established approach path while on final approach resulting in an improper flare and bounced landing.Sep 26, 2009 · N7944L · Substantial damage