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 CEN17LA047Accident · No injuriesLimited investigationFinal reportCessna Citation 500 · Gunnison, COThe pilot’s failure to fly a stabilized approach and his inadequate landing flare, which resulted in a hard landing. Contributing to the accident was the pilot’s failure to ensure that the airplane was properly serviced with fuel before departing on the…NTSB WPR17LA034Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Sacramento, CAThe failure of the vertical stabilizer due to fatigue.NTSB WPR17LA032Accident · Minor injuriesLimited investigationFinal reportHoskins Lonnie F Velocity XL RG · Petaluma, CAThe pilot’s failure to maintain adequate airspeed during an aborted landing, which resulted in an exceedance of the airplane’s critical angle of attack and an inadvertent aerodynamic stall. Contributing to the accident was the pilot’s distraction while on…NTSB GAA17CA087Accident · No injuriesData collectionFinal reportJack Fehling Celebrity · North Hampton, NHThe pilot’s unstabilized approach, which resulted in the biplane being low and striking trees.NTSB ERA17WA081Accident · 4 fatalForeign investigationRobinson Helicopter R44 II · Sao Lourenco da Serra, BrazilOn December 4, 2016, about 1800 universal coordinated time, a Robinson R44-II, Brazilian registration PR-TUN, was substantially damaged when it impacted terrain while maneuvering near Sao Lourenco, Sao Paulo, Brazil. The pilot and three passengers were…NTSB ENG17IA005Incident · Minor injuriesIncident investigationFinal reportEmbraer ERJ170 200LR · San Antonio, TXA failure of the nose landing gear down lock spring which precluded normal downlock operation of the nose landing gear. The spring failure was due to the presence of too much retained austenite which led to the formation of progressive cracking and subsequent…NTSB DCA17WA035Accident · Serious injuriesForeign investigationBoeing 777 · Lajes Terceira Island, PortugalThe government of Portugal has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on December 04, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Portugal's investigation under the…NTSB CEN17WA052Accident · 1 fatalForeign investigationPZL Bielsko SZD51 · Husbands Bosworth, United KingdomOn December 4, 2016, about 1230 coordinated universal time, a PZL Bielsko SZD-51-1 glider, G-CSFT, and a Cessna 150L airplane, G-CSFC, collided in midair near Husbands Bosworth, Leicestershire, United Kingdom. The glider impacted terrain and the pilot was…NTSB CEN17WA049Accident · 4 fatalForeign investigationBeech E 90 · Toledo, SpainNTSB ERA17WA303Accident · 1 fatalForeign investigationSchempp Hirth VENTUS2C · San Carlos de Bolivar, ArgentinaOn December 3, 2016, about 1750 coordinated universal time, a Schempp Hirth Ventus-2C motorized glider, Argentine registration LV-EDB, operated by a private individual, was substantially damaged when it impacted terrain after the left wing detached from the…NTSB CEN17LA048Accident · No injuriesLimited investigationFinal reportArion Lightning LS-1 · Goshen, INA partial loss of engine power due to carburetor icing and the subsequent forced landing on a rough/soft field.NTSB GAA17CA139Accident · No injuriesData collectionFinal reportPiper PA46 · Midland, VAThe pilot’s improper landing flare and subsequent hard landing while demonstrating a short-field landing and the flight instructor’s delayed remedial action.NTSB GAA17CA089Accident · No injuriesData collectionFinal reportPiper PA 28 · Thomson, GAThe pilot’s improper preflight planning, which resulted in fuel exhaustion and the total loss of engine power.NTSB GAA17CA088Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA-20 · Payson, UTThe student pilot's improper in-flight fuel planning, which resulted in fuel exhaustion.NTSB DCA17WA219Incident · No injuriesForeign investigationBoeing 737 · Nagpur, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a ATR-72 airplane that occurred on December 02, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's…NTSB CEN17FA046Accident · 1 fatalField investigationFinal reportGordon Pegazair P 100 · Mt Vernon, INThe pilot's failure to maintain airplane control, which resulted in a collision with terrain. Contributing to the accident was the pilot's impairment resulting from the combination of his progressive degenerative neurologic condition and his use of alcohol.NTSB ANC17LA011Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Unalaska, AKThe pilot’s failure to maintain adequate clearance from terrain during a precautionary landing in whiteout conditions, which resulted in an in-flight collision with terrain.NTSB WPR17LA030Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Scottsdale, AZThe pilot’s loss of directional control during the landing roll, which resulted in the runway excursion onto the rock-covered runway safety area.NTSB CEN17FA045Accident · 1 fatalField investigationFinal reportCessna 340 · Fargo, NDThe loose fuel fitting on the combustion heater that leaked a lean fuel-air mixture into the nose baggage compartment. The mixture was most likely ignited by the combustion heater, blowing off the nose baggage compartment doors and starting an in-flight fire.NTSB GAA17IA083Incident · No injuriesIncident investigationFinal reportCessna 560 · Salinas, CAThe pilot's failure to maintain clearance from a parked helicopter.NTSB ENG17IA006Incident · No injuriesIncident investigationFinal reportBombardier CL 600 2C10 · Kansas, ILThe probable cause of the uncontained No. 1 (left) engine failure was a separated high pressure turbine 2nd stage blade that failed due to a fatigue crack that originated below the blade platform from an area of corrosion.NTSB DCA17WA037Accident · No injuriesForeign investigationBoeing 767-319ER · Georgetown, GuyanaThe government of Guyana has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 29, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guyana's investigation under the provisions…NTSB ERA17WA062Accident · 3 fatalForeign investigationRobinson R44 · Vinogradny Township, RussiaOn November 28, 2016, about 0638 universal coordinated time, a Robinson R44 helicopter, Russian registration RA-04195, was substantially damaged when it impacted terrain near Vinogradny Township, Russia, while enroute from Yalta, Russia, to Crimea, Russia.…NTSB DCA17RA031Accident · No injuriesForeign investigationBAE AVRO146RJ · Medellin, ColombiaThe El Grupo de Investigacon de Accidentes (GRIAA) of Colombia has notified the NTSB of an accident involving a BAE AVRO146RJ that occurred on November 28, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GRIAA investigation under…NTSB GAA17CA120Accident · No injuriesData collectionFinal reportPiper PA28 · St. Louis, MOThe student pilot's improper landing flare, which resulted in a bounced landing.NTSB ENG17WA004Incident · No injuriesForeign investigationBoeing Commercial Airplane Gro B787-9 · Singapore, SingaporeThe Singapore Transport Safety Investigation Bureau (TSIB) has notified the NTSB of an incident involving a Boeing 787-9 that occurred on November 26, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the TSIB investigation under the…NTSB WPR17FA029Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Glamis, CAThe pilot's improper decision to attempt a downwind landing and his failure to maintain adequate airspeed while maneuvering during a go-around and subsequent landing attempt, which resulted in exceedance of the airplane's critical angle of attack and an…NTSB ANC17LA008Accident · No injuriesLimited investigationFinal reportAirborne Extreme SQ-12 · Palmer, AKThe fuel injector manufacturer's inappropriate guidance to use a 5-ampere circuit breaker in place of the required 10-ampere circuit breaker on the fuel injector circuit, which resulted in the circuit breaker opening, a loss of electrical power to the…NTSB WPR17LA038Accident · No injuriesLimited investigationFinal reportCessna 182A · Safford, AZThe total loss of engine power due to the failure of the No. 5 piston, piston pin, or connecting rod assembly for reasons that could not be determined due to the severity of the post fracture damage.NTSB GAA17WA583Incident · No injuriesClass 5 · ForeignBellanca 7GCBC · Budaors, HungaryNTSB ERA17WA059Accident · 4 fatalForeign investigationEmbraer EMB710 · Novo Progresso, BrazilOn November 24, 2016, about 2040 universal coordinated time, an Embraer EMB-710C, Brazilian registration PT-NCJ, was substantially damaged when it impacted terrain on approach to an unregistered landing strip in a quarry near Novo Progresso, State of Para,…NTSB GAA17CA084Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Pensacola, FLThe student pilot’s incorrect brake application during the landing roll, which resulted in a loss of directional control.NTSB ERA17WA061Accident · 1 fatalForeign investigationCessna TU206 · Villavicencio, ColombiaOn November 23, 2016, about 2000 coordinated universal time, a Cessna TU206G, Colombian registration HK2659, was substantially damaged during a forced landing near Vanguardia Airport (SKVV), Colombia. The Colombian certificated pilot and two of the passengers…NTSB ERA17WA055Accident · 1 fatalForeign investigationAyres S2R · Valparaiso, ChileOn November 23, 2016, about 1410 universal coordinated time, an Ayres S2-R, United States registration N5532G, was destroyed when it impacted mountainous terrain near Paso Internacional Los Libertadores, Chile. The pilot was fatally injured. The flight…NTSB ERA17LA057Accident · No injuriesLimited investigationFinal reportPiper PA28 · Columbus, GAA total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of any anomalies that would have precluded normal operation.NTSB CEN17LA044Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Bridgeport, TXThe pilot's failure to properly position the fuel selector before takeoff, which resulted a total loss of engine power due to fuel starvation.NTSB CEN17LA043Accident · Minor injuriesLimited investigationFinal reportBeech 200 · Moorhead, MNThe pilot's failure to attain a positive climb rate during an attempted missed approach in night instrument meteorological conditions that were at/near approach minimums, which resulted in controlled flight into terrain.NTSB WPR17FA025Accident · 1 fatalField investigationFinal reportPiper PA 28-181 · Upland, CAThe pilot's failure to maintain clearance from rising terrain in dark night conditions, which resulted in controlled flight into terrain.NTSB GAA17CA085Accident · No injuriesData collectionFinal reportHundley Michael J Vans RV8 · Roopville, GAThe pilot’s overcorrection with the right rudder during the landing roll, which resulted in a loss of directional control and a runway excursion.NTSB GAA17CA078Accident · No injuriesData collectionFinal reportLancair LC41 550FG · Redding, CAThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB GAA17CA077Accident · No injuriesData collectionFinal reportCurtiss Wright Travel AIR 4000 · San Diego, CAThe other pilot’s failure to see and avoid the airplane stopped ahead of him during taxi.NTSB ERA17LA063Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Bluefield, WVThe pilot's failure to maintain directional control during the aborted takeoff.NTSB ERA17LA053Accident · Minor injuriesLimited investigationFinal reportBroussard Broussard MH 1521 · Simpsonville, SCThe pilot’s inability to maintain directional control during the landing roll due to a flat left main landing gear tire.NTSB ANC17LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bethel, AKThe mechanic's failure to install a whistle slot in the engine breather tube, which resulted in a frozen tube, displacement of the crankshaft oil seal, a loss of oil, and smoke in the cockpit, which led to a forced landing.NTSB WPR17WA026Accident · 1 fatalForeign investigationAir Tractor AT802 · Trangie, AustraliaNTSB DCA17CA096Accident · Serious injuriesData collectionFinal reportBoeing 717 200 · Hopewell, VAthe flight attendant's inadvertent bump into a retractable galley tray.NTSB ANC17LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-300 · McGrath, AKThe failure of the nose landing gear to extend and lock due to the failure of the alternator and reduced battery power due to the cold ambient temperature, which prohibited the electrically-driven hydraulic pump from supplying adequate hydraulic pressure to…NTSB GAA17CA079Accident · No injuriesData collectionFinal reportCessna 172 · Dayton, TNThe student pilot’s inability to maintain pitch and bank control during the landing after the airplane was struck by a deer.NTSB ERA17FA052Accident · 1 fatalField investigationFinal reportRyan Navion · New Gretna, NJThe pilot's inadequate preflight weather planning and in-flight weather evaluation, which resulted in an encounter with a strong cold front and the pilot's subsequent loss of airplane control.NTSB WPR17FA024Accident · 4 fatalField investigationFinal reportPiper PA 31T · Elko, NVA loss of engine power to the left engine for reasons that could not be determined due to the extensive fire and impact damage to the airplane.