NTSB investigations, CA

7 cases where NTSB found Task performance, general.

Cases per year

20082026
NTSB investigations, CA per year, 2008–2026: 7 cases
20081
20101
20112
20122
20261

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\", '020600'))
  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 WPR26LA246Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Lake Elsinore, CAThe student pilot’s failure to maintain a proper glidepath, which resulted in a long landing and collision with a person on the ground.Jul 5, 2026 · N5790S · Substantial damageNTSB WPR13FA054Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Corona, CAThe pilot's failure to maintain clearance between the helicopter’s main rotor blades and the metal canopy of a fuel island.Nov 26, 2012 · N4204A · Substantial damageNTSB WPR13CA055Accident · No injuriesData collectionFinal reportPiper PA18 · Needles, CAThe flight instructor, while demonstrating a water landing to the pilot receiving instruction, did not maintain proper alignment with the landing surface, which resulted in a hard landing.Nov 24, 2012 · N2224 · Substantial damageNTSB WPR11FA316Accident · 4 fatalField investigationFinal reportMooney M20F · Watsonville, CAThe pilot's decision to take off toward a nearby low cloud layer and the subsequent turn, stall, and spin during the pilot’s attempt to avoid the cloud layer. Contributing to the accident was the pilot's failure to avoid the stall. His ability to avoid the…Jul 8, 2011 · N7759M · Substantial damageNTSB WPR11CA174Accident · Minor injuriesData collectionFinal reportCessna 182C · Stockton, CAThe pilot's failure to secure the airplane before pulling the propeller to start the engine.Mar 20, 2011 · N9040T · Substantial damageNTSB WPR10CA382Accident · No injuriesData collectionFinal reportBoeing PT-13B · Santa Rosa, CAThe failure of the pilot of another airplane to maintain clearance while taxiing.Jul 31, 2010 · N46590 · 2 aircraft · Minor damageNTSB LAX08LA235Accident · No injuriesLimited investigationFinal reportExtra Flugzeugproduktions-und EA 300/L · San Jose, CAThe pilot of the other airplane's inadequate visual lookout and failure to maintain clearance from another airplane.Jul 20, 2008 · N981KM · 2 aircraft · Minor damage