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 CEN18WA105Incident · No injuriesForeign investigationSikorsky S-92A · Shetland, United KingdomOn January 14, 2018, about 1413 universal time (UTC), a United Kingdom registered Sikorsky S-92A, G-CHHF, experienced a nose landing gear (NLG) anomaly during landing at Scatsta Airport, Shetland, United Kingdom. The NLG did not extend during the approach to…NTSB GAA18CA113Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Homstead, FLThe pilot’s diverted attention to his phone while maneuvering at a low altitude, which resulted in collision with terrain.NTSB ERA18TA076Accident · No injuriesFinal reportVertical Aviation Technologies 260L Hummingbird · Harrisville, NYThe failure of an electric fuel pump, which resulted in fuel starvation and a total loss of engine power during cruise flight.NTSB ERA18IA078Incident · No injuriesClass 3 · IncidentFinal reportAirbus Helicopters EC 130 · Memphis, TNThe pilot’s failure to lock the collective pitch control after landing, and the mechanic’s failure to properly balance the collective pitch control after converting the helicopter to a single-pilot configuration, which resulted in an uncommanded collective…NTSB WPR18FA074Accident · 1 fatalField investigationFinal reportHughes 369D · Pomeroy, WAA loss of control following the gunner's failure to ensure that the net maintained clearance from the tail rotor.NTSB ERA18LA073Accident · No injuriesLimited investigationFinal reportAero Commander 680 F · Lapine, ALThe pilot's failure to maintain directional control during takeoff after a total loss of left engine power due to fuel contamination, which resulted in impact with trees. Contributing to the accident were the mechanic's failure to properly flush the fuel…NTSB ERA18LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Meriden, CTThe pilot's inadequate preflight fuel planning and his improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN18FA088Accident · 1 fatalField investigationFinal reportCessna 172F · Williamsport, INThe pilot's mismanagement of fuel, which resulted in fuel exhaustion and descent and collision with trees.NTSB GAA18CA112Accident · No injuriesData collectionFinal reportCessna 172 · Silver City, NMThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a hard, bounced landing.NTSB CEN18WA091Accident · 1 fatalForeign investigationPiper PA25 · Mocorito, MexicoOn January 26, 2018, at 1930 UTC, a Piper PA25-150, XB-FBN, impacted terrain under unknown circumstances in the Community el Recoveco in Mocorito, Mexico. The aircraft was destroyed, and the pilot was fatally injured. The flight had departed airdrome "El…NTSB CEN18LA087Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Loveland, COThe airplane pilot’s failure to see and avoid the helicopter while in the traffic pattern, which resulted in a midair collision between the two aircraft. Contributing to the accident was the airplane pilot’s misunderstanding of the helicopter pilot’s…NTSB ANC18LA020Accident · No injuriesLimited investigationFinal reportEurocopter France SA330J Puma · Pacific Ocean, JapanThe worn rear bearing of the freewheel unit. Contributing to the accident was the delay in analyzing an oil sample, which would have detected the increase in metal contaminants from the worn bearing.NTSB WPR18WA083Accident · No injuriesForeign investigationGulfstream GULFSTREAM200 · Abuja, NigeriaOn January 25, 2018, at 1818 Universal Coordinated Time (UTC), a Nigerian registered Gulfstream G-200, 5N-BTF experienced a runway excursion during the landing rollout at Nnamdi Azikiwe International Airport (DNAA), Abuja, Nigeria. The airplane departed the…NTSB GAA18CA111Accident · Minor injuriesData collectionFinal reportMaule M 6 · Boerne, TXThe ground vehicle driver’s decision to drive on an active taxiway at night and failure to yield to taxiing aircraft, resulting in a collision with a taxiing aircraft.NTSB ERA18LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA32R · Marathon, FLThe pilot's failure to maintain directional control during takeoff.NTSB ENG18WA010Incident · No injuriesForeign investigationBoeing 737 · Lima, PeruOn January 25, 2018, a Peruvian Air Lines Boeing 737-530, registered in Peru as OB-2140P, had an uncommanded shutdown of the No. 2 engine, a CFMI CFM56-3B1, after leveling off at FL370. The flight crew declared an emergency and diverted back to Lima, Peru.…NTSB ANC18LA021Accident · Serious injuriesClass 3 · LimitedFinal reportFoxfly Foxdominator · Indiantown, FLThe pilot’s improper decision to attempt to take off in the gyroplane in strong gusting crosswind conditions, with insufficient distance to safely abort, which resulted in a loss of control and impact with a ditch and road embankment.NTSB GAA18CA143Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot’s improper approach and landing flare, which resulted in a porpoised landing.NTSB ERA18LA068Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Fort Lauderdale, FLThe partial loss of engine power during the initial climb due to a stuck intake valve on the No. 4 cylinder.NTSB CEN18LA085Accident · No injuriesLimited investigationFinal reportQuartz Mountain Aerospace L-11E · Omaha, NEThe instructor pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ANC18LA025Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC 2 · Kodiak, AKThe pilot's failure to maintain directional control during landing for reasons that could not be determined based on the available evidence.NTSB ERA18WA066Accident · 2 fatalForeign investigationRobinson R44 · Recife, BrazilThe government of Brazil has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on January 23, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB CEN18WA120Accident · 4 fatalForeign investigationPiper PA-28RT-201T · Oberhausen-Rheinhausen, GermanyOn January 23, 2018, about 1207 coordinated universal time, a Piper PA-28 airplane, Swiss registration HB-PGF, collided with an Airbus-Helicopter EC135P2, German registration D-HDRV near Oberhausen-Rheinhausen, Germany. The pilots and passengers were all…NTSB CEN18FA083Accident · 1 fatalField investigationFinal reportSkwira Matthew J W-10 Tailwind · Sauk Centre, MNImpact with terrain for reasons that could not be determined based on the available information.NTSB GAA18CA110Accident · Minor injuriesData collectionFinal reportHelicopteres Guimbal Cabri G2 · Cahokia, ILThe student pilot's failure to maintain yaw control while landing in gusting crosswind conditions and the flight instructor's delayed remedial action.NTSB ERA18FA064Accident · 1 fatalField investigationFinal reportVans RV-12 · Bonita Springs, FLThe pilot's unsafe maneuvering and exceedance of the airplane's operating limitations, which resulted in an in-flight failure of the left wing. Contributing to the accident was the pilot's underlying physiologic or psychiatric disease.NTSB CEN18LA084Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Abilene, TXMaintenance personnel’s improper maintenance of the engine, which resulted in a catastrophic engine failure due the shifting/slipping of the No. 2 bearing and the subsequent oil starvation and total loss of engine power during cruise flight.NTSB GAA18CA115Accident · No injuriesData collectionFinal reportCessna 210 · Sussex, NJThe pilot’s inadvertent landing gear retraction during approach.NTSB ERA18LA082Accident · Serious injuriesLimited investigationFinal reportMosquito XEL · Loxahatchee, FLThe noncertificated pilot's failure to maintain helicopter control during takeoff. Contributing to the accident were the pilot's lack of recent flight experience and his lack of training and experience in the accident helicopter make and model.NTSB ERA18LA067Accident · No injuriesLimited investigationFinal reportCessna 172RG · Martinsburg, WVA hydraulic leak in the right main landing gear actuator, which resulted in the main landing gear not extending.NTSB WPR18WA067Accident · 1 fatalForeign investigationCessna 182 · Bridport, AustraliaOn January 20, 2018, at 1800 local time, a Cessna 182P, VH-TSA, collided with terrain near Bridport, Australia. The airplane sustained substantial damage. The pilot sustained serious injuries and the passenger was fatally injured. The flight was operated…NTSB WPR18CA072Accident · Minor injuriesData collectionFinal reportCessna 172P · Cloverdale, CAThe pilot's failure to maintain airplane control during the approach and his delayed decision to go around.NTSB CEN18LA082Accident · Serious injuriesLimited investigationFinal reportMatheny Larry E Christavia MK 1 · Grand Detour, ILThe pilot's failure to see and avoid the power line. Contributing to the accident was the pilot’s intentional flight at low altitude.NTSB WPR18LA076Accident · Serious injuriesClass 3 · LimitedFinal reportBuckeye Industries Dream Machine 582 · Chester, MTThe pilot's failure to maintain adequate clearance from powerlines.NTSB WPR18LA071Accident · Serious injuriesClass 3 · LimitedFinal reportSix Chuter Spirit · Marana, AZThe noncertificated pilots’ failure to maintain an adequate visual lookout, which resulted in a midair collision.NTSB CEN18WA081Accident · 1 fatalForeign investigationZodiac 601XL · Castellon, SpainOn January 19, 2018, about 0930 UTC, a Zodiac 601XL, Spanish registry EC-XKM, owned and operated by a private individual, impacted mountainous terrain in the municipality of La Pobla de Benifassa, Castellon, Spain. A postimpact fire ensued. The pilot was…NTSB CEN18LA086Accident · No injuriesLimited investigationFinal reportSwearingen SA227 TT · Houston, TXThe failure of the left starter relay during engine start, which resulted in a loss of electrical and battery power during the flight and led to a forced landing with the nose landing gear not fully extended, causing substantial damage to the engines.NTSB ENG18WA011Incident · No injuriesForeign investigationAirbus A330 · Alice Springs, AustraliaOn January 18, 2018, about 14:25 Western Australian standard time, a Malaysian-registered Airbus A330-323 airplane had the No. 1 engine, a Pratt & Whitney PW4168A engine shutdown by the flight crew after it had compressor stalls. The airplane, which was…NTSB CEN18LA080Accident · Minor injuriesLimited investigationFinal reportTomlinson Tracy L Tukan · Erie, COThe student pilot’s inadvertent shutting off of the fuel valve while on approach, which resulted in a loss of engine power due to fuel starvation and impact with terrain.NTSB CEN18FA078Accident · 5 fatalField investigationFinal reportBell UH-1H · Raton, NMThe pilot's failure to maintain adequate altitude above mountainous terrain during cruise flight in dark night conditions, which resulted in controlled flight into terrain.NTSB WPR18WA159Accident · Serious injuriesForeign investigationRobinson R44 · Ayers Rock, AustraliaOn January 17, 2018, at 1800 local time, a Robinson R44 helicopter, VH-HGX, experienced a partial loss of engine power shortly after takeoff. The pilot subsequently initiated an autorotation, landed hard and rolled over near Ayres Rock, Australia. The pilot…NTSB WPR18LA070Accident · No injuriesLimited investigationFinal reportPiper PA 32-300 · Reno, NVA total loss of engine power due to fuel starvation. Contributing to the accident was the failure of the pilot/owner to ensure that the airplane was airworthy before flight.NTSB WPR18LA069Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Skyforest, CAThe pilot’s failure to establish the proper airspeed after departure and to maintain adequate clearance from a ridgeline in high-density and downdraft conditions and his subsequent exceedance of the airplane’s critical angle of attack, which resulted in an…NTSB ERA18WA063Accident · 6 fatalForeign investigationPiper PA-23-250 · Nicholls Town, BahamasThe government of Bahamas has notified the NTSB of an accident involving a PIPER PA 23-250 airplane that occurred on January 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the…NTSB DCA18WA100Incident · No injuriesForeign investigationBoeing 737 · Auckland, New ZealandThe AAIB of New Zealand has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on January 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB of New Zealand's investigation under the provisions of…NTSB GAA18CA109Accident · No injuriesData collectionFinal reportBeech B60 · Scottsdale, AZThe pilot’s improper brake application during landing, which resulted in a tire blowout and a loss of directional control.NTSB CEN18LA077Accident · Serious injuriesClass 3 · LimitedFinal reportBryk Steven L Velocity XL RG · Santa Fe, NMThe airplane’s inadvertent encounter with unforecasted icing conditions during cruise flight, which resulted in the accumulation of airframe icing, the airplane’s inability to maintain altitude, and a subsequent forced landing on rough terrain.NTSB GAA18CA104Accident · Minor injuriesData collectionFinal reportGeldermann Bert E Lancair Legacy · Friday Harbor, WAThe pilot’s inability to maintain the landing flare, which resulted in the airplane landing hard short of the runway. Contributing to the accident was the cockpit canopy opening in flight.NTSB CEN18FA074Accident · 2 fatalField investigationFinal reportMD Helicopters 369HM · Perrysburg, OHA loss of engine power due to snow or ice ingestion at an altitude that was insufficient to allow for engine re-ignition. Contributing to the accident were conditions, including altitude and flat light conditions, that precluded a successful autorotation to…NTSB GAA18CA103Accident · Minor injuriesData collectionFinal reportHarrop Blake RV 7 · Death Valley National Park, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.