NTSB investigations, AR
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 CEN21FA364Accident · 1 fatalClass 3 · FieldFinal reportCessna 210H · Melbourne, ARThe pilot’s failure to maintain control of the airplane with full flaps during the takeoff.NTSB CEN21LA296Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Hoxie, ARThe pilot’s failure to ensure an adequate fuel supply for the intended flight.NTSB CEN21LA287Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Sedgwick, ARThe total loss of engine power due to the failure and disengagement of the torque sensor assembly front spur gear from its splined shouldered shaft due to a loose self-locking nut.NTSB CEN21FA277Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR20 · Conway, ARThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall and spin. Contributing to the accident was the failure of the pilot to perform an adequate preflight inspection, to include removal of the pitot tube cover.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 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 CEN21LA231Accident · No injuriesClass 3 · LimitedFinal reportCessna 150J · Madison, ARThe pilot’s improper fuel planning which led to fuel exhaustion, and a total loss of engine power.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 CEN21LA161Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Dumas, ARThe failure of both pilots to see and avoid the other airplane.NTSB CEN21LA107Accident · 2 fatalClass 3 · LimitedFinal reportHawker Beechcraft G58 · Credit, ARA loss of left engine power for undetermined reasons, which resulted in an emergency descent with one engine inoperative and inadvertent collision with transmission lines. Contributing to the accident was the pilot’s inability to respond appropriately to the…NTSB CEN21LA070Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA38 · Franklin, ARThe impairment of both pilots from carbon monoxide exposure due to a degraded muffler. Contributing to the accident was the inadequate maintenance inspection, which failed to detect the degraded muffler.NTSB CEN21LA005Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT402 · Egypt, ARThe pilot’s failure to maintain clearance from a tree limb during a low-level aerial application flight.NTSB CEN20LA430Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46R-350T · Rogers, ARThe pilot’s inadvertent loss of aircraft control, resulting in substantial damage to the airframe during the spin recovery.NTSB CEN20CA391Accident · Minor injuriesClass 4 · Data collectionFinal reportChampion 8GCBC · Ozark, ARThe pilot's failure to maintain clearance from a wire during final approach to landing.NTSB CEN20LA379Accident · 4 fatalClass 3 · LimitedFinal reportCirrus SR22 · Chester, ARThe noninstrument-rated pilot’s continued flight into dark night instrument meteorological conditions which resulted in spatial disorientation and a subsequent loss of airplane control.NTSB CEN20LA357Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT802 · Dell, ARThe pilot’s failure to maintain airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and collision with terrain.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 CEN20CA351Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Conway, ARThe pilot’s improper recovery from a bounced landing.NTSB CEN20CA349Accident · No injuriesClass 4 · Data collectionFinal reportCessna T206 · Bentonville, ARThe pilot's misjudgment of the landing flare which resulted in a bounced landing.NTSB CEN20CA303Accident · No injuriesClass 4 · Data collectionFinal reportStearman N2S 3 · Jacksonville, ARThe pilot's failure to adequately monitor his fuel quantity during flight, which resulted in fuel exhaustion and a total loss of engine power.NTSB CEN20LA287Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Des Arc, ARA total loss of engine power for reasons that could not be determined from all available evidence.NTSB CEN20LA269Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Weldon, ARThe total loss of engine power during cruise flight for reasons that could not be determined based on the available evidence.NTSB CEN20LA234Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT402 · Pine Bluff, ARThe pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and a loss of airplane control. Contributing was a partial loss of engine power for undetermined reasons.NTSB CEN20CA205Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Lakeview, ARThe pilot’s failure to maintain control of the airplane during the takeoff.NTSB CEN20LA109Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Dumas, ARThe pilot’s failure to maintain clearance from a power line pole during a low-level aerial application flight, which resulted in impact with the bracket and a subsequent forced landing.NTSB CEN20LA078Accident · Serious injuriesClass 3 · LimitedFinal reportNavion Navion · Fort Smith, ARThe inadequate inspection of the fuel selector valve, which was degraded, allowed fuel to leak, and resulted in fuel starvation and a loss of engine power.NTSB GAA20CA064Accident · Minor injuriesData collectionFinal reportNew Glasair Sportsman GS-2 · Huntsville, ARThe pilot's failure to maintain proper pitch control during takeoff from a muddy, turf runway and his exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an 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 CEN19FA248Accident · 1 fatalClass 3 · FieldFinal reportCessna 310 · De Queen, ARA loss of control for reasons that could not be determined based on the available information.NTSB CEN19LA222Accident · Serious injuriesClass 3 · LimitedFinal reportStinson 108 · Clinton, ARA partial loss of engine power for undetermined reasons.NTSB CEN19LA194Accident · No injuriesClass 3 · LimitedFinal reportBeech A23 · Fort Smith, ARA total loss of engine power due to fuel starvation as a result of the flight instructor's fuel mismanagement.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 CEN19FA160Accident · 3 fatalClass 3 · FieldFinal reportRobinson R44 · Cass, ARA loss of engine power for reasons that could not be determined based on the available information.NTSB GAA19CA304Accident · No injuriesData collectionFinal reportPiper PA32R · Flippin, ARThe airplane’s collision with deer during the landing and the airport’s failure to provide an adequate barrier to prevent wildlife from entering the runway environment despite previous deer strikes.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 CEN19LA146Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S76 · Morrilton, ARThe improper securing of the exhaust duct bolts, which resulted in the duct becoming unseated and substantial heat damage to the tail rotor drive shaft.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 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 GAA19CA177Accident · Minor injuriesData collectionFinal reportChampion 7EC · Fayetteville, ARThe pilot's exceedance of the airplane's critical angle of attack during takeoff as he attempted to avoid power lines, which resulted in an aerodynamic stall.NTSB CEN19FA020Accident · 1 fatalClass 2 · FieldFinal reportHughes 369 · McDougal, ARThe pilot's failure to maintain the helicopter's clearance from the powerline structure while hovering in gusty wind conditions, which resulted in an inadvertent collision with the structure and an uncontrolled descent into terrain.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 GAA18CA549Accident · Minor injuriesData collectionFinal reportAviat A1 · Bentonville, ARThe pilot’s exceedance of the airplane’s critical angle of attack during an attempted go-around after the airplane bounced, which resulted in an aerodynamic stall.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 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.NTSB GAA18CA442Accident · No injuriesData collectionFinal reportChampion 7GC · Warren, ARThe pilot’s failure to maintain directional control during landing.NTSB 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…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 CEN18LA241Accident · No injuriesLimited investigationFinal reportCessna T210 · Pocahontas, ARThe pilot's excessive use of wheel brakes while landing, which resulted in both brakes locking up, a loss of directional control, a runway excursion, and a nose over.NTSB GAA18CA365Accident · No injuriesData collectionFinal reportCraig A Reed Starduster II · Morrilton, ARThe pilot’s loss of directional control during an aborted landing.