Ongoing NTSB investigations, CA
13 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2024 | 2 |
|---|---|
| 2025 | 3 |
| 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.\"completionStatus\" = 'Ongoing'
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."completionStatus" = 'Ongoing' 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 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 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 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 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 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 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…