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 ERA18TA144Accident · Serious injuriesFinal reportChristopher Lord ELA 07 Scorpion · Sebring, FLThe pilot's failure to slow the gyroplane and maintain control while exiting the runway.NTSB ERA18LA145Accident · No injuriesLimited investigationFinal reportPiper PA28 · Vero Beach, FLWater contamination of the fuel supply, which resulted in a total loss of engine power.NTSB DCA18CA169Accident · No injuriesData collectionFinal reportBoeing 737-8H4 · Baltimore, MDThe maintenance truck driver's failure to give way to the airplane that resulted in the truck colliding with the taxiing aircraft.NTSB CEN18LA162Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Broomfield, COThe overstress fracture of the upper link of the nose landing gear torque link assembly, which resulted in the pilot’s inability to maintain directional control during landing.NTSB GAA18CA304Accident · No injuriesData collectionFinal reportBeech 58 · Gainesville, GAThe pilot’s failure to maintain a proper landing flare in gusting crosswind conditions.NTSB GAA18CA260Accident · No injuriesData collectionFinal reportCessna 182 · Clarksville, TNThe pilot’s decision to land with a tailwind in variable crosswind and downdraft and updraft conditions on a wet runway, which resulted in a runway overrun.NTSB GAA18CA257Accident · No injuriesData collectionFinal reportAeronca 7AC · Warrenton, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall.NTSB ERA18TA142Accident · Minor injuriesFinal reportBarry Maggio Apollo AG-1 · Smith Beach, VAThe noninstrument-rated pilot's inadequate preflight and in-flight weather planning, which resulted in an off-airport precautionary landing to avoid weather and a subsequent collision with power lines.NTSB ANC18LA034Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman TBM-3 · Fort Apache, AZA partial loss of engine power for reasons that could not be determined based on the available information.NTSB GAA18CA284Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · Bayou La Batre, ALThe pilot’s improper planning for landing on a wet grass airstrip, which resulted in a runway overrun.NTSB GAA18CA277Accident · No injuriesData collectionFinal reportCessna 162 · Waterloo, INThe pilot’s improper landing flare during a soft-field landing and his use of an improper soft-field landing procedure, which resulted in a bounced landing.NTSB GAA18CA273Accident · Minor injuriesData collectionFinal reportChristopher Lord ELA Eclipse 10 · Calhoun, GAThe student pilot’s failure to maintain sufficient airspeed, which resulted in a loss of altitude and necessitated a sudden descent to unsuitable terrain.NTSB GAA18CA268Accident · No injuriesData collectionFinal reportPiper PA 15 · Fulton, NYThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA267Accident · No injuriesData collectionFinal reportCessna 172 · Fulton, NYThe student pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB GAA18CA263Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1 26 · Springfield, VTThe pilot’s inability to maintain sufficient altitude after the glider encountered downdrafts during the approach, which resulted in the glider striking trees.NTSB GAA18CA259Accident · Minor injuriesData collectionFinal reportCreech Jerry Creech Jerry CH 701 · Lusby, MDThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.NTSB GAA18CA256Accident · No injuriesData collectionFinal reportCessna A185 · Chandler, AZThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.NTSB GAA18CA255Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Dekalb, ILThe pilot’s improper landing flare during gusting wind conditions, and the flight instructor’s delayed remedial action.NTSB GAA18CA254Accident · No injuriesData collectionFinal reportBeech 58 · Sisters, ORThe pilot’s failure to maintain sufficient altitude during approach in gusting crosswind conditions, which resulted in an attempted rejected landing and a runway undershoot.NTSB ERA18FA141Accident · 1 fatalField investigationFinal reportAeronca 7AC · Middletown, NYThe pilot's exceedance of the airplane's critical angle of attack during climbout, which resulted in an aerodynamic stall from which the pilot could not recover.NTSB DCA18WA174Incident · No injuriesForeign investigationBoeing 737 · Arequipa, PeruThe government of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on May 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of ICAO…NTSB CEN18LA159Accident · No injuriesLimited investigationFinal reportBeech A36 · Shullsburg, WIA catastrophic engine failure due to improper torque on the engine through-bolt nuts, which resulted in relative movement between the crankcase halves, damage to a main journal bearing, and a loss of oil lubrication.NTSB CEN18FA160Accident · 2 fatalField investigationFinal reportBelair Raven · Sault Ste Marie, MIThe pilot's failure to maintain adequate airspeed during takeoff in gusty crosswind conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB WPR18LA135Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 152 · Tamiami, FLThe non-instrument-rated pilot’s loss of control during an encounter with instrument meteorological conditions at night. Contributing to the accident was the pilot's decision to depart on the flight without obtaining approval to fly at night in accordance…NTSB GAA18CA265Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Truman, ARThe pilot’s failure to see and avoid a pole during an agricultural application flight.NTSB GAA18CA253Accident · No injuriesData collectionFinal reportCessna 172 · Glendale, AZThe student pilot’s failure to maintain runway alignment during takeoff, which resulted in an aborted takeoff and runway excursion.NTSB ERA18WA166Accident · No injuriesForeign investigationPZL Swidnik SW4 · Curitibanos, BrazilThe government of Brazil has notified the NTSB of an accident involving a PZL Swidnik, SW4, helicopter that occurred on May 4, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB ERA18WA143Accident · 3 fatalForeign investigationCessna U206F · Trelawny, JamaicaThe government of Jamaica has notified the NTSB of an accident involving a CESSNA U206F airplane that occurred on May 04, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Jamaica's investigation under the provisions of…NTSB DCA18WA180Incident · No injuriesForeign investigationBoeing 737 · Port Elizabeth, South AfricaThe Civil Aviation Authority (CAA) of South Africa has informed the NTSB of an incident involving a Boeing 737-300, which occurred on May 4, 2018. The NTSB has appointed a U.S Accredited Representative to assist the CAA investigation under the provisions of…NTSB CEN18LA158Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · East Troy, WIA partial loss of engine power for reasons that could not be determined based on the available information, which resulted in impact with terrain and dynamic rollover during the subsequent attempted landing.NTSB GAA18CA258Accident · No injuriesData collectionFinal reportBerger Bernard M Pulsar Series III · Palmyra, PAThe pilot’s failure to maintain an appropriate approach speed, which resulted in a bounced landing and a runway overrun.NTSB DCA18WA173Incident · No injuriesForeign investigationBoeing 767 323 · Guayaquil, EcuadorThe government of Ecuador has notified the NTSB of an incident involving a BOEING 767 323 airplane that occurred on May 03, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…NTSB WPR18LA130Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Portland, ORA hard landing for reasons that could not be determined based on the available information.NTSB WPR18FA131Accident · 1 fatalField investigationFinal reportAmerican Air Racing Thunder Mustang · Reno, NVThe pilot's failure to properly secure the engine coolant pump pulley during recent maintenance, which resulted in a loss of the engine's lubrication, cooling, and propeller control systems, and a forced landing, during which the airplane nosed over.…NTSB GAA18CA347Accident · No injuriesData collectionFinal reportPiper PA28 · Pine Spring, TXThe pilot’s failure to maintain adequate altitude while flying over mountainous terrain in turbulent wind conditions at night, which resulted in a tree strike.NTSB GAA18CA250Accident · Minor injuriesData collectionFinal reportMichael R Alexander Mosquito XE · Iron Station, NCThe noncertificated pilot’s decision to practice hovering the helicopter in a confined space, which resulted in the tail rotor striking a tree.NTSB GAA18CA248Accident · Minor injuriesData collectionFinal reportCessna 172 · Port Angeles, WAThe pilot’s exceedance of the airplane’s critical angle of attack during a turn away from terrain, which resulted in an accelerated stall. Contributing to the accident was the pilot’s decision to delay the turn to avoid terrain.NTSB ERA18WA139Accident · 2 fatalForeign investigationAgusta Bell AB206B · Cacao, French GuianaThe government of France has notified the NTSB of an accident involving a Agusta Bell AB206B helicopter that occurred on May 2, 2018 near Cacao, French Guiana. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's…NTSB ERA18LA140Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Panama City, FLThe pilot's failure to properly remove and secure the tie-down ropes during the preflight inspection, which resulted in the ropes becoming entangled in the rotor head swashplate and pitch control rods during flight and the subsequent loss of pitch control.NTSB ERA18FA138Accident · 1 fatalField investigationFinal reportPiper PA32 · West Milford, NJAn in-flight fire and total loss of engine power after takeoff due to a loose fuel line. Contributing to the accident was the installation of an unapproved fuel line by unknown personnel.NTSB DCA18WA171Incident · No injuriesForeign investigationBoeing 737 · Bangkok, ThailandThe Air Accident Investigation Committee of Thailand has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on May 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Thailand's…NTSB CEN18WA253Incident · No injuriesForeign investigationBeech 400 · Geneva, SwitzerlandOn May 2, 2018, about 1035 Universal Coordinated Time, a Beech 400, United Kingdom registration G-FXAR, experienced a cabin depressurization event and landed without further incident at the Geneva International Airport (LSGG), Geneva, Switzerland. There were…NTSB CEN18LA157Accident · Minor injuriesLimited investigationFinal reportHartline J Bon Hartline Kitfox III · Marathon, TXThe failure of the flaperon hinge attachment point during takeoff, which resulted in a loss of airplane control. Contributing to the accident was the lack of reinforcement of the hinge attachment point in accordance with the manufacturer’s service bulletin.NTSB CEN18LA156Accident · No injuriesLimited investigationFinal reportLaminar Lancair 360 · Woodward, OKThe pilot-rated passenger’s inadvertent contact with and closure of the emergency fuel shutoff valve, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's lack of experience in the accident…NTSB WPR18WA160Accident · 2 fatalForeign investigationRobinson Helicopter R44 II · Mabula, South AfricaOn May 1, 2018, at 0940 Universal Coordinated Time, a Robinson R44 Raven II helicopter, ZS-MZS, impacted an open field for unknown reasons near Mabula, South Africa. The pilot and one passenger were fatally injured. The helicopter was destroyed. The…NTSB WPR18LA132Accident · Minor injuriesLimited investigationFinal reportCosmos Phase III · Fernandina Beach, FLThe student pilot's failure to maintain aircraft control and the flight instructor’s failure to adequately monitor the student pilot before aircraft control was lost at a low altitude.NTSB DCA18CA165Accident · No injuriesData collectionFinal reportBombardier CL600 2D24 · Queens, NYthe failure of the captain of Delta 212 to ensure adequate clearance while taxiing behind Endeavor 3413.NTSB WPR18LA133Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Borrego Springs, CAThe loss of the helicopter’s drive system for reasons that could not be determined from the available evidence, which led to an autorotation that resulted in a hard landing and rollover on uneven sandy terrain.NTSB GAA18CA294Accident · No injuriesData collectionFinal reportCessna 172 · Palo Alto, CAThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA252Accident · No injuriesData collectionFinal reportBeech 95B55 · Little Rock, ARThe pilot’s improper landing flare.