NTSB investigations, AR
22 cases where NTSB found Terrain.
Cases per year
| 2008 | 3 |
|---|---|
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 1 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 2 |
Where
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 c.\"eventStateOrRegion\" = 'AR' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030210'))
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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030210')) 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 CEN24LA313Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Dyess, ARThe improper overhaul of the carburetor and the malfunction of left magneto which resulted in a partial loss of engine power.NTSB CEN24LA145Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20E · Alpine, ARThe improper maintenance of the cabin air and exhaust system which resulted in a cracked exhaust pipe and damaged cabin air tubing, and the subsequent elevated carbon monoxide levels in the cockpit and a forced landing to unsuitable terrain after the pilot…NTSB CEN24LA069Accident · Minor injuriesClass 4 · LimitedFinal reportAero Commander 100 · Texarkana, ARThe pilot’s improper decision to attempt a go-around with full flaps extended, which resulted in decreased climb performance and led to a collision with trees.NTSB CEN23LA212Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Light, ARThe pilot exceeding the climb capability of the airplane during takeoff which led to it settling into the ground.NTSB CEN23LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Osage, ARA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.NTSB CEN22LA364Accident · No injuriesClass 4 · LimitedFinal reportBeechcraft 35 · Star City, ARThe pilot’s delayed decision to abort the takeoff, which resulted in a runway excursion and impact with a ditch.NTSB CEN22FA215Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. G-164 · Whiskerville, ARThe pilot misjudged the approach during the emergency landing, likely due to the full chemical load, and impacted a ditch, resulting in substantial damage and postimpact fire. Contributing to the pilot’s injuries was the lack of a crash-resistant fuel system…NTSB CEN20LA327Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman G164 · Alicia, ARInadequate maintenance of panel fasteners, which led to a side panel coming loose during takeoff and the pilot having to make a subsequent forced landing to a flooded rice field when the airplane became difficult to control.NTSB GAA19CA289Accident · No injuriesData collectionFinal reportAir Tractor AT802 · Fisher, ARThe pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA259Accident · No injuriesData collectionFinal reportCessna 182 · Crossett, ARThe pilot's failure to maintain the runway centerline and his subsequent failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent nose-over.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.NTSB 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…NTSB CEN17LA230Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Delaplaine, ARThe loss of engine power due to fuel exhaustion, which resulted in a forced landing on unsuitable terrain.NTSB GAA16CA266Accident · Minor injuriesData collectionFinal reportCessna 177 · Pine Bluff, ARThe pilot’s failure to maintain adequate airspeed and her exceedance of the airplane’s critical angle-of-attack during a low-altitude turn, which resulted in an aerodynamic stall.NTSB CEN15LA308Accident · Serious injuriesLimited investigationFinal reportDevoe Clip Wing · Melbourne, ARThe loss of engine power for reasons that could not be determined based on the available evidence and the postaccident engine examination, which led to a forced landing on unsuitable terrain due to the pilot’s decision not to deploy the ballistic parachute…NTSB GAA15CA114Accident · No injuriesData collectionFinal reportPiper PA 16 · Tollville, ARThe pilot's failure to maintain directional control during the landing flare, which resulted in the airplane impacting a rice field and nosing over.NTSB CEN14LA298Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Oneida, ARThe pilot’s inadequate fuel management, which resulted in a total loss of engine power at low altitude due to fuel exhaustion and a forced landing in a muddy field and subsequent nose-over.NTSB CEN14CA238Accident · No injuriesData collectionFinal reportAmerican Legend AL-3 · Osage, ARThe pilot's repeated attempts to take off from an unimproved field with tall grass.NTSB CEN13CA021Accident · Minor injuriesData collectionFinal reportPiper PA-18-105 Special · Lonoke, ARThe pilot's failure to maintain directional control during the landing.NTSB CEN09LA054Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Mena, ARThe pilot's failure to maintain clearance from rising terrain. Contributing to the accident was the pilot's continued flight into deteriorating weather conditions.NTSB DEN08CA147Accident · No injuriesData collectionFinal reportPiper PA-22 · Star City, ARThe pilot failed to maintain directional control during landing. Contributing to the accident were the crosswinds and the rough terrain near the runway.NTSB DEN08LA138Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Heber Springs, ARthe improper installation of the PC line on the engine which resulted in a partial loss of engine power. Contributing to the accident was the trees encountered during the forced landing.