NTSB investigations, CA

71 cases where the sequence of events included Ground collision.

Cases, newest first

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\" = '200' 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.

NTSB WPR11CA456Accident · No injuriesData collectionFinal reportCub Crafters CC11-100 · San Jose, CAThe pilot's failure to maintain directional control while taxiing due to his distraction by a cockpit warning light.Sep 17, 2011 · N468CB · Substantial damageNTSB WPR11FA158Accident · No injuriesField investigationFinal reportCessna 208B · Bakersfield, CAThe malfunction of a master brake cylinder, which resulted in a loss of braking action and subsequent loss of directional control and collision with three vehicles during taxi. Contributing to the accident was the inappropriate design and manufacture of the…Mar 10, 2011 · N930FE · Substantial damageNTSB WPR10CA451Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Paradise Lakes Estates, CAThe pilot's failure to maintain clearance from a fence during taxi.Sep 7, 2010 · N32025 · Substantial damageNTSB WPR10CA382Accident · No injuriesData collectionFinal reportBoeing PT-13B · Santa Rosa, CAThe failure of the pilot of another airplane to maintain clearance while taxiing.Jul 31, 2010 · N46590 · 2 aircraft · Minor damageNTSB WPR10CA222Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Los Alamos, CAThe pilot's inadequate compensation for the crosswind conditions resulting in the loss of directional control while landing.May 2, 2010 · N72RZ · Substantial damageNTSB WPR10IA135Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Los Angeles, CAThe flight crew’s failure to maintain clearance from the jet bridge during taxi. Contributing to the incident was the ramp marshaller's diverted attention and failure to signal the flight crew to stop at the correct position.Feb 16, 2010 · N226SW · Minor damageNTSB WPR10CA079Accident · No injuriesData collectionFinal reportCurtiss Wright Travel AIR 4000 · Torrance, CAThe Travel Air pilot's failure to maintain an adequate visual lookout during taxi.Nov 29, 2009 · N8700 · 2 aircraft · No damageNTSB WPR10LA002Accident · No injuriesLimited investigationFinal reportCessna 421B · San Simeon, CAThe pilot's failure to follow the manufacturer’s checklist and set the parking brake.Oct 3, 2009 · N31KT · Substantial damageNTSB WPR09CA461Accident · No injuriesData collectionFinal reportCessna 172S · San Carlos, CAThe student pilot's failure to maintain clearance with a fence post during taxi.Sep 21, 2009 · N21591 · Substantial damageNTSB WPR09CA447Accident · No injuriesData collectionFinal reportCessna 172P · Long Beach, CAThe pilot’s failure to maintain clearance from a parked vehicle during taxi.Sep 8, 2009 · N51594 · Substantial damageNTSB WPR09LA413Accident · Serious injuriesLimited investigationFinal reportAntares US MA-34R · San Jose, CAThe pilot's failure to maintain aircraft control during engine startup, which resulted in a collision with parked aircraft. Contributing to the accident was the engine's inadvertent increase to high power for undetermined reasons.Aug 24, 2009 · N2356W · Substantial damageNTSB WPR09LA287Accident · No injuriesLimited investigationFinal reportHoward Long EZ · Placerville, CAThe pilot's inability to maintain directional control during the landing roll due to a jammed brake cable.Jun 14, 2009 · N7999H · Substantial damageNTSB WPR09LA255Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135 · Los Angeles, CAThe flight crew's failure to adequately monitor and maintain clearance from a parked aircraft while taxiing. Contributing to the accident was an improperly parked airplane that encroached upon the taxiway area.May 21, 2009 · N843AE · Substantial damageNTSB WPR09CA073Accident · No injuriesData collectionFinal reportCessna 152 · Long Beach, CAThe student pilot's failuire to maintain directional control during takeoff.Jan 5, 2009 · N45969 · DestroyedNTSB WPR09CA093Accident · No injuriesData collectionFinal reportStemme S-10 · San Jose, CAThe pilot's failure to maintain clearance from an obstacle during taxi.Dec 30, 2008 · N8679 · Substantial damageNTSB DCA09FA022Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-83 · Los Angeles Intl Airport, CAThe first officer's unannounced advancement of the left engine throttle, which led to a sustained application of high thrust that caused the airplane to impact the tug.Dec 26, 2008 · N9617R · Substantial damageNTSB WPR09LA036Accident · No injuriesLimited investigationFinal reportCessna 680 · Los Angeles, CAFailure of the ground service vehicle driver to maintain adequate clearance/distance from the taxiing airplane.Nov 12, 2008 · N320QS · Substantial damageNTSB LAX08LA235Accident · No injuriesLimited investigationFinal reportExtra Flugzeugproduktions-und EA 300/L · San Jose, CAThe pilot of the other airplane's inadequate visual lookout and failure to maintain clearance from another airplane.Jul 20, 2008 · N981KM · 2 aircraft · Minor damageNTSB LAX08LA146Accident · No injuriesLimited investigationFinal reportCessna P206A · Hollister, CAThe pilot's failure to maintain physical clearance from the other airplane while taxiing.May 17, 2008 · N4638F · 2 aircraft · Minor damageNTSB SEA08LA067Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Hollister, CAThe dual student's failure to maintain aircraft control while taxiing from the active runway and the delayed remedial action by the flight instructor. A contributing factor was the unfavorable high wind condition.Jan 25, 2008 · N87R · Substantial damageNTSB SEA08LA061Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · San Francisco, CAThe company tug operator's failure to maintain clearance with another aircraft during the pushback process. Also causal was the ground controller's failure to alert the pilot of the other aircraft and tug operator of this airplane of the simultaneous pushback…Jan 14, 2008 · N705SK · 2 aircraft · Substantial damage