NTSB investigations, CA
863 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 69 |
|---|---|
| 2009 | 71 |
| 2010 | 68 |
| 2011 | 56 |
| 2012 | 62 |
| 2013 | 54 |
| 2014 | 53 |
| 2015 | 51 |
| 2016 | 64 |
| 2017 | 68 |
| 2018 | 59 |
| 2019 | 41 |
| 2020 | 33 |
| 2021 | 20 |
| 2022 | 30 |
| 2023 | 24 |
| 2024 | 18 |
| 2025 | 9 |
| 2026 | 13 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' 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.
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" = '470' 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
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 WPR26FA346Accident · 2 fatalClass 3 · FieldPreliminary reportAirbus AS332 · Yosemite Valley, CAOn September 20, 2026, at 1356 Pacific daylight time, an Airbus AS332 L1 Super Puma, N332N, was destroyed when it was involved in an accident near Yosemite Valley, California. The two pilots were fatally injured. The helicopter was operated as a public use…NTSB WPR26LA349Accident · Minor injuriesClass 4 · LimitedInvestigation openCameron Balloons US A-400 · Angwin, CANTSB WPR26FA345Accident · 3 fatalClass 3 · FieldPreliminary reportEurocopter AS 350 B2 · Chatsworth, CAOn September 15, 2026, about 1855 Pacific daylight time, an Airbus Helicopters (formerly Eurocopter) AS-350 B2 helicopter, N358TV, was destroyed when it was involved in an accident near Chatsworth, California. The pilot, passenger and one person on the ground…NTSB WPR26LA322Accident · Serious injuriesClass 4 · LimitedInvestigation openKrugh Patrick M Steen Skybolt · Big Bear, CANTSB WPR26LA303Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172L · Upland, CANTSB WPR26LA268Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-18 · Colusa, CAThe pilot's inadequate fuel planning and in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR26FA262Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-4 · Yuba City, CAOn July 16, 2026, at 0701 Pacific daylight time, an experimental amateur built Vans RV-4, N98GB, was substantially damaged when it was involved in an accident near Yuba City, California. The pilot was fatally injured. The airplane was operated as a Title 14…NTSB WPR26LA263Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-27 · Montague, CAThe pilot’s inability to see and avoid a piece of loose wire in a field during an off-airport landing in a glider, which resulted in a ground loop. Contributing to the accident was the pilot’s inability to maintain a safe position behind the tow airplane…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 WPR26LA207Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-2 · Mettler, CAThe pilot's failure to ensure the loading hose had been disconnected before takeoff, which resulted in an interrupted takeoff and subsequent loss of control. Contributing to the accident was the ground loader's failure to disconnect the hose before…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 WPR26LA164Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172S · Pacoima, CAOn April 20, 2026, about 1107 Pacific daylight time, a Cessna 172S airplane, N2126F, sustained substantial damage when it was involved in an accident near Whiteman Airport (WHP), Pacoima, California. The pilot was seriously injured. The airplane was operated…NTSB WPR26FA109Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-22-150 · Oroville, CAOn February 28, 2026, about 0948 Pacific standard time, a Piper PA-22-150, N3170Z, was destroyed when it was involved in an accident near Oroville, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB WPR26FA069Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-32-260 · Rio Linda, CAOn December 24, 2025, at approximately 1230 Pacific standard time, a Piper PA-32-260, N2785Q, was substantially damaged when it was involved in an accident near Rio Linda, California. The pilot sustained serious injuries, and the pilot-rated passenger was…NTSB WPR26LA071Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Lake Elsinore, CAThe pilot’s intentional deployment of the airframe parachute system due to task-saturation in instrument meteorological conditions.NTSB WPR25FA277Accident · 1 fatalClass 3 · FieldPreliminary reportLawson Thomas O Lancair Super ES · Mount Hamilton, CAOn September 12, 2025, about 1421 Pacific daylight time, an experimental amateur-built Lancair Super ES, N905ET, was destroyed when it was involved in an accident near Mount Hamilton, California. The pilot was fatally injured. The airplane was operated as a…NTSB WPR25LA275Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Hollister, CAThe pilot’s delayed go-around from an unstabilized approach that resulted in an impact with terrain.NTSB WPR25FA257Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 140 · Shelter Cove, CAOn August 17, 2025 about 1521 Pacific daylight time, a Cessna 140, N89447, was involved in an accident near Shelter Cove, California. The student pilot was fatally injured, and the passenger sustained serious injuries. The airplane was operated as a Title 14…NTSB WPR25LA192Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASH 30 MI · Santa Barbara, CAThe pilot’s failure to maintain taxiway centerline while taxiing off the runway which resulted in a left-wing strike with a runway direction sign.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 WPR25LA141Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8 · Placerville, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR25LA078Accident · No injuriesClass 4 · LimitedFinal reportBell 206A · Lemoore, CAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.NTSB WPR25LA059Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · El Cajon, CAThe pilot’s inability to maintain directional control during landing with a flat tire.NTSB WPR25LA005Accident · Serious injuriesClass 4 · LimitedFinal reportRotorsport Cavalon · Chico, CAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent descent and subsequent collision with trees.NTSB WPR24LA316Accident · No injuriesClass 3 · LimitedFinal reportAviat A-1A · Taft, CAThe pilot receiving instruction’s failure to maintain directional control during landing roll and the flight instructor’s delayed remedial action.NTSB WPR24FA309Accident · 1 fatalClass 3 · FieldFinal reportNanchang China CJ-6A · Lancaster, CAThe CJ-6A pilot’s failure to maintain separation and the Yak pilot’s failure to monitor the other airplane during a detachment, which resulted in a midair collision.NTSB WPR24FA295Accident · Serious injuriesClass 3 · FieldPreliminary reportPiper PA-24-250 · Hawthorne, CAOn September 6, 2024, at 0036 Pacific daylight time, a Piper PA-24-250, N588CP, was destroyed when it was involved in an accident near Hawthorne, California. The pilot and pilot rated passenger sustained serious injuries. The airplane was operated as a Title…NTSB WPR24FA252Accident · 2 fatalClass 3 · FieldFinal reportTextron T206H · Kneeland, CAThe pilot’s delayed decision to perform a go-around after an unstabilized approach, which resulted in a loss of control, runway overrun, and impact with terrain.NTSB WPR24LA219Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Oxnard, CAThe student pilot’s failure to maintain directional control during the takeoff roll.NTSB WPR24LA218Accident · Minor injuriesClass 3 · LimitedFinal reportTL Ultralight Sting RG · Rio Linda, CAA loss of engine power due to fuel exhaustion. Contributing to the accident was a fuel quantity indication that was inconsistent with the actual fuel state of the airplane, which likely led the pilot to overestimate the amount of fuel remaining onboard.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 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 WPR24FA119Accident · 2 fatalClass 3 · FieldPreliminary reportDaher TBM700 · Truckee, CAOn March 30, 2024, at 1837 Pacific daylight time, a Daher TBM 700 (960), N960LP, was substantially damaged when it was involved in an accident in Truckee, California. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code…NTSB WPR24LA117Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Acton, CAThe pilots inability to fully turn off the carburetor heat which resulted in a reduction of engine power and reduced climb performance. Contributing to the accident was the pilots delayed recovery from the simulated emergency landing.NTSB WPR24LA114Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · Farmington, CAThe pilot’s improper preflight fuel planning that resulted in the loss of engine power due to fuel exhaustion.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 WPR24LA081Accident · Serious injuriesClass 3 · LimitedFinal reportChristopher Randall Raptor Junior 540 · Camarillo, CAA total loss of engine power due to the loss of power to the electronic fuel injection and ignition system, which was the result of a loose connection between a common ground feed-through stud and the ground bus.NTSB WPR24FA073Accident · 4 fatalClass 3 · FieldFinal reportOstroth Thane L Cozy MK IV · Half Moon Bay, CAThe airplane’s impact with the ocean for undetermined reasons after departing into night, instrument meteorological conditions.NTSB WPR24LA046Accident · Serious injuriesClass 3 · LimitedFinal reportCessna P210N · Big Bear, CAA loss of engine power during the initial climb for undetermined reasons, which resulted in an aborted takeoff and runway excursion.NTSB 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.NTSB WPR23LA357Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Redding, CAThe student pilot’s loss of airplane control during takeoff, which resulted in a bounced landing and impact with the airport’s windsock.NTSB WPR23LA349Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Compton, CAThe total loss of engine power on takeoff due to water-contaminated fuel. Contributing to the accident was the inadequately maintained fuel system, which resulted in water entering the fuel tanks through the filler caps.NTSB WPR23LA341Accident · No injuriesClass 3 · LimitedFinal reportBellanca 7ECA · El Cajon, CAA total loss of engine power for undetermined reasons.NTSB WPR23LA336Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-18-135 · Compton, CAAn overstress fracture of the pilot’s seat, which resulted in the loss of control during takeoff and the pilot’s inadvertent movement of the fuel selector and subsequent partial loss of engine power.NTSB WPR23LA313Accident · Minor injuriesClass 3 · LimitedFinal reportBell OH-58A · Guernsey, CAThe pilot’s overpitching of the main rotor blades while maneuvering at low altitude in a high-temperature environment at high gross weight, which resulted in a reduction of engine and rotor speed, excessive main rotor blade flapping, mast bumping, and impact…NTSB WPR23LA305Accident · 1 fatalClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Davis, CAAn inflight loss of control during a low altitude operation for undetermined reasons.NTSB WPR23LA270Accident · No injuriesClass 3 · LimitedFinal reportSling Sling LSA · Palm Springs, CAFailure of the landing gear strut during takeoff due to a preexisting cracks that were caused by a manufacturing anomaly during the composite fiber layup process.NTSB WPR23LA274Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Long Beach, CAThe student pilot’s failure to maintain directional control during landing and the subsequent go-around, which resulted in impact with a hangar.