NTSB investigations, CA
73 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2009 | 2 |
|---|---|
| 2011 | 2 |
| 2012 | 4 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 8 |
| 2020 | 2 |
| 2021 | 3 |
| 2022 | 7 |
| 2023 | 8 |
| 2024 | 7 |
| 2025 | 11 |
| 2026 | 8 |
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\" = '000' 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" = '000' 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 WPR26FA363Accident · 3 fatalClass 3 · FieldPreliminary reportEurocopter Deutschland EC 135 P2+ · Avalon, CAOn September 30, 2026, about 1946 Pacific daylight time, a Eurocopter Deutschland GMBH EC-135 P2+, N313RX, was substantially damaged when it was involved in an accident near Avalon, California. The pilot, flight nurse, and patient were fatally injured; the…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 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 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 ANC26FA039Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 182T · Armistead, CAOn May 7, 2026, about 1055 pacific daylight time (PDT), a Cessna 182T airplane, N227TF, was destroyed when it was involved in an accident near Armistead, California. The flight instructor and the pilot receiving instruction were fatally injured. The airplane…NTSB ANC26FA024Accident · 2 fatalClass 3 · FieldPreliminary reportAirplane Factory Ltd The Sling · Avalon, CAOn April 09, 2026, about 1224 Pacific daylight time, an Airplane Factory (Pty) Ltd. Sling 2 airplane, N166TW, was substantially damaged when it was involved in an accident near Avalon, California. The pilot and pilot-rated passenger were fatally injured. The…NTSB WPR26FA130Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · Olympic Valley, CAOn March 22, 2026, at 1716 Pacific daylight time, a Beech A36, N2882W, was substantially damaged when it was involved in an accident near Olympic Valley, California. The pilot was fatally injured. The airplane was operated as a Title14 Code of Federal…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 WPR26FA043Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 172M · Poleta, CAOn November 10, 2025, at about 1515 Pacific standard time, Cessna 172M, N13221, was substantially damaged when it was involved in an accident near Poleta, California. A pilot-rated passenger and a passenger were fatally injured, and the pilot was seriously…NTSB WPR26FA008Accident · 1 fatalClass 3 · FieldPreliminary reportAirbus Helicopters EC 130 T2 · Sacramento, CAOn October 6, 2025, about 1905 Pacific daylight time, an Airbus Helicopters EC-130 T2, N414RX, was substantially damaged when it was involved in an accident in Sacramento, California. The pilot and flight paramedic sustained serious injuries; the flight nurse…NTSB WPR25FA264Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172S · Los Banos, CAOn August 26, 2025, about 1905 Pacific daylight time, a Cessna 172S, N5203H, was destroyed when it was involved in an accident near Los Banos, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB OPS25LA048Incident · No injuriesClass 3 · LimitedPreliminary reportEmbraer ERJ 170-200 LR · Monterey, CAOn July 15, 2025, about 0005 Pacific Daylight Time (PDT), SkyWest Airlines (SKW) flight 3005, an Embraer 170-200LR, N185SY, conducted a pilot-initiated go-around approximately 4 miles from the threshold of runway 10R at Monterey Regional Airport (MRY),…NTSB WPR25FA208Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-28-180 · Needles, CAOn July 13, 2025, about 2128 Pacific daylight time, a Piper PA-28-180, N8375W, was substantially damaged when it was involved in an accident near Needles, California. Both pilots sustained fatal injuries. The airplane was operated as a Title 14 Code of…NTSB WPR25LA212Accident · 1 fatalClass 4 · LimitedFinal reportCessna T240 · San Diego, CAImpact with the ocean for reasons that could not be determined because the pilot and airplane were not located.NTSB WPR25FA169Accident · 6 fatalClass 3 · FieldPreliminary reportCessna 414 · San Diego, CAOn June 08, 2025, at 1230 Pacific daylight time, a Cessna 414A, N414BA, was substantially damaged when it was involved in an accident in San Diego, California. The pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB WPR25FA161Accident · 6 fatalClass 3 · FieldPreliminary reportCessna S550 · San Diego, CAOn May 22, 2025, at 0347 Pacific daylight time (PDT), a Cessna Citation S550, N666DS, was destroyed when it was involved in an accident near San Diego, California. The pilot and five passengers were fatally injured. Eight people on the ground received minor…NTSB WPR25LA085Accident · Serious injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22T · Santa Barbara, CAOn January 29, 2025, about 1417 Pacific standard time, a Cirrus Design Corp SR22T, N124LZ, was destroyed when it was involved in an accident near Santa Barbara, California. The two pilots were seriously injured. The airplane was operated as a Title 14 Code of…NTSB WPR25LA082Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172K · Columbia, CAA partial loss of engine power for undetermined reasons.NTSB WPR25FA072Accident · 2 fatalClass 3 · FieldPreliminary reportVans RV-10 · Fullerton, CAOn January 2, 2025, about 1409 Pacific standard time, an experimental amateur built Vans Aircraft RV-10, N8757R, was destroyed when it was involved in an accident near Fullerton, California. The pilot and passenger were fatally injured, and there were 19…NTSB WPR25LA039Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32-300 · Pomona, CAA total loss of engine power during final approach for reasons that could not be determined.NTSB WPR25FA007Accident · 5 fatalClass 3 · FieldPreliminary reportBeech 95-B55 · Avalon, CAOn October 8, 2024, at 2005 Pacific daylight time, a Beech 95-B55, N73WA, was destroyed when it was involved in an accident near Avalon, California. The pilot, two pilot rated passengers, and two student pilot passengers were fatally injured. The airplane was…NTSB WPR24FA287Accident · Serious injuriesClass 3 · FieldFinal reportPitts S1 · Santa Paula, CAThe total loss of engine power at low altitude for reasons that could not be determined.NTSB WPR24LA269Accident · No injuriesClass 3 · LimitedFinal reportProtech PT2 · Lodi, CAA reported loss of engine power for reasons that could not be determined.NTSB WPR24LA193Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Monument Hills, CAA total loss of engine power for reasons that could not be determined.NTSB WPR24LA160Accident · Minor injuriesClass 3 · LimitedFinal reportSteen Skybolt · Santa Maria, CAA total loss of engine power during approach for reasons that could not be determined.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 WPR24LA023Accident · No injuriesClass 3 · LimitedFinal reportVans RV-12 · Novato, CAA partial loss of engine power during initial climb for undetermined reasons.NTSB WPR23LA341Accident · No injuriesClass 3 · LimitedFinal reportBellanca 7ECA · El Cajon, CAA total loss of engine power for undetermined reasons.NTSB WPR23LA264Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A185F · La Mesa, CAA total loss of engine power for undetermined reasons.NTSB WPR23LA249Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Meeks Bay, CAA loss of engine power for reasons that could not be determined based on the available information.NTSB WPR23FA185Accident · 3 fatalClass 3 · FieldFinal reportGates Lear Jet 36A · San Clemente Island, CAThe pilots’ loss of airplane control following a catastrophic fire that started on the left side of the aft equipment bay (tail cone). The fire likely initiated from a leak from the left fuel motive flow line due to a b-nut that loosened for reasons that…NTSB WPR23LA121Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · San Andreas, CAA loss of engine power for undetermined reasons.NTSB WPR23LA098Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210N · Murrieta, CAA loss of engine power during the turn from base to final for undetermined reasons. Contributing to the accident was the pilot’s decision to not maintain traffic pattern altitude, which resulted in the off-airport landing.NTSB WPR23FA007Accident · 1 fatalClass 3 · FieldFinal reportCornford Craig H Mustang II · Jamul, CAImpact with mountainous terrain for undetermined reasons due to the limited evidence that could be collected from the accident sceneNTSB CEN22FA375Accident · 1 fatalClass 3 · FieldFinal reportSonex Waiex · Maxwell, CAA loss of control in flight for undetermined reasons that resulted in an impact with terrain.NTSB WPR22LA242Accident · No injuriesClass 3 · LimitedFinal reportCessna 120 · San Carlos, CAThe total loss of engine power for undetermined reasons.NTSB WPR22LA221Accident · No injuriesClass 3 · LimitedFinal reportBell 206B · Stockton, CATail rotor blade impact with an unidentified object, which resulted in the loss of control and subsequent rollover of the helicopter.NTSB WPR22LA192Accident · 1 fatalClass 3 · LimitedFinal reportMaule MX-7-180C · Willits, CAAn uncommanded descent during a go-around maneuver for undetermined reasons.NTSB WPR22LA099Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Napa, CAThe loss of engine power for undetermined reasons, which resulted in an off-airport landing on unimproved terrain.NTSB ANC22LA014Accident · No injuriesClass 3 · LimitedFinal reportBell 205A-1 · El Cajon, CAA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR22LA062Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Temecula, CAThe total loss of engine power for reasons that could not be determined from the available evidence.NTSB WPR21LA326Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Del Mar, CAThe partial loss of engine power for reasons that could not be determined, which resulted in a forced landing on an interstate highway and subsequent collision with vehicles.NTSB WPR21LA299Accident · No injuriesClass 3 · LimitedFinal reportSchweizer G-164B · Tracy, CAA loss of thrust during a low-level agricultural application flight, which resulted in a descent and impact with terrain. The reason for the loss of thrust could not be determined based on available information.NTSB WPR20LA320Accident · Serious injuriesClass 3 · LimitedFinal reportGreat Lakes 2T1A · San Diego, CAA loss of engine power for reasons that could not be determined, which resulted in a hard landing off airport.NTSB WPR20LA225Accident · No injuriesClass 3 · LimitedFinal reportVans RV 8 · Grimes, CAA partial loss of engine power for reasons that could not be determined because the airplane was not examined.NTSB WPR20FAMS1Accident · 2 fatalClass 3 · Missing aircraftFinal reportPiper PA28R · Shelter Cove, CAUndetermined due to lack of available evidence.NTSB WPR19LA267Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Modesto, CAA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR19LA228Accident · Serious injuriesClass 3 · LimitedFinal reportHead AX9-118 · Galt, CAA loss of control following an adverse wind encounter.NTSB WPR19FA188Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Hayward, CAThe pilots’ loss of control during a low altitude maneuver for undetermined reasons, which resulted in impact with terrain.