NTSB investigations, AR
74 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 6 |
| 1984 | 7 |
| 1985 | 1 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 4 |
| 1991 | 6 |
| 1992 | 2 |
| 1993 | 4 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 3 |
| 1997 | 4 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 1 |
| 2005 | 1 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 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 DFW05CA024Accident · No injuriesData collectionFinal reportMcCulloch J2 · Camden, ARThe separation of the engine exhaust stack for undetermined reasons.NTSB CHI03LA265Accident · No injuriesLimited investigationFinal reportCessna 188B · Monette, ARFailure of the right brake and the pilot's inability to maintain directional control. A factor associated with the accident was the ditch.NTSB CHI03FA277Accident · Serious injuriesField investigationFinal reportBell TH-13T · Light, ARThe total failure and seizure of the main rotor transmission while in cruise flight leading to the helicopter’s impact with terrain.NTSB CHI03LA230Accident · No injuriesLimited investigationFinal reportMurch Rotec Rally 3 · Searcy, ARThe frayed rudder cable that failed during the turn to final. A factor was the ditch the airplane encountered during the forced landing.NTSB FTW03LA094Accident · No injuriesLimited investigationFinal reportCessna 210L · Morrilton, ARThe failure of the main landing gear to extend and lock, as a result of a hydraulic fluid leak caused by a chaffed and ruptured flex line.NTSB DEN03FA023Accident · 1 fatalField investigationFinal reportRockwell Commander 114 · Hot Springs, ARthe loss of engine power due to the failure of the engine ignition system's single-drive dual-magneto, and the magneto's improper installation by unknown maintenance personnel. Contributing factors were the improper installation of the magneto by unknown…NTSB FTW02LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bella Vista, ARThe binding throttle control cable, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA172Accident · No injuriesLimited investigationFinal reportBeech BE-100-A100 · Little Rock, ARThe malfunction of the left main landing gear retraction/extension assembly due to a missing lock pin/washer/nut on the clevis of the push/pull gear extension tube that resulted from improper maintenance.NTSB FTW01LA180Accident · No injuriesLimited investigationFinal reportCessna 210 · Fort Smith, ARthe overload fracture of the left main landing gear actuator which resulted in the loss of all hydraulic fluid and led to a wheels up landing.NTSB FTW00LA267Accident · Minor injuriesLimited investigationFinal reportPZL-Mielec M-18A · Jacksonville, ARthe corrosion and fatigue cracking of the right wing attachment fitting, which resulted in the right wing separating in flight. A factor was the failure of the operator to perform the recommended wing attachment fitting inspection.NTSB FTW99LA079Accident · No injuriesLimited investigationFinal reportMiller/Bell TR-1 · Hiwasse, ARThe pilot's inadequate compensation for prevailing wind conditions. Factors were the crosswind, the lack of suitable terrain, and the separation of the adell clamp for the oil cooler inlet line.NTSB FTW98LA253Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Delaplaine, ARThe failure of maintenance personnel to comply with and airworthiness directive, which resulted in failure of the planetary gear due to lack of lubrication. A contributing factors was the lack of suitable terrain for the pilot to execute a forced landing.NTSB FTW98LA252Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Coy, ARfailure of the left main tire, which resulted in the pilot's inability to maintain directional control of the airplane during the landing roll.NTSB CHI98LA125Accident · No injuriesLimited investigationFinal reportBeech B35 · Bentonville, ARthe damage to the empennage was due to flutter.NTSB FTW98LA059Accident · No injuriesLimited investigationFinal reportMooney M20F · Stuttgart, ARthe pilot's failure to activate the runway lights, which led to his selection of a closed/abandoned runway for the landing. Factors relating to the accident were: the unlatched cabin door, and the lack of lighting conditions at dusk.NTSB FTW97FA330Accident · 1 fatalField investigationFinal reportSouthwest Florida SW204 · Manila, ARFatigue failure of the main rotor blade resulting in the in-flight separation of the main rotor system due to the use of an unairworthy blade, and failure of the maintenance personnel who modified the rotor blade and the mechanic who complied with the…NTSB FTW97LA264Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Crossett, ARfailure of maintenance personnel to perform an adequate inspection of the fuselage center frame and detect a fatigue fracture of a longeron tube on the upper left side of the center frame, which resulted in a disconnect of the tail rotor drive shaft from the…NTSB FTW97FA220Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Corning, ARThe in-flight separation of the left wing as result of fatigue crack of the lower spar cap due to inadequate materials by the manufacturer. A factor was the operator's failure to comply with a published service bulletin on the airframe.NTSB FTW96LA385Accident · Minor injuriesLimited investigationFinal reportHiller UH12E · Hamburg, ARThe loss of tail rotor control as result of a tail rotor blade strike by a partially disconnected ballast weight, due to a disconnected pin. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA381Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Biscoe, ARBinding of the flight control system for an undetermined reason.NTSB FTW96LA325Accident · Minor injuriesLimited investigationFinal reportPezetel M-18A · Mcgehee, ARfailure of the brake system for undetermined reason(s), which resulted in a loss of directional control and a subsequent encounter with a ditch.NTSB FTW96LA069Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · West Helena, ARBinding of the power lever linkage, due to corrosion, which resulted in a situation that led to an inadvertent shut-down of the engine at a critical point on the approach to land. A factor relating to the accident was: inadequate maintenance.NTSB FTW95LA355Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fayetteville, ARThe pilot's inability to extend the landing gear due to the failure of an emergency gear extension valve.NTSB FTW95LA346Accident · No injuriesLimited investigationFinal reportCessna 150F · Manila, ARA blown (tripped) fuse, which rendered flap retraction inoperative. Factors relating to the accident were: the hot weather condition, the aircraft's lack of climb performance with the flaps extended, and the lack of suitable terrain in the forced landing area.NTSB FTW95LA216Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Rogers, ARThe failure of the right outboard tire for undetermined reason.NTSB FTW95FA080Accident · 2 fatalField investigationFinal reportBeech 65-90 · Royal, ARThe pilot inadvertently allowed the airplane to descend and collide with trees, after he became diverted by an inoperative cabin heater. Darkness was a related factor.NTSB FTW95LA031Accident · No injuriesLimited investigationFinal reportHerron Little Wing Autogyro · Little Rock, ARThe fractured tail wheel mounting bracket and loose tailwheel. A factor was the pilot's continued flight testing after experiencing tail wheel shimmy on the prior test flight.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 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 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 FTW94IA070Incident · No injuriesIncident investigationFinal reportBoeing 737-2H4 · Little Rock, ARWas the landing gear separation due to an undetermined cause.NTSB FTW93LA236Accident · No injuriesLimited investigationFinal reportBeech F35 · Mena, ARThe inflight separation of the ruddervator as result of improper balancing.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…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.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 windNTSB FTW93LA007Accident · No injuriesLimited investigationFinal reportCessna 210G · Little Rock, ARThe partial failure of the landing gear retraction/extension assembly from restricted hydraulic fluid movement through a partially failed main landing gear uplock release valve.NTSB FTW92LA210Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Russellville, ARThe pilot's improper flare. Factors were the propeller system's pitch change mechanism disconnected due to improper overhaul and failure to install the staking pins by other maintenance personnel.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 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 FTW91LA113Accident · No injuriesLimited investigationFinal reportCessna A188B · Lewisville, ARThe failure of the right brake line during a critical phase of operation.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 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 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 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 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 MKC90LA144Accident · Minor injuriesLimited investigationFinal reportBell 47D-1 · Fair Oaks, ARTail rotor cable disengagement due to inadequate maintenance.NTSB MKC90LA083Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Harrisburg, ARFailure of the generator, and failure of the pilot to maintain rotor RPM.NTSB MKC90LA027Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Springdale, ARThe banner tow pick up equipment became entangled resulting in a jammed rudder and restricted aircraft control.NTSB MKC89LA150Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Jonesboro, ARThe pilot's encounter with unsuitable terrain during a forced landing made necessary by the separation of three feet of one of the propeller blades.