NTSB investigations
3,842 cases where the defining event 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '240') 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 ERA19WA165Accident · 1 fatalForeign investigationRobinson R22 · Pegognaga, ItalyThe government of Italy has notified the NTSB of an accident involving a Robinson R22 Beta helicopter that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions…NTSB WPR19TA131Accident · No injuriesClass 3Final reportRobinson R22 · Lincoln Park, NJThe flight instructor's failure to maintain control of the helicopter while transitioning from a hover to forward flight, which resulted in a loss of control.NTSB WPR19TA142Accident · No injuriesClass 3Final reportZenair Zenith CH 701 · Marion, VAThe noncertificated pilot's failure to maintain control following a bounced landing and his decision to fly the airplane without proper training.NTSB GAA19CA232Accident · No injuriesData collectionFinal reportPavel Vagner TANGO2 · Cobden, ILThe pilot's failure to maintain the proper airspeed during the approach, which resulted in a hard landing.NTSB WPR19FA124Accident · 2 fatalClass 3 · FieldFinal reportVans RV 6 · Ridgefield, WAThe pilots' inadvertent exceedance of the airplane's critical angle of attack following an inflight collision with a bird.NTSB WPR19FA121Accident · 2 fatalClass 3 · FieldFinal reportTL Ultralight Sro Stingsport · Madera, CAThe pilot's exceedance of the airplane's critical angle of attack during the simulated engine failure on initial climb after takeoff, which resulted in an aerodynamic stall and subsequent loss of control at too low of an altitude to recover.NTSB WPR19FA118Accident · 1 fatalClass 2 · FieldFinal reportNorthrop N9M · Norco, CAThe pilot's loss of control for undetermined reasons.NTSB ERA19FA154Accident · 1 fatalClass 3 · FieldFinal reportWheeler Express Series 2000 · Cleveland, NCA loss of control and impact with terrain while maneuvering.NTSB CEN19FA124Accident · 6 fatalClass 2 · FieldFinal reportBeech 58 · Kerrville, TXThe pilot's inadequate preflight fuel planning and fuel management, which resulted in a loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to follow the one-engine inoperative checklist and maintain the airplane's minimum…NTSB CEN19FA122Accident · 2 fatalClass 3 · FieldFinal reportRans S7 · Kingsland, TXThe exceedance of the airplane's critical angle of attack during a steep climb after takeoff, which resulted in an aerodynamic stall and spin into terrain.NTSB WPR19FA115Accident · 1 fatalClass 3 · FieldFinal reportBeech 60 · Fullerton, CAThe pilot’s use of an unapproved elevator control lock device, and his failure to remove that device and correctly position the elevator before flight, which resulted in a loss of control during takeoff. Contributing to the accident was his failure to perform…NTSB WPR19FA116Accident · 2 fatalClass 3 · FieldFinal reportVans RV8 · Brookings, ORThe pilot’s failure to maintain aircraft control during an aggressive maneuver that resulted in a nose down collision with terrain.NTSB GAA19WA210Accident · 6 fatalForeign investigationBritten Norman BN2A · Marcel Marchant (SCPF), ChileThe government of Chile has notified the NTSB of an accident involving a BRITTEN NORMAN BN2A airplane that occurred on April 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the…NTSB WPR19WA225Incident · No injuriesForeign investigationPilatus PC12 · Merredin, AustraliaOn April 14, 2019, at 0020 local time, a Pilauts PC-12 airplane, VH-OWJ, experienced an uncontrolled pitch down while climbing through 2,600 ft mean sea level near Merredin, Western Australia. The pilot and three passengers were not injured. The airplane was…NTSB GAA19WA230Incident · No injuriesForeign investigationCessna CJ1 · Bournemouth, Dorset, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a CESSNA CJ1 airplane that occurred on April 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB CEN19FA120Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Lake, MSThe noninstrument-rated pilot’s loss of control while flying in dark night instrument meteorological weather conditions with convective activity, which resulted in the airplane exceeding its structural limitations and experiencing an in-flight breakup.…NTSB WPR19FA106Accident · 2 fatalClass 3 · FieldFinal reportTecnam P2002 · Santa Fe, NMThe flight instructor’s failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control.NTSB GAA19WA197Accident · 4 fatalForeign investigationCessna P210 · Solunska glava (LBSF), North MacedoniaThe government of Macedonia has notified the NTSB of an accident involving a CESSNA P210 airplane that occurred on April 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Macedonia's investigation under the…NTSB GAA19WA187Accident · 3 fatalForeign investigationEpig 1000LT · Egelsbach (Germany), GermanyThe government of Germany has notified the NTSB of an accident involving an amateur-built EPIG 1000LT airplane that occurred on March 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under…NTSB GAA19WA201Accident · 1 fatalForeign investigationMoravan Z-50LA · Castel Viscardo, ItalyThe government of Italy has notified the NTSB of an accident involving a MORAVAN Z-50LA airplane that occurred on March 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB GAA19WA188Accident · 1 fatalForeign investigationPiper J3C · Snowshoe Lake, Ontario, CanadaNTSB ERA19FA134Accident · 1 fatalClass 2 · FieldFinal reportHogan Innovator · Calhoun, GAThe pilot's failure to maintain aircraft control during the airplane's second test flight, which resulted in a collision with terrain. Contributing to the accident was the pilot allowing external pressures to guide his decision to fly the airplane when he…NTSB CEN19LA107Accident · Serious injuriesLimited investigationFinal reportCessna R172E · Loveland, COAn inflight loss of control on landing approach due to encountering a down-draft, and the pilot's failure to take timely action to abandon the approach and perform a go-around.NTSB GAA19WA179Accident · 2 fatalForeign investigationEnstrom 480 · Blazkov village, Czech Republic., CzechiaThe government of Czech Republic has notified the NTSB of an accident involving a ENSTROM 480 helicopter that occurred on March 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Czech Republic's investigation under…NTSB CEN19FA104Accident · 2 fatalClass 3 · FieldFinal reportIsrael Aircraft Industries 1124 · Yukon, OKThe airplane’s unairworthy thrust reverser (T/R) system due to inadequate maintenance that resulted in an asymmetric T/R deployment during an approach to the airport and the subsequent loss of airplane control.NTSB CEN19FA100Accident · 1 fatalClass 2 · FieldFinal reportCessna 421 · Plain City, OHA loss of airspeed indication due to icing of the airplane's pitot probe, and the pilot's loss of control while maneuvering.NTSB ANC19LA015Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Talkeetna, AKA loss of pitch control for an undetermined reason, which resulted in a collision with terrain during an emergency landing.NTSB ERA19FA130Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Cashiers, NCThe pilot's loss of airplane control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.NTSB ERA19FA124Accident · 1 fatalField investigationFinal reportPiper PA31 · Madeira, OHFuel starvation to the left engine and the resulting loss of engine power to that engine, and a loss of airplane control due to the pilot's failure to maintain the minimum controllable airspeed.NTSB GAA19WA222Accident · 2 fatalForeign investigationCessna U206 · Bolivar, VenezuelaThe government of Venezuela has notified the NTSB of an accident involving a CESSNA U206 airplane that occurred on March 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation under the…NTSB CEN19FA095Accident · 2 fatalClass 2 · FieldFinal reportBell 407 · Galliano, LAThe pilot's loss of control during cruise flight as a result of spatial disorientation while operating the helicopter in close proximity to terrain in marginal meteorological conditions.NTSB WPR19FA093Accident · 5 fatalClass 2 · FieldFinal reportPiper PA23 · Pahokee, FLThe pilot's failure to maintain control of the airplane while maneuvering for landing with one engine inoperative following a loss of engine power for reasons that could not be determined based on the available information.NTSB GAA19CA158Accident · No injuriesData collectionFinal reportPiper PA18 · Wyndmere, NDThe pilot's exceedance of the airplane's critical angle of attack during an uncoordinated turn while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB ANC19FA038Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Skwentna, AKThe pilot’s decision to depart into marginal visual flight rule conditions in mountainous terrain with the potential for icing, and the airplane’s accumulation of structural icing, which resulted in the pilot’s inability to maintain airplane control and the…NTSB CEN19WA105Accident · No injuriesForeign investigationPiper PA34 · Lagunilla, Costa RicaNTSB CEN19WA103Accident · 2 fatalForeign investigationRobinson R66 · Timmins, CYTS, CanadaThe government of Canada has notified the NTSB of an accident involving a Robinson R66 helicopter that occurred on March 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB GAA19CA162Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe student pilot's failure to maintain the runway heading during a go-around with a crosswind, which resulted in the left main landing gear impacting a runway sign.NTSB ERA19FA113Accident · 3 fatalField investigationFinal reportCessna 182 · Louisburg, NCThe pilot's spatial disorientation and loss of airplane control following takeoff in night instrument meteorological conditions.NTSB CEN19FA088Accident · 2 fatalField investigationFinal reportPiper PA46 · Shreveport, LAThe pilot's conduct of a departure into instrument meteorological conditions (IMC), which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot's poor instrument flying skills and his decision…NTSB CEN19LA087Accident · Serious injuriesClass 3 · LimitedFinal reportWarner Aerocraft Space Walker II · Devine, TXThe pilot’s failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB ERA19FA107Accident · 2 fatalField investigationFinal reportCessna 172 · Mansfield, MAThe flight instructor's failure to maintain airplane control during initial climb after a touch-and-go landing, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB DCA19MA086Accident · 3 fatalClass 1 · MajorFinal reportBoeing 767 · Trinity Bay, TXThe inappropriate response by the first officer as the pilot flying to an inadvertent activation of the go-around mode, which led to his spatial disorientation and nose-down control inputs that placed the airplane in a steep descent from which the crew did…NTSB GAA19CA144Accident · No injuriesData collectionFinal reportMooney M20J · Ridgeland, SCThe flight instructor's failure to retract the flaps during an attempted go-around and his failure to maintain the runway heading, which resulted in a collision with terrain left of the runway.NTSB ERA19TA105Accident · Minor injuriesFinal reportBeech 76 · Frankfort, KYThe pilot's failure to maintain airplane control during a simulated single-engine go-around, which resulted in a collision with terrain.NTSB GAA19CA142Accident · No injuriesData collectionFinal reportCirrus SR22 · Tulsa, OKThe pilot's failure to maintain a stabilized approach with a tailwind and his subsequent failure to maintain yaw control during an attempted go-around.NTSB GAA19CA141Accident · No injuriesData collectionFinal reportRobinson R22 · Clearwater, FLThe flight instructor's failure to maintain sufficient altitude over uneven terrain during a hover taxi, which resulted in ground contact and a subsequent dynamic rollover.NTSB GAA19CA139Accident · No injuriesData collectionFinal reportAirbus A350 · Eureka, AKThe pilot's selection of unsuitable terrain for landing on snow-covered mountainous terrain with steep rocks above, which resulted in loose rocks damaging the main rotor blades and the subsequent loss of helicopter controllability.NTSB CEN19FA082Accident · 2 fatalClass 2 · FieldFinal reportCessna 421 · Canadian, TXThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions with icing conditions present, which resulted in an aerodynamic stall and spin into terrain.NTSB ERA19WA099Accident · 3 fatalForeign investigationBell 206 · Barueri County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Bell 206 helicopter that occurred on February 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB WPR19LA100Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCAA · Watsonville, CAThe pilot’s loss of airplane control during a go-around for reasons that could not be determined based on available evidence.