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 ENG17IA017Incident · No injuriesIncident investigationFinal reportDouglas DC 9 83 · Dayton, OHThe probable cause of the No. 2 (right) engine fire was an uncontained generator failure. Deformed rotating generator components and/or metal fragments radially released by the generator severed the constant speed drive-to-oil cooler return line located…NTSB DCA17WA137Incident · No injuriesForeign investigationBoeing 767 · Amsterdam, NetherlandsThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 767, which occurred on March 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB CEN17LA145Accident · No injuriesLimited investigationFinal reportCessna 120 · Columbia, ILThe partial loss of engine power due to carburetor icing.NTSB GAA17CA227Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Borrego Springs, CAThe pilot’s selection of an unsuitable takeoff area, which resulted in impact with obstacles.NTSB GAA17CA197Accident · No injuriesData collectionFinal reportCessna R182 · Colorado Springs, COThe pilot’s failure to complete the landing checklist and to extend the landing gear before touchdown.NTSB GAA17CA195Accident · No injuriesData collectionFinal reportIniziative Industriali Italian SKY Arrow 600 Sport · Mosby, MOThe student pilot's failure to maintain directional control during an attempted go-around.NTSB ERA17WA132Accident · Serious injuriesForeign investigationBell 206 · Araucária Municipality, BrazilThe government of Brazil has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on March 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB ENG17WA016Incident · No injuriesForeign investigationSaab 340 · Sydney, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Saab 340B which occurred on March 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of ICAO…NTSB CEN17WA137Accident · 1 fatalForeign investigationCessna 152 · St-Bruno, Quebec, CanadaNTSB CEN17FA132Accident · 1 fatalField investigationFinal reportCessna 210B · Opal, SDThe pilot's loss of airplane control for reasons that could not be determined due to a lack of evidence.NTSB CEN17WA133Accident · No injuriesForeign investigationCessna 172P · Manitouwadge, CanadaOn March 15, 2017, at an unknown time, a Cessna 172P airplane, N230TX, owned and operated by the University of Michigan Flyers Inc. was substantially damaged when it collided with wooded terrain near Manitouwadge, Ontario, Canada. No pilot or occupant was…NTSB CEN17WA130Accident · 1 fatalForeign investigationBell 206 · Figeac, FranceOn March 15, 2017, about 2100 universal coordinated time (UTC), a Bell 206 helicopter, F-GPPH, impacted terrain near Figeac, France. The pilot was fatally injured and the helicopter was destroyed. The flight originated from Poiters Biard (LFBI), France, and…NTSB GAA17CA188Accident · No injuriesData collectionFinal reportPiper PA 12 · Anchorage, AKThe pilot’s failure to maintain directional control during the taxi on skis on hard-packed snow in gusting wind conditions.NTSB CEN17RA131Accident · 4 fatalForeign investigationSikorsky S92 · Blacksod Bay, IrelandOn March 14, 2017, about 1719 universal coordinated time (UTC), a Sikorsky S-92 helicopter, Irish registration EI-ICR, crashed offshore near Blackrock Island West of Blacksod Bay, Ireland. There were 4 occupants. The pilot was fatally injured and 3…NTSB CEN17FA127Accident · 1 fatalField investigationFinal reportMcdonnell Douglas Heli 369FF · Chalmers, INThe pilot's failure to ensure that the needle did not entangle with the tower's vertical lattice as he moved the helicopter rearward, which resulted in the helicopter becoming tethered to the tower and a subsequent loss of control.NTSB GAA17CA146Accident · No injuriesData collectionFinal reportKaman Aerospace K 1200 · Julian, CAThe pilot’s failure to conduct a thru-flight walkaround inspection, which resulted in the engine cowling remaining open and subsequently separating from the helicopter and striking the main rotor blades and vertical stabilizer during departure.NTSB CEN17WA129Accident · 5 fatalForeign investigationMD Helicopter 369 · Mexicali, MexicoOn March 13, 2017, about 1600 hours pacific daylight time, a MD Helicopters model 369FF single-engine helicopter, serial number 0079FF, Mexican registration XC-PEP, collided with high-voltage power lines while maneuvering near Mexicali, Mexico. The pilot and…NTSB CEN17LA126Accident · No injuriesLimited investigationFinal reportCessna 182 · Skiatook, OKThe loss of directional control while taxiing for reasons that could not be determined because postaccident examination of the airplane revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA17CA333Accident · No injuriesData collectionFinal reportSwearingen SA227 TT · Santa Monica, CAThe pilot’s unstabilized approach after encountering wake turbulence, which resulted in a hard landing.NTSB GAA17CA189Accident · No injuriesData collectionFinal reportPiper PA 28 · Gila Bend, AZThe flight instructor’s failure to review the notices to airmen related to the airport, which resulted in his landing on a closed runway and the airplane striking runway closed markers.NTSB GAA17CA186Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, ORThe pilot's failure to maintain directional control during the landing roll in quartering tailwind conditions.NTSB ERA17LA128Accident · No injuriesLimited investigationFinal reportPiper PA28 · Tampa, FLA collapsed engine induction duct, which resulted in restricted air flow to the engine and a subsequent loss of engine power. Contributing to the accident was the operator's failure to ensure that the correct induction duct was installed.NTSB ERA17CA129Accident · Minor injuriesData collectionFinal reportKerns Kenneth H Kens Wingless Wonder · Mount Airy, NCThe pilot’s improper adjustment of the prerotator motor, which resulted in its failure to disengage and the subsequent loss of aircraft control during takeoff.NTSB CEN17WA128Accident · 1 fatalForeign investigationPiper PA25 · Etchoropo, Sonora, MexicoOn March 12, 2017, at 2050 hours universal coordinated time, a Piper PA25-235 airplane, Mexican registration XB-FHP, impacted terrain near Etchoropo, Sonora, Mexico. The pilot was fatally injured. The airplane was destroyed by impact forces.The accident…NTSB CEN17WA125Accident · Serious injuriesForeign investigationRobinson Helicopter Robinson R44 II · Carlingford, IrelandOn March 12, 2017, about 1715 coordinated universal time (UTC), a Robinson Helicopter Company Inc. R44 II helicopter, G-DORM, was destroyed when it impacted terrain during an approach to landing near Carlingford, County Louth, Ireland. The pilot and one…NTSB WPR17LA076Accident · No injuriesLimited investigationFinal reportPiper Aerostar 602P · Reno, NVThe failure of the left main landing gear to fully extend for reasons that could not be determined because postaccident examination and testing did not reveal any evidence of preimpact mechanical failures or malfunctions that would have precluded normal…NTSB WPR17FA077Accident · 1 fatalField investigationFinal reportChallenger II · Oakdale, CAThe pilot's failure to attain a proper touchdown point and his subsequent loss of directional control during landing for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would…NTSB GAA17CA196Accident · No injuriesData collectionFinal reportSchweizer SGS126 · Bangor, PAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in an off-airport landing.NTSB GAA17CA191Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 208 · Kalaupapa, HIThe pilot's attempted aborted landing late in the landing sequence because she saw another airplane on the runway facing her with its propeller turning, which resulted in a hard landing, a subsequent loss of directional control, and ground loop.NTSB GAA17CA190Accident · Minor injuriesData collectionFinal reportDavis Frank R Xenos Motorglider · Minden, NVThe pilot’s failure to maintain directional control in variable wind conditions.NTSB GAA17CA185Accident · No injuriesData collectionFinal reportPipistrel Doo Ajdovscina Virus · Okmulgee, OKThe pilot’s failure to review the Federal Aviation Administration chart supplement before landing, which resulted in his landing on a closed runway and collision with a fence. Contributing to the accident was the airport’s failure to adequately mark the…NTSB GAA17CA184Accident · No injuriesData collectionFinal reportCSP Leasing Cavalon · Santa Maria, CAThe student pilot’s improper landing flare and subsequent failure to maintain crosswind correction during landing in crosswind conditions.NTSB ERA17WA127Accident · 7 fatalForeign investigationSikorsky S76 · Istanbul, TürkiyeOn March 10, 2017, at 0821 coordinated universal time, a Sikorsky S-76C++ helicopter, Turkish registration TC-HEZ, was destroyed shortly after takeoff from the Istanbul Ataturk Airport (LTBA), Istanbul, Turkey. The two pilots and the five passengers were…NTSB DCA17CA079Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas DC 9 83(MD-83) · Dallas-Fort Worth (DFW), TXan inadvertent encounter with convective turbulence.NTSB GAA17CA183Accident · Minor injuriesData collectionFinal reportJohnson Jerry WAG Aero/SPT Trainer · Hendersonville, NCThe pilot’s unstabilized approach and failure to attain the proper touchdown point while attempting to land in gusting crosswind conditions, which resulted in an attempted go-around and collision with trees and power lines.NTSB GAA17CA182Accident · Serious injuriesData collectionFinal reportPedersen Bjarne Martin Sportsman GS-2 · Robbinsville, NJThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA17CA181Accident · No injuriesData collectionFinal reportAerotek Pitts S-2A · West Palm Beach, FLThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA179Accident · No injuriesData collectionFinal reportBurkhart Grob G 109B · Mokuleia, HIThe failure of the upper rudder hinge during flight due to severe corrosion. Contributing to the accident were the pilot’s inadequate preflight inspection and the lack of an annual inspection.NTSB ERA17LA125Accident · Serious injuriesClass 2 · LimitedFinal reportGrob G120TP-A · Abbeville, ALThe flame-out of the engine due to a mis-set fuel control unit at the time of manufacture. Contributing to the accident was the pilots’ delayed recognition that the engine had flamed out, partially due to the operator’s requirement to disable the crew…NTSB ERA17FA123Accident · 1 fatalField investigationFinal reportJordan Bruce C Pitts S2E · Apex, NCThe pilot's failure to maintain airplane control during the final approach to the runway in gusting tailwind conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB DCA17FA076Accident · Minor injuriesClass 1 · FieldFinal reportMcdonnell Douglas MD80 · Ypsilanti, MIthe jammed condition of the airplane's right elevator, which resulted from exposure to localized, dynamic wind while the airplane was parked and rendered the airplane unable to rotate during takeoff. Contributing to the accident were (1) the effect of a large…NTSB WPR17FA074Accident · 1 fatalField investigationFinal reportQuicksilver MXL II · Hesperia, CAThe pilot's failure to identify and correct his construction error of a critical structural component, which resulted in a loss of airplane control during takeoff. Contributing to the accident was the pilot's impairment due to his combined use of multiple…NTSB GAA17CA192Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Laramie, WYThe pilot’s decision to land with a crosswind that exceeded the airplane’s demonstrated capability, which resulted in the airplane banking left and the wing striking the ground.NTSB DCA17WA121Incident · No injuriesForeign investigationBoeing 737 · Sint Maarten, NTThe government of Netherlands Antilles has notified the NTSB of an accident involving a BOEING 737 that occurred on March 07, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Netherlands Antilles's investigation under…NTSB DCA17CA087Accident · Serious injuriesData collectionFinal reportAirbus A319 114 · Los Angeles, CAmalfunction of the parking brake electrical control valve that resulted in a sudden stop.NTSB ANC17FA018Accident · 1 fatalField investigationFinal reportCessna R172K · Nome, AKThe pilot's improper decision to conduct multiple visual approaches to the destination airport despite the night instrument meteorological conditions; the airplane's low fuel state at that time, which resulted in a total loss of engine power due to fuel…NTSB GAA17CA174Accident · Minor injuriesData collectionFinal reportLancair Columbia 400 · Henderson, NVThe pilot’s improper decision to land the airplane with a gusting crosswind, which resulted in a loss of airplane control.NTSB ERA17LA120Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150J · Argyle, NYA total loss of engine power for undetermined reasons, which resulted in a forced landing and subsequent impact with trees.NTSB DCA17WA075Incident · No injuriesForeign investigationBoeing 777 · Cancun, MexicoThe Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on March 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…NTSB ANC17RA019Accident · 9 fatalForeign investigationBell 412 · Matsumoto, Japanimport