NTSB investigations, CA
34 cases where the sequence of events included Landing area overshoot.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 3 |
| 2010 | 6 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 5 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2024 | 2 |
| 2025 | 1 |
| 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\" = '380' 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" = '380' 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 WPR26LA349Accident · Minor injuriesClass 4 · LimitedInvestigation openCameron Balloons US A-400 · Angwin, CANTSB WPR26LA303Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172L · Upland, CANTSB WPR26FA262Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-4 · Yuba City, CAOn July 16, 2026, at 0701 Pacific daylight time, an experimental amateur built Vans RV-4, N98GB, was substantially damaged when it was involved in an accident near Yuba City, California. The pilot was fatally injured. The airplane was operated as a Title 14…NTSB WPR26LA246Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Lake Elsinore, CAThe student pilot’s failure to maintain a proper glidepath, which resulted in a long landing and collision with a person on the ground.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 WPR24LA229Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · San Diego, CAA failure of the No. 2 cylinder due to fatigue cracking as the result of an undersized fillet radius around the edge of the cylinder head dome.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 GAA19CA241Accident · Minor injuriesData collectionFinal reportStemme S 10 · Sonoma, CAThe pilot's improper decision to land with a tailwind and his failure to maintain a proper approach, which resulted in a long landing, a runway overrun, and impact with a tree.NTSB WPR18LA203Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Avalon, CAThe pilot's delayed decision to conduct a go-around following an unstable landing approach and long landing.NTSB GAA18CA271Accident · No injuriesData collectionFinal reportCessna P210 · Grass Valley, CAThe pilot’s improper landing flare, which resulted in a long landing and a runway excursion.NTSB GAA17CA384Accident · Minor injuriesData collectionFinal reportCessna P210 · Willits, CAThe pilot’s failure to maintain directional control while landing in gusting wind conditions. Contributing to the accident was the pilot’s failure to go around after the unstabilized approach.NTSB WPR17FA029Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Glamis, CAThe pilot's improper decision to attempt a downwind landing and his failure to maintain adequate airspeed while maneuvering during a go-around and subsequent landing attempt, which resulted in exceedance of the airplane's critical angle of attack and an…NTSB WPR17CA001Accident · No injuriesData collectionFinal reportCessna R172K · Rosamond, CAThe pilot's improper use of the control lock, combined with his incomplete execution of two pre-departure procedures, which resulted in a takeoff with the control lock installed.NTSB GAA16CA465Accident · No injuriesData collectionFinal reportCessna TR182 · South Lake Tahoe, CAThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a nose over. Contributing to the accident was the pilot's failure to remove the carburetor heat during the attempted go-around in high…NTSB GAA16CA449Accident · Minor injuriesData collectionFinal reportCessna 182 · Fallbrook, CAThe flight instructor's failure to go-around and the subsequent long landing and his failure to maintain directional control, which resulted in a runway excursion.NTSB WPR16FA115Accident · No injuriesField investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Santa Monica, CAA partial loss of engine power during takeoff due to vapor lock. Contributing to the accident was the student pilot's failure to notice that the engine had exceeded multiple temperature limits and that the fuel flow had become erratic during an extended…NTSB WPR15LA175Accident · No injuriesLimited investigationFinal reportMooney M20K · Fresno, CAA total loss of engine power during cruise flight due to a failure of the No. 1 piston and connecting rod assembly.NTSB WPR15CA100Accident · Minor injuriesData collectionFinal reportCessna U206 - G · Kernville, CAThe pilot's inadequate flare and failure to maintain airplane control during the landing with a tailwind which resulted in a bounce, long landing, and subsequent runway excursion.NTSB WPR15CA076Accident · No injuriesData collectionFinal reportBeech 35 A33 · Angwin, CAThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overshoot, and collision with a fence.NTSB WPR14CA299Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Hoopa, CAThe pilot's inadequate approach and excessive airspeed which resulted in a long landing and subsequent runway overrun onto rough terrain.NTSB WPR13CA328Accident · No injuriesData collectionFinal reportCessna 172S · Redlands, CAThe student pilot's improper flare and unsuccessful attempt to correct a bounced landing, which resulted in the overrun landing.NTSB WPR12LA321Accident · No injuriesLimited investigationFinal reportLoflin RV-7A · Novato, CAThe partial loss of engine power for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was the pilot’s failure to…NTSB WPR10CA404Accident · Minor injuriesData collectionFinal reportCarr Bryan Vans RV-6A · Grass Valley, CAThe pilot’s failure to attain a proper touchdown point that resulted in an overrun of the runway and nose over.NTSB WPR10CA402Accident · No injuriesData collectionFinal reportCessna 182P · Compton, CAThe pilot's failure to attain the proper touchdown point that resulted in an overrun of the runway and collision with a wall.NTSB WPR10CA372Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Garberville, CAThe pilot’s improper airspeed, misjudged approach, and failure to attain the proper touchdown point. Contributing to the accident was the pilot’s lack of familiarity with the airport.NTSB WPR10CA351Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Fullerton, CAThe pilot’s improper flare and inadequate bounced landing recovery, which resulted in a hard landing and porpoise down the runway.NTSB WPR10CA281Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Avalon, CAThe pilot's failure to achieve the proper touchdown point, which resulted in a runway overrun.NTSB WPR10CA095Accident · No injuriesData collectionFinal reportCessna 182P · Fallbrook, CAThe pilot's misjudged altitude and airspeed that resulted in his failure to attain the proper touchdown point.NTSB WPR10LA072Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Clarksburg, CAThe pilot’s improper touchdown point and excessive airspeed during landing, which resulted in a runway overrun.NTSB WPR09CA466Accident · Minor injuriesData collectionFinal reportBeech A23-19 · Tehachapi, CAThe pilot's failure to attain an established approach path while on final approach resulting in an improper flare and bounced landing.NTSB WPR09CA132Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Fallbrook, CAThe pilot's improper use of the brakes and his failure to maintain control of the airplane during landing rollout.NTSB LAX08FA117Accident · No injuriesField investigationFinal reportCessna 510 · Carlsbad, CAThe pilot's misjudgment of speed and distance, resulting in an overshoot of the runway. Contributing to the accident was the pilot's failure to follow the Autopilot Preflight Test Fail checklist and his distraction with a flickering primary flight display…NTSB SEA08LA087Accident · No injuriesLimited investigationFinal reportMaule M-4 · Bishop, CAA loss of engine power due to foreign object ingestion in the induction system, which resulted in a stuck/jammed exhaust valve during the takeoff.NTSB SEA08LA060Accident · No injuriesLimited investigationFinal reportDeSousa Jabiru J400 · Santa Monica, CAThe pilot's failure to attain the proper touchdown point, and loss of the wheel brake system.