NTSB investigations, CA
570 cases where NTSB found Physical environment.
Cases per year
| 2008 | 63 |
|---|---|
| 2009 | 50 |
| 2010 | 38 |
| 2011 | 33 |
| 2012 | 36 |
| 2013 | 38 |
| 2014 | 36 |
| 2015 | 32 |
| 2016 | 27 |
| 2017 | 50 |
| 2018 | 29 |
| 2019 | 31 |
| 2020 | 22 |
| 2021 | 19 |
| 2022 | 17 |
| 2023 | 17 |
| 2024 | 15 |
| 2025 | 11 |
| 2026 | 6 |
Where
Latest 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0302'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0302')) 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 WPR26LA268Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-18 · Colusa, CAThe pilot's inadequate fuel planning and in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR26LA263Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-27 · Montague, CAThe pilot’s inability to see and avoid a piece of loose wire in a field during an off-airport landing in a glider, which resulted in a ground loop. Contributing to the accident was the pilot’s inability to maintain a safe position behind the tow airplane…NTSB WPR26LA222Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Death Valley, CAThe pilot’s failure to maintain airspeed and encounter with a tailwind while landing on a rough runway, which resulted in a runway overrun and subsequent nose over.NTSB WPR26LA220Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Morgan Hill, CAAn in-flight collision with a bird.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 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 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 WPR26LA015Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Lathrop, CAAn inflight collision with a bird.NTSB WPR25LA219Accident · Serious injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Hollister, CAThe departing pilot’s failure to see and avoid the landing airplane during the takeoff, which resulted in a mid-air collision.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 WPR25FA145Accident · 2 fatalClass 3 · FieldFinal reportChampion 7ECA · Cottonwood, CAThe flight instructor’s delayed response to an improper landing approach and runway overshoot, which resulted in an impact with an airport perimeter fence and trees.NTSB WPR25LA157Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fullerton, CAThe pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun and collision with terrain.NTSB WPR25LA113Accident · Minor injuriesClass 4 · LimitedFinal reportBeech E-55 · Van Nuys, CAAn in-flight collision with a bird during an approach to land.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 WPR25LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Ramona, CAAn in-flight collision with a bird in the airport traffic pattern.NTSB WPR25LA078Accident · No injuriesClass 4 · LimitedFinal reportBell 206A · Lemoore, CAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.NTSB DCA25LA102Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787 · Ojai, CAAn encounter with turbulence during descent, which resulted in a serious injury to a flight attendant.NTSB WPR25LA068Accident · No injuriesClass 4 · LimitedFinal reportRemos Remos G-3/600 · Brawley, CAThe flight instructor’s lack of remedial action to the student pilot’s inadequate landing flare, which resulted in a hard landing and a loss of directional control.NTSB WPR25LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201T · Placerville, CAThe pilot’s failure to maintain an adequate descent rate during the landing approach, which resulted in an impact with terrain short of the runway threshold.NTSB WPR25LA005Accident · Serious injuriesClass 4 · LimitedFinal reportRotorsport Cavalon · Chico, CAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent descent and subsequent collision with trees.NTSB WPR24LA310Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Redlands, CAThe pilot’s failure to maintain airplane control during final approach, which resulted in a collision with rocky terrain.NTSB WPR24FA309Accident · 1 fatalClass 3 · FieldFinal reportNanchang China CJ-6A · Lancaster, CAThe CJ-6A pilot’s failure to maintain separation and the Yak pilot’s failure to monitor the other airplane during a detachment, which resulted in a midair collision.NTSB WPR24LA317Accident · No injuriesClass 4 · LimitedFinal reportYakovlev YAK-50 · Watsonville, CAThe Yak-50 pilot’s failure to maintain clearance from another airplane while taxiing and maneuvering. Contributing to the accident was the pilot’s inattention due to a distraction inside the cockpit.NTSB WPR24LA314Accident · Minor injuriesClass 3 · LimitedFinal reportCessna U206G · West Sacramento, CAFailure of the No. 4 cylinder fuel injection assembly tube and subsequent total loss of engine power.NTSB DCA24LA316Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757-224 · Dunnigan, CAThe abrupt pitch control input by the flight crew in response to a TCAS resolution advisory resulted in two serious passenger injuries.NTSB WPR24LA293Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Amboy, CAThe pilot's failure to maintain clearance from a street sign during takeoff from a road.NTSB WPR24LA282Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Durham, CAThe pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike.NTSB WPR24LA283Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Fallbrook, CAThe pilot’s failure to maintain clearance from an obstacle during taxi operations.NTSB WPR24LA244Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Lakeport, CAA collision with a deer during takeoff.NTSB WPR24LA207Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Scheelite, CAThe pilot’s inadvertent entry to a box canyon where the airplane could not outclimb the rising terrain.NTSB ANC24FA038Accident · 1 fatalClass 3 · FieldFinal reportSchweizer G-164B · Richvale, CAThe pilot’s failure to maintain clearance from a trailer located on the edge of the runway during takeoff. Contributing to the accident was the location of the trailer on the side of the runway.NTSB WPR24LA151Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman G164 · Maxwell, CAThe pilot’s failure to ascertain a proper touchdown point and late decision to initiate a go-around, which resulted in a subsequent collision with vegetation.NTSB WPR24LA092Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Calexico, CAThe pilot's failure to maintain clearance from power lines during an aerial application flight.NTSB WPR24LA049Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Watsonville, CAAn in-flight collision with a bird while in the initial climb.NTSB WPR24FA018Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Covelo, CAThe pilot’s failure to maintain clearance from trees after entering a steep banked turn for unknown reasons. Contributing to the accident was the pilot’s decision to take off toward rising terrain.NTSB WPR24LA003Accident · No injuriesClass 3 · LimitedFinal reportCessna 340A · Hayward, CAThe pilot’s sudden incapacitation from effects of a previously undiagnosed underlying heart disease, which resulted in his loss of control of the airplane and subsequent impact with terrain.NTSB WPR23LA322Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5B · Lone Pine, CAThe pilot's inability to maintain altitude after encountering a downdraft, which resulted in collision with terrain.NTSB WPR23LA312Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Dixon, CAThe pilot’s loss of directional control after striking an unidentified object during landing on an unimproved runway, and his subsequent use of excessive braking that resulted in a nose-over.NTSB WPR23LA298Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Long Beach, CAThe flight instructor’s inattention during ground operations, which resulted in unintentional movement of the airplane and ground collision with another airplane.NTSB WPR23LA245Accident · No injuriesClass 4 · LimitedFinal reportSchleicher Alexander ASH 26 E · Williams, CAThe pilot’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in a collision with terrain.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 WPR23FA172Accident · 1 fatalClass 3 · FieldFinal reportCessna 172S · Los Angeles, CAThe pilot’s failure to maintain clearance with the hilly terrain resulting from his loss of situational awareness due to the deteriorating weather conditions as he descended to approach his destination airport.NTSB WPR23LA159Accident · No injuriesClass 4 · LimitedFinal reportVashon Ranger R7 · Upland, CAThe pilot's improper selection of the mixture control, which resulted in a total loss of engine power and a collision with the airport boundary fence during a forced landing.NTSB WPR23LA151Accident · No injuriesClass 4 · LimitedFinal reportLowe Bruce Skystr Ktfx IV-1200 · Susanville, CAThe pilot’s braking technique during an off airport precautionary landing on unforeseen soft terrain, which resulted in a nose over.NTSB ANC23FA031Accident · 2 fatalClass 3 · FieldFinal reportBell Helicopter Textron 407 · Nuevo, CAThe pilot’s decision to maneuver in a steep bank at a low altitude, which resulted in his failure to maintain clearance with terrain.NTSB WPR23FA122Accident · 1 fatalClass 3 · FieldFinal reportRockwell International S-2R · Willows, CAThe pilot’s failure to maintain clearance from powerlines while flying under multiple conductors during a low-altitude aerial application flight, which resulted in propeller contact with a powerline and a subsequent loss of control.NTSB WPR23LA120Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Vernalis, CAThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight.NTSB WPR23LA082Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Watsonville, CAThe pilot’s failure to maintain clearance from powerlines during a go around.NTSB WPR23LA081Accident · No injuriesClass 4 · LimitedFinal reportEmbraer Executive EMB-505 · Hawthorne, CAA runway overrun due to the pilot’s failure to stop the airplane as a result of diminished braking action due to a water contaminated runway surface.