NTSB investigations, CA
63 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 4 |
| 1984 | 3 |
| 1985 | 5 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 4 |
| 1989 | 1 |
| 1990 | 7 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 2 |
| 1995 | 1 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 3 |
| 2000 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 320)
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" = 320) 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 SEA08CA018Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Stockton, CAThe pilot's failure to maintain clearance from a ditch while taxiing. Contributing factors were the pilot's inadequate visual lookout and the ditch.NTSB LAX07IA008Incident · No injuriesIncident investigationFinal reportGulfstream G1159B · Burbank, CAThe pilot's improper decision to continue to taxi onto an unusable taxi area clearly marked as such. A finding in the accident was the incorrectly depicted EMAS area on the approach chart.NTSB LAX07CA013Accident · No injuriesData collectionFinal reportAviat A-1A · Woodlake, CAthe collapse of the landing gear during the landing roll out due to an encounter with rough uneven terrain. Also causal was the pilot's in-flight decision to land on the unsuitable mountainous uneven terrain with hidden obstructions.NTSB LAX06CA021Accident · Minor injuriesData collectionFinal reportDirks Glaser DG-300 · California City, CAthe pilot's inadvertent retraction of the gear and failure to deploy the spoilers, and his subsequent failure to attain a proper touchdown point.NTSB LAX05CA111Accident · No injuriesData collectionFinal reportCessna 172A · Emigrant Gap, CAthe pilot's inadequate preflight planning and his selection of an unsuitable landing area, resulting in an encounter with a snow-covered runway.NTSB LAX04CA130Accident · No injuriesData collectionFinal reportCessna 172S · Riverside, CAthe pilot's inadequate visual lookout, which resulted in his failure to maintain proper alignment with the taxiway. Factors in the accident were the dusk lighting conditions and pilot not understanding the ground control taxi clearance.NTSB LAX04CA085Accident · No injuriesData collectionFinal reportCessna 172N · Hayfork, CAthe pilot's inadequate in-flight decision to attempt a landing on a snow covered runway without ascertaining the depth of the snow cover.NTSB LAX03CA286Accident · No injuriesData collectionFinal reportBeech 58 · Kneeland, CApoor braking action due to the undulating runway surface and crumbling asphalt resulting in an on ground encounter with terrain. Contributing to the accident was the necessity for the pilot to fly an increased approach angle due to the trees at the approach…NTSB LAX02LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Madera, CAThe pilot's becoming lost/disoriented.NTSB LAX00LA298Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Grass Valley, CAThe pilot's failure to attain proper alignment with the runway during approach for landing. Contributing factors were the pilot's inadequate and improper preflight planning and in-flight decision.NTSB LAX00TA186Accident · No injuriesFinal reportMcDonnell Douglas 500N · Los Angeles, CAThe combined failure of the operator management and the check pilot to ensure the landing area was suitable for the slide on landing. Factors were the high vegetation that entangled the skids, resulting in the abrupt stop and nose down movement of the…NTSB LAX98LA242Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Pleasanton, CAThe flight instructor's delayed remedial action and the student pilot's failure to maintain rotor RPM. A factor was the downhill terrain.NTSB LAX98LA231Accident · No injuriesLimited investigationFinal reportCessna 182RG · Cameron Park, CAThe pilot's decision to initiate a turn to exit the runway at an excessive rate of speed.NTSB LAX98LA130Accident · Minor injuriesLimited investigationFinal reportCessna 150A · Apple Valley, CAThe pilot's selection of an unsuitable landing area.NTSB LAX97LA233Accident · No injuriesLimited investigationFinal reportCessna 152 · Madera, CAthe student pilot's failure to maintain runway alignment during takeoff.NTSB LAX97LA153Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Healdsburg, CAThe loss of pressure in the landing gear normal brake system for undetermined reasons requiring the pilot to make an intentional ground loop to stop the aircraft.NTSB LAX97LA077Accident · No injuriesLimited investigationFinal reportCessna 140 · Emigrant Gap, CAthe pilot's misjudgment of altitude/clearance while attempting a precautionary landing on a closed, snow covered runway.NTSB LAX97LA045Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Calexico, CAthe pilot's premature lift-off from the runway and his failure to attain adequate airspeed.NTSB LAX96LA316Accident · No injuriesLimited investigationFinal reportCessna 172F · Ocotillo, CAthe pilot's failure to maintain proper runway alignment. The sun glare and proximity of rocks were related factors.NTSB LAX96LA320Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Paradise, CAThe pilot's attempted flight into known adverse weather conditions.NTSB LAX95LA147Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Byron, CAthe unsuitable terrain selected by the pilots.NTSB LAX93LA219Accident · No injuriesLimited investigationFinal reportCessna 182Q · Concord, CAThe passenger/dual student's improper recovery from a bounced landing, and the pilot's inadequate supervision of the flight.NTSB LAX93LA256Accident · No injuriesLimited investigationFinal reportCessna 150M · Lakeport, CAThe student pilot's delayed flare and improper bounced landing recovery technique which resulted in an inadvertent porpoise and a collision with the runway. A factor in the accident was the student's lack of total experience.NTSB LAX93LA073Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Long Beach, CAA failure of the dual student (second pilot) to properly perform the touch down, and properly assess the terrain at the point of touch down, of an intentional autorotation. Contributing to the accident was a failure of the flight instructor (first pilot) to…NTSB ATL92IA151Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11 · Los Angeles, CAThe pilot in command's improper use of the aircraft flight controls (elevator) during the landing, which resulted in the aircraft tail contacting the runway surface.NTSB LAX92LA259Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAThe failure of the pilot to maintain an adequate wing tip clearance between the aircraft and a dirt bank paralleling the airstrip.NTSB LAX92LA256Accident · No injuriesLimited investigationFinal reportLake 200 · Clearlake, CAThe pilot's inadequate weather evaluation of the wind on the Lake and his delay in lift-off. Contributing to the accident was the rough water that existed on the unsheltered section of the Lake.NTSB LAX91LA362Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Verona, CAThe pilot's improper planning/decision to depart from a runway with high vegetation along the edge and subsequent collision with terrain.NTSB LAX91LA312Accident · No injuriesLimited investigationFinal reportCessna 172N · Mariposa, CAThe pilot misjudging his planned approach. A down-sloping runway surface was a factor in the accident.NTSB LAX91LA167Accident · No injuriesLimited investigationFinal reportCessna 414A · Avenal, CAThe failure of the pilot to maintain directional control after striking a dirt berm during the landing roll. Contributing to the accident was the failure of the pilot to ensure that the airport was adequate for his intended operations.NTSB LAX91LA047Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Poway, CAThe pilot's failure to obtain a proper touchdown point. Contributing factors which related to the basket's tipping over were the pilot's misjudging the wind direction and the wind's relative high speed.NTSB LAX90LA161Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Santa Rosa, CAThe pilot's improper recovery from a bounced landing.NTSB LAX90FA148Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-10-10F · Los Angeles, CAPilot failed to adhere to established landing procedures, maintain a stabilized approach, and allowed the airspeed to go below the predicted v.NTSB LAX90LA122Accident · No injuriesLimited investigationFinal reportBoeing 737-300 · Santa Ana, CAThe pilot's improper rotation during takeoff.NTSB LAX90LA077Accident · No injuriesLimited investigationFinal reportCessna 182Q · Watsonville, CAThe pilot's inadequate visual lookout.NTSB LAX90LA100Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Fresno, CAThe pilot's improper handling of the airplane during taxi.NTSB LAX90LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Big Bear, CAThe pilot's failure to maintain adequate clearance between the aircraft wing tip and the snow bank. A factor in the accident was the snow berms alongside the runway.NTSB LAX89DVA08Accident · No injuriesFinal reportSchweizer G-164B · Livingston, CAThe pilot's decision to attempt a takeoff on unsuitable terrain. A factor was the water on the airstrip.NTSB LAX89DVG02Accident · Minor injuriesFinal reportKnowles Thorp T-18 · Lincoln, CAThe pilot stated that he was practicing takeoffs and landings on a local flight. During one of those landings he indicated that the right wheel locked up and caused the aircraft to veer to the right. He stated that he subsequently lost control of the aircraft…NTSB LAX88DVG09Accident · No injuriesFinal reportSchweizer G-164B · Robbins, CADuring landing roll, after an aerial application flight, the sprayboom became entangled in weeds. The airplane ground looped and nosed over. There were no reported mechanical failures or malfunctions of the airplane at the time of the accident.NTSB LAX88DVG06Accident · No injuriesFinal reportCessna 188 · Upper Lake, CAThe acdt occurred drg an aerial app flt. The pilot reported that he had flown 6 or 7 flights earlier in the day. Each flight the load was reduced due to the increasing temperature of the day. Just prior to the accident, the pilot reported that the takeoff…NTSB LAX88LA156Accident · Serious injuriesLimited investigationFinal reportEiriavion PIK 20D · Saint Helena, CAThe flight departed vacaville gliderport on an aero tow. The plt intended to fly to calistoga, CA and return. After passing st. Helena, CA, the thermal activity began to decrease. The plt executed a 180 deg turn to return to vacaville. When the flt was over…NTSB LAX87LA228Accident · No injuriesLimited investigationFinal reportCessna 120 · Fresno, CAA Cessna 120 landed left of the runway on a rough dirt area and nosed over. The pilot indicated that the airport is not lighted. The runway is equipped with white reflectors and the taxiways are equipped with amber reflectors. The pilot stated he was unable…NTSB LAX86LA352Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Likely, CAThe airplane departed san jose airport (sjc), san jose, CA on a business flight in an area near Likely, CA. The pilot intentionally landed on an open dirt area to obtain a soil sample. During the landing roll-out the airplane's left main gear separated after…NTSB LAX86LA194Accident · No injuriesLimited investigationFinal reportCessna 150H · Davis, CAThe acft landed on a privately own ranch dirt airstrip. The plt reported the landing was normal, but during the landing roll the acft nosewheel struck a small ditch causing it to nose over onto its back. The pilot did not report any preimpact acft…NTSB LAX86LA019Accident · No injuriesLimited investigationFinal reportBeech 24R · San Diego, CAThe acft collided with a ditch during taxi to takeoff. The plt was taxiing into the sun and went into the ditch when the taxiway turned to the rt. The plt said he was blinded by the rising sun.NTSB SEA85LA191Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Coalinga, CAThe plt mistakenly landed on a pvt airstrip and during a x-wind landing made a go around due to a gust of wind. The acft struck a dirt berm with the right wing and the right main gear.NTSB LAX85LA209Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Hemet, CAThe plt attempted to land the glider near the rwy threshold in order to be ready for an immediate relaunch. He reported that he was aware of vegetation, located along the edge of the rwy, but said that he misjudged its height. The right wing contacted the…NTSB LAX85LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Grass Valley, CAAccording to the plt she flared too late and was too close to the left side of the 50 ft wide rwy at touchdown. The acft veered left on the lndg roll and the left main gear struck a snowbank. The plt tried to steer out of the snowbank but the nose gear also…NTSB LAX85LA140Accident · No injuriesLimited investigationFinal reportCessna 177RG · Ukiah, CAOn a dark night, the plt failed to observe that the taxiway (on which he was taxiing) made a 90 deg turn to connect with the beginning of the rwy. Where the taxiway turned, the acft continued straight ahead & went into a 3 ft deep ditch. There were no taxiway…