NTSB investigations
5,011 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 CEN20CA152Accident · No injuriesData collectionFinal reportCessna 172 · Enid, OKThe flight instructor's delayed remedial action during a power-off approach and go-around in gusting wind conditions, which resulted in a hard landing, loss of directional control, and a runway excursion onto a field.NTSB ERA20WA172Accident · 1 fatalForeign investigationComp Air CA-8 · Campo Verde, BrazilThe government of Brazil has notified the NTSB of an accident involving an amateur-built COMP AIR CA-8 airplane that occurred on April 13, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under…NTSB ANC20LA043Accident · Serious injuriesClass 3 · LimitedFinal reportCessna A185E · Eagle River, AKThe pilot’s failure to ensure adequate fuel onboard prior to the planned flight, resulting in a total loss of engine power due to fuel exhaustion and an aerodynamic stall during the subsequent emergency landing. Contributing to the accident was the pilot’s…NTSB WPR20LA122Accident · No injuriesClass 3 · LimitedFinal reportBuckman Bucks Special · Prescott, WADiminished engine performance due to carburetor icing conditions and multiple mechanical anomalies that did not allow for the airplane to attain adequate airspeed during takeoff from a planted field and failure to maintain clearance from obstructions.…NTSB WPR20LA118Accident · 1 fatalClass 3 · LimitedFinal reportKolb Firestar 2 · La Center, WAA loss of control for reasons that could not be determined based on the available information.NTSB CEN20CA144Accident · No injuriesData collectionFinal reportRobinson R22 · Seymour, TXThe pilot's failure to maintain clearance from a tree while maneuvering at low altitude.NTSB ERA20CA143Accident · No injuriesData collectionFinal reportDiamond DA42 · Palm Coast, FLThe pilot receiving instruction’s failure to maintain airplane control during a simulated engine failure landing and subsequent attempted go-around in gusting crosswind conditions and the flight instructor's delayed remedial action.NTSB CEN20LA134Accident · 1 fatalClass 3 · LimitedFinal reportMuse P51D · Mesquite, TXThe pilot’s inadvertent exceedance of the airplane’s critical angle of attack for undetermined reasons, which resulted in an aerodynamic stall, loss of control, and subsequent impact with terrain.NTSB WPR20WA202Accident · No injuriesForeign investigationRotorcraft Development Corpora UH1-D · Tsumeb, NamibiaThe government of Namibia has notified the NTSB of an accident involving a Rotorcraft Development Corporation UH1-D helicopter, registration V5-HOZ, that occurred on March 24, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB ERA20LA134Accident · 2 fatalClass 3 · LimitedFinal reportMaule MT-7 · Swansboro, NCThe airplane’s turning descent into water while enroute in night instrument meteorological conditions for reasons that could not be determined.NTSB WPR20CA113Accident · No injuriesData collectionFinal reportJust JA30 Superstol · Puyallup, WAThe pilot's failure to maintain airplane control during landing in gusting crosswind conditions, which resulted in the wing striking the ground.NTSB CEN20LA127Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28R · Pleasant Plain, OHThe pilot’s encounter with convective turbulence and low-level wind shear in dark night instrument meteorological conditions that resulted in spatial disorientation and the loss of airplane control.NTSB ERA20LA129Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Conway, SCThe pilot’s incorrect use of the autopilot while approaching the initial approach fix and his subsequent improper primary pitch control input while a pitch mode of the autopilot was engaged, which resulted in pitch excursions and subsequent departure from…NTSB CEN20LA122Accident · 1 fatalClass 3 · LimitedFinal reportCessna 208 · LaCrosse, KSAn infight loss of control as a result of pilot impairment, the cause of which could not be determined.NTSB ANC20CA034Accident · Minor injuriesData collectionFinal reportCessna 172 · Kahului, HIThe student pilot's failure to avoid wake turbulence while landing behind a heavy jet airplane, which resulted in a loss of roll control and subsequent hard landing.NTSB WPR20LA110Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Pinedale, WYA loss of airplane control during approach for reasons that could not be determined based on available evidence.NTSB GAA21WA049Accident · 1 fatalClass 4 · ForeignCessna 177 · Ebermannstadt, GermanyNTSB WPR20FA108Accident · 2 fatalClass 3 · FieldFinal reportMooney M20K · Sylmar, CAThe pilot’s spatial disorientation during an instrument approach in instrument meteorological conditions, which resulted in loss of control of the airplane.NTSB ERA20CA128Accident · Minor injuriesData collectionFinal reportStolp Starduster Acroduster II SA750 · Senoia, GAThe pilot's failure to see and avoid trees while maneuvering at low altitude, which resulted in a loss of airplane control.NTSB ERA20FA119Accident · 1 fatalClass 3 · FieldFinal reportAmerican AA 1 · Boynton Beach, FLThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, and his exceedance of the airplane’s critical angle of attack following the loss of engine power, which resulted in an aerodynamic stall and…NTSB ANC20LA028Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter EC130 · Kalapana, HIA loss of control due to the fatigue fracture of a tail rotor fenestron blade due to the geometry of the water drain hole positioning on the rib.NTSB ERA20FA118Accident · 3 fatalClass 3 · FieldFinal reportPiper PA46 · Bishop, GAThe pilot’s encounter with a rain shower updraft and severe turbulence, which resulted in a loss of airplane control and an inflight breakup. Contributing to the accident was the pilot’s reliance on outdated weather information on his in-cockpit weather…NTSB CEN20FA110Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Lincoln, ILThe pilot's exceedance of the airplane's critical angle of attack during an aerial survey, which resulted in an aerodynamic stall at an altitude too low to recover.NTSB ERA20CA116Accident · Serious injuriesData collectionFinal reportLet L 23 Super Blanik · Huntsville, ALThe pilot's failure to maintain glider control and his exceedance of the glider's critical angle of attack while maneuvering in gusting wind conditions, which resulted in an aerodynamic stall.NTSB CEN20FA108Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Port Isabel, TXThe pilot’s loss of control during the initial takeoff climb for reasons that could not be determined based on available evidence.NTSB CEN20CA106Accident · No injuriesData collectionFinal reportKitfox 57 Super Sport · Kosciusko, MSThe pilot's lifting off with the airplane at a high of angle of attack, which resulted in aerodynamic stall.NTSB WPR20CA095Accident · No injuriesData collectionFinal reportCessna 172 · Dubois, IDThe student pilot's failure to maintain a proper airspeed and descent rate while conducting a low pass over a snow-covered runway after encountering a downdraft and the flight instructor's delayed action, which resulted in the wheels contacting the snow and…NTSB WPR20LA096Accident · Minor injuriesClass 3 · LimitedFinal reportLightning Avion Eab Arion Lightning · Jerome, IDThe pilot’s mismanagement of fuel, which resulted in fuel starvation and the pilot’s loss of airplane control during an emergency descent, which resulted in a stall and subsequent impact with terrain.NTSB ERA20CA114Accident · No injuriesData collectionFinal reportCessna 172 · Everglades City, FLThe pilot's failure to maintain airplane control during the landing flare in gusting crosswind conditions, which resulted in the left wing striking the runway.NTSB WPR20CA093Accident · Minor injuriesData collectionFinal reportAviat A1 · Columbia, CAThe pilot's failure to maintain bank control during landing in gusting wind conditions.NTSB ANC20FA024Accident · 2 fatalClass 3 · FieldFinal reportCessna 305 · Mokuleia, HIA separation of the left rudder cable due to inadequate maintenance, which resulted in an in-flight loss of control and impact with terrain.NTSB CEN20WA097Accident · 1 fatalForeign investigationPiper PA60 · Pamplona, SpainThe National Transportation Safety Board was notified of an accident involving a Piper PA-60-602P, EC-HRJ, in Pamplona, Spain. This investigation is under the jurisdiction of the Comisión de Investigación de Accidentes e Incidentes de Aviación Civil in Spain.NTSB CEN20FA093Accident · 3 fatalClass 3 · FieldFinal reportBeech 200 · Coleman, TXThe pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s distraction with a “popped” circuit breaker and communications with air traffic control.NTSB ERA20LA105Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Fayetteville, NCThe passenger’s excessive control application during the takeoff and the flight instructor’s inadequate remedial action, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA20CA104Accident · No injuriesData collectionFinal reportSchweizer 269C · Ormond Beach, FLThe student pilot's improper pedal and cyclic input while maneuvering, which resulted in a loss of helicopter control.NTSB ERA20CA102Accident · No injuriesData collectionFinal reportCessna 172 · Rochester, NYThe pilot's failure to maintain airplane control during a go-around. Contributing to the accident was the pilot’s decision to take off after perceiving a rudder issue during taxi operations.NTSB CEN20TA088Accident · Minor injuriesClass 3Final reportCessna 170 · Valley Center, KSThe pilot's delayed decision to abort the takeoff when the airplane passed the point where he had anticipated the liftoff would occur.NTSB ERA20FA101Accident · 2 fatalClass 3 · FieldFinal reportMooney M20J · Bartow, FLThe pilot’s exceedance of the airplane's critical angle of attack and subsequent aerodynamic stall and spin at low altitude due to a possible distraction in the cockpit for which the reason was undetermined.NTSB GAA20WA111Accident · 4 fatalForeign investigationPiper PA31 · Guaymaral, ColombiaThe government of Colombia has notified the NTSB of an accident involving a PIPER PA31 airplane that occurred on February 12, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB ERA20FA097Accident · 1 fatalClass 3 · FieldFinal reportAviastroitel AC 4C · Front Royal, VAThe pilot's exceedance of the glider’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and subsequent loss of control.NTSB ERA20FA096Accident · 4 fatalClass 3 · FieldFinal reportCessna 501 · Fairmount, GAThe pilots’ loss of control in flight in freezing instrument meteorological conditions due to spatial disorientation and the cumulative effects of task saturation.NTSB CEN20FA075Accident · 3 fatalClass 3 · FieldFinal reportCessna 182 · Chatham, LAThe pilot’s encounter with icing in-flight, which resulted in a loss of control and impact with terrain.NTSB CEN20FA072Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Florence, COThe pilot’s decision to continue the takeoff with reduced airplane performance due to high density altitudeNTSB CEN20FA070Accident · 3 fatalClass 3 · FieldFinal reportPiper PA60 · Springfield, ILThe pilot’s failure to follow the instrument landing system (ILS) course guidance during the instrument approach.NTSB ERA20FA088Accident · 1 fatalClass 3 · FieldFinal reportAeropro CZ A220 · Grafton, WVThe pilot’s decision to continue a visual flight rules flight into instrument meteorological conditions and conditions favorable for airframe icing, which resulted in a loss of control of the airplane.NTSB DCA20MA059Accident · 9 fatalClass 1 · MajorFinal reportSikorsky S76 · Calabasas, CAThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s likely self-induced pressure…NTSB CEN20CA067Accident · Minor injuriesData collectionFinal reportGlasair 1 · Greenville, TXThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing, and his subsequent loss of airplane control during an attempted go-around.NTSB WPR20FA079Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Payson, AZThe pilot's decision to fly into a canyon with rising terrain, and his subsequent loss of aircraft control while maneuvering away from rising terrain.NTSB GAA20WA110Accident · 1 fatalForeign investigationExtra E54T · Iztapa, GuatemalaNTSB GAA20WA107Accident · 2 fatalForeign investigationPiper PA28 · Chatel-St-Denis, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a PIPER PA28 airplane that occurred on January 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…