NTSB investigations
5,010 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR13CA428Accident · Minor injuriesData collectionFinal reportCessna 182Q · Big Bear, CAThe pilot's failure to maintain a stabilized landing approach, which resulted in a collision with a fence short of the runway.NTSB CEN13CA564Accident · Serious injuriesData collectionFinal reportTreidel Mark/R F D Dominator · Watkins, COThe pilot's loss of control of the gyroplane during takeoff roll, following his inadvertent release of the cyclic control.NTSB CEN13FA558Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Bolingbrook, ILThe pilot’s failure to maintain control of the airplane during a go-around.NTSB CEN13WA566Accident · 4 fatalForeign investigationCessna 421 - C · Colombier-Saugnieu, FranceNTSB CEN13LA555Accident · Serious injuriesLimited investigationFinal reportBuckeye Industries Dream Machine · St. Joseph, MIThe pilot's failure to maintain control of the powered-parachute during takeoff.NTSB ERA13WA430Accident · 3 fatalForeign investigationCessna R172K · Morona Santiago, EcuadorNTSB ERA13FA424Accident · 1 fatalField investigationFinal reportBrown Robert K RV7A · Hamilton Township, NJThe pilot's improper aerobatic maneuver that resulted in a loss of control, exceedance of the airplane's design limitations, and a subsequent in-flight breakup of the airplane.NTSB ERA13CA417Accident · Serious injuriesData collectionFinal reportMiller/Culpepper Christen Eagle II · Blythe, GAThe pilot's failure to maintain aircraft control during takeoff which resulted in a stall and collision with terrain.NTSB CEN13IA563Incident · Minor injuriesIncident investigationFinal reportPilatus PC-12/47E · Austin, TXThe pilot’s improper weight and balance calculations, which resulted in the airplane exceeding its weight and center-of-gravity limits and led to a loss of pitch control during takeoff, and the operator’s failure to obtain required weight information and to…NTSB WPR13FA405Accident · 2 fatalField investigationFinal reportKamtz RV-7A · Jackson Hole, WYA loss of engine power for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation. Also causal was the pilot’s failure to adequately compensate for the…NTSB ERA13FA412Accident · Serious injuriesField investigationFinal reportJoseph Bender Mustang II · Smoketown, PAThe pilot/owner/builder's failure to abort the takeoff and his subsequent failure to maintain airplane control. Contributing to the accident were the pilot's total lack of experience in the accident airplane and his lack of flying experience in the 3 1/2…NTSB CEN13CA538Accident · No injuriesData collectionFinal reportCessna 182J · Hyannis, NEThe pilot did not adequately compensate for the gusty wind conditions which resulted in a loss of directional control during the landing.NTSB WPR13FA399Accident · 1 fatalField investigationFinal reportTyler Ives SD-1 TG · Spanish Fork, UTThe pilot’s failure to maintain airplane control while performing prohibited aerobatic maneuvers and the deployment and separation of the ballistic parachute system from the airframe for reasons that could not be determined due to the severity of impact…NTSB ANC13FA093Accident · 1 fatalField investigationFinal reportCessna 170B · Glennallen, AKThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall/spin and impact with the ground.NTSB CEN13LA539Accident · Minor injuriesLimited investigationFinal reportCessna T207 · Colorado Springs, COThe pilot’s failure to establish the proper pitch attitude and airspeed during takeoff with the engine at maximum power, which resulted in the exceedance of the airplane’s climb performance capability.NTSB WPR13LA398Accident · Serious injuriesLimited investigationFinal reportStrong Dream Machine · Bieber, CAThe pilot’s inability to maintain aircraft control during takeoff after several suspension lines became entangled in, and were subsequently severed by, the propeller blades.NTSB ANC13CA092Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot's decision to take off from a remote, rough landing site in gusty wind conditions, which resulted in a loss of control.NTSB CEN13LA518Accident · Minor injuriesLimited investigationFinal reportAmerican Champion 7GCB · Pearsall, TXThe failure of the rudder cable due to electrical arcing damage from contact with an unguarded battery and the pilot's subsequent loss of control during the go-around.NTSB ERA13CA400Accident · Minor injuriesData collectionFinal reportMaxair Drifter Drifter II · Lafayette, TNThe pilot's failure to maintain aircraft control during the initial climb after takeoff in gusty wind conditions, which resulted in a hard off-airport landing.NTSB CEN13CA521Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Osage Beach, MOThe pilot’s failure to maintain aircraft control during initial climb in gusty wind conditions.NTSB WPR13FA393Accident · 1 fatalField investigationFinal reportStuart Vortex · Scappoose, ORThe student pilot's unintentional takeoff followed by his failure to maintain control of the gyroplane during the landing approach. Contributing to the accident was the student pilot’s lack of both flight training and flight experience and his lack of a solo…NTSB CEN13CA530Accident · No injuriesData collectionFinal reportAeronca 7EC · Plattsmouth, NEThe pilot's loss of control during takeoff.NTSB ANC13FA091Accident · 1 fatalField investigationFinal reportPiper PA-18A · Nikolai, AKThe pilot’s improper decision to load the airplane beyond its allowable takeoff weight and center of gravity limits, which resulted in a loss of control during the initial climb. Contributing to the accident was the external load and the downwind takeoff.NTSB ERA13FA388Accident · 1 fatalField investigationFinal reportCessna 172 · Limington, MEAn impairing medical event of undetermined origin that led to a loss of control during takeoff.NTSB ERA13CA392Accident · Minor injuriesData collectionFinal reportCessna 172L · McComb, MSThe pilot’s failure to maintain adequate airspeed during approach to landing, which resulted in an aerodynamic stall and subsequent loss of control.NTSB ERA13FA385Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Danville, VAThe student pilot's failure to maintain control and climb the airplane during a go-around maneuver. Contributing to the accident was the flight instructor's failure to provide adequate oversight of the student pilot by ensuring that the cockpit was free of…NTSB CEN13LA546Accident · Minor injuriesLimited investigationFinal reportBrantly B-2B · Rothbury, MIThe pilot’s failure to maintain helicopter control while turning to avoid trees during an aborted takeoff in gusting wind conditions.NTSB ANC13FA090Accident · 2 fatalField investigationFinal reportChampion 7ECA · Sutton, AKThe pilot’s failure to maintain airplane control while maneuvering at low altitude, which resulted in an aerodynamic stall/spin and collision with terrain. Contributing to the accident was the pilot’s use of marijuana, which likely degraded his psychomotor…NTSB ERA13CA383Accident · No injuriesData collectionFinal reportCessna 150L · Chestertown, MDThe student pilot's improper control inputs which resulted in a loss of control and aerodynamic stall. Contributing to the accident was the flight instructor's delayed remedial action.NTSB CEN13FA509Accident · 1 fatalField investigationFinal reportCessna 421C · Paris, ILThe pilot's failure to abort the takeoff during the ground roll after detecting the airplane's degraded performance. Contributing to the accident was the pilot's decision to attempt a flight with a known problem with the left engine and the likely partial…NTSB WPR13FA388Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Desert Center, CAThe pilot's abrupt maneuver, which resulted in an accelerated stall and a loss of airplane control at low altitude.NTSB CEN13LA507Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Clayton, NMThe pilot's loss of vertical control after the helicopter encountered a gusty tailwind while maneuvering at a low altitude and near the helicopter's maximum gross weight.NTSB ERA13FA372Accident · 2 fatalField investigationFinal reportAeronca 7AC · Taunton, MAThe pilot/owner’s inadequate preflight inspection and inadequate pretakeoff check of the flight controls, which resulted in a takeoff with the rudder gust lock installed. Contributing to the accident was the pilot-rated passenger’s failure to detect that the…NTSB ERA13LA374Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Marco Island, FLThe pilot’s improper pitch trim setting before takeoff, which resulted in the airplane’s rapid, nose-high pitch at takeoff and the pilot’s subsequent loss of control.NTSB ANC13FA084Accident · 2 fatalField investigationFinal reportCessna 150L · Anchorage, AKA loss of engine power due to fuel starvation as a result of a low fuel state and a nose-high attitude during a go-around, which unported the fuel tank feed line, and the pilot's decision to make a low-altitude turn back to the airport, which resulted in an…NTSB ANC13CA083Accident · Minor injuriesData collectionFinal reportPiper PA-18A · Talkeetna, AKThe pilot's failure to maintain directional control during takeoff.NTSB CEN13CA501Accident · No injuriesData collectionFinal reportMcdonnell Douglas Heli 369FF · Reese, MIThe failure of the temporary hoist holding the powerline wire which resulted in a brief loss of control and main rotor blade impacts with the tower.NTSB ANC13LA081Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Palmer, AKThe pilot’s failure to maintain adequate airspeed during initial climb after takeoff, which resulted in a subsequent aerodynamic stall. Contributing to the accident was the pilot’s decision to take off with a slight tailwind.NTSB WPR13FA380Accident · 1 fatalField investigationFinal reportNelson KR-2 · Cataldo, IDThe pilot’s decision to intentionally enter a spin in the airplane, which had unknown spin characteristics due to the engine modification, from which he was unable to recover.NTSB CEN13FA496Accident · 2 fatalField investigationFinal reportMooney M20J · Kansas City, MOThe pilot's improper decision to attempt continued flight after a momentary loss of engine power with usable runway remaining. Contributing to the accident were the pilot's premature retraction of the landing gear, the loss of engine power due to fuel system…NTSB CEN13CA575Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Mariner · Lee's Summit, MOThe student pilot's improper flare while performing an autorotation and the flight instructor's delayed remedial action to correct the high sink rate, which resulted in a hard landing.NTSB CEN13CA494Accident · No injuriesData collectionFinal reportGlobe GC-1B · Santa Teresa, NMThe pilot's loss of directional control during the final approach due to an inadvertent encounter with a dust devilNTSB ANC13WA103Accident · Serious injuriesForeign investigationBeech A36 - TC · Ami, JapanOn August 18, 2013, about 0520 coordinated universal time (UTC), a Japaneese registered Beechcraft A36 airplane, JA4152, lost control during a go-around near Ami, Japan. The pilot and one passenger were seriously injured, and two passengers sustained minor…NTSB ERA13LA366Accident · No injuriesLimited investigationFinal reportInterstate S-1B1 · Lititz, PAThe pilot’s failure to control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the initial takeoff climb. Contributing to the accident was the pilot’s failure to set the trim in accordance with the pretakeoff checklist and the…NTSB WPR13FA376Accident · 2 fatalField investigationFinal reportUrban Air Sro Samba XXL · Carson City, NVThe pilot's failure to maintain adequate airspeed while maneuvering, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin. Contributing to the accident was the improper location of the parachute…NTSB CEN13LA493Accident · Serious injuriesLimited investigationFinal reportTrick Trikes Storm Trooper · Covert, MIThe student pilot’s loss of control while maneuvering at low altitude over a congested beach area. Contributing to the accident was the pilot’s ostentatious display.NTSB WPR13CA373Accident · Minor injuriesData collectionFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Las Vegas, NVThe pilot's failure to maintain aircraft control during the initial climb following an aborted landing. Contributing to the accident was the pilot's inaccurate fuel planning which resulted in a low fuel state and subsequent precautionary off airport landing.NTSB WPR13FA370Accident · 2 fatalField investigationFinal reportChampion 7GCAA · Paradise, CAThe pilot's failure to maintain airplane control during low-altitude maneuvering after encountering an updraft.NTSB WPR13FA368Accident · 1 fatalField investigationFinal reportBeech E35 · West Yellowstone, MTThe pilot's failure to maintain airplane control while aligning the airplane with the runway for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's…NTSB WPR13CA367Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Hesperia, CAThe pilot’s failure to maintain sufficient airspeed on final approach to landing which resulted in an inadvertent stall.