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 CEN13WA470Incident · No injuriesForeign investigationGeneva, SwitzerlandOn May 26, 2013, at 1043 coordinated universal time, an Airbus A319, United Kingdom registered G-EZAU, a Boeing 737, German registered D-ABKB, and a Boeing 737, United Kingdom registered G-TAWF, came in close proximity near Geneva, Switzerland. Visual…NTSB WPR13CA242Accident · No injuriesData collectionFinal reportCessna 182R · Alpine, WYThe pilot’s inadequate flare and loss of aircraft control during landing.NTSB ERA13CA277Accident · Minor injuriesData collectionFinal reportBoswell John J AIR CAM 912S · West Palm Beach, FLThe pilot's failure to maintain directional control of the airplane during takeoff.NTSB ERA13CA255Accident · Minor injuriesData collectionFinal reportFlightstar Sportplanes Flightstar II · York, SCThe pilot’s failure to maintain aircraft control while landing in gusty wind conditions.NTSB ENG13WA030Incident · No injuriesForeign investigationBoeing 777 · Moscow, RussiaOn May 25, 2013, at about 0810 UTC, a Russian-operated Transaero Boeing 777, during the climb after takeoff from Vnukovo-Moscow, had the No. 1 engine, a Pratt & Whitney PW4090, have increasing exhaust gas temperature and vibrations that was followed by an…NTSB CEN13CA319Accident · No injuriesData collectionFinal reportCessna TR182 · Emporia, KSThe pilot's failure to lower the landing gear prior to landing.NTSB WPR13LA248Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Wheatland, WYA loss of engine power due to fuel exhaustion and the pilot's inadequate fuel planning.NTSB ERA13FA253Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Johnstown, NYThe pilot's loss of control due to spatial disorientation in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations, and a subsequent in-flight breakup.NTSB ENG13WA029Incident · No injuriesForeign investigationAirbus A319 · London, United KingdomAn Airbus A319-131, registration number G-EUOE, during departure from London-Heathrow International Airport, had the engine cowls from both International Aero Engines V2500 engines separate and fall on to the runway. The pilots declared a PAN and reported…NTSB CEN13LA378Accident · No injuriesLimited investigationFinal reportBell 206B · St Louis, MOThe loss of engine power due to the separation of compressor blades, which resulted from fatigue cracking.NTSB CEN13FA295Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 II · Cross Timbers, MOThe pilot's failure to see and avoid a power line during the low-altitude flight.NTSB WPR13LA251Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Truckee, CAThe pilot's failure to lean the fuel mixture during takeoff in high-density altitude conditions, which resulted in a loss of engine power.NTSB WPR13CA241Accident · No injuriesData collectionFinal reportCessna 172M · Truckee, CAThe pilot’s failure to maintain directional control during the landing roll which resulted in a collision with a tree.NTSB ERA13LA257Accident · No injuriesLimited investigationFinal reportCessna 180J · Greenwood, MSA partial loss of engine power due to carburetor icing.NTSB ERA13LA252Accident · No injuriesLimited investigationFinal reportBeech A36 · Atlanta, GAThe pilot's inadequate preflight planning, which resulted in the airplane being loaded in excess of its maximum gross weight at an aft center of gravity for a takeoff with a quartering tailwind and high-density altitude conditions, all of which degraded the…NTSB ENG13WA028Incident · No injuriesForeign investigationSikorsky S-76C · United Kingdom, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Sikorsky S-76C. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of ICAO Annex 13…NTSB CEN13WA300Accident · 3 fatalForeign investigationPiper PA-34 · Babia Gora, PolandOn May 23, 2013, at 0613 UTC, a Piper PA-34-200T, Polish registration SP-HIN, was destroyed when it impacted Babia Gora Mountain, elevation 5,659 feet, near Krakow, Poland. A post impact fire ensued. The pilot and two passengers on board the airplane were…NTSB CEN13LA305Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Beaumont, TXThe lack of a forward clamp on the carburetor heat box rubber boot, which allowed the boot to be ingested into the inlet of the carburetor heat box, restricting the airflow and leading to a subsequent partial loss of engine power.NTSB CEN13LA293Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Longview, TXThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate preflight planning, which precluded him from locating his intended destination and led to fuel…NTSB CEN13CA306Accident · No injuriesData collectionFinal reportCessna 170B · Danville, INThe pilot not maintaining directional control of the airplane during the landing roll resulting in the ground loop.NTSB ERA13WA403Accident · No injuriesForeign investigationCessna A188B · Dajabon, Dominican RepublicOn May 22, 2013, about 0745 universal coordinated time, a Cessna A188B, Dominican Republic registration HI 912, operated by Agriasa, was substantially damaged during a forced landing following loss of engine power near La Cangrejeria, Dajabon, Dominican…NTSB DCA13WA097Incident · No injuriesForeign investigationPanama City, PanamaThe Accident Investigation Unit (UPIA) of Panamá has notified the NTSB of an incident involving a B737-700 that occurred on May 22, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the UPIA investigation under the provisions of ICAO…NTSB CEN13LA298Accident · No injuriesLimited investigationFinal reportAllen Jan A Challenger II · Greeley, COThe loss of engine power due to the engine seizure, which resulted from damage caused by the ingestion of carburetor ice into the engine intake ports.NTSB CEN13LA291Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Englewood, COThe in-flight separation of the engine throttle lever and throttle cable due to maintenance personnel not applying sufficient torque to the self-locking nut or improperly reusing a degraded self-locking nut.NTSB CEN13CA292Accident · No injuriesData collectionFinal reportCessna 162 · Erie, COThe pilot’s total lack of experience in aircraft make/model, and his failure to maintain directional control during landing. Contributing to the accident was the operator’s lack of oversight is allowing the airplane to be rented to the pilot.NTSB CEN13IA355Incident · No injuriesIncident investigationFinal reportRockwell International 114 · Lapeer, MIThe malfunction of the pilot’s seat-latching mechanism due to a bent rod, which allowed the seat to come loose and slide full aft and resulted in a temporary loss of airplane control.NTSB WPR13LA237Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Chandler, AZThe failure of the alternator and/or battery, which prevented the operation of the landing gear extension system and resulted in the nose landing gear collapsing during the landing roll.NTSB WPR13FA236Accident · 2 fatalField investigationFinal reportCessna 170B · Auburn, CAThe pilot's failure to maintain airplane control during approach to landing, which resulted in an inadvertent stall and subsequent spin.NTSB WPR13CA240Accident · No injuriesData collectionFinal reportGlobe GC-1B · Tucson, AZThe pilot's failure to lower the landing gear prior to touchdown.NTSB ERA13WA274Accident · 1 fatalForeign investigationPitts S-2B · Adana, TürkiyeOn May 19, 2013, at 1015 Universal Coordinated Time (UTC), a Pitts S-2B, Turkish registration TC-AYT, operated by a private owner, was destroyed following a collision with terrain during aerobatic flight near Adana, Turkey. The pilot was fatally injured. The…NTSB ENG13IA027Incident · No injuriesIncident investigationFinal reportBoeing 747 · Atlanta, GAFailure of the right inboard foreflap outboard fitting due to fatigue and bearing anomalies on the sequence carriages which resulted in the partial separation of the right inboard foreflap. Contributing to the incident was the failure of maintenance personnel…NTSB CEN13WA580Incident · No injuriesForeign investigationTomisin Thomas J Rutan Long EZ · Cadiz, SpainOn May 19, 2013, at 1512 coordinated universal time, a Rutan Long EZ experimental airplane, N742TJ, landed with the nose landing gear retracted at the Jerez Airport (LEJR), Cadiz, Spain. The pilot was not injured and the airplane sustained minor damage. The…NTSB CEN13WA288Accident · 1 fatalForeign investigationPiper PA-28-140 · Gwynedd, Wales, United KingdomOn May 19, 2013, about 1019 hours universal coordinated time, a Piper PA-28-140, United Kingdom registration G-ATRR, impacted terrain during landing at the Caernarfon Airport (EGCK), Gwynedd, Wales, United Kingdom. There were three occupants on-board at the…NTSB ANC13LA049Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Big Lake, AKThe pilot’s execution of a hard landing, which resulted in the overstress fracture of the right main axle housing and the subsequent nosedown.NTSB ANC13LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-16 · Juneau, AKThe total loss of engine power for reasons that could not be determined due to the inability to recover the airplane.NTSB WPR13LA247Accident · No injuriesLimited investigationFinal reportCessna 210-5A · Wenatchee, WAThe pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and his improper landing flare, which resulted in the airplane’s tail striking the runway.NTSB ERA13LA248Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Geneva, FLThe passenger’s failure to adhere to the pilot’s instructions to stay away from the front of the airplane when the engine was operating.NTSB ERA13CA250Accident · Minor injuriesData collectionFinal reportThomas David W Rans S-12 XL · Cleveland, GAThe pilot's failure to maintain airspeed while maneuvering after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of overall recent flight experience and lack of experience in make and model.NTSB DCA13FA094Accident · No injuriesField investigationFinal reportBombardier DHC8 · Newark, NJthe frozen left main landing gear (MLG) uplock roller due to lack of lubrication and the uplock latch that had worn beyond acceptable tolerances, which prevented the flight crew from extending the left MLG using the alternate extension system. Contributing to…NTSB CEN13LA299Accident · 1 fatalLimited investigationFinal reportPeck Norman O Peck P-1 · Aztec, NMThe pilot’s loss of airplane control during takeoff for reasons that could not be determined because postaccident fire damage precluded a complete examination of the airplane.NTSB CEN13LA287Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Oskaloosa, IAThe loss of engine power for reasons that could not be determined because the engine examination did not reveal any malfunctions or failures that would have precluded normal operation.NTSB CEN13LA286Accident · No injuriesLimited investigationFinal reportCessna 182C · Fremont, MIThe pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion while in the traffic pattern.NTSB WPR13CA235Accident · Minor injuriesData collectionFinal reportSwanson Tiger Moth 80 · Lynden, WAThe pilot's failure to maintain clearance from trees during final approach and his obscured vision due to the sun glare.NTSB ERA13CA247Accident · No injuriesData collectionFinal reportCessna 182D · East Moriches, NYThe inadvertent deployment of the skydiving instructor's drogue chute when he exited the airplane, resulting in it contacting and damaging the horizontal stabilizer.NTSB DCA13WA102Incident · No injuriesForeign investigationBoeing 757 · Reus, SpainOn 17 May, 2013, at about 0703 UTC, a B757-200, registration G-OOBE, operated by Thomson Airways, was on approach and cleared to land at Reus Airport (LERS), Spain, was forced to perform a go-around due to a Diamond DA20, registration EC-IIT, that was present…NTSB CEN13CA284Accident · No injuriesData collectionFinal reportStinson 108-1 · Cambridge, MNThe pilot’s loss of directional control while landing with a gusting crosswind.NTSB WPR13LA233Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164D · Butte City, CAThe pilot's failure to maintain airplane control after an encounter with wake turbulence while maneuvering at low altitude. Contributing to the accident was the pilot’s fatigue due to extended hours of wakefulness and high workload.NTSB WPR13FA234Accident · 1 fatalField investigationFinal reportCessna 421C · Floriston, CAThe pilot's failure to maintain airplane control during descent while operating in instrument meteorological conditions.NTSB WPR13CA232Accident · No injuriesData collectionFinal reportCessna 195A · San Carlos, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN13IA285Incident · No injuriesIncident investigationFinal reportCirrus SR22 · Dallas, TXThe failure of the airplane’s parachute to deploy when activated during a loss of control in cruise flight due to the dynamic maneuvering of the airplane at the time of the activation, which exceeded the parachute system’s certification requirements.