Fatal NTSB investigations, AR
33 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 3 |
|---|---|
| 2010 | 4 |
| 2011 | 4 |
| 2012 | 1 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 5 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 3 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'AR' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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.
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 c."eventStateOrRegion" = 'AR' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN24FA179Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Marianna, ARThe pilot’s exceedance of the airplane’s design limitations, which resulted in an in-flight breakup.NTSB CEN23FA167Accident · 1 fatalClass 3 · FieldFinal reportTitan Tornado · Lewisville, ARThe non-certificated pilot’s failure to maintain airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.NTSB CEN23FA113Accident · 5 fatalClass 3 · FieldFinal reportBeech B200 · Little Rock, ARThe loss of control during initial climb for undetermined reasons. Contributing to the accident were the sudden wind shifts during the initial climb.NTSB ERA22FA338Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Portland, ARThe failure of both pilots to see and avoid the other airplane during aerial application and ferry operations.NTSB CEN22FA082Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Hardy, ARThe non-instrument rated pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was a loss of engine power due to fuel…NTSB CEN22LA024Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150L · Forrest City, ARThe pilot’s loss of control during landing. Contributing to the pilot’s injuries was his ejection from the airplane resulting from him not wearing his available seat restraints.NTSB CEN21FA270Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor 502B · Paragould, ARAn inflight loss of control and subsequent impact with terrain during an aerial application flight for reasons that could not be determined based on the available evidence.NTSB CEN19FA332Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Prairie Grove, ARThe noninstrument-rated pilot's loss of control due to spatial disorientation after encountering instrument meteorological conditions at night.NTSB 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.NTSB CEN17FA259Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Cash, ARThe pilot's incapacitation due to a cardiac event, which resulted in a loss of airplane control.NTSB CEN17FA071Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · Gurdon, ARThe loss of control in flight for reasons that could not be determined because of the severe impact and postcrash fire damage to the airplane and the lack of information about the airplane emergency that the pilot was experiencing.NTSB CEN16LA347Accident · 1 fatalLimited investigationFinal reportHaggenmacher Bensen · Bryant, ARThe pilot’s loss of gyroplane control during an intentional high-speed pass, which resulted in the gyroplane porpoising and impacting terrain. Contributing to the accident was the pilot’s decision to conduct the flight in an aircraft in which he had little…NTSB CEN16LA312Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance from a transmission line while maneuvering at low altitude.NTSB CEN16FA210Accident · 1 fatalField investigationFinal reportCessna 175 · Pine Bluff, ARA loss of engine power during cruise flight for reasons that could not be determined because a test run of the engine did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation. Contributing to the accident were the…NTSB CEN16LA182Accident · 1 fatalLimited investigationFinal reportBell 47G 3B 1 · Portia, ARThe pilot's decision to perform a sliding takeoff from the elevated platform, which resulted in a dynamic rollover when the right skid plate caught on a protruding screw. Contributing to the accident was the pilot's failure to adequately inspect the landing…NTSB CEN16FA172Accident · 1 fatalField investigationFinal reportCessna 310F · North Little Rock, ARThe pilot's failure to promptly feather the left propeller upon the initial loss of engine power shortly after takeoff and his failure to maintain airspeed while maneuvering with one engine inoperative, which resulted in a loss of control at a low altitude.…NTSB CEN15LA367Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-802A · Wiville, ARThe pilot's failure to maintain clearance from a utility pole while maneuvering during an agricultural application flight, which resulted in damage to the right aileron and a subsequent uncontrolled right roll at a low altitude.NTSB CEN14GA135Accident · 1 fatalFinal reportCessna 210E · Oden, ARThe pilot’s improper decision to fly into an area with reported marginal meteorological conditions in an airplane not maintained for instrument flight and his subsequent failure to maintain clearance from trees and terrain.NTSB CEN14FA035Accident · 2 fatalField investigationFinal reportBeech C90 · Springdale, ARA total loss of power to both engines due to fuel exhaustion. Also causal were the pilot’s reliance on the fuel totalizer rather than the fuel quantity gauges to determine the fuel on board and his improper fuel planning.NTSB CEN14FA014Accident · 2 fatalField investigationFinal reportPiper PA 32R-301 · Huntsville, ARThe noninstrument-rated pilot’s continued flight into an area of known rain with reduced visibility and his failure to maintain airplane control while maneuvering the airplane after entering these conditions.NTSB CEN13LA237Accident · 1 fatalLimited investigationFinal reportAlon A2 · Greenbrier, ARThe pilot's improper recovery from a bounced landing and porpoise. Contributing to the accident were the pilot's limited recent flying experience and proficiency and the challenging runway environment.NTSB CEN13LA054Accident · 1 fatalLimited investigationFinal reportCessna P210N · Conway, ARThe pilot's inadequate preflight inspection, which failed to detect the lack of fuel and resulted in fuel exhaustion during climb, and the pilot's subsequent failure to maintain airplane control, which resulted in an aerodynamic stall at low altitude from…NTSB CEN12FA072Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Perryville, ARThe pilot's loss of control in flight.NTSB CEN11FA467Accident · 1 fatalField investigationFinal reportRans S-12 · Scott, ARThe pilot’s loss of airplane control, likely due to a cardiac event.NTSB CEN11FA285Accident · 1 fatalField investigationFinal reportHawker-Beechcraft E-55 · De Queen, ARThe pilot’s loss of control during takeoff for undetermined reasons.NTSB CEN11FA244Accident · 2 fatalField investigationFinal reportCessna 182M · Hot Springs, ARA total loss of engine power for undetermined reasons.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.NTSB 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.NTSB CEN10FA316Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Umpire, ARThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation.NTSB 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.NTSB DEN08FA122Accident · 2 fatalField investigationFinal reportHughes 269B · Salesville, ARThe pilot's failure to maintain clearance from the crossing transmission line.NTSB DFW08LA161Accident · 1 fatalLimited investigationFinal reportCessna 150M · Forrest City, ARThe failure of the pilot to maintain adequate airspeed while maneuvering in the traffic pattern, resulting in an inadvertent aerodynamic stall.NTSB DFW08LA143Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Wheatley, ARThe pilot's failure to maintain airspeed, resulting in an inadvertent low-altitude aerodynamic stall.