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 CEN14WA206Accident · 7 fatalForeign investigationSui RY, Laurinen Janne, KääRiä Comp AIR 8 · Jamijarvi, FinlandOn April 20, 2014, at 1240 UTC, a Comp Air 8, Finnish registration OH-XDZ, was destroyed when it departed controlled flight and subsequently impacted in a forest near Jamijarvi Airfield (EFJM), Jamijarvi, Finland. A post-impact fire ensued. Eight of the 10…NTSB CEN14CA203Accident · Minor injuriesData collectionFinal reportPiper PA-28 · Kalamazoo, MIAn inadvertent stall during gusting crosswind conditions.NTSB CEN14LA205Accident · 1 fatalLimited investigationFinal reportQuicksilver GT400 · Hillsboro, KSThe pilot’s failure to maintain control of the unregistered airplane in gusting wind conditions.NTSB WPR14FA167Accident · 1 fatalField investigationFinal reportSands Helicycle · Reno, NVThe pilot’s failure to maintain control of the helicopter while in the traffic pattern.NTSB WPR14CA166Accident · Serious injuriesData collectionFinal reportPiper PA 18-135 · Kent, ORThe pilot's failure to maintain aircraft control during takeoff.NTSB ERA14FA192Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Hugheston, WVThe pilot's loss of airplane control while operating in instrument flight rules conditions.NTSB WPR14WA164Accident · 2 fatalForeign investigationQuest Kodiak · Jayapura, Papua, Indonesia, IndonesiaOn April 9, 2014, at 0025 universal coordinated time, a Quest Aircraft Company, Kodiak-100, PK-SDF, during takeoff from Doyo Baru Airstrip, Jayapura, Papua, Indonesia, the airplane lost altitude and struck the airport fence and subsequently came to rest on a…NTSB CEN14LA192Accident · 1 fatalLimited investigationFinal reportAerotrike Safari · Littlefield, TXThe non-certificated pilot's in-flight loss of control for reasons that could not be determined from the available evidence.NTSB CEN14FA193Accident · Minor injuriesField investigationFinal reportAirbus AS350 B3E · Albuquerque, NMThe pilot's loss of yaw control during takeoff due to the absence of hydraulic boost to the tail rotor pedals for reasons that could not be determined based on the available information. A finding in the accident was the lack of a caution indicator to alert…NTSB WPR14LA161Accident · 1 fatalLimited investigationFinal reportNorthwing Apache Sport · Brigham City, UTThe pilot’s failure to maintain aircraft control while maneuvering near power lines.NTSB WPR14CA162Accident · No injuriesData collectionFinal reportCessna 207 · Shaw Island, WAThe pilot's loss of directional control during the landing flare with a gusting tailwind.NTSB ERA14CA185Accident · No injuriesData collectionFinal reportCessna 205A · Leesburg, VAThe pilot's inadequate compensation for the wind conditions during landing, resulting in a runway excursion and impact with terrain. Contributing to the accident was the pilot's inadequate evaluation of the wind conditions.NTSB ANC14FA022Accident · 2 fatalField investigationFinal reportCessna 208B · Kwethluk, AKThe check airman's delayed remedial action and initiation of a recovery procedure after a simulated pitch trim excursion, which resulted in a loss of airplane control.NTSB ERA14FA182Accident · 2 fatalField investigationFinal reportMonroe Dennis RV-7 · Summerfield, FLThe pilot's failure to maintain airplane control while maneuvering at a low airspeed, which resulted in an aerodynamic stall, and his decision to maneuver at an altitude that did not allow an adequate margin to recover from a stall.NTSB CEN14FA185Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Albany, OHThe pilot’s loss of airplane control during the approach to landing.NTSB CEN14CA189Accident · Minor injuriesData collectionFinal reportBelisle Thomas J RV7A · New Iberia, LAThe pilot's loss of control due to a temporary incapacitation.NTSB CEN14CA187Accident · No injuriesData collectionFinal reportCessna 172 · Larimore, NDFailure of the pilot to attain and maintain sufficient control inputs to compensate for the crosswind. Contributing to the accident was the flight instructor's failure to adequately monitor the pilot and the flight.NTSB ERA14LA180Accident · Serious injuriesLimited investigationFinal reportHelpling Helen C Tango 2 · Ocala, FLThe pilot's failure to maintain airplane control after the left cockpit canopy opened during takeoff for reasons that could not be determined due to fire damage.NTSB ERA14WA186Accident · 1 fatalForeign investigationBoeing B75 · Lujan, ArgentinaOn March 29, 2014, about 1900 coordinated universal time, a Boeing B75 Stearman, Argentine registration LV-HAF, was substantially damaged when it impacted the ground during the initial climb after takeoff from the Lujan Airport, Lujan, Argentina. The pilot…NTSB CEN14CA181Accident · No injuriesData collectionFinal reportMaule MX 7-180B · Dora, ARThe pilot's bounced landing and delayed decision to go around, which resulted in collision with a fence during the go around.NTSB ERA14LA174Accident · 1 fatalLimited investigationFinal reportN/A N/A · Patillas, PRThe pilot’s failure to maintain airplane control during approach for landing, which resulted in a stall/spin.NTSB ERA14FA168Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Brunswick, GAAn inflight failure of the airplane's only operating vacuum pump, which resulted in the loss of attitude information provided by vacuum-driven flight instruments. Also causal was the pilots' failure to maintain control of the airplane while operating in…NTSB ERA14WA196Accident · 2 fatalForeign investigationRobinson R22 - Beta · Ribeirão Preto, BrazilOn March 23, 2014, about 1355 universal coordinated time, a Robinson R22 Beta, Brazilian registration PP-SSP, was substantially damaged when it impacted the ground on a corn plantation in Ribeirao Preto, Brazil. The pilot and a passenger were fatally injured.…NTSB ERA14CA165Accident · Serious injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Kill Devil Hills, NCThe pilot's failure to maintain control of the airplane during the landing approach in gusty wind conditions.NTSB WPR14WA154Accident · 5 fatalForeign investigationCessna U206 - G · Caboolture, AustraliaOn March 22, 2014 about 1123 local time, a Cessna 206 airplane, Australian registration VH-FRT, crashed shortly after takeoff near Caboolture, Australia. The airplane was substantially damaged and the pilot and four passengers were fatally injured. The…NTSB CEN14FA167Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Ridgway, COThe pilot's loss of airplane control during an instrument approach procedure, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall and spin.NTSB CEN14CA170Accident · No injuriesData collectionFinal reportDonald G Stokes Challenger II · Crockett, TXThe pilot's failure to maintain control of the airplane, resulting in a hard landing.NTSB CEN14FA163Accident · 1 fatalField investigationFinal reportSmith Aerostar 601P · Aurora, COThe pilot's operation of the airplane while intoxicated, which resulted in a loss of airplane control.NTSB CEN14CA440Accident · Serious injuriesData collectionFinal reportMooney M20J · Lamar, COThe pilot allowed the airplane to liftoff without sufficient airspeed which resulted in a stall and subsequent impact with the terrain.NTSB WPR14FA137Accident · 2 fatalField investigationFinal reportEurocopter AS 350 B2 · Seattle, WAThe loss of helicopter control due to a loss of hydraulic boost to the tail rotor pedal controls at takeoff, followed by a loss of hydraulic boost to the main rotor controls after takeoff. The reason for the loss of hydraulic boost to the main and tail rotor…NTSB WPR14FA132Accident · 1 fatalField investigationFinal reportCessna 120 · Carson City, NVThe pilot’s delayed decision to initiate a course-reversal turn when the airplane was unable to attain sufficient altitude to cross a mountain range, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall…NTSB ERA14LA152Accident · Serious injuriesLimited investigationFinal reportKurtz Jay B RV-9A · Live Oak, FLThe pilot’s improper recovery from a bounced landing, which resulted in an aerodynamic stall, a subsequent nose-down landing, and excessive bending loads to the nose landing gear.NTSB ERA14LA146Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Mulberry, FLThe failure of the pilot and the parachutist to see and avoid each other, which resulted in the airplane’s wing colliding with the parachute’s suspension lines.NTSB ERA14FA144Accident · 3 fatalField investigationFinal reportRogers George T Lancair IVP · Hartsville, SCFailure of the flying pilot to maintain control of the airplane while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident were the…NTSB ERA14CA151Accident · No injuriesData collectionFinal reportCessna 172M · Pittstown, NJThe pilot's failure to maintain directional control while landing.NTSB WPR14FA127Accident · 1 fatalField investigationFinal reportPiper PA 46 350P · Truckee, CAThe pilot’s failure to properly execute the missed approach in instrument conditions. Contributing to the accident were the pilot’s lack of instrument proficiency, as demonstrated by his failure to execute the required procedure turn to align with the final…NTSB WPR14CA122Accident · No injuriesData collectionFinal reportCessna 172M · Ramona, CAThe student pilot's inadequate flare and failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB CEN14LA149Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Presidio, TXThe pilot’s failure to maintain sufficient rotor rpm when transitioning the helicopter from a hover to forward flight, which resulted in a loss of helicopter control.NTSB CEN14LA148Accident · 1 fatalLimited investigationFinal reportVans RV-9A · Tribune, KSThe pilot’s failure to maintain airplane control while conducting high-g turns, which resulted in impact with terrain. Contributing to the accident was the pilot’s improper decision to initiate the flight with a severe progressive neurological disorder that…NTSB ERA14FA128Accident · 3 fatalField investigationFinal reportBeech 95-B55 · LaGrange, GAThe pilot's overreaction to a perceived conflict with a tow plane and glider on an intersecting runway, which resulted in a loss of control during an attempted aborted landing. Contributing to the accident was the failure of the glider tow operator to follow…NTSB ERA14LA137Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Macon, GAThe pilot’s failure to maintain airplane control while maneuvering in the traffic pattern at low altitude in gusting wind. Contributing to the accident was the pilot’s improper decision to maneuver in the traffic pattern at a low altitude that did not allow…NTSB CEN14FA145Accident · 1 fatalField investigationFinal reportBeech B100 · Pearland, TXThe noninstrument-rated pilot's loss of airplane control during a missed instrument approach. Contributing to the accident was the pilot's decision to file an instrument flight rules flight plan and to fly into known instrument meteorological conditions.NTSB ERA14WA132Accident · 2 fatalForeign investigationRobinson R22 - Beta · Rio de Janeiro, BrazilOn February 18, 2014, about 1315 universal coordinated time, a Robinson R22 - BETA, Brazilian registration PT-YFV, was destroyed when it impacted water, near Rio de Janeiro, Brazil. The flight instructor and student pilot were fatally injured. The local…NTSB ERA14FA123Accident · 1 fatalField investigationFinal reportWilliams Christopher T Sonex · Wellington, FLThe pilot's failure to maintain adequate airspeed following a partial loss of engine power during initial climb, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the…NTSB ERA14WA131Accident · 2 fatalForeign investigationRobinson R44 · Braganca, BrazilOn February 15, 2014, about 2200 coordinated universal time (UTC), a Robinson, R 44 helicopter, Brazilian registration PT-YMF, was destroyed when it impacted the ground in a dense forest in the Bragança Municipality, in the State of Pará, Brazil. The…NTSB ERA14FA120Accident · 2 fatalField investigationFinal reportCessna 210L · Clay, ALThe pilot's failure to maintain control of the airplane while being vectored to intercept the localizer during night instrument meteorological conditions (IMC). Contributing to the accident was the operator's inadequate dispatch procedures, which did not…NTSB ERA14LA117Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Stuart, FLThe noninstrument-rated pilot’s continued flight into dark night, instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation and subsequent impact with water.NTSB ERA14FA112Accident · 4 fatalField investigationFinal reportGulfstream AM Corp Comm Div 690 · Bellevue, TNThe pilot's failure to maintain airspeed with one engine inoperative, which resulted in a loss of control while on approach. Contributing to the accident were airframe ice accumulation due to conditions conducive to icing and the loss of engine power on one…NTSB DCA14WA179Accident · 3 fatalForeign investigationBeech C90 · Lanseria, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Beech C90-GTI airplane that occurred on February 03, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA investigation under the…NTSB WPR14CA110Accident · Minor injuriesData collectionFinal reportBeech V35A · Globe, AZThe pilot's inadequate glide path and failure to maintain adequate airspeed during final approach, which resulted in an aerodynamic stall.