NTSB investigations, 2018
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WHERE year(c.\"eventDate\") = 2018 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 WHERE year(c."eventDate") = 2018 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 ERA18FA264Accident · 2 fatalField investigationFinal reportDassault Falcon 50 · Greenville, SCThe operator's decision to allow a flight in an airplane with known, unresolved maintenance discrepancies, and the flight crew's failure to properly configure the airplane in a way that would have allowed the emergency or parking brake systems to stop the…NTSB ANC18WA078Accident · 1 fatalForeign investigationCessna 208 · Narita, JapanOn September 27, 2018, at 0626 universal coordinated time, a Cessna 208B airplane, VH-FAY, disappeared from radar during cruise flight over international waters, about 185Km northeast of Narita International Airport. Parts from the destroyed airplane were…NTSB ANC18LA073Accident · No injuriesLimited investigationFinal reportCessna A185 · Fairbanks, AKThe total loss of engine power due to fuel exhaustion.NTSB ANC18LA072Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Anchorage, AKThe pilot's failure to avoid wake turbulence from a crossing heavy airplane.NTSB WPR18LA275Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32RT · Malad, IDThe pilot’s failure to identify that he was not utilizing the full runway for takeoff, and his delayed decision to abort the takeoff, which resulted in a runway overrun.NTSB DCA18WA305Incident · No injuriesForeign investigationBoeing 737 · Chattogram, BangladeshThe AAIG of Bangladesh has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on September 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIG of Bangladesh's investigation under the provisions of…NTSB DCA18WA296Incident · Minor injuriesForeign investigationAirbus A320 · Tijuana, MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on September 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB DCA18CA294Accident · Serious injuriesData collectionFinal reportAirbus A321 · Dallas, TXa passenger leaving a bag in the aisle that the flight attendant tripped over.NTSB CEN18FA389Accident · 1 fatalClass 2 · FieldFinal reportVans RV 4 · Austin, ARThe pilot's failure to maintain airplane control while maneuvering which resulted in the airplane exceeding its critical angle of attack and an accelerated stall.NTSB WPR18LA272Accident · No injuriesClass 3 · LimitedFinal reportSmith AEROSTAR601 · Heber, UTA recent hard landing resulted in a fracture of a joint from a cylinder to a main landing gear.NTSB CEN18WA390Accident · 1 fatalForeign investigationRobinson R44 · Buttonville, CanadaOn September 25, 2018, about 1800 hours universal coordinated time, a Robinson R44 II helicopter, Canadian registration C-GMCT, impacted terrain while diverting due to deteriorating weather conditions near the Toronto/Buttonville Municipal Airport (CYKZ),…NTSB CEN18FA387Accident · 1 fatalField investigationFinal reportBeech 200 · Oscoda, MIThe pilot's descent below minimum descent altitude during the nonprecision instrument approach for reasons that could not be determined based on the available information.NTSB GAA18CA581Accident · Minor injuriesData collectionFinal reportDe Havilland DHC 2 MK. I(L20A) · Kukaklek Lake, AKThe pilot’s failure to see and avoid a sand bar during a water takeoff, which resulted in the airplane impacting a river bank.NTSB GAA18CA570Accident · No injuriesData collectionFinal reportAviat A1 · Raquette Lake, NYThe pilot’s failure to maintain lateral control after landing on water in gusting wind conditions.NTSB GAA18CA566Accident · No injuriesData collectionFinal reportVans RV-14 · Heber City, UTThe pilot's loss of directional control during the landing roll and his subsequent attempted go-around.NTSB ERA18LA271Accident · Minor injuriesClass 3 · LimitedFinal reportBell OH 58A · Juana Diaz, PRA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA18LA257Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Winter Haven, FLThe student pilot’s improper pitch attitude control during the initial climb, which resulted in a loss of airspeed, and his subsequent decision to conduct a 180° turn following the perceived anomaly, which resulted in a runway overrun.NTSB ENG18WA037Accident · No injuriesForeign investigationHonda HA-420 · Foz do Iguacu, BrazilThe government of Brazil has notified the NTSB of an accident involving a Honda HA-420, which occurred on September 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB DCA18CA299Accident · Serious injuriesData collectionFinal reportBoeing 757 · Newark, NJthe catering cart striking the flight attendant's foot.NTSB CEN18FA386Accident · 1 fatalField investigationFinal reportCessna U206 · Rainy Pass, AKThe pilot's improper decision to continue the flight in deteriorating weather conditions, which resulted in an inadvertent entry into a box canyon and subsequent controlled flight into mountainous terrain.NTSB ERA18TA263Accident · Minor injuriesFinal reportZenith CH 750 · DeLeon Springs, FLThe pilot's operation of the airplane with the alternator switch in the off position, which allowed the selected battery to discharge and resulted in an ignition system failure and a total loss of engine power.NTSB ANC18FA071Accident · 2 fatalField investigationFinal reportPiper PA-12-150 · Healy, AKAn impact with terrain for reasons that could not be determined based on the available information.NTSB WPR18WA282Accident · Minor injuriesForeign investigationBell 206 · Yarraden, AustraliaOn September 22, 2018, at 2045 coordinated universal time, a Bell 206B helicopter, registration VH-HZO, sustained substantial damage after colliding with the ground following a total loss of power near Yarraden, Australia. The pilot was not injured. The three…NTSB ERA18TA267Accident · Serious injuriesClass 3Final reportGrob G103 Twin Astir · Groveland, FLThe student pilot's failure to relinquish the flight controls during landing when the flight instructor told him to do so, and the instructor’s subsequent inability to properly control the glider, which led to a hard landing.NTSB ERA18LA258Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Georgetown, SCA loss of directional control during landing due to overstress failure of the left seat’s left rudder pedal arm clevis, which occurred as a result of manufacturing defects.NTSB CEN18RA397Incident · No injuriesForeign investigationCirrus SF50 · Zurich, SwitzerlandOn September 22, 2018, about 1615 UTC, a Cirrus Design Corporation SF50 VisionJet, N474CG, owned by Southern Aircraft Consultancy Incorporated Trustee, and operated I-FLY AG, c/o Aximos Treuhand AG, experienced an electrical fire in the air conditioning unit…NTSB WPR18LA280Accident · No injuriesClass 3 · LimitedFinal reportMooney M20J · Kapolei, HILoss of engine power due to water in the fuel lines.NTSB GAA18CA567Accident · No injuriesData collectionFinal reportPiper PA18 · St. Mary's, AKThe pilot’s selection of an unsuitable off-airport landing area, which resulted in a ground loop.NTSB GAA18CA564Accident · No injuriesData collectionFinal reportCessna 150 · Roseburg, ORThe pilot's loss of directional control during landing.NTSB GAA18CA563Accident · Serious injuriesData collectionFinal reportAir Tractor AT802 · Napoleon, NDThe pilot’s failure to maintain clearance from a power line pole during an agricultural application flight.NTSB CEN18WA388Accident · 3 fatalForeign investigationCessna 210 · Pico de Orizaba, MexicoOn September 21, 2018, about 1440 hours universal coordinated time, a Cessna T210L single-engine airplane, serial number 21060532, Mexican registration XB-NVG, impacted terrain on mount Pico de Orizaba near Veracruz and Puebla, Mexico. The three occupants…NTSB CEN18FA384Accident · 2 fatalField investigationFinal reportCessna 150 · Festus, MOA total loss of engine power due to fuel exhaustion and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to initiate and continue the…NTSB WPR18LA271Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206 · Brenham, TXThe pilot's improper fuel management during the landing approach, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was his failure to follow the published emergency procedures after the loss of engine power.NTSB GAA18CA573Accident · No injuriesData collectionFinal reportHiller UH 12E · Frankfort, KSThe ground crewmember's improper grabbing of the hovering helicopter's skid during an external load hook-up, which resulted in the helicopter descending and the main rotors striking ground equipment.NTSB GAA18CA565Accident · Minor injuriesData collectionFinal reportDe Havilland DHC 2 · Igiugig, AKThe pilot’s selection of an empty fuel tank for takeoff, which resulted in fuel starvation and the subsequent total loss of engine power.NTSB ERA18TA255Accident · Serious injuriesFinal reportCalvin Nate H Velocity STD RG E · Kingsport, TNThe pilot's failure to use carburetor heat in conditions conducive to serious carburetor icing at glide power, which resulted in a partial loss of power and an aerodynamic stall.NTSB DCA18WA304Incident · No injuriesForeign investigationBoeing 737 · Mumbai, IndiaThe AAIB of India has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB of India's investigation under the provisions of ICAO Annex…NTSB DCA18CA303Accident · No injuriesClass 4 · Data collectionFinal reportEmbraer EMB120 · 40 nm vicinity south of Lake Jackson, TXan encounter with severe turbulence, which caused the improperly secured cargo to shift and damage the airplane floor structure.NTSB GAA18CA578Accident · No injuriesData collectionFinal reportCirrus SR22 · Frederick, MDThe pilot's improper landing flare, which resulted in the airplane porpoising.NTSB GAA18CA562Accident · No injuriesData collectionFinal reportRutan Rutan Long EZ · Independence, ORThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing.NTSB CEN18LA382Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Sugar Land, TXFatigue failure of the No. 1 cylinder intake valve, which resulted in the loss of engine power.NTSB CEN18LA381Accident · No injuriesLimited investigationFinal reportPiper PA28 · Pagosa Springs, COThe student pilot's mismanagement of the fuel selector valve during the simulated forced landing demonstration and the flight instructor's inadequate supervision to ensure the fuel selector was properly set, which resulted in a loss of engine power and…NTSB WPR18LA269Accident · No injuriesClass 3 · LimitedFinal reportRobinson R44 · Wahiawa, HILoss of oil in flight as a result of a loose oil filter adapter which resulted in the pilot initiating an immediate landing to an open field. Contributing to the accident was the pilot's manipulation of the throttle that led to a reduction in rotor rpm, which…NTSB GAA18CA577Accident · No injuriesData collectionFinal reportAviat A1 · Grand Island, NEThe pilot’s failure to maintain directional control during the landing roll in tailwind and crosswind conditions. Contributing to the accident was the pilot’s fatigue.NTSB WPR18LA268Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Upland, CALoss of engine power due to fuel contamination.NTSB WPR18FA266Accident · 1 fatalClass 2 · FieldFinal reportBeech 33 · Cottonwood, AZThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA18CA560Accident · Minor injuriesData collectionFinal reportPiper PA22 · Hillsdale, MIThe pilot’s exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.NTSB GAA18CA569Accident · No injuriesData collectionFinal reportMaule M7 · Grass Valley, ORThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA18LA253Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Montauk, NYThe pilot's failure to properly secure his seat before initiating the takeoff, which resulted in the seat sliding back as the airplane accelerated during takeoff, his inability to reach the pedals, and the subsequent loss of directional control and impact…NTSB DCA18WA288Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyThe BFU of Germany has notified the NTSB of an accident involving a Boeing 747 airplane that occurred on September 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the BFU of Germany's investigation under the provisions of ICAO…