NTSB investigations, CA
5 cases where the sequence of events included Security/criminal event.
Cases per year
| 2021 | 2 |
|---|---|
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 1 |
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\" = '350' 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" = '350' 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 WPR26LA287Occurrence · 1 fatalClass 3 · LimitedPreliminary reportCameron Balloons A-315 · Menifee, CAOn August 2, 2026, about 0710 Pacific daylight time, a Cameron Balloons A-315, N315U, was not damaged when it was involved in an accident near Menifee, California. The pilot and one passenger were not injured, and one passenger was fatally injured. The…NTSB WPR25LA077Incident · No injuriesClass 4 · LimitedFinal reportBombardier Inc., Canadair CL-215-6B11 · Los Angeles, CAThe NTSB did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of Investigation.NTSB WPR24LA142Accident · 1 fatalClass 3 · LimitedFinal reportUltramagic Z-90 · Del Mar, CAThe passenger’s intentional departure from the balloon in flight as an act of suicide.NTSB WPR22LA049Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft BL-65 · New Cuyama, CAThe pilot’s decision to intentionally crash the airplane.NTSB WPR21LA366Accident · No injuriesClass 4 · LimitedFinal reportSharp Ralph R Zenith Stol CH 701 · Bishop, CAA loss of airplane control for undetermined reasons.