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 DCA13WA101Incident · No injuriesForeign investigationBoeing 777 · Shijiazhuang, ChinaOn June 4, 2013, at approximately 1435 local time, American Airlines flight 187, a B777-200, N782AN, declared mayday due to emergency fuel while on approach to Beijing Capital International Airport (ZBAA) Beijing, China. As AAL187 started its approach to…NTSB CEN13CA317Accident · No injuriesData collectionFinal reportStinson 108 · Lebanon, INThe pilot did not maintain control of the airplane during the landing roll.NTSB CEN13CA316Accident · No injuriesData collectionFinal reportSheldrick John H RV-6 · Brookfield, WIThe pilot's failure to maintain runway alignment and his failure to recognize that the airplane had drifted away from the runway prior to landing.NTSB ANC13FA054Accident · 1 fatalField investigationFinal reportDehavilland Beaver DHC-2 MK.1 · Petersburg, AKThe pilot’s failure to maintain adequate altitude above the trees, and his subsequent failure to maintain adequate airspeed while maneuvering to avoid the trees, which resulted in an inadvertent aerodynamic stall/spin and an uncontrolled descent.NTSB ERA13IA267Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Tallahassee, FLThe failure of the elevator trim cable due to fatigue cracking, which resulted from maintenance personnel’s repeated inadequate inspection of the cable.NTSB ERA13CA278Accident · No injuriesData collectionFinal reportPiper PA-46-500TP · West Palm Beach, FLThe pilot’s diversion of attention while taxiing the airplane, which resulted in his failure to maintain directional control and collision with a ditch.NTSB CEN13CA315Accident · No injuriesData collectionFinal reportCub Crafters CCK · Cookson, OKA total loss of engine power due to water contamination in the fuel. Contributing to the accident was the pilot's failure to check the fuel during the preflight, and failure to check the fuel storage tank’s fuel filter/water separator.NTSB CEN13CA312Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lansing, ILImproper control inputs by the pilot-receiving-instruction and the inability of the flight instructor to correct the control inputs in sufficient time to avoid the hard landing.NTSB WPR13CA257Accident · Serious injuriesData collectionFinal reportCessna 182P · Bridgeport, CAThe pilot's distracted attention while on final approach which resulted in his failure to maintain adequate airspeed and subsequent loss of aircraft control.NTSB ERA13WA296Accident · 1 fatalForeign investigationExtra Flugzeugbau EA-330SC · Bolshoye Gryzlovo, RussiaNTSB CEN13WA392Accident · 6 fatalForeign investigationCessna T210 · Ixchiguan, GuatemalaOn June 28, 2013, at 1330 coordinated universal time, a Cessna T210N, Mexican registration XB-MSN, owned by a private individual, was destroyed when it impacted terrain under unknown circumstances near Ixchiguan, Guatemala. The pilot and five passengers were…NTSB CEN13CA336Accident · Minor injuriesData collectionFinal reportSchempp-Hirth VENTUS-2B · Corona, NMThe pilot's failure to maintain aircraft control while ridge-soaring in gusty wind conditions.NTSB WPR13CA261Accident · No injuriesData collectionFinal reportBeech A23-24 · La Grande, ORThe pilot’s failure to maintain airplane control and the flight instructors failure to monitor the pilot during a simulated emergency landing.NTSB WPR13CA260Accident · No injuriesData collectionFinal reportWampach Murphy Moose · Galt, CAThe pilot's improper landing flare, which resulted in an abnormal runway contact.NTSB WPR13CA256Accident · No injuriesData collectionFinal reportCub Crafters CC11-100 · Payson, AZThe pilot’s failure to maintain aircraft control during the landing flare with a quartering tailwind.NTSB ERA13LA268Accident · Minor injuriesLimited investigationFinal reportMaule M-4-220C · Fredericksburg, PAA total loss of engine power due to the fatigue failure of the No. 4 cylinder piston pin.NTSB ERA13LA264Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Williamson, SCThe pilot’s decision to takeoff with a quartering tailwind at high density altitude, close to gross takeoff weight, on a short turf runway with trees at the departure end.NTSB ERA13LA263Accident · 1 fatalLimited investigationFinal reportWilson William M Cricket MC12 · Doylestown, PAThe pilot's failure to abort the takeoff after detecting the airplane’s degraded performance. Contributing to the accident were the likely loss of power from the left engine for reasons that could not be determined during the postaccident examination of the…NTSB CEN13WA311Accident · 1 fatalForeign investigationSaab 91C · Söderhamn, SwedenOn June 1, 2013, at 1215 universal coordinated time, a SAAB model 91C (Safir) airplane, Swedish registration SE-KVC, collided with terrain shortly after takeoff from the Söderhamn Airport (ESNY), near Söderhamn, Sweden. A postimpact fire destroyed the…NTSB CEN13LA330Accident · No injuriesLimited investigationFinal reportCessna TP206B · Sturgeon Bay, WIThe pilot’s improper reselection of the left fuel tank, which had an obstructed vent system and resulted in a total loss of engine power during the approach for landing.NTSB CEN13LA323Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Hamlin, TXThe pilot's decision to land the airplane with a crosswind that exceeded the airplane's capabilities.NTSB WPR13FA254Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Anthem, AZThe failure of the pilots in both aircraft to maintain adequate visual lookout in a known training area where multiple aircraft frequently operated, which resulted in a midair collision.NTSB WPR13CA255Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Martin, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR13CA252Accident · Minor injuriesData collectionFinal reportCessna 172A · Eatonville, WAA partial loss of engine power due to carburetor icing and the pilot's failure to maintain adequate airspeed during a go-around, which resulted in a stall.NTSB ERA13TA261Accident · No injuriesFinal reportBell 407 · Columbia, MDThe short circuit failure of a tantalum capacitor, internal to the engine’s electronic control unit, resulting in an uncommanded shutdown of the engine in flight.NTSB ERA13LA258Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Herndon, VAThe pilot’s inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB ERA13FA259Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Linden, NJThe flight instructor's inadequate preflight planning and his decision to take off with the airplane at a high gross weight in high temperature conditions that degraded the engine’s available power and his subsequent failure to maintain airspeed while…NTSB ERA13CA280Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Hollywood, FLThe pilot's failure to maintain directional control during the landing roll.NTSB ERA13CA266Accident · No injuriesData collectionFinal reportCessna 172L · Millinocket, METhe student pilot’s failure to maintain directional control during landing.NTSB ERA13CA265Accident · No injuriesData collectionFinal reportCessna 180 · Concord, NHThe pilot’s delayed remedial action following a loss of directional control during the landing roll.NTSB DCA13WA103Incident · No injuriesForeign investigationBoeing 737-800 · Eindhoven, NetherlandsThe Dutch Safety Board (DSB), has notified the NTSB of an incident involving a Boeing 737-800 that occurred on May 31, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the DSB investigation under the provisions of ICAO Annex 13 as the…NTSB CEN13WA320Accident · 2 fatalForeign investigationBeech 3N · Cochenour, CanadaOn May 30, 2013, at 2218 central daylight time, a Beech 3N (BE-18), Canadian registration C-FWWV, collided with the water on takeoff from Red Lake, Cochenour, Ontario, Canada. The airplane was registered to First Air Service and operated by a private…NTSB CEN13WA309Accident · 4 fatalForeign investigationSikorsky 76A · Moosonee, CanadaOn May 13, 2013, about 0015 EDT, a Sikorsky S-76A, Helicopter, C-GIMY, impacted terrain after departing the Moosonee Airport (CYMO), Moosonee, Ontario. The two pilots and two medical crew were fatality injured in the accident. The accident investigation is…NTSB ANC13CA052Accident · No injuriesData collectionFinal reportCessna U206A · Fairbanks, AKThe pilot’s inadequate flare, which resulted in a nose-low impact with glassy water and a subsequent nose-over.NTSB ERA13LA262Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Brevard, NCThe cylinder manufacturer's misalignment of the exhaust valve guides in the No. 2 cylinder during manufacture, which resulted in the exhaust valve sticking and the pushrod breaking and the subsequent total loss of engine power.NTSB ERA13CA260Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Ellenville, NYThe student pilot's inadequate preflight planning and failure to maintain clearance from rising terrain, which resulted in controlled flight into terrain.NTSB CEN13WA405Accident · 1 fatalForeign investigationPiper PA-32R-301T · Lagunillas, MexicoNTSB CEN13LA308Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar Plus · Elyria, OHThe failure of the canopy latch spring, which caused the canopy to open during initial climb. Contributing to the accident was the installation of an improper part in the canopy latch assembly, which led to the failure of the canopy latch spring.NTSB ANC13CA053Accident · No injuriesData collectionFinal reportCessna U206G · King Salmon, AKThe pilot's inadequate airspeed control during a glassy water landing, which resulted in an excessive sink rate, and a hard landing.NTSB CEN13WA307Accident · 1 fatalForeign investigationPiper PA-28RT-201T · Tallard, FranceNTSB ANC13WA051Accident · 2 fatalForeign investigationBell 206B · Fort McMurray, CanadaOn May 29, 2013, about 1110 mountain daylight time, a Canadian registered Bell 206B helicopter, C-FZWB, crashed approximately 75 nautical miles north of Ft. McMurray, Alberta, Canada. The helicopter was owned and operated by Aurora Helicopters Ltd., doing…NTSB WPR13FA244Accident · 2 fatalField investigationFinal reportRaytheon A36 · Mountainaire, AZThe pilot's inability to maintain a climb after departure in high-density altitude conditions, which resulted in a collision with trees and terrain. Contributing to the accident were the pilot's decision not to track the four-lane highway just beyond the…NTSB WPR13CA245Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Page, AZA loss of engine power during cruise flight due to fuel exhaustion. Contributing to the accident was the pilot's improper fuel planning.NTSB ANC13CA050Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Napakiak, AKThe student pilot's improper flare, which resulted in a hard landing, and the flight instructor's inadequate supervision of the student.NTSB ERA13FA256Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Macon, GAA total loss of engine power due to oil starvation for reasons that could not be determined due to extensive postcrash fire and heat damage to the engine components.NTSB CEN13WA301Accident · 1 fatalForeign investigationPiper PA-39 · Wolfsbehringen, GermanyNTSB WPR13FA243Accident · Minor injuriesField investigationFinal reportHiller UH-12E · Wenatchee, WAFatigue failure of the six bolts that secured the bevel gear to the first stage planetary carrier, which caused the transmission to seize while the helicopter and main rotor were still operating.NTSB WPR13CA259Accident · No injuriesData collectionFinal reportDressen Escape LS · Fruitland, IDThe pilot’s failure to maintain airplane control during the landing roll as a result of the parking brake lever not being positioned in the full off position.NTSB WPR13CA249Accident · No injuriesData collectionFinal reportBeech V35B · Kernville, CAThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions.NTSB ERA13LA254Accident · Serious injuriesLimited investigationFinal reportFleming Eldridge E Sonex · Naples, FLThe pilot’s failure to maintain airspeed during a forced landing, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of the noncertificated engine’s power for reasons that could not be determined because examination of the…