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 DFW06CA200Accident · No injuriesData collectionFinal reportAeronca 11AC · Searcy, ARThe student pilot's inadequate compensation for the existing wind conditions and the flight instructor's delayed remedial action to maintain directional control. A contributing factor was the crosswind.NTSB DFW06LA198Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Parkdale, ARThe failure of a compressor turbine blade for undetermined reasons, which resulted in a total loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06FA184Accident · 2 fatalField investigationFinal reportPiper J3 · Walnut Ridge, ARThe pilot's failure to maintain airspeed and the subsequent stall. Contributing factors were the low altitude and impairment due to drugs.NTSB DFW06CA182Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Marvell, ARThe pilot's failure to maintain clearance with terrain during takeoff.NTSB DFW06LA163Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Colt, ARThe pilot's failure to maintain clearance with the ground during an aerial application flight.NTSB DFW06LA159Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Stugartt, ARThe pilot's failure to maintain clearance from high brush during takeoff. Contributing factors were the short runway and the high density altitude.NTSB DFW06LA154Accident · No injuriesLimited investigationFinal reportMcClung Christian Eagle I · Pocahontas, ARThe loss of engine power as a result of a fractured crankshaft due to fatigue. A factor was the engine modifications to increase engine horsepower.NTSB DFW06CA155Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Minturn, ARThe pilot's inadequate inflight planning/decision, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA153Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Mena, ARThe pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB DFW06CA142Accident · Serious injuriesData collectionFinal reportBell 47G-4A · Sheridan, ARThe pilot's inadequate fuel management, which resulted in fuel exhaustion and a subsequent loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA146Accident · No injuriesData collectionFinal reportAir Tractor AT-802 · Tuckerman, ARThe loss of engine power due to water contamination in the fuel. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA139Accident · Minor injuriesData collectionFinal reportAllstar PZL SZD 51-1 Junior · Cherry Valley, ARThe pilot's failure to maintain clearance from a tree while on final to approach to landing. A contributing factor was the loss of thermal lift on final approach.NTSB DFW06CA138Accident · No injuriesData collectionFinal reportMaule MX-7-180B · Melbourne, ARThe pilot's failure to maintain directional control while landing resulting in a ground loop. A contributing factor was the prevailing crosswind.NTSB DFW06CA137Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Winchester, ARThe pilot's failure to abort the takeoff following the partial loss of engine power for undetermined reasons. A contributing factor was the rising embankment at the end of the runway.NTSB DFW06LA130Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · DeWitt, ARThe failure by both pilots to maintain adequate visual lookout and the Grumman G-164A pilot's impairment caused by the recent use of marijuana.NTSB DFW06CA113Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · De Witt, ARThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the gusty winds.NTSB DFW06CA096Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Lakeview, ARThe pilot's inadequate weather evaluation and failure to maintain airspeed, which resulted in an inadvertent stall. A contributing factor was the prevailing tailwind.NTSB DFW06LA088Accident · 1 fatalLimited investigationFinal reportBeech C23 · Mena, ARThe pilot's continued flight into instrument meteorological conditions. Contributing factors were the mountainous terrain and the low ceilings.NTSB DFW06CA084Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Cherokee City, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA081Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Texarkana, ARThe loss of engine power due to a cracked cylinder. Contributing factors were the pilot's failure to maintain adequate airspeed.NTSB DFW06LA074Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Forrest City, ARThe pilot's failure to follow proper procedures while attempting to start the engine by hand-proping the engine.NTSB DFW06CA061Accident · No injuriesData collectionFinal reportMaule M-7-260C · Lakeview, ARThe pilot's failure to compensate for existing wind conditions during the landing roll. Contributing factors were the prevailing crosswind, and wet terrain.NTSB DFW06CA070Accident · No injuriesData collectionFinal reportBeech C23 · Eureka Springs, ARThe pilot's failure to maintain directional control while landing and his delay in aborting the landing.NTSB DFW06CA031Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Osceola, ARThe pilot's failure to maintain control of the airplane while on final approach. A contributing factor was the gusty winds.NTSB DFW06LA027Accident · 1 fatalLimited investigationFinal reportArrow Falcon Exporters Arrow F OH-58A · West Memphis, ARThe loss of engine power due to a disconnected pneumatic (Pc) line. A contributing factor was the ravine.NTSB DFW06LA007Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Big Flat, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for a forced landing.NTSB CHI05FA272Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-36 · West Memphis, ARThe pilot's improper in-flight decision not to land at the departure runway or other available airports during the emergency descent, and his failure to maintain clearance from a vehicle and terrain. Contributing factors were a false engine fire warning…NTSB DFW05CA246Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Guion, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA235Accident · Serious injuriesData collectionFinal reportBell 47G · Swifton, ARThe pilot's failure to maintain clearance with the power lines. A contributing factor was sun glare.NTSB DFW05LA229Accident · 1 fatalLimited investigationFinal reportCessna A188B · Blytheville, ARThe pilot's failure to maintain control of the aircraft for undetermined reasons.NTSB DFW05CA231Accident · No injuriesData collectionFinal reportBell 47 · Monette, ARThe loss of control as result of a loss of hydraulic pressure for undetermined reasons.NTSB DFW05LA215Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Joiner, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA208Accident · Serious injuriesData collectionFinal reportHiller UH-12E · Hampton, ARA loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. A factor was unsuitable terrain to complete a successful autorotation.NTSB DFW05CA207Accident · No injuriesData collectionFinal reportGrumman G-164 · Knobel, ARThe loss of engine power due to the failure of the #1 cylinder head. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA203Accident · No injuriesData collectionFinal reportCessna 172M · El Dorado, ARThe student pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB DFW05CA198Accident · Minor injuriesData collectionFinal reportAmateur Built Varieze · Alco, ARThe pilot's pilots failure to refuel the airplane. Contributing factors were the low ceilings and the lack of suitable terrain for the precautionary landing.NTSB DFW05LA190Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Black Oak, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA179Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance with terrain during aerial application.NTSB DFW05CA177Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164C · Gillett, ARThe loss of engine power resulting from a disconnected discharge pressure line at the fuel control unit. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA171Accident · 1 fatalLimited investigationFinal reportCessna A188B · Piggott, ARThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall.NTSB DFW05LA162Accident · 1 fatalLimited investigationFinal reportWsk-Pzl Mielec M18B · Eudora, ARThe pilot's failure to maintain clearance from the tree.NTSB DFW05CA161Accident · No injuriesData collectionFinal reportCessna A188B · Osceola, ARThe pilot's failure to maintain directional control during takeoff. A contributing factor was the prevailing crosswind.NTSB DFW05CA166Accident · No injuriesData collectionFinal reportRockwell International S-2R · Watson, ARThe loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB DFW05CA176Accident · No injuriesData collectionFinal reportCessna A188B · Truman, ARThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight. A contributing factor was the sunglare.NTSB DFW05CA160Accident · Minor injuriesData collectionFinal reportCessna 150H · Morrilton, ARThe pilot's failure to maintain proper alignment with the runway during landing. A contributing factor was the dark night lighting condition.NTSB DFW05CA137Accident · Minor injuriesData collectionFinal reportPZL-Mielec M18 · Clover Bend, ARThe pilot's failure to maintain directional control during takeoff. A contributing factor was the dust devil (whirlwind) encountered.NTSB DFW05CA133Accident · No injuriesData collectionFinal reportGrumman 164-B · Fontaine, ARThe pilot's failure to maintain clearance during a downwind takeoff with a full load of fertilizer. Factor contributing to the accident were the prevailing tailwind and the high density altitude.NTSB DFW05CA131Accident · No injuriesData collectionFinal reportAir Tractor AT-402A · Cherry Valley, ARThe pilot's failure to calculate take off-distance performance data, which resulted in insufficient runway length for take off. Factors were the tailwind and high gross weight.NTSB DFW05CA130Accident · Serious injuriesData collectionFinal reportCessna 182P · Lowell, ARThe instructor's inadequate supervision and the second pilot's inadequate planning/decision to assure adequate takeoff performance to clear obstacles. Contributing factors were the prevailing quartering tailwind, the pilots selection of the wrong runway, and…NTSB DFW05LA112Accident · Serious injuriesLimited investigationFinal reportBoeing 737-700 · Little Rock, ARAn encounter with moderate turbulence during cruise flight.