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 CHI03LA273Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T660 · Blytheville, ARThe pilot's inadequate visual lookout and altitude/clearance not being maintained from the transmission wires. A factor to the accident was the transmission wires.NTSB CHI03LA253Accident · No injuriesLimited investigationFinal reportCessna 140 · Morrilton, ARThe deterioration of the fuel line resulting in fuel contamination and the loss of engine power.NTSB FTW03LA195Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A340-300 · Walnut Ridge, ARThe flight crew's inadequate evaluation of the weather and their decision to continue the along the route of flight resulting in an encouter with severe turbulence. Contributing factors were the captain's instructions to continue food servicing in the cabin,…NTSB CHI03LA245Accident · No injuriesLimited investigationFinal reportCessna 150L · Pine Bluff, ARInadequate preflight planning which resulted in fuel exhaustion during the cross country flight. A factor associated with the accident was the rough terrain encountered during the forced landing.NTSB CHI03LA230Accident · No injuriesLimited investigationFinal reportMurch Rotec Rally 3 · Searcy, ARThe frayed rudder cable that failed during the turn to final. A factor was the ditch the airplane encountered during the forced landing.NTSB FTW03LA187Accident · No injuriesLimited investigationFinal reportMikoyan MIG-15BIS · Little Rock, ARThe loss of engine power during takeoff for undetermined reasons.NTSB CHI03LA174Accident · No injuriesLimited investigationFinal reportCessna A188B · McGehee, ARThe pilot's failure to maintain directional control of the airplane during landing. Contributing factors to the accident were the tailwind condition, the pilot's selection of the wrong runway on which to land and the ditch.NTSB CHI03LA200Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Fort Smith, ARThe loss of engine power for undetermined reasons during the climb out. A factor was the ditch encountered during the forced landing.NTSB CHI03LA189Accident · Serious injuriesLimited investigationFinal reportBowers Fly Baby · Altus, ARA loss of engine power for undetermined reasons. Factors associated with the accident were the tree and evasive maneuver performed during the forced landing.NTSB CHI03LA180Accident · No injuriesLimited investigationFinal reportCessna 170B · Widener, ARThe pilot's failure to maintain clearance from the wires and his failure to maintain adequate airspeed, resulting in a stall. A factor contributing to the accident was the unmarked wires.NTSB CHI03LA175Accident · No injuriesLimited investigationFinal reportCessna 210M · Carlisle, ARThe pilot's improper in-flight decision to descend for landing, at night, without the runway environment insight. Contributing factors were the pilot's disorientation, the embankment and the dark night condition.NTSB CHI03LA176Accident · No injuriesLimited investigationFinal reportAllied Ag Cat Productions G-164B · Dyess, ARThe loose fittings on the bleed air system which resulted in a loss of engine power, and the unsuitable terrain encountered during the forced landing. Factors to the accident were the watery and the muddy conditions and the inadequate fastening of the bleed…NTSB CHI03LA171Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Marked Tree, ARThe pilot's failure to maintain clearance with the wire. Contributing factors were the low altitude flight/maneuver and the static wire.NTSB CHI03LA164Accident · No injuriesLimited investigationFinal reportMcCulloch J-2 · Magnolia, ARThe pilot's inadequate weight a balance calculations and inadequate preflight planning.NTSB CHI03LA156Accident · No injuriesLimited investigationFinal reportDromader M-18 · Dumas, ARThe pilot's delay in aborting the takeoff and his intentional maneuver to avoid the obstruction at the end of the runway. Contributing factors were the road and ditch.NTSB CHI03LA155Accident · No injuriesLimited investigationFinal reportSesin EXEC90 · Searcy, ARThe unqualified maintenance performed by the pilot and the inadequate autorotation by the pilot. A factor contributing to this accident was the overtemperature of the engine cooling system.NTSB CHI03LA148Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Reydell, ARThe pilot's failure to maintain directional control during initial climb.NTSB FTW03LA159Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Palestine, ARThe shearing of the torsion shaft which resulted in a loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA142Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Needham, ARThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03FA114Accident · 1 fatalField investigationFinal reportCessna 182S · Fayetteville, ARThe pilot's failure to fly a stabilized, published instrument approach procedure, which resulted in a collision with trees and terrain. Factors were the low clouds and night conditions.NTSB FTW03LA109Accident · No injuriesLimited investigationFinal reportCessna 150G · Hope, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03FA111Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Prattsville, ARThe pilot's execution of VFR flight into IMC and his failure to maintain obstacle clearance. Fog conditions and the pilot's lack of an instrument rating are contributing factors.NTSB FTW03LA110Accident · No injuriesLimited investigationFinal reportCessna 177A · England, ARThe pilot's failure to refuel the airplane while searching for a private grass airstrip, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA098Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Holly Grove, ARThe pilot's failure to abort the takeoff.NTSB FTW03LA094Accident · No injuriesLimited investigationFinal reportCessna 210L · Morrilton, ARThe failure of the main landing gear to extend and lock, as a result of a hydraulic fluid leak caused by a chaffed and ruptured flex line.NTSB FTW03LA079Accident · No injuriesLimited investigationFinal reportCessna 172S · Springdale, ARThe pilot's failure to maintain directional control while landing. A contributing factor was the prevailing crosswind.NTSB FTW03LA078Accident · No injuriesLimited investigationFinal reportChampion 7FC · Springdale, ARThe pilot's failure to maintain directional control while landing. A contributing factor was the prevailing crosswind.NTSB FTW03FA064Accident · 1 fatalField investigationFinal reportBeech BE-58 · Egypt, ARThe pilot's inadvertent flight into severe icing conditions. A contributing factor was the pilot's inadequate preflight planning.NTSB FTW03LA074Accident · No injuriesLimited investigationFinal reportCessna 170A · West Helena, ARThe pilot's failure to maintain directional control during landing. A contributing factor was the deflated tire.NTSB FTW03FA059Accident · 3 fatalField investigationFinal reportBeech 1900C · Eagleton, ARIn-flight collision with terrain due to the pilot's failure to maintain clearance and altitude above rapidly rising terrain while on a VFR approach. Contributing factors were the obscuration of the terrain due to clouds.NTSB DEN03FA023Accident · 1 fatalField investigationFinal reportRockwell Commander 114 · Hot Springs, ARthe loss of engine power due to the failure of the engine ignition system's single-drive dual-magneto, and the magneto's improper installation by unknown maintenance personnel. Contributing factors were the improper installation of the magneto by unknown…NTSB FTW03FA057Accident · 1 fatalField investigationFinal reportCessna 210L · Harrison, ARThe pilot's failure to maintain control of the aircraft and the exceedance of the manufactured limits, which resulted in an in flight break-up. Contributing factors were the dark night conditions and the clouds.NTSB FTW03LA052Accident · No injuriesLimited investigationFinal reportShepherd Kolb Mark III · Norfork, ARThe loss of engine power due to fuel contamination. Contributing to the accident were the trees.NTSB FTW03LA050Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Weiner, ARThe loss of engine power due to a compressor stall for undetermined reasons. A contributing factor was the soft terrain.NTSB FTW03LA039Accident · Serious injuriesLimited investigationFinal reportLarson Kitfox III · Little Rock, ARThe pilot's failure to maintain aircraft control during an intentional taxi resulting in the inadvertent lift-off of the airplane and subsequent inadvertent stall. Contributing factors were the pilot's lack of total experience in the make and model of…NTSB FTW03LA026Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Marshall, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA023Accident · No injuriesLimited investigationFinal reportBeech A23 · Farmington, ARThe loss of engine power due to the failure of the mechanical fuel pump.NTSB FTW03FA016Accident · 6 fatalField investigationFinal reportPiper PA-32-301 · Paron, ARThe pilot's failure to maintain altitude/clearance from terrain. Contributing factors were the low ceiling, the pilot's decision to fly in known adverse weather conditions, and his lack of an instrument rating.NTSB FTW03LA010Accident · No injuriesLimited investigationFinal reportBeech K35 · Flippin, ARThe pilot's selection of an unsuitable landing area. A contributing factor was the pilot's disorientation.NTSB FTW03FA008Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Lakeview, ARthe pilot's failure to maintain clearance with the terrain while maneuvering.NTSB FTW03FA003Accident · 1 fatalField investigationFinal reportSocata TB-20 · Texarkana, ARThe inadvertamt stall by the student pilot, and the inadequate supervision by the flight instructor.NTSB FTW03LA004Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400 · Marmaduke, ARThe pilot's failure to maintain aircraft control. A contributing factor was the towering cumulus in all quadrants.NTSB FTW02LA264Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Edmondson, ARThe pilot's failure to maintain clearance from the high voltage power lines.NTSB FTW02LA253Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Rector, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB FTW02LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bella Vista, ARThe binding throttle control cable, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Omaha, ARthe pilot's failure to maintain adequate airspeed during the go-around resulting in an inadvertent stall. A contributing factor was haze.NTSB FTW02LA183Accident · Serious injuriesLimited investigationFinal reportBeech V35A · Leslie, ARThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA176Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Dover, ARThe pilot's failure to maintain clearance with trees during the approach. A contributing factor was dark night light conditions.NTSB FTW02LA172Accident · No injuriesLimited investigationFinal reportBeech BE-100-A100 · Little Rock, ARThe malfunction of the left main landing gear retraction/extension assembly due to a missing lock pin/washer/nut on the clevis of the push/pull gear extension tube that resulted from improper maintenance.NTSB FTW02LA168Accident · No injuriesLimited investigationFinal reportErcoupe ERCO-415-E · Conway, ARThe loss of engine power for undetermined reasons. Factors were the pilots necessity to avoid a power line during the emergency descent and the lack of suitable terrain for the forced landing.