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 CEN19FA307Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Lakeview, SDThe student pilot’s failure to maintain control of the airplane, which resulted in the exceedance of the airplane’s critical angle-of-attack, an aerodynamic stall, and subsequent impact with terrain, and the student pilot’s non-compliance and lack of…NTSB ERA19FA265Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Lady Lake, FLThe pilot's loss of pitch control due to the in-flight opening of the canopy for reasons that could not be determined.NTSB GAA19WA593Accident · No injuriesForeign investigationPiper PA25 · Mazatan, Chiapas, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on September 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB GAA19WA565Accident · 1 fatalForeign investigationCessna 172 · Racine, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 172 that occurred on September 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of ICAO…NTSB WPR19LA249Accident · No injuriesClass 3 · LimitedFinal reportHughes 369 · Asotin, WAA loss of control for undetermined reasons.NTSB GAA19WA594Accident · 1 fatalForeign investigationAirbus A350 · Alta city, NorwayThe government of Norway has notified the NTSB of an accident involving a AIRBUS A350 helicopter that occurred on August 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…NTSB WPR19TA245Accident · No injuriesClass 3Final reportBell 47G · North Las Vegas, NVThe noncertificated passenger’s loss of control during attempted hover operations.NTSB GAA19WA540Accident · 3 fatalForeign investigationRobinson R44 · Buriti Alegre, BrazilThe government of Brazil has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on August 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB GAA19CA511Accident · No injuriesData collectionFinal reportPiper PA28 · Cottonwood, AZThe student pilot's improper pitch and lateral control during a soft-field takeoff, which resulted in impact with terrain. Contributing to the accident was the student pilot's failure to relinquish control of the airplane to the instructor.NTSB CEN19WA287Accident · 3 fatalForeign investigationPiper PA28RT · Simplon Pass, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a Piper PA28RT airplane that occurred on August 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB CEN19LA300Accident · No injuriesClass 3 · LimitedFinal reportCessna 425 · Bethany, OKA loss of control during the initial climb for undetermined reasons, which resulted in an aborted takeoff and runway excursion.NTSB CEN19WA285Accident · 1 fatalForeign investigationRotorway Exec 162F · Herisau, SwitzerlandOn August 24, 2019, about 1400 universal coordinated time, a Rotorway Exec 162F helicopter, Swiss registration HB-YKJ, was destroyed when it crashed in a meadow during an autorotation and caught fire, about 3 miles south of Herisau, Switzerland. The pilot was…NTSB GAA19WA532Accident · 4 fatalForeign investigationCessna 182 · Warintza, Morona Santiago, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a CESSNA 182 airplane that occurred on August 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…NTSB GAA19CA513Accident · Minor injuriesData collectionFinal reportCessna A185 · Rangeley Lake, METhe pilot's inadequate preflight inspection of the floats, which led to his subsequent attempt to depart from a lake with damaged floats and led to a loss of roll control and the right wing impacting the water.NTSB ERA19LA257Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Burnsville, NCThe pilot’s reliance on latent satellite weather imagery for tactical weather avoidance, which resulted in flight into thunderstorms and a loss of control. Also causal was an engine overspeed during the uncontrolled descent, which resulted in catastrophic…NTSB ERA19WA261Accident · 3 fatalForeign investigationAgusta A109 · Poros, GreeceThe government of the Hellenic Republic, Greece, has notified the NTSB of an accident involving an Agusta A-109C helicopter that occurred on August 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Greece's…NTSB GAA19CA499Accident · Minor injuriesData collectionFinal reportVans RV7 · Ocracoke, NCThe pilot's failure to maintain lateral control during an attempted aborted landing, which resulted in impact with trees.NTSB CEN19FA270Accident · 2 fatalClass 3 · FieldFinal reportPitts S2 · New Orleans, LAA loss of control for undetermined reasons.NTSB WPR19LA221Accident · Minor injuriesClass 3 · LimitedFinal reportAutoGyro Cavalon · Shelton, WAThe pilot’s failure to initiate the takeoff roll with inadequate rotor speed, and his failure to follow the published takeoff procedures, which resulted in a loss of control and impact with the ground.NTSB WPR19FA219Accident · 1 fatalClass 3 · FieldFinal reportCapes Murphy Moose · Marysville, WAThe pilot’s failure to maintain terrain clearance while turning to final approach to avoid a collision with another airplane flying a straight in approach to the same runway. Contributing to the accident was the pilots of both airplanes failure to adequately…NTSB CEN19LA267Accident · Minor injuriesClass 3 · LimitedFinal reportDe Havilland DHC6 · San Marcos, TXThe pilot's delayed go-around attempt and the flight instructor's delayed remedial action that resulted in a nose-down impact with terrain during an attempted go-around.NTSB WPR19FA216Accident · 2 fatalClass 3 · FieldFinal reportLancair Lancair IV · Kooskia, IDThe pilot’s failure to maintain airspeed while maneuvering in an area of precipitation and reduced visibility, which resulted in an aerodynamic stall and spin and loss of airplane control.NTSB ERA19WA270Accident · 3 fatalClass 5 · ForeignEmbraer EMB710 · Itaituba, BrazilNTSB ERA19FA243Accident · 2 fatalClass 2 · FieldFinal reportPoberezny Acro Sport II · Jersey Shore, PAThe pilot's decision to conduct low altitude aerobatic maneuvers which resulted in an exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude, which resulted in an aerodynamic stall.NTSB CEN19LA263Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · New Carlisle, OHThe pilot’s excessive use of pitch control during rotation, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff.NTSB ERA19FA240Accident · 3 fatalClass 3 · FieldFinal reportBeech F33 · Hatboro, PAThe pilot's loss of airplane control due to spatial disorientation during the departure climb after entering instrument meteorological conditions.NTSB GAA19CA490Accident · No injuriesData collectionFinal reportDiamond DA20 · Pueblo, COThe student pilot's failure to maintain the runway heading during an attempted aborted landing, which resulted in a runway excursion onto rough terrain.NTSB WPR19FA209Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Wolf Point, MTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an accelerated aerodynamic stall and subsequent loss of control.NTSB CEN19FA248Accident · 1 fatalClass 3 · FieldFinal reportCessna 310 · De Queen, ARA loss of control for reasons that could not be determined based on the available information.NTSB GAA19WA579Accident · No injuriesForeign investigationHughes 369 · Follebu, NorwayThe government of Norway has notified the NTSB of an accident involving a HUGHES 369 helicopter that occurred on August 01, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…NTSB CEN19WA268Accident · 1 fatalForeign investigationBeech V35 · Senneterre, Quebec, CanadaNTSB CEN19FA238Accident · 2 fatalClass 3 · FieldFinal reportPiper PA34 · Gainesville, TXThe pilots’ failure to maintain airspeed while on final approach with asymmetric engine power, which resulted in a loss of control.NTSB CEN19LA242Accident · Serious injuriesLimited investigationFinal reportIcon A5 · Lake, MIThe pilot's improper decision to operate the airplane in exceedance of the airplane manufacturer’s operating limitations, which led to an aerodynamic stall. Contributing to the accident was the pilot's improper decision to continue attempting the takeoff…NTSB GAA19WA460Accident · 1 fatalForeign investigationDe Havilland DH82 · Hythe, United KingdomNTSB CEN19FA235Accident · FatalClass 3 · FieldFinal reportCessna 175 · Kilgore, TXThe noncertificated pilot’s exceedance of the airplane’s critical angle of attack when the airplane became airborne during a high-speed taxi test, resulting in an aerodynamic stall and impact with terrain.NTSB GAA19WA444Accident · 1 fatalForeign investigationCirrus SR22 · Leutasch, Austria, AustriaThe government of Austria has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on July 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Austria's investigation under the provisions of…NTSB WPR19LA191Accident · 1 fatalClass 3 · LimitedFinal reportBolkow Phoebus · Alvord Desert, ORPilot’s failure to properly respond to a slack towline during takeoff, which resulted in a loss of control of the glider.NTSB GAA19CA424Accident · No injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot's failure to maintain lateral control during landing in gusting wind conditions, which resulted in the left wing striking the ground.NTSB GAA19WA441Accident · 7 fatalForeign investigationDe Havilland DHC2 · Mistastin Lake, NL, CanadaThe government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…NTSB GAA19WA420Accident · 9 fatalForeign investigationAIRvan GA8 · Umea, SwedenThe government of Sweden has notified the NTSB of an accident involving a AIRvan GA8 airplane that occurred on July 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions of…NTSB GAA19CA447Accident · No injuriesData collectionFinal reportBiuro Projektowe B Bogumil Ber SZD-56-2 · Sparks, NVThe pilot’s failure to abort the takeoff in a timely manner, which resulted in glider settling into sage brush.NTSB GAA19CA412Accident · No injuriesData collectionFinal reportCessna 172 · Elkton, FLThe pilot under instruction's failure to follow the flight instructor’s directions and the flight instructor's delayed remedial action and subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB WPR19LA194Accident · Serious injuriesClass 3 · LimitedFinal reportBell 47G 3B 1 · Mosby, MTThe pilot’s failure to account for environmental conditions conducive to a loss of tail rotor effectiveness, which resulted in a loss of tail rotor effectiveness and subsequent loss of control. Contributing to the accident was the pilot’s inappropriate…NTSB GAA19WA442Accident · 2 fatalForeign investigationSteen Skybolt · Enconada, BoliviaThe government of Bolivia has notified the NTSB of an accident involving an amateur-built STEEN Skybolt airplane that occurred on July 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under…NTSB GAA19CA409Accident · No injuriesData collectionFinal reportDiamond DA 40 · Denver, COThe pilot receiving instruction's failure to maintain the runway heading and bank control during landing in crosswind conditions, which resulted in a go-around and subsequent collision with a runway light.NTSB ERA19FA225Accident · 1 fatalClass 3 · FieldFinal reportQuicksilver Mxii · Oliver Springs, TNThe noncertificated pilot’s decision to continue to takeoff and climb after encountering an undetermined airplane control issue that he was unable to counteract, which resulted in collision with trees and subsequent impact with terrain.NTSB ERA19WA237Accident · 2 fatalForeign investigationPiper PA28 · Atibaia, BrazilThe government of Brazil has notified the NTSB of an accident involving a Piper PA-28-140 airplane that occurred on July 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB GAA19WA459Accident · 2 fatalForeign investigationDe Havilland DHC2 · Hawk Junction ON-Canada, CanadaThe government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…NTSB CEN19FA218Accident · 1 fatalField investigationFinal reportGIbb AR-1 · Hawley, MNAn in-flight loss of control and collision with terrain for reasons that could not be determined based on the available information.NTSB ANC19FA033Accident · 1 fatalClass 3 · FieldFinal reportPiper PA 24-180 · Ketchikan, AKThe pilot’s decision to continue visual flight rules into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.