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 FTW92LA091Accident · No injuriesLimited investigationFinal reportCessna 172P · West Helena, ARPilot's improper flarea ND improper recovery from a bounced landing.NTSB FTW92LA089Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Wright, ARThe failure of the pilot to maintain altitude due to diverted attention.NTSB FTW92LA086Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Harrison, ARThe pilot's failure to attain the proper touchdown point, and his failure to maintain the proper descent rate.NTSB FTW92DPG01Accident · 1 fatalFinal reportWind Ryder · Little Rock, ARA loss of control for undetermined reason(s).NTSB FTW92LA081Accident · No injuriesLimited investigationFinal reportCameron 084 · Maumelle, ARThe pilots improper fuel consumption planning. A factor was a lack of suitable terrain for landing.NTSB FTW92LA078Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillette, ARThe unsuitable terrain selected by the pilot.NTSB FTW92FA073Accident · Serious injuriesField investigationFinal reportCessna 150 · Clarksville, ARThe pilots inadvertent stall. A factor was the operator's inadequate supervision.NTSB FTW92LA069Accident · Serious injuriesLimited investigationFinal reportRalph Legate Stits Skycoup · Conway, ARThe pilot's failure to maintain proper clearance with the guy wire. A factor was the fuel starvation caused by failure of the carburetor float.NTSB FTW92LA065Accident · No injuriesLimited investigationFinal reportCessna 150L · Searcy, ARThe pilot's improper use of carburetor heat resulting in the loss of engine power due to carburetor ice. The carburetor icing conditions and the soft terrain in the landing area were factors.NTSB FTW92LA047Accident · No injuriesLimited investigationFinal reportCessna 182D · Carlisle, ARThe parachute jumper's reserve parachute inadvertently opening, for undetermined reasons, resulting in the jumper impacting the right horizontal stabilizer.NTSB FTW92FA045Accident · 4 fatalField investigationFinal reportBeech C23 · Dewitt, ARThe pilot's attempt to land in IMC conditions and her subsequent loss of control during climb out due to spatial disorientation. A factor was the pilot's disregard of the pre-flight weather briefing.NTSB FTW92LA016Accident · Serious injuriesLimited investigationFinal reportBalkema/Boven Kestrel Hawk · West Memphis, ARThe pilot allowed the aircraft to enter an inadvertent stall during flare at excessive altitude while executing the forced landing. Factors were the pilot in command and unauthorized person performed carburetor maintenance adjustments prior to flight, and the…NTSB DEN92LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Berryville, ARA power loss for undetermined reasons. Factors were: incorrect fuel, improper maintenance, and inadequate maintenance inspection interval.NTSB FTW92LA001Accident · Serious injuriesLimited investigationFinal reportBoeing 727-243 · Little Rock, ARThe pilot's failure to specifically warn the flight attendants of the hazardous conditions warnings. A factor was the turbulence.NTSB FTW91DPG21Accident · 1 fatalFinal reportJoseph P. Frasca Astrocraft · Johnson, ARThe loss of control for unknown reasons, and procedures for emergency equipment not followed, which resulted in parachute separation.NTSB FTW91DPG20Accident · No injuriesFinal reportAyres S2R · Dumas, ARThe failure of a worn rudder adjustment bar. A factor was the pilot's inability to maintain directional control.NTSB FTW91LA159Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Benton, ARA loss of engine power for unknown reasons.NTSB FTW91LA157Accident · No injuriesLimited investigationFinal reportCessna 172K · Fisher, ARThe pilot's failure to use the aircraft performance data to compute the takeoff distance. A factor was the high density altitude.NTSB FTW91LA152Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ward, ARThe pilot's failure to maintain directional control.NTSB FTW91LA150Accident · No injuriesLimited investigationFinal reportHughes 269A-1 · No. Little Rock, ARThe pilot's failure to maintain main rotor RPM, his delayed flare, and the improper touchdown.NTSB FTW91DPG19Accident · No injuriesFinal reportGrumman G-164A · Allport, ARA loss of power for undetermined reason. A factor was the terrain on which the pilot made the forced landing.NTSB FTW91DPG18Accident · No injuriesFinal reportGrumman G-164A · Dewitt, ARThe pilot's failure to maintain proper glidepath. A factor was the berm at the approach end of the runway.NTSB FTW91LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Heber Springs, ARThe pilot's touchdown at an improper point on the airstrip. A factor was the wet downsloping grass airstrip.NTSB FTW91LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-400 · Nashville, ARFuel starvation induced loss of power due to a blocked finger fuel strainer in the fuel servo unit. A factor was the unsuitable terrain at the pilot's disposal.NTSB FTW91LA133Accident · No injuriesLimited investigationFinal reportCessna 150 · Searcy, ARThe pilots misjudgment of altitude and lack of a timely flare.NTSB FTW91DPG17Accident · No injuriesFinal reportGrumman G-164 · Goodwin, ARThe failure of the right main landing gear.NTSB FTW91DPG16Accident · No injuriesFinal reportAyres S2R-T34 · Mellwood, ARFailure of the pilot to maintain proper clearance with the power line.NTSB FTW91DPG15Accident · No injuriesFinal reportGrumman 164B · Brinkley, ARA blocked fuel screen which resulted in a fuel starvation induced loss of power. A factor was the lack of suitable terrain for the forced landing.NTSB FTW91FA123Accident · 1 fatalField investigationFinal reportHughes 269B · Brickeys, ARThe failure of the clutch control cable due to fraying which initiated the forced landing and the operator's failure to perform recommended inspections on the aircraft. Factors were the pilot's failure to maintain rotor RPM and the unsuitable terrain.NTSB FTW91DPG14Accident · No injuriesFinal reportGrumman G-164A · Swifton, ARPartial failure of the hopper, chemical fire, and the failure of the landing gear. A factor ws the loss of visual outside reference.NTSB FTW91LA116Accident · No injuriesLimited investigationFinal reportCessna 172P · Lakeview, AR(1) The pilot's failure to properly flare the airplane for landing and (2) his subsequent improper recovery from a bounced landing.NTSB FTW91LA111Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Clinton, ARThe loss of directional control due to locked wheel brake on the left landing gear.NTSB FTW91LA113Accident · No injuriesLimited investigationFinal reportCessna A188B · Lewisville, ARThe failure of the right brake line during a critical phase of operation.NTSB FTW91FA109Accident · Serious injuriesField investigationFinal reportNorth American NA1 · Mountain Home, ARThe contamination of the airplane's fuel system and the foreign object blockage of the vapor return orifice which induced the power loss. A factor was the lack of suitable terrain.NTSB FTW91DPG13Accident · Serious injuriesFinal reportGrumman G-164B · Mc Crory, ARLoss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW91LA103Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Brighton, AR(1) The pilot's failure to maintain adequate clearance from the wires and (2) the wire's subsequent interference with the flight controls.NTSB FTW91LA100Accident · No injuriesLimited investigationFinal reportCessna 150 · Berryville, ARThe loss of engine power for unknown reasons and the pilot's improper flare which resulted in a hard landing.NTSB FTW91LA095Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Newport, ARThe pilot's improper planning which resulted in his flying into his own chemicals.NTSB FTW91LA091Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Peach Orchard, ARThe pilot's failure to maintain adequate main rotor RPM resulting in deteriorated helicopter performance. A factor was the tailwind condition.NTSB DEN91LA078Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Fayetteville, ARThe pilot failed to apply carburetor heat.NTSB FTW91FA088Accident · 4 fatalField investigationFinal reportBeech A36 · Lakeview, ARThe pilot's improper visual approach, and his failure to maintain an adequate visual lookout for obstructions. Factors were the unmarked power linesNTSB FTW91DPG12Accident · Minor injuriesFinal reportBell 47-G3B1 · Colt, ARLoss of engine power for an undetermined reason. A factor was the unsuitable terrain.NTSB FTW91LA087Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Horseshoe Bend, ARThe pilot's failure to maintain directional control of the airlane. A factor was the crosswind.NTSB FTW91DPG11Accident · No injuriesFinal reportGrumman G-164A · Holly Grove, ARThe pilot's failure to maintain directional control. Factors were the wet runway and the ditch struck after control was lost.NTSB FTW91DPG10Accident · No injuriesFinal reportWeatherly 201B · Mc Crory, ARLoss of the outboard portion of the propeller blade. A factor was the lack of suitable terrain for the forced landing.NTSB FTW91DPG09Accident · No injuriesFinal reportGrumman G-164A · Goodwin, ARPower loss due to failure of the number five cylinder assembly. A factor was the soft terrain.NTSB FTW91LA082Accident · No injuriesLimited investigationFinal reportCessna 210L · Marked Tree, ARThe failure of the engine piston and connecting rod. A factor was the wet landing area.NTSB FTW91DPG04Accident · No injuriesFinal reportGrumman G-164B · Vanndale, ARThe pilot's failure to verify his weight and balance. A factor was the soft terrain.NTSB FTW91FA092Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Parkin, ARFailure of the pilot to maintain adequate clearance from objects.NTSB FTW91DPG07Accident · No injuriesFinal reportCessna A188B · Eudora, ARThe pilot's exceeding the airplane's takeoff performance capability for the climatic conditions.