NTSB investigations
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 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 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 ERA20CA103Accident · No injuriesData collectionFinal reportPiper PA28RT · Fort Myers, FLThe fracture of the right main landing gear torque link bolt on landing, which resulted in the landing gear assembly rotating freely, the subsequent loss of directional control, and the landing gear collapsing.NTSB ERA20CA098Accident · No injuriesData collectionFinal reportMaule M7 · Manchester, NHThe pilot's improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a ground-loop.NTSB DCA20WA070Accident · Serious injuriesForeign investigationAirbus A380 · Los Angeles, CAThe General Civil Aviation Authority (GCAA) of the United Arab Emirates has informed the NTSB of an accident involving an Airbus A-380, which occurred on February 2, 2020. The NTSB has appointed a U.S Accredited Representative to assist the GCAA investigation…NTSB CEN20FA072Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Florence, COThe pilot’s decision to continue the takeoff with reduced airplane performance due to high density altitudeNTSB CEN20LA073Accident · No injuriesClass 3 · LimitedFinal reportHiller UH 12E · Dinosaur, COFailure of a S4 compressor blade due to a fatigue crack that likely initiated at a corrosion pit. Contributing to the accident was maintenance personnel’s failure to detect the corrosion pits during maintenance.NTSB ANC20WA025Accident · No injuriesForeign investigationAgustawestland AW139 · Fukushima, JapanThe government of Japan has notified the NTSB of an accident involving a AGUSTAWESTLAND AW139 helicopter that occurred on February 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the…NTSB ERA20CA093Accident · No injuriesData collectionFinal reportCessna 172 · Crystal River, FLThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and subsequent nose-over.NTSB DCA20WA073Incident · No injuriesForeign investigationBoeing 757 · Keflavik, IcelandThe Icelandic Transportation Safety Board (ITSB) has informed the NTSB of an incident involving a Boeing 757-200, which occurred on February 7, 2020. The NTSB has appointed a U.S Accredited Representative to assist the ITSB investigation under the provisions…NTSB DCA20WA062Incident · No injuriesForeign investigationBoeing 747 · Dammam, Saudi ArabiaThe government of Saudi Arabia has notified the NTSB of an accident involving a BOEING 747 airplane that occurred on January 31, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Saudi Arabia's investigation under the…NTSB ERA20CA099Accident · No injuriesData collectionFinal reportPiper PA28 · Naples, FLThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and impact with sign.NTSB DCA20WA063Incident · No injuriesForeign investigationAirbus A300 · Bogota, ColombiaThe government of Colombia has notified the NTSB of an incident involving a AIRBUS A300 airplane that occurred on January 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB ANC20CA016Accident · No injuriesClass 4 · Data collectionFinal reportCessna 150 · Big Lake, AKThe pilot's failure to apply full carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power, a forced landing, and impact with a tree.NTSB WPR20WA129Accident · Minor injuriesClass 5 · ForeignCessna U206G · Happy Valley, AustraliaNTSB CEN20TA071Accident · Minor injuriesClass 3Final reportBeech 60 · Big Spring, TXA total loss of engine power in both engines due to fuel exhaustion, which resulted in a landing short of the runway.NTSB CEN20LA125Accident · No injuriesClass 3 · LimitedFinal reportMitsubishi MU 2B-40 · Chilton, WIThe pilot's decision to land on the turf runway with insufficient landing performance and his subsequent loss of control during the landing roll.NTSB CEN20FA070Accident · 3 fatalClass 3 · FieldFinal reportPiper PA60 · Springfield, ILThe pilot’s failure to follow the instrument landing system (ILS) course guidance during the instrument approach.NTSB WPR20CA085Accident · No injuriesData collectionFinal reportCessna 180 · Eloy, AZThe pilot's failure to maintain directional control while landing in crosswind conditions, which resulted in a ground-loop.NTSB ERA20FA088Accident · 1 fatalClass 3 · FieldFinal reportAeropro CZ A220 · Grafton, WVThe pilot’s decision to continue a visual flight rules flight into instrument meteorological conditions and conditions favorable for airframe icing, which resulted in a loss of control of the airplane.NTSB CEN20LA069Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Woody Creek, COWater trapped in the static system, which resulted in incorrect airspeed display information and the pilot’s forced landing.NTSB DCA20MA059Accident · 9 fatalClass 1 · MajorFinal reportSikorsky S76 · Calabasas, CAThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s likely self-induced pressure…NTSB CEN20CA067Accident · Minor injuriesData collectionFinal reportGlasair 1 · Greenville, TXThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing, and his subsequent loss of airplane control during an attempted go-around.NTSB WPR20CA084Accident · No injuriesData collectionFinal reportCessna 150 · Prescott, AZThe pilot's improper approach and landing flare, which resulted in a stall and a subsequent hard, bounced landing.NTSB WPR20CA080Accident · No injuriesClass 4 · Data collectionFinal reportMerwin Kitfox · Goodyear, AZThe tail wheel mechanism detachment for reasons that could not be determined due to the lack of available evidence which resulted in the loss of directional control on landing.NTSB ERA20LA221Accident · No injuriesClass 3 · LimitedFinal reportGulfstream 150 · San Juan, PRThe pilot’s loss of control during landing on a wet runway after encountering standing water.NTSB ERA20LA089Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Summerland Key, FLThe pilot's failure to remove the flight control gust lock before takeoff, which resulted in an inability to rotate, aborted takeoff, and subsequent runway overrun. Contributing to the accident was a missing piece of the flight control gust lock, which did…NTSB ERA20FA086Accident · 2 fatalClass 3 · FieldFinal reportMustang II · Senoia, GAThe pilot’s exceedance of the airplane’s structural limitations while conducting previous aerobatic maneuvers, which resulted in an in-flight breakup of the airplane.NTSB ERA20FA085Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · Lake City, FLThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and subsequent loss of control at low altitude.NTSB CEN20WA102Accident · 1 fatalForeign investigationRobinson R44 · Tuzantan, MexicoOn January 25, 2020, about 1858 hours universal coordinated time, a Robinson R-44II helicopter, Mexican registration XB-KQV, impacted terrain near Tuzantan, Chiapas, Mexico. The pilot was fatally injured. The flight departed Ángel Albino Corzo / Tuxtla…NTSB WPR20FA079Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Payson, AZThe pilot's decision to fly into a canyon with rising terrain, and his subsequent loss of aircraft control while maneuvering away from rising terrain.NTSB WPR20FA077Accident · 2 fatalClass 3 · FieldFinal reportStinson V77 · Auburn, CAA total loss of engine power due to a combination of mechanical engine anomalies. Contributing to the accident was inadequate maintenance that failed to identify the engine anomalies.NTSB GAA20WA110Accident · 1 fatalForeign investigationExtra E54T · Iztapa, GuatemalaNTSB ERA20CA087Accident · No injuriesData collectionFinal reportVans Vans RV 8 · Fernandina Beach, FLThe pilot receiving instruction’s loss of directional control on landing with a crosswind, which resulted in a runway excursion and the left main landing gear collapsing.NTSB ENG20WA017Incident · No injuriesForeign investigationAirbus A320 · Mexico City, MexicoOn January 24, 2020, an Airbus A320-271N neo, powered by two Pratt & Whitney PW1127G-JM geared turbofan engines, experienced a right (No. 2) engine failure while climbing through 11,500 feet after takeoff from the Mexico City Intentional Airport (MMMX). The…NTSB CEN20LA066Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Charlotte, TXThe pilot's failure to maintain clearance from a powerline during landing.NTSB WPR20WA082Accident · 3 fatalForeign investigationCessna S550 · George, South AfricaOn January 23, 2020, about 0853 coordinated universal time, a Cessna S550, ZS-CAR, impacted mountainous terrain under unknown circumstances while conducting aerial surveying operations near George, South Africa. The two crew members and one passenger were…NTSB WPR20WA076Accident · 3 fatalClass 5 · ForeignLockheed C130 · Cooma, AustraliaNTSB ENG20WA034Incident · No injuriesForeign investigationBombardier CL600 2C10 · Lyon Saint Exupéry Airport, FranceThe BEA of France has notified the NTSB of an incident involving a Bombardier CL600-2C10 airplane that occurred on January 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the BEA of France's investigation under the provisions of…NTSB DCA20WA061Incident · No injuriesForeign investigationAirbus A319 · Panama City, PanamaThe government of Panama has notified the NTSB of an incident involving a Airbus A319 airplane that occurred on January 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Panama's investigation under the provisions…NTSB CEN20WA081Accident · Serious injuriesForeign investigationBell 206 · Lac Saint-Jean, CanadaThe government of Canada has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on January 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB WPR20WA083Accident · 2 fatalForeign investigationCessna 182 · Tangalooma, AustraliaThe government of Australia has notified the NTSB of an accident involving a CESSNA 182 airplane that occurred on January 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB WPR20FA072Accident · 4 fatalClass 3 · FieldFinal reportBeech B36TC · Corona, CAThe pilots’ failure to abort the takeoff, which resulted in a collision with a fence at the end of the runway. Contributing to the accident was the airplane being at or over the maximum gross takeoff weight and the inappropriate elevator trim tab setting.NTSB WPR20CA074Accident · Minor injuriesData collectionFinal reportPiper PA-18 Replica · Jean, NVThe pilot's inadvertent application of the brakes during the landing roll, which resulted in a nose-over.NTSB WPR20CA073Accident · Minor injuriesData collectionFinal reportStearman B75N1 · Vacaville, CAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and nose-over when the right wheel encountered mud.NTSB GAA20WA107Accident · 2 fatalForeign investigationPiper PA28 · Chatel-St-Denis, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a PIPER PA28 airplane that occurred on January 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB DCA20WA060Incident · No injuriesForeign investigationBoeing 777 · Sydney, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of a serious incident involving a Boeing 777 airplane that occurred on January 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…NTSB CEN20LA068Accident · No injuriesClass 3 · LimitedFinal reportBell 407 · Minot, NDThe pilot's failure to maintain clearance from fencing around the landing pad during landing, which resulted in the tail rotor contacting the fence.NTSB ERA20LA084Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman AA5 · Tallahassee, FLThe pilot's improper fuel planning, resulting in fuel exhaustion and a total loss of engine power in cruise flight.NTSB CEN20CA064Accident · Serious injuriesData collectionFinal reportGuimbal Cabri G2 · Independence, IAThe student pilot's failure to maintain helicopter control while maneuvering to land, which resulted in impact with an airplane and a hangar.NTSB WPR20FA067Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Jacksonville, TXThe pilot’s failure to maintain clearance from guy wires associated with a tower while maneuvering at low altitude.NTSB WPR20CA071Accident · No injuriesData collectionFinal reportCessna 172 · Sun River, ORThe pilot's failure to maintain directional control during the landing roll on a runway with icy patches, which resulted in impact with a snowbank and a subsequent nose-over.