NTSB investigations, 2018, AR

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

Cases per year

20082026
NTSB investigations, 2018, 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\") = 2018
    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 CEN18LA347Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Little Rock, ARThe total loss of engine power for reasons that could not be determined based on the available evidence, which resulted in a forced landing on unsuitable terrain.Aug 22, 2018 · N7954W · Substantial damageNTSB GAA18CA465Accident · No injuriesData collectionFinal reportBellanca 8GCBC · El Dorado, ARThe pilot's improper fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Jul 27, 2018 · N391KM · Substantial damageNTSB CEN18LA274Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lakeview, ARThe student pilot’s impairment by alcohol and multiple medications, which led to his failure to maintain obstacle clearance during takeoff and the subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and…Jul 12, 2018 · N50183 · Substantial damageNTSB CEN18FA263Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Wheatley, ARThe pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available evidence.Jul 11, 2018 · N8508P · DestroyedNTSB GAA18CA365Accident · No injuriesData collectionFinal reportCraig A Reed Starduster II · Morrilton, ARThe pilot’s loss of directional control during an aborted landing.Jun 19, 2018 · N969TM · Substantial damageNTSB CEN18LA223Accident · Serious injuriesClass 3 · LimitedFinal reportAeronca 7BCM · Eureka Springs, ARThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power after takeoff for undetermined reasons, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.Jun 14, 2018 · N9098C · Substantial damageNTSB CEN18LA211Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Parkin, ARThe improper operation of the rudder pedal adjustment mechanism for an undetermined period of time, which led to the failure of the rudder pedal adjustment track, the detachment of the rudder pedal, and the pilot’s subsequent inability to maintain directional…May 31, 2018 · N6215P · Substantial damageNTSB GAA18CA265Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Truman, ARThe pilot’s failure to see and avoid a pole during an agricultural application flight.May 4, 2018 · N4170S · Substantial damage