NTSB investigations, CA
513 cases where NTSB found Conditions/weather/phenomena.
Cases per year
| 2008 | 46 |
|---|---|
| 2009 | 44 |
| 2010 | 41 |
| 2011 | 29 |
| 2012 | 33 |
| 2013 | 28 |
| 2014 | 25 |
| 2015 | 32 |
| 2016 | 29 |
| 2017 | 40 |
| 2018 | 20 |
| 2019 | 26 |
| 2020 | 21 |
| 2021 | 25 |
| 2022 | 16 |
| 2023 | 21 |
| 2024 | 15 |
| 2025 | 14 |
| 2026 | 8 |
Where
Latest 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0303'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0303')) 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 WPR26LA239Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · El Cajon, CAThe pilot's failure to maintain directional control during landing with a right crosswind,.NTSB WPR26LA222Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Death Valley, CAThe pilot’s failure to maintain airspeed and encounter with a tailwind while landing on a rough runway, which resulted in a runway overrun and subsequent nose over.NTSB WPR26LA213Accident · Serious injuriesClass 4 · LimitedFinal reportMoose SR 2500 · Sonoma, CAThe pilot's failure to maintain airspeed during a go-around in shifting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB 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 WPR26LA182Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-5 · Jurupa Valley, CAThe pilot’s decision to land at night on a runway without illuminated runway lights. Contributing to the accident was the pilot’s failure to review NOTAMs for a nightly airport closure.NTSB WPR26LA170Accident · No injuriesClass 4 · LimitedFinal reportBalony Kubicek Spol Sro BB100Z · Elk Grove, CAThe pilot’s delayed decision to deflate the balloon during a static display in windy conditions, which resulted in a loss of control and impact with a building. Contributing to the accident was the proximity of the balloon from structures during a static…NTSB WPR26LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Carlsbad, CAThe student pilot’s failure to maintain airplane control while landing in gusting crosswind conditions.NTSB WPR26LA135Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Big Bear, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB WPR26LA066Accident · No injuriesClass 4 · LimitedFinal reportBoeing PT-13D · El Cajon, CAThe pilot's failure to maintain directional control during the landing roll.NTSB ANC25LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Los Banos, CAThe pilot’s failure to maintain directional control during the landing roll with a crosswind, resulting in a ground loop and nose over.NTSB WPR25LA258Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1 · Vacaville, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB WPR25LA185Accident · No injuriesClass 4 · LimitedFinal reportSilvaire Luscombe 8A · San Andreas, CAThe pilot’s loss of directional control during landing roll following an encounter with a dust devil.NTSB WPR25LA175Accident · No injuriesClass 3 · LimitedFinal reportCessna 182P · Hyampom, CAThe pilot’s failure to use carburetor heat, which resulted in a loss of engine power due to carburetor icing and a subsequent impact with terrain during a forced landing.NTSB WPR25LA149Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Mojave, CAThe pilot’s exceedance of the airplane’s critical angle of attack during climb out from an aborted landing.NTSB WPR25LA139Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Oakland, CAThe pilot’s failure to maintain airplane control during takeoff with a left quartering crosswind.NTSB WPR25LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Placerville, CAThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB WPR25LA132Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Oakland, CAThe pilot’s failure to maintain directional control during takeoff roll with a left crosswind.NTSB WPR25LA119Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · San Carlos, CAThe pilot's failure to maintain directional control during landing roll with crosswind conditions.NTSB DCA25LA156Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8 · San Diego, CAAn encounter with an area of moderate clear air turbulence associated with the jet stream during cruise.NTSB DCA25LA126Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Hacienda Heights, CAThe airplane’s encounter with moderate turbulence during descent, which resulted in serious injury to a flight attendant.NTSB WPR25LA092Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Shafter, CAA total loss of engine power due to carburetor ice. Contributing was the student pilot and flight instructors’ failure to utilize carburetor heat.NTSB DCA25LA085Accident · No injuriesClass 4 · LimitedFinal reportBoeing 767 · San Bernardino, CAEncounter with windshear during landing which resulted in a tailstrike.NTSB WPR25LA041Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Palm Springs, CAThe pilot’s failure to maintain clearance from a commercial airliner which resulted in an encounter with wake turbulence and subsequent loss of control resulting in impact with terrain.NTSB WPR25LA037Accident · No injuriesClass 3 · LimitedFinal reportCessna 172I · Los Angeles, CAA partial loss of engine power due to carburetor ice accumulation.NTSB WPR25LA033Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Lancaster, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR24FA290Accident · 1 fatalClass 3 · FieldFinal reportAero Commander 200D · Novato, CAThe pilot’s failure to abort takeoff or compensate for gusty crosswind conditions during takeoff, which resulted in a loss of control and subsequent runway excursion.NTSB WPR24LA251Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Carlsbad, CAThe pilot’s failure to maintain lateral control of the helicopter while departing with a crosswind, which resulted in a dynamic rollover.NTSB WPR24FA195Accident · 2 fatalClass 3 · FieldFinal reportLuscombe 8A · South Lake Tahoe, CAThe pilot’s decision to continue low-altitude flight toward rising mountainous terrain in high density altitude conditions, which resulted in collision with trees and terrain.NTSB WPR24LA189Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Italia S R L Alpha Trainer · Paso Robles, CAThe pilot’s exceedance of the airplane’s critical angle of attack that resulted in an aerodynamic stall and subsequent loss of control on final approach. Contributing to the accident was the pilot’s decision to land with a tailwind.NTSB DCA24LA206Accident · No injuriesClass 3 · LimitedFinal reportBoeing 737-8 · Oakland, CADamage to the standby rudder power control unit connection to the vertical fin due to an extreme high wind event while the airplane was parked, which remained undetected and resulted in anomalous operation of the standby rudder power control unit.…NTSB WPR24LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 172G · Lakeport, CAThe pilot’s inadequate use of carburetor heat, which resulted in a total loss of engine power shortly after takeoff due to fuel starvation as a result of carburetor ice.NTSB WPR24LA145Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Big Bear, CAThe pilot’s failure to maintain directional control during takeoff with a gusty crosswind.NTSB WPR24LA144Accident · No injuriesClass 4 · LimitedFinal reportRans S7 · Hemet, CAThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB WPR24FA124Accident · 1 fatalClass 3 · FieldFinal reportGulfstream 695A · San Bernardino, CAThe pilot’s continued use of the airplane’s autopilot after flight into moderate to severe icing conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB WPR24LA111Accident · Minor injuriesClass 4 · LimitedFinal reportPiper Aerostar 601P · Grass Valley, CAThe pilot’s failure to maintain directional control in a gusting wind condition.NTSB WPR24LA085Accident · Serious injuriesClass 3 · LimitedFinal reportEvektor-Aerotechnik A S Harmony LSA · Santa Ana, CAA loss of airplane control due to wake turbulence resulting from the instructor pilot’s decision to continue the landing into a drifting wake vortex.NTSB CEN24MA111Accident · 6 fatalClass 2 · MajorFinal reportAirbus Helicopters EC 130 · Halloran Springs, CAThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the company’s inadequate oversight of its…NTSB WPR24LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Modesto, CAThe failure of the pilot to maintain directional control of the airplane during landing, which resulted in a nose over.NTSB WPR24FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna P210N · San Diego, CAA total loss of engine power due to fuel exhaustion. Contributing to the accident were the pilot’s inadequate flight and fuel planning and his decision to fly in night instrument meteorological conditions despite his lack of recent instrument flight.NTSB 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.NTSB WPR23LA338Accident · Serious injuriesClass 3 · LimitedFinal reportBell 212 · Balch Camp, CAThe pilot’s inadequate performance planning for the operation that resulted in an excessive gross weight for the operating conditions, leading to a loss of altitude during maneuvering and contact with trees. Contributing to the accident was the pilot’s…NTSB WPR23LA322Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5B · Lone Pine, CAThe pilot's inability to maintain altitude after encountering a downdraft, which resulted in collision with terrain.NTSB WPR23LA363Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Needles, CAAn encounter with windshear during the initial climb after takeoff, resulting in a loss of control and a subsequent hard landing.NTSB WPR23FA258Accident · 1 fatalClass 3 · FieldFinal reportCessna 172N · San Rafael, CAThe total loss of engine power due to carburetor icing as a result of the pilot’s failure to activate the carburetor heat in a timely manner during the descent.NTSB WPR23FA257Accident · 6 fatalClass 3 · FieldFinal reportCessna 550 · Murrieta, CAThe flight crew’s decision to descend below the decision altitude of an instrument approach without having the appropriate runway visual reference(s) distinctively identified and with the visibility below the minimum that was prescribed for the approach,…NTSB WPR23LA245Accident · No injuriesClass 4 · LimitedFinal reportSchleicher Alexander ASH 26 E · Williams, CAThe pilot’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in a collision with terrain.NTSB 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.NTSB WPR23LA202Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M-18C 55 · Napa, CAThe pilot’s failure to use carburetor heat, which resulted in a loss of engine power due to carburetor icing and a subsequent impact with terrain during a forced landing.NTSB WPR23LA200Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B3 · San Diego, CAThe pilot’s failure to maintain altitude during a hover taxi due to distraction resulting from the unanticipated activation of strobing lights while using night vision googles.NTSB 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.