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 DCA19WA203Accident · Serious injuriesForeign investigationBoeing 787 · Beijing, ChinaThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 797, which occurred on August 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex…NTSB DCA19WA202Incident · Minor injuriesForeign investigationBoeing 767 · Shannon, IrelandThe AAIU of Ireland has notified the NTSB of an accident involving a Boeing 767 airplane that occurred on August 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions of ICAO…NTSB CEN19LA275Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Rio Grande City, TXThe loss of engine power following an increase in oil temperature for undetermined reasons during cruise flight, which resulted in a forced landing on unsuitable terrain.NTSB CEN19LA267Accident · Minor injuriesClass 3 · LimitedFinal reportDe Havilland DHC6 · San Marcos, TXThe pilot's delayed go-around attempt and the flight instructor's delayed remedial action that resulted in a nose-down impact with terrain during an attempted go-around.NTSB WPR19LA218Accident · No injuriesClass 3 · LimitedFinal reportExtra EA300 · Mesa, AZThe flight instructor’s operation of the airplane outside of the manufacturer’s limitations, which resulted in fuel starvation and a partial loss of engine power. Contributing to the accident was an inoperative electric fuel boost pump.NTSB GAA19CA494Accident · No injuriesData collectionFinal reportRockwell 690 · Stockton, CAThe pilot's delay in extending the landing gear and his improper movement of the landing gear lever, which led to a gear-up landing.NTSB ERA19LA247Accident · 1 fatalClass 3 · LimitedFinal reportFantasy Air Allegro · Boone, NCThe reported total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN19WA272Incident · No injuriesForeign investigationReims Aviation Cessna F172N · Lesnovo, BulgariaOn August 14, 2018, about 0750 coordinated universal time, a Reims Aviation Cessna F172N airplane, Bulgarian registration number LZ-SPB, had a forced landing at the Lesnovo Airport (LBLS), Lesnovo, Bulgaria, following an inflight loss of engine power. The…NTSB ERA19LA246Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jay, FLThe pilot's improper decision to fly over a river at a very low altitude, which resulted in a collision with power lines.NTSB GAA19CA512Accident · No injuriesData collectionFinal reportPiper PA28 · Chickasha, OKThe student pilot's failure to maintain crosswind correction during landing and his subsequent loss of directional control during the landing roll, which resulted in a runway excursion and impact with uneven terrain.NTSB ANC19TA044Accident · Minor injuriesClass 3Final reportCessna 180 · Anchorage, AKThe pilot’s failure to maintain takeoff heading due to sun glare, which resulted in his inability to see an island adjacent to the water lane and subequent impact with the island.NTSB WPR19FA216Accident · 2 fatalClass 3 · FieldFinal reportLancair Lancair IV · Kooskia, IDThe pilot’s failure to maintain airspeed while maneuvering in an area of precipitation and reduced visibility, which resulted in an aerodynamic stall and spin and loss of airplane control.NTSB ERA19WA270Accident · 3 fatalClass 5 · ForeignEmbraer EMB710 · Itaituba, BrazilNTSB ERA19LA245Accident · Serious injuriesClass 3 · LimitedFinal reportSchweizer 269C · Allentown, PAInadequate maintenance of the helicopter’s magnetos, which resulted in a partial loss of engine power during the initial climb due to a failure of the left magneto and malfunction of the right magneto.NTSB ERA19FA243Accident · 2 fatalClass 2 · FieldFinal reportPoberezny Acro Sport II · Jersey Shore, PAThe pilot's decision to conduct low altitude aerobatic maneuvers which resulted in an exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude, which resulted in an aerodynamic stall.NTSB CEN19LA263Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · New Carlisle, OHThe pilot’s excessive use of pitch control during rotation, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff.NTSB WPR19LA217Accident · No injuriesClass 3 · LimitedFinal reportCessna 206 · Prospect, ORThe failure of the counterweight retainer pin plate which resulted in a total loss of engine power.NTSB GAA19CA493Accident · No injuriesData collectionFinal reportNorth American AT 6D · Chino, CAThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA19CA491Accident · No injuriesData collectionFinal reportConsolidated Vultee BT13 · Franklin, PAThe pilot's failure to maintain directional control during takeoff in gusting crosswind conditions, which resulted in a runway excursion and the left main landing gear collapsing.NTSB GAA19CA489Accident · No injuriesData collectionFinal reportCessna 180 · Two Harbors, MNThe pilot's abrupt maneuver to try and avoid a deer during landing on a grass strip runway, which resulted in a ground loop.NTSB DCA19WA197Incident · No injuriesForeign investigationBoeing 787 · Rome, ItalyThe government of Italy has notified the NTSB of an incident involving a BOEING 787 airplane that occurred on August 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB CEN19WA274Accident · No injuriesForeign investigationBell 206 · Vuoggatjålme, SwedenOn August 10, 2019, about 0855 hours universal coordinated time, a Bell 206-L1, Swedish registration SE-JOA, was damaged when the rotor blades struck the tail boom during an emergency landing following a loss of engine power after takeoff near Vuoggatjålme,…NTSB CEN19LA262Accident · Minor injuriesClass 3 · LimitedFinal reportPietenpol Aircamper · Newark, OHThe engine’s failure to produce full power for reasons that could not be determined.NTSB WPR21WA102AccidentClass 5 · ForeignCessna 150 · Gan International Airport, MaldivesNTSB WPR19LA228Accident · Serious injuriesClass 3 · LimitedFinal reportHead AX9-118 · Galt, CAA loss of control following an adverse wind encounter.NTSB WPR19FA215Accident · 1 fatalClass 3 · FieldFinal reportNorth American T28A · Ontario, ORA total loss of engine power due to the improperly adjusted carburetor idle valve.NTSB GAA19WA573Accident · Serious injuriesForeign investigationBeech 36 · Corse-du-Sud, FranceThe government of France has notified the NTSB of an accident involving a BEECH 36 airplane that occurred on August 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB GAA19CA558Accident · No injuriesData collectionFinal reportCessna 172 · Chicago, ILThe pilot's improper landing flare, which resulted in a hard, porpoised landing.NTSB ENG19WA042Incident · No injuriesForeign investigationAirbus A320 · Varanasi, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on August 9, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 2 (right)…NTSB CEN19LA264Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Cordell, OKThe pilot's improper landing flare, which resulted in a hard bounced landing.NTSB WPR19LA220Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Phoenix, AZThe failure of the landing gear due to the nose gear being positioned to the far right during retraction, which caused the nose gear to jam upon retraction.NTSB GAA19CA488Accident · No injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot's improper decision to turn off the runway while the airplane was moving too fast after landing, which resulted in a runway excursion and impact with a taxiway sign.NTSB ERA19WA242Accident · No injuriesForeign investigationPiper PA34 · Bimini, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA34 airplane that occurred on August 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…NTSB ERA19FA240Accident · 3 fatalClass 3 · FieldFinal reportBeech F33 · Hatboro, PAThe pilot's loss of airplane control due to spatial disorientation during the departure climb after entering instrument meteorological conditions.NTSB DCA19LA193Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321 · Orlando, FLEncountering gusty conditions at a low altitude during landing and the crew’s decision to do a go-around at a low altitude with an excessive rotation rate.NTSB DCA19CA198Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A320 · Charlottesville, VAan inadvertent encounter with clear air turbulence.NTSB CEN19LA266Accident · Serious injuriesClass 3 · LimitedFinal reportCanadair CL600 2B16 · Lubbock, TXThe unexpected wake turbulence encounter while climbing in smooth air to cruise, resulting in passenger injuries. Contributing to the accident was the passenger seat belt sign was off.NTSB CEN19LA260Accident · Minor injuriesClass 3 · LimitedFinal reportMoth DH60GM · Cortez, COA partial loss of engine power due to carburetor ice accumulation, which resulted in a loss of altitude and impact with trees.NTSB CEN19LA258Accident · Minor injuriesClass 3 · LimitedFinal reportCessna R172 · North Garden, VAA total loss of engine power due to the failure of the oil pump drive gear.NTSB CEN19FA259Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT502 · Sumner, IAThe pilot’s impairment by medical conditions and/or medications, which resulted in the airplane’s impact with power lines and terrain.NTSB WPR19FA212Accident · 2 fatalClass 3 · FieldFinal reportWheeler Express Series 2000 · Camarillo, CAThe pilot’s failure to maintain adequate airspeed on final approach, which resulted in exceedance of the airplane’s critical angle of attack and an aerodynamic stall at an altitude that precluded recovery.NTSB GAA19CA490Accident · No injuriesData collectionFinal reportDiamond DA20 · Pueblo, COThe student pilot's failure to maintain the runway heading during an attempted aborted landing, which resulted in a runway excursion onto rough terrain.NTSB ENG19RA038Incident · No injuriesForeign investigationRaytheon 390 · Hamburg, GermanyOn August 7, 2019, about 1408 coordinated universal time (UTC), a Raytheon 390 Premier 1A airplane, Czech Republic registration OK-EJH, experienced smoke/fire in the cockpit from the windshield heat system during takeoff from Hamburg Airport, Hamburg,…NTSB CEN19FA253Accident · 1 fatalClass 3 · FieldFinal reportJonker Sailplanes JS1C · Cotulla, TXThe pilot’s failure to maintain sufficient airspeed of the glider, which resulted in exceedance of the glider's critical angle of attack and an aerodynamic stall/spin.NTSB WPR19WA210Accident · 1 fatalForeign investigationLiberty Aerospace XL-2 · Braidwood, AustraliaOn August 6, 2019, at 0138 coordinated universal time, a Liberty Aerospace XL-2, registration VH-XLK, collided with terrain during a landing attempt near Braidwood, New South Wales, Australia. The pilot and sole occupant was fatally injured, and the airplane…NTSB GAA19WA533Accident · 1 fatalForeign investigationPiper PA25 · Totatlan, Jalisco, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on August 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB DCA19CA192Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 737 · SFO International Airport, CAthe ramp controller directing a Boeing 737 to hold in a location that was marked for a regional jet.NTSB ANC19WA052Accident · 2 fatalForeign investigationCessna 208 · Mayo, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on August 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB WPR19FA209Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Wolf Point, MTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an accelerated aerodynamic stall and subsequent loss of control.NTSB GAA19WA583Accident · No injuriesForeign investigationCessna 560 · Aarhus airport, DenmarkThe government of Denmark has notified the NTSB of an accident involving a CESSNA 560 airplane that occurred on August 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the provisions…