NTSB investigations
8,203 cases where the first occurrence was “Loss of control - in flight”.
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.\"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 MIA01LA114Accident · Serious injuriesLimited investigationFinal reportArnet Pereyra Aventura II · Rockledge, FLthe pilot's failure to maintain airspeed during takeoff/initial climb, which resulted in an inadvertent stall, an uncontrolled descent, and collision with the ground. Contributing to the accident was the pilot's distraction with the landing gear system.NTSB LAX01LA139Accident · Minor injuriesLimited investigationFinal reportBeech F-33A · Mobile, AZThe certified flight instructor's inadequate supervision of the dual student who failed to recognize the extent of the crosswind and lost directional control. A factor in the accident was the variable wind condition.NTSB IAD01LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Williamsport, PAThe pilot's premature raising of flaps resulting in his failure to establish a climb and his failure to maintain directional control.NTSB LAX01LA138Accident · No injuriesLimited investigationFinal reportCessna 180 · Tucson, AZthe pilot's failure to attain and maintain a sufficient airspeed, which resulted in an inadvertent stall/mush.NTSB ATL01LA046Accident · 1 fatalLimited investigationFinal reportJacques J. Mistrot Skybolt · Smithfield, NCThe pilot's failure to maintain control of the airplane during climb out that resulted in the in-flight collision with the ground. A factor was the physical impairment.NTSB MIA01FA108Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Marco Island, FLThe failure of the pilot to maintain control of the aircraft during a rejected landing and the collision with the terrain and mangrove trees. A finding in the investigation was the presence of quinine in the blood and urine during postmortem toxicological…NTSB FTW01LA091Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-3 · Decatur, TXthe pilot's failure to maintain aircraft control during the takeoff/initial climb. Contributing factors were the pilot's exceeding aircraft weight and balance limits and the dust devil.NTSB LAX01FA129Accident · 3 fatalField investigationFinal reportCessna 172N · Santa Monica, CAthe pilot's loss of airplane control while maneuvering due to spatial disorientation. Contributing factors were the dark night, the marine cloud layer that restricted the pilot's cruising altitude, and the pilot's lack of familiarity with nighttime flight…NTSB DEN01FA075Accident · 1 fatalField investigationFinal reportSocata TBM 700 · Englewood, COthe pilot's spatial disorientation, which led to his failure to maintain aircraft control. A contributing factor was the pilot's decision to intentionally fly into known adverse weather that consisted of low ceilings, obscuration, and ice fog.NTSB DEN01FA074Accident · 2 fatalField investigationFinal reportVangilder Christen Eagle II · Ogden, UTthe flight instructor's failure to maintain aircraft control while maneuvering and the subsequent inadvertent stall/spin. A contributing factor was the flight instructor's lack of familiarity with the airplane.NTSB LAX01LA120Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28C · Hollister, CAthe pilot's inadequate use of the antitorque controls and subsequent failure to maintain directional control of the helicopter during the takeoff initial climb.NTSB CHI01FA104Accident · Minor injuriesField investigationFinal reportAirbus Industrie A320-200 · Detroit, MIThe pilot induced oscillations and the delay in aborting the takeoff. Factors associated with the accident were the first officer used an improper trim setting and the captain did not identify and correct the setting during the taxi checklist, and the wet…NTSB FTW01LA080Accident · No injuriesLimited investigationFinal reportCessna 210D · Lawton, OKthe pilot's failure to maintain aircraft control during the landing flare/touchdown. A contributing factor was the crosswind.NTSB CHI01FA100Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Erhard, MNThe pilot's failure to maintain aircraft control. Factors relating to the accident were the pilot's encounter with known adverse weather conditions, the low ceiling, the pilot disregarding the weather observation information obtained prior to the flight, and…NTSB IAD01LA036Accident · No injuriesLimited investigationFinal reportLenart Rotorway Exec 162F · Wallingford, CTflight instructor's failure to follow published checklist procedures, which resulted in the forward ballast weight not being moved to the tailboom prior to departure.NTSB FTW01LA073Accident · No injuriesLimited investigationFinal reportHughes 369D · Canadian, TXthe helicopter's encounter with loss of tail rotor effectiveness while hovering out-of-ground effect, and the pilot's failure to maintain control. A contributing factor was the soft terrain condition.NTSB DEN01FA058Accident · 1 fatalField investigationFinal reportBell 412SP · Grand Junction, COthe pilot's failure to maintain rotor speed during an intentional autorotation, which resulted in a loss of control.NTSB DEN01FA056Accident · 1 fatalField investigationFinal reportBeech V35B · Green River, UTthe pilot's failure to maintain aircraft control as a result of incapacitation (from hypoxia) due to the in-flight decision to fly at altitudes where oxygen is required, without oxygen available.NTSB LAX01FA103Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Paso Robles, CAThe pilot/owner/operator's failure to maintain control of the airplane during the takeoff initial climb resulting in an in-flight collision with terrain. Contributing to the accident was the dark night light condition.NTSB CHI01FA093Accident · 2 fatalField investigationFinal reportCessna 172H · Centralia, ILThe student pilot allowed the airspeed to get too low and inadvertently stalled the airplane, and the CFI delayed in taking remedial action.NTSB MIA01LA082Accident · 4 fatalLimited investigationFinal reportBeech 36 · Tybee Island, GAThe flights entry into a descending right turn for undetermined reasons resulting in the flight crashing into the ocean.NTSB CHI01FA113Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Norris, SDThe pilot encountering instrument meteorological conditions and his subsequent loss of control of the airplane.NTSB DEN01FA053Accident · 1 fatalField investigationFinal reportRoss G-202 · Grand Junction, COthe pilot's inadvertent entry into a spin while performing aerobatic maneuvers. A contributing factor was the pilot's lack of aerobatic experience.NTSB MIA01FA075Accident · 2 fatalField investigationFinal reportBrantly B-2B · Archer, FLThe flight crew's loss of control for undermined reasons.NTSB ATL01LA034Accident · Serious injuriesLimited investigationFinal reportJack McDaniel Rans S-12 · Homestead, FLThe pilots failure to maintain flying speed during a soft field takeoff, that resulted in the loss of control and a stall/ spin.NTSB LAX01LA095Accident · No injuriesLimited investigationFinal reportBeech A36 · Palo Alto, CAThe pilot-in-command's delayed decision to go-around and his failure to maintain sufficient airspeed during the attempted go-around. His non-verification of the flap setting contributed to the accident.NTSB CHI01LA082Accident · Serious injuriesLimited investigationFinal reportBeech 65-B80 · Sioux Falls, SDThe pilot initiated the flight into known icing conditions which resulted in his ability to maintain control of the airplane. Factors associated with the accident were the ice accumulation and the company induced pressure for the pilot to make the flight into…NTSB LAX01LA093Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Pixley, CAA loss of control during takeoff due to the helicopter's heavy gross weight condition that exceeded its lifting capability.NTSB ATL01LA031Accident · Serious injuriesLimited investigationFinal reportSorrell SNS-2 Guppy · Raymond, MSThe failure of the rudder horn bracket, that resulted in the inflight loss of control.NTSB MIA01FA071Accident · 2 fatalField investigationFinal reportMooney M20R · Bluffton, SCThe pilot's failure to maintain control due to spatial disorientation.NTSB LAX01LA091Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Lake Elsinore, CAThe failure of the glider pilot to maintain adequate airspeed during a turn from base leg to final approach, which lead to a stall and spin.NTSB MIA01GA070Accident · 2 fatalFinal reportPiper PA-32-300 · Marathon, FLThe pilot-in-command's lack of recent experience in instrument flight resulting in the pilot becoming spatially disoriented, and subsequent in-flight collision with water while descending.NTSB SEA01LA043Accident · No injuriesLimited investigationFinal reportS.N.I.A.S SE 3130 Alouette II · Driggs, IDThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB NYC01FA071Accident · 1 fatalField investigationFinal reportSchempp-Hirth Discus CS · Wurtsboro, NYThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin while on base leg.NTSB MIA01LA064Accident · No injuriesLimited investigationFinal reportRobinson R22 · Long Beach, MSThe student pilot's failure to relinquish the flight controls while the CFI was demonstrating a takeoff to a hover. This resulted in an in-flight loss of directional control, in-flight collision with terrain, and subsequent roll over.NTSB LAX01LA080Accident · Minor injuriesLimited investigationFinal reportCessna 182RG · Douglas, AZThe student's failure to maintain control of the airplane during the go-around and his premature retraction of the landing gear. A factor was the flight instructor's inadequate supervision of the flight.NTSB MIA01FA060Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Bethel, NCthe pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an in-flight collision with power lines and the subsequent impact with terrain. A factor in this accident was: the pilot's lack of recent instrument…NTSB LAX01FA070Accident · 2 fatalField investigationFinal reportCessna 172F · San Luis Obispo, CAThe pilot's failure to maintain a proper climb rate to VFR conditions on-top.NTSB DEN01LA037Accident · No injuriesLimited investigationFinal reportCessna 177 · Las Cruces, NMAn inadvertent stall. Factors were excessive airspeed, excessive flare, and improper recovery from a bounced landing.NTSB LAX01LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rosamond, CAThe pilot's improper airplane handling technique and inadequate airspeed during performance of an intentional soft field takeoff.NTSB FTW01FA043Accident · 1 fatalField investigationFinal reportBell 407 · Gilchrist, TXThe loss of control for reasons undetermined.NTSB DEN01FA033Accident · 2 fatalField investigationFinal reportBeech V35B · Albuquerque, NMthe pilot's failure to maintain aircraft control and the inadvertent stall. Factors contributing to the accident were the pilot's improper in-flight planning, his lack of recent flying experience, and the abrupt maneuver to correct to the proper runway.NTSB LAX01LA063Accident · Minor injuriesLimited investigationFinal reportBell 206-L3 · Wilcox, AZThe pilot's incapacitation that resulted from nausea during the final approach to landing. The pilot collapsed on the cyclic, which precipitated inadvertent contact between the main rotor blades and the ground. Factors were hilly terrain on a dark night,…NTSB FTW01LA042Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B2 · Mesquite, TXThe student pilot's abrupt control input, which resulted in a tail rotor blade strike. Factors were the CFI's delay in taking remedial action and the student pilot's lack of total experience.NTSB CHI01FA052Accident · 1 fatalField investigationFinal reportBeech BE-23 · Rolla, MOThe pilot's inadequate preflight during the pre-buy inspection, the pilot's incapacitation due to carbon monoxide, and the fractured muffler.NTSB FTW01LA039Accident · No injuriesLimited investigationFinal reportRobinson R22 · Sunnyvale, TXThe flight instructor's inadequate supervision of his student and his failure to maintain control of the helicopter. Factors were the student pilot allowing the airspeed and main rotor RPM to get too low during the simulated emergency.NTSB FTW01LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKthe certified flight instructor's (CFI) failure to maintain directional control of the airplane during landing. A contributing factor was the gusty wind condition.NTSB MIA01FA043Accident · 1 fatalField investigationFinal reportPiper PA-31-325 · Belvidere, NCThe pilot's failure to maintain airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions resulting in the airplane entering a descending turn and crashing into terrain.NTSB MIA01FA041Accident · 2 fatalField investigationFinal reportChristen Industries Pitts S-2B · Weston, FLAn inflight loss of control by both pilots while maneuvering, which resulted in an inverted flat spin, an uncontrolled descent, and an impact with terrain/water. A factor contributing to the accident was the failure of both pilots to ensure that the…NTSB LAX01GA057Accident · 1 fatalFinal reportCessna 182P · Lancaster, CAthe pilot's in-flight loss of control for undetermined reasons.