NTSB investigations, 2014, CA

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

Cases per year

20082026
NTSB investigations, 2014, 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\") = 2014
    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 WPR15CA031Accident · No injuriesData collectionFinal reportSIAI Marchetti S211 · Borrego Valley, CAThe private pilot's premature landing flare and the flight instructor's delayed remedial action, which resulted in a hard landing.Oct 24, 2014 · N211JY · Substantial damageNTSB WPR15CA028Accident · No injuriesData collectionFinal reportCessna 172 - S · Hawthorne, CAThe pilot's improper flare which resulted in a loss of aircraft control and subsequent hard landing.Oct 23, 2014 · N564AT · Substantial damageNTSB WPR14CA364Accident · No injuriesData collectionFinal reportFlight Design Ctls LSA · Grass Valley, CAThe pilot's inadequate flare which resulted in a loss of aircraft control during landing.Sep 3, 2014 · N245LS · Substantial damageNTSB WPR14CA379Accident · No injuriesData collectionFinal reportCessna 152 · Santa Rosa, CAThe student pilot's inadequate flare resulted in a hard landing.Sep 1, 2014 · N67367 · Substantial damageNTSB WPR14CA351Accident · No injuriesData collectionFinal reportCessna 172S · Santa Ynez, CAThe student pilot's inadequate flare and loss of aircraft control during landing, which resulted in multiple bounces.Aug 16, 2014 · N10033 · Substantial damageNTSB WPR14CA295Accident · No injuriesData collectionFinal reportCessna R182 · El Monte, CAThe failure of the right main landing gear pivot assembly. Contributing to the accident was the owner's failure to perform an inspection of the assembly in accordance with the manufacturer's service bulletin.Jul 18, 2014 · N7571T · Substantial damageNTSB WPR14CA293Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Marysville, CAThe pilot's failure to adequately monitor the environmental conditions to assure the aircraft performance would afford an uneventful takeoff with the loading conditions. Contributing to the accident were the pilot's inability to jettison the load due to the…Jul 14, 2014 · N48475 · Substantial damageNTSB WPR14CA139Accident · No injuriesData collectionFinal reportBayer Oscar Starduster SA300 · San Luis Obispo, CAThe pilot's inadequate flare, which resulted in a bounced landing and subsequent loss of aircraft control during landing.Mar 19, 2014 · N490B · Substantial damage