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 FTW00LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Gould, ARThe stall/mush encountered by the pilot. A factor was the crosswind.NTSB FTW00LA121Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Fayetteville, ARThe failure of the inboard half of the right main landing gear wheel as a result of fatigue.NTSB FTW00FA113Accident · 2 fatalField investigationFinal reportVans RV-6T · Pettigrew, ARthe pilot's continued flight into known adverse weather and his failure to maintain obstacle clearance. Contributing factors were adverse weather conditions, and the pilot's disregard for the forecasted adverse weather.NTSB FTW00LA097Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Gillett, ARThe cracked #8 cylinder resulting in failure of the cylinder. A factor was the plowed/furrowed terrain.NTSB FTW00LA090Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Manilla, ARThe pilot's performance of low altitude flight and his failure to maintain clearance with the power lines.NTSB FTW00LA078Accident · No injuriesLimited investigationFinal reportSwearingen SA-227-AT · Fayetteville, ARThe flight crew's failure to extend the landing gear. Contributing factors were the flight crew's non-compliance with the checklist, the pilot-in-command's diverted attention as a result of the loss of instrument approach/runway lighting, the partial failure…NTSB FTW00FA063Accident · 1 fatalField investigationFinal reportCessna 152 · Carlisle, ARthe pilot's failure to maintain aircraft control.NTSB FTW00LA067Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Corning, ARThe loss of engine power for an undetermined reason. A factor was the dark night light condition.NTSB FTW00LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlisle, ARThe loss of engine power as a result of excessively fouled spark plugs. A factor was the soft terrain during the forced landing.NTSB FTW00LA026Accident · No injuriesLimited investigationFinal reportWaco KNF · Midway, ARThe inability of the pilot to maintain control of the airplane as a result of a downdraft.NTSB FTW00LA016Accident · Minor injuriesLimited investigationFinal reportBellanca 7ACA · No. Little Rock, ARThe pilot's delay in aborting the takeoff. A factor was the partial loss of engine power for an undetermined reason.NTSB FTW00LA014Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Jonesboro, ARThe flight instructor's delay in taking remedial action to recover from a low rotor rpm situation. A factor was the student's failure to maintain adequate rotor rpm.NTSB FTW00LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Village, ARThe pilot's failure to obtain/maintain directional control during landing.NTSB FTW00LA006Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M18 · Weldon, ARThe cause of the accident was undetermined.NTSB FTW00LA002Accident · No injuriesLimited investigationFinal reportCessna 210L · Fayetteville, ARThe cause of the right main gear collapse was undetermined. A factor was the failure of the gear 'down & locked' switch resulting in a false 'down & locked' indication in the cockpit.NTSB FTW99LA263Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ozark, ARThe pilot's delay in aborting the takeoff, which resulted in a runway overrun. A factor was the wet grass runway.NTSB FTW99LA260Accident · No injuriesLimited investigationFinal reportCessna 172K · Mountain Home, ARThe pilot's failure to obtain runway alignment. Factors were the dark night conditions, an embankment, and the pilot's lack of total experience flying at night.NTSB FTW99LA258Accident · No injuriesLimited investigationFinal reportCessna 172RG · Fort Smith, ARThe failure of the electric pump motor/hydraulic power pack resulting in the collapse of the right main landing gear upon landing.NTSB FTW99LA243Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Jonesboro, ARThe pilot's misjudgment of distance/altitude during the final approach to landing, resulting in an undershoot, and collision with a power line pole.NTSB FTW99LA236Accident · Minor injuriesLimited investigationFinal reportAeronca 7DC · Helena, ARThe student pilot's failure to maintain clearance from a tree. A factor associated with the accident was the pilot's low altitude.NTSB FTW99LA245Accident · No injuriesLimited investigationFinal reportCessna 150K · Springdale, ARThe inadequate visual lookout by both pilots.NTSB FTW99LA234Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Russellville, ARThe improper touchdown by the flight instructor.NTSB FTW99LA231Accident · Minor injuriesLimited investigationFinal reportAlon A-2A · Cabot, ARThe missing engine oil filler cap which resulted in the loss of engine power as a result of oil starvation. Factors were the pilot's improper aircraft preflight inspection and the lack of suitable terrain for the forced landing.NTSB FTW99LA225Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Dermott, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA220Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Humphrey, ARFuel exhaustion as a result of the pilot's failure to refuel the airplane.NTSB FTW99LA219Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5A · Wayton, ARThe pilot's inadequate compensation for wind conditions, and his failure to maintain clearance with trees during a go-around. Factors were the gusty wind condition, and the high density altitude. Factors associated with the accident were gusty winds, and a…NTSB FTW99LA213Accident · No injuriesLimited investigationFinal reportCessna 172N · Hot Springs, ARthe pilot's failure to refuel the airplane which resulted in fuel exhaustion and a total loss of engine power. A factor was the lack of suitable terrain for a forced landing.NTSB FTW99FA201Accident · 1 fatalField investigationFinal reportAerospatiale ATR-42-500 · Little Rock, ARThe station manager's inadvertent encounter with the rotating propeller due to his diverted attention.NTSB FTW99LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Heber Springs, ARThe pilot's excessive approach airspeed resulting in the airplane overrunning the runway, and his failure to maintain aircraft control during the landing roll.NTSB FTW99LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvel, ARThe pilot's failure to attain the proper takeoff airspeed.NTSB FTW99LA188Accident · No injuriesLimited investigationFinal reportBeech C35 · Jonesboro, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors were the prevailing tailwind, and the airplane's over gross weight condition.NTSB FTW99LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Pocahontas, ARThe failure of the carburetor heat control cable which resulted in a partial loss of engine power during initial takeoff climb. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA175Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cabot, ARThe flight instructor's failure to attain the proper touchdown point during the landing.NTSB FTW99FA171Accident · 1 fatalField investigationFinal reportHeilig-Reading Emeraude CP 301A · Altus, ARThe pilot's failure to maintain clearance with a wire, during an approach to a private airstrip.NTSB FTW99LA169Accident · No injuriesLimited investigationFinal reportCessna 414 · Springdale, ARThe failure of the right main landing gear torque tube support bracket/pivot bearing which resulted in the failure of the landing gear locking mechanism.NTSB FTW99LA167Accident · No injuriesLimited investigationFinal reportCessna 172D · Jonesboro, ARThe pilot's inadequate preflight planning and preparation, and her delayed aborted takeoff. Factors were the high density altitude and the tall grass on the airstrip.NTSB FTW99LA161Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 · Dewitt, ARThe pilot's inadvertent flight into adverse weather, which resulted in a loss of aircraft control. A factor was the downdraft weather condition.NTSB DCA99MA060Accident · 11 fatalClass 1 · MajorFinal reportMcDonnell Douglas MD-82 · Little Rock, ARThe flight crew's failure to discontinue the approach when severe thunderstorms and their associated hazards to flight operations had moved into the airport area and the crew's failure to ensure that the spoilers had extended after touchdown. Contributing to…NTSB FTW99LA158Accident · No injuriesLimited investigationFinal reportCessna 210K · Mountain View, ARThe pilot's failure to maintain control during the landing flare/touchdown. Factors were the pilot's delay in aborting the landing and the fence post.NTSB FTW99LA152Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Cherry Valley, ARThe pilot's inadvertent stall due to his evasive maneuver to avoid colliding with a truck on the runway. A factor was the runway incursion by the truck.NTSB FTW99FA150Accident · 1 fatalField investigationFinal reportGrumman-Schweizer G164-B · Brinkley, ARThe pilot's inadvertent VFR flight into instrument meteorological conditions. Contributing factors were the pilots failure to maintain control of the aircraft, spatial disorientation, and the fog.NTSB FTW99FA148Accident · 1 fatalField investigationFinal reportBeech C18S · Waldron, ARthe separation of a propeller blade in cruise flight as a result of fatigue cracking emanating from surface corrosion pitting.NTSB FTW99FA143Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Rose Bud, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall.NTSB FTW99LA126Accident · No injuriesLimited investigationFinal reportBeech J35 · Bass, ARThe pilot's failure to maintain aircraft directional control during landing roll on a gravel road. Factors were the clouds and low ceilings, the low fuel status, and the gravel road condition.NTSB FTW99LA125Accident · Serious injuriesLimited investigationFinal reportOakes J3 CUB · Greenbriar, ARThe student pilot's failure to compensate for the gusty wind condition while maneuvering, which resulted in the inadvertent stall. A factor was the gusty wind condition.NTSB FTW99LA124Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Hickory Ridge, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall/spin.NTSB FTW99LA117Accident · No injuriesLimited investigationFinal reportCessna 170B · Fayetteville, ARThe pilot's failure to obtain the proper climb rate resulting in an inadvertent stall. Factors were the rising terrain and the variable winds.NTSB FTW99LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Sheridan, ARThe pilot's excessive landing approach speed and his failure to attain the proper touchdown point which resulted in a runway overrun.NTSB FTW99LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · Turrell, ARThe total loss of engine power as the result of improper maintenance which led to the number one cylinder intake valve rocker assembly stud bolt backing out rendering the valve inoperative. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99FA104Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Waldron, ARThe pilot's encounter with adverse weather and loss of aircraft control, which resulted in exceeding the aircraft's design stress limits. Factors were the pilot's lack of total experience in the make and model of airplane, and the icing and thunderstorm…