NTSB investigations, AR
21 cases where the sequence of events included Other weather encounter.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2016 | 2 |
| 2017 | 1 |
| 2019 | 3 |
| 2021 | 3 |
| 2022 | 1 |
| 2023 | 1 |
| 2025 | 1 |
| 2026 | 2 |
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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '400' 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '400' 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 CEN27LA007Accident · No injuriesClass 4 · LimitedInvestigation openKitfox III · Ward, ARNTSB CEN26LA085Accident · Minor injuriesClass 4 · LimitedFinal reportQuad City Challenger · Greenbrier, ARThe non-certificated pilot's failure to maintain airplane control during the landing.NTSB CEN25LA200Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Gibson, ARThe pilot’s loss of control during takeoff due to an encounter with a sudden wind shift.NTSB CEN23LA228Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164 · Saffell, ARThe airplane’s encounter with a dust devil after takeoff, which resulted in a loss of lift, and a subsequent loss of control. Contributing to the accident was the presence of a dust devil in the airplane’s flight path.NTSB CEN22LA174Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Paragould, ARThe student pilot’s failure to maintain directional control during landing which resulted in a ground loop.NTSB CEN21LA471Accident · Serious injuriesClass 4 · LimitedFinal reportJust Highlander · West Cobb, ARThe airplane’s encounter with gusting wind conditions and low-level wind shear on final approach, which resulted in a loss of control, an aerodynamic stall, and a subsequent hard landing.NTSB CEN21LA454Accident · No injuriesClass 4 · LimitedFinal reportKitfox IV · Ozark, ARThe pilot’s inability to maintain altitude after the airplane encountered a downdraft while he intentionally flew at a low-altitude during a practice for a short-takeoff-and-landing flight competition.NTSB CEN21LA240Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT602 · Trumann, ARThe pilot’s failure to review the weather conditions before the flight, which resulted in a loss of directional control during takeoff due to a sudden change in wind direction and speed associated with an approaching thunderstorm.NTSB GAA19CA319Accident · No injuriesData collectionFinal reportPiper PA24 · Weiner, ARThe pilot's failure to maintain directional control during the landing roll on a wet runway, which resulted in a runway overrun and collision with a pole.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 GAA19CA271Accident · No injuriesData collectionFinal reportAyres S 2R · Stuttgart, ARThe pilot's exceedance of the airplane's critical angle of attack while maneuvering during an agricultural application flight, which resulted in an aerodynamic stall.NTSB GAA17CA454Accident · Serious injuriesData collectionFinal reportAir Tractor AT 802 · Trumann, ARThe pilot’s improper decision to continue flight in deteriorating weather conditions, which resulted in collision with the ground.NTSB GAA16CA144Accident · No injuriesData collectionFinal reportCessna 195 · Clinton, ARThe pilot's failure to maintain direction control during the landing roll, which resulted in runway excursion, and collision with a fence.NTSB GAA16CA125Accident · No injuriesData collectionFinal reportSocata Tampico TB 9 · Fort Smith, ARThe pilot's failure to maintain directional control during takeoff in crosswind conditions, which resulted in runway excursion, impact with terrain and an airport sign, and a postimpact fire.NTSB CEN14LA299Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502 · Dell, ARThe pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight in high-density altitude and gusting crosswind conditions.NTSB CEN14CA258Accident · No injuriesData collectionFinal reportAir Tractor AT 802A · Hunter, ARThe pilot's downwind takeoff from a grass airstrip, which resulted in inadequate climb performance and the subsequent impact with terrain.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 CEN12LA386Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Walnut Ridge, ARThe pilot's failure to maintain aircraft control after encountering a whirlwind or dust-devil during the landing flare.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 CEN09CA428Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Reydell, ARThe pilot's inability to maintain control of the airplane when it unexpectedly encountered a whirlwind shortly after takeoff.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.