NTSB investigations, 2019
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WPR20LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Red Rock, AZA total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s improper use of carburetor heat.NTSB ERA20LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Toms River, NJThe failure of the Cessna 172N pilot to see and avoid a second airplane while maneuvering in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the Cessna 172N pilot to tune his radio to the correct…NTSB GAA20CA080Accident · No injuriesData collectionFinal reportSymphony Aircraft Ind SA · Fitzgerald, GAThe airplane’s impact with a deer while landing.NTSB GAA20CA074Accident · No injuriesData collectionFinal reportCessna 172 · FallBrook, CAThe student pilot's use of excessive ground speed while making a right turn when exiting the runway, which resulted in a loss of directional control and a runway excursion.NTSB GAA20CA071Accident · No injuriesData collectionFinal reportCessna 182 · San Luis, COThe pilot's improper pitch attitude during landing on rising terrain in flat light conditions, which resulted in a hard landing.NTSB GAA20CA067Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a taxiway sign.NTSB WPR20WA021Accident · 1 fatalForeign investigationRobinson R44 · Tunis, TunisiaThe government of Tunisia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on November 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Tunisia's investigation under the…NTSB WPR20LA028Accident · 1 fatalClass 3 · LimitedFinal reportCessna 182 · Metaline, WAImpact with a lake for reasons that could not be determined.NTSB GAA20CA070Accident · No injuriesData collectionFinal reportCessna 195 · Kalispell, MTThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the left main landing gear collapsing.NTSB DCA20WA017Accident · Serious injuriesForeign investigationBoeing 747 · Ataturk, TürkiyeThe Transport Safety Investigation Center (TSIC) of Turkey has notified the NTSB of an accident involving a Boeing 747-400, which occurred on November 11, 2019. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…NTSB DCA20LA013Accident · No injuriesClass 3 · LimitedFinal reportEmbraer EMB145 · Chicago, ILThe flight crew’s inability to maintain the airplane on the runway centerline after touchdown due to the reduced braking action resulting from the deteriorating weather conditions, which caused the airplane’s departure from the runway surface. Contributing to…NTSB ANC20LA004Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Goodnews Bay, AKThe pilot’s failure to monitor the airplane instruments during a night visual flight rules departure in dark light conditions, which resulted in spatial disorientation and the airplane’s descent into water.NTSB GAA20WA123Incident · No injuriesForeign investigationBombardier CL600 2B19 · Madrid, SpainThe government of Spain has notified the NTSB of an accident involving a BOMBARDIER CL600 2B19 airplane that occurred on November 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the…NTSB GAA20CA072Accident · No injuriesData collectionFinal reportCessna U206 · Mexico, MOThe pilot's failure to properly set the parking brake before exiting an operating airplane, which resulted in a runaway airplane and subsequent impact with trees.NTSB GAA20CA063Accident · Minor injuriesData collectionFinal reportSikorsky S 58JT · Lebanon, INThe pilot's failure to maintain proper clearance from a tractor trailer during landing.NTSB ERA20LA033Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20J · St. Augustine, FLA total loss of engine power for undetermined reasons.NTSB GAA20CA085Accident · No injuriesData collectionFinal reportPiper PA60 · Salt Lake City, UTThe pilot's failure to follow the taxiway centerline guide and his distraction due to adjusting the radio, which resulted in his failure to maintain clearance from a taxiway light after landing and while taxiing to a ramp.NTSB GAA20CA084Accident · No injuriesData collectionFinal reportBeech 55 · Broomfield, COThe pilot's unintentional retraction of the landing gear during the landing roll.NTSB GAA20CA064Accident · Minor injuriesData collectionFinal reportNew Glasair Sportsman GS-2 · Huntsville, ARThe pilot's failure to maintain proper pitch control during takeoff from a muddy, turf runway and his exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall.NTSB ERA20LA035Accident · No injuriesClass 3 · LimitedFinal reportBeech 55 · Griffin, GAThe pilot’s failure to ensure that the airplane was properly configured for takeoff, which resulted in the inadvertent retraction of the landing gear during the takeoff roll and the airplane’s subsequent runway excursion.NTSB CEN20LA018Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Houston, TXThe pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.NTSB GAA20CA069Accident · No injuriesData collectionFinal reportCessna 180 · Tyler, TXThe pilot's improper wind correction while taking off with a tailwind, which resulted in a runway excursion and subsequent nose-over.NTSB ENG20WA008Incident · No injuriesForeign investigationAirbus A321 · Raipur, IndiaThe AAIB of India has notified the NTSB of an incident involving an Airbus A321 airplane with CFMI CFM56-5 engines that occurred on November 8, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the…NTSB WPR20FA019Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Upland, CAThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and loss of control.NTSB GAA20CA062Accident · No injuriesData collectionFinal reportBell 47G · Groveland, FLThe student pilot's improper cyclic input after a reported hydraulic failure, the reason for which could not be determined, and his failure to follow the emergency procedures, which resulted in a hard landing.NTSB DCA20IA014Incident · No injuriesClass 3 · IncidentFinal reportEmbraer ERJ170 · Atlanta, GAThe captain’s use of his pitch trim switch, which had been placarded inoperative but not deactivated, resulting in the airplane pitching up when the captain was trying to trim down. The trim commands were reversed due to maintenance personnel’s incorrect…NTSB WPR20WA020Incident · No injuriesForeign investigationCessna 172 · Vereeniging, South AfricaOn November 6, 2019, about 1740 coordinated universal time, a Cessna 172L, South African registration ZS-DAC, was enroute to the VOR beacon GAV, near Vereeniging, and reported a loss of engine power. The pilot forced landed the airplane in a field. The pilot…NTSB GAA20CA075Accident · No injuriesData collectionFinal reportCessna 182 · Broomfield, COThe pilot’s inadvertent flight into icing conditions, which resulted in the accumulation of structural icing and an aerodynamic stall.NTSB GAA20CA073Accident · Minor injuriesData collectionFinal reportSchleicher ASW15 · Waynesville, OHThe glider pilot's improper approach during landing, which resulted in collision with trees.NTSB ENG20WA049Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Owerri, NigeriaNTSB CEN20WA065Accident · No injuriesForeign investigationLearjet 35 · Cabo San Lucas, MexicoOn November 5, 2019, at 1942 Mexican pacific standard time, a Learjet 35A airplane, Mexican registration XA-VBD, experienced a runway excursion after landing at Cabo San Lucas International Airport, Cabo San Lucas, Mexico. The four occupants sustained no…NTSB WPR20LA032Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Hurricane, UTThe pilot’s failure to ensure that the landing gear was in the fully extended and locked position before landing. Contributing to the accident was the overload of the landing gear circuit for reasons that could not be determined.NTSB GAA20CA060Accident · No injuriesData collectionFinal reportRobinson R22 · Smoketown, PAThe student pilot's improper cyclic input while hovering and the flight instructor's delayed remedial action, which resulted in a dynamic rollover.NTSB ERA20TA030Accident · No injuriesClass 3Final reportBeech 76 · Doral, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB ERA20FA031Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · New Bedford, MAPilot impairment due to exposure to carbon monoxide as a result of undetected corrosion and holes in the engine’s left exhaust muffler.NTSB ERA20FA029Accident · 1 fatalClass 3 · FieldFinal reportPavel Tango2 · Cedartown, GAThe pilot's loss of control of the gyroplane for reasons that could not be determined based on available evidence.NTSB GAA20CA059Accident · No injuriesData collectionFinal reportErcoupe 415 · Greer, SCThe pilot's improper landing flare, which resulted in a hard landing, loss of directional control, and impact with a fence.NTSB GAA20CA056Accident · No injuriesData collectionFinal reportPitts S1 · Monument Valley, UTThe pilot's failure to maintain directional control during landing after a wing struck vegetation, which resulted in a runway excursion and subsequent ground-loop.NTSB GAA20CA068Accident · No injuriesData collectionFinal reportIcon A5 · Chester, CTThe pilot's failure to maintain a proper approach angle in dark night conditions, which resulted in a collision with treetops and a subsequent hard landing.NTSB GAA20CA066Accident · No injuriesData collectionFinal reportAmerican AA 5 · Gilbert, SCThe pilot's improper approach path, which resulted in impact with a tree.NTSB GAA20CA057Accident · No injuriesData collectionFinal reportCub Crafters CC11 · Palmyra, PAThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain lateral control during a go-around, which resulted in impact with a tree.NTSB ERA20LA037Accident · Serious injuriesClass 3 · LimitedFinal reportMosquito XE · Seffner, FLThe pilot's failure to maintain control of the helicopter while landing, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's lack of helicopter experience.NTSB GAA20WA083Accident · 1 fatalForeign investigationCessna F150 · Santa Severa Nord, ItalyThe government of Italy has notified the NTSB of an accident involving a CESSNA F150 airplane that occurred on November 01, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB GAA20CA053Accident · No injuriesData collectionFinal reportZenair CH701 · Salem, ORThe pilot's failure to maintain lateral control during takeoff, which resulted in impact with terrain. Contributing to the accident was the pilot’s improper decision to make his first flight in an airplane he unfamiliar with before waiting for calm winds.NTSB ERA20LA028Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Odessa, TXA loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.NTSB ERA20FA027Accident · 1 fatalClass 3 · FieldFinal reportGrumman OV-1 · Stuart, FLThe pilot’s improper recovery from a low-altitude aerobatic maneuver, which resulted in descent into terrain.NTSB ERA20FA026Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Paducah, KYThe pilot’s failure to fully seat the fuel selector in the proper tank position during the descent for landing, which resulted in fuel starvation and a total loss of engine power.NTSB CEN20LA017Accident · Serious injuriesClass 3 · LimitedFinal reportSocata TB 30 Epsilon · Kalamazoo, MIA total loss of engine power for undetermined reasons, which resulted in an aerodynamic stall during the pilot’s attempted forced landing at low altitude and impact with terrain.NTSB WPR20FA018Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Brawley, CAThe pilot’s decision to perform a flight while impaired by the effects of alcohol and cocaine, and his failure to maintain terrain clearance during the flight.NTSB GAA20CA054Accident · Serious injuriesData collectionFinal reportBeech 200 · New Braunfels, TXThe airplane’s in-flight collision with a bird.