NTSB investigations, 2008, CA

7 cases where the sequence of events included Ground collision.

Cases per year

20082026
NTSB investigations, 2008, CA per year, 2008–2026: 71 cases
20087
20098
20104
20112
20125
20133
20144
20154
20166
20176
20183
20194
20203
20212
20221
20231
20242
20254
20262

Latest 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 year(c.\"eventDate\") = 2008
    AND 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 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