NTSB investigations, CA
155 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 12 |
| 1984 | 15 |
| 1985 | 8 |
| 1986 | 5 |
| 1987 | 5 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 6 |
| 1991 | 6 |
| 1992 | 9 |
| 1993 | 6 |
| 1994 | 6 |
| 1995 | 9 |
| 1996 | 5 |
| 1997 | 5 |
| 1998 | 3 |
| 1999 | 5 |
| 2000 | 3 |
| 2001 | 1 |
| 2002 | 6 |
| 2003 | 2 |
| 2004 | 6 |
| 2005 | 6 |
| 2006 | 5 |
| 2007 | 6 |
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 340)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 340) 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 LAX08CA037Accident · No injuriesData collectionFinal reportCessna 152 · Turlock, CAThe pilot's delayed decision to abort the landing, which resulted in a runway overrun.NTSB SEA07CA267Accident · No injuriesData collectionFinal reportCessna 340A · Schellville, CAThe pilot's misjudgment of speed and distance, which resulted in an overrun of the runway. Contribution factors are the pilot's inadvertent landing at the wrong airport with a shorter runway than his intended destination and limited braking effectiveness…NTSB LAX07CA275Accident · Minor injuriesData collectionFinal reportCessna U206G · Fort Bragg, CAThe pilot's misjudged speed and distance, which resulted in a landing overrun of the runway.NTSB SEA07CA257Accident · No injuriesData collectionFinal reportCessna 182Q · Dunsmuir, CAThe pilot's misjudgment of distance/speed and his failure to attain the proper touchdown point during landing, which resulted in a runway overrun during the landing roll.NTSB SEA07CA236Accident · No injuriesData collectionFinal reportCessna 182R · Redding, CAThe pilot's failure to achieve the proper touchdown point, which resulted in a runway overrun and collision with a fence.NTSB SEA07LA152Accident · No injuriesLimited investigationFinal reportDassault-Breguet Mystere Falcon 900 · Santa Barbara, CAThe erroneous gross weight calculation and improper trim setting by the captain, which resulted in the airplane's failure to rotate at Vr as expected and the captain's decision to perform to a high speed aborted takeoff.NTSB LAX06CA278Accident · No injuriesData collectionFinal reportGlaser Dirks DG 300 · Truckee, CAthe pilot's misjudged landing approach that led to a runway overshoot. A contributing factor was the pilot's hypoxic condition.NTSB LAX06CA216Accident · Minor injuriesData collectionFinal reportEklund Thorp T-18 · San Andreas, CAthe pilot's misjudged airspeed and distance during the approach, and his failure to initiate a timely go-around, which resulted in a landing overrun.NTSB LAX06FA211Accident · 1 fatalField investigationFinal reportCessna 560 · Upland, CAThe pilot's unstabilized approach to the runway and failure to obtain the proper touchdown point, which resulted in a runway overrun.NTSB LAX06CA207Accident · Minor injuriesData collectionFinal reportRonald D. Murray RV-6A · Hesperia, CAthe pilot's inadequate in-flight planning and selection of the wrong runway, which resulted in a downwind landing, the pilot's failure to attain the proper touchdown point, and a runway overrun.NTSB LAX06CA193Accident · No injuriesData collectionFinal reportPiper PA-32R-301T · Gualala, CAthe pilot's misjudged distance and speed, which resulted in a runway overrun. A contributing factor was the hump in the runway.NTSB LAX06CA040Accident · No injuriesData collectionFinal reportCessna P210R · Palo Alto, CAthe pilot's misjudged altitude and distance, which resulted in an overrun, and his failure to execute a timely go-around during the approach.NTSB LAX05CA293Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Dunsmuir, CAthe pilot's delayed decision to abort the takeoff.NTSB LAX05CA250Accident · No injuriesData collectionFinal reportAyres S2R-134 · Kerman, CAthe pilot's failure to obtain an adequate airspeed during an attempted takeoff.NTSB LAX05CA235Accident · No injuriesData collectionFinal reportCessna T210M · TwentyninePalms, CAthe pilot's failure to verify the current local wind condition that resulted in his selection of the wrong runway and an inadvertent downwind landing, a runway overrun and a ground collision with objects. A factor in the accident was the short runway and its…NTSB LAX05CA059Accident · No injuriesData collectionFinal reportCessna 441 · Thermal, CAthe pilot's misjudged speed and distance, which resulted in a failure to attain the proper touchdown point and a subsequent overrun of the runway. A factor in the accident was limited braking effectiveness resulting from the wet runway condition.NTSB LAX05FA058Accident · Minor injuriesField investigationFinal reportPiper PA-46-350P · Palo Alto, CAthe pilot's misjudged distance and speed on final approach, which led to a long landing and a runway overrun. Also causal was the pilot's inadequate in-flight decision to continue flight with indications of apparent serious system anomalies, failure to divert…NTSB LAX05CA043Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Santa Monica, CAthe certified flight instructor's inadequate supervision, inadequate compensation for the tailwind condition, and delayed remedial action, which resulted in a runway overrun and collision with a ditch.NTSB LAX05CA006Accident · Minor injuriesData collectionFinal reportCessna 182RG · Placerville, CAthe pilot's misjudged distance and speed, and failure to attain the proper touchdown point, which resulted in the airplane overrunning the runway surface and nosing over after encountering soft terrain.NTSB LAX04CA262Accident · No injuriesData collectionFinal reportManoucher Lancair 360 Mkii · Pacoima, CAthe pilot misjudged the airplane's distance/speed which resulted in an overrun. A contributing factor was the tailwind.NTSB LAX04CA236Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Dunsmuir, CAthe pilot's misjudgment of speed and distance, which resulted in an overrun of the runway. The pilot's failure to use flaps and his landing at an airport with a runway shorter than he expected is a contributing factor.NTSB LAX04CA212Accident · No injuriesData collectionFinal reportBeech A60 · Gualala, CAthe pilot's inadequate in-flight planning which resulted in a downwind landing. The tailwind was a contributing factor and an overrun of the runway.NTSB LAX04CA105Accident · No injuriesData collectionFinal reportBeech B36TC · San Diego, CAthe pilot's misjudged speed and altitude, which led to a failure to attain the proper touchdown point and a subsequent runway overrun. Also causal was the pilot's delayed decision to perform a go-around.NTSB LAX04LA030Accident · No injuriesLimited investigationFinal reportCessna 310C · Los Angeles, CAThe pilot's misjudgment of distance and speed on the approach resulting in an overrun.NTSB LAX03LA293Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Georgetown, CAthe pilot's misjudged speed and distance, and his failure to perform a go-around which resulted in a runway overrun.NTSB LAX02LA252Accident · No injuriesLimited investigationFinal reportCessna S550 · Big Bear City, CAThe pilot's failure to obtain the proper touchdown point which resulted in an overrun. Contributing factors were the pilot's improper in-flight planning, improper use of performance data, the tailwind condition, failure to perform a go-around, and the…NTSB LAX02FA247Accident · 2 fatalField investigationFinal reportBeech 58TC · Avalon, CAthe pilot's misjudged distance and speed during the landing approach, which resulted in an overrun of the runway. Also causal was the pilot's failure to conduct a go-around during the approach, or abort the landing when an overrun became obvious.NTSB LAX02LA238Accident · No injuriesLimited investigationFinal reportCessna T210F · Willits, CAthe student pilot's misjudged, distance, and speed, and failure to attain the proper touchdown point.NTSB LAX02LA165Accident · No injuriesLimited investigationFinal reportCessna 182Q · San Diego, CAThe pilot's failure to apply continuous brake pressure. Sun glare is a contributing factor.NTSB LAX02LA092Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Santa Paula, CAThe pilot's selection of the wrong landing runway due to his failure to correctly interpret wind indicators, which resulted in his landing with a tailwind.NTSB LAX02FA075Accident · No injuriesField investigationFinal reportCessna 525A · Novato, CAThe pilot's failure to achieve the proper touchdown point and his failure to retract the flaps and spoilers during an attempted landing abort, which resulted in a landing overrun. Also causal was the pilot's decision to attempt a landing in wind conditions…NTSB LAX02FA028Accident · 2 fatalField investigationFinal reportCessna 340A · Santa Monica, CAThe pilot's failure to remove the control gust lock prior to takeoff and his failure to abort the takeoff with sufficient runway remaining to stop the airplane on the runway.NTSB LAX01LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Half Moon Bay, CAA local windshear condition that exceeded the airplane's climb performance capability during landing approach and resulted in the runway overrun during an attempted go-around.NTSB LAX01LA019Accident · Serious injuriesLimited investigationFinal reportBeech 300 · Concord, CAthe pilot's delayed decision to abort the takeoff and his failure to utilize the propeller's reverse pitch function.NTSB DCA00MA030Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 737-300 · Burbank, CAthe flight crew's excessive airspeed and flightpath angle during the approach and landing and its failure to abort the approach when stabilized approach criteria were not met. Contributing to the accident was the controller's positioning of the airplane in…NTSB LAX99LA297Accident · No injuriesLimited investigationFinal reportCessna 205 · Gualala, CAThe pilot's failure to attain a proper touchdown point due to his misjudgment of the aircraft's speed, altitude, and distance to the runway. The pilot's failure to initiate a go-around is also causal.NTSB LAX99LA167Accident · No injuriesLimited investigationFinal reportMassey Super Stallion · Shafter, CAThe pilot's decision to attempt a landing with insufficient runway remaining to stop the airplane.NTSB LAX99LA109Accident · No injuriesLimited investigationFinal reportCessna 172P · Death Valley, CAThe pilot's use of an excessive approach reference speed and his misjudged distance/speed relationship to the runway, which resulted in a landing overrun. The pilot's failure to execute a timely go-around was also causal.NTSB LAX99FA101Accident · No injuriesField investigationFinal reportGrumman G-1159 · Van Nuys, CAThe pilot performed inadequate in flight planning and decided to continue the approach and landing with excessive airspeed. The pilot failed to follow company directives, which required a go around under the encountered flight conditions. This led to a long…NTSB LAX99LA082Accident · No injuriesLimited investigationFinal reportCessna 172L · Santa Paula, CAThe instructor pilot's misjudged altitude and speed, which resulted in a failure to attain the proper touchdown point causing an overrun and collision with a block wall. A factor was the wet runway, which may have hindered brake effectiveness.NTSB LAX99LA011Accident · 3 fatalLimited investigationFinal reportPiper PA-28-181 · Shelter Cove, CAThe pilot's excessive airspeed, failure to attain the proper touchdown point, and the delayed decision to initiate a go-around.NTSB LAX99LA012Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Apple Valley, CAThe pilot's inadvertent use of the aircraft's brakes while using the rudder pedals to maintain directional alignment during the takeoff roll.NTSB LAX98LA133Accident · No injuriesLimited investigationFinal reportCessna TR182 · Maricopa, CAThe pilot's misjudgment of the wind direction and speed, and, his inadequate compensation for those conditions. A factor in the accident was the short runway length, which limited the pilot's time to attempt a go-around.NTSB LAX97LA251Accident · No injuriesLimited investigationFinal reportCessna 150M · Chico, CAfailure of the student pilot to maintain adequate airspeed during a go-around. Trees at the departure end of the runway were a related factor.NTSB LAX97LA237Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Joshua Tree, CAfailure of the pilot to adequately judge the wind direction and to select the correct runway, which resulted in a downwind landing; and his failure to go around, while there was sufficient runway remaining. The tailwind, fence, and ditch were related factors.NTSB LAX97LA199Accident · No injuriesLimited investigationFinal reportCessna 172N · El Monte, CAthe student pilot's misunderstanding of the controller's clearance during an aborted touch-and-go landing.NTSB LAX97LA169Accident · No injuriesLimited investigationFinal reportCameron N-77 · Temecula, CAThe pilot's misjudgment of his speed and altitude, which led to a landing overshoot.NTSB LAX97LA145Accident · No injuriesLimited investigationFinal reportBeech B-60 · Big Bear City, CAThe pilot's decision to land with a tail wind condition, and a failure to attain the proper touchdown point which resulted in an overrun.NTSB LAX97LA062Accident · No injuriesLimited investigationFinal reportCessna 182M · Fallbrook, CAthe pilot's selection of a runway with a tailwind component and his maintaining an excessive airspeed on final approach, which resulted in a late touchdown and a high ground speed.NTSB LAX96LA296Accident · Serious injuriesLimited investigationFinal reportCessna 421C · Avalon, CAthe pilot's failure to initiate a go-around when a landing overshoot became apparent. Factors which contributed to the accident were: the pilot's excessive airspeed and misjudged distance during landing, his lack of flying experience in the Cessna, and…