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 WPR10CA461Accident · No injuriesData collectionFinal reportDehavilland Beaver DHC-2 MK.1 · Renton, WAThe pilot's failure to maintain directional control of the float-equipped airplane during an aborted water takeoff, resulting in a dragged wing.NTSB ERA10WA489Accident · No injuriesForeign investigationPiper PA-31-350 · South Bimini, BahamasOn September 19, 2010, at 1440 eastern daylight time, a Piper PA31-350, N84859, registered to Spirit Air Inc, and operated by Pioneer Air Services was on initial climb out when the lower half of the main cabin door came open. The pilot reversed his course and…NTSB ERA10LA488Accident · 1 fatalLimited investigationFinal reportSchulman Mosquito XEL · Halifax, MAThe pilot's loss of control while hovering. Contributing to the accident was the pilot’s limited experience operating the helicopter make and model.NTSB ERA10LA487Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Dublin, GAThe pilot's failure to properly secure the oil drain plug after changing the engine oil, which resulted in oil starvation and an engine failure during cruise flight.NTSB ERA10LA486Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Barnwell, SCThe failure of the No. 1 connecting rod end cap for undetermined reasons, which resulted in a total loss of engine power.NTSB CEN10CA548Accident · No injuriesData collectionFinal reportPiper PA-17 · Edwardsburg, MIA total loss of engine power during takeoff due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB CEN10CA547Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Houma, LAThe pilot’s inadequate compensation for the crosswind while landing, which resulted in a loss of directional control.NTSB WPR10LA483Accident · No injuriesLimited investigationFinal reportBoam Rans S-6S · Roberts, IDA loss of engine power due to the detachment of the left carburetor from the engine inlet manifold. Contributing to the accident was the pilot's failure to address a known engine vibration.NTSB ERA10LA494Accident · No injuriesLimited investigationFinal reportCessna 172D · Palm Beach, FLThe pilot's failure to use carburetor heat which led to a loss of engine power due to carburetor icing.NTSB ERA10LA485Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Rainelle, WVThe improper rigging of the fuel selector by maintenance personnel, which resulted in a total loss of engine power.NTSB ERA10LA484Accident · No injuriesLimited investigationFinal reportBell OH-58A · Covington, TNA loss of engine power due to contamination of the helicopter's fuel supply.NTSB ERA10LA483Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Clyo, GAThe pilot's failure to maintain a proper aircraft pitch attitude during the takeoff roll, which allowed the tailwheel to contact the grass runway and increase drag on the airplane.NTSB DCA10WA096Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Paris, FranceOn September 18, 2010 about 7:30 PM local time, a FedEx Express McDonnell Douglas MD-11F (registration N574FE), landed on runway 27R and crossed runway 27L Paris-Charles De Gaulle Airport (LFPG), Paris, France. As a result, a Boeing 777 aborted its initial…NTSB CEN10WA546Accident · 1 fatalForeign investigationBell 206 · San Pedro Sula, HondurasOn September 18, 2010, at 1757 coordinated universal time, a Bell 206B, HR-AVL, was substantially damaged upon impact with terrain near the La Mesa Airport, San Pedro Sula, Honduras. The pilot, the sole occupant on board, was fatally injured. The number of…NTSB CEN10LA567Accident · No injuriesLimited investigationFinal reportCessna 320 · Denton, TXThe failure of the landing gear push-pull rod.NTSB CEN10LA551Accident · Minor injuriesLimited investigationFinal reportMccauley Gene E RV-6A · Kokomo, INCollapse of the nose landing gear during landing rollout on an unpaved runway due to a loss of ground clearance with the landing gear fork, causing the airplane to nose over.NTSB WPR10FA459Accident · 2 fatalField investigationFinal reportCessna T210N · Coeur d'Alene, IDThe pilot’s continued flight into instrument meteorological conditions and failure to maintain clearance with mountainous terrain while maneuvering in an area of low cloud ceilings.NTSB CEN10LA571Accident · Serious injuriesLimited investigationFinal reportCa Tecnam P2004 Bravo · Mason, MIA total loss of engine power for undetermined reasons, which resulted in a forced landing to a bean field.NTSB CEN10LA556Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Duluth, MNThe pilot's failure to identify and arrest the helicopter's descent due to spatial disorientation.NTSB CEN10CA582Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Atkins, ARA partial loss of engine power during low-altitude flight for undetermined reasons.NTSB CEN10CA545Accident · Serious injuriesData collectionFinal reportAerospatiale AS 355F1 · Pikes Peak, COThe helicopter's encounter with an unexpected downdraft, which resulted in a hard landing.NTSB ANC10CA095Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's improper recovery from a bounced landing.NTSB WPR10LA458Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mammoth, CADynamic rollover of the helicopter during a precautionary landing.NTSB OPS10IA574Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-214 · Minneapolis, MNThe Local North Controller's issuance of a left-turn heading to the Airbus without establishing the position and heading of the Beech. Contributing to the incident was the Local South Controller's distraction with a ground movement operation and lack of…NTSB ANC10LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Dillingham, AKBoth pilots’ failure to see and avoid each other during initial climb, resulting in a midair collision. Contributing to the accident was the pilot of N9699P’s inability to use his airplane's radio for air traffic advisories.NTSB ERA10WA509Accident · 4 fatalForeign investigationRobinson R44 · Lagoa do Triunfo, Para, BrazilOn September 15, 2010, about 2150 universal coordinated time, a Robinson R-44 II helicopter, Brazilian registration PR-DAN, was substantially damaged when it impacted the terrain in Lagoa do Triunfo, Para, Brazil. The pilot and three passengers were fatally…NTSB ERA10TA481Accident · No injuriesFinal reportPiper PA-34-200T · Inverness, FLThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the nose landing gear.NTSB ERA10CA491Accident · No injuriesData collectionFinal reportMooney M20J · Hazard, KYThe pilot's failure to maintain clearance from a fuel pump while taxiing. Contributing to the accident was the pilot’s diverted attention.NTSB ERA10CA480Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf 912 · Pleasant Garden, NCThe pilot's loss of directional control on takeoff during an encounter with a wind gust.NTSB CEN10CA552Accident · No injuriesData collectionFinal reportCessna 172P · Stow, OHThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB CEN10CA541Accident · Minor injuriesData collectionFinal reportAerolite Bearcat · Mineola, TXFailure of the oil injection pump resulting in a total loss of engine power.NTSB ANC10CA093Accident · Minor injuriesData collectionFinal reportCessna T310R · Nome, AKThe pilot's failure to maintain clearance from terrain during a special VFR approach, resulting in a collision with terrain.NTSB WPR10WA460Accident · 1 fatalForeign investigationCessna 188 · Geraldton Aerodrome, Australia, AustraliaOn September 14, 2010, at 0745 universal coordinated time, a Cessna 188 Agwagon, VH-KZF, collided with terrain during takeoff for an aerial application flight near Geraldton Aerodrome, Australia. The airplane was operated by Prestige Helicopters PTY LTD. The…NTSB ERA10CA479Accident · No injuriesData collectionFinal reportCessna 182S · Toms River, NJThe pilot's failure to maintain an adequate visual lookout during a night taxi. Contributing to the accident was the improper parking of a ground vehicle partially onto the taxiway.NTSB ANC10CA089Accident · No injuriesData collectionFinal reportCessna 150M · Bethel, AKThe pilot's failure to maintain altitude/clearance during a night approach, resulting in a collision with terrain short of the runway.NTSB DCA10WA101Accident · No injuriesForeign investigationATR ATR42 · Cuidad Guayana, VenezuelaOn September 13, 2010, a Venezuelan ATR-42 operated by Conviasa Airlines crashed near Cuidad Guayana, Venezuela. The accident is being investigated by the government of Venezuela and the Safety Board is assisting with flight recorder readouts. All inquiries…NTSB CEN10CA539Accident · No injuriesData collectionFinal reportCessna A185F · Rushville, NEThe pilot's failure to maintain directional control of the airplane during takeoff. Contributing to the accident was the loss of visual reference due to the sun glare.NTSB ANC10CA102Accident · No injuriesData collectionFinal reportPiper PA-12 · Windy Forks Strip, AKThe pilot's failure to maintain directional control while taxiing on a rough/uneven airstrip.NTSB WPR10LA456Accident · Serious injuriesLimited investigationFinal reportSavage Savage-Cozy · Aurora, ORThe pilot’s failure to maintain control of the airplane following a loss of engine power in the traffic pattern; the cause of the loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not…NTSB ERA10LA478Accident · No injuriesLimited investigationFinal reportPiaggio P-180 · Clearwater, FLThe flight crew did not ensure that the landing gear was down and that it indicated down through the takeoff sequence.NTSB ERA10CA476Accident · No injuriesData collectionFinal reportGoodman Robert Bruce RV-4 · Gainesville, GAThe pilot's failure to see and avoid marked power lines during low-level flight over a lake.NTSB CEN10CA543Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Ft. Wayne, INThe pilot's selection of unsuitable terrain for the landing.NTSB CEN10CA537Accident · Minor injuriesData collectionFinal reportLewis Brandon Scott Exterminator · Rockford, ILThe pilot's failure to maintain control of the gyrocopter while practicing takeoffs and landings.NTSB CEN10CA533Accident · No injuriesData collectionFinal reportPiper PA46-310P · Farmington, NMThe pilot’s premature retraction of the landing gear and the flaps during landing. Contributing to the accident was the inadvertent dimming of the cockpit lighting, resulting in a perceived unsafe gear configuration.NTSB ANC10LA087Accident · Serious injuriesLimited investigationFinal reportCessna 185A · Paxson, AKThe pilot's decision to make a climbing turn close to the ground in gusting wind at a low airspeed, resulting in a loss of control and collision with terrain.NTSB ANC10CA090Accident · No injuriesData collectionFinal reportCessna 150L · Kenai, AKThe pilot's decision to takeoff from a remote lake after overloading the airplane. Contributing to the accident was the pilot's lack of a seaplane rating.NTSB WPR10LA464Accident · 1 fatalLimited investigationFinal reportHughes OH-6A · Majuro (Pacific Ocean)A loss of helicopter control for undetermined reasons.NTSB WPR10LA454Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA-300 · Sierra Vista, AZA loss of engine power due to metal debris contamination of the inverted oil system shuttle valve, which resulted in a disruption of oil flow and subsequent oil starvation.NTSB WPR10CA455Accident · No injuriesData collectionFinal reportMaule MX7 · Willows, CAThe pilot's inadequate compensation for the gusty crosswind condition and his failure to maintain directional control.NTSB CEN10CA544Accident · No injuriesData collectionFinal reportPiper PA22 · Atkinson, NEThe pilot's failure to maintain directional control while landing with a crosswind.