NTSB investigations, AR
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 FTW95FA337Accident · 2 fatalField investigationFinal reportCessna 150M · Armorel, ARThe pilot's impairment of judgement and performance due to drugs which led to his failure to maintain airspeed and resulted in an inadvertent stall/spin. Factors were the pilot's overconfidence in personal ability and interpersonal relations.NTSB FTW95LA347Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Lake City, ARThe pilot's failure to maintain clearance with the transmission wires.NTSB FTW95LA328Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Searcy, ARThe inadvertent stall as a result of the pilot's failure to maintain airspeed during the approach.NTSB FTW95LA317Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Mccrory, ARThe loss of engine power due to a cracked cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA310Accident · Serious injuriesLimited investigationFinal reportWilliams Bell OH13H/Tomcat MK5A · Alicia, ARThe pilot's failure to remove the refueling hose. A factor was that he diverted his attention from the refueling operation.NTSB FTW95LA297Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Osceola, ARThe loss of engine power due to a failed supercharger/blower. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA296Accident · No injuriesLimited investigationFinal reportCessna 210D · Bentonville, ARThe pilot's failure to attain the proper touchdown point. Factors were the mown grass and the high density altitude.NTSB FTW95LA292Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Van Buren, ARA partial loss of engine power for undetermined reasons, and the pilot's misjudgment of distance and speed during the precautionary landing resulting in an overshoot.NTSB FTW95LA301Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Cash, AREngine power loss due to partial failure of one magneto combined with total failure of the other magneto. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA288Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Carlisle, ARThe pilot delayed pull-up from a swath run and failed to maintain clearance from the obstruction (grain elevator). A factor relating to the accident was: the pilot's use of medications that were not approved for use while flying.NTSB FTW95LA290Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · De Witt, ARThe pilot's failure to maintain airspeed and the resulting inadvertent stall/mush.NTSB FTW95FA277Accident · 4 fatalField investigationFinal reportBellanca 17-31A · Hot Springs, ARThe partial loss of engine power as a result of the disengagement of the throttle cable housing due to improper maintenance. Factors were the night condition and the lack of suitable terrain.NTSB FTW95LA284Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Elaine, ARThe pilot did not maintain a positive rate of climb.NTSB FTW95LA283Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Widener, ARLoss of engine power for an undetermined reason. The proximity of power lines (obstruction) was a related factor.NTSB FTW95LA282Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Newport, ARA disconnected throttle push pull rod, due to inadequate maintenance. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB FTW95LA269Accident · No injuriesLimited investigationFinal reportCessna 180E · Springdale, ARThe pilot's failure to compensate for the crosswind conditions. Factors were the crosswind, and the pilot's improper weather evaluation.NTSB FTW95FA266Accident · 4 fatalField investigationFinal reportBeech V35B · Huntsville, ARan engine surge for undetermined reasons, and the pilot's failure to maintain airspeed resulting in an inadvertent stall/spin. A factor was the aft center of gravity.NTSB FTW95LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bigelow, ARThe pilot's failure to maintain clearance with terrain.NTSB FTW95LA254Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cash, ARThe loss of engine power for undetermined reasons. Factors were the low altitude at which the power loss occurred and the lack of suitable terrain for a forced landing.NTSB FTW95LA248Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M18 · Cherry Valley, ARFuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA245Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Devalls Bluff, ARThe pilot's delayed flare resulting in a hard landing. Factors were the loss of engine power due to fuel starvation as a result of fuel line blockage.NTSB FTW95LA216Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Rogers, ARThe failure of the right outboard tire for undetermined reason.NTSB FTW95LA210Accident · No injuriesLimited investigationFinal reportCessna 175 · Malvern, ARThe pilot's failure to maintain directional control. A factor was the pilot's lack of recent experience.NTSB FTW95LA213Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Caldwell, ARThe loss of power due to a crack in the #4 cylinder. Factors were the lack of suitable terrain for the forced landing and proper touchdown point not possible.NTSB FTW95LA207Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Mcgehee, ARThe ground service person's lack of attention and failure to remain clear of the turning propeller.NTSB FTW95LA199Accident · No injuriesLimited investigationFinal reportFairchild F-23A · Ozark, ARThe inadvertent stall while executing the turn to reverse direction during an aerial application flight.NTSB FTW95LA194Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Casa, ARThe pilot's failure to maintain obstacle clearance.NTSB FTW95LA192Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Gerome, ARThe pilot's use of unsuitable terrain for landing.NTSB FTW95LA190Accident · Serious injuriesLimited investigationFinal reportGrunska Earl J Baby ACE D · Paris, ARThe pilot's failure to maintain minimum required airspeed for flight, resulting in an inadvertent stall. A factor was the partial loss of power for undetermined reasons.NTSB FTW95LA189Accident · No injuriesLimited investigationFinal reportCessna 180 · Little Rock, ARThe pilot's failure to maintain directional control due to the excessive taxi speed.NTSB FTW95LA180Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Mcgehee, ARThe pilot intentionally shutting down the airplane's engine. A factor was the pilot's improper maintenance procedures.NTSB FTW95LA173Accident · No injuriesLimited investigationFinal reportCessna 152 · Oakgrove, ARThe student pilot's failure to maintain clearance from power lines while maneuvering at low altitude and the flight instructor's inadequate supervision. Factor's were the instructor's decision to allow the simulation to continue to such a low altitude and…NTSB FTW95LA171Accident · No injuriesLimited investigationFinal reportChampion 7GC · Paragould, ARThe student pilot's failure to maintain directional control, resulting in an inadvertent groundloop. A factor was the instructor's inadequate supervision.NTSB FTW95LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Mountain Home, ARThe pilot's failure to compensate for the gusty crosswind. A factor was gusting crosswinds.NTSB FTW95LA162Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromadier · Pine Bluff, ARThe loss of engine power for undetermined reasons and the pilot's failure to maintain minimum required airspeed for flight, resulting in an inadvertent stall. A factor was the pilot's diverted attention.NTSB FTW95LA154Accident · No injuriesLimited investigationFinal reportBeech G18S · Springdale, AREngine compartment fire due to undetermined reasons.NTSB FTW95LA145Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Gillett, ARThe engine main rod bearing seized to the crankshaft due to worn master rod metal pieces blocking the oil passages. A factor was an engine overhaul was not performed by company maintenance personnel.NTSB FTW95FA125Accident · 1 fatalField investigationFinal reportBeech 95-B55B · Midway, ARThe pilot's impairment of judgment and performance due to drugs, his lack of qualification/training, and his resultant inability to maintain control of the airplane.NTSB FTW95LA104Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Mountain View, ARThe pilot's selection of a downwind runway for takeoff, his failure to use all available runway, and delay in aborting the takeoff. A factor was the tailwind.NTSB FTW95LA097Accident · No injuriesLimited investigationFinal reportCessna 150M · Prescott, ARFuel exhaustion due to the pilot's failure to refuel. Factors were the pilot's disorientation and lack of suitable terrain for a forced landing.NTSB FTW95LA091Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marshall, ARThe pilot's continued flight into adverse deteriorating weather conditions. A factor was the weather and rising terrain.NTSB FTW95FA087Accident · 3 fatalField investigationFinal reportBeech B95 · Hot Springs, ARThe pilot's failure to follow IFR and missed approach procedures.NTSB FTW95FA080Accident · 2 fatalField investigationFinal reportBeech 65-90 · Royal, ARThe pilot inadvertently allowed the airplane to descend and collide with trees, after he became diverted by an inoperative cabin heater. Darkness was a related factor.NTSB FTW95LA039Accident · No injuriesLimited investigationFinal reportHughes 269A · Monticello, ARThe loss of engine power due to a fatigued rod end bolt. A factor was the lack of suitable terrain for landing.NTSB FTW95LA027Accident · Serious injuriesLimited investigationFinal reportGardner SEA REY · Hartman, ARFailure of the pilot to follow the landing checklist and retract the landing gear for a water landing.NTSB FTW95LA031Accident · No injuriesLimited investigationFinal reportHerron Little Wing Autogyro · Little Rock, ARThe fractured tail wheel mounting bracket and loose tailwheel. A factor was the pilot's continued flight testing after experiencing tail wheel shimmy on the prior test flight.NTSB FTW95LA012Accident · No injuriesLimited investigationFinal reportCessna 172H · Moro, AREngine compartment fire due to undetermined reasons.NTSB FTW94LA306Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Mcgehee, ARThe loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.NTSB FTW94LA301Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Russellville, ARThe pilot's inadequate compensation for the crosswind during the takeoff ground roll. A factor was the crosswind.NTSB FTW94LA298Accident · No injuriesLimited investigationFinal reportCessna 172M · Oil Trough, ARThe pilot's loss of aircraft directional control during the landing roll. A factor was the wet grass landing surface.