NTSB investigations, 2018, CA

9 cases where the sequence of events included Hard landing.

Cases per year

20082026
NTSB investigations, 2018, 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\") = 2018
    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 WPR19CA052Accident · No injuriesData collectionFinal reportRobinson R22 · Hayward, CAAn in-flight collision with a bird during low-altitude maneuvering, which resulted in a hard landing.Dec 28, 2018 · N8319T · Substantial damageNTSB GAA19CA090Accident · Minor injuriesData collectionFinal reportZenair CH 750 Cruzer · Hesperia, CAThe pilot's improper landing flare, which resulted in hard, bounced landing, runway excursion, and impact with a hangar.Dec 8, 2018 · N947DS · Substantial damageNTSB WPR18LA265Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 300CBi 269C1 · Granada Hills, CAA partial loss of engine power that was the result of a loss of compression in the No. 1 and 4 cylinders due to damage and material separation from the exhaust valve heads, which resulted in a subsequent forced, hard landing. Contributing to the accident was…Sep 15, 2018 · N2128T · Substantial damageNTSB WPR18LA226Accident · Serious injuriesClass 3 · LimitedFinal reportHughes 369 · Riverside, CAThe instructor’s delayed remedial action to an excessive descent rate during a simulated autorotation, which resulted in a hard landing.Aug 17, 2018 · N105JL · Substantial damageNTSB GAA18CA396Accident · No injuriesData collectionFinal reportCessna 182 · San Luis Obispo, CAThe pilot’s improper landing flare, which resulted in a hard landing.Jul 8, 2018 · N411BP · Substantial damageNTSB GAA18CA500Accident · No injuriesData collectionFinal reportCessna 152 · Sacramento, CAThe student pilot's improper landing flare, which resulted in a hard, bounced landing.Jun 30, 2018 · N4962L · Substantial damageNTSB WPR18LA133Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Borrego Springs, CAThe loss of the helicopter’s drive system for reasons that could not be determined from the available evidence, which led to an autorotation that resulted in a hard landing and rollover on uneven sandy terrain.Apr 30, 2018 · N423ML · Substantial damageNTSB GAA18CA589Accident · No injuriesData collectionFinal reportPiper PA28R · Camarillo, CAThe flight instructor's improper landing flare, which resulted in a hard landing.Apr 23, 2018 · N9368N · Substantial damageNTSB GAA18CA103Accident · Minor injuriesData collectionFinal reportHarrop Blake RV 7 · Death Valley National Park, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.Jan 14, 2018 · N4163B · Substantial damage