Ongoing NTSB investigations, CA
16 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2024 | 1 |
|---|---|
| 2025 | 6 |
| 2026 | 9 |
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\" = '341' 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" = '341' 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 WPR27LA019Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 177A · San Jose, CAOn October 17, 2026, at 1508 Pacific daylight time, a Cessna 177A, N30544, was substantially damaged when it was involved in an accident near San Jose, California. The pilot and one passenger sustained minor injuries. One passenger was seriously injured. The…NTSB WPR26LA359Accident · Minor injuriesClass 4 · LimitedInvestigation openHawker Hawker Hunter MK.58 · Morro Bay, CANTSB WPR26LA324Accident · No injuriesClass 3 · LimitedPreliminary reportZenith CH701 · Byron, CAOn August 30, 2026, about 0905 Pacific daylight time, an experimental amateur-built Zenith CH701, N701WJ, was substantially damaged when it was involved in an accident at Byron Airport (C83), Byron, California. The pilot was not injured. The airplane was…NTSB WPR26LA291Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 177B · Perris, CAOn August 5, 2026, at 1117 mountain daylight time, a Cessna 177B, N34852, was substantially damaged when it was involved in an accident near Perris, California. The flight instructor and student pilot were not injured. The airplane was being operated as a…NTSB WPR26LA251Accident · No injuriesClass 3 · LimitedPreliminary reportLuscombe 8A · Novato, CAOn July 7, 2026, about 1200 Pacific daylight time, a Luscombe 8A, N45886, was substantially damaged when it was involved in an accident near Novato, California. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA237Accident · Serious injuriesClass 3 · LimitedPreliminary reportAutogyro MT03 · San Jose, CAOn June 29, 2026, about 1148 Pacific daylight Time, a MTO Sport gyroplane, N423AG, was substantially damaged when it was involved in an accident at Reid-Hillview Airport (RHV), San Jose, California. The pilot was seriously injured, and the passenger received…NTSB WPR26LA204Accident · Minor injuriesClass 3 · LimitedPreliminary reportAir Tractor AT-602 · Robbins, CAOn May 30, 2026, about 0900 Pacific daylight time, an Air Tractor AT-602, N5111A, was substantially damaged when it was involved in an accident near Robbins, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB WPR26LA158Accident · Minor injuriesClass 3 · LimitedPreliminary reportAlexander Schleicher ASH 31 MI · Williams, CAOn April 13, 2026, about 1051 Pacific standard time, an experimental Alexander Schleicher GMBH and Co., Ash 31 Mi Glider, N77UK, was substantially damaged when it was involved in an accident near Williams, California. The pilot sustained minor injuries. The…NTSB WPR26FA103Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 210B · Camarillo, CAOn February 15, 2026, about 1805 Pacific standard time, a Cessna 210B, N9735X, was substantially damaged when it was involved in an accident near Camarillo, California. The pilot was fatally injured and the passenger sustained serious injuries. The airplane…NTSB WPR26LA037Accident · No injuriesClass 3 · LimitedPreliminary reportGrumman American Avn. AA-5B · Santa Ynez, CAOn October 29, 2025, about 1820 Pacific daylight time, a Grumman American AA-5B, N74323, was substantially damaged when it was involved in an accident near Santa Ynez, California. The commercial pilot was not injured. The airplane was operated as a Title 14…NTSB WPR26LA034Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28R-200 · La Verne, CAOn October 28, 2025, about 1845 Pacific daylight time, a Piper Arrow PA-28R-200, N5107S, sustained substantial damage when it was involved in an accident near Upland, California. The pilot and passenger were not injured. The airplane was operated as a Title…NTSB WPR26LA030Accident · Serious injuriesClass 3 · LimitedPreliminary reportRutan Long-EZ · Long Beach, CAOn October 20, 2025, about 1603 Pacific daylight time, an experimental amateur-built Rutan Long-EZ, N8183K, was substantially damaged when it was involved in an accident in Long Beach, California. The pilot was seriously injured, and a pedestrian on the…NTSB WPR25LA188Accident · Minor injuriesClass 3 · LimitedPreliminary reportFilby Gerry RV-9 · Morgan Hill, CAOn June 23, 2025, about 1217 Pacific daylight time, an experimental amateur-built Vans Aircraft Inc RV-9 airplane, N696WG, was substantially damaged when it was involved in an accident near Morgan Hill, California. The pilot sustained minor injuries. The…NTSB WPR25LA174Accident · Serious injuriesClass 3 · LimitedPreliminary reportQuitter John F MXL II · Acampo, CAOn June 14, 2025, about 1511 Pacific daylight time, an experimental MXL II, N375ME, was substantially damaged when it was involved in an accident near Acampo, California. The pilot was uninjured, and the passenger was seriously injured. The airplane was…NTSB WPR25LA171Accident · Minor injuriesClass 3 · LimitedPreliminary reportYakovlev YAK-50 · Hayward, CAOn June 7, 2025, about 1252 Pacific daylight time, a Yakovlev YAK-50, N150YK, was substantially damaged when it was involved in an accident near Hayward, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25LA055Accident · No injuriesClass 3 · LimitedPreliminary reportVans RV14 · Palmdale, CAOn December 15, 2024, about 1303 pacific standard time, an experimental amateur built Vans RV-14, N144SD, was substantially damaged when it was involved in an accident near Palmdale, California. The pilot was not injured. The airplane was operated as a Title…