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 ERA13WA376Accident · 4 fatalForeign investigationBeech 58 · Jundiai Municipality, BrazilOn August 3, 2013, at 1524 Universal Coordinated Time (UTC), a Beech model 58, Brazilian registration PT-LKG, operated by a private owner, was destroyed following a collision with terrain on approach to Jundiai Airport (SBJD), State of Sao Paulo, Brazil. The…NTSB ERA13FA348Accident · 3 fatalField investigationFinal reportBeech D55 · Conway, SCThe pilot's loss of airplane control, which resulted from his failure to follow the loss of single engine power checklist procedures after a total loss of right engine power due to fuel starvation. Contributing to the accident was the pilot's improper…NTSB ERA13CA350Accident · No injuriesData collectionFinal reportCessna 172S · Portsmouth, NHThe pilot’s inadequate preflight inspection resulting in his failure to remove the pin he used to lock the flight controls in place of the approved control lock.NTSB CEN13CA458Accident · Minor injuriesData collectionFinal reportCessna R182 · Lago Vista, TXThe pilot’s inadequate recovery from a bounced landing in crosswind conditions, and an inadvertent aerodynamic stall during the subsequent go-around attempt.NTSB CEN13WA578Accident · 2 fatalClass 5 · ForeignCirrus Design SR20 · Poncins, FranceOn July 31, 2013, about 1420 universal coordinated time, a Cirrus SR-20 airplane, F-HCPT, impacted terrain near Poncins, France. The two occupants were fatally injured. This investigation is under the jurisdiction of the government of France. Any further…NTSB ERA13LA346Accident · Serious injuriesLimited investigationFinal reportFpna A-22 Valor · Wurtsboro, NYThe pilot’s failure to comply with the manufacturer’s limitations and guidance regarding flaperons usage at low altitude and in adverse wind conditions, which resulted in an in-flight loss of airplane control.NTSB WPR13LA347Accident · 1 fatalLimited investigationFinal reportAirborne Windsports PTY Edge XT-912-L · Red Bluff, CAThe pilot's failure to properly secure himself in the cockpit with the seat belt, which resulted in his inability to control the airplane after takeoff.NTSB ERA13FA340Accident · 1 fatalField investigationFinal reportFolland Gnat T 1 · Georgetown, SCThe loss of airplane control for reasons that could not be determined due to postcrash fire damage. Contributing to the accident was the pilot’s decision to perform an aerobatic maneuver at low altitude, which did not allow sufficient time for him to regain…NTSB CEN13FA446Accident · 1 fatalField investigationFinal reportCampbell Earl S JR RV-6A · Knox, INThe incapacitation of the pilot due to a cardiovascular event that prevented him from maintaining control of the airplane during the landing approach.NTSB ERA13CA338Accident · No injuriesData collectionFinal reportCessna 210M · Shirley, NYThe pilot's loss of control during an aborted takeoff as a result of his failure to properly configure the elevator trim prior to flight.NTSB CEN13LA448Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Capron, ILThe pilot's failure to maintain main rotor speed while maneuvering at low altitude during an agricultural application flight, which resulted in an uncontrolled descent into terrain.NTSB CEN13LA439Accident · 1 fatalLimited investigationFinal reportWoods Rufus III Vans RV-8A · Lucas, KSThe noninstrument-rated pilot's inadvertent entry into instrument meteorological conditions, which resulted in his spatial disorientation and a subsequent loss of airplane control.NTSB CEN13LA436Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · Champaign, ILThe pilot’s failure to maintain control of the helicopter during an aerial application maneuver.NTSB WPR13LA334Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B2 · Las Vegas, NVThe pilot receiving instruction's failure to maintain control of the helicopter in a hover, which resulted in a tail rotor ground strike.NTSB WPR13FA335Accident · 1 fatalField investigationFinal reportMooney M20C · South Lake Tahoe, CAThe pilot’s decision to turn into rising terrain that would have required performance in excess of the airplane’s maximum climb rate to clear after taking off at a high density altitude.NTSB ERA13WA356Accident · 2 fatalForeign investigationBeech G36 · Bonito, BrazilOn July 19, 2013, about 1330 universal coordinated time (UTC), a Hawker Beechcraft G16, Brazilian registration PR-KEX, registered to a private owner and operated by a private individual, impacted terrain during flight in the vicinity of the Bonito…NTSB DCA13WA129Accident · No injuriesForeign investigationCirrus SR20 · Randburg, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cirrus SR20 airplane that occurred on July 18, 2013. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…NTSB CEN13FA420Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Oak Ridge, LAThe private pilot’s and the flight instructor’s failure to maintain airplane control while performing agricultural operations turns low to the ground, which resulted in a stall/spin. Contributing to the accident was the private pilot’s impairment due to his…NTSB CEN13LA422Accident · Serious injuriesLimited investigationFinal reportGrumman Aircraft Cor-Schweizer G-164A · Elmira, MIThe pilot's failure to maintain clearance from a line of trees while applying agricultural product to a field.NTSB CEN13CA419Accident · Minor injuriesData collectionFinal reportCessna 162 · Broomfield, COThe pilot’s improper recovery from a bounced landing, which resulted in a loss of control.NTSB ERA13WA332Accident · 2 fatalForeign investigationCessna 172N · Buenos Aires, ArgentinaOn July 16, 2013, about 2007 coordinated universal time, a Cessna 172N, Argentine registration LV-BPP, was substantially damaged when it impacted terrain while on approach to land at the Quilmes Airport (SADQ), Buenos Aires, Argentina. The flight instructor…NTSB CEN13LA418Accident · No injuriesLimited investigationFinal reportMarino Benoist Type XIV · Duluth, MNThe pilot's failure to maintain control of the seaplane during its initial flight test. Contributing to the accident was the pilot's overall lack of flight experience in the seaplane.NTSB CEN13FA415Accident · 1 fatalField investigationFinal reportBell UH-1H · Dove Creek, COPilot-induced oscillations caused by the loss of hydraulic assist of the flight controls due to an excessive loss of hydraulic fluid during a critical phase of flight, which resulted in ground impact. Contributing to the accident was an inadequate analysis of…NTSB CEN13CA430Accident · Minor injuriesData collectionFinal reportAlvarez Marvin R Rans S-6S · Schertz, TXThe noncertificated pilot's operation of the airplane, which resulted in impact with terrain.NTSB WPR13CA323Accident · Minor injuriesData collectionFinal reportCessna 152 · Kamiah, IDThe student pilot’s failure to maintain aircraft control during the initial climb, which resulted in a collision with a powerline.NTSB CEN13LA409Accident · 1 fatalLimited investigationFinal reportFlight Design Ctsw · Taos, NMThe airplane's unexpected encounter with a dust devil, which resulted in the loss of airplane control.NTSB WPR13LA315Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Alta, UTThe flight instructor's decision to follow a route over mountainous terrain in conditions that exceeded the helicopter’s ability to maintain terrain clearance.NTSB WPR13LA314Accident · Serious injuriesLimited investigationFinal reportLuy Wayman Lockwood Aircam · Groveland, CAThe pilot’s inadequate compensation for a crosswind and failure to maintain airplane control during a go-around.NTSB WPR13LA313Accident · 1 fatalLimited investigationFinal reportNorth Wing Uum Sport X2 · Parker Dam, CAThe student pilot’s abrupt maneuver to avoid transmission wires, which resulted in his loss of airplane control. Contributing to the accident were the pilot’s decision to perform a low-altitude flight, his distracted attention, and his failure to monitor the…NTSB WPR13CA361Accident · Minor injuriesData collectionFinal reportBuckeye Dream Machine · Fruitland, WAThe operation of a powered parachute by a non-certificated pilot, and the pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with a vehicle.NTSB ERA13CA307Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Okeechobee, FLThe student pilot’s failure to maintain directional control during a go-around.NTSB WPR13LA287Accident · Serious injuriesLimited investigationFinal reportBell 206B · Royal City, WAThe pilot's failure to maintain clearance from netting material during a low pass over trees, which resulted in a loss of helicopter control.NTSB WPR13FA284Accident · 2 fatalField investigationFinal reportBeech A45 · Boulder City, NVThe pilot/mechanic's loss of control during an emergency descent following a loss of engine power while in cruise flight. Contributing to the accident was the pilot/mechanic's incorrect assembly of the No. 6 cylinder at the last cylinder change, which…NTSB CEN13FA364Accident · 4 fatalField investigationFinal reportCessna 172M · Waterford, MIThe pilot's failure to retract the wing flaps before attempting to take off, due to his lack of familiarity with the airplane make and model, which prevented the airplane from maintaining adequate altitude for takeoff.NTSB CEN13FA357Accident · 1 fatalField investigationFinal reportBell 47G-3B-1 · Maplewood, MNThe loss of helicopter control for reasons that could not be determined because an examination of the helicopter and its systems revealed no malfunctions or failures that would have precluded normal operation.NTSB CEN13LA366Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124 · Cincinnati, OHLoss of control due to insufficient airspeed on takeoff and premature landing gear retraction, which resulted in the collapse of the left landing gear as the airplane impacted the runway.NTSB ERA13WA287Accident · 4 fatalForeign investigationPiper PA22 · Taisha, EcuadorOn June 13, 2013, at 2028 coordinated universal time (1528 local time), a Piper PA-22-135, Ecuadorian registration HC-CMX, was destroyed when it impacted terrain shortly after taking off from Taisha Airport (SETH), Taisha, Morona-Santiago, Ecuador, en route…NTSB WPR13FA269Accident · 2 fatalField investigationFinal reportGraves SH-2F · Montague, CAThe pilot’s failure to maintain airplane control while maneuvering for reasons that could not be determined during postaccident testing and examination, which resulted in a stall and subsequent spin.NTSB ERA13LA279Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Louisville, KYThe pilot's failure to set the correct flap position before takeoff and his inadequate preflight planning, which resulted in the operation of the airplane over the maximum allowable gross weight, both of which led to an aerodynamic stall at too low an…NTSB CEN13FA344Accident · 1 fatalField investigationFinal reportEurocopter AS350B2 · Talihina, OKThe helicopter pilot's failure to see and avoid the 40-ft-tall lamp post during takeoff. Contributing to the accident was the pilot's inadequate preflight evaluation of the obstructions in the takeoff path.NTSB ERA13FA275Accident · 1 fatalField investigationFinal reportCessna 340A · Boynton Beach, FLThe pilot’s loss of situational awareness, which resulted in an inadvertent aerodynamic stall/spin after he climbed the airplane back into instrument meteorological conditions (IMC). Contributing to the accident was the pilot’s improper decision to continue…NTSB ERA13CA284Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Ozark, ALThe student pilot’s failure to maintain control of the airplane during the aborted landing.NTSB CEN13FA331Accident · Minor injuriesField investigationFinal reportEurocopter AS 350 B3 · Grand Prairie, TXThe pilot receiving instruction's failure to maintain adequate airspeed during a simulated hydraulics failure training maneuver, which resulted in his loss of control of the helicopter and its subsequent impact with terrain, and the flight instructor's…NTSB ERA13FA273Accident · 3 fatalField investigationFinal reportBell Helicopter Textron 206L-1 · Manchester, KYThe pilot’s loss of helicopter control due to spatial disorientation when he inadvertently encountered night, instrument meteorological conditions, which resulted in the in-flight separation of the main rotor and tailboom.NTSB CEN13FA324Accident · 1 fatalField investigationFinal reportWeatherly 620B · Ludlow, SDThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall. Contributing to the accident was task- and/or work-related fatigue.NTSB CEN13CA345Accident · Minor injuriesData collectionFinal reportCessna 140 · Minot, NDThe pilot's failure to maintain aircraft control during takeoff.NTSB CEN13WA404Accident · Minor injuriesForeign investigationCirrus Design SR22 GTS G3 · Gloucestershire, United KingdomNTSB CEN13CA333Accident · No injuriesData collectionFinal reportCessna 172P · Pontiac, MIThe student pilot's failure to maintain aircraft control during the takeoff and his interference with the flight instructor's ability to provide remedial action.NTSB ERA13LA270Accident · 1 fatalLimited investigationFinal reportMaule BEE DEE M-4-210 · Cuttyhunk, MAThe pilot’s failure to maintain adequate airspeed after takeoff, which resulted in an aerodynamic stall and loss of airplane control.NTSB ANC13CA109Accident · No injuriesData collectionFinal reportPiper PA 16 · Glennallen, AKThe pilot's loss of control during the initial climb after takeoff, resulting in a collision with trees.