NTSB investigations, CA

7 cases where NTSB found Convective turbulence.

Cases per year

20102026
NTSB investigations, CA per year, 2010–2026: 7 cases
20101
20111
20141
20152
20231
20251

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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03032020'))
  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 DCA25LA126Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Hacienda Heights, CAThe airplane’s encounter with moderate turbulence during descent, which resulted in serious injury to a flight attendant.Feb 14, 2025 · N939WN · No damageNTSB DCA23LA213Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-224 · Sacramento, CAAn encounter with forecast convective turbulence during climb.Mar 21, 2023 · N79011 · No damageNTSB GAA15CA276Accident · No injuriesData collectionFinal reportPiper PA 28 · Van Nuys, CAThe pilot's failure to compensate for turbulence during the landing flare, which resulted in a hard landing and runway excursion.Sep 24, 2015 · N8258S · Substantial damageNTSB WPR15LA239Accident · Serious injuriesLimited investigationFinal reportEmbraer E175 · South Lake Tahoe, CAThe airplane's encounter with moderate turbulence during descent, which resulted in a serious injury to a flight attendant who was not securely seated. Contributing to the accident was the flight attendant's decision to continue to secure items before the…Aug 7, 2015 · N204NN · No damageNTSB DCA15CA050Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · San Jose, CAan inadvertent encounter with convective turbulence during descent.Dec 11, 2014 · N481WN · No damageNTSB WPR11FA173Accident · 3 fatalField investigationFinal reportCessna P210 · Daggett, CAThe pilot's decision to conduct the flight into a region of reported moderate to severe turbulence and icing conditions, followed by a loss of airplane control and an aerodynamic spin from which the pilot did not recover.Mar 20, 2011 · N50MC · Substantial damageNTSB WPR10LA259Accident · 1 fatalLimited investigationFinal reportSocata TB-20 · Happy Camp, CAThe pilot’s inadequate preflight planning and decision to continue to operate under visual flight rules into instrument meteorological conditions, which resulted in an encounter with an embedded thunderstorm and rain showers and moderate to severe turbulence,…May 22, 2010 · N3041Y · Substantial damage