NTSB investigations
8,203 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 332 |
|---|---|
| 1983 | 466 |
| 1984 | 438 |
| 1985 | 425 |
| 1986 | 370 |
| 1987 | 348 |
| 1988 | 369 |
| 1989 | 320 |
| 1990 | 359 |
| 1991 | 354 |
| 1992 | 332 |
| 1993 | 304 |
| 1994 | 323 |
| 1995 | 280 |
| 1996 | 263 |
| 1997 | 264 |
| 1998 | 281 |
| 1999 | 263 |
| 2000 | 274 |
| 2001 | 248 |
| 2002 | 245 |
| 2003 | 279 |
| 2004 | 237 |
| 2005 | 281 |
| 2006 | 249 |
| 2007 | 299 |
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.\"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."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 NYC08FA071Accident · 3 fatalField investigationFinal reportBell 206L-3 · Cherokee, ALThe pilot's failure to maintain control of the helicopter during an out-of-ground-effect hover. Contributing to the accident was a loss of tail rotor effectiveness.NTSB DFW08LA052Accident · 2 fatalLimited investigationFinal reportAlthouse RAF 2000 GTX · Crowley, TXThe pilot's failure to maintain rotor rpm while maneuvering, which resulted in a loss of rotor blade rigidity.NTSB DFW08FA053Accident · 1 fatalField investigationFinal reportBell 206L1 · Venice, LAThe pilot’s decision to continue to the destination landing platform in weather conditions below the company’s weather minimums and his failure to maintain aircraft control during the approach. Contributing to the passenger fatality and the severity of the…NTSB DEN08CA045Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Gunnison, COThe pilot's failure to maintain directional control of the airplane during takeoff resulting in the airplane hitting a snowbank and subsequently, the ground.NTSB CHI08FA055Accident · 1 fatalField investigationFinal reportCessna 310R · Traverse City, MIThe pilot's failure to maintain a proper glidepath during the instrument approach, which led to his loss of control and subsequent impact with trees and terrain.NTSB DEN08CA043Accident · No injuriesData collectionFinal reportChampion 7GCAA · Gallup, NMThe pilot's premature landing flare and an inadvertent stall/mush. A contributing factor is pilot's lack of recent night experience.NTSB SEA08CA055Accident · No injuriesData collectionFinal reportBrooks Exec 162F · Santa Maria, CAThe pilot's failure to maintain control of the helicopter during hover. Contributing to the accident was the pilot's lack of experience in rotorcraft.NTSB CHI08FA054Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Warrens, WIThe decision by the pilot to fly into known adverse weather, and the pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing factors include the clouds and the night conditions.NTSB CHI08FA053Accident · 3 fatalField investigationFinal reportBeech V35B · Springfield, ILThe loss of control during an instrument approach due to spatial disorientation.NTSB ANC08LA027Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Bethel, AKThe pilot's failure to adequately remove frost contamination from the airplane, which resulted in a loss of control and subsequent collision with terrain during an emergency landing after takeoff.NTSB DEN08LA040Accident · 1 fatalLimited investigationFinal reportGarniss Stol 701 · Mesilla, NMThe pilot's failure to maintain aircraft control during an intentional low altitude maneuver due to impairment, resulting in the in-flight collision with terrain.NTSB CHI08LA052Accident · Serious injuriesLimited investigationFinal reportLevick RAF-2000-GTX-SE · Salem, INThe pilot's failure to maintain control of the gyroplane during climbout after takeoff.NTSB NYC08LA061Accident · No injuriesLimited investigationFinal reportCessna 310J · Hilton Head Island, SCThe pilot's failure to maintain aircraft control during a go-around.NTSB CHI08CA048Accident · No injuriesData collectionFinal reportSmith, Ted Aerostar Aerostar 601 · Elyria, OHThe pilot's momentary loss of control after takeoff, which resulted in an in-flight collision with a tree. A contributing factor was the presence of the tree.NTSB SEA08FA042Accident · 2 fatalField investigationFinal reportBeech 200 · Salmon, IDAn in-flight loss of control due to the pilot's failure to remove ice and snow from the airplane prior to takeoff. Contributing to the accident were the pilot's improper preflight preparation/actions, falling snow, and a low ambient temperature.NTSB MIA08FA027Accident · 2 fatalField investigationFinal reportCessna T210N · Bloomfield, KYthe pilot exceeded the design stress limits of the airplane, which resulted in the in-flight break up. Contributing to the accident was the pilot's loss of control in-flight due to spatial disorientation.NTSB MIA08FA026Accident · 2 fatalField investigationFinal reportCessna R182 · Woodland, ALThe flight instructor’s failure to maintain control of the airplane while attempting to conduct visual flight in reduced visibility conditions at night. Factors contributing to the accident include the flight instructor’s inadequate preflight planning, and…NTSB SEA08LA043Accident · No injuriesLimited investigationFinal reportBell UH-1B · Ennis, MTThe loss of collective control friction during takeoff that resulted in a collective bounce oscillation. Contributing to the accident was the pilot's failure to maintain aircraft control during the aborted takeoff and the snow covered terrain.NTSB NYC08LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Gaithersburg, MDThe student pilot's failure to maintain aircraft control during an attempted touch-and-go. Contributing to the accident was the instructor's delay in taking remedial action, and the presence of trees in proximity to the side of the runway.NTSB MIA08LA023Accident · Serious injuriesLimited investigationFinal reportPorter Glen Aventura II · Rockledge, FLThe failure of the pilot to maintain airspeed during climbout, resulting in an aerodynamic stall and uncontrolled descent. Contributing to the severity of the pilot's injuries was the inadequate manufacture of the shoulder harness restraint cables.NTSB NYC08CA048Accident · Serious injuriesData collectionFinal reportVans RV-8 · Latrobe, PAThe pilot's failure to maintain directional control during landing.NTSB MIA08FA021Accident · 1 fatalField investigationFinal reportMooney M20J · Fort Myers, FLThe reason for this occurrence was not determined.NTSB DFW08FA040Accident · 2 fatalField investigationFinal reportCessna 172N · Marlow, OKThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall/spin and impact with terrain. Contributing to the accident were the low altitude for recovery and the gusty tailwind.NTSB DFW08CA041Accident · No injuriesData collectionFinal reportCessna 172P · Bridgeport, TXThe pilot's failure to maintain direction control of the airplane while landing with a crosswind. A contributing factor was the prevailing crosswind.NTSB CHI08LA041Accident · 1 fatalLimited investigationFinal reportHerink H R/Herink R W Challenger · Apple River, ILThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the low altitude and the gusty wind conditions.NTSB NYC08FA046Accident · 1 fatalField investigationFinal reportCessna 310R · Owensboro, KYA loss of control during approach for undetermined reasons.NTSB NYC08CA047Accident · No injuriesData collectionFinal reportCessna 152 · Venice, FLThe student pilot's improper recovery from a bounced landing.NTSB CHI08FA039Accident · 4 fatalField investigationFinal reportCirrus Design SR22 · Faribault, MNThe pilot not maintaining adequate airspeed for the gusty crosswind conditions and the stall/spin encountered during the go-around. Contributing to the accident were the crosswinds and wind gusts.NTSB DFW08FA036Accident · 1 fatalField investigationFinal reportCessna A150K · Mesquite, TXThe flight instructor's failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb. Factors contributing to the accident are the instructor's decision to takeoff with excessive flaps, the improper maintenance replacement of the flap…NTSB SEA08FA036Accident · 2 fatalField investigationFinal reportCessna 177 · Auburn, CAThe pilot failed to maintain an adequate airspeed while maneuvering in the traffic pattern for landing, which resulted in a stall/spin. Contributing to the accident was the pilot's impairment during the flight from the effects of over-the-counter medications.NTSB NYC08FA039Accident · 1 fatalField investigationFinal reportMooney M20K · Maine, NYThe pilot's spatial disorientation, which resulted in a loss of control and subsequent collision with trees.NTSB NYC08CA037Accident · No injuriesData collectionFinal reportCessna 172N · Statesboro, GAThe student pilot's failure to maintain a proper flare at touchdown.NTSB CHI08LA040Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Sport Cruiser · Waukegan, ILThe pilot's failure to assure that all of his tools were accounted for prior to takeoff which resulted in the foreign object jamming the control stick and the pilot's inability to maintain control of the airplane. A factor associated with the accident was the…NTSB NYC08CA036Accident · Minor injuriesData collectionFinal reportCessna 120 · Ocala, FLThe pilot's failure to maintain proper runway alignment during landing.NTSB SEA08CA026Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Sedona, AZThe pilot's inadequate compensation for the wind condition, which resulted in his failure to maintain directional control during takeoff. Factors associated with the accident included the gusty crosswind condition and the taxiway sign.NTSB SEA08LA066Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Benson, AZThe pilot's inadequate compensation for wind conditions, and his failure to maintain sufficient airspeed to avoid a stall. Contributing to the accident was a variable tailwind.NTSB SEA08LA024Accident · Serious injuriesLimited investigationFinal reportTitan Tornado I · McMinnville, ORThe failure of the pilot to maintain an adequate airspeed during the initial climb after takeoff that resulted in an inadvertent stall. Contributing to the accident was the pilot's unfamiliarity with the accident airplane.NTSB NYC08CA032Accident · No injuriesData collectionFinal reportBrand, Richard Bateleur 2000 · West Ossipee, NHThe pilot's failure to maintain aircraft control, while practicing aerobatics.NTSB NYC08LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Hollywood, FLThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall. Contributing to the accident were an inoperative stall warning system and an erroneous airspeed indicator.NTSB SEA08FA022Accident · 1 fatalField investigationFinal reportHughes 269C · Baker City, ORThe pilot’s failure to maintain main rotor rpm while maneuvering.NTSB NYC08LA024Accident · 2 fatalLimited investigationFinal reportBlondin 601HDS · Farmington, DEThe reason for this occurrence could not be determined.NTSB NYC08CA025Accident · Serious injuriesData collectionFinal reportBurkhart Grob G 103 Twin II · Windham, NYAn inadvertent encounter with a wind gust while maneuvering.NTSB CHI08FA033Accident · 1 fatalField investigationFinal reportCessna 172I · Gladwin, MIThe pilot's failure to maintain aircraft control while maneuvering at a low altitude. Contributing to the accident was the pilot's diverted attention while attempting to photograph ground objects.NTSB SEA08LA017Accident · 1 fatalLimited investigationFinal reportKelly F1D · Reno, NVThe pilot's loss of airplane control while performing intentional approach to stall maneuvers. Contributing to the accident was the inadvertent entry of the airplane into a spin.NTSB MIA08CA011Accident · Serious injuriesData collectionFinal reportSmith Miniplane DSA-1 · Alburgh, VTThe pilot's failure to maintain control of the airplane during aerobatic maneuvers which resulted in a loss of control and in-flight collision with trees.NTSB CHI08LA031Accident · 1 fatalLimited investigationFinal reportWRB Associates Zodiac 601 XL · La Belle, MOThe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was the pilot's lack of recent flight experience and his total lack of experience in the accident airplane model.NTSB LAX08CA022Accident · No injuriesData collectionFinal reportBagnall Harold E Kitfox Lite 2 · N. Bonneville, WAThe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude that resulted in a stall-mush condition and collision with the water.NTSB LAX08FA023Accident · 1 fatalField investigationFinal reportCessna 172S · Palm Springs, CAThe flight instructor's failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb, and his impairment from alcohol.NTSB CHI08CA030Accident · No injuriesData collectionFinal reportCessna 172M · Duluth, MNThe pilot's inadequate compensation for wind conditions during the landing approach. Contributing to the accident was the crosswind weather condition.NTSB LAX08FA001Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Cedar City, UTThe pilot's failure to maintain aircraft control while in cruise flight due to spatial disorientation. Contributing to the accident were the dark conditions.