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 DCA18WA156Incident · No injuriesForeign investigationBoeing 767 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a BOEING 767 airplane that occurred on March 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB WPR18FA112Accident · 1 fatalField investigationFinal reportMooney M20E · Marina, CAThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall/spin.NTSB GAA18CA180Accident · Minor injuriesData collectionFinal reportAnderson Darrell L Starduster TOO · Tucson, AZThe failure of the left main landing gear axle weld during the landing roll.NTSB GAA18CA179Accident · No injuriesData collectionFinal reportLynn Perry Cavalon · Haverhill, NHThe pilot's failure to maintain directional control during a rejected takeoff. Contributing to the accident was the binding of the control stick, for an undetermined reason, which precipitated the rejected takeoff.NTSB ERA18FA114Accident · 2 fatalField investigationFinal reportBeech V35 · Hydro, OKThe pilot's decision to continue the night visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot's lack of instrument/night currency, and his failure…NTSB ANC18LA030Accident · No injuriesLimited investigationFinal reportChampion 7GC · Anchorage, AKThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a loss of control and failure of the main landing gear. Contributing to the accident was the pilot's self-induced pressure to land.NTSB CEN18WA135Accident · No injuriesForeign investigationRotorway Exec · Koblenz-Winningen, GermanyThe government of Germany has notified the NTSB of an accident involving an amateur-built ROTORWAY EXEC helicopter that occurred on March 25, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation…NTSB CEN18LA127Accident · Minor injuriesLimited investigationFinal reportMX MXS · Fulton, TXA total loss of engine power due to the fatigue failure of the crankshaft, which resulted in the pilot’s forced landing to an abandoned airport and the airplane’s subsequent impact with debris on the runway.NTSB ERA18LA116Accident · Minor injuriesClass 3 · LimitedFinal reportLindstrand Balloons 105A · Wesley Chapel, FLThe pilot's failure to maintain adequate clearance from powerlines during landing approach, which resulted in an inflight collision with the powerlines.NTSB CEN18WA130Accident · 2 fatalForeign investigationMaule M 7-235 · Arosa, SwitzerlandNTSB GAA18CA229Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Farmingdale, NYThe student pilot’s rapid lowering of the collective, which resulted in a hard landing.NTSB GAA18CA178Accident · No injuriesData collectionFinal reportFlightworks Capella XS FW2C80TD · Hartselle, ALThe pilot's failure to maintain directional control during the landing roll.NTSB GAA18CA175Accident · Minor injuriesData collectionFinal reportCessna 172 · Beaver Falls, PAThe student pilot’s failure to maintain directional control during the landing roll.NTSB ERA18LA115Accident · No injuriesLimited investigationFinal reportCessna 180K · Canton, MSThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion. Contributing to the pilot's decision to land with a tailwind was a partial loss of engine power due to his failure to effectively use carburetor heat in conditions…NTSB ERA18LA113Accident · No injuriesLimited investigationFinal reportFairchild Funk M62C F 23A · Columbia, TNThe pilot's inadvertent selection of the fuel selector handle to the off position, which resulted in fuel starvation and a total loss of engine power.NTSB DCA18WA317Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Budapest, HungaryNTSB CEN18LA128Accident · No injuriesLimited investigationFinal reportCessna 310R · Kansas City, MOThe landing gear collapse due to the separation of the end fitting bolt for reasons that could not be determined based on the available evidence.NTSB CEN18LA123Accident · 1 fatalLimited investigationFinal reportMills Michael S1L · Dewitt, MIThe pilot's failure to see and avoid power lines due to sun glare.NTSB WPR18WA110Accident · 2 fatalForeign investigationEurocopter EC120 · Hardy Reef, Queensland, AustraliaOn March 21, 2018, about 1500 local time, a Eurocopter (Airbus Helicopters) EC120B helicopter, VH-WII, sustained substantial damage when it impacted water during an aborted landing attempt on a floating helicopter landing site (HLS) located between Hardy Reef…NTSB GAA18CA195Accident · No injuriesData collectionFinal reportPiper PA24 · Knox, INThe flight instructor’s improper landing flare, which resulted in a hard landing.NTSB ERA18LA112Accident · Serious injuriesClass 3 · LimitedFinal reportGulfstream Aerospace G V · Miami, FLThe passengers' failure to comply with the fasten seatbelt sign, with resulted in their injury during an inflight turbulence encounter.NTSB CEN18LA125Accident · Minor injuriesLimited investigationFinal reportCub Crafters PA18 150 · Beggs, OKThe pilot's failure to verify that the fuel selector was properly set before takeoff, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN18FA126Accident · 1 fatalField investigationFinal reportRans S-16 Shekari · Pierce, NEThe pilot's failure to maintain airspeed during the approach for landing, which resulted in an aerodynamic stall and the airplane's impact with terrain.NTSB ANC18LA027Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC 6 Twin Otter · Arctic OceanThe flight crew's improper decision to deliberately operate the airplane at low altitude and along a flightpath that resulted in a collision with a pedestrian after takeoff. Contributing to the accident was the pedestrian's proximity to the runway.NTSB WPR18LA111Accident · No injuriesLimited investigationFinal reportPflugradt Kitfox · Clatskanie, ORA partial loss of engine power due to an improperly secured throttle cable set screw.NTSB GAA18CA173Accident · No injuriesData collectionFinal reportCessna 182 · Rapid City, SDThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control and runway excursion.NTSB GAA18CA172Accident · No injuriesData collectionFinal reportLithuanian Factory Of LAK 12 · Sunriver, ORThe glider pilot's inadequate flight planning, which resulted in an off-airport landing.NTSB WPR18WA115Accident · No injuriesForeign investigationRobinson R22 · Bloemfontein, South AfricaNTSB GAA18CA170Accident · No injuriesData collectionFinal reportCessna 172 · Vernon, TXThe pilot's failure to maintain directional control while landing in gusty crosswind conditions.NTSB WPR18LA107Accident · Serious injuriesLimited investigationFinal reportCubcrafters CC11-160 · Browns Valley, CAThe pilot’s failure to adequately monitor the environment and maintain a sufficient altitude to avoid power lines.NTSB GAA18CA176Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Ontario, ORThe flight instructor's failure to maintain directional control during landing, in cross wind conditions.NTSB ERA18LA110Accident · Minor injuriesLimited investigationFinal reportBesarick Skybolt · Punta Gorda, FLA substantial oil leak, which resulted in a partial loss of engine power and failure of the No. 2 connecting rod.NTSB GAA18CA169Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Mammoth Lakes, CAThe pilot’s failure to maintain directional control during the landing roll in a gusting crosswind conditions, which exceeded the airplane’s maximum demonstrated crosswind and resulted in the collapse of the left main landing gear.NTSB GAA18CA167Accident · No injuriesData collectionFinal reportBeech C99 · Hastings, NEThe pilot's decision to land in a gusty crosswind that exceeded the airplane's maximum demonstrated crosswind and resulted in a runway excursion.NTSB ERA18LA111Accident · No injuriesLimited investigationFinal reportCessna 210 · Shelburne, VTThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA18LA109Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Palatka, FLBoth pilots’ and the flight instructor’s failure to identify, see, and avoid the other airplane, which resulted in a midair collision.NTSB ERA18LA107Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Key West, FLA partial loss of engine power during initial climb for reasons that could not be determined because examination of the wreckage did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.NTSB GAA18CA197Accident · No injuriesData collectionFinal reportPiper PA28 · Cedar Key, FLThe pilot’s unstabilized approach, which resulted in a long landing and subsequent runway overrun.NTSB GAA18CA168Accident · Minor injuriesData collectionFinal reportHughes 269 · San Antonio, TXThe pilot’s decision to relinquish the helicopter flight controls to a non-rated passenger during a 3 ft hover.NTSB CEN18LA124Accident · Serious injuriesLimited investigationFinal reportWhite Thorpe T 18 · Cleburne, TXThe loss of engine power due to fuel exhaustion.NTSB GAA18CA162Accident · Minor injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Punta Gorda, FLA collision with a large bird during approach.NTSB ERA18LA103Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Orlando, FLThe improper adjustment of the fuel pump by maintenance personnel, which resulted in an overly rich fuel/air mixture and a total loss of engine power.NTSB ERA18LA101Accident · No injuriesLimited investigationFinal reportPiper PA28 · Chesapeake, VAThe pilot's failure to apply carburetor heat during the approach for a touch-and-go landing, which resulted in a total loss of engine power during the subsequent takeoff.NTSB GAA18CA177Accident · No injuriesData collectionFinal reportCessna 152 · Snohomish, WAThe pilot’s decision to land with a tailwind and in his failure to maintain pitch control of the airplane in gusting wind conditions.NTSB GAA18CA166Accident · No injuriesData collectionFinal reportCessna 140 · Madison, SDThe flight instructor’s delayed aborted takeoff on a soft, wet, grass runway, which resulted in a runway overrun.NTSB GAA18CA161Accident · No injuriesData collectionFinal reportCessna 172 · Green Valley, AZThe pilot’s failure to maintain directional control of the airplane during landing with a tailwind.NTSB GAA18CA157Accident · No injuriesData collectionFinal reportCessna 182 · Rockford, ILThe pilot’s unnecessary action during the approach, which resulted in a hard landing.NTSB WPR18LA109Accident · Minor injuriesClass 3 · LimitedFinal reportLyons Robert Navajo HKS · Arlington, WAThe pilot's loss of directional control during landing. Contributing to the accident was the pilot's failure to attain a proper touchdown point, which required his use of heavy braking to stop on the remaining runway and exacerbated the uneven braking…NTSB WPR18LA105Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28-180 · Montague, CAImpact with powerlines and terrain after takeoff for reasons that could not be determined based on the available information.NTSB WPR18FA104Accident · 1 fatalField investigationFinal reportPiper PA 18-150 · La Center, WAThe pilot's failure to maintain clearance from trees while maneuvering at a low altitude.