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 CEN10CA167Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Sugar Land, TXThe pilot's failure to maintain a proper glidepath and rate of descent during approach, resulting in a hard landing.NTSB WPR10CA175Accident · No injuriesData collectionFinal reportBeech 23 · Twenty Nine Palms, CAThe pilot's encounter with a wind shear/downdraft that exceeded the climb performance capabilities of the airplane during initial climb.NTSB WPR10CA172Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe flight instructor's failure to attain and maintain adequate airspeed while demonstrating a soft-field takeoff.NTSB ERA10LA193Accident · No injuriesLimited investigationFinal reportBeech B95 · Lumberton, NJThe pilot's inadvertent retraction of the landing gear during the landing rollout.NTSB ERA10CA192Accident · No injuriesData collectionFinal reportCessna 172 · Farmingdale, NYThe student pilot's improper flare and recovery from a bounced landing.NTSB ERA10CA181Accident · No injuriesData collectionFinal reportCessna 172M · Connelsville, PAA total loss of engine power due to fuel exhaustion due to the pilot's failure to refuel.NTSB WPR10FA163Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Morton, WAThe failure of maintenance personnel to properly secure a fitting cap on the throttle and metering assembly inlet after conducting a fuel system pressure check, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was…NTSB OPS10IA015Incident · No injuriesIncident investigationFinal reportCessna 208B · Phoenix, AZThe Cessna 208 pilot’s failure to identify the correct landing runway.NTSB ERA10FA180Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Williston, FLThe pilots of both airplanes did not maintain an adequate visual lookout to see and avoid each other.NTSB CEN10CA172Accident · No injuriesData collectionFinal reportKinney Kevin Zenith 601XL · Warren, OHA total loss of engine power due to the failure of an oil hose due to improper installation of the hose.NTSB ERA10LA179Accident · No injuriesLimited investigationFinal reportFerguson William C FX4-2 · Cartersville, GAThe failure of the engine-driven oil pump drive coupling resulting in a loss lubrication and subsequent loss of engine power.NTSB WPR10LA171Accident · No injuriesLimited investigationFinal reportCarr RV-4 · Arlington, WAThe failure of both main landing gear's drag link bolts in overstress and the subsequent collapse of the landing gear during landing rollout.NTSB WPR10LA169Accident · Serious injuriesLimited investigationFinal reportUltramagic S-160 · Rancho Santa Fe, CAA reduction of burner/heat production due to low fuel. Contributing to the accident was the pilot's continued flight with a low fuel status.NTSB WPR10CA170Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Phoenix, AZThe student pilot's inadequate compensation for the quartering tailwind during landing and the flight instructor's delay in taking remedial action.NTSB ERA10FA178Accident · 1 fatalField investigationFinal reportBeech 95 · Lagrange, NYThe pilot’s failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB DCA10WA047Incident · No injuriesForeign investigationNairobi, KenyaOn March 18, 2010, a Boeing 737-300, 5Y-KQC, operated by Kenya Airways, was involved in a runway excursion during landing on runway 06 at Jomo Kenyata Airport, Nairobi, Kenya. Instrument meteorological conditions prevailed at the time. There were no injuries…NTSB DCA10WA041Incident · No injuriesForeign investigationBoeing 747 · Paris, FranceOn March 18, 2010, at 0700 local time (0600 UTC), a Thai Airways International Boeing 747-4D7, registered in Thailand as HS-TGL, experienced a fire in its avionics bay while parked at Charles de Gaulle International Airport (CDG), Paris, France. No injuries…NTSB CEN10LA168Accident · No injuriesLimited investigationFinal reportCessna 182G · Mount Vernon, MOA loss of engine power due to the failure of the number four connecting rod for undetermined reasons.NTSB CEN10LA166Accident · No injuriesLimited investigationFinal reportCessna 421B · Artesia, NMA loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB CEN10LA165Accident · 1 fatalLimited investigationFinal reportWalsh Philip J SEA REY · Huntsville, ARThe pilot's loss of airplane control for undetermined reasons.NTSB CEN10FA164Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Lewisville, TXThe pilot did not retract the landing gear before a water landing. Contributing to the accident was the pilot did not use a checklist.NTSB ANC10CA027Accident · No injuriesData collectionFinal reportCessna 182B · Port Alsworth, AKThe pilot's decision to enter adverse weather conditions, resulting in a loss of visibility and collision with terrain during a turn to reverse direction.NTSB WPR10LA168Accident · No injuriesLimited investigationFinal reportCessna 150F · Tillamook, ORThe partial loss of engine power during climb to cruise due to carburetor icing and the pilot's delay in using carburetor heat.NTSB WPR10LA166Accident · Serious injuriesLimited investigationFinal reportKjonaas Varieze · Casa Grande, AZA loss of engine power during cruise flight due to fuel exhaustion.NTSB WPR10LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Eliza Island, WAThe total loss of engine power during cruise flight due to the failure of maintenance personnel to tighten a fitting on the propeller governor oil line, which resulted in a loss of engine oil and catastrophic engine failure.NTSB WPR10FA162Accident · 2 fatalField investigationFinal reportNorth American AT6 · Bakersfield, CAThe pilots did not maintain clearance from terrain for undetermined reasons.NTSB WPR10CA167Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Okanogan, WAThe pilot's failure to maintain clearance from a fence at the end of the runway.NTSB ERA10CA183Accident · No injuriesData collectionFinal reportPiper PA-30 · Baltimore, MDThe pilot's inadvertent retraction of the landing gear during a touch-and-go landing. Contributing to the accident was the pilot's lack of recent experience in the make and model airplane.NTSB ANC10LA026Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe structural failure of the right main landing gear leg, resulting in the collapse of the landing gear.NTSB WPR10LA161Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX9 118 · Phoenix, AZThe pilot’s improper preflight inspection of the balloon’s rapid deflation system, which resulted in its inhibited functionality during landing.NTSB WPR10CA164Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Parker, AZThe mechanics' failure to account for all the tools following a maintenance procedure and the pilot's failure to perform a preflight check before a maintenance test flight.NTSB WPR10LA160Accident · Serious injuriesLimited investigationFinal reportMigas RV9-A · Twin Falls, IDThe pilot's loss of directional control during landing roll for an undetermined reason.NTSB ERA10LA177Accident · No injuriesLimited investigationFinal reportCessna T337G · Shelby, NCThe pilot's improper landing flare and touchdown during landing in gusty crosswind conditions.NTSB ERA10LA175Accident · 1 fatalLimited investigationFinal reportSmith Edward I Lancair IV-P · Hilton Head Island, SCA loss of engine power due to the failure of the crankshaft as a result of a previous propeller strike.NTSB ERA10CA176Accident · No injuriesData collectionFinal reportRolladen-Schneider LS-4 · Jasper, TNThe inadequate in-flight planning by the glider pilot to intentionally cross a ridge at low altitude, resulting in the in-flight collision with trees.NTSB CEN10CA158Accident · No injuriesData collectionFinal reportCessna 172M · Waupaca, WIThe student pilot's failure to maintain directional control while taking off in gusting winds.NTSB ANC10LA025Accident · Serious injuriesLimited investigationFinal reportBritten-Norman BN-2A-21 · Kodiak, AKThe pilot's failure to maintain clearance from rising terrain during takeoff resulting in collision with trees.NTSB CEN10LA159Accident · Minor injuriesLimited investigationFinal reportCessna TU206 · Ninnekah, OKA loss of engine power due to fuel exhaustion, resulting from the pilot’s inadequate preflight inspection.NTSB ANC10FA022Accident · 1 fatalField investigationFinal reportAntares MA-32 · Chugiak, AKThe pilot's decision to pitch the aircraft excessively during a steep climbing maneuver, resulting in a loss of control and an aerodynamic tumble.NTSB WPR10FA158Accident · 1 fatalField investigationFinal reportBeech K35 · Boulder City, NVA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management; also causal was his subsequent failure to maintain clearance from power lines.NTSB WPR10CA159Accident · No injuriesData collectionFinal reportCessna 182P · Long Beach, CAThe student pilot’s improper landing flare, resulting in a hard landing.NTSB WPR10CA157Accident · No injuriesData collectionFinal reportPiper PA-28-161 · El Cajon, CAAn in-flight collision with a bird in the downwind leg of the airport's traffic pattern.NTSB ERA10CA182Accident · No injuriesData collectionFinal reportFrederickson Charles A Pitts S-2E · Okeechobee, FLThe pilot’s failure to maintain directional control during a crosswind landing.NTSB CEN10IA157Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Chicago, ILAn in-flight encounter with lightning. Contributing to the incident was the damaged and displaced tailcone bulkhead frame that inhibited the full travel of the elevator during approach.NTSB CEN10CA160Accident · No injuriesData collectionFinal reportUltralight America Spitfire II Modelctv · Cameron, TXThe pilot's failure to maintain control while maneuvering during a forced landing after a partial loss of engine power.NTSB CEN10CA156Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Houston, TXThe student pilot's loss of directional control during takeoff, resulting in a dynamic rollover of the helicopter.NTSB ANC10CA023Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · Aniak, AKThe pilot's decision to maneuver at a low altitude during gusting wind conditions, resulting in a collision with terrain.NTSB WPR10LA156Accident · 1 fatalLimited investigationFinal reportNorth American P51D · Chandler, AZThe pilot’s improper flare, resulting in a bounced landing, stall, and loss of directional control.NTSB ERA10LA172Accident · No injuriesLimited investigationFinal reportHughes 369 · Naples, FLThe pilot's excessive aft cyclic imput during the flare following an practice autorotation, which resulted in main rotor blade contact with the tail boom.NTSB ERA10CA174Accident · Serious injuriesData collectionFinal reportAirbus Industrie A319-100 · Titusville, FLAn inadvertent in-flight encounter with turbulence, resulting in an injury to a cabin attendant.