NTSB investigations, CA
26 cases where the defining event was Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 1 |
| 2019 | 1 |
| 2021 | 4 |
| 2022 | 4 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 2 |
| 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '470')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '470') 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 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 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 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 WPR24FA119Accident · 2 fatalClass 3 · FieldPreliminary reportDaher TBM700 · Truckee, CAOn March 30, 2024, at 1837 Pacific daylight time, a Daher TBM 700 (960), N960LP, was substantially damaged when it was involved in an accident in Truckee, California. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code…NTSB WPR23LA274Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Long Beach, CAThe student pilot’s failure to maintain directional control during landing and the subsequent go-around, which resulted in impact with a hangar.NTSB WPR22FA198Accident · 1 fatalClass 3 · FieldFinal reportBeech 77 · Hemet, CAThe student pilot’s failure to maintain clearance from a cinderblock wall while performing a go-around.NTSB WPR22LA141Accident · No injuriesClass 4 · LimitedFinal reportFernandes Dale R Glasair II S-FT · Saline Valley, CAThe pilot’s failure to establish a controlled descent rate during landing which resulted in the airplane touching down short of the runway.NTSB WPR22LA144Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Alpine, CAThe pilot’s failure to maintain clearance from rising terrain while operating in a canyon, which resulted in an impact with terrainNTSB WPR22LA114Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 208B · Oceanside, CAThe pilot’s intentional inflight operation of the propeller in beta, which led to an aerodynamic lock, his inability to restore forward thrust, and subsequent collision with terrain.NTSB DCA22WA057IncidentClass 5 · ForeignCanadair CRJ-900 · San Diego, CANTSB WPR22LA031Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Covelo, CAA passenger’s unsecured object departed the cabin resulted in a collision with the tail rotor drive shaft.NTSB WPR21FA270Accident · 2 fatalClass 3 · FieldFinal reportCessna 421C · Monterey, CAThe pilot’s failure to maintain airplane control due to spatial disorientation during an instrument departure procedure in instrument meteorological conditions which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of…NTSB WPR21LA240Accident · No injuriesClass 4 · LimitedFinal reportCessna T206 · Apple Valley, CAThe pilot's distraction due to adjusting the radio while taxing at night, which resulted in a taxiway excursion and subsequent impact with terrain.NTSB WPR20FA018Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Brawley, CAThe pilot’s decision to perform a flight while impaired by the effects of alcohol and cocaine, and his failure to maintain terrain clearance during the flight.NTSB WPR11CA105Accident · No injuriesData collectionFinal reportLantz Lake Tahoe Special · Redding, CAThe airplane's unintentional collision with debris during a water landing.NTSB WPR11CA035Accident · No injuriesData collectionFinal reportCessna 172S · Branscomb, CAThe pilot's failure to maintain clearance from trees during the landing roll on an unimproved airstrip.NTSB WPR11CA023Accident · No injuriesData collectionFinal reportAir Tractor AT-802 · Fort Hunter Liggett, CAThe pilot's misjudged glide path, which resulted in a runway undershoot and collision with terrain during landing.NTSB WPR10FA136Accident · 3 fatalField investigationFinal reportCessna 310R · Palo Alto, CAThe pilot’s failure follow the standard instrument departure as instructed, and his failure to attain a sufficient altitude to maintain clearance from power lines during takeoff in instrument meteorological conditions.NTSB WPR10LA082Accident · Minor injuriesLimited investigationFinal reportEADS Socata TBM 700 · Truckee, CAThe pilot’s failure to maintain an adequate airspeed and clearance from terrain during an attempted go-around. Contributing to the accident was the pilot's decision to land on a partially obscured runway.NTSB WPR09LA222Accident · 2 fatalLimited investigationFinal reportValentin Taifun 17 E II · Mammoth Lakes, CAThe pilot's failure to maintain clearance from terrain while maneuvering in a canyon.NTSB WPR09LA032Accident · 1 fatalLimited investigationFinal reportUniversal Globe · Wallace, CAThe pilot's incapacitation during cruise for unknown reasons that resulted in a loss of aircraft control.NTSB SEA08CA199AccidentData collectionFinal reportCessna 177B · Truckee, CAThe pilot's improper decision to take off in a heavily loaded airplane under the ambient conditions that existed at the time. Contributing to the accident was the mountainous/hilly terrain, a high density altitude, gusty winds and downdrafts.NTSB LAX08CA229Accident · No injuriesData collectionFinal reportBell 47G-3B-1 · Shafter, CAThe pilot's failure to maintain adequate altitude while maneuvering. Contributing factors were the failure of the helicopter's lights during the night flight and the effect of that failure on the pilot's visual perception.NTSB SEA08LA158Accident · 1 fatalLimited investigationFinal reportMauck RV-6A · Sierraville, CAThe pilot's failure to maintain clearance with trees and terrain while maneuvering Contributing to the accident was the reduced visibility in the area due to smoke.NTSB LAX08CA188Accident · Minor injuriesData collectionFinal reportPiper PA-36-375 · Lodi, CAThe pilot's inadequate in-flight decision to continue the flight into an area of obscured visibility and his failure to maintain clearance above obstacles.NTSB SEA08LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Piru, CAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and dark night conditions.