NTSB investigations, CA
106 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 8 |
| 2010 | 5 |
| 2011 | 8 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 4 |
| 2015 | 1 |
| 2016 | 13 |
| 2017 | 10 |
| 2018 | 13 |
| 2019 | 10 |
| 2020 | 7 |
| 2022 | 1 |
| 2023 | 5 |
| 2025 | 3 |
| 2026 | 4 |
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\" = '900' 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" = '900' 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 WPR26LA322Accident · Serious injuriesClass 4 · LimitedInvestigation openKrugh Patrick M Steen Skybolt · Big Bear, CANTSB WPR26LA207Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-2 · Mettler, CAThe pilot's failure to ensure the loading hose had been disconnected before takeoff, which resulted in an interrupted takeoff and subsequent loss of control. Contributing to the accident was the ground loader's failure to disconnect the hose before…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 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 WPR25LA275Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Hollister, CAThe pilot’s delayed go-around from an unstabilized approach that resulted in an impact with terrain.NTSB WPR25LA192Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASH 30 MI · Santa Barbara, CAThe pilot’s failure to maintain taxiway centerline while taxiing off the runway which resulted in a left-wing strike with a runway direction sign.NTSB WPR25LA112Accident · Serious injuriesClass 4 · LimitedFinal reportEnstrom 280FX · Waterford, CAThe pilot’s failure to maintain clearance from water while operating at a low altitude.NTSB WPR23LA217Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Bakersfield, CAThe pilot’s improper use of flaps during the takeoff sequence which resulted in a runway overrun and collision with trees.NTSB WPR23LA212Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Colusa, CAThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight. Contributing to the accident was the pilot’s fatigue.NTSB WPR23LA128Accident · Serious injuriesClass 3 · LimitedFinal reportJones Jay D Cassutt M 11 · Castroville, CAA failure of the outboard trailing edge rib in the left wing, which resulted in a separation of the left aileron and a loss of control.NTSB WPR23FA092Accident · 1 fatalClass 3 · FieldFinal reportCessna 414 · Modesto, CAThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain proper airspeed during a turn to final, resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s distraction…NTSB WPR23LA091Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · San Diego, CAThe flight instructor’s failure to maintain altitude while maneuvering to another runway after the engine cowling opened shortly after takeoff. Contributing to the accident was the failure of both the student pilot and flight instructor to conduct an adequate…NTSB WPR22LA174Accident · Serious injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 407 · Livermore, CALoss of engine power due to the pilot inadvertently selecting engine IDLE mode while in flight, which reduced rotor and engine speed to a level that could not sustain flight.NTSB WPR20LA325Accident · No injuriesClass 4 · LimitedFinal reportCessna T210 · Bridgeport, CAAn inadvertent retraction of the flaps during a go-around by the pilot-rated passenger, which caused the airplane to settle onto the runway with the landing gear retracted.NTSB WPR20CA261Accident · Serious injuriesClass 4 · Data collectionFinal reportAviat A1 · Kernville, CAThe pilot's failure to maintain clearance from trees during a go-around, which resulted in an impact with terrain.NTSB WPR20CA146Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Perris, CAThe pilot's diverted attention while taxing which resulted in his failure to maintain clearance from the skip loader during taxi.NTSB WPR20CA105Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Santa Barbara, CAThe pilot's failure to maintain adequate airspeed during the approach, which resulted in a rapid descent rate, hard landing, and nose-over.NTSB WPR20CA103Accident · No injuriesData collectionFinal reportCubCrafters FX-3 · Sonoma/Schellville, CAThe pilot's inadvertent activation of the left brake during the landing roll, which resulted in a loss of directional control, a runway excursion, and collision with a ditch.NTSB WPR20CA092Accident · No injuriesData collectionFinal reportBell OH 58A · Colexico, CAThe pilot's failure to arrest the descent rate while maneuvering at low altitude, which resulted in impact with terrain.NTSB WPR20CA090Accident · No injuriesData collectionFinal reportBeech 36 · Avalon, CAThe pilot's improper approach and delayed decision to apply corrective action, which resulted in a runway overrun, impact with a berm, and a subsequent nose-over.NTSB WPR20CA055Accident · No injuriesData collectionFinal reportCessna 175 · Elk, CAThe pilot's failure to arrest the descent rate during an aborted simulated engine-out approach, which resulted in impact with vegetation and a subsequent cartwheel.NTSB GAA20CA074Accident · No injuriesData collectionFinal reportCessna 172 · FallBrook, CAThe student pilot's use of excessive ground speed while making a right turn when exiting the runway, which resulted in a loss of directional control and a runway excursion.NTSB WPR20FAMS1Accident · 2 fatalClass 3 · Missing aircraftFinal reportPiper PA28R · Shelter Cove, CAUndetermined due to lack of available evidence.NTSB GAA20CA003Accident · No injuriesData collectionFinal reportVans RV9 · Lake Elsinore, CAThe pilot's selection of unsuitable terrain for taxi, which resulted in the landing gear collapsing and a nose-over.NTSB GAA19CA504Accident · No injuriesData collectionFinal reportCessna 182 · Oakland, CAThe pilot's premature full retraction of the flaps during a go-around and his subsequent improper decision to turn with a minimal climb gradient, which resulted in an off-airport landing and a landing gear collapse.NTSB GAA19CA421Accident · Minor injuriesData collectionFinal reportWillie Bennett Glastar · Lompoc, CAThe pilot's failure to maintain a proper glidepath during a night landing, which resulted in impact with a tree.NTSB GAA19CA372Accident · No injuriesData collectionFinal reportCessna T206 · Porterville, CAThe pilot's failure to verify that the rear cargo portion of the right cabin door was adequately secured before flight, which resulted in both portions of the door opening in flight and substantial damage to the fuselage.NTSB WPR19FA115Accident · 1 fatalClass 3 · FieldFinal reportBeech 60 · Fullerton, CAThe pilot’s use of an unapproved elevator control lock device, and his failure to remove that device and correctly position the elevator before flight, which resulted in a loss of control during takeoff. Contributing to the accident was his failure to perform…NTSB WPR19TA110Accident · Serious injuriesClass 3Final reportKubicek BB100 · St. Helena, CAThe balloon pilot's encounter with unforecasted wind, which resulted in his decision to land in unsuitable terrain and a subsequent hard landing. Contributing to the severity of passenger injury was the pilot’s failure to provide a proper safety briefing.NTSB WPR19LA104Accident · Serious injuriesClass 3 · LimitedFinal reportCameron A-400 · Yountville, CAThe pilot’s inability to maintain obstacle clearance after the balloon’s encounter with a downdraft, which resulted in a collision with power lines.NTSB GAA19CA095Accident · No injuriesData collectionFinal reportPiper PA28 · Chino, CAThe flight instructor's failure to maintain directional control during landing.NTSB GAA19CA068Accident · No injuriesData collectionFinal reportSilveira Jonathan A Sonex · Corona, CAThe pilot’s failure to see and avoid the airplane on the runway while landing and the pilot receiving instruction’s and flight instructor's failure to properly scan the approach before pulling onto the runway during the takeoff.NTSB GAA19CA013Accident · No injuriesData collectionFinal reportCessna 140 · Marina, CAThe pilot’s inadvertent application of the brakes, which resulted in a nose-over.NTSB GAA18CA584Accident · No injuriesData collectionFinal reportCessna 305 · Groveland, CAThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and subsequent ground-loop.NTSB WPR18LA252Accident · No injuriesClass 3 · LimitedFinal reportGuimbal Cabri · Santa Ana, CAThe flight instructor's delayed application of power during a power recovery following an autorotation, which resulted in an unrecoverable low rotor rpm during the landing flare and subsequent loss of control.NTSB WPR18LA205Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · San Diego/El Cajon, CAThe pilot’s inadequate preflight planning, which resulted in his exceedance of the airplane's maximum gross weight, which lead to the airplane's poor climb performance, and a subsequent loss of control and impact with terrain.NTSB WPR18LA206Accident · Minor injuriesClass 3 · LimitedFinal reportBell UH 1H · Oakdale, CAThe pilot's loss of control during a precautionary landing following an abnormal noise in-flight, the source of which could not be determined.NTSB GAA18CA342Accident · No injuriesData collectionFinal reportBeech D35 · Corona, CAThe pilot’s inadvertent landing gear retraction during the landing roll.NTSB GAA18CA239Accident · No injuriesData collectionFinal reportBeech 76 · Vacaville, CAThe pilot under instruction’s failure to extend the landing gear and the flight instructor’s inadequate supervision and failure to ensure that the landing gear was extended.NTSB GAA18CA210Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Franklin, CAThe pilot receiving instruction’s abrupt cyclic control input during the touch-down autorotation.NTSB WPR18LA107Accident · Serious injuriesLimited investigationFinal reportCubcrafters CC11-160 · Browns Valley, CAThe pilot’s failure to adequately monitor the environment and maintain a sufficient altitude to avoid power lines.NTSB GAA18CA120Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Santa Paula, CAThe pilot’s failure to maintain directional control during landing due to being distracted by another airplane and her delayed initiation of a go-around, during which the right wing struck a parked helicopter.NTSB GAA18CA107Accident · No injuriesData collectionFinal reportBell UH 1H · Van Nuys, CAThe pilot’s failure to maintain clearance from a stationary helicopter during landing. Contributing to the accident was the ground crew’s failure to ensure that the helicopter would clear the stationary helicopter.NTSB WPR18LA058Accident · No injuriesLimited investigationFinal reportCessna 210 · San Bernardino, CAThe fatigue failure of the left main landing gear (MLG) saddle, which resulted in the pilot's inability to extend the left MLG. Contributing to the accident was the pilot's improper decision to fly the airplane before the annual inspection was completed and…NTSB WPR18LA012Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22T · San Carlos, CAThe pilot's failure to follow the Before-Takeoff checklist and properly set the flaps before takeoff, which altered the airplane’s flight characteristics, and the pilot’s failure to recognize the problem and abort the takeoff in a timely manner, which…NTSB WPR17LA211Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 · Long Beach, CAThe student pilot's failure to maintain rotor rpm during the crosswind landing approach and his subsequent improper decision to initiate an autorotation instead of applying corrective control inputs after the helicopter experienced normal airframe vibration.…NTSB ANC17LA051Accident · No injuriesClass 3 · LimitedFinal reportLeonardo AW139 · Tujunga, CAA yaw excursion and uncontrolled descent due to loss of tail rotor effectiveness during aerial firefighting operations resulting in an impact with trees. A contributing factor was the pilot’s failure to maintain sufficient airspeed, coupled with a quartering…NTSB WPR17FA171Accident · 2 fatalField investigationFinal reportCessna 172N · Big Bear, CAThe pilot's exceedance of the airplane's critical angle of attack during takeoff in high density altitude conditions, which resulted in an aerodynamic stall, loss of control, and subsequent impact with terrain.NTSB GAA17CA355Accident · No injuriesData collectionFinal reportBell UH1B · Williams, CAThe pilot’s failure to maintain clearance from transmission wires while maneuvering at a low altitude during an agricultural application flight.NTSB WPR17LA104Accident · Minor injuriesClass 3 · LimitedFinal reportEvolution Air Lancair Evolution · Firebaugh, CAA failure in the windshield, frame, or windshield-to-frame bond, which resulted in a rapid decompression during cruise flight.