NTSB investigations, AR
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 FTW91DPG06Accident · No injuriesFinal reportGrumman G-164A · Gillett, ARThe windshiled becoming obscured by aerial application spray and the resultant limited vision from the cockpit.NTSB FTW91LA077Accident · Serious injuriesLimited investigationFinal reportVuncannon Rotoway Exec 152 · Jonesboro, ARThe pilot's inadequate lookout and failure to maintain sufficient clearance from the wires for safe operation.NTSB FTW91DPG05Accident · 1 fatalFinal reportAyres S2R-T34 · Wheatley, ARThe failure of the flagman to follow established procedures.NTSB DEN91T#A01Accident · 2 fatalClass 3Final reportHughes TH-55 · Traskwood, ARNTSB FTW91LA067Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Carlisle, ARThe pilot's failure to maintain airspeed above the stalling speed of the airplane and the resultant inadvertent stall. A factor was the emotional state of the pilot.NTSB FTW91LA066Accident · 2 fatalLimited investigationFinal reportAeronca 7AC · Bradley, ARThe pilot's attempted to perform aerobatic flight at an altitude inadequate for recovery.NTSB DEN91LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Lehi, ARThe pilot's failure to maintain aircraft control. Factors were: the wet runway and resultant hydroplaning.NTSB FTW91FA060Accident · 2 fatalField investigationFinal reportCessna 172M · Flippin, ARThe pilot's attempted VFR flight in instrument meteorological conditions and his failure to maintain altitude.NTSB FTW91DPG03Accident · No injuriesFinal reportGrumman G-164A · Earle, ARA power loss for undetrmined reasons. A factor was the muddy/soft terrain in which the forced landing was performed.NTSB FTW91FA045Accident · 1 fatalField investigationFinal reportPiper PA-60-600 · Fort Chaffee, ARThe pilot's operation of the aircraft with known deficiencies in equipment. Factors were the improper overhaul of the engines by other maintenance personnel resulting in oil loss, deteriorated engine performance, and unsuitable terrain.NTSB FTW91DPG02Accident · No injuriesFinal reportGrumman G-164A · Light, ARThe pilot's selection of the downwind runway for landing. A factor was the tailwind.NTSB FTW91FA033Accident · 1 fatalField investigationFinal reportPiper PA-30 · Oppella, ARThe pilot's failure to maintain a proper climb rate following loss of his visual references and allowing himself to become diverted during the takeoff. Factors in the accident were interrupted instrument lighting and the dark night conditions.NTSB FTW91LA018Accident · No injuriesLimited investigationFinal reportCessna 172L · Mount Ida, ARThe pilot in command's failure to compensate for the adverse wind conditions which resulted in a loss of control on touchdown. A factor was the gusty crosswind.NTSB FTW91FA017Accident · 1 fatalField investigationFinal reportBeech B55 · England, ARThe pilot's misjudgement of altitude, which resulted in his failure to arrest descent from a dive. The pilot's impaired judgment from consumption of ethanol (alcohol) was a factor.NTSB FTW91LA015Accident · No injuriesLimited investigationFinal reportCessna 195 · N. Little Rock, ARThe failure of the right brake system to release after application for unknown reasons.NTSB FTW91LA006Accident · No injuriesLimited investigationFinal reportBeech 77 · Arkadelphia, ARFuel starvation to the engine due to a blocked fuel system vent. Factors contributing to the accident were the pilot's inadequate preflight, and contacting high vegetation and low trees during the landing roll.NTSB FTW91DPG01Accident · Minor injuriesFinal reportCessna A-188 · Manila, ARThe pilot's failure to maintain proper clearance from power lines and the inadvertent stall.NTSB DEN91LA001Accident · No injuriesLimited investigationFinal reportRaven S-60A · Harrison, ARThe student pilot's improper inflight planning and inaccurate evaluation of the surface weather. A factor was the unfavorable wind.NTSB FTW90LA187Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Greers Ferry, ARThe pilot's decision to penetrate adverse weather and the resultant spatial disorientation. Factors were the weather conditions and the pilot's lack of instrument training/experience.NTSB DEN90LA187Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Springdale, ARPilot's loss of control of the aircraft, during landing, due to mechanical malfunction of the tailwheel assembly.NTSB FTW90DPG15Accident · Serious injuriesFinal reportRotec Engineering Ralley III · Woodson, ARUndetermined.NTSB FTW90FA179Accident · 1 fatalField investigationFinal reportBeech 58 · Conway, ARThe pilot's failure to attain the proper touchdown point and his delayed decision to abort the landing. Factors were the weather conditions.NTSB FTW90DPG16Accident · Serious injuriesFinal reportEipper Quick Silver MX II · Tontitown, ARA partial power loss for undetermined reasons and the pilot's poor flare during the forced landing.NTSB FTW90DPG14Accident · Minor injuriesFinal reportGrumman G-164B · Dumas, ARThe inadvertent stall encountered during the turn to reverse direction.NTSB FTW90LA162Accident · No injuriesLimited investigationFinal reportPiper PA28-201T · Heber Springs, ARThe pilot's failure to conduct a thorough preflight and his attempt to execute a turn at high speed.NTSB FTW90DPG13Accident · No injuriesFinal reportGrumman G-164A · Luxora, ARA partial power loss due to failure of the number five connecting rod. A factor was the soft terrain in which the forced landing was made.NTSB FTW90DPG12Accident · No injuriesFinal reportAir Tractor AT-401 · Jacksonville, ARA loss of engine power due to unknown causes. A factor was the unsuitable terrain.NTSB DEN90LA179Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeview, ARThe pilot's failure to maintain alignment during landing.NTSB FTW90DPG11Accident · No injuriesFinal reportAir Tractor AT401 · Altheimer, ARThe pilot's failure to align the airplane with the runway during landing.NTSB FTW90DPG10Accident · No injuriesFinal reportCessna 188A · Hunter, ARThe pilot's failure to maintain proper clearance above the crops.NTSB FTW90DPG09Accident · 1 fatalFinal reportGrumman G164A · Osceola, ARThe pilot's failure to maintain proper clearance from the power lines.NTSB FTW90DPG08Accident · Serious injuriesFinal reportAir Tractor AT-301 · Corning, ARBlockage of the carburetor Air intake by a collapsed Air induction hose due to improper maintenance by an unknown party.NTSB FTW90DPG07Accident · No injuriesFinal reportSchweizer G-164B · Sherrill, ARPremature lift off and subsequent stall.NTSB FTW90DPG04Accident · No injuriesFinal reportAir Tractor 301A · Foreman, ARThe pilot's inadvertent stall/mush.NTSB FTW90LA148Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Carlisle, ARPilot's initiation of the abort with excess airspeed. A contributing factor was the engine tachometer overspeed.NTSB FTW90DPG06Accident · No injuriesFinal reportWSK PZL Mielec M18A · Hunter, ARLoss of part of the engine exhaust collector, as result of improper maintenance replacement/installation.NTSB FTW90DPG05Accident · No injuriesFinal reportWSK PZL Mielec M18A · Hunter, ARThe pilot's continued operation with a known malfunctioning engine.NTSB FTW90LA135Accident · No injuriesLimited investigationFinal reportPiper PA-24 · West Fork, ARThe catastrophic failure of the engine.NTSB FTW90DPG03Accident · No injuriesFinal reportGrumman G164-A · Rondo, ARThe power loss for undetermined reasons.NTSB MKC90LA147Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Egypt, ARThe pilot's failure to maintain directional control. A factor related to the accident was the soft/muddy area on the runway.NTSB MKC90LA144Accident · Minor injuriesLimited investigationFinal reportBell 47D-1 · Fair Oaks, ARTail rotor cable disengagement due to inadequate maintenance.NTSB MKC90LA139Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Swifton, ARFailure of the engine driven blower assembly. A factor was the lack of suitable terrain for the forced landing.NTSB MKC90LA140Accident · No injuriesLimited investigationFinal reportPiper J-3 · Clarksville, ARFailure of the pilot to maintain flying speed.NTSB MKC90LA134Accident · No injuriesLimited investigationFinal reportWeatherly 201-B · Stuttgart, ARFuel exhaustion induced power loss caused by the pilot's failure to refuel the airplane.NTSB MKC90LA132Accident · No injuriesLimited investigationFinal reportPiper PA-36-400 · Altheimer, ARDirectional control was not maintained by the pilot in command. Contributing factors were landing with a tailwind. Compensation for wind conditions not considered and selection of the wrong runway.NTSB MKC90LA129Accident · No injuriesLimited investigationFinal reportRockwell S2R · Tilton, ARFailure of the engine blower(supercharger). Related to the accident was the soft/wet terrain, where the forced landing was performed.NTSB MKC90LA127Accident · No injuriesLimited investigationFinal reportCessna 188 · Joiner, ARPremature lift-off by the pilot in command.NTSB MKC90LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Fisher, ARPartial loss of engine power for an undetermined reason.NTSB MKC90DPG02Accident · 1 fatalFinal reportAero Commander S-2R · Alicia, ARThe pilot's failure to maintian airspeed during the turn to reverse direction for a swath run.NTSB MKC90LA118Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Morton, ARThe pilot's failure to maintain directional control due to inadequate compensation for wind conditions.