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 ANC19FA038Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Skwentna, AKThe pilot’s decision to depart into marginal visual flight rule conditions in mountainous terrain with the potential for icing, and the airplane’s accumulation of structural icing, which resulted in the pilot’s inability to maintain airplane control and the…NTSB CEN19LA101Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150 · Granite Shoals, TXThe pilot's decision to takeoff with a limited amount of fuel onboard, which unported during a turn, resulting in fuel starvation and a subsequent loss of engine power.NTSB CEN19FA093Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Summersville, MOThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight fuel planning and in-flight fuel monitoring.NTSB ERA19TA120Accident · Minor injuriesClass 3Final reportCirrus SR22 · Atlantic Ocean (Atlantic Ocean)A loss of oil pressure and subsequent total loss of engine power for undetermined reasons.NTSB ERA19LA119Accident · Minor injuriesClass 3 · LimitedFinal reportOstertag Walter G Velocity RG · Stateboro, GAThe pilot’s loss of airplane control while on final approach in gusty wind conditions.NTSB ERA19FA118Accident · 1 fatalClass 3 · FieldFinal reportHughes 369 · Talking Rock, GAA fatigue failure of the overrunning clutch subassembly due to abnormal bending loads due to cracks on the center engine mount, which resulted in an inflight loss of power. Contributing to the accident was the helicopter's low altitude and airspeed when the…NTSB ERA19FA116Accident · 1 fatalClass 2 · FieldFinal reportPiper PA28 · Fellsmere, FLThe student pilot's loss of control due to spatial disorientation following an encounter with instrument meteorological conditions shortly after takeoff. Contributing to the accident was the failure of both the pilot and the flight school to ensure that the…NTSB DCA19WA108Incident · No injuriesForeign investigationBoeing 767 · Halifax, CanadaThe government of Canada has notified the NTSB of an accident involving a BOEING 767 airplane that occurred on March 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB DCA19FA089Accident · Minor injuriesClass 3 · FieldFinal reportEmbraer EMB145 · Presque Isle, METhe flight crew’s decision, due to confirmation bias, to continue the descent below the decision altitude when the runway had not been positively identified. Contributing to the accident were (1) the first officer’s fatigue, which exacerbated his confirmation…NTSB CEN19WA105Accident · No injuriesForeign investigationPiper PA34 · Lagunilla, Costa RicaNTSB CEN19WA103Accident · 2 fatalForeign investigationRobinson R66 · Timmins, CYTS, CanadaThe government of Canada has notified the NTSB of an accident involving a Robinson R66 helicopter that occurred on March 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB WPR19WA164Accident · 5 fatalForeign investigationBell 505X · Londiani, Kericho, KenyaOn March 3, 2019, about 0834 local time, a Bell 505X, 5Y-KDL, collided with terrain near Londiani, Kericho, Kenya. The 1 pilot and 4 passengers were fatally injured; the helicopter was destroyed. The helicopter was owned and operated by KWAE Island…NTSB DCA19WA099Accident · No injuriesForeign investigationBeech 1900 · Ourgla, AlgeriaThe Civil Aviation Directorate (CAD) of Algeria has notified the NTSB of an accident involving a Beech 1900D, which occurred on March 3, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAD investigation under the provisions of ICAO…NTSB CEN19LA092Accident · Minor injuriesLimited investigationFinal reportBell 407 · Union Center, SDThe ambulance driver’s failure to see the helicopter’s rotating main rotor blades in dark night conditions, which resulted in the ambulance’s inadvertent collision with the helicopter. Contributing to the accident was the ambulance driver's failure to follow…NTSB GAA19CA162Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe student pilot's failure to maintain the runway heading during a go-around with a crosswind, which resulted in the left main landing gear impacting a runway sign.NTSB GAA19CA155Accident · No injuriesData collectionFinal reportChampion 8GCBC · Palmer, AKThe pilot's failure to maintain lateral control during landing, which resulted in the left ski impacting snow and a subsequent bounce and loss of directional control.NTSB ERA19TA114Accident · Serious injuriesFinal reportRempe Kitfox · Merritt Island, FLThe pilot's failure to maintain airplane control during an attempted go-around.NTSB ERA19FA113Accident · 3 fatalField investigationFinal reportCessna 182 · Louisburg, NCThe pilot's spatial disorientation and loss of airplane control following takeoff in night instrument meteorological conditions.NTSB WPR19LA092Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Melba, IDThe total loss of engine power due to a separated carburetor idle mixture adjustment screw and spring assembly for reasons that could not be determined.NTSB ERA19FA112Accident · 1 fatalClass 3 · FieldFinal reportPiper PA25 · Fort Lauderdale, FLThe pilot’s failure to maintain proper altitude and clearance while maneuvering during a banner tow flight, which resulted in an in-flight collision with a 19-story building in a heavily congested area. Contributing to the accident were the easterly wind…NTSB GAA19CA154Accident · No injuriesData collectionFinal reportDenney Kitfox MDL Classiciv · Floodwood, MNThe pilot's loss of lateral control while landing in gusting crosswind conditions, which resulted in a nose-over.NTSB ERA19TA111Accident · No injuriesFinal reportPiper PA32 · West Palm Beach (Atlantic Ocean)A total loss of engine power for reasons that could not be determined based on the available evidence, which resulted in a ditched landing in the ocean.NTSB ERA19TA110Accident · Serious injuriesClass 3Final reportSikorsky HH-60L · Tullahoma, TNThe flight crew’s improper decision to continue the VFR flight into deteriorating weather conditions, which resulted in a collision with trees during a subsequent precautionary landing attempt.NTSB ENG19WA045Incident · No injuriesForeign investigationEmbraer ERJ190 · Devon, United Kingdom, United KingdomOn February 28, 2019, an Embraer ERJ 190-200 LR powered by two General Electric CF34 10E7 turbofan engines, experienced smoke filling the cabin during the takeoff roll from Exeter International Airport, Devon, United Kingdom. The takeoff was aborted and an…NTSB CEN19FA088Accident · 2 fatalField investigationFinal reportPiper PA46 · Shreveport, LAThe pilot's conduct of a departure into instrument meteorological conditions (IMC), which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot's poor instrument flying skills and his decision…NTSB DCA19CA088Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 777 · Honolulu, HIthe airplanes encounter with clear air turbulence.NTSB CEN19LA087Accident · Serious injuriesClass 3 · LimitedFinal reportWarner Aerocraft Space Walker II · Devine, TXThe pilot’s failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB ERA19LA109Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Louisville, KYThe failure of the magnetos due to a known deficiency, which resulted in a partial loss of engine power. Contributing to the accident was maintenance personnel’s failure to comply with the applicable service bulletin.NTSB DCA19WA182Incident · No injuriesForeign investigationBoeing 737 · London, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 26, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO…NTSB GAA19CA152Accident · No injuriesData collectionFinal reportCessna 185 · Ridgeland, SCThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA148Accident · No injuriesData collectionFinal reportCessna 172 · Bellingham, WAThe pilot's improper crosswind correction during taxi operations in gusting crosswind conditions.NTSB GAA19CA149Accident · No injuriesData collectionFinal reportZenair Zenith Stol CH 701 · Springfield, ILThe pilot's improper crosswind correction during taxi operations in gusting crosswind conditions.NTSB GAA19CA153Accident · No injuriesData collectionFinal reportCessna 172 · Princeton, NJA collision with deer on the runway while landing at night and the airport's lack of a complete perimeter fence.NTSB GAA19CA147Accident · Minor injuriesData collectionFinal reportPorterfield CP 65 · Aberdeen, SDThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB ERA19WA128Accident · 2 fatalForeign investigationCessna T182 · Jacareacanga County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna T182 airplane that occurred on February 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ERA19FA107Accident · 2 fatalField investigationFinal reportCessna 172 · Mansfield, MAThe flight instructor's failure to maintain airplane control during initial climb after a touch-and-go landing, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB ERA19FA106Accident · 1 fatalClass 2 · FieldFinal reportStol UC-1 · Winter Haven, FLA total loss of left engine power for reasons that could not be determined, and the instructor's failure to maintain airspeed while maneuvering for a forced landing, which resulted in a loss of control. Contributing to the accident was the instructor's…NTSB DCA19MA086Accident · 3 fatalClass 1 · MajorFinal reportBoeing 767 · Trinity Bay, TXThe inappropriate response by the first officer as the pilot flying to an inadvertent activation of the go-around mode, which led to his spatial disorientation and nose-down control inputs that placed the airplane in a steep descent from which the crew did…NTSB WPR19FA086Accident · 3 fatalClass 3 · FieldFinal reportBeech D55 · Stallion Springs, CAThe pilot’s continued visual flight into instrument meteorological conditions associated with mountain obscuration conditions, which resulted in controlled flight into rising terrain. Contributing to the accident was the pilot’s failure to obtain a weather…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…