NTSB investigations, CA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 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 WPR26LA213Accident · Serious injuriesClass 4 · LimitedFinal reportMoose SR 2500 · Sonoma, CAThe pilot's failure to maintain airspeed during a go-around in shifting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB WPR26FA198Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20J · Woodlake, CAOn May 23, 2026, about 1034 Pacific daylight time, a Mooney M20J, N4452H, was destroyed when it was involved in an accident near Woodlake, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations part 91…NTSB WPR26LA194Accident · Minor injuriesClass 4 · LimitedFinal reportAutogyro Cavalon · Palo Alto, CAThe pilot’s failure to maintain directional control during the landing roll, in gusting crosswind conditions.NTSB WPR26LA182Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-5 · Jurupa Valley, CAThe pilot’s decision to land at night on a runway without illuminated runway lights. Contributing to the accident was the pilot’s failure to review NOTAMs for a nightly airport closure.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 WPR26LA170Accident · No injuriesClass 4 · LimitedFinal reportBalony Kubicek Spol Sro BB100Z · Elk Grove, CAThe pilot’s delayed decision to deflate the balloon during a static display in windy conditions, which resulted in a loss of control and impact with a building. Contributing to the accident was the proximity of the balloon from structures during a static…NTSB WPR26LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Redding, CAThe pilot’s failure to extend the landing gear before landing due to distraction and his failure to conduct the before landing checklist.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 WPR26LA173Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Salinas, CAThe flight instructor’s inadequate preflight inspection which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR26LA159Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fullerton, CAThe pilot’s loss of control during takeoff, due to the seat sliding aft.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 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 WPR26LA143Accident · No injuriesClass 4 · LimitedFinal reportPaul D Cannon Kitfox Light Squared · Lincoln, CAThe pilot's failure to properly flare the airplane during landing, which resulted in a hard landing and separation of the main landing gear. Contributing to the accident was the improper installation and over torquing of the landing gear attachment hardware,…NTSB WPR26LA144Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Los Angeles, CAThe pilot’s failure to maintain adequate clearance from a jet blast fence during taxi.NTSB WPR26LA148Accident · No injuriesClass 4 · LimitedFinal reportQuicksilver GT-400 · Chula Vista, CAThe pilot’s improper landing flare, which resulted in a bounced landing and a subsequent runway excursion.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 WPR26LA135Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Big Bear, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB WPR26LA124Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210 · Upland, CAThe pilot’s improper approach, which resulted in a long landing, runway excursion, and a nose over.NTSB WPR26FA121Accident · 1 fatalClass 3 · FieldPreliminary reportMD Helicopters 369FF · Mojave, CAOn March 9, 2026, about 1517 Pacific daylight time, an MD Helicopters 369FF, N530XX, was destroyed when it was involved in an accident near Mojave, California. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…NTSB WPR26LA115Accident · No injuriesClass 4 · LimitedFinal reportMightyfly MF-100 · Atwater, CAA control system anomaly, which resulted in the overload and failure of one of the propulsion motor systems during the transition from hover to forward flight.NTSB DCA26LA184Incident · No injuriesClass 3 · LimitedPreliminary reportBoeing 787-9 · Los Angeles, CAOn March 2, 2026, at 1100 Pacific Standard Time, United Airlines flight 2127, a Boeing 787-9, registration N24972, powered by two General Electric GEnx™-1B76A/P2 turbofan engines, experienced a No. 1 (left) engine surge during climb from Los Angeles…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 WPR26LA107Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-30 · Big Bear, CAOn February 23, 2026, at 1800 Pacific standard time, a Piper PA-30, N811LE, was substantially damaged when it was involved in an accident near Big Bear, California. The pilot and passenger were not injured. The airplane was operated as a 14 Code of Federal…NTSB WPR26LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Kneeland, CAThe pilot’s failure to maintain airplane control during landing roll on a snow-covered runway.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 DCA26LA115Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321-271NX · San Francisco, CAThe first officer’s excessive aft sidestick input combined with decaying airspeed during initiation of a go-around, resulting in an increase in the airplane pitch attitude and subsequent lower fuselage contacting the runway.NTSB DCA26LA097Accident · No injuriesClass 4 · LimitedFinal reportBoeing 767 · San Bernardino, CAThe flight crew’s improper derotation which resulted in a hard nose gear touchdown. Contributing to the accident was the captain and first officer’s lack of crew resource management related to communication about pitch control inputs. Contributing to the…NTSB WPR26LA073Accident · No injuriesClass 3 · LimitedPreliminary reportEvektor - Aerotechnik A S Sportstar MAX · Needles, CAOn December 27, 2025, about 1109 Pacific standard time, an Evektor-Aerotechnik AS Sportstar Max LSA airplane, N2312T, was substantially damaged when it was involved in an accident near Needles, California. The pilot and pilot rated passenger were not injured.…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 WPR26LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Temecula, CAThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR26LA066Accident · No injuriesClass 4 · LimitedFinal reportBoeing PT-13D · El Cajon, CAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR26LA060Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeechcraft G36 · Tracy, CAOn December 15, 2025, about 1526 Pacific standard time, a Beechcraft G36, N360FV, was substantially damaged when it was involved in an accident near Tracy, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA044Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Fresno, CAThe pilot's improper application of left brake pedal during the landing roll, which resulted in a loss of directional control and a ground loop.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 WPR26LA047Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172S · Lancaster, CAOn November 9, 2025, about 1205 Pacific daylight time, a Cessna 172S, N5199J, sustained substantial damage when it was involved in an accident near Lancaster, California. The pilot and passengers were not injured. The airplane was operated as a Title 14 Code…NTSB WPR26LA038Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182P · San Andreas, CAThe pilot’s decision to adjust his seat during the takeoff roll, which resulted in the seat sliding aft and a subsequent loss of directional control.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 WPR26LA023Accident · Minor injuriesClass 4 · LimitedFinal reportHawker Hawker Hunter MK.58 · Big Sur, CAA complete loss of engine power for reasons that could not be determined.NTSB CEN26FA015Accident · Serious injuriesClass 3 · FieldPreliminary reportBell 222 · Huntington Beach, CAOn October 11, 2025, at 1401 Pacific daylight time, a Bell 222 helicopter, N222EX, was substantially damaged when it was involved in an accident near Huntington Beach, California. The pilot and passenger received serious injuries. One person on the ground…NTSB WPR26LA009Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Watsonville, CAThe pilot’s decision to program avionics during taxi, resulting in an inadvertent throttle input and collision with a hangar.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 WPR26LA015Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Lathrop, CAAn inflight collision with a bird.NTSB WPR25LA304Accident · No injuriesClass 4 · LimitedFinal reportCessna 182A · Avalon, CAThe pilot’s decision to land with a tailwind and a downslope to the runway.NTSB ANC25LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Los Banos, CAThe pilot’s failure to maintain directional control during the landing roll with a crosswind, resulting in a ground loop and nose over.NTSB WPR25LA292Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182N · Fallbrook, CAOn September 23, 2025, about 1400 Pacific daylight time, N766EE, a Cessna 182N, was substantially damaged when it was involved in an accident near Fallbrook, California. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…