NTSB investigations, AR
22 cases where NTSB found Experience/knowledge.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 5 |
| 2013 | 3 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 1 |
| 2026 | 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0203'))
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", '0203')) 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 CEN26LA085Accident · Minor injuriesClass 4 · LimitedFinal reportQuad City Challenger · Greenbrier, ARThe non-certificated pilot's failure to maintain airplane control during the landing.NTSB CEN24FA095Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Little Rock, ARThe pilot’s failure to maintain airplane control after a partial loss of engine power during initial climb. Contributing to the accident was the pilot’s failure to follow airplane flight manual procedures and limitations for the turbocharged engine, which…NTSB CEN24LA040Accident · No injuriesClass 4 · LimitedFinal reportICP Savannah S · Mountain View, ARThe sport pilot’s poor decision to allow a noncertificated pilot to land the airplane which resulted in a loss of control during landing.NTSB CEN23LA225Accident · No injuriesClass 4 · LimitedFinal reportSkykits Savannah VGW · Flippin, ARThe pilot's loss of directional control during takeoff.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 CEN22LA152Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Ash Flat, ARThe partial loss of engine power during a go-around resulting in an inadvertent entry into an aerodynamic stall. Contributing to the accident was the inexperience of the low-time pilot.NTSB CEN22LA147Accident · No injuriesClass 4 · LimitedFinal reportSikorsky S-76D · Texarkana, ARThe pilot’s failure to maintain adequate clearance during landing on a rooftop helipad.NTSB CEN21FA198Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-46-310P · Danville, ARThe pilot’s improper decision to continue flight in an area of moderate-to-heavy icing conditions, which resulted in exceedance of the airplane’s anti-icing system capabilities, a degradation of aircraft performance, and subsequent aerodynamic stall.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 CEN19LA116Accident · No injuriesClass 3 · LimitedFinal reportBerkey S-6ES · Lafe, ARThe non-certificated pilot's failure to maintain an appropriate glidepath while landing toward the sun, which resulted in impact with vegetation and a subsequent loss of control.NTSB CEN18FA389Accident · 1 fatalClass 2 · FieldFinal reportVans RV 4 · Austin, ARThe pilot's failure to maintain airplane control while maneuvering which resulted in the airplane exceeding its critical angle of attack and an accelerated stall.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 CEN15FA189Accident · 1 fatalField investigationFinal reportCessna 152 · Batesville, ARThe noninstrument-rated pilot's controlled flight into terrain due to an inadvertent encounter with clouds in dark night conditions. Contributing to the accident was the pilot's decision to fly at night in marginal visual meteorological conditions without the…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 CEN13LA342Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Morrilton, ARThe flight instructor's inadequate training and oversight of the student pilot, which resulted in the noncertificated student pilot's loss of control during landing.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 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 CEN10CA377Accident · No injuriesData collectionFinal reportAero Commander 100 · Jacksonville, ARThe pilot's failure to maintain an appropriate approach speed and his delayed decision not to initiate a go-around. Contributing to the accident was the pilot's lack of experience in the airplane type.NTSB 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.NTSB 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.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 DFW08LA139Accident · No injuriesLimited investigationFinal reportCommander AC-680 · Hope, ARThe pilot's failure to maintain control of the twin-engine airplane while landing. Contributing to the accident were the crosswind and partial loss of power on the right engine.