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 CEN11LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Robstown, TXThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB CEN11LA048Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Waterloo, IAThe separation of a stabilator control cable turnbuckle due to stress corrosion cracking, which resulted in a loss of airplane control during takeoff.NTSB CEN11LA045Accident · Serious injuriesLimited investigationFinal reportWalker Kenneth Sonex · San Angelo, TXThe pilot's loss of airplane control. Contributing to the accident was the pilot's impairment due to alcohol.NTSB CEN11LA043Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Port Mansfield, TXThe total loss of engine power for undetermined reasons because examination of the airframe and engine did not reveal any anomalies that would have contributed to the loss of engine power.NTSB CEN11CA052Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Stockport, OHThe pilot's inadvertent movement of the throttle control during landing, which resulted in an increase in power and excursion from the runway.NTSB CEN11CA047Accident · No injuriesData collectionFinal reportAardema Robert John 1 Aardema RAG WNG SP · Oshtemo, MIThe failure of the ignition system wiring, which resulted in a total loss of engine power.NTSB CEN11CA046Accident · No injuriesData collectionFinal reportHughes J/Hughes J Rand-Robinson · Pearland, TXThe pilot's improper flare, which resulted in a hard landing. Contributing to the accident was an engine oil leak which partially obscured the pilot’s forward vision.NTSB ERA11FA038Accident · 1 fatalField investigationFinal reportCessna 210A · Aiken, SCThe pilot's inadequate weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot’s…NTSB ERA11CA047Accident · No injuriesData collectionFinal reportCessna 177RG · Bedford, KYThe mechanic's failure to properly secure a fuel line when it was reinstalled during an engine inspection.NTSB ERA11CA040Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Julian, NCThe pilot's failure to attain the proper touchdown point.NTSB ERA11CA039Accident · No injuriesData collectionFinal reportCessna 172P · Tampa, FLThe student pilot's failure to maintain directional control during a short-field takeoff.NTSB WPR11CA033Accident · No injuriesData collectionFinal reportMedway Raven · Benson, AZThe pilot's inadequate evaluation of the runway condition and failure to maintain directional control during takeoff.NTSB WPR11CA030Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Pahrump, NVThe pilot's inadvertent activation of brakes upon touchdown, resulting in a loss of directional control.NTSB ERA11LA037Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Aguadilla, PRThe pilot's improper decision to ditch the airplane after a reported partial loss of engine power and overheat on one engine for undetermined reasons.NTSB DCA11FA004Accident · No injuriesField investigationFinal reportBoeing 757-223 · Miami, FLFatigue failure of the fuselage crown skin due to incorrect manufacturing of the crown skin panel that resulted in a skin thickness less than the manufacturer-specified thickness.NTSB CEN11LA041Accident · 1 fatalLimited investigationFinal reportDonegan Benton Kitfox II · Seguin, TXThe pilot’s failure to ensure adequate fuel on board and subsequent failure to maintain airplane control following an engine failure due to fuel exhaustion.NTSB ERA11FA036Accident · 2 fatalField investigationFinal reportBeech B36TC · Rienzi, MSThe pilot's continued flight into known adverse weather conditions. Contributing to the accident was the air traffic controller's failure to provide precipitation information to the pilot as required.NTSB WPR11FA032Accident · 4 fatalField investigationFinal reportMooney M20J · Lander, WYThe pilot's decision to depart into known adverse weather conditions over mountainous terrain, which required operation near the limits of the airplane's performance capability and which resulted in a loss of airplane control and subsequent ground impact.…NTSB WPR11FA029Accident · 3 fatalField investigationFinal reportCessna 340A · Morton, WAThe pilot’s failure to arrest the excessive rate of turn into the failed engine, which resulted in a loss of control and subsequent impact with terrain. Contributing to the accident was a partial loss of engine power for reasons that could not be determined…NTSB CEN11LA034Accident · No injuriesLimited investigationFinal reportCessna T210N · Presidio, TXA loss of engine power due to fuel exhaustion for undetermined reasons.NTSB WPR11LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-236 · Dorrington, CAThe pilot’s failure to use carburetor heat while cruising in carburetor icing conditions, which resulted in a loss of engine power.NTSB WPR11FA027Accident · 2 fatalField investigationFinal reportReed Glasair III SH-3R · Lake Mathews, CAThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude beneath a cloud layer.NTSB WPR11CA026Accident · No injuriesData collectionFinal reportCessna 340A · Camp Verde, AZThe pilot's misjudged approach and failure to attain the correct touchdown point, which resulted in a runway overrun.NTSB ERA11CA052Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Cambridge, MDThe commercial pilot’s inadequate flare during landing and the certificated flight instructor's delayed remedial action, which resulted in a hard landing.NTSB DCA11WA114Accident · 1 fatalForeign investigationPiper PA32 - 301 · Vipingo Ridge, KenyaOn October 23, 2010, about 0653 UTC, 5Y-NAM, a Piper PA-32R-301, a personal flight, had an inflight breakup during cruise flight and crashed in an open field at Vipingo Ridge, Kenya. The pilot, the sole occupant, was fatally injured. The aircraft was…NTSB CEN11WA042Accident · 3 fatalForeign investigationAgusta A109 · New Castle, United KingdomNTSB CEN11CA036Accident · Minor injuriesData collectionFinal reportFrederick R Goenne Glastar · Recklaw, TXThe pilot's failure to maintain directional control during the landing roll on a rough runway surface.NTSB WPR11CA024Accident · No injuriesData collectionFinal reportCessna 185 · Fort Thomas, AZThe airplane's encounter with a dust devil during landing rollout, which resulted in the pilot not being able to maintain directional control.NTSB CEN11CA033Accident · Minor injuriesData collectionFinal reportMcClish B85C · New Baden, ILThe pilot's failure to maintain control of the airplane during landing.NTSB WPR11FA021Accident · 3 fatalField investigationFinal reportCirrus Design SR-22 · Agua Dulce, CAThe non-instrument-rated pilot's improper decision to continue the flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control.NTSB WPR11CA023Accident · No injuriesData collectionFinal reportAir Tractor AT-802 · Fort Hunter Liggett, CAThe pilot's misjudged glide path, which resulted in a runway undershoot and collision with terrain during landing.NTSB WPR11CA022Accident · Minor injuriesData collectionFinal reportRotherwick Glasair III · Colville, WAThe pilot's misjudged approach and failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB ERA11LA033Accident · No injuriesLimited investigationFinal reportRockwell International 112TC · Waynesboro, GAThe pilot’s deliberate exiting of the airplane by parachute while in flight following a reported flight control malfunction that could not be verified.NTSB ERA11CA030Accident · Minor injuriesData collectionFinal reportCirrus SR20 · Sanford, FLThe student pilot's loss of directional control during a go-around maneuver following a bounced landing.NTSB CEN11IA106Incident · No injuriesIncident investigationFinal reportPiper PA-46-500TP · Olathe, KSThe loss of engine power for undetermined reasons.NTSB CEN11FA040Accident · 1 fatalField investigationFinal reportBeech 95-B55 (T42A) · Clarion, IAThe pilot's failure to maintain control of the airplane. Contributing to the accident was the loss of left engine power for undetermined reasons.NTSB OPS11IA054Incident · No injuriesIncident investigationFinal reportDassault FALCON900EX · Teterboro, NJThe pilot of the F900 overshooting of the final approach course, which conflicted with traffic in the pattern. Contributing to the accident was the lack of appropriate coordination between the tower controller and the approach controller.NTSB ERA11WA031Accident · 5 fatalForeign investigationCessna TU206G · Medellin, ColombiaOn October 20, 2010, about 1300 Universal Coordinated Time (UTC), a Cessna TU206G, Columbian registration HK2933, was destroyed by fire after crashing in Path Shipyards, Medellin, Columbia. The flight was en route from Medellin, (SKMD), to Fort Vigia,…NTSB ERA11CA034Accident · Minor injuriesData collectionFinal reportBoeing A75 · Douglas, GAA nose-over due to excessive brake application.NTSB CEN11CA059Accident · No injuriesData collectionFinal reportHawker MK-20 Sea Fury · Breakenridge, TXThe improperly adjusted brakes and the pilot's failure to lock the tailwheel, resulting in a loss of directional control. Contributing to the accident was the pilot's decision to continue flying the airplane with a known brake deficiency.NTSB WPR11CA028Accident · No injuriesData collectionFinal reportCessna 195 · Wells, NVThe pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB ERA11CA027Accident · No injuriesData collectionFinal reportPiper PA28 · Titusville, FLAn inadvertent collision with a deer during a night takeoff.NTSB CEN11CA038Accident · No injuriesData collectionFinal reportCessna 182L · Mancelona, MIA loss of engine power in flight due to the failure of the engine's No. 5 piston.NTSB WPR11WA020Accident · 2 fatalForeign investigationCessna 172 · Durham Downs, Australia, AustraliaOn October 18, 2010, at 1230 universal coordinated time, a Cessna 172S, VH-VSK, collided with the terrain near Durham Downs, Australia. The airplane was operated by S. Kidman & Co LTD. The pilot and passenger were killed and the airplane was substantially…NTSB WPR11IA019Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Phoenix, AZThe overextension of the main cabin door due to difficulty opening the door because the power-assist motor cable was lodged within the main cabin door assembly.NTSB ERA11LA025Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Warren, VTThe pilot's inadvertent deployment of the airbrake handle past the upper limit of its normal operating range, which resulted in binding of the controls.NTSB ERA11IA026Incident · No injuriesIncident investigationFinal reportShort Bros. & Harland Shorts SC7 Skyvan · Fort Lauderdale, FLThe flightcrew’s failure to maintain directional control while initiating an engine reverse after landing.NTSB ERA11CA029Accident · No injuriesData collectionFinal reportSqueglia R/Wheeler W Hummel Bird · Hollywood, FLThe pilot's inadequate flare, which resulted in a hard landing.NTSB CEN11TA027Accident · No injuriesFinal reportBeech A100 · Palestine, TXAn in-flight collision with a flock of birds while the airplane was descending through a cloud layer.NTSB CEN11FA029Accident · 2 fatalField investigationFinal reportAmerican Champion 8KCAB · Sebewaing, MIThe pilot's failure to maintain airspeed and aircraft control following a loss of engine power after takeoff.