Skip to content

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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 FTW94FA023Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Saratoga, ARThe pilot-in-command's performance of aerobatics at an altitude where it was not possible to maintain clearance.Oct 30, 1993 · N130KS · Substantial damage NTSB FTW94FA014Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Texarkana, ARThe pilot's continued VFR flight into instrument meteorological conditions. Factors that contributed to the accident were: the pilot's failure to obtain a weather briefing, the existing weather, his lack of instrument flying experience, and the dark night…Oct 18, 1993 · N98143 · Destroyed NTSB FTW93LA275Accident · No injuriesLimited investigationFinal reportKelm Zenair CH-701 · South Bend, ARThe engine power loss for undetermined reasons. A factor was the lack of available runway onto which the forced landing could be executed.Sep 29, 1993 · N27DK · Substantial damage NTSB FTW93LA260Accident · No injuriesLimited investigationFinal reportCessna A188B · Manila, ARPartial loss of engine power due to the collapse of an air induction hose.Sep 19, 1993 · N731UF · Substantial damage NTSB FTW93LA256Accident · No injuriesLimited investigationFinal reportJones Dominator · Magnolia, ARTotal loss of engine power for undetermined reasons. A factor was the lack of suitable terrain.Sep 4, 1993 · N44VJ · Substantial damage NTSB FTW93LA246Accident · No injuriesLimited investigationFinal reportCessna T210N · Springdale, ARThe loss of engine power due to fuel starvation and the improper use of the fuel selector. Factors were the pilot's failure to follow the checklist, and the lack of suitable terrain for the forced landing.Aug 26, 1993 · N6142Y · Substantial damage NTSB FTW93LA237Accident · No injuriesLimited investigationFinal reportBeech 58 · Little Rock, ARThe inadvertent landing gear retraction by the pilot. A factor was the pilot's negative habit interference.Aug 11, 1993 · N7222V · Substantial damage NTSB FTW93LA236Accident · No injuriesLimited investigationFinal reportBeech F35 · Mena, ARThe inflight separation of the ruddervator as result of improper balancing.Aug 11, 1993 · N5064B · Substantial damage NTSB DEN93FA099Accident · 6 fatalField investigationFinal reportPiper PA-32-300 · Delight, ARThe failure of the vacuum pump, and an inoperative turn coordinator. Factors which contributed to the accident were: the pilot's loss of control of the airplane as a result of spatial disorientation, the pilot exceeding the design stress limits of the…Aug 6, 1993 · N479KC · Destroyed NTSB FTW93LA230Accident · No injuriesLimited investigationFinal reportAero Commander S2R · England, ARA partial loss of engine power for undetermined reasons.Aug 4, 1993 · N5570X · Substantial damage NTSB FTW93LA225Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Osceola, ARInadvertent stall. Factors were the improper latching of the engine cowling by the pilot and his inadequate preflight inspection.Aug 1, 1993 · N4021C · Substantial damage NTSB FTW93LA224Accident · No injuriesLimited investigationFinal reportCessna 150M · Bald Knob, ARFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Aug 1, 1993 · N66081 · Substantial damage NTSB FTW93LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrison, ARAn inadvertent groundloop by the pilot.Jul 30, 1993 · N2464P · Substantial damage NTSB FTW93LA220Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Elaine, ARThe pilot's failure to maintain clearance of water spraying and the resultant power loss. A factor was unsuitable terrain for the forced landing.Jul 30, 1993 · N8842Q · Substantial damage NTSB DEN93LA093Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Brookland, ARThe pilot's failure to maintain adequate object clearance.Jul 30, 1993 · N7319V · Substantial damage NTSB DEN93LA084Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Garner, ARTotal failure of one propeller blade. Factors were the continued operation of the engine during the forced landing, despite the pilot's efforts to shut it down, and the lack of suitable terrain for the forced landing.Jul 22, 1993 · N3650U · Substantial damage NTSB DEN93LA081Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Dermott, ARPower loss due to the total failure of the engine's master rod. Factors were an improper engine overhaul and the lack of suitable terrain for a forced landing.Jul 15, 1993 · N1009T · Substantial damage NTSB FTW93LA215Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mccrory, ARThe loss of engine power due to cylinder failure. A factor was the lack of suitable terrain for the forced landing.Jul 13, 1993 · N9780 · Substantial damage NTSB FTW93LA214Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Bono, ARThe airplane's takeoff performance being exceeded by the PIC. A factor was the pilot's inability to safely reject the takeoff.Jul 9, 1993 · N8522V · Substantial damage NTSB FTW93FA207Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Little Rock, ARThe pilot's loss of control of the airplane as a result of physical impairment.Jul 7, 1993 · N95851 · Substantial damage NTSB FTW93LA213Accident · No injuriesLimited investigationFinal reportBeech 95-B55B · Ashdown, ARThe pilot's failure to abort the landing. A factor was the wet grassJul 3, 1993 · N258P · Substantial damage NTSB FTW93LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rogers, ARThe pilot's failure to maintain control of the airplane. A factor was the tailwind.Jul 3, 1993 · N2839B · Substantial damage NTSB FTW93LA195Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A Dromader · Wheatley, ARThe pilot's operation of the airplane beyond its takeoff performance limitations and inadvertent stall. A factor was high density altitude.Jun 23, 1993 · N116RA · Substantial damage NTSB FTW93LA193Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Holly Grove, ARTotal loss of power due to fuel exhaustion due to the pilot not refueling. A factor was the lack of suitable terrain for the forced landing.Jun 19, 1993 · N4804Q · Substantial damage NTSB FTW93LA190Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Wynne, ARThe engine power loss for undetermined reasons and the lack of suitable terrain for a forced landing.Jun 15, 1993 · N4955X · Substantial damage NTSB FTW93LA189Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Weiner, ARProper rotation speed not attained by the pilotJun 14, 1993 · N3098W · Substantial damage NTSB FTW93LA180Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Dumas, ARThe pilot's inadequate compensation for wind conditions.Jun 7, 1993 · N6622Q · Substantial damage NTSB FTW93LA178Accident · No injuriesLimited investigationFinal reportBell-Transworld 47G-2 · Wynne, ARPartial power loss due to the failure of one magneto. A factor was the lack of suitable terrain for the forced landing.Jun 5, 1993 · N9238Z · Substantial damage NTSB FTW93LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stuttgart, ARThe pilot's selection of the downwind runway for landing. Factors were the wind conditions and the left brake malfunction for undetermined reasonsJun 2, 1993 · N6695K · Substantial damage NTSB FTW93LA172Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Walnut Ridge, ARThe pilot's failure to maintain adequate clearance.Jun 2, 1993 · N48659 · Destroyed NTSB FTW93LA171Accident · No injuriesLimited investigationFinal reportAyres SR2-T34 · Harrisburg, ARThe loss of engine power due to the failure of the reduction gear assembly due to fatigue. A factor was the lack of suitable terrain for the forced landing.May 31, 1993 · N6051F · Substantial damage NTSB FTW93LA170Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Searcy, ARTotal power loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.May 27, 1993 · N5272Y · Substantial damage NTSB FTW93LA169Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Weiner, ARPartial power loss due to improper installation of the linkage control bracket. A factor was the lack of suitable terrain for the forced landing.May 27, 1993 · N4593 · Substantial damage NTSB FTW93LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stuttgart, ARPilot's failure to maintain clearance from the electrical wires.May 26, 1993 · N8405K · Destroyed NTSB FTW93LA156Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Trumann, ARPilot's failure to maintain terrain clearance. A factor was the diverted attention of the pilot.May 15, 1993 · N6556 · Substantial damage NTSB FTW93LA147Accident · No injuriesLimited investigationFinal reportRaven S-55A · Bentonville, ARAircraft control was not maintained by the pilot. A factor was unfavorable windsMay 1, 1993 · N6465K · Substantial damage NTSB FTW93LA146Accident · Minor injuriesLimited investigationFinal reportPzl-Mielec PZL-M-18 · De Witt, ARCompensation for wind improper by pilot. Factors were tailwind and downdraftMay 1, 1993 · N28587 · Destroyed NTSB DEN93FA053Accident · 2 fatalField investigationFinal reportBeech 65-A90 · Mount Ida, ARThe pilot's failure to establish an adequate climb rate. Factors in the accident were: pilot fatigue from lack of sleep, and the weather conditions.May 1, 1993 · N530N · Destroyed NTSB FTW93MA143Accident · Minor injuriesMajor investigationFinal reportEmbraer EMB-120 RT · Pine Bluff, ARThe captain's failure to maintain professional cockpit discipline, his consequent inattention to flight instruments and ice accretion, and his selection of an improper autoflight vertical mode, all of which led to an aerodynamic stall, loss of control, and a…Apr 29, 1993 · N24706 · Substantial damage NTSB FTW93LA139Accident · No injuriesLimited investigationFinal reportBell-K Copter 47G-2 · Walnut Ridge, ARWas the pilot's failure to maintain clearance of wires. A factor was the unsuitable terrainApr 28, 1993 · N7766 · Substantial damage NTSB DEN93LA051Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Truman, ARA power loss for undetermined reasons. A factor was: the lack of suitable terrain for the forced landing.Apr 28, 1993 · N31182 · Destroyed NTSB FTW93LA135Accident · No injuriesLimited investigationFinal reportCessna 320C · No. Little Rock, ARThe failure of the pilot to follow the checklist. A factor was the popped circuit breakerApr 21, 1993 · N3057T · Substantial damage NTSB FTW93LA133Accident · No injuriesLimited investigationFinal reportCessna T303 · Mena, ARThe pilot's failure to maintain directional controlApr 16, 1993 · N9481T · Substantial damage NTSB FTW93LA131Accident · No injuriesLimited investigationFinal reportHispano Aviacion HA-200 · Walnut Ridge, ARA corroded bleed air check valve and subsequent failure ot the right wing's fuel transfer system. A factor was the unfavorable windApr 16, 1993 · N554GA · Substantial damage NTSB FTW93LA130Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Searcy, ARThe pilot's improper flare and his improper recovery for a bounced landing. The crosswind and the pilot's improper compensation for the wind were factors.Apr 15, 1993 · N2150W · Substantial damage NTSB FTW93LA123Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Forrest City, ARThe pilot's improper landing flare. Factors were the wind conditions and pilot's failure to maintain directional control.Apr 11, 1993 · N7661 · Substantial damage NTSB FTW93LA127Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Danville, ARPilot's improper crosswind correction, his loss of directional control, and improper supervision by the instructor pilot. A factor was the crosswindApr 10, 1993 · N4079R · Substantial damage NTSB FTW93LA114Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Des Arc, ARThe pilot's loss of outside visual reference and loss of control.Mar 30, 1993 · N4437S · Destroyed NTSB FTW93LA106Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Mena, ARThe pilot's improper in-flight planning/decision. Factors related to the accident were: the adverse weather conditions, the pilot's improper use of carburetor heat, his improper IFR procedures, darkness, and the high (mountainous) terrain.Mar 16, 1993 · N4341P · Substantial damage NTSB FTW93LA101Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Goodwin, ARThe pilot's failure to compensate for the crosswind. A factor was the crosswind.Mar 11, 1993 · N634U · Substantial damage