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 ERA18LA002Accident · 1 fatalLimited investigationFinal reportCessna 182 · San Juan, PRThe pilot's failure to maintain adequate distance from helicopters during the approach for landing, resulting in an encounter with wake turbulence and subsequent loss of control.NTSB DCA18CA001Accident · No injuriesData collectionFinal reportBoeing 737 7H4 · Chicago, ILthe mechanical failure of the tugs fuel governor, which made it difficult for the ramp agent to stop the tug. Contributing to the accident was the lack of guidance on how ground personnel were to handle vehicle malfunctions.NTSB CEN18LA002Accident · Serious injuriesLimited investigationFinal reportCharles A Brazil MTO Sport · McCoy, TXThe pilot’s failure to maintain clearance from a powerline during landing.NTSB WPR18FA001Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Klamath Falls, ORThe noninstrument rated pilot's decision to depart on a cross-country flight with en route weather conditions forecasted to be less than visual meteorological conditions and then to continue flight into instrument meteorological conditions, which resulted in…NTSB GAA18CA021Accident · Minor injuriesData collectionFinal reportPiper PA32R · Block Island, RIThe pilot's use of an incorrect airspeed during landing, which resulted in a runway overrun.NTSB CEN18FA001Accident · 1 fatalField investigationFinal reportBrantly B 2B · Midland, MIThe pilot's failure to maintain control of the helicopter, which resulted in a loss of tail rotor effectiveness, and his failure to promptly initiate the proper recovery technique, which resulted in a descent that could not be arrested before impacting the…NTSB ANC18RA001Accident · 1 fatalForeign investigationRobinson R44 · Campbell River, CanadaNTSB WPR17FA215Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Brinnon, WAThe flight instructor's failure to completely and properly evaluate the student pilot's incorrectly- planned flight, and his failure to use all available resources to maintain situation awareness during the flight, which resulted in controlled flight into…NTSB GAA17CA566Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Hampshire, ILThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.NTSB ENG17RA039Accident · No injuriesForeign investigationAirbus A380 · Goose Bay, CanadaOn September 30, 2017, an Air France A380 operating as flight AF 66 from Paris, France to Los Angeles, California had the No. 4 engine's inlet and fan rotor separate from the remainder of the engine. The airplane diverted to Goose Bay, Canada for landing. The…NTSB DCA17CA214Accident · No injuriesData collectionFinal reportBoeing 737 823 · Arlington, VAThe failure N841NNs captain to maintain appropriate clearance from N982VJ, which was stopped on the taxiway.NTSB GAA17CA581Accident · No injuriesData collectionFinal reportCessna 414 · San Jose, CAThe pilot’s failure to maintain a proper descent rate, which resulted in a hard landing.NTSB DCA17WA215Incident · No injuriesForeign investigationBoeing 737 · Budapest, HungaryThe Ministry of National Development Transport Safety Bureau of Hungary has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on September 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB CEN17CA371Accident · No injuriesData collectionFinal reportVans RV7 · Itasca, TXThe pilot’s inadequate preflight planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA17CA575Accident · No injuriesData collectionFinal reportSilvaire 8 · Texarkana, ARThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA564Accident · No injuriesData collectionFinal reportBoeing PT 13 · Skagit, WAThe pilot’s failure to maintain clearance from airport lighting during the landing roll.NTSB GAA17CA563Accident · No injuriesData collectionFinal reportPiper PA 22 · Orangeburg, SCA failed main landing gear tire for reasons that could not be determined due to postcrash fire damage.NTSB ERA17WA342Accident · 1 fatalForeign investigationRobinson R44 · Cape Town, South AfricaOn September 28, 2017, about 1000 coordinated universal time, a Robinson R44 II helicopter, South African registration ZS-OSL, was destroyed when it impacted terrain during an emergency autorotation near Cape Town, South Africa. The pilot was fatally injured.…NTSB ERA17LA341Accident · No injuriesLimited investigationFinal reportCessna 162 · Huntsville, ALThe flight instructor’s failure to use carburetor heat, which resulted in the total loss of engine power due to carburetor icing.NTSB ERA17LA340Accident · Minor injuriesLimited investigationFinal reportWaco UPF 7 · Ocklawaha, FLA failure of both magnetos due to multiple deficiencies, which resulted in a total loss of engine power.NTSB ERA17FA339Accident · 1 fatalField investigationFinal reportHickox Andy Andys Gyroplane · Umatilla, FLThe pilot's improper response to a total loss of engine power, which resulted in main rotor blade contact with the rudder and vertical stabilizer, and a subsequent uncontrolled descent. The loss of engine power was due to the separation of the electrical…NTSB DCA17WA216Incident · No injuriesForeign investigationBoeing 737 · Luga, MaltaThe United Kingdom Air Accident Investigation Branch (AAIB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation…NTSB CEN17LA372Accident · No injuriesLimited investigationFinal reportPiper PA 25-235 · Westphalia, KSA total loss of engine power due to a fatigue failure of the crankshaft that resulted from main bearing shift and lack of lubrication.NTSB GAA17CA572Accident · No injuriesData collectionFinal reportCub Crafters CC19-180 · Kalispell, MTThe pilot’s inadvertent brake application during the landing roll, which resulted in a loss of directional control.NTSB GAA17CA562Accident · Minor injuriesData collectionFinal reportEurocopter AS 350 · Fullerton, CAThe pilot under evaluation’s failure to maintain adequate airspeed during a simulated hydraulic failure, which resulted in a loss of helicopter control. Contributing to the accident was the check pilot’s delayed remedial action.NTSB GAA17CA561Accident · No injuriesData collectionFinal reportAmerican Legend AL18 · Bessemer, ALThe student pilot’s incorrect application of the brakes and subsequent failure to maintain directional control during the landing roll. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB GAA17CA560Accident · Minor injuriesData collectionFinal reportPiper J5A · Geneseo, NYThe pilot's failure to properly secure the airplane before a hand propeller start, which resulted in the airplane moving forward and colliding with maintenance equipment.NTSB GAA17CA559Accident · No injuriesData collectionFinal reportCessna 182 · San Diego, CAThe airplane’s inadvertent entry into instrument meteorological, dark night conditions and the pilot’s failure to maintain an adequate approach for landing.NTSB ERA17LA336Accident · No injuriesLimited investigationFinal reportCessna 152 · Winder, GAThe pilot's inadequate preflight inspection, which resulted in undetected water in the fuel system and a total loss of engine power during the initial climb.NTSB DCA17WA226Incident · No injuriesForeign investigationAirbus A320 · Dublin, IrelandThe Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of a serious incident involving a AIRBUS A320 airplane that occurred on September 27, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB CEN17LA376Accident · No injuriesLimited investigationFinal reportCessna 182M · Piqua, OHThe accumulation of carburetor ice while operating at a reduced engine power setting, which resulted in a total loss of engine power on approach and a subsequent forced landing on unsuitable terrain.NTSB WPR17LA217Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Los Angeles, CAThe pilot's failure to extend the landing gear before landing.NTSB GAA17CA565Accident · No injuriesData collectionFinal reportPiper PA18 · Holy Cross, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB GAA17CA557Accident · Minor injuriesData collectionFinal reportBellet James J Vans RV 8 · Orange, MAThe pilot's failure to remove the engine cowl plugs during preflight, which resulted in excessive engine cylinder head temperatures during climb and a total loss of engine power.NTSB ERA17WA344Accident · 2 fatalForeign investigationCessna 150 · BahamasOn September 26, 2017, a Cessna 150G, N3214X, went missing and was presumed to be substantially damaged. The private pilot and passenger were also missing, and presumed to be fatally injured. As of October 30, 2017, the airplane had not been found. A visual…NTSB CEN17WA369Accident · 1 fatalForeign investigationMD Helicopter 369 · Norrbotten, Sweden, SwedenOn September 26, 2017, about 1154 hours universal coordinated time, an MD Helicopters 369D, Swedish registration SE-JVI, impacted terrain about one-third mile from the Alvsbyn Airport (ESUV), Norrbotten, Sweden. One pilot was fatally injured and the second…NTSB WPR17LA216Accident · No injuriesLimited investigationFinal reportCessna 172P · TamuningThe pilot's inadequate preflight inspection, which resulted in oil exhaustion and a subsequent total loss of engine power during cruise flight.NTSB GAA17CA569Accident · No injuriesData collectionFinal reportPiper PA 18 · Beluga, AKThe pilot’s inability to maintain pitch control due to an encounter with a tailwind gust after the airplane had stopped, which resulted in a nose-over.NTSB ERA17LA335Accident · Minor injuriesClass 3 · LimitedFinal reportBrad J Bates Mosquito XE 285 · Odessa, FLA total loss of engine power due to cold seizure of the No.1 piston, which resulted in its failure and a subsequent emergency autorotation and impact with a house’s roof.NTSB DCA17CA217Accident · Serious injuriesData collectionFinal reportBoeing 737-8H4 · Sioux City, IAthe flight attendant accidentally pouring hot water on his hand which resulted in a 2nd degree burn.NTSB CEN17LA368Accident · 1 fatalLimited investigationFinal reportEris E. Ervin Quicksilver · Cleburne, TXAn engine loss of power due to fuel starvation from a broken fuel line between the fuel tank and the engine; the loss of engine power prevented the pilot from reaching a suitable landing area. Contributing to the accident was the inadequate maintenance of the…NTSB GAA17CA553Accident · No injuriesData collectionFinal reportAerotrike Safari · Bridgeton, NJThe pilot’s improper landing flare, which resulted in a hard landing while conducting an off-airport precautionary landing after a bird strike.NTSB GAA17CA551Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Santa Barbara, CAThe student pilot’s unstabilized hover, which resulted in ground contact and a dynamic rollover. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA17LA334Accident · Serious injuriesLimited investigationFinal reportMcmillan Joel L Avid SW 65 · Darlington, SCA total loss of engine power due to fuel starvation as a result of a clogged fuel filter.NTSB ERA17LA333Accident · Serious injuriesLimited investigationFinal reportBuschmann/Vanzee Vari EZ · Ambler, PAWater contamination of the fuel that was not detected during a preflight inspection, which resulted in a total loss of engine power.NTSB CEN17LA366Accident · No injuriesLimited investigationFinal reportEmerson Kitfox · Waller, TXA partial loss of engine power for reasons that could not be determined based on the available information.NTSB CEN17FA364Accident · 2 fatalField investigationFinal reportBeech C35 · Camden, ARThe pilot's improper decision to return to the runway instead of landing straight ahead when the engine lost power and his failure to maintain adequate airspeed while maneuvering for an emergency landing, which resulted in an exceedance of the airplane's…NTSB WPR17LA214Accident · No injuriesLimited investigationFinal reportSC Aerostar YAK 52W · El Cajon, CAThe pilot's failure to maintain directional control during taxi after a reduction in braking performance and steering capabilities due to his failure to reopen the air supply valve after the nonstandard engine start.NTSB WPR17LA212Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Glendale, CAThe pilot’s inadequate preflight fuel planning and improper decision to not refuel before the flight, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB ERA17LA332Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Clearwater, FLThe airplane pilot's inadequate visual lookout, which resulted in an in-flight collision with a helicopter. Contributing to the accident was the airplane pilot's failure to adequately transmit his position while operating in the airport traffic pattern.