NTSB investigations, 2010, AR

13 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2010, AR per year, 2008–2026: 151 cases
200812
20094
201013
201111
201213
201315
201412
201511
201613
20177
20188
20196
20203
20215
20222
20237
20245
20252
20262

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\" = '470' 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 CEN11CA011Accident · Minor injuriesData collectionFinal reportCessna 175C · Humphrey, ARThe pilot’s failure to maintain clearance from a static wire while maneuvering at a low altitude.Oct 8, 2010 · N8323T · Substantial damageNTSB CEN11CA006Accident · No injuriesData collectionFinal reportRockwell International S-2R · Texarkana, ARThe loss of engine power due to cracked engine cylinder.Oct 5, 2010 · N8432V · Substantial damageNTSB CEN10CA582Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Atkins, ARA partial loss of engine power during low-altitude flight for undetermined reasons.Sep 17, 2010 · N2309F · Substantial damageNTSB 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 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 CEN10LA492Accident · Serious injuriesLimited investigationFinal reportInfinity Infinity · Little Rock, ARThe failure of the control lanyard for undetermined reasons.Aug 12, 2010 · N208FA · Substantial damageNTSB CEN10CA436Accident · Minor injuriesData collectionFinal reportCessna 310C · Ashdown, ARThe pilot’s loss of directional control during the takeoff roll and his lack of experience in the airplane.Jun 24, 2010 · N18RR · Substantial damageNTSB CEN10CA332Accident · No injuriesData collectionFinal reportPiper J3C-65 · Hot Springs, ARA total loss of engine power due to fuel starvation as a result of the pilot's inadvertent closure of the fuel valve. Contributing to the accident were the unmarked fuel shutoff valve and the pilot's inexperience in the accident airplane.Jun 14, 2010 · N70906 · Substantial damageNTSB CEN10FA316Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Umpire, ARThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation.Jun 13, 2010 · N6076H · Substantial damageNTSB CEN10CA265Accident · No injuriesData collectionFinal reportAyres S2R-R1340 · Roe, ARThe pilot's decision to take off with a tailwind, resulting in a runway overrun.May 21, 2010 · N107CA · Substantial damageNTSB CEN10LA245Accident · Minor injuriesLimited investigationFinal reportGross Cozy · Pine Bluff, ARThe inadvertent opening of the cockpit canopy during cruise flight for undetermined reasons, which allowed debris to impact and damage the pusher propeller with a resulting total loss of engine power.May 9, 2010 · N144TJ · 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 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