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 ERA20LA217Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT502 · Atmore, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, spin, and loss of control.NTSB CEN20CA231Accident · Serious injuriesClass 4 · Data collectionFinal reportDestiny XLT · Frankfort, OHThe pilot's inadequate preflight inspection of the powered parachute, which resulted in his takeoff with twisted riser lines and impaired aircraft control.NTSB WPR20CA188Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 177RG · Lynden, WAThe pilot's failure to maintain control of the airplane during the landing approach, which resulted in the airplane exceeding its critical angle of attack, an aerodynamic stall, hard landing, and a landing gear collapse.NTSB CEN20CA229Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna T188 · McCurtain, OKThe pilot's failure to maintain the proper airspeed during a low altitude aerial application maneuver and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodymanic stall at too low of an altiutde to recover.NTSB ERA20LA212Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA32RT · Selma, ALThe mechanic’s failure to clean the oil suction screen during the most recent maintenance, which resulted in oil starvation and subsequent total loss of engine power.NTSB CEN20LA219Accident · 1 fatalClass 3 · LimitedFinal reportFlight Design Ctls · Beecher, ILThe pilot’s decision to continue takeoff after a partial loss of engine power, and the pilot’s subsequent failure to control airplane pitch during a forced landing. Contributing to the accident was the partial loss of engine power for reasons that could not…NTSB ERA20CA209Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA38 · Cumberland, MDThe pilot's failure to maintain directional control during landing and the subsequent go-around in gusting crosswind conditions.NTSB CEN20CA226Accident · No injuriesClass 4 · Data collectionFinal reportBellanca 17 30 · Talihina, OKThe pilot's failure to maintain control of the airplane during a crosswind landing, which resulted in a hard landing and runway excursion.NTSB CEN20CA217Accident · Minor injuriesClass 4 · Data collectionFinal reportAirborne XT912 · Bristol, WIThe pilot's incorrect flight control input during the landing flare, which resulted in an impact with the ground.NTSB CEN20LA214Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · New Washington, INA high velocity descent and impact with terrain for undetermined reasons.NTSB WPR20LA169Accident · 3 fatalClass 3 · LimitedFinal reportCessna 175 · Redlands, CAThe noncertificated pilot’s visual flight rules flight into instrument meteorological conditions and subsequent impact with terrain.NTSB ERA20LA207Accident · 2 fatalClass 3 · LimitedFinal reportQuad City Challenger · Wurtsboro, NYA loss of control after takeoff due to the pilot’s improper use of ballast weight. Contributing was the pilot’s decision to operate the airplane above its maximum gross weight.NTSB ERA20LA206Accident · 5 fatalClass 3 · LimitedFinal reportPiper PA 31T · Eatonton, GAThe pilot’s failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, which placed the airplane in an unusual attitude from which the pilot could not recover. Contributing to the accident was the convective and…NTSB CEN20CA213Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA18 · Cadillac, MIThe pilot’s failure to maintain control of the float-equipped airplane after the float became caught on the trailer used for takeoff.NTSB WPR20CA167Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Las Vegas, NVThe student pilot's failure to maintain directional control of the airplane during a soft-field takeoff and the flight instructor's delayed remedial action.NTSB WPR20CA166Accident · No injuriesClass 4 · Data collectionFinal reportAviat A 1 · Glendive, MTThe pilot's failure to maintain airplane control during landing in gusting wind condition which resulted in a collision with terrain.NTSB ERA20CA204Accident · Minor injuriesClass 4 · Data collectionFinal reportSonex Sonex · New Smyrna Beach, FLThe pilot failed to maintain an adequate airspeed while on final approach and impacted terrain.NTSB WPR20CA173Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Butte, MTThe pilot's failure to maintain airplane control during landing in turbulent conditions.NTSB ERA20LA202Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA23 · San Juan, PRThe pilot’s intentional operation of the airplane with known deficiencies of the left engine and subsequent in-flight loss of control after takeoff. Contributing to the loss of engine power was internal contamination of the left servo fuel injector.…NTSB ERA20CA205Accident · Serious injuriesClass 4 · Data collectionFinal reportMooney M20C · Durham, NCThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall..NTSB ANC20CA056Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Nikiski, AKThe pilot's failure to maintain directional control during landing in gusting wind conditions, which resulted in a ground loop.NTSB WPR20LA157Accident · 1 fatalClass 3 · LimitedFinal reportCub Crafters CCK-1865 · Valley Center, CAThe pilot's exceedance of the airplane's critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CEN20LA201Accident · 4 fatalClass 3 · LimitedFinal reportPiper PA28 · Carlinville, ILThe pilot’s attempted recovery from a steep descent which inadvertently exceeded the ultimate load factor of the airframe and resulted in a low-level inflight breakup.NTSB CEN20LA199Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA28 · Pineville, LAThe airplane’s inability to gain sufficient airspeed after takeoff due to it being at or over its maximum gross weight, which resulted in a loss of control. Contributing to the accident was the pilot’s decision to operate the airplane at or over its maximum…NTSB WPR20CA162Accident · No injuriesClass 4 · Data collectionFinal reportBell 206 · Elko, NVThe pilot's failure to maintain helicopter control in gusting wind that resulted in a loss in altitude and subsequent collision with a fence.NTSB CEN20WA438Accident · 1 fatalClass 5 · ForeignPitts S2 · Carcassonne, FranceNTSB WPR20LA155Accident · 1 fatalClass 3 · LimitedFinal reportCSP Leasing Cavalon · Roseburg, ORA substantially unweighted rotor system for reasons that could not be determined, which resulted in contact between the main rotor blade and the gyrocopter’s keel tube and a loss of control and impact with terrain.NTSB ANC20CA051Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA18 · Sterling, AKThe pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a runway excursion and collision with trees.NTSB WPR20CA153Accident · Minor injuriesClass 4 · Data collectionFinal reportAyres S 2R · Artois, CAThe pilot's failure to maintain clearance from power lines during a go-around.NTSB WPR20LA152Accident · 1 fatalClass 3 · LimitedFinal reportCirrus SR20 · Santa Maria, CAThe pilot’s exceedance of the airplane’s critical angle of attack during a steep and descending turn to final approach, which resulted in an aerodynamic stall and loss of control.NTSB CEN20LA186Accident · 2 fatalClass 3 · LimitedFinal reportCessna T206 · Center, TXThe non-instrument rated pilot’s intentional flight into instrument meteorological conditions (clouds) which resulted in spatial disorientation and an inflight loss of control.NTSB CEN20CA188Accident · No injuriesClass 4 · Data collectionFinal reportCessna R172 · Lino Lakes, MNThe pilot's loss of directional control during takeoff with a crosswind.NTSB CEN20CA182Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Chatham, ILThe pilot's decision to continue flight in instrument meteorological conditions in an airplane not equipped for instrument flight, which forced her to perform a precautionary landing to a muddy field resulting in the airplane nosing over.NTSB CEN20CA178Accident · No injuriesClass 4 · Data collectionFinal reportGeneral Atomics MQ-9B · San Angelo, TXThe pilot's failure to maintain an adequate landing flare that resulted in a porpoise and impact with terrain.NTSB ERA20CA184Accident · No injuriesClass 4 · Data collectionFinal reportBell OH-58C · Livingston, NYThe pilot's failure to maintain obstacle clearance while maneuvering at low altitude at night, which resulted in the helicopter striking a tree.NTSB WPR20LA141Accident · 1 fatalClass 3 · LimitedFinal reportBellanca 8GCBC · Byron, CAThe tow airplane pilot’s loss of control resulting from the glider pilot’s failure to maintain a proper altitude behind the tow airplane, which caused the tail of the tow airplane to be lifted upward and the tow airplane to pitch nose down while at a low…NTSB CEN20LA173Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Titan Tornado S · Haskell, OKThe student pilot/builder’s addition of winglets to the stabilator, which resulted in flutter and overstress failure of the stabilator control horn.NTSB CEN20CA177Accident · Minor injuriesClass 4 · Data collectionFinal reportM-Squared Sport 1000 · Little Falls, MNThe uncertificated pilot's failure to maintain aircraft control during takeoff, which resulted in an impact with terrain.NTSB CEN20LA169Accident · 1 fatalClass 3 · LimitedFinal reportRans S-12 · Delta, COThe pilot’s exceedance of the airplane’s critical angle of attack during a test flight which resulted in an aerodynamic stall and impact with terrain.NTSB CEN20LA168Accident · 1 fatalClass 3 · LimitedFinal reportYakovlev YAK 52 · Palmyra, ILA loss of control during a low-altitude aerobatic maneuver.NTSB CEN20LA167Accident · 1 fatalClass 3 · LimitedFinal reportMD Helicopter 369 · Houston, TXAn uncommanded right yaw that occurred for reasons that could not be determined based on the available evidence, which resulted in a loss control.NTSB CEN20LA160Accident · 1 fatalClass 3 · LimitedFinal reportAerostar 601 · Craig, COThe student pilot’s flight into terrain for undetermined reasons.NTSB ERA20WA174Accident · 2 fatalForeign investigationVans RV7 · Toledo, BrazilThe government of Brazil has notified the NTSB of an accident involving an amateur-built VANS RV7 airplane that occurred on April 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB ERA20CA158Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Athens, GAThe pilot's failure to maintain airplane control after an aborted landing, which resulted in collision with trees.NTSB WPR20CA127Accident · No injuriesData collectionFinal reportFLIGHTstar 2 · Oakdale, CAThe noncertificated pilot’s decision to take off through a large helicopter’s rotor wash, which resulted in his inability to gain altitude during takeoff.NTSB ERA20CA155Accident · Serious injuriesData collectionFinal reportGrumman AA5 · Bloomingdale, GAThe pilot's failure to maintain airplane control during landing with a gusting quartering tailwind.NTSB CEN20CA153Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Mamou, LAThe airplane's encounter with a sunken area during takeoff from a turf runway, which resulted in the airplane becoming prematurely airborne and impacting a tree and then terrain.NTSB ERA20WA154Accident · 1 fatalForeign investigationGarlick UH1H · del Curepto, ChileThe government of Chile has notified the NTSB of an accident involving a GARLICK UH1H helicopter that occurred on April 20, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…NTSB CEN20LA150Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Bowie, TXThe pilot's failure to maintain control of the airplane during takeoff in gusting wind conditions, which resulted in an uncontrolled turn and descent into terrain.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.