NTSB investigations, CA
181 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 11 |
|---|---|
| 1983 | 15 |
| 1984 | 17 |
| 1985 | 10 |
| 1986 | 9 |
| 1987 | 10 |
| 1988 | 6 |
| 1989 | 14 |
| 1990 | 13 |
| 1991 | 6 |
| 1992 | 3 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 6 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 5 |
| 1999 | 6 |
| 2000 | 4 |
| 2001 | 4 |
| 2002 | 3 |
| 2003 | 6 |
| 2004 | 6 |
| 2005 | 6 |
| 2006 | 2 |
| 2007 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310)
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" = 310) 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 SEA08CA052Accident · No injuriesData collectionFinal reportCessna 172S · Fullerton, CAThe pilot's failure to maintain clearance while taxiing. Contributing to the accident was the pilot's diverted attention.NTSB LAX08CA019Accident · Minor injuriesData collectionFinal reportPloof Progressive Aerodyne's Searey · Lake Berryessa, CAThe airplane's encounter with a submerged object during landing in water, which resulted in the airplane nosing over.NTSB SEA07CA258Accident · Minor injuriesData collectionFinal reportBell 206-B2 · Rosamond, CAThe pilot's inadequate compensation for gusting variable winds encountered after landing. Factors include gusting, suddenly shifting winds, and a hangar near the spot where the helicopter had landed.NTSB LAX07CA157Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Mariposa, CAThe pilot's failure to maintain clearance from a vehicle while taxiing.NTSB LAX06TA291Accident · No injuriesFinal reportCessna U206G · Wasco, CAThe pilot's improper decision in leaving the engine running while he left the airplane unattended.NTSB LAX06CA157Accident · No injuriesData collectionFinal reportCessna 172S · Big Bear, CAthe pilot's failure to maintain wing clearance from a pole during taxi.NTSB LAX06CA057Accident · No injuriesData collectionFinal reportGrafton Rand KR-1 · El Cajon, CAThe pilot's attempt to turn off the runway at an excessive taxi speed.NTSB LAX06CA062Accident · No injuriesData collectionFinal reportRyan Navion · Los Angeles, CAthe pilot's failure to maintain adequate clearance from a parked vehicle.NTSB LAX06CA045Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Panamint Spring, CAthe pilot's improper in-flight selection of unsuitable terrain for landing.NTSB LAX06CA025Accident · No injuriesData collectionFinal reportCessna 182Q · Torrance, CAthe pilot's excessive taxi speed, and his failure to maintain an adequate clearance from objects.NTSB LAX05LA218Accident · No injuriesLimited investigationFinal reportBoeing 727-230 · San Diego, CAthe inadvertent throttle movement by one of the flight crew and the captain's inadequate supervision during the engine start sequence.NTSB LAX05CA182Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Oxnard, CAthe pilot's failure to maintain an adequate clearance from the building. The pilot's diverted attention was a factor.NTSB LAX05CA024Accident · No injuriesData collectionFinal reportChampion 7GCAA · Petaluma, CAthe pilot's failure to follow the published prestart, start, and shutdown procedures.NTSB LAX04CA317Accident · No injuriesData collectionFinal reportPiper PA-32R-301 · Monterey, CAthe pilot's failure to maintain proper alignment with the taxiway and adequate obstacle clearance. A factor was the bright morning sunglare.NTSB LAX04LA299Accident · No injuriesLimited investigationFinal reportCessna 182G · Big Bear City, CAthe pilot's mistaken selection of an airport road as the landing runway. Factors in the accident were the nonstandard markings on the temporary landing surface and the glare from the setting sun.NTSB LAX04CA196Accident · No injuriesData collectionFinal reportCessna 172N · Lincoln, CAthe pilot's failure to maintain obstacle clearance.NTSB LAX04CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Diego, CAthe pilot's misjudgment of clearance from the vehicle while taxiing. A factor in the accident was the pilot's diverted attention.NTSB LAX04CA088Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Groveland, CAthe pilot's inadequate visual lookout, and his failure to maintain obstacle clearance. Factors to the accident were the parked vehicle, and the pilot's diverted attention.NTSB LAX04CA065Accident · No injuriesData collectionFinal reportBeech 58P · San Diego, CAthe pilot's inadequate lookout, which resulted in his failure to maintain clearance from the vehicle while taxiing.NTSB LAX04CA013Accident · No injuriesData collectionFinal reportCleveland Orson Starduster II SA-300 · Stockton, CAthe pilot's inadequate visual lookout resulted in his failure to maintain clearance from the parked airplane.NTSB LAX04LA007Accident · No injuriesLimited investigationFinal reportBoeing 777-22B · San Francisco, CAthe failure of the taxiing Boeing 777's flight crew to maintain clearance from a Boeing 777 that was being pushed back from the gate. Contributing to the accident was the failure of the local ramp controller to caution either aircrew of a possible movement…NTSB LAX03LA167Accident · No injuriesLimited investigationFinal reportBoeing 757-223 · Santa Ana, CAthe vehicle driver's failure to deploy the parking brake or use wheel chocks to secure the vehicle prior to leaving it unattended.NTSB LAX03FA116Accident · 1 fatalField investigationFinal reportCessna 182G · Santa Maria, CAthe pilot's failure to maintain proper runway alignment during the takeoff ground roll, which resulted in the left wing contacting the brush lining the runway edge. The combined effects of the brush and tree contact retarded the airplanes acceleration and…NTSB LAX03LA088Accident · No injuriesLimited investigationFinal reportCessna 421C · San Francisco, CAThe vehicle driver's inadequate visual lookout and failure to follow established procedures. A contributing factor was the dark nighttime condition.NTSB LAX03LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · San Luis Obispo, CAThe pilot's failure to maintain obstacle clearance due to her inadequate visual lookout.NTSB LAX02LA261Accident · Minor injuriesLimited investigationFinal reportAB Sportine Aviacija Genesis 2 · Orland, CAthe loss of thermal lift during flight.NTSB LAX02LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Sacramento, CAFailure of the pilot to ensure the seat was set properly prior to engine start, and not using the parking brake when adjustment of seat was necessary, which resulted in the inadvertent deactivation of the brakes and subsequent collision with the fuel trucks.NTSB LAX01LA257Accident · No injuriesLimited investigationFinal reportCessna 185F · Visalia, CAThe pilot failed to maintain clearance from crops which bordered the narrow runway.NTSB LAX01LA172Accident · No injuriesLimited investigationFinal reportBell 206B · San Diego, CAthe failure of the ground personnel to maintain clearance between two aircraft on the ramp, while one airplane was taxiing and the other was standing with the engine running and rotor blades turning.NTSB LAX01LA159Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Murrieta, CAThe failure of the pilot to maintain an adequate visual lookout during taxi to avoid striking a post. A factor in the accident was the inadequate marking of the obstruction by airport personnel.NTSB LAX01LA074Accident · No injuriesLimited investigationFinal reportCessna TR182 · Concord, CAThe failure of the pilot to maintain clearance from buildings during taxi.NTSB LAX01LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Ramona, CAThe pilot's inadvertent encounter with a pothole during taxi, after landing.NTSB LAX00LA270Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Luis Obispo, CAThe pilot's inadequate visual lookout while taxiing to the runway, which resulted in his failure to see and avoid the fuel truck.NTSB LAX00LA289Accident · No injuriesLimited investigationFinal reportCessna 172K · Palo Alto, CAThe pilot of the other airplane's (Cessna) inadequate visual lookout and misjudged distance to the standing Beech.NTSB LAX00LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAThe pilot's in-flight decision to continue the takeoff and his subsequent delayed decision to abort the takeoff after he noted that the airplane was unable to climb out of ground effect.NTSB LAX99LA306Accident · No injuriesLimited investigationFinal reportCessna 172N · San Jose, CAThe pilot's failure to maintain an adequate visual lookout during taxi. Sun glare was a factor in the accident.NTSB LAX99LA302Accident · No injuriesLimited investigationFinal reportBoeing 737-322 · Los Angeles, CAThe lavatory service driver's failure to follow established company procedures and directives. A factor in the accident was the airline's use of a one person pushback procedure.NTSB LAX99LA309Accident · No injuriesLimited investigationFinal reportCessna 172N · Carlsbad, CAThe pilot's failure to maintain an adequate clearance from obstacles during taxi in a confined space.NTSB LAX99LA195Accident · No injuriesLimited investigationFinal reportBeech A36 · Willows, CAThe failure of the pilot to maintain an adequate clearance with a parked trailer while taxiing the aircraft.NTSB LAX99LA172Accident · No injuriesLimited investigationFinal reportBeech A36 · San Diego, CAThe pilot's failure to maintain a visual lookout while taxiing resulting in the aircraft's colliding with a runway sign. Contributing factors were dusk light conditions, the sign, and the pilot's diverting his attention to aircraft instrumentation during taxi.NTSB LAX99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Rubidoux, CAThe pilot's failure to maintain adequate clearance from parked airplanes while taxiing due to his diverted attention.NTSB LAX99LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe pilot's failure to maintain clearance between the airplane's wing and a parked fuel truck.NTSB LAX98LA303Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Santa Rosa, CAThe pilot's inadequate visual lookout during taxiing operations. A factor was the pilot's diverted attention while taxiing.NTSB LAX98LA315Accident · No injuriesLimited investigationFinal reportCessna 150L · Oroville, CAFailure of the pilot to maintain proper clearance and subsequently striking a hangar door while taxiing to parking.NTSB LAX98LA259Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Willits, CAThe pilot's selection of an inadequate landing area and failure to maintain clearance from obstacles during the landing roll.NTSB LAX98LA163Accident · No injuriesLimited investigationFinal reportCessna 172A · Van Nuys, CAThe pilot's failure to maintain obstacle clearance due to his inadequate visual lookout and selection of the wrong taxi route. Contributing factors were the pilot's diverted attention while taxiing in the vicinity of a construction area.NTSB LAX98LA030Accident · No injuriesLimited investigationFinal reportCessna 172P · San Diego, CAThe student pilot's failure to maintain adequate clearance from a hangar while taxiing.NTSB LAX97LA313Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Yucca Valley, CAthe driver's failure to see the posted sign and yield to the landing aircraft.NTSB LAX97LA064Accident · No injuriesLimited investigationFinal reportCessna 172 · Big Bear City, CAthe pilot's inadequate compensation for the wind condition, and his failure to maintain alignment with the runway. The gusty crosswind was a related factor.NTSB LAX96LA319Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries Katana DA20-A1 · S. Lake Tahoe, CAThe pilot's inadequate use of the brakes, which resulted in loss of directional control while taxiing in a non-movement area.