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 ERA11LA234Accident · 1 fatalLimited investigationFinal reportLet L 33 Solo · New Castle, VAPilot incapacitation shortly after takeoff for unknown reasons.NTSB ERA11FA233Accident · 1 fatalField investigationFinal reportCessna 402B · Biddeford, METhe pilot did not maintain minimum controllable airspeed while on final approach with a partial loss of power in the right engine, which resulted in a loss of control. Contributing to the accident was the partial loss of engine power in the right engine due…NTSB ERA11FA232Accident · 3 fatalField investigationFinal reportCessna 310R · McComb, MSThe pilot's impairment due to alcohol ingestion and his failure to maintain airplane control during an approach at night in instrument meteorological conditions.NTSB ERA11WA245Accident · 2 fatalForeign investigationBell 206B · Santo Andre City, BrazilOn April 8, 2011, at 2030 coordinated universal time (1730 local time), a Bell 206B, Brazilian registration PT-YMJ, was destroyed when it impacted terrain at the 5,000-foot level of the Serra do Mar mountain range in Santo André, São Paulo, Brazil. The pilot…NTSB WPR11FA188Accident · 1 fatalField investigationFinal reportAviat A-1C-180 · Laramie, WYThe pilot’s failure to maintain airplane control and to recover from an aerodynamic stall, which resulted in a spin.NTSB ERA11WA251Accident · 3 fatalForeign investigationEurocopter AS-355-F2 · Alto Alegre, BrazilOn April 6, 2011, about 2225 coordinated universal time, a Eurocopter AS-355-F2, Brazilian registration PT-HNA, was destroyed when it impacted terrain near Alto Alegre, Brazil. The pilot and one passenger incurred minor injuries, and three passengers were…NTSB CEN11FA267Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · South Bend, INThe pilot’s failure to maintain airplane control while on final approach with a gusting crosswind and the subsequent aerodynamic stall and spin during the attempted go-around.NTSB WPR11LA183Accident · 1 fatalLimited investigationFinal reportTomei S12 XL · Pleasant Grove, CAThe pilot’s failure to allow the airplane’s engine to properly warm up before applying takeoff power, which resulted in the forward cylinder's piston seizing and a subsequent loss of engine power. Also causal was the pilot's failure to maintain an adequate…NTSB WPR11FA184Accident · 1 fatalField investigationFinal reportNorth American Navion A · Alameda, CAThe pilot’s failure to maintain airspeed while maneuvering for an emergency landing, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power for undetermined reasons during initial climb.NTSB WPR11FA182Accident · 1 fatalField investigationFinal reportPiper PA-28RT · Cherry Valley, CAThe pilot’s continued flight in an area of low ceiling and visibility, which resulted in a collision with mountainous/hilly terrain.NTSB ERA11FA222Accident · 2 fatalField investigationFinal reportReplogle Lancair 360 · Chesapeake, VAThe pilot did not maintain airspeed following a loss of engine power, which resulted in an aerodynamic stall and spin. Contributing to the accident was the pilot's selection of the wrong fuel tank at takeoff, which resulted in fuel starvation and the total…NTSB ENG11WA024Accident · 1 fatalForeign investigationCASA C212 · Saskatoon, Saskatchewan, Canada, CanadaOn April 1, 2011, in Saskatoon, Saskatchewan, Canada, a crew of a CASA C-212 Aviocar 200, registration number C-FDKM, powered by two Honeywell TPE311 engines, reported problems with the right hand engine, and performed an air turn-back. Approximately 12…NTSB DCA11MA076Accident · 4 fatalClass 1 · MajorFinal reportGulfstream GVI · Roswell, NMThe National Transportation Safety Board determines the probable cause(s) of this accident as follows: an aerodynamic stall and subsequent uncommanded roll during a one engine-inoperative takeoff flight test, which were the result of (1) Gulfstream’s failure…NTSB CEN11FA259Accident · 1 fatalField investigationFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Boulder, COThe pilot's incapacitation for undetermined reasons, which resulted in a loss of control.NTSB ANC11WA026Accident · 1 fatalForeign investigationDe Havilland · Mayo, CanadaOn March 31, 2011, approximately 1745 pacific daylight time, a Canadian registered De Havilland DHC-3T airplane, Canadian registration C-GMCW sustained substantial damage when it broke-up in-flight, about 39 nautical miles northeast of Mayo, Yukon Territory,…NTSB WPR11WA176Accident · 4 fatalForeign investigationPiper PA-32R · Moree, AustraliaThe accident is under the jurisdiction of and is being investigated by the Australian Transport Safety Bureau.NTSB ERA11FA219Accident · 2 fatalField investigationFinal reportBeech 58 · Greensboro, NCThe pilot’s spatial disorientation due to a somatogravic illusion while conducting a missed approach in instrument meteorological conditions, which resulted in the airplane’s descent into objects and terrain.NTSB ERA11FA218Accident · 2 fatalField investigationFinal reportCessna 310R · Pikeville, KYThe pilot's flight below the published minimum descent altitude in instrument meteorological conditions, which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's use of nighttime cold medication at doses above…NTSB CEN11FA263Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Fredricktown, MOThe pilot's decision to attempt to maintain visual flight by descending below an area of deteriorating forecast weather to an altitude that did not provide adequate terrain clearance.NTSB CEN11FA253Accident · 3 fatalField investigationFinal reportPiper PA46-350P · Monroe, MIThe pilot's demonstration of poor judgment by attempting a high-speed pass several feet above the runway and his subsequent failure to maintain clearance from the runway.NTSB CEN11FA247Accident · 3 fatalField investigationFinal reportStinson 108 · Dickens, TXThe non-instrument rated pilot's decision to fly in night instrument meteorological conditions.NTSB ERA11FA214Accident · 1 fatalField investigationFinal reportAerostar S A YAK-52 · Palm Coast, FLThe pilot’s failure to recover from the nose-low descent during an aerobatic maneuver.NTSB ERA11FA210Accident · 1 fatalField investigationFinal reportPiper PA-20 · Elgin, SCA total loss of engine power due to fuel exhaustion resulting from the pilot’s inadequate preflight planning. Contributing to the accident was that the pilot did not maintain an adequate airspeed, which resulted in an aerodynamic stall.NTSB ERA11WA215Accident · 1 fatalForeign investigationBell 205 · San Clemente, ChileNTSB ERA11GA207Accident · 1 fatalFinal reportCessna A185F · Ashland, MEAn inadvertent encounter with localized instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB CEN11FA244Accident · 2 fatalField investigationFinal reportCessna 182M · Hot Springs, ARA total loss of engine power for undetermined reasons.NTSB WPR11FA173Accident · 3 fatalField investigationFinal reportCessna P210 · Daggett, CAThe pilot's decision to conduct the flight into a region of reported moderate to severe turbulence and icing conditions, followed by a loss of airplane control and an aerodynamic spin from which the pilot did not recover.NTSB CEN11LA239Accident · 1 fatalLimited investigationFinal reportGlasflugel Standard Libelle · Wellington, COThe pilot's loss of glider control due to impairment or incapacitation caused by an episode of ventricular tachycardia.NTSB CEN11FA240Accident · 2 fatalField investigationFinal reportCessna 150D · Baraboo, WIThe student pilot’s inadequate preflight planning and his decision to continue the flight into instrument meteorological conditions, which resulted in a subsequent loss of airplane control.NTSB WPR11FA170Accident · 1 fatalField investigationFinal reportCessna T310R · Butte, MTThe pilot's loss of airplane control during the missed approach for undetermined reasons. Contributing to the accident was the rapid and unforecast deterioration of the weather conditions to below the landing minimum and the pilot's decision to attempt the…NTSB ERA11LA208Accident · 1 fatalLimited investigationFinal reportJennings John C Mini Max · Clinton, SCThe pilot's inadequate performance planning, which resulted in a collision with a tree during takeoff.NTSB WPR11FA166Accident · 5 fatalField investigationFinal reportBeech 200 · Long Beach, CAThe pilot's failure to maintain directional control of the airplane during a momentary interruption of power from the left engine during the initial takeoff climb. Contributing to the accident was the power interruption due to water contamination of the fuel,…NTSB ERA11WA189Accident · 1 fatalForeign investigationCessna 182 · Calamar, ColombiaOn March 14, 2011, about 0815 universal coordinated time, a Cessna, 182N, Colombian registration, HK1084, operated by Transportes Aereos del Ariari, crashed while returning to Aerodromo Jorge E. Gonzalez- San Jose Guaviare (SKSJ), Calamar, Colombia, shortly…NTSB WPR11FA490Accident · 1 fatalField investigationFinal reportRadford RV-6 · Grand Canyon, AZThe pilot's intentional flight into terrain.NTSB ERA11FA185Accident · 1 fatalField investigationFinal reportCessna 310R · Smyrna, TNThe pilot's improper response to a known autopilot pitch divergence anomaly. Contributing to the accident was the pilot's decision to perform a test flight on a system for which he lacked a complete working knowledge.NTSB WPR11FA156Accident · 2 fatalField investigationFinal reportDouglas AD-4N · Twin Falls, IDThe non-instrument-rated pilot’s encounter with localized instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB ERA11FA183Accident · 2 fatalField investigationFinal reportDehavilland DHC-6-100 · Hampton, GAThe pilot did not maintain airspeed while maneuvering, which resulted in an aerodynamic stall.NTSB WPR11FA155Accident · 1 fatalField investigationFinal reportMuse KR2 · Newberry Springs, CAThe airplane’s encounter with severe turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB ERA11FA182Accident · 1 fatalField investigationFinal reportDiamond DA-40 · Allagash, METhe pilot's inadvertent encounter with icing conditions, which resulted in an aerodynamic stall and loss of control. Contributing was the pilots’ inadequate preflight weather planning.NTSB WPR11FA147Accident · 1 fatalField investigationFinal reportNeefjes Lancair 360 MK-II · Milford, UTThe pilot's loss of control of the airplane due to spatial disorientation after inadvertently entering instrument meteorological conditions. Contributing to the accident were the pilot's inadequate preflight preparation, his en route decision-making, and his…NTSB DCA11WA032Accident · 4 fatalForeign investigationGrumman G21 · Al Ain, United Arab EmiratesNTSB WPR11FA145Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Phoenix, AZThe pilot and flight instructor's failure to adequately monitor the flight task and environment while maneuvering to maintain sufficient altitude with rising terrain in dark night conditions and the flight instructor's improper decision to practice in an area…NTSB ERA11FA165Accident · 1 fatalField investigationFinal reportBritish BAC 167 Strikemaster · Kingston, NYThe pilot’s failure to maintain airplane control while maneuvering. Contributing to the accident was the pilot's lack of experience in the accident airplane.NTSB CEN11WA214Accident · 2 fatalForeign investigationCessna P210 · Armentières sur Avre, FranceUnder the jurisdiction and control of the French government.NTSB CEN11FA201Accident · 1 fatalField investigationFinal reportCessna 421C · Connersville, INThe pilot did not maintain control of the airplane while making a low-altitude turn during dark night conditions.NTSB ERA11WA211Accident · 6 fatalForeign investigationCessna 340 · Tachira, VenezuelaOn February 22, 2011, about 1915 UTC, a Cessna 340A, Venezulian registration YV2402, operated by Premezolados Agreconsa C.A., collided with mountainous terrain near Tachira, Venezuela. Visual meteorological conditions prevailed at the destination airport…NTSB ERA11FA151Accident · 1 fatalField investigationFinal reportCessna 150E · Ware Shoals, SCThe non-certificated pilot's impairment due to alcohol and a sedating antihistamine, which resulted in his failure to maintain airspeed and the subsequent aerodynamic stall and ground impact.NTSB ERA11WA159Accident · 1 fatalForeign investigationRobinson R44 · Canne della Battaglia, ItalyOn February 18, 2011, about 0706 universal coordinated time, a Robinson R44, French registration F-GUJB, crashed after an in-flight separation of the tail rotor from the fuselage. The pilot was killed. The flight departed Bari, Italy, for Foggia Airport…NTSB ERA11WA155Accident · 4 fatalForeign investigationBell 206 · Vereda Galan, ColombiaOn February 18, 2011, about 0415 universal coordinated time, a Bell 206-B, Colombian registration HK-4594, operated by Heliservice LTDA, crashed in mountainous terrain near Vereda Galan, Colombia, and was consumed by a post crash fire. Instrument…NTSB CEN11WA222Accident · 2 fatalForeign investigationLearjet 24 · Pachuca, MexicoOn February 18, 2011, approximately 1705 coordinated universal time (1105 central standard time), a Lear Jet 24, XBGHO, registered to Rutas Aereas Mayas Flight School, was destroyed when it impacted terrain and a building while doing touch-and-go landings at…