NTSB investigations, 2022, CA

6 cases where the sequence of events included Hard landing.

Cases per year

20082026
NTSB investigations, 2022, 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\") = 2022
    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 WPR23LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · San Jose, CAThe student pilots unstabilized approach and improper landing flare, which resulted in a hard bounced landing.Nov 13, 2022 · N5171B · Substantial damageNTSB WPR23LA004Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206B · Fresno, CAThe disbond of a tail rotor drive shaft splined adapter, which resulted in a loss of tail rotor drive and a subsequent hard landing.Oct 1, 2022 · N284CA · Substantial damageNTSB WPR22LA302Accident · Minor injuriesClass 3 · LimitedFinal reportGoddard Dick Sim Bensen B-8M · Corona, CAThe fatigue failure of the engine mount resulting in a loss of engine power and directional control while maneuvering.Aug 13, 2022 · N532KB · Substantial damageNTSB WPR22LA296Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Corona, CAThe airplane’s partial loss of engine power during the landing for reasons that could not be determined based on the available evidence, which resulted in an off airport landing and subsequent fire.Aug 9, 2022 · N841AD · Substantial damageNTSB WPR22LA167Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Redding, CAThe student pilot's improper landing flare and remedial action which resulted in a bounced landing.Apr 25, 2022 · N9572W · Substantial damageNTSB ANC22LA014Accident · No injuriesClass 3 · LimitedFinal reportBell 205A-1 · El Cajon, CAA partial loss of engine power for reasons that could not be determined based on the available evidence.Jan 15, 2022 · N502HQ · Substantial damage