NTSB investigations, CA
80 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 8 |
| 1984 | 7 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 6 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 2 |
| 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\" = 390)
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" = 390) 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 LAX08CA035Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Fallbrook, CAThe pilot's misjudged distance and altitude that led to an undershoot and a failure to obtain the proper touchdown point.NTSB SEA08CA011Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Tehachapi, CAThe pilot's misjudged distance/altitude that led to an undershoot, and his failure to attain the proper touchdown point.NTSB LAX08CA006Accident · No injuriesData collectionFinal reportAviat A-1 · Arroyo Grande, CAThe pilot's misjudged altitude and distance on the approach that led to an undershoot and inadequate obstacle clearance.NTSB SEA07CA149Accident · No injuriesData collectionFinal reportPiper PA-16 · Esparto, CAThe pilot's misjudgment of altitude resulting in an undershoot. Factors included the berm and the wind gusts.NTSB SEA07LA079Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Marysville, CAThe failure of the pilot to maintain a proper glidepath while on final approach and his failure to maintain clearance, which resulted in an undershoot and subsequent collision with the runway's approach light standards. A factor was the approach light…NTSB LAX07CA104Accident · No injuriesData collectionFinal reportSchleicher ASW-27B · Williams, CAThe pilot's misjudged distance/altitude and delay in retracting the spoilers that led to an undershoot, which resulted in a collision with terrain.NTSB LAX05CA219Accident · Minor injuriesData collectionFinal reportCessna 180A · Big Bend, CAthe pilot misjudged his clearance altitude above the surface of the lake, resulting in a collision with water.NTSB LAX05LA089Accident · No injuriesLimited investigationFinal reportSmith Aerostar 601 · Murrieta, CAThe pilot's misjudgment of distance/altitude on final approach, which resulted in an undershoot of the runway.NTSB LAX04LA235Accident · 1 fatalLimited investigationFinal reportHarold W Bruce RV-6 · Cloverdale, CAthe pilot's inadequate in-flight planning/decision and selection of the wrong runway, and his inadequate compensation for the gusting tail wind conditions, which resulted in a stall/mush.NTSB LAX04CA115Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Placerville, CAthe pilot's failure to attain a proper glide path during the final approach and delayed go-around, resulting in an undershoot of the runway. The inadequate supervision of the flight and flight instructor's delayed remedial action was also causal.NTSB LAX03CA266Accident · No injuriesData collectionFinal reportCessna 172M · Riverside, CAThe student pilot's misjudged distance and altitude, and the instructor's inadequate supervision of the flight. Also causal was the instructor's delayed remedial action.NTSB LAX02LA244Accident · No injuriesLimited investigationFinal reportCessna 182P · Mokelumne Hill, CAThe pilot's failure to maintain the proper glidepath and failure to follow the manufacturer's recommended flap setting of 40 degrees, which resulted in an undershoot short of the runway. Factors include the runway's upslope and short length, which likely…NTSB LAX02LA024Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Copperopolis, CAThe pilot's misjudgment of speed and altitude on final approach to landing, which resulted in a low approach and impact with a fence at the runway threshold. The impact lead to a subsequent loss of control and nose over.NTSB LAX01FA032Accident · 1 fatalField investigationFinal reportCessna 340A · Selma, CAThe pilot's improper decision to attempt a visual approach and landing in instrument meteorological conditions and his failure to follow instrument flight rules procedures.NTSB LAX00LA291Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Avalon, CAThe pilot's inadequate compensation for the downdraft condition and subsequent failure to maintain proper glide path. A factor in the accident was the upsloping runway and nature of the terrain around the runway, which presented an optical illusion and lead…NTSB LAX00LA117Accident · No injuriesLimited investigationFinal reportPiper PA-46-310 · Palo Alto, CAThe pilot's failure to obtain/maintain the proper visual glide path resulting in an undershoot and collision with the runway edge.NTSB LAX00LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fallbrook, CAthe pilot's misjudged altitude and distance during a night landing approach, which resulted in an undershoot.NTSB LAX98LA148Accident · No injuriesLimited investigationFinal reportCessna 150G · Oroville, CAThe pilot's failure to maintain the proper glide path, and his inadequate compensation for wind conditions, which resulted in an undershoot.NTSB LAX98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Healdsburg, CAthe pilot's misjudged distance and altitude relationship to the runway during a short field approach, which resulted in an undershoot and a hard landing.NTSB LAX97LA310Accident · No injuriesLimited investigationFinal reportBingelis Falco F.8L · Watsonville, CAthe pilot's misjudgment of distance and speed on final approach, leading to a landing undershoot.NTSB LAX97LA165Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Hemet, CAthe pilot's failure to adjust his traffic pattern to compensate for local atmospheric conditions.NTSB LAX97LA024Accident · No injuriesLimited investigationFinal reportSchweizer 2-33-A · Los Alamitos, CAThe student pilot's failure to properly handle the glider, and the instructor pilot's inadequate supervision.NTSB LAX96LA224Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Santa Clarita, CAthe pilot's failure to abandon the pinnacle approach after encountering an excessive rate of descent.NTSB LAX96LA166Accident · No injuriesLimited investigationFinal reportRockwell 112TCA · Independence, CAthe pilot's inadequate compensation for the wind conditions. The wind was a factor.NTSB LAX96LA069Accident · No injuriesLimited investigationFinal reportCessna 172 · Ocotillo Wells, CAthe failure of the pilot to maintain a proper glide path on final approach.NTSB LAX95LA013Accident · No injuriesLimited investigationFinal reportStan G. Hallam RV-6 · Bridgeport, CAthe pilot's poorly planned approach, his failure to maintain the proper airspeed and descent rate, and his failure to perform the necessary remedial action.NTSB LAX95LA002Accident · No injuriesLimited investigationFinal reportCessna 172M · Coalinga, CAthe pilot's failure to maintain a proper glide path.NTSB LAX94LA381Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Woodland, CAthe failure of the pilot to maintain an adequate airspeed during a short field approach and the inadvertent entry into a stall/mush condition. In addition, the instructor failed to take proper remedial action.NTSB LAX94LA111Accident · No injuriesLimited investigationFinal reportBritten-Norman BN2A-8 Islander · Santa Rosa Isl, CAA failure of the pilot-in-command to maintain a proper glide path to the runway and his misjudgement of the touchdown point that resulted in an undershoot and subsequent hard landing.NTSB LAX93LA259Accident · 1 fatalLimited investigationFinal reportRaymond Long EZ · Groveland, CAThe pilot's failure to maintain a proper glide path during final approach. A factor in the accident was sun glare in the pilot's line of vision.NTSB LAX93LA121Accident · No injuriesLimited investigationFinal reportBeech C35 · Susanville, CAThe pilot's poorly planned approach. Contributing to this accident was the pilot's misjudging his distance and altitude and the prevailing light snow conditions.NTSB LAX93LA109Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Columbia, CAThe pilot's failure to maintain a proper glidepath while on short final approach. A factor in the accident was the dark night lighting conditions which may have affected the pilot's perceptual awareness of the airport environment and the cues for a proper…NTSB LAX92LA375Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Santa Monica, CAThe the pilot's poorly planned approach; his failure to select the proper touch down point; and inadequate remedial action.NTSB LAX92LA266Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Coalinga, CAThe failure of the pilot to maintain the proper glide path during the night VFR approach which resulted in a landing undershoot and a subsequent collision with the raised asphalt lip of the runway edge.NTSB LAX92LA253Accident · No injuriesLimited investigationFinal reportPiper PA-60-700P · Coalinga, CAThe pilot's failure to attain the proper touchdown point and misjudging the aircraft's distance from the runway. Contributing to this accident was the crosswind condition and the nose and main landing gear collapsing due to overload.NTSB LAX92LA075Accident · No injuriesLimited investigationFinal reportPiper PA601P · San Diego, CAThe pilot's poorly planned approach and delay in accomplishing the proper remedial action while executing a night short field landing at an adequately lighted airport. Contributing to the accident was the failure of the pilot to maintain the proper glide…NTSB LAX91LA408Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Fremont, CAThe pilot failed to adequately compensate for the prevailing wind conditions.NTSB LAX91LA349Accident · No injuriesLimited investigationFinal reportLet L-13 · Byron, CAThe on ground collision with a hidden ditch not visible to the pilot during the landing roll out phase of a forced landing.NTSB LAX90DVM02Accident · Minor injuriesFinal reportLink VARI-EZE · Hollister, CAThe pilot's misjudgement of altitude and distance to the runway, while on final approach to land. The sunglare was a related factor.NTSB LAX90LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Coalinga, CAThe pilot's misjudgement of distance and altitude to the runway, while on final approach, which resulted in his failure to attain the proper touchdown point for landing. Factors related to the accident were: darkness, haze, and soft terrain in the area where…NTSB LAX90LA024Accident · No injuriesLimited investigationFinal reportCessna 320 · Hayward, CAFailure of the pilot to attain the proper touchdown point and his improper flare for landing. Factors related to the accident were: the pilot's lack of experience in the make and model of aircraft, and company induced pressure.NTSB LAX89LA322Accident · Minor injuriesLimited investigationFinal reportBellanca Citabria · Auburn, CAThe pilot's inadvertent activation of nose down trim which resulted in a loss of control and collision with a tree. Contributing factor(s) was: the pilot's lack of experience in this type of airplane.NTSB LAX89LA321Accident · No injuriesLimited investigationFinal reportCessna 150 · Paradise, CAThe pilot's failure to adequately compensate for the existing wind conditions and to maintain adequate airspeed. Contributing to the accident were the adverse wind conditions.NTSB LAX89LA249Accident · No injuriesLimited investigationFinal reportBeech C24R · Lower Lake, CAPilot-in-command's failure to identify the sink rate soon enough to take corrective action.NTSB LAX89DVA04Accident · Minor injuriesFinal reportLowe Quickie Q-200 · Hanford, CAThe pilot misjudged his altitude & distance to the runway, while on final approach, which resulted in an undershoot of the runway. A factor related to the accident was the fence.NTSB LAX89LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gualala, CAPilot misjudged the altitude and distance to the runway and subsequently did not attain the proper touchdown point.NTSB LAX88LA209Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Vacaville, CAAt the end of a pleasure flt, the plt extended the downwind leg for landing, thinking that the touchdown altitude was 12 ft instead of, in actuality, 220 ft. the plt normally flew out of another airport with an alt of 12 ft. from the extended downwind, the…NTSB LAX88LA145Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CANTSB LAX87LA315Accident · No injuriesLimited investigationFinal reportCessna 172D · Fortuna, CAThe pilot was attempting a precautionary landing because of deteriorating weather due to fog. He undershot the runway on his landing touchdown. He said he was blinded by the approach lights but elected to continue with the landing rather than attempting a…NTSB LAX87LA317Accident · No injuriesLimited investigationFinal reportBeech B-60 · Bermuda Dunes, CAThe right main landing gear hit the runway lip upon touchdown on runway 11 and collapsed. At the time of the accident the runway's overrun area was under construction and there was a nine inch lip at the runway end. The pilot was aware of the construction…