NTSB investigations, 2012, NV

5 cases where the sequence of events included Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2012, NV per year, 2008–2026: 78 cases
20085
20096
20101
20113
20125
20135
20148
20152
20166
20174
20186
20197
20205
20213
20224
20235
20241
20251
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 year(c.\"eventDate\") = 2012
    AND c.\"eventStateOrRegion\" = 'NV' 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\" = '240' 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 WPR13LA093Accident · No injuriesLimited investigationFinal reportKaufmann Vans RV-10 · Las Vegas, NVA missing elevator control assembly attachment bolt, which rendered the elevator control system ineffective and resulted in a loss of pitch control, and the pilot’s incorrect installation of the elevator control assembly.Dec 31, 2012 · N104BK · Substantial damageNTSB WPR12LA218Accident · 1 fatalLimited investigationFinal reportAvia Stroitel AC-5M · Kingston, NVThe pilot's failure to maintain control of the glider while maneuvering in flight.May 19, 2012 · N186P · Substantial damageNTSB WPR12FA216Accident · 2 fatalField investigationFinal reportAero Vodochody L-39 · Boulder City, NVAn in-flight emergency followed by a collision with terrain for reasons that could not be determined because postaccident examination of the airframe, engine, and forward and aft canopies revealed no evidence of mechanical malfunctions or failures that would…May 18, 2012 · N39WT · Substantial damageNTSB WPR12CA162Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Henderson, NVThe pilot did not maintain directional and yaw control of the helicopter during approach and landing, which resulted in a dynamic rollover.Apr 9, 2012 · N55NZ · Substantial damageNTSB WPR12CA100Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Las Vegas, NVThe pilot's inadequate compensation for the known wind conditions during a hovering maneuver, which resulted in a loss of tail rotor effectiveness and directional control.Feb 11, 2012 · N20536 · Substantial damage