NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 FTW98LA131Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Lafayette, LAThe unsecured squat switch wires located in the nose gear that were crimped (damaged) when the landing gear was retracted and shorted, resulting in an in-flight fire. A factor was the failure of the landing gear to extend during the emergency descent/landing.NTSB CHI98LA097Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Peoria, ILan improper preflight inspection of the airplane by the pilot and the inadvertant stall/mush which was encountered. A factor associated with this accident was the pilot's decision to continue to use the emergency hydraulic hand pump rather than the CO2 bottle…NTSB ANC98LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot's continued VFR over-the-top operation, becoming lost/disoriented, his inadequate in-flight planning/decision making, and subsequent fuel exhaustion. Factors in the accident were the presence of a cloud layer below the pilot's selected altitude, the…NTSB NYC98LA068Accident · No injuriesLimited investigationFinal reportZwart KIT FOX Vixen · Weyers Cave, VAThe failure of the propeller drive train after the pilot/builder installed an improper drive belt.NTSB NYC98LA067Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Brookville, OHThe pilot's misjudgment of the fuel supply.NTSB NYC98FA066Accident · 1 fatalField investigationFinal reportCessna 172P · York, PAThe pilot's failure to maintain airspeed during final approach which resulted in an inadvertent stall/spin.NTSB MIA98LA081Accident · No injuriesLimited investigationFinal reportCessna 150A · Gulf Of Mexicoa loss of engine power due to undermined reason resulting in a forced landing, and an in- flight collision with water.NTSB LAX98LA094Accident · No injuriesLimited investigationFinal reportPiper J3 · Chandler, AZThe pilot's failure to maintain directional control of the airplane.NTSB LAX98FA091Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Sutter, CAThe pilot's in-flight decision(s) to attempt VFR flight in instrument meteorological conditions at an altitude which did not provide for adequate terrain clearance requirements. A factor that contributed to the accident was the pilot's decision to disregard…NTSB FTW98IA130Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Lawton, OKthe collapse of the left main landing gear during landing roll as result of a shorted weight-on-wheels relay. Contributing factors were the insufficient information available to the flight crew in the company's quick reference handbook (QRH), and the…NTSB CHI98FA096Accident · 2 fatalField investigationFinal reportWasielak Sonerai II L · Malta, ILThe pilot's failed to maintain adequate clearance from the other aircraft.NTSB ATL98LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Fayetteville, NCfuel system contamination (rubber shavings), which led to blockage of a fuel line, fuel starvation, loss of engine power, and a collision with terrain.NTSB ATL98FA053Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Clinton, MSThe pilot's lack of recent instrument flight experience that led to spatial disorientation and loss of airplane control; and his improper use of carburetor heat that resulted in a loss of engine power and subsequent collision with the ground during an…NTSB ANC98LA021Accident · No injuriesLimited investigationFinal reportCessna 180H · Anchorage, AKThe pilot's failure to attain the proper touchdown point on the runway. Factors in the accident were: snow covered terrain at the approach end of the runway and flat light conditions.NTSB ATL98LA051Accident · Minor injuriesLimited investigationFinal reportPZL-Bielsko SZD-48-3 · Pikeville, TNThe loss of thermal lift.NTSB ATL98LA050Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Perry Foley, FLa loose (or missing) carburetor drain plug and fuel line, due to an inadequate maintenance/annual inspection, which resulted in a fuel leak, fuel exhaustion, loss of engine power, and a forced landing. The obstructions (trees in the emergency landing area)…NTSB ATL98LA049Accident · Serious injuriesLimited investigationFinal reportTankersley Europa MONO-WHEEL · Fernandina Bch, FLa partial loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed.NTSB ATL98LA048Accident · No injuriesLimited investigationFinal reportCessna 210 · Hazel Green, ALthe pilot's improper flare, which resulted in a hard landing and the nose gear collapsing.NTSB MIA98LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Graniteville, SCfailure of the number three exhaust valve, which resulted in loss of engine power and a forced landing. Related factors were: the obstructions (earthen embankment and fence) in the emergency (forced) landing area.NTSB FTW98LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKFuel exhaustion due to the student pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB SEA98LA038Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Stanwood, WAThe pilot's failure to apply carburetor heat. Factors included carburetor icing conditions and soft terrain in the forced landing area.NTSB MIA98LA080Accident · No injuriesLimited investigationFinal reportCessna 172H · St. Petersburg, FLa sudden encounter with wind gusts associated with a quickly passing rain shower which resulted in a nose-over, and subsequent collision with the runway.NTSB CHI98LA094Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Wood Lake, NEthe pilot's intentional flight into adverse weather conditions, the wing ice, and the inadvertent stall. Factors contributing to this accident were the rain, freezing rain and low ceilings.NTSB ATL98FA047Accident · 2 fatalField investigationFinal reportSchweizer SA 2-37A · Green Cove Sprg, FLloss of engine power for undetermined reason(s); and failure of the pilot to maintain adequate airspeed, while maneuvering the airplane for a forced landing, which resulted in an inadvertent stall, uncontrolled descent, and collision with a house boat…NTSB LAX98LA090Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Wasco, CAThe pilot overboosting the engine on takeoff which resulted in a cracked cylinder and subsequent loss of engine power.NTSB IAD98LA028Accident · No injuriesLimited investigationFinal reportBeech 55B · Buffalo, NYImproper use of the fuel selector, which resulted in fuel starvation and loss of engine power.NTSB ATL98LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Americus, GAthe pilot's improper planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing on unprepared terrain.NTSB DCA98WA024Incident · No injuriesForeign investigationBoeing 757-200 · Brussels, BelgiumNTSB ATL98LA045Accident · No injuriesLimited investigationFinal reportPitts S-2A · New Smyrna Beac, FLThe loss of engine power for undetermined reasons, and, the jammed engine starter drive assembly, that prevented an engine restart in flight. A factor was the soft terrain.NTSB IAD98FA027Accident · 2 fatalField investigationFinal reportBeech C-90 · Newton, WVThe pilot inadequate management of the fuel system which resulted in fuel starvation to both engines. Factors in the accident were the pilot's concern about maintenance being completed prior to executing a scheduled flight later in the day, and operating the…NTSB DCA98WA044Accident · No injuriesForeign investigationAirbus Industrie A300B4-62R · TaiwanNTSB CHI98IA095Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-212 · Memphis, TNthe inadequate (bronze) material used by the fuel pump's manufacturer, which wore and ultimately blocked the fuel filter bypass and partially blocked the fuel nozzles, causing the fuel spray to burn through the low pressure turbine case.NTSB SEA98LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Bridger, MTThe student pilot's failure to maintain airspeed during a bounced landing recovery.NTSB SEA98LA036Accident · No injuriesLimited investigationFinal reportPiper PA-17 · Bozeman, MTThe pilot's failure to maintain directional control during takeoff.NTSB FTW98LA129Accident · No injuriesLimited investigationFinal reportEnstrom F-28C-2 · Broomfield, COwater contamination in the fuel, which resulted in loss of engine power and a forced (autorotative) landing. Factors relating to the accident were: darkness; and a high obstruction in the emergency landing area.NTSB ATL98LA043Accident · Minor injuriesLimited investigationFinal reportWilde Mickey Questair 20 · Greensboro, NCThe improper installation of the nose landing gear strut, which led to the collapse of the nose gear upon touchdown.NTSB NYC98LA122Accident · Serious injuriesLimited investigationFinal reportGoins Sonerai II LTS · Suffolk, VAThe pilot's failure to maintain directional control during the initial takeoff climb. Factors related to the accident were habit interference, the pilot's lack of experience in the make and model, and the trees.NTSB MIA98FA079Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Fort Pierce, FLThe pilot's continued visual flight rules into instrument flight rules conditions and his failure to maintain altitude after encountering instrument flight rules conditions resulting in the aircraft colliding with powerlines and crashing. A factor in the…NTSB FTW98FA127Accident · 1 fatalField investigationFinal reportIreneusz Rans S-12 · Rockwall, TXThe pilot's failure to maintain clearance while performing low altitude flight over the water.NTSB ATL98LA044Accident · No injuriesLimited investigationFinal reportCharles Holmes Kitfox XL · Homestead, FLThe student pilot's improper touchdown flare during landing.NTSB ATL98LA042Accident · No injuriesLimited investigationFinal reportAviat A-1 · Clearwater, FLfailure of the pilot to maintain adequate airspeed, while maneuvering to pick up a banner, which led to a stall, loss of altitude, and collision with the water.NTSB LAX98LA089Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Chico, CAFuel exhaustion due to the pilot's failure to ensure that an adequate fuel supply was onboard. A contributing factor was related to the fuel quantity gage's erroneous indication of fuel.NTSB LAX98LA087Accident · No injuriesLimited investigationFinal reportCessna 195 · Carefree, AZThe pilot's misjudging the wind direction and his selection of the wrong runway for the landing attempt.NTSB LAX98FA086Accident · 1 fatalField investigationFinal reportBeech J35 · Morgan Hill, CAThe pilot-in-command's failure to maintain visual separation from N8343D approaching from his right. The controller's failure to provide a traffic advisory and the copilot's and flight engineer's inadequate visual lookout were factors.NTSB FTW98MA126Accident · Serious injuriesMajor investigationFinal reportEmbraer 145-ER · Beaumont, TXThe first officer's improper use of the rudder when given a simulated engine failure on takeoff and the pilot-in-command's delayed remedial action which resulted in a loss of control. A factor was the first officer's lack of experience in the regional jet…NTSB FTW98LA128Accident · No injuriesLimited investigationFinal reportBeech 23 · Colorado Sprngs, COThe pilot's inadvertent porpoise during landing roll. A factor was the ditch.NTSB MIA98LA077Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Georgetown, SCthe pilot's decision to attempt a takeoff from an unsuitable area of roadway, following a forced landing after the engine had lost power, due to fuel exhaustion; and his failure to maintain clearance from obstructions, while attempting the takeoff. The…NTSB LAX98LA088Accident · No injuriesLimited investigationFinal reportCessna 182P · Payson, AZThe collapse of the nose landing gear for undetermined reasons.NTSB LAX98IA085Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-51 · Honolulu, HIthe disintegration of the No. 6 bearing in the No. 2 engine which resulted in an aborted takeoff. In addition, the malfunction of the slide in the right forward service door was the result of a faulty seal in the inflation system. The inflation gauge had not…NTSB DCA98MA023Accident · Minor injuriesClass 1 · MajorFinal reportBoeing 727-223 · Chicago, ILthe failure of the flight crew to maintain a proper pitch attitude for a successful landing or go-around. Contributing to the accident were the divergent pitch oscillations of the airplane, which occurred during the final approach and were the result of an…