NTSB investigations, 2019
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 year(c.\"eventDate\") = 2019 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 year(c."eventDate") = 2019 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 CEN20FA009Accident · 1 fatalClass 3 · FieldFinal reportVans RV-8 · White Plains, ALImpact with terrain for reasons that could not be determined based on the available information.NTSB GAA20CA079Accident · No injuriesData collectionFinal reportPiper PA28 · Quakertown, PAThe student pilot's improper landing flare, which resulted in a hard, bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and collision with a drainage culvert.NTSB GAA20CA037Accident · No injuriesData collectionFinal reportUltramagic N 250 · Albuquerque, NMThe pilot's failure maintain clearance from power lines, which resulted in an explosion and preimpact fire.NTSB CEN20WA011Accident · 2 fatalForeign investigationCessna 172 · San Salvador, El SalvadorNTSB WPR20LA009Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 206 · Stockton, CAA total loss of engine power after takeoff for reasons that could not be determined based on the available information.NTSB GAA20CA043Accident · No injuriesData collectionFinal reportZenair Zenith 801 · Knoxville, TNThe pilot's failure to maintain a proper descent rate during the approach and his improper landing flare, which resulted in a hard landing.NTSB GAA20CA036Accident · No injuriesData collectionFinal reportTitan Titan Tornado II · Marble Canyon, AZThe pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a runway excursion and impact with sand hummocks.NTSB GAA20CA034Accident · Minor injuriesData collectionFinal reportBell 47G · King City, CAThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing and the main rotor blades striking the tailboom.NTSB ERA20WA015Accident · Minor injuriesForeign investigationDouglas DC3C S1C3G · Nassau, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Douglas DC3C S1C3G airplane that occurred on October 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the…NTSB ERA20LA018Accident · No injuriesClass 3 · LimitedFinal reportBeech N35 · Madisonville, TNThe pilot's unstable approach and delayed decision to go-around. Contributing to the accident was the unporting of the fuel supply following a forward slip maneuver during the approach, which resulted in the loss of engine power during the go-around.NTSB ERA20LA017Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Shellman, GAA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA20FA013Accident · 1 fatalClass 3 · FieldFinal reportSportine Aviacija LAK17B · Tamaqua, PAThe pilot's exceedance of the glider's critical angle of attack while climbing in thermal lift, which resulted in an aerodynamic stall/spin.NTSB DCA20MA002Accident · 1 fatalClass 1 · MajorFinal reportSaab 2000 · Unalaska, AKThe landing gear manufacturer’s incorrect wiring of the wheel speed transducer harnesses on the left main landing gear during overhaul. The incorrect wiring caused the antiskid system not to function as intended, resulting in the failure of the left outboard…NTSB GAA20CA046Accident · No injuriesData collectionFinal reportCessna L19 · New Braunfels, TXThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and ground-loop.NTSB GAA20CA035Accident · No injuriesData collectionFinal reportRobinson R22 · Overton, NVThe pilot’s failure to maintain a proper approach and the flight instructor's subsequent failure to maintain an adequate climb rate during an attempted go-around in gusting tailwind conditions, which resulted in a hard landing and dynamic rollover.NTSB GAA20CA033Accident · No injuriesData collectionFinal reportWeatherly 620 · Fabens, TXThe pilot's failure to maintain clearance from power wires while maneuvering at a low altitude.NTSB GAA20CA032Accident · Minor injuriesData collectionFinal reportFlight Design Ctls · Monument Valley, UTThe pilot's failure to maintain lateral control and to attain adequate altitude during takeoff with a quartering tailwind in gusting wind conditions, which resulted in impact with a sandy berm left of the runway.NTSB GAA20CA031Accident · No injuriesData collectionFinal reportErcoupe 415 · Alvin, TXThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport landing, during which the airplane landed hard and then ground looped.NTSB ERA20FA012Accident · 1 fatalClass 3 · FieldFinal reportBell 206 · New Salem, NCThe pilot's inadequate visual lookout, which resulted in impact with a powerline.NTSB DCA20CA003Accident · No injuriesData collectionFinal reportKitty Hawk Heaviside2 · Tres Pinos, CAa software timing error initiated by a battery charging script that was not properly terminated prior to the test flight due to operator error.NTSB CEN20LA021Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA23 · (Gulf of Mexico)The airplane’s descent into the ocean for reasons that could not be determined.NTSB CEN20FA008Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7AC · Green Bay, WIThe pilot’s low final approach path and his failure to see and avoid a truck traveling on a roadway, which resulted in a collision with the truck.NTSB GAA20CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Gerlach, NVThe pilot's exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall.NTSB ERA20LA016Accident · Serious injuriesClass 3 · LimitedFinal reportBombardier BD 700 1A10 · Augusta, GAThe first officer's failure to maintain a safe distance from a large turbine-powered airplane while escorting passengers, resulting in a passenger encounter with jet blast.NTSB WPR20WA011Incident · No injuriesClass 5 · ForeignDiamond DA42 · Singapore, SingaporeNTSB GAA20CA029Accident · No injuriesData collectionFinal reportCessna 180 · Flannigan, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a wing strike.NTSB GAA20CA028Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Lebanon, NHThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a ditch.NTSB GAA20CA023Accident · No injuriesData collectionFinal reportCessna 172 · Louisville, KYThe student pilot's improper landing flare, which resulted in a porpoised landing, a subsequent hard landing on grass left of the runway, and a nose-over. Contributing to the accident was the student’s self-imposed pressure to land the airplaneNTSB GAA20CA014Accident · No injuriesData collectionFinal reportPiper PA38 · Colorado Springs, COThe pilot's failure to maintain the runway heading while taking off with a gusting tailwind, which resulted in impact with a fence.NTSB ENG20LA001IncidentClass 3 · LimitedFinal reportAirbus BD-500-1A11 (CS300) · West Flanders Province, BelgiumA No. 1 (left) engine low pressure compressor (LPC) stage 1 integrally bladed rotor (IBR) separation due to a high cycle fatigue crack (HCF) that originated at the runout of an airfoil leading edge root radius. The HCF crack developed because of a…NTSB DCA20WA012Incident · No injuriesForeign investigationBoeing 737 · Malta, MaltaThe AAIU of Ireland has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on October 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU of Ireland's investigation under the provisions of ICAO…NTSB WPR20LA007Accident · Minor injuriesClass 3 · LimitedFinal reportHiller UH 12E · Susanville, CAA partial loss of engine power due to multiple overtemperature events and a hot start event, which resulted in thermally damaged internal components of the engine. Contributing to the accident was the lack of suitable terrain on which to perform the forced…NTSB GAA20WA093Incident · No injuriesForeign investigationSikorsky S92 · Foxcote house, Gloucestershire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a SIKORSKY S92 helicopter that occurred on October 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation…NTSB GAA20CA045Accident · No injuriesData collectionFinal reportAeropro CZ A220 · Buckeye, AZThe pilot's failure to maintain directional control during an aborted landing with a crosswind, which resulted in tailwheel impacting vegetation and the left main landing gear collapsing.NTSB GAA20CA022Accident · No injuriesData collectionFinal reportBeech 36 · Douglas, GAThe pilot's failure to extend the landing gear due to intoxication during an unauthorized flight.NTSB GAA20CA013Accident · No injuriesData collectionFinal reportSocata TBM700 · Breckenridge, TXThe pilot's failure to maintain bank control and adequate altitude during the approach, which resulted in his failure to maintain the runway heading and a subsequent collision with trees and terrain.NTSB ERA20FA009Accident · 1 fatalClass 3 · FieldFinal reportVans RV4 · Cameron, NCThe pilot's exceedance of the airplane’s critical angle of attack during the landing approach, which resulted in a loss of control and a subsequent aerodynamic stall/spin. Contributing to the accident was the pilot's decision to fly the airplane in a…NTSB GAA20CA025Accident · Serious injuriesData collectionFinal reportCessna 172 · Key West, FLThe pilot’s and the passenger's improper decision to have the passenger attempt to move a wheel chock while the propeller was turning, which resulted in a serious injury.NTSB GAA20CA015Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Goddard, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN20LA016Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Springtown, TXA total loss of engine power for undetermined reasons.NTSB ANC20LA002Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Palmer, AKThe pilot's delayed application of carburetor heat in weather conditions conducive to carburetor icing, which resulted in a partial loss of engine power, a precautionary landing, and impact with terrain.NTSB ANC20CA006Accident · No injuriesData collectionFinal reportPiper PA18 · Moose Pass, AKThe pilot's improper approach, which resulted in his failure to maintain clearance from a tree while landing in dusk conditions, and his subsequent loss of directional control, which resulted in a runway excursion.NTSB GAA20CA026Accident · Minor injuriesData collectionFinal reportLlewellyn, Warwinc W Vans RV-4 · Lusby, MDThe pilot's failure to maintain lateral control during takeoff, which resulted in impact with terrain and a subsequent cartwheel.NTSB GAA20CA024Accident · No injuriesData collectionFinal reportCessna 180 · Greenville, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and ground-loop.NTSB GAA20CA011Accident · No injuriesData collectionFinal reportChampion 8GCBC · Henrys Lake, IDThe pilot's decision to land on unsuitable terrain, which resulted in a nose-over.NTSB CEN20TA007Accident · Serious injuriesFinal reportAutoGyro MTO Sport · Montgomery, TXThe pilot's failure to maintain clearance from trees during departure. Contributing to the accident was the pilot's inadequate preflight assessment of the field for takeoff.NTSB WPR20WA010Accident · No injuriesForeign investigationBell 412 · Port Said City, EgyptOn October 11, 2019, about 1147 coordinated universal time, a Bell Helicopter 412EP, SU-CBX, impacted the sea about 65 miles north of Port Said City, Egypt after losing control in flight. There were no injuries to the two pilots and three passengers, and the…NTSB GAA20CA027Accident · Minor injuriesData collectionFinal reportZenith Zenith 601XLB · Gastonia, NCThe pilot's failure to latch the canopy before departure, which resulted in the canopy opening and the subsequent loss of airplane control.NTSB GAA20CA021Accident · No injuriesData collectionFinal reportWingtip To Wingtip Panzl S-330 · Cedartown, GA***This report was modified on June 4, 2020. Please see the docket for this accident to view the original report.*** The departing pilot's failure to see and avoid the arriving airplane as it was turning off the runway from which the departing pilot was…NTSB GAA20CA020Accident · Minor injuriesData collectionFinal reportAyres S2R · Willacoochee, GAThe pilot's failure to maintain clearance from power lines while maneuvering at low altitude.