NTSB investigations, 2013, CA

9 cases where the sequence of events included Hard landing.

Cases per year

20082026
NTSB investigations, 2013, CA per year, 2008–2026: 180 cases
200821
200919
201011
201115
20129
20139
20146
201510
201611
201718
20189
20197
20206
20217
20226
20234
20244
20252
20266

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\") = 2013
    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\" = '092' 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 WPR14CA074Accident · No injuriesData collectionFinal reportCessna 172M · Fullerton, CAThe pilot's inadequate landing flare, which resulted in a bounced landing.Dec 23, 2013 · N80238 · Substantial damageNTSB WPR13LA404Accident · No injuriesLimited investigationFinal reportBell 47G5 · King City, CAThe failure of the helicopter’s center frame tube due to a fatigue crack and corrosion originating from a welded surface. Contributing to the accident was maintenance personnel’s inadequate inspection of the helicopter during its most recent 100-hour…Sep 11, 2013 · N7836S · Substantial damageNTSB WPR13LA432Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA 1C · Hemet, CAThe airplane’s hard landing due to the pilot’s failure to maintain sufficient airspeed while on approach after shutting down the engine because of the smoke in the cockpit from a burnt wire that originated from the alternator field terminal and extended to…Sep 9, 2013 · N9923U · Substantial damageNTSB WPR13LA402Accident · No injuriesLimited investigationFinal reportCessna 172N · Long Beach, CAThe total loss of engine power during initial climb due to debris within the carburetor mixture metering sleeve.Sep 9, 2013 · N42EP · Substantial damageNTSB WPR13CA367Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Hesperia, CAThe pilot’s failure to maintain sufficient airspeed on final approach to landing which resulted in an inadvertent stall.Aug 11, 2013 · N7720P · Substantial damageNTSB WPR13CA332Accident · No injuriesData collectionFinal reportCessna 172S · Santa Barbra, CAThe pilot's inadequate landing flare, which resulted in a hard landing.Jul 17, 2013 · N971TA · Substantial damageNTSB WPR13CA329Accident · No injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Inyokern, CAThe failure of the pilot to maintain aircraft control during a practice autorotation maneuver and the pilot providing training's delayed remedial action which resulted in a hard landing. Contributing to the accident was the lack of communication between the…Jul 13, 2013 · N123HP · Substantial damageNTSB WPR13CA172Accident · No injuriesData collectionFinal reportWaco YMF-3 · Thermal, CAThe pilot’s failure to maintain directional control while landing in a gusting crosswind.Mar 30, 2013 · N14080 · Substantial damageNTSB WPR13CA120Accident · No injuriesData collectionFinal reportBell 206B · Shandon, CAThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.Feb 10, 2013 · N802KA · Substantial damage