NTSB investigations, AR
154 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 6 |
| 1984 | 9 |
| 1985 | 7 |
| 1986 | 6 |
| 1987 | 6 |
| 1988 | 6 |
| 1989 | 6 |
| 1990 | 7 |
| 1991 | 4 |
| 1992 | 6 |
| 1993 | 5 |
| 1994 | 11 |
| 1995 | 8 |
| 1996 | 4 |
| 1997 | 6 |
| 1998 | 9 |
| 1999 | 5 |
| 2000 | 4 |
| 2001 | 6 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 7 |
| 2005 | 9 |
| 2006 | 2 |
| 2007 | 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\" = 250)
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" = 250) 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 CHI07LA113Accident · 2 fatalLimited investigationFinal reportMurphy Aircraft Mfg SR3500 Moose · Cotter, ARThe pilot not maintaining airplane control and airspeed during the approach. Factors were the gusty wind conditions, the inadvertent stall the pilot encountered, and the power lines that were impacted during the uncontrolled descent.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 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 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 DFW05LA171Accident · 1 fatalLimited investigationFinal reportCessna A188B · Piggott, ARThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall.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 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 DFW05LA092Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Tontitown, ARThe pilot's falure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the prevailing tailwind.NTSB DFW05FA073Accident · 1 fatalField investigationFinal reportBell 206-L1 · Gentry, ARThe pilot’s improper decision to maneuver in an environment conducive to a loss of tail rotor effectiveness.NTSB DFW05LA118Accident · 2 fatalLimited investigationFinal reportCessna TR182 · Little Rock, ARThe pilot's failure to maintain control of the airplane during an instrument approach for undetermined reasons. Contributing factors were the mist and low cloud ceiling.NTSB FTW04LA220Accident · Minor injuriesLimited investigationFinal reportBell 212 · Umpire, ARThe pilot's encounter with settling with power resulting in a loss of control. A contributing factor was the high density altitude.NTSB FTW04LA153Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402 · Tucker, ARThe pilot's failure to maintain control while manuevering during aerial application which resulted in impact with terrain.NTSB FTW04LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Benton, ARThe student pilot's failure to maintain airspeed resulting in an inadvertent stall during a go-around.NTSB FTW04LA127Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 · Brinkley, ARThe pilots failure to attain flying airspeed after takeoff. A factor was the overloading of agricultural chemicals that exceeded the airplane's maximum takeoff weight.NTSB FTW04LA103Accident · Serious injuriesLimited investigationFinal reportPdps PZL-Bielsko SZD-50-3 · Cherry Valley, ARThe pilot's failure to maintain airspeed during the landing which resulted in an inadvertent stall.NTSB FTW04FA083Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Wrightsville, ARThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin on the downwind leg of the traffic pattern.NTSB FTW04LA080Accident · 1 fatalLimited investigationFinal reportGrumman G-164C · Hazen, ARThe pilot's loss of control while maneuvering during an aerial application flight for undetermined reasons.NTSB CHI03LA148Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Reydell, ARThe pilot's failure to maintain directional control during initial climb.NTSB FTW03FA064Accident · 1 fatalField investigationFinal reportBeech BE-58 · Egypt, ARThe pilot's inadvertent flight into severe icing conditions. A contributing factor was the pilot's inadequate preflight planning.NTSB FTW03FA003Accident · 1 fatalField investigationFinal reportSocata TB-20 · Texarkana, ARThe inadvertamt stall by the student pilot, and the inadequate supervision by the flight instructor.NTSB FTW02LA253Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Rector, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB FTW02LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Omaha, ARthe pilot's failure to maintain adequate airspeed during the go-around resulting in an inadvertent stall. A contributing factor was haze.NTSB FTW01LA173Accident · No injuriesLimited investigationFinal reportCurtis-Travel Air 4000 · Morrilton, ARthe pilot's failure to maintain aircraft control during takeoff. Contributing factors were the pilot's lack of experience in the accident airplane, and the rough/uneven runway.NTSB FTW01FA171Accident · 4 fatalField investigationFinal reportCessna 205 · De Queen, ARthe pilot's VFR flight into IMC, which resulted in spatial disorientation and a loss of aircraft control. A contributing factor to the accident was the pilot's lack of total instrument flight time.NTSB FTW01LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Newport, ARthe loss of control during takeoff initial climb as a result of encountering wake turbulence due to the pilot's failure to recognize the hazard and delay the takeoff.NTSB FTW01LA114Accident · Serious injuriesLimited investigationFinal reportBoykin B J B8M · Clarksville, ARthe pilot's inadequate preflight inspection, which resulted in a loose control stick on takeoff, rendering the aircraft uncontrollable.NTSB FTW01LA106Accident · No injuriesLimited investigationFinal reportCessna 172G · N. Little Rock, ARthe pilot's delayed go-around on landing.NTSB FTW01LA097Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Roe, ARthe inadvertent stall by the pilot while maneuvering at low altitude. A contributory factor was the tailwind.NTSB FTW00LA214Accident · 1 fatalLimited investigationFinal reportBurton/Boyton Celerity · Horseshoe Bend, ARThe loss of control while maneuvering for an undetermined reason.NTSB FTW00LA157Accident · Minor injuriesLimited investigationFinal reportPzl-Mielec M-18A · Marmaduke, ARThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall/mush.NTSB FTW00LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Gould, ARThe stall/mush encountered by the pilot. A factor was the crosswind.NTSB FTW00FA063Accident · 1 fatalField investigationFinal reportCessna 152 · Carlisle, ARthe pilot's failure to maintain aircraft control.NTSB FTW99LA188Accident · No injuriesLimited investigationFinal reportBeech C35 · Jonesboro, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors were the prevailing tailwind, and the airplane's over gross weight condition.NTSB FTW99FA143Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Rose Bud, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall.NTSB FTW99LA125Accident · Serious injuriesLimited investigationFinal reportOakes J3 CUB · Greenbriar, ARThe student pilot's failure to compensate for the gusty wind condition while maneuvering, which resulted in the inadvertent stall. A factor was the gusty wind condition.NTSB FTW99LA124Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Hickory Ridge, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall/spin.NTSB FTW99FA060Accident · 1 fatalField investigationFinal reportPiper PA-32-300R · Smackover, ARThe pilot's spatial disorientation resulting in a loss of control of the airplane and the ensuing stall/spin. Factors were the low ceilings and the night condition.NTSB FTW99FA041Accident · 1 fatalField investigationFinal reportCessna 501 · Umpire, ARThe pilot's in flight loss of control for undetermined reasons.NTSB FTW99LA035Accident · No injuriesLimited investigationFinal reportCessna 172P · Fayetteville, ARThe pilot's inadequate compensation for the wind conditions resulting in a loss of directional control. A factor was the shifting and gusty wind conditions.NTSB FTW99LA007Accident · 1 fatalLimited investigationFinal reportPainton Loehle Aviation 5151 · Osceola, ARThe pilot's failure to maintain aircraft control due to incapacitation as a result of hypertensive arteriosclerotic cardiovascular disease.NTSB FTW98FA365Accident · 1 fatalField investigationFinal reportCessna 150F · Wilton, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall. Factors were the pilot's improper use of flaps during the takeoff climb and the high density altitude.NTSB FTW98LA371Accident · No injuriesLimited investigationFinal reportBell 47G · Monette, ARThe pilot's failure to maintain control. A factor was his lack of total flight experience in helicopters.NTSB FTW98LA313Accident · Serious injuriesLimited investigationFinal reportShoemaker S-12 Aeraile · Marion, ARThe non-certificated pilot's failure to maintain minimum required airspeed resulting in an inadvertent stall. A factor was the pilot's lack of total flight experience.NTSB FTW98FA272Accident · 1 fatalField investigationFinal reportAyres S2R-R1340 · Humphrey, ARThe pilot's visual lookout was inadequate for undetermined reasons.NTSB FTW98LA107Accident · Serious injuriesLimited investigationFinal reportSutton Tierra II · Woodson, ARThe pilot's inability to maintain control of the airplane for undetermined reasons.NTSB FTW98FA100Accident · 1 fatalField investigationFinal reportAir Tractor 502B · Eudora, ARThe pilot's failure to maintain adequate airspeed while attempting an aerobatic manueverNTSB FTW98FA031Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201 · Hazen, ARThe pilot's failure to maintain aircraft control. Factors were the pilot's lack of total experience in the make and model of aircraft, the pilot's lack of total night flight experience, and the dark night conditions,NTSB FTW97LA341Accident · Serious injuriesLimited investigationFinal reportBurgess Skyhopper · Jonesboro, ARThe pilot's failure to obtain/maintain the aircraft's airspeed. Factors were the high density altitude and the lack of suitable terrain for the forced landing.