NTSB investigations, 2017, CA

14 cases where the sequence of events included Abnormal runway contact.

Cases per year

20082026
NTSB investigations, 2017, CA per year, 2008–2026: 104 cases
20081
20095
20108
20115
20127
20135
20148
20158
20167
201714
201810
20197
20201
20215
20224
20232
20245
20252

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\" = '090' 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 WPR17LA210Accident · No injuriesLimited investigationFinal reportCessna 210 · Sacramento, CAPartial retraction of the main landing gear during the landing roll for reasons that could not be determined because postaccident examination and functional testing of the gear revealed no anomalies.Sep 20, 2017 · N7330E · Substantial damageNTSB GAA17CA538Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Santa Ynez, CAThe pilot’s improper landing flare in gusting wind conditions, which resulted in a hard, bounced landing.Sep 11, 2017 · N4465F · 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 GAA17CA470Accident · No injuriesData collectionFinal reportCessna 172 · Carlsbad, CAThe student pilot’s improper landing flare in gusting wind conditions.Jul 30, 2017 · N497TC · Substantial damageNTSB GAA17CA479Accident · No injuriesData collectionFinal reportCessna 172 · Santa Ana, CAA hard landing and propeller strike for reasons that could not be determined based on the available evidence.Jul 29, 2017 · N1129K · Substantial damageNTSB GAA17CA423Accident · No injuriesData collectionFinal reportCessna T210L · Yuba City, CAThe pilot’s failure to extend the landing gear before landing.Jul 7, 2017 · N333GK · 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 GAA17CA372Accident · No injuriesData collectionFinal reportCessna 172RG · El Cajon, CAThe pilot's failure to extend the landing gear with sufficient time to allow the landing gear to fully extend and the flight instructor's failure to visually check to see if the right main landing gear were extended.Jun 20, 2017 · N5424V · Substantial damageNTSB GAA17CA315Accident · No injuriesData collectionFinal reportCessna T182 · San Carlos, CAThe pilot's incorrect landing flare, which resulted in a hard, bounced landing.Jun 3, 2017 · N6259T · Substantial damageNTSB GAA17CA312Accident · No injuriesData collectionFinal reportCessna 172 · El Cajon, CAThe student pilot's incorrect landing flare, which resulted in the airplane porpoising upon touchdown.May 30, 2017 · N483SP · Substantial damageNTSB GAA17CA303Accident · No injuriesData collectionFinal reportDehavilland DHC 6 · Perris, CAThe prospective pilot’s improper landing flare and the pilot’s delayed remedial action to initiate a go-around, which resulted in a runway excursion.May 24, 2017 · N708PV · 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 GAA17CA184Accident · No injuriesData collectionFinal reportCSP Leasing Cavalon · Santa Maria, CAThe student pilot’s improper landing flare and subsequent failure to maintain crosswind correction during landing in crosswind conditions.Mar 10, 2017 · N425AG · Substantial damage