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 ERA20FA025Accident · 1 fatalClass 3 · FieldFinal reportVans RV 4 · Middleburg, FLImpact with power lines for reasons that could not be determined based on available evidence.NTSB ERA20FA022Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Ocala, FLThe pilot’s failure to maintain control of the airplane due to an acute medical event and/or his use of impairing medications.NTSB DCA20WA011Incident · No injuriesForeign investigationBoeing 737 · Johannesburg, South AfricaThe CAA of South Africa has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAA's investigation under the provisions of ICAO Annex 13 as…NTSB ANC20LA003Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Honolulu, HIThe pilot of the Cessna's failure to set the parking brake before diverting his attention inside the airplane, which resulted in his airplane colliding with the airplane ahead of it on the taxiway.NTSB ERA20FA021Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28R · Atlanta, GAThe pilot's loss of control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.NTSB ENG20WA023Incident · No injuriesForeign investigationAirbus A320 · Kolkata, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on October 30, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left)…NTSB GAA20CA082Accident · No injuriesData collectionFinal reportCessna 170 · Albuquerque, NMThe pilot receiving instruction's failure to maintain directional control and his inadvertent left brake pedal application during the landing roll, which resulted in a runway excursion and ground-loop.NTSB GAA20CA052Accident · No injuriesData collectionFinal reportRobinson R66 · Alexandria, LAThe pilot's fixation on the instrument panel, which resulted in a hard landing.NTSB ERA20WA032Accident · 2 fatalForeign investigationICP Ventura · Gecitkale, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a ICP Ventura ultralight that occurred on October 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions…NTSB ERA20FA020Accident · 1 fatalClass 3 · FieldFinal reportCessna 414 · Colonia, NJThe pilot’s failure to maintain airspeed during a circling instrument approach procedure, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall and spin.NTSB DCA20CA010Accident · No injuriesData collectionFinal reportDe Havilland DHC8 · Boise, IDa bird strike during climb out.NTSB GAA20CA058Accident · No injuriesData collectionFinal reportLet L13 · Enumclaw, WAThe pilot's failure to maintain a proper glidepath, which resulted in a collision with trees.NTSB GAA20CA055Accident · No injuriesData collectionFinal reportCessna 172 · Augusta, GAThe student pilot's failure to attain sufficient airspeed to climb out of ground effect, which resulted in a descent, loss of directional control, runway excursion, and impact with a fence.NTSB GAA20CA088Accident · Serious injuriesData collectionFinal reportHiggins John H/Williams John D Questair Venture · Daytona Beach, FLThe pilot's unstabilized approach, which resulted in a hard, bounced landing, loss of directional control, and impact with a tree and then terrain.NTSB GAA20CA048Accident · Minor injuriesData collectionFinal reportBeech A36 · Le Roy, NYThe pilot's improper pitch control during takeoff in high, gusting wind conditions, which resulted in a runway overrun and the nose landing gear collapsing.NTSB ERA20LA023Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C · Grand Bay, ALA loss of engine power during initial climb due to carburetor ice that formed during an extended ground delay, and the pilot's failure to use carburetor heat before initiating the takeoff.NTSB DCA20WA009Incident · No injuriesForeign investigationBoeing 737 · Paris, FranceThe BEA of France has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 27, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the BEA of France's investigation under the provisions of ICAO Annex…NTSB CEN20LA015Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · White Bear Township, MNThe pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.NTSB GAA20CA051Accident · No injuriesData collectionFinal reportPereyra Aventura · Tavares, FLThe pilot's improper landing flare, which resulted in a bounced landing on water, and his failure to maintain airplane control during a go-around, which resulted in the airplane nosing over.NTSB ENG20WA028Incident · No injuriesForeign investigationAirbus A320 · Delhi, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on October 26, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 2 (right)…NTSB WPR20WA137Accident · No injuriesForeign investigationRobinson R44 · Pretoria, South AfricaThe government of South African Civil Aviation Authority has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on October 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South…NTSB WPR20WA023Incident · No injuriesForeign investigationSikorsky S92 · Port Harcourt NAS, NigeriaOn October 25, 2019, about 1419, time zone unknown, a Sikorsky S-92 helicopter, 5N-BOA, experienced an in-flight engine shutdown near Port Harcourt NAS, Nigeria. Their were no injuries. The helicopter was operated under the pertinent civil regulations of the…NTSB WPR20FAMS1Accident · 2 fatalClass 3 · Missing aircraftFinal reportPiper PA28R · Shelter Cove, CAUndetermined due to lack of available evidence.NTSB WPR20FA016Accident · 1 fatalClass 3 · FieldFinal reportEnstrom 280F · Jordan Valley, ORA partial loss of engine power due to a worn engine air induction hose, and a subsequent uncontrolled descent into terrain. Contributing to the accident was the failure of maintenance personnel to adequately inspect the hose, and the pilot’s decision to fly…NTSB WPR20FA015Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · American Falls, IDThe pilot’s failure to ensure adequate fuel onboard and his subsequent failure to maintain airspeed while maneuvering which resulted in an aerodynamic stall following a total loss of engine power due to fuel exhaustion. Contributing to the accident was the…NTSB GAA20CA050Accident · No injuriesData collectionFinal reportPiper PA 30 · Opa Locka, FLThe pilot receiving instruction's failure to relinquish the flight controls to the flight instructor during a simulated engine failure during takeoff, which resulted in the airplane touching down in a left banking attitude and the landing gear collapsing.NTSB ENG20WA022Incident · No injuriesForeign investigationAirbus A320 · Mumbai Airport, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on October 25, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 2 (right)…NTSB CEN20LA014Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Swea City, IAThe pilot's failure to replace the oil filler cap during his preflight inspection, which resulted in oil starvation and a subsequent total loss of engine power.NTSB WPR20LA017Accident · No injuriesClass 3 · LimitedFinal reportCessna 205 · Red Creek, AZThe pilot’s failure to properly configure the flaps for an aborted landing, which resulted in degraded climb performance and impact with vegetation at the end of the runway.NTSB GAA20CA091Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 · Apopka, FLThe student pilot's improper landing flare, which resulted in a hard, bounced landing and subsequent nose-over.NTSB ERA20FA019Accident · 2 fatalClass 3 · FieldFinal reportMooney M20A · Summit Point, WVThe pilot’s decision to conduct a practice stall maneuver at low altitude, which resulted in inadequate altitude remaining in which to recover before impacting terrain.NTSB ENG20WA026Incident · No injuriesForeign investigationAirbus A320 · Kolkata, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on October 24, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 2 (right)…NTSB WPR20LA014Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV 6 · Spanaway, WAA total loss of engine power during the initial climb for reasons that could not be determined.NTSB WPR20LA012Accident · No injuriesClass 3 · LimitedFinal reportCzech Sport Sportcruiser · Holden, UTThe fatigue failure of the No. 2 cylinder intake valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power. Contributing to the severity of the damage was the improper deployment of the ballistic…NTSB WPR20FA013Accident · 2 fatalClass 3 · FieldFinal reportRobinson R44 · Las Vegas, NVAn undetermined inflight event that resulted in the pilot performing an autorotation to uneven terrain for reasons that could not be determined due to the extent of impact damage.NTSB GAA20WA078Accident · 6 fatalForeign investigationCessna 401 · Madero, Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 401 airplane that occurred on October 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB GAA20CA095Accident · No injuriesData collectionFinal reportCessna 120 · Marion, ALThe student pilot's overapplication of the brakes during landing to avoid a deer on the runway, which resulted in a nose-over.NTSB CEN20FA012Accident · 2 fatalClass 3 · FieldFinal reportRobinson R22 Beta · Hebbronville, TXThe failure of the spotter helicopter pilot to maintain clearance from the gunner helicopter while maneuvering. Contributing to the accident were the effects from the pilot’s use of impairing drugs.NTSB CEN20LA013Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 502 · Lamesa, TXThe pilot's improper decision to maneuver at a low altitude and in close proximity to a wind turbine undergoing maintenance, which resulted in a collision with a tagline rope being held by a worker on the ground and serious injury to the worker.NTSB GAA20WA065Accident · 2 fatalForeign investigationCirrus SR20 · Belo Horizonte, BrazilThe government of Brazil has notified the NTSB of an accident involving a CIRRUS SR20 airplane that occurred on October 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB GAA20WA047Accident · 1 fatalForeign investigationRobinson R44 · Tarasenkove, UkraineThe government of Ukraine has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on October 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ukraine's investigation under the…NTSB GAA20CA044Accident · No injuriesData collectionFinal reportRichard B Carpenter AR-1 · Brooksville, FLThe pilot's failure to attain the proper rotor speed before takeoff, which resulted in the rotor blade striking the rudder. Contributing to the accident was the pilot's failure to abort the takeoff in a timely manner.NTSB GAA20CA041Accident · No injuriesData collectionFinal reportMaule MX7 · Nantucket, MAThe pilot's failure to maintain directional control during landing on a grass runway in gusting wind conditions, which resulted in impact with a large bush.NTSB WPR20FA008Accident · 2 fatalClass 3 · FieldFinal reportPiper PA 24 · Angel Fire, NMThe airplane’s degraded performance due to high-density altitude and gusting wind conditions, which resulted in its inability to maintain altitude during the initial takeoff climb. Contributing to the accident was the pilot’s lack of experience with high…NTSB GAA20WA077Accident · 2 fatalForeign investigationCessna 310 · La Piedad, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 310 airplane that occurred on October 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB GAA20CA040Accident · No injuriesData collectionFinal reportKitfox S7 · Reno, NVThe pilot's use of excessive braking control during the landing roll, which resulted in a nose over.NTSB GAA20CA039Accident · No injuriesData collectionFinal reportZenair CH 701 · Safford, AZThe in-flight separation of a propeller blade for reasons that could not be determined based on the available evidence, which resulted in an off-airport landing on soft sand and the separation of main landing gear. Contributing to the accident was the pilot’s…NTSB GAA20CA038Accident · No injuriesData collectionFinal reportPiper PA28 · Wedgefield, FLAn in-flight collision with a bird.NTSB ERA20FA014Accident · 2 fatalClass 3 · FieldFinal reportPiper PA32 · Raleigh, NCThe pilot’s failure to maintain a safe glidepath during final approach to the runway, which resulted in a collision with trees and terrain. Contributing was the pilot’s lack of recent instrument flight experience.NTSB ENG20RA002Incident · No injuriesForeign investigationBoeing 777 · Bangkok, ThailandOn October 20, 2019, a Thai Airways International Boeing 777-300ER, powered by two General Electric GE90-115B turbofan engines, aborted takeoff after experiencing a No. 1 engine high pressure turbine uncontainment failure during takeoff roll. The incident is…