Fatal NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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.\"highestInjuryLevel\" = 'Fatal' 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."highestInjuryLevel" = 'Fatal' 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 CEN11WA119Accident · 2 fatalForeign investigationRaytheon 390 · Bever, SwitzerlandOn December 19, 2010, 1402 coordinated universal time, a German registered Raytheon 390 Premier I, D-IAYL, was destroyed upon impact with terrain while maneuvering near Bever, Switzerland. The two pilots were fatally injured. The airplane departed Zagreb…NTSB CEN11FA115Accident · 3 fatalField investigationFinal reportCessna 182C · Crowley, LAA loss of engine power due to the magneto failure for undetermined reasons.NTSB CEN11FA110Accident · 2 fatalField investigationFinal reportBeech B60 · Edwards, COControlled flight into terrain, while on an instrument approach in instrument meteorological conditions, for undetermined reasons.NTSB ERA11WA090Accident · 2 fatalForeign investigationHawker Beechcraft TC-45J · Nassau, BahamasOn December 14, 2010, about 1442 eastern standard time, a Hawker Beechcraft TC-45J, N38L, registered to and operated by Monarch Air Group, impacted ocean waters about 7 miles southwest of Lynden Pindling International Airport (MYNN), Nassau, Bahamas. The…NTSB ERA11FA085Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Pearlington, MSThe pilot’s controlled flight into terrain likely due to spatial disorientation, while flying over sparsely lighted terrain at night.NTSB ERA11WA089Accident · 4 fatalForeign investigationBeech 95-B55 · Bom Jesus do Galho City, BrazilOn December 9, 2010, about 2135 universal coordinated time, a Hawker Beech Aircraft 95-B55, Brazilian registration PT-LEU, experienced an engine failure, impacted the terrain, and was destroyed by a post crash fire in Bom Jesus do Galho City, Minas Gerais,…NTSB CEN11WA105Accident · 2 fatalForeign investigationRobinson R22 · Tourrettes-sur-Loup, FranceOn December 9, 2010, at 0755 coordinated universal time, a Robinson R22, United Kingdom registered G-CBVL, operated by Spiral Wing, Ltd., was destroyed when it impacted mountainous terrain under unknown circumstances near Tourrettes-sur-Loup, France. Visual…NTSB ERA11WA088Accident · 1 fatalForeign investigationPiper PA-32R-301T · Roma, ItalyOn December 8, 2010, at 1443 UTC, a Piper PA-32R-301T, N58SE, registered to Aircraft Guaranty Title Corporation Trustee,collided with a bus depot after departing runway 34 from Roma Urbe Airport (LIRU), Roma, Italy. The airplane had been recently purchased by…NTSB ERA11FA078Accident · 2 fatalField investigationFinal reportCessna U206G · Leverett, MAA total loss of engine power due to the fatigue failure of the crankshaft, which resulted from improper tightening of the cylinder hold-down nuts.NTSB CEN11LA093Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ponca City, OKThe pilot's loss of control during landing for undetermined reasons.NTSB WPR11LA069Accident · 1 fatalLimited investigationFinal reportSabre Trike · Peoria, AZAn in-flight loss of control for undetermined reasons.NTSB CEN11LA090Accident · 1 fatalLimited investigationFinal reportSoutherland Freebird Litesport U · Decatur, ILThe pilot's reported inability to control his amateur-built airplane for undetermined reasons after the airplane inadvertently became airborne while conducting a high-speed taxi.NTSB CEN11WA094Accident · 1 fatalForeign investigationCessna F150 · Linköping, SwedenOn December 1, 2010, at 1711 coordinate universal time, a Cessna F150H, SE-IGU, was substantially damaged upon impact with terrain after initial takeoff from the Linköping Airport (ESSL), Linköping, Sweden. The pilot was fatally injured. The airplane was…NTSB ERA11FA074Accident · 1 fatalField investigationFinal reportBeech A36 · Theodore, ALThe pilot's failure to maintain aircraft control while maneuvering at night in deteriorating weather conditions due to spatial disorientation. Contributing to the accident was the pilot's failure to obtain a weather briefing.NTSB CEN11LA086Accident · 1 fatalLimited investigationFinal reportMaule M-5-180C · Emory, TXThe pilot's loss of control and failure to attain/maintain adequate airspeed during an attempted go-around after a hard bounced landing, resulting in an aerodynamic stall. Contributing to the accident was the pilot’s recent minimal experience in airplane…NTSB WPR11LA064Accident · 1 fatalLimited investigationFinal reportKennedy Lancair 320 · Hubbard, ORThe loss of control during takeoff for undetermined reasons. Contributing to the accident was the pilot's impairment from an over-the-counter sedating medication.NTSB WPR11FA059Accident · 1 fatalField investigationFinal reportMooney M20R · Hollister, CAThe pilot did not ensure the airplane was loaded within its weight and balance envelope, which resulted in longitudinal instability and a loss of aircraft control during the initial climb.NTSB ERA11FA070Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Destin, FLControlled flight into water due to the pilot's improper descent below the published minimum descent altitude.NTSB CEN11LA082Accident · 1 fatalLimited investigationFinal reportCessna 172M · Velma, OKThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall and subsequent impact with terrain. Contributing to the accident was the pilot's relative inexperience in pipeline patrols.NTSB WPR11FA054Accident · 3 fatalField investigationFinal reportBeech 19A · Newport Beach, CAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN11FA079Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Norfolk, NEThe pilot’s decision to continue the flight into instrumental meteorological conditions which resulted in a collision with a tree.NTSB WPR11FA061Accident · 1 fatalField investigationFinal reportAmerican Champion 8GCBC · Bremerton, WAThe pilot did not maintain clearance from terrain for undetermined reasons. Contributing to the accident were the pilot’s use of oxycodone and his severe coronary artery disease.NTSB ERA11WA075Accident · 1 fatalForeign investigationPiper PA-25 · Tapurah City, BrazilOn November 18, 2010, about 1700 Universal Coordinated Time (UTC), a Piper PA-25-235, Brazilian registration PT-WOP, operated by Aeroagricola Boa Safra Ltda, lost control and crashed into trees during an agricultural flight at the Marape Farm, Tapurah City,…NTSB ERA11GA066Accident · 3 fatalFinal reportCessna M337B · Avon Park, FLThe pilot's inadvertent encounter with an unexpected intense rain shower with severe turbulence at night.NTSB CEN11WA088Accident · 3 fatalForeign investigationHawker Beechcraft F33A · Buttonville, CanadaOn November 18, 2010, at 1842 eastern standard time, a Hawker Beechcraft model F33A (Bonanza), s/n CE-1709, Canadian registration C-GSCZ, departed controlled flight and crashed 15 nautical miles east of Buttonville, Ontario, Canada. The airplane was…NTSB CEN11FA075Accident · 1 fatalField investigationFinal reportHawker-Beechcraft A36 · Oklahoma City, OKThe pilot’s loss of control of the airplane during night instrument meteorological conditions, likely due to spatial disorientation.NTSB WPR11FA050Accident · 2 fatalField investigationFinal reportDiamond Aircraft Ind DA20-C1 · Payson, UTThe pilots' failure to maintain adequate airspeed during a slow flight maneuver that resulted in a stall and spin, and the flight instructor’s delayed or improper remedial actions to recover from the spin. Contributing to the accident was the flight school’s…NTSB WPR11FA047Accident · 1 fatalField investigationFinal reportBeech C35 · Enterprise, ORThe noninstrumented pilot’s inadequate weather planning, which resulted in his failure to maintain visual flight while maneuvering under low ceilings in rainy and foggy conditions and his subsequent failure to maintain clearance from mountainous terrain.NTSB WPR11FA046Accident · 1 fatalField investigationFinal reportCessna 150J · Tucson, AZThe pilot's inability to maintain airplane control while on final approach due to undiagnosed cardiac disease, which caused a medical emergency and subsequent pilot incapacitation.NTSB CEN11LA067Accident · 1 fatalLimited investigationFinal reportBrantly B-2B · Post, TXThe pilot's decision to operate the helicopter over the maximum gross weight and forward of the recommended center of gravity.NTSB ERA11WA064Accident · 3 fatalForeign investigationBell 412EP · Trujillo, ColombiaOn November 13, 2010, about 2115 universal coordinated time, a Bell 412, Mexican registration XA-UNI, owned and operated by Aeroservicios Especializados S.A. de C.V. (ASESA), crashed in mountainous terrain near Trujillo, Colombia. Instrument meteorological…NTSB ERA11LA056Accident · 1 fatalLimited investigationFinal reportCarlo Robert Quicksilver SPT 2S · Lajas, PRThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall and entry into a spin.NTSB ERA11FA055Accident · 2 fatalField investigationFinal reportMooney M20F · Copake, NYThe pilot's failure to monitor and maintain clearance from mountainous terrain during a visual descent to the destination airport at night, which resulted in controlled flight into terrain.NTSB ERA11FA054Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · West Palm Beach, FLThe failure of both the pilot and the certified flight instructor to ensure that the left fuel selector was in the on position for takeoff and their failure to follow the proper procedures when the left engine lost power shortly after takeoff, resulting in an…NTSB CEN11LA066Accident · 1 fatalLimited investigationFinal reportGearn Geary D Swearingen SX300 · Milford, IAA loss of control for undetermined reasons.NTSB WPR11WA043Accident · 1 fatalForeign investigationRobinson R22 · Rolleston, Australia, AustraliaOn November 9, 2010, at 0330 universal coordinated time, a Robinson R22, VH-TCG, operated by a private individual, collided with terrain during a mustering operation near Rolleston, Australia. The helicopter was substantially damaged and the pilot was killed.…NTSB ERA11WA086Accident · 1 fatalForeign investigationEurocopter AS 350 B2 · Taltal, ChileOn November 6, 2010, at 2330 universal coordinated time, a Eurocopter, AS 350 B2 helicopter, Chilean registration CC-AAN, collided with terrain while in low level cruise flight near Taltal, Chile. The flight was operated by Servicios y Transporte Aereos…NTSB ERA11LA050Accident · 1 fatalLimited investigationFinal reportNorth American/Schwamm AT-6F · Fitchburg, MAA total loss of engine power due to a cracked carburetor float and resulting carburetor malfunction.NTSB ERA11LA048Accident · 2 fatalLimited investigationFinal reportBean R E/R B Weld Glasair III · Winchester, TNThe pilot's inadvertent climb and entry into instrument meteorological conditions during a course reversal, which resulted in spatial disorientation and a loss of control.NTSB DCA11WA008Accident · 21 fatalForeign investigationBeech 1900 · Karachi, PakistanOn November 5, 2010, a JS Air Pakistan, a Hawker Beechcraft B-1900, registration AP-BJD, crashed shortly after takeoff from Karachi-Jinnah International Airport (KHI), Karachi, Pakistan. All 17 passengers and 4 crewmembers onboard were fatally injured, and…NTSB CEN11WA058Accident · 2 fatalForeign investigationBeech C90 · St Anonin sur Bayon, FranceOn November 4, 2011, approximately 1520 coordination universal time, a French registered Beech C90A, F-BTVB, was substantially damaged upon impact with terrain following a loss of control near St Antonin sur Bayon, France. The two pilots were both fatally…NTSB CEN11WA080Accident · 2 fatalForeign investigationPiper PA46 · Sekowice, PolandOn November 3, 2010, at 1009 coordinated universal time, a German registered Piper PA-46-350P, D-ETXA, was destroyed upon impact with terrain following a loss of control near Sekowice, Poland. The pilot and one additional occupant were both fatally injured.…NTSB CEN11FA053Accident · 1 fatalField investigationFinal reportBell 206 · Meeker, COThe pilot's failure to maintain clearance from electrical power lines during the low-altitude flight.NTSB CEN11LA050Accident · 1 fatalLimited investigationFinal reportMcfarland Bill Challenger II · Praire Du Sac, WIThe separation of the fuselage-mounted wing strut attachment fitting for an undetermined reason, which resulted in the separation of the left wing of the airplane.NTSB CEN11LA049Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Schaumburg, ILThe pilot did not maintain airspeed following a loss of engine power during takeoff climb, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power due to the unlocked engine primer.NTSB ERA11FA042Accident · 1 fatalField investigationFinal reportMD Helicopters 369E · Thomas, WVThe pilot's failure to clear the helicopter and its external load from surrounding structures and his failure to execute a timely release of the external load, which resulted in an inadvertent entanglement and collision with wires and terrain. Contributing to…NTSB ERA11FA038Accident · 1 fatalField investigationFinal reportCessna 210A · Aiken, SCThe pilot's inadequate weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot’s…NTSB CEN11LA041Accident · 1 fatalLimited investigationFinal reportDonegan Benton Kitfox II · Seguin, TXThe pilot’s failure to ensure adequate fuel on board and subsequent failure to maintain airplane control following an engine failure due to fuel exhaustion.NTSB ERA11FA036Accident · 2 fatalField investigationFinal reportBeech B36TC · Rienzi, MSThe pilot's continued flight into known adverse weather conditions. Contributing to the accident was the air traffic controller's failure to provide precipitation information to the pilot as required.NTSB WPR11FA032Accident · 4 fatalField investigationFinal reportMooney M20J · Lander, WYThe pilot's decision to depart into known adverse weather conditions over mountainous terrain, which required operation near the limits of the airplane's performance capability and which resulted in a loss of airplane control and subsequent ground impact.…