NTSB investigations, 2016, CA

8 cases where the sequence of events included Attempted remediation/recovery.

Cases per year

20082026
NTSB investigations, 2016, CA per year, 2008–2026: 105 cases
20081
20093
20101
20123
20133
20142
20155
20168
201718
201814
201910
20209
20211
20226
20233
20245
20259
20264

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\") = 2016
    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\" = '060' 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 WPR17LA043Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mt. Baldy, CAThe pilot's failure to maintain main rotor speed during a low orbiting approach over a confined mountainous area. Contributing to the accident was the pilot's decision to attempt to land in an area that did not allow for a safe exit path under conditions near…Dec 29, 2016 · N324RS · Substantial damageNTSB GAA17CA034Accident · No injuriesData collectionFinal reportYakovlev YAK · Tracy, CAThe pilot’s unstabilized approach and delayed application of full throttle for a go-around, which resulted in an uncontrolled descent.Oct 23, 2016 · N38YK · Substantial damageNTSB GAA16CA425Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · San Diego, CAThe pilot's failure to maintain directional control during landing with a crosswind.Aug 10, 2016 · N35451 · Substantial damageNTSB WPR16CA147Accident · No injuriesData collectionFinal reportStinson L 5G · Beckwourth, CAThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the check pilot's failure to act in a timely manner to prevent the airplane from departing the runway.Jun 25, 2016 · N2581B · Substantial damageNTSB GAA16CA197Accident · Minor injuriesData collectionFinal reportBellanca 7ECA · Ramona, CAThe pilot's failure to maintain directional control during takeoff in variable wind conditions.Apr 23, 2016 · N8654V · Substantial damageNTSB GAA16CA151Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Riverside, CAThe student pilot's incorrect action performance by not applying sufficient pressure to the right anti-torque pedal, resulting in an uncontrollable left yaw, and ground impact.Mar 17, 2016 · N9076U · Substantial damageNTSB GAA16CA143Accident · Minor injuriesData collectionFinal reportBell 47 · Agua Dulce, CAThe pilot's failure to set the appropriate collective friction prior to releasing the collective in flight, which resulted in decreased main rotor pitch, settling with power, and an impact with terrain.Mar 2, 2016 · N568TB · Substantial damageNTSB GAA16CA121Accident · No injuriesData collectionFinal reportGlines Kenneth Tailwind W 8 · Big Bear, CAThe pilot's inadvertent landing off the left side of the snow-covered runway, resulting in a ground loop and nose over.Jan 25, 2016 · N1983T · Substantial damage