NTSB investigations, 2010, CA

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

Cases per year

20082026
NTSB investigations, 2010, 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\") = 2010
    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 WPR11CA057Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Fullerton, CAThe pilot's improper flare during landing.Nov 24, 2010 · N459CT · Substantial damageNTSB WPR10LA445Accident · Serious injuriesLimited investigationFinal reportMorehead KR-2 · Rancho Murieta, CAThe pilot’s improper flare and recovery from a bounced landing.Sep 2, 2010 · N522PC · Substantial damageNTSB WPR10CA392Accident · No injuriesData collectionFinal reportCessna 172P · San Jose, CAThe pilot’s improper flare and inadequate recovery from a bounced landing.Aug 8, 2010 · N64204 · Substantial damageNTSB WPR10CA351Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Fullerton, CAThe pilot’s improper flare and inadequate bounced landing recovery, which resulted in a hard landing and porpoise down the runway.Jul 15, 2010 · N8337A · Substantial damageNTSB WPR10CA350Accident · No injuriesData collectionFinal reportCessna 170 · Truckee, CAThe pilot’s failure to maintain directional control during an aborted landing, resulting in a collision with obstacles.Jul 14, 2010 · N3967V · Substantial damageNTSB WPR10CA263Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAThe pilot's improper recovery from a bounced landing.May 25, 2010 · N69254 · Substantial damageNTSB WPR10CA190Accident · No injuriesData collectionFinal reportCessna T210N · Truckee, CAThe pilot's failure to identify the snow-covered runway, which resulted in an off-runway landing and subsequent collision with a berm.Apr 3, 2010 · N4137C · Substantial damageNTSB WPR10CA178Accident · No injuriesData collectionFinal reportHardie James D KIT FOX XL · Willows, CAThe pilot’s improper flare, resulting in a bounced landing and ground loop.Mar 24, 2010 · N42JH · Substantial damage