NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 GAA19CA146Accident · No injuriesData collectionFinal reportCessna 182 · Livermore, CAThe pilot's failure to maintain directional control during the landing roll with a gusting tailwind, which resulted in a runway excursion and collision with runway lights and taxiway signage.NTSB GAA19CA144Accident · No injuriesData collectionFinal reportMooney M20J · Ridgeland, SCThe flight instructor's failure to retract the flaps during an attempted go-around and his failure to maintain the runway heading, which resulted in a collision with terrain left of the runway.NTSB CEN19LA086Accident · No injuriesLimited investigationFinal reportBeech 65 · Colby, KSThe pilot’s failure to properly secure the crew hatch door before takeoff, which resulted in his distraction and his failure to maintain airplane control and airspeed.NTSB CEN19FA084Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Goshen, INThe pilot’s failure to maintain adequate altitude for undetermined reasons during a practice circling approach in dark night visual meteorological conditions, which resulted in a collision with power lines.NTSB WPR19LA087Accident · Serious injuriesClass 3 · LimitedFinal reportMD Helicopter 369 · Kukuihaele, HIThe partial loss of engine power due to corrosion in the engine bleed valve due to wash solution intrusion. Contributing to the accident was the installation of a bushing manufactured to incorrect dimensions in the bleed valve, and the uneven terrain at the…NTSB GAA19CA151Accident · No injuriesData collectionFinal reportCessna 172 · Morristown, NJThe student pilot's improper rudder input and the flight instructor's delayed remedial action during takeoff, which resulted in a loss of directional control, a runway excursion, and the landing gear collapsing.NTSB GAA19CA150Accident · No injuriesData collectionFinal reportPiper PA22 · Scappoose, ORThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and collision with taxiway signage.NTSB ERA19WA108Accident · 1 fatalForeign investigationCessna U206 · Eteringbang, GuyanaThe government of Guyana has notified the NTSB of an accident involving a CESSNA U206 airplane that occurred on February 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guyana's investigation under the provisions…NTSB ERA19TA105Accident · Minor injuriesFinal reportBeech 76 · Frankfort, KYThe pilot's failure to maintain airplane control during a simulated single-engine go-around, which resulted in a collision with terrain.NTSB ENG19IA013Incident · No injuriesIncident investigationFinal reportBoeing 737 · Orlando, FLA No. 1 (left) engine high pressure compressor stage 2 blade separation. The blade separated due to a mixed-mode fatigue crack that originated on a blade disk post and was initiated by a misaligned (out-of-schedule) high pressure compressor stage 1 variable…NTSB DCA19WA093Incident · No injuriesForeign investigationBoeing 737 · Capetown, South AfricaThe South African Civil Aviation Authority (CAA) has notified the NTSB of an incident involving a Boeing 737, which occurred on February 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation under the provisions of…NTSB CEN19LA085Accident · Serious injuriesClass 3 · LimitedFinal reportTecnam P92 · Englewood, COThe loss of engine power for undetermined reasons, because the airplane wreckage was sold and relocated before the engine could be examined.NTSB GAA19CA142Accident · No injuriesData collectionFinal reportCirrus SR22 · Tulsa, OKThe pilot's failure to maintain a stabilized approach with a tailwind and his subsequent failure to maintain yaw control during an attempted go-around.NTSB GAA19CA141Accident · No injuriesData collectionFinal reportRobinson R22 · Clearwater, FLThe flight instructor's failure to maintain sufficient altitude over uneven terrain during a hover taxi, which resulted in ground contact and a subsequent dynamic rollover.NTSB GAA19CA139Accident · No injuriesData collectionFinal reportAirbus A350 · Eureka, AKThe pilot's selection of unsuitable terrain for landing on snow-covered mountainous terrain with steep rocks above, which resulted in loose rocks damaging the main rotor blades and the subsequent loss of helicopter controllability.NTSB DCA19CA091Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Franklin, TNan encounter with convective turbulence during descent.NTSB CEN19WA083Accident · 2 fatalForeign investigationRobinson R44 · Roeldal, NorwayThe government of Norway has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on February 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the…NTSB WPR19FA084Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Ely, NVThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions and icing conditions which resulted in a high rate of descent and impact with terrain. Contributing to the accident was the inaccurate weather reporting…NTSB DCA19WA087Incident · No injuriesForeign investigationBoeing 737 · Pontianak, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving a Boeing 737, which occurred on February 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under…NTSB CEN19WA089Incident · No injuriesForeign investigationPiper PA19 · Brustem Airfield, Belgium, BelgiumThe government of Belgium has notified the NTSB of an accident involving a PIPER PA19 airplane that occurred on February 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions…NTSB WPR19LA094Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Montague, CAThe pilot’s failure to maintain directional control while landing on a wet/icy runway.NTSB GAA19CA137Accident · No injuriesData collectionFinal reportCessna 172 · Sanford, FLThe student pilot's failure maintain the proper pitch attitude during landing, which resulted in the airplane porpoising.NTSB CEN19LA091Accident · Serious injuriesClass 3 · LimitedFinal reportVan's RV-8 · Horseshoe Bay, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN19FA082Accident · 2 fatalClass 2 · FieldFinal reportCessna 421 · Canadian, TXThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions with icing conditions present, which resulted in an aerodynamic stall and spin into terrain.NTSB GAA19CA145Accident · No injuriesData collectionFinal reportPiper PA32 · Lacon, ILThe pilot's failure to maintain directional control during landing with gusting crosswind conditions, which resulted in a subsequent impact with a snowbank.NTSB WPR19WA271Accident · 5 fatalForeign investigationCessna U206G · Londiani, KenyaOn February 13, 2019, at 0729 universal coordinated time a Cessna U206G, 5Y-BSE, crashed into terrain, following a distress signal from the airplane near Londiani, Kericho County, Kenya. The pilot and four passengers were fatally injured. The airplane was…NTSB GAA19CA138Accident · No injuriesData collectionFinal reportCessna 172RG · Atlanta, GAThe pilot's failure to extend the landing gear before landing. Contributing to the accident were the pilot’s inability to see the landing gear position light because his iPad was blocking his view of it and his feeling of being rushed during the approach and…NTSB ERA19WA127Accident · 1 fatalForeign investigationCessna 210 · Belém City, State of Pará, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on February 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB DCA19WA082Incident · No injuriesForeign investigationBoeing 737 · Albania, AlbaniaThe government of Albania has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Albania's investigation under the provisions…NTSB DCA19CA081Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer ERJ170 · Reno, NVan inadvertent encounter with convective turbulence that resulted in a TCAS RA, which required an abrupt control input by the flight crew to resolve the conflict.NTSB ANC19TA014Accident · Serious injuriesClass 3Final reportPiper PA32R · Anchorage, AKThe pilot’s failure to ensure that the passenger’s lap belt was appropriately fastened for the forecast turbulent conditions, and the passenger’s failure to tighten her lap belt appropriately, which resulted in the passenger’s serious injury during an…NTSB GAA19CA140Accident · No injuriesData collectionFinal reportPiper PA24 · Slaton, TXThe student pilot's complacency, which led to his improper crosswind correction and subsequent failure to maintain directional control during the landing roll, which resulted in a runway excursion and ground collision.NTSB ERA19WA099Accident · 3 fatalForeign investigationBell 206 · Barueri County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Bell 206 helicopter that occurred on February 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB CEN19LA090Accident · No injuriesClass 2 · LimitedFinal reportBeech 400 · Richmond, INThe flight crew's decision to continue an unstable approach under conditions that exceeded the airplane's landing performance capabilities, which resulted in a runway overrun and impact with terrain.NTSB WPR19LA088Accident · No injuriesClass 3 · LimitedFinal reportLancair IV · Laramie, WYAn environmental stress cracking failure of the acrylic windshield, which resulted in a rapid decompression during cruise flight.NTSB GAA19CA143Accident · No injuriesData collectionFinal reportCessna 421 · Woodruff, WIThe pilot's failure to maintain to directional control during takeoff from a snow-covered runway with a right, quartering tailwind, which resulted in a runway excursion and impact with a snowbank.NTSB GAA19CA136Accident · No injuriesData collectionFinal reportCessna 182 · Arlington, WAThe pilot's distraction during the engine warm-up, which resulted in the airplane's collision with a hangar. Contributing to the accident was the pilot's failure to set the brakes.NTSB ERA19TA098Accident · Minor injuriesClass 3Final reportCessna 172 · Lignum, VAA total loss of engine power for undetermined reasons.NTSB DCA19WA084Incident · Minor injuriesForeign investigationBoeing 737 · Nurenburg, GermanyThe government of Germany has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions…NTSB CEN19WA081Accident · 2 fatalForeign investigationCessna 150 · Atizapán de Zaragoza, México, México, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 150H airplane that occurred on February 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB WPR19LA100Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCAA · Watsonville, CAThe pilot’s loss of airplane control during a go-around for reasons that could not be determined based on available evidence.NTSB WPR19FA083Accident · 1 fatalClass 3 · FieldFinal reportMooney M20F · Diablo, CAThe student pilot’s decision to depart on a visual flight rules flight into reduced visibility night conditions and his subsequent failure to maintain clearance from mountainous terrain, which resulted in controlled flight into terrain.NTSB GAA19CA133Accident · No injuriesData collectionFinal reportDenney Kitfox IV Speedster · Page, AZThe pilot's failure to maintain lateral control during the landing flare, which resulted in the left wing striking a tree.NTSB ERA19LA097Accident · No injuriesLimited investigationFinal reportPiper PA28 · Vero Beach, FLThe pilot's failure to use carburetor heat while operating the airplane in weather conditions and at engine power settings conducive to the formation of carburetor ice, which resulted in a loss of engine power due to carburetor icing and the subsequent forced…NTSB ERA19LA096Accident · 1 fatalLimited investigationFinal reportConvair C131 · Atlantic Ocean (Atlantic Ocean)The captain's decision to continue with the flight with a malfunctioning left engine propeller control and the subsequent loss of engine power on both engines for undetermined reasons, which resulted in ditching into the ocean. Contributing to the accident…NTSB WPR19TA085Accident · Serious injuriesClass 3Final reportPiper PA46 · Aurora, ORThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for landing during a simulated power-off approach and landing, which resulted in an aerodynamic stall and loss of control and the flight instructor’s failure to adequately…NTSB WPR19FA080Accident · 2 fatalClass 2 · FieldFinal reportCessna 172 · Desert Hot Springs, CAThe pilot's inadequate and/or improper preparation for the flight in which he selected an altitude too low to assure terrain clearance and resulted in an impact with terrain in turbulent downdraft conditions.NTSB ERA19WA101Accident · 2 fatalForeign investigationGlobe GC1A · Dom Pedrito County, BrazilThe government of Brazil has notified the NTSB of an accident involving a GLOBE GC1A airplane that occurred on February 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ENG19WA012Incident · No injuriesForeign investigationAirbus A321 · Lahore, PakistanOn February 2, 2019, a Vietnam Airlines A321-272N Neo, powered by two P&W PW1130G-JM geared fan engines experienced an No. 2 (right ) engine failure while in cruise. It was reported that a stall warning was detected followed by high vibration and an exhaust…NTSB DCA19CA075Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Bluefields, NicaraguaAn inadvertent encounter with clear air turbulence.