NTSB investigations, 2017, CA

22 cases where the sequence of events included Loss of control on ground.

Cases per year

20082026
NTSB investigations, 2017, CA per year, 2008–2026: 379 cases
200823
200927
201028
201117
201223
201323
201416
201519
201622
201722
201823
201921
202016
202116
202216
202318
202416
202520
202613

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\" = '230' 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 GAA18CA079Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Chino, CAThe pilot’s failure to maintain directional control during a touch-and-go landing.Dec 3, 2017 · N1431C · Substantial damageNTSB GAA18CA076Accident · No injuriesData collectionFinal reportCessna 152 · Fullerton, CAThe student pilot’s failure to maintain directional control during takeoff.Nov 30, 2017 · N417CB · Substantial damageNTSB GAA18CA050Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Rosamond, CAThe pilot’s failure to maintain directional control during the landing roll.Nov 19, 2017 · N69656 · Substantial damageNTSB WPR18LA015Accident · No injuriesLimited investigationFinal reportSchweizer G 164B · Tracy, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.Oct 24, 2017 · N8494K · Substantial damageNTSB GAA18CA018Accident · No injuriesData collectionFinal reportAeronca 7DC · Salinas, CAThe pilot’s failure to maintain directional control during landing with a tailwind.Oct 22, 2017 · N83512 · Substantial damageNTSB GAA18CA010Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Brawley, CAThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Oct 11, 2017 · N80060 · 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 GAA17CA558Accident · No injuriesData collectionFinal reportBellanca 14 19 · Redding, CAThe pilot’s failure to maintain directional control during the landing roll.Aug 27, 2017 · N36KC · Substantial damageNTSB GAA17CA445Accident · No injuriesData collectionFinal reportCessna 170 · San Andreas, CAThe pilot’s improper landing flare during an aborted go-around in gusting wind conditions, which resulted in a hard landing.Jul 27, 2017 · N5596C · Substantial damageNTSB GAA17CA377Accident · No injuriesData collectionFinal reportPiper PA 22-150 · Mammoth Lakes, CAThe pilot’s failure to maintain directional control during the landing roll.Jul 1, 2017 · N1737P · Substantial damageNTSB GAA17CA364Accident · No injuriesData collectionFinal reportCessna 305 · Ukiah, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.Jun 25, 2017 · N4819R · Substantial damageNTSB GAA17CA352Accident · No injuriesData collectionFinal reportPiper PA 18 · Red Bluff, CAThe pilot’s failure to maintain pitch control during the landing roll in gusting wind conditions, which resulted in a nose-over.Jun 18, 2017 · N4420Z · Substantial damageNTSB GAA17CA413Accident · No injuriesData collectionFinal reportChampion 7ECA · Van Nuys, CAThe pilot’s failure to maintain directional control during the landing roll.Jun 15, 2017 · N2537F · Substantial damageNTSB GAA17CA310Accident · No injuriesData collectionFinal reportCessna A185 · Fall River Mills, CAThe pilot’s failure to maintain directional control during the landing roll.May 27, 2017 · N2262T · Substantial damageNTSB GAA17CA280Accident · Minor injuriesData collectionFinal reportWeaver Stanley R/Robinson Scot Vans RV-8 · Vacaville, CAThe pilot’s failure to maintain directional control while landing in crosswind conditions.May 15, 2017 · N184ME · Substantial damageNTSB GAA17CA270Accident · No injuriesData collectionFinal reportCessna A185 · Columbia, CAThe pilot’s failure to maintain directional control in tailwind and crosswind conditions.May 9, 2017 · N185RX · Substantial damageNTSB WPR17LA100Accident · No injuriesLimited investigationFinal reportGrumman G164 · Madera, CAThe pilot’s loss of directional control during takeoff with a quartering tailwind, which resulted in a runway excursion and separation of the right landing gear.May 7, 2017 · N8712H · DestroyedNTSB GAA17CA242Accident · No injuriesData collectionFinal reportNorth American SNJ · Van Nuys, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll with a quartering tailwind.Apr 20, 2017 · N7969C · Substantial damageNTSB GAA17CA204Accident · Minor injuriesData collectionFinal reportCessna 170 · Death Valley, CAThe pilot’s improper compensation for crosswind conditions during the landing flare and his subsequent failure to maintain directional control during the landing.Mar 26, 2017 · N9953A · Substantial damageNTSB WPR17FA077Accident · 1 fatalField investigationFinal reportChallenger II · Oakdale, CAThe pilot's failure to attain a proper touchdown point and his subsequent loss of directional control during landing for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would…Mar 11, 2017 · N2621T · Substantial damageNTSB GAA17CA148Accident · Serious injuriesData collectionFinal reportBeech A23 · Beckwourth, CAThe student pilot’s inadvertent use of the control yoke to correct for a drift and his subsequent failure to maintain directional control during takeoff.Feb 14, 2017 · N425RS · Substantial damageNTSB GAA17CA114Accident · No injuriesData collectionFinal reportBeech B200 · Coalinga, CAThe pilot’s failure to maintain directional control during takeoff.Jan 14, 2017 · N795DE · Substantial damage