NTSB investigations, 2010, AR

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

Cases per year

20082026
NTSB investigations, 2010, AR per year, 2008–2026: 82 cases
20086
20094
20108
20116
20123
20133
20145
20155
20167
20174
20182
20192
20204
20216
20222
20237
20243
20252
20263

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\") = 2010
    AND c.\"eventStateOrRegion\" = 'AR' 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 CEN10FA520Accident · 2 fatalField investigationFinal reportCessna T210 · Mountain Home, ARThe pilot’s decision to continue flight into a known area of heavy rain and his subsequent failure to maintain aircraft control.Sep 7, 2010 · N2081U · Substantial damageNTSB CEN10FA509Accident · 3 fatalField investigationFinal reportBell Helicopter Textron 206L-1 · Walnut Grove, ARThe pilot’s loss of aircraft control, due to spatial disorientation, resulting in the in-flight separation of the main rotor and tail boom.Aug 31, 2010 · N62AE · Substantial damageNTSB CEN10LA497Accident · 1 fatalLimited investigationFinal reportMiller Charles W Vans RV-7A · El Dorado, ARThe pilot's failure to maintain clearance with trees on takeoff at night. Contributing factors were fatigue and the pilot's lack of recent nighttime experience.Aug 20, 2010 · N474JM · Substantial damageNTSB CEN10CA357Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 77A · Harrison, ARThe pilot’s failure to maintain control of the balloon during landing.Jun 27, 2010 · N60029 · Minor damageNTSB CEN10FA310Accident · 1 fatalField investigationFinal reportAir Tractor AT602 · Knobel, ARThe pilot did not maintain control of the airplane while maneuvering at low altitude.Jun 7, 2010 · N4184P · Substantial damageNTSB CEN10LA243Accident · No injuriesLimited investigationFinal reportMooney M20G · Benton, ARThe pilot's failure to maintain directional control of the airplane during the aborted takeoff.May 8, 2010 · N9221V · Substantial damageNTSB CEN10LA165Accident · 1 fatalLimited investigationFinal reportWalsh Philip J SEA REY · Huntsville, ARThe pilot's loss of airplane control for undetermined reasons.Mar 18, 2010 · N100JW · Substantial damageNTSB CEN10FA114Accident · 4 fatalField investigationFinal reportBeech A36 · Winslow, ARThe instrument-rated pilot's spatial disorientation and subsequent loss of airplane control during flight in instrument meteorological and conditions favorable for structural icing.Feb 6, 2010 · N1085D · Substantial damage