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 FTW94LA297Accident · No injuriesLimited investigationFinal reportWeatherly 620TP · Montrose, ARThe pilot's failure to maintain airspeed and the resultant aerodynamic stall.NTSB FTW94LA284Accident · No injuriesLimited investigationFinal reportCessna 152 · Arkadelphia, ARLoss of engine power due to fuel exhaustion and the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA281Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Wheatley, ARTotal loss of engine power due to a cracked cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Russellville, ARVFR flight into IMC.NTSB FTW94LA259Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Booneville, ARThe proper touchdown point not obtained due to excessive airspeed during the approach and landing.NTSB FTW94LA256Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Mcgehee, ARTotal loss of engine power as the engine seized due to a blower bearing failure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94FA258Accident · 1 fatalField investigationFinal reportAir Tractor AT-301 · Hunter, ARInadvertent stall due to pilot's failure to maintain airspeed. A factor was the pilot's over confidence in his personal ability.NTSB FTW94LA246Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pollard, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain to perform a forced landing.NTSB FTW94FA242Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Lakeview, ARThe pilot's failure to maintain minimum required airspeed for flight.NTSB FTW94LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-501 · Marianna, ARA premature liftoff. Factors were the tall, wet grass and a tail wind component.NTSB FTW94LA238Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Winchester, ARThe loss of power due to the number one cylinder head cracking. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA225Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · England, ARThe inadvertent stall during initial takeoff climb. A factor was the tall grass.NTSB FTW94LA223Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Watson, ARWas the excessive airspeed during approach and the pilot's failure to execute a missed approach.NTSB FTW94LA221Accident · No injuriesLimited investigationFinal reportBell OH-13E · Mountain View, ARThe fuel exhaustion as result of a struck fuel drain valve. Factors were the high density altitude, and the unsuitable terrain at the pilot's disposal for the forced landing.NTSB FTW94LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Marked Tree, ARThe power loss for undetermined reasons. Factors were the pilot's inadvertent entry into a stall and the lack of suitable terrain onto which to execute the landing.NTSB FTW94LA216Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Searcy, ARThe total loss of engine power due to water contamination of the fuel system. A factor was the lack of suitable terrain available to the pilot for the forced landing and his inadequate preflight inspection.NTSB FTW94LA211Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dumas, ARThe pilot's failure to establish the proper airspeed before beginning a turn after takeoff.NTSB FTW94LA214Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Coy, ARThe separation of the landing gear due to failure of the landing gear axle bolts.NTSB FTW94LA210Accident · No injuriesLimited investigationFinal reportHiller UH-12L4 · West Helena, ARA total loss of power due to a leak in the main fuel line which occurred as a result of an electrical short which burned a hole in the fuel line. Factors were a failure by the pilot to perform recommended maintenance and the lack of suitable terrain for a…NTSB FTW94LA209Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Parkin, ARTotal power loss for undetermined reasons. A factor was unsuitable terrain for a forced landing.NTSB FTW94LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Brinkley, ARA supercharger impeller bearing failure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA187Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Carlisle, ARThe loss of engine power for undetermined reason. A factor ws the lack of suitable terrain at the pilot's disposal for the forced landing.NTSB FTW94LA180Accident · 1 fatalLimited investigationFinal reportCessna 182A · Roland, ARBoth the pilot and passenger's failure to follow procedure/directives.NTSB FTW94LA177Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Casscoe, ARThe inadvertent stall and power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA170Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 6103 Twin Astir · Forrest City, ARThe pilot's loss of aircraft control when he diverted his attention to closing the canopy. A factor was his failure to properly close the canopy prior to takeoff.NTSB FTW94LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARWas the pilots failure to maintain terrain clearance.NTSB FTW94LA164Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Monticello, ARThe loss of engine power due to the number 2 cylinder cracking. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA163Accident · No injuriesLimited investigationFinal reportGulfstream G-164C · Weiner, ARThe pilot selected unsuitable terrain for the takeoff.NTSB FTW94LA159Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · De Witt, ARA stall/mush into terrain after the pilot inadvertently raised the flaps.NTSB FTW94IA154Incident · No injuriesIncident investigationFinal reportSaab-Scania SF-34OB · Texarkana, ARThe pilot's inability to retard the power levers during a rejected takeoff due to his failure to perform the emergency procedures in accordance with the aircraft operating manual. A factor was the illumination of the configuration light as result of…NTSB FTW94LA144Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Osage, ARFuel exhaustion due to the pilot's failure to refuel and the lack of suitable terrain for a forced landing.NTSB FTW94FA138Accident · 2 fatalField investigationFinal reportCessna A150K · Mccrory, ARWas the inadvertent stall and spin. Factors were the pilot's performance of aerobatics at an inadequate altitude.NTSB FTW94LA131Accident · Minor injuriesLimited investigationFinal reportGulfstream G-164B · Delaplaine, ARThe loss of engine power for undetermined reasons. A factor was the low altitude at which the power loss occurred.NTSB FTW94LA128Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Monticello, ARThe loss of power for undetermined reasons and the inadvertant stall during the forced landing. A factor was the lack of suitable terrain.NTSB FTW94FA123Accident · 1 fatalField investigationFinal reportSIAI-Marchetti F.260C · Watson, ARThe pilot's failure to maintain adequate clearance from wires during low level flight which resulted in a severed aileron cable. Factors were the pilot's failure to maintain adequate altitude during the flight and his inability to control the airplane…NTSB FTW94FA121Accident · 1 fatalField investigationFinal reportAir Tractor AT-502 · Hughes, ARWas the pilot's failure to maintain terrain clearance for undetermined reason.NTSB FTW94LA118Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Elaine, ARThe pilot's failure to maintain terrain clearance.NTSB FTW94LA111Accident · No injuriesLimited investigationFinal reportCessna 172M · Flippin, ARThe student pilot's premature flare and the resultant inadvertent stall.NTSB FTW94LA098Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Moro, ARThe pilot's failure to maintain clearance of power lines.NTSB FTW94LA097Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Hamburg, ARThe loss of engine power due to fouled spark plugs. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94FA090Accident · 1 fatalField investigationFinal reportCessna P337H · N. Little Rock, ARFailure of the pilot to maintain control of the aircraft, while maneuvering to land. Factors related to the accident were: darkness and possible spatial disorientation.NTSB FTW94LA086Accident · 1 fatalLimited investigationFinal reportAir Tractor AT400 · Widener, ARThe pilot's loss of control for undetermined reasons.NTSB FTW94LA087Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Almyra, ARThe partial failure of the brake master cylinder assembly for undetermined reasons. A factor was the soft terrain adjacent to the runway.NTSB FTW94LA084Accident · Minor injuriesLimited investigationFinal reportNoble Quickie Q-200 · N. Little Rock, ARThe pilot/owner's inaccurate calculation of the airplane's center of gravity. A factor was the pilot's failure to follow the correct calculation procedure.NTSB FTW94LA083Accident · No injuriesLimited investigationFinal reportCessna 172N · Georgetown, ARA carburetor icing induced power loss due to the pilot's improper use of carburetor heat in conditions conducive to carburetor icing. A factor was the lack of suitable terrain onto which a forced landing could be executed.NTSB FTW94LA080Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Paris, ARFailure by the pilot in command to have annual maintenance inspections performed on the aircraft.NTSB FTW94IA070Incident · No injuriesIncident investigationFinal reportBoeing 737-2H4 · Little Rock, ARWas the landing gear separation due to an undetermined cause.NTSB FTW94LA042Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Parkin, ARThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain available to the pilot for the forced landing.NTSB FTW94FA038Accident · 2 fatalField investigationFinal reportCessna T303 · Rogers, ARThe pilot's continued flight into known adverse weather conditions, and the ensuing inadvertent stall. Factors were the icing conditions, the fog, the drizzle, the dark night light conditions, and the pilot's disregard for the forecasted weather conditions.NTSB FTW94LA027Accident · No injuriesLimited investigationFinal reportCessna 150G · Salem, ARPartial loss of engine power for undetermined reasons. A factor was unsuitable terrain for the forced landing.