NTSB investigations, 2017, CA

6 cases where the sequence of events included Ground collision.

Cases per year

20082026
NTSB investigations, 2017, 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\") = 2017
    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 WPR18CA059Accident · No injuriesData collectionFinal reportCessna 182 · Santa Ana, CAThe pilot’s failure to follow ground control instructions and to see and avoid ground obstacles while taxiing.Dec 26, 2017 · N698MC · Substantial damageNTSB WPR17LA214Accident · No injuriesLimited investigationFinal reportSC Aerostar YAK 52W · El Cajon, CAThe pilot's failure to maintain directional control during taxi after a reduction in braking performance and steering capabilities due to his failure to reopen the air supply valve after the nonstandard engine start.Sep 23, 2017 · N52KF · Substantial damageNTSB DCA17CA195Accident · No injuriesData collectionFinal reportBoeing 737-924ER · Los Angeles, CAthe B737 flight crew's misjudgment of the clearance between their wingtip and the B767 horizontal stabilizer.Sep 12, 2017 · N69813 · 2 aircraft · Minor damageNTSB GAA17CA411Accident · No injuriesData collectionFinal reportSpani Wayne M Starduster TOO SA300 · San Diego, CAThe other pilot's failure to maintain separation from a stationary airplane during the taxi to the runway.Jul 16, 2017 · N506WS · 2 aircraft · Minor damageNTSB GAA17CA395Accident · No injuriesData collectionFinal reportCessna R182 · San Jose, CAThe other pilot’s failure to maintain separation from another airplane in the run-up area while taxiing.Jul 8, 2017 · N1746R · 2 aircraft · Minor damageNTSB GAA17CA119Accident · No injuriesData collectionFinal reportCessna 175 · Lakeport, CAThe pilot’s failure to secure the airplane before pulling the propeller through, which resulted in the airplane rolling and subsequently colliding with a parked airplane.Jan 6, 2017 · N8148T · Substantial damage