NTSB investigations, CA

6 cases where NTSB found Illness/injury.

Cases per year

20082026
NTSB investigations, CA per year, 2008–2026: 6 cases
20081
20102
20151
20161
20221

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\", '02012010'))
  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 DCA22LA151Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-700 · Santa Ana, CAA flight attendant received a serious injury for undetermined reasons during a firm landing.Jul 2, 2022 · N480WN · No damageNTSB WPR16FA157Accident · 1 fatalField investigationFinal reportArion Lightning LS-1 · Van Nuys, CAThe pilot's loss of airplane control due to an exceedance of the airplane's critical angle of attack, which resulted in an accelerated stall and subsequent impact with a building. Contributing to the accident was the pilot's unreported physiological…Aug 2, 2016 · N341AL · Substantial damageNTSB WPR16FA014Accident · 2 fatalField investigationFinal reportPiper PA 28R-180 · Morongo Valley, CAThe non-instrument rated pilot's improper inflight decision-making to attempt to outclimb clouds along his planned route rather than reverse course, which resulted in his inadvertent entry into instrument meteorological conditions, spatial disorientation, and…Oct 17, 2015 · N4972J · DestroyedNTSB WPR10LA458Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mammoth, CADynamic rollover of the helicopter during a precautionary landing.Sep 16, 2010 · N2153S · Substantial damageNTSB WPR10FA217Accident · 1 fatalField investigationFinal reportPiper PA-30 · Merced, CAPilot incapacitation due to the combined effect of multiple unreported medical conditions.Apr 27, 2010 · N847DE · Substantial damageNTSB LAX08FA047Accident · 1 fatalField investigationFinal reportBeechcraft V35B · Selma, CAThe pilot's failure to maintain control resulting in the in-flight break-up of the airplane due to aerodynamic overload. Contributing factors included the pilot's impairment due to multiple medical conditions and due to recent use of alcohol.Jan 18, 2008 · N4662M · Substantial damage