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 CEN20WA426Accident · 3 fatalClass 5 · ForeignCirrus SR22 · Le Chevillotte, FranceNTSB WPR20LA319Accident · 1 fatalClass 3 · LimitedFinal reportCessna T182 · Santa Barbara, CAThe pilot’s loss of airplane control due to spatial disorientation after entering instrument meteorological conditions.NTSB CEN20LA430Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46R-350T · Rogers, ARThe pilot’s inadvertent loss of aircraft control, resulting in substantial damage to the airframe during the spin recovery.NTSB ERA20LA336Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · La Grange, NCThe pilot’s failure to maintain directional control during final approach, which resulted in a collision with trees.NTSB ERA20LA330Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA25 · Floral City, FLThe pilot’s failure to see and avoid a tree while flying towards the rising sun during an aerial application flight, which resulted in a collision with the tree and a subsequent loss of airplane control.NTSB WPR20LA323Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopter 369 · Chemehuevi Valley, CAThe pilot’s failure to maintain helicopter control during an approach with a gusting variable wind, which resulted in an impact with terrain.NTSB GAA20WA139Accident · 1 fatalClass 5 · ForeignCessna 172 · Riyadh, Saudi ArabiaNTSB ERA20LA329Accident · 1 fatalClass 3 · LimitedFinal reportCessna 182 · Lincolnton, GAThe pilot's loss of airplane control while maneuvering at a low altitude.NTSB CEN20WA409Accident · 1 fatalClass 5 · ForeignPitts S1 · Kulmbach, GermanyNTSB CEN20LA415Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · San Antonio, TXThe pilot’s inadequate compensation for gusting crosswind conditions while landing, which resulted a loss of lateral control and impact with a fence.NTSB CEN20LA402Accident · 4 fatalClass 3 · LimitedFinal reportPiper PA46 · Hilltop Lakes, TXThe loss of engine power for reasons that could not be determined and the pilot’s failure to maintain control of the airplane which resulted in an aerodynamic stall and spin. Contributing to the accident was the pilot’s failure to establish and maintain a…NTSB WPR20LA310Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV4 · Clovis, NMThe pilot’s failure to maintain lateral control during initial climb due to distraction, which resulted in an in-flight upset and impact with terrain.NTSB CEN20WA408Accident · 2 fatalForeign investigationRaven Aircraft Corppration Raven · Moosburg an der Isar, GermanyNTSB CEN20LA400Accident · 1 fatalClass 3 · LimitedFinal reportSafari S · Red Bud, ILA loss of control for reasons that could not be determined.NTSB CEN20LA399Accident · 2 fatalClass 3 · LimitedFinal reportVans RV9 · Zeeland, MIThe pilot’s failure to maintain airspeed during a visual approach in dark night conditions, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the pilot’s lack of recent flight experience at night.NTSB CEN20CA406Accident · Minor injuriesClass 4 · Data collectionFinal reportPik PIK-20D · Union, ILThe pilot’s failure to maintain directional control during takeoff that resulted in a collision with another glider that was parked close to the departure runway, and the pilot’s improper decision to attempt a takeoff without ensuring he had safe clearance…NTSB ERA20LA323Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Hollywood, FLThe pilot's failure to maintain directional control during a crosswind takeoff, which resulted in a collision with airport lights and a sign.NTSB CEN20CA404Accident · No injuriesClass 4 · Data collectionFinal reportCubcrafters CC11 · Larkspur, COThe pilot’s failure to maintain control of the airplane while taking off in gusting quartering tailwind conditions.NTSB CEN20CA396Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA46 · Jacksonville, TXThe student pilot’s failure to maintain control of the airplane during the landing approach and the exceedance of the airplane’s critical angle of attack at low altitude resulting in an aerodynamic stall. Contributing was the instructor pilot’s failure to…NTSB GAA20WA137Accident · 2 fatalForeign investigationRans S6 · Lasne, BelgiumThe government of Belgium has notified the NTSB of an accident involving a RANS S6 airplane that occurred on September 13, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions…NTSB ERA20LA315Accident · 2 fatalClass 3 · LimitedFinal reportVans RV9 · Steinhatchee, FLThe failure of the air traffic controller to provide hazardous weather information to the pilot, resulting in the flight’s encounter with strong updraft conditions, an inflight loss of airplane control, and an in-flight breakup. Contributing was the pilot’s…NTSB CEN20LA389Accident · 2 fatalClass 3 · LimitedFinal reportChampion 8KCAB · Groton, SDThe pilot’s loss of airplane control during a low-altitude aerobatic maneuver.NTSB WPR20LA303Accident · 2 fatalClass 3 · LimitedFinal reportNavion B · Van Nuys, CAThe pilot’s failure to maintain control of the airplane during an abrupt turn after takeoff at a low altitude, which resulted in an aerodynamic stall.NTSB GAA20WA147Incident · No injuriesClass 5 · ForeignBellanca 8KCAB · Roskilde, DenmarkNTSB ERA20LA314Accident · 1 fatalClass 3 · LimitedFinal reportZenair CH750 Cruzer · Boaz, ALThe pilot’s failure to maintain control of the airplane, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing was the pilot’s continued visual flight rules flight into an area of low clouds.NTSB ERA20LA312Accident · 1 fatalClass 3 · LimitedFinal reportQuad City Challenger · Sweetwater, TNA loss of control for reasons that could not be determined based on the available information.NTSB ERA20CA319Accident · No injuriesClass 4 · Data collectionFinal reportRotorway Exec 162F · Kenansville, FLThe pilot’s failure to maintain control of the helicopter during takeoff.NTSB ERA20LA309Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA28 · McMinnville, TNA total loss of engine power due to a fatigue failure in a cylinder, and the pilot’s subsequent failure to maintain airspeed and her exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude.NTSB CEN20LA383Accident · Minor injuriesClass 3 · LimitedFinal reportStearman A75N1(PT17) · Henderson, TXThe pilot’s failure to maintain proper airspeed, resulting in an aerodynamic stall after takeoff.NTSB CEN20LA379Accident · 4 fatalClass 3 · LimitedFinal reportCirrus SR22 · Chester, ARThe noninstrument-rated pilot’s continued flight into dark night instrument meteorological conditions which resulted in spatial disorientation and a subsequent loss of airplane control.NTSB ERA20CA307Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 170 · Morrisville, VTThe pilot's failure to maintain directional control and subsequent exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall and collision with terrain.NTSB CEN20LA375Accident · 1 fatalClass 3 · LimitedFinal reportTitan Mustang T-51 · Brighton, COThe pilot’s loss of airplane control while maneuvering in the traffic pattern.NTSB ERA20LA305Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA20 · Luray, VAThe noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, and collision with terrain.NTSB ANC20LA086Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA 14 · Wasilla, AKThe pilot’s failure to maintain airplane control during an attempted go-around in gusting wind conditions, which resulted in impact with trees.NTSB ERA20CA300Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Millington, MDThe pilot’s misidentification of a corn field for the destination airport’s runway, and a subsequent aerodynamic stall at low altitude while attempting to land.NTSB ANC20CA091Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Lime Village, AKThe pilot’s loss of control during the landing flare, which resulted in an impact with trees.NTSB ERA20CA303Accident · No injuriesClass 4 · Data collectionFinal reportZenith CH601 · Punta Gorda, FLAn inadvertent opening of the airplane’s canopy on takeoff, which resulted in a loss of control and runway excursion.NTSB GAA20WA134Accident · 1 fatalForeign investigationBeech 35 · Teresina, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH 35 airplane that occurred on August 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB WPR20WA292Accident · 1 fatalForeign investigationCessna 172 · Springs, South AfricaThe government of South Africa has notified the National Transportation Safety Board (NTSB) of an accident involving a Cessna 172 airplane that occurred on August 26, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB GAA20WA132Accident · 2 fatalClass 5 · ForeignAviamilano Falco F8L · Sibari, ItalyNTSB CEN20LA365Accident · 1 fatalClass 3 · LimitedFinal reportCessna T210 · Peyton, COThe pilot’s failure to maintain adequate airspeed and the exceedance of the airplane’s critical angle of attack during the airplane’s turn to final, resulting in an aerodynamic stall.NTSB ANC20CA088Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Kotzebue, AKThe pilot's failure to maintain an airspeed conducive to flight during takeoff.NTSB ANC20CA087Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Lake Louise, AKThe pilot’s decision to takeoff in shifting winds from a remote unimproved gravel bar, which resulted in a failure to attain an airspeed suitable for flight and a loss of control.NTSB CEN20LA354Accident · 1 fatalClass 3 · LimitedFinal reportLancair Lancair Super ES · Ely, MNThe non-instrument rated pilot’s improper decision to attempt flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control and subsequent impact with terrain.NTSB CEN20LA352Accident · 1 fatalClass 3 · LimitedFinal reportBeech 200 · Rockford, ILThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined based on the available evidence.NTSB WPR20LA280Accident · 1 fatalClass 3 · LimitedFinal reportArrow-Falcon Exporters UH-1H · Coalinga, CAThe pilot’s inability to maintain control of the helicopter due to a hydraulic system failure for reasons that could not be fully determined due to the thermal destruction from the postimpact fire.NTSB CEN20LA381Accident · No injuriesClass 3 · LimitedFinal reportPiper PA36 · Ord, NEThe pilot’s failure to maintain adequate airspeed while in a turn during initial climb and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at a low altitude.NTSB CEN20LA336Accident · 2 fatalClass 3 · LimitedFinal reportCirrus SR22 · Osage Beach, MOAn in-flight fire and subsequent loss of airplane control shortly after takeoff. The source of the in-flight fire or the reason for the loss of airplane control could not be determined based on the available information.NTSB WPR20LA270Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA 14 · Susanville, CAThe pilot’s decision to conduct a steep departure at a high-density altitude and the exceedance of the airplane’s critical angle of attack during a climb, which resulted in an accelerated stall and subsequent loss of control. Contributing to the accident was…NTSB CEN20LA338Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A185F · Sugar Land, TXA total loss of engine power after takeoff for undetermined reasons, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack during landing, which resulted in an aerodynamic stall.