NTSB investigations, CA
109 cases where the defining event was Hard landing.
Cases per year
| 2008 | 19 |
|---|---|
| 2009 | 16 |
| 2010 | 7 |
| 2011 | 9 |
| 2012 | 6 |
| 2013 | 7 |
| 2014 | 4 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 7 |
| 2018 | 2 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 1 |
| 2024 | 4 |
| 2025 | 1 |
| 2026 | 5 |
Where
Open the mapLatest cases
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '092')
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.
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '092') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR26LA332Accident · No injuriesClass 4 · LimitedInvestigation openCessna 152 · Carlsbad, CANTSB WPR26LA194Accident · Minor injuriesClass 4 · LimitedFinal reportAutogyro Cavalon · Palo Alto, CAThe pilot’s failure to maintain directional control during the landing roll, in gusting crosswind conditions.NTSB WPR26LA143Accident · No injuriesClass 4 · LimitedFinal reportPaul D Cannon Kitfox Light Squared · Lincoln, CAThe pilot's failure to properly flare the airplane during landing, which resulted in a hard landing and separation of the main landing gear. Contributing to the accident was the improper installation and over torquing of the landing gear attachment hardware,…NTSB WPR26LA148Accident · No injuriesClass 4 · LimitedFinal reportQuicksilver GT-400 · Chula Vista, CAThe pilot’s improper landing flare, which resulted in a bounced landing and a subsequent runway excursion.NTSB DCA26LA097Accident · No injuriesClass 4 · LimitedFinal reportBoeing 767 · San Bernardino, CAThe flight crew’s improper derotation which resulted in a hard nose gear touchdown. Contributing to the accident was the captain and first officer’s lack of crew resource management related to communication about pitch control inputs. Contributing to the…NTSB ANC25LA032Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Redding, CAThe pilot's failure to maintain a stabilized approach and his delayed action to perform a go-around, resulting in a collision with the runway surface.NTSB WPR25LA028Accident · No injuriesClass 4 · LimitedFinal reportDierenfield Devin RV-6A · Lancaster, CAThe pilot’s failure to maintain a stablized approach, which resulted in a hard landing.NTSB WPR24LA310Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Redlands, CAThe pilot’s failure to maintain airplane control during final approach, which resulted in a collision with rocky terrain.NTSB WPR24LA272Accident · Minor injuriesClass 4 · LimitedFinal reportRenquist George GS-2 Sportsman · Hawthorne, CAThe flight crew’s failure to maintain airspeed during a short field landing and the instructor’s delayed remediation, which resulted in a hard landing.NTSB WPR24LA163Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Livermore, CAThe flight instructor’s delayed remedial action, which resulted in an aerodynamic stall and abnormal contact with the runway. Contributing to the accident was the student pilot’s improper landing flare and go-around.NTSB WPR22LA167Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Redding, CAThe student pilot's improper landing flare and remedial action which resulted in a bounced landing.NTSB WPR22LA028Accident · No injuriesClass 4 · LimitedFinal reportBearhawk 4 · Redding, CAThe pilot’s improper landing flare which resulted in a hard landing and subsequent ground loop.NTSB WPR21LA364Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Auburn, CAThe student pilot’s inadequate flare which resulted in a hard and bounced landing.NTSB WPR21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Hayward, CAThe pilot's improper landing flare, which resulted in a bounced hard landing.NTSB 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.NTSB WPR20CA132Accident · No injuriesClass 4 · Data collectionFinal reportCook Sonex · Upland, CAA gradual loss of engine power during takeoff due to the pressure regulator not keeping continuous fuel pressure which led to a precautionary off airport landing and collision with terrain.NTSB WPR20CA105Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Santa Barbara, CAThe pilot's failure to maintain adequate airspeed during the approach, which resulted in a rapid descent rate, hard landing, and nose-over.NTSB WPR20CA064Accident · Minor injuriesData collectionFinal reportAirborne XT912 · Hawthorne, CAThe student pilot's failure to arrest the airplane’s descent rate, which resulted in a hard landing.NTSB GAA20CA034Accident · Minor injuriesData collectionFinal reportBell 47G · King City, CAThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing and the main rotor blades striking the tailboom.NTSB GAA19CA537Accident · No injuriesData collectionFinal reportCzech Sport Sportcruiser · Murrieta, CAThe student pilot's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control and a hard landing.NTSB GAA19CA284Accident · No injuriesData collectionFinal reportSchweizer 269C · Riverside, CAThe student pilot's failure to maintain yaw control and the engine's rpm during transition to a hover, which resulted in hard landing.NTSB WPR19TA110Accident · Serious injuriesClass 3Final reportKubicek BB100 · St. Helena, CAThe balloon pilot's encounter with unforecasted wind, which resulted in his decision to land in unsuitable terrain and a subsequent hard landing. Contributing to the severity of passenger injury was the pilot’s failure to provide a proper safety briefing.NTSB WPR18LA226Accident · Serious injuriesClass 3 · LimitedFinal reportHughes 369 · Riverside, CAThe instructor’s delayed remedial action to an excessive descent rate during a simulated autorotation, which resulted in a hard landing.NTSB GAA18CA589Accident · No injuriesData collectionFinal reportPiper PA28R · Camarillo, CAThe flight instructor's improper landing flare, which resulted in a hard landing.NTSB WPR18LA041Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 · Truckee, CAThe flight instructor’s failure to execute a power recovery from a non-stabilized autorotative descent, which resulted in a hard landing.NTSB WPR17LA211Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 · Long Beach, CAThe student pilot's failure to maintain rotor rpm during the crosswind landing approach and his subsequent improper decision to initiate an autorotation instead of applying corrective control inputs after the helicopter experienced normal airframe vibration.…NTSB GAA17CA479Accident · No injuriesData collectionFinal reportCessna 172 · Santa Ana, CAA hard landing and propeller strike for reasons that could not be determined based on the available evidence.NTSB GAA17CA445Accident · No injuriesData collectionFinal reportCessna 170 · San Andreas, CAThe pilot’s improper landing flare during an aborted go-around in gusting wind conditions, which resulted in a hard landing.NTSB GAA17CA354Accident · No injuriesData collectionFinal reportPiper PA28 · Big Bear, CAThe pilot’s improper landing flare, which resulted in a hard landing and a subsequent loss of directional control.NTSB GAA17CA218Accident · No injuriesData collectionFinal reportBell 206 · La Verne, CAThe pilot’s early increased application of the collective during a simulated hovering autorotation, which resulted in a loss of rotor rpm and subsequent main rotor blade strike of the tailboom.NTSB GAA17CA333Accident · No injuriesData collectionFinal reportSwearingen SA227 TT · Santa Monica, CAThe pilot’s unstabilized approach after encountering wake turbulence, which resulted in a hard landing.NTSB GAA17CA048Accident · No injuriesData collectionFinal reportCessna 182 · Palo Alto, CAThe pilot's failure to perform a go-around when he recognized that the airplane was high and fast during the final approach, which resulted in an improper landing flare and a hard landing.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.NTSB GAA16CA511Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB 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.NTSB GAA16CA085Accident · No injuriesData collectionFinal reportKelm David Kitfox 7 · Tracy, CAThe pilot's failure to maintain pitch control during the landing, which resulted in a hard landing, runway excursion and impact with terrain.NTSB GAA15CA248Accident · No injuriesData collectionFinal reportCessna 177B · Los Angeles, CAThe pilot's failure to maintain pitch control during the landing, resulting in a hard landing.NTSB GAA15LA195Accident · Serious injuriesLimited investigationFinal reportKubicek BB100Z · Hidden Valley Lake, CAThe balloon pilot’s deliberate hard landing to avoid power lines and trees, which resulted in serious passenger injuries.NTSB 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.NTSB 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.NTSB WPR15CA093Accident · No injuriesData collectionFinal reportFlight Design Ctls · Hanford, CAThe pilot's inadequate flare, which resulted in a hard landing.NTSB WPR15CA068Accident · No injuriesData collectionFinal reportCessna E162 · Santa Rosa, CAThe student pilot's improper flare which resulted in a hard landing and subsequent nose gear collapse.NTSB WPR14CA379Accident · No injuriesData collectionFinal reportCessna 152 · Santa Rosa, CAThe student pilot's inadequate flare resulted in a hard landing.NTSB WPR14TA357Accident · Minor injuriesFinal reportAirbus Helicopters AS 350 B3 · Hemet, CAThe flight instructor's failure to adequately brief and demonstrate the simulated emergency procedure to the pilot under instruction and his delayed remedial action and inadequate supervision during the maneuver, which resulted in an excessive sink rate and a…NTSB WPR14LA102Accident · No injuriesLimited investigationFinal reportBeech C90 · Columbia, CAThe pilot’s unstabilized night visual approach, which resulted in a hard landing and the collapse of all three landing gear.NTSB WPR14CA074Accident · No injuriesData collectionFinal reportCessna 172M · Fullerton, CAThe pilot's inadequate landing flare, which resulted in a bounced landing.NTSB WPR13LA404Accident · No injuriesLimited investigationFinal reportBell 47G5 · King City, CAThe failure of the helicopter’s center frame tube due to a fatigue crack and corrosion originating from a welded surface. Contributing to the accident was maintenance personnel’s inadequate inspection of the helicopter during its most recent 100-hour…NTSB WPR13LA432Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA 1C · Hemet, CAThe airplane’s hard landing due to the pilot’s failure to maintain sufficient airspeed while on approach after shutting down the engine because of the smoke in the cockpit from a burnt wire that originated from the alternator field terminal and extended to…NTSB 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.NTSB WPR13CA332Accident · No injuriesData collectionFinal reportCessna 172S · Santa Barbra, CAThe pilot's inadequate landing flare, which resulted in a hard landing.