NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 GAA21WA054Accident · 4 fatalClass 5 · ForeignBell 206 · XIa Men City, ChinaNTSB WPR21LA184Accident · No injuriesClass 3 · LimitedFinal reportCessna 182K · Las Vegas, NVA total loss of engine power due to fuel exhaustion.NTSB WPR21LA142Accident · No injuriesClass 3 · LimitedFinal reportDavis Dan B Lancair Evolution · Phoenix, AZA malfunction of the main cabin door latching mechanism for reasons that could not be determined based on the available information.NTSB WPR21LA139Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Twin Falls, IDThe pilot’s failure to maintain airplane control during initial climb with a crosswind when the airspeed decreased, the airplane exceeded its critical angle of attack and aerodynamical stalled at too low an altitude for the pilot to recover before the…NTSB ERA21LA159Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Marianna, FLThe failure of the alternator control unit housing plug connection, which resulted in insufficient battery power to fully extend the landing gear. Contributing to the accident was the pilot’s decision to not use the emergency gear extension handle to secure…NTSB DCA21WA102IncidentClass 5 · ForeignMcdonnell Douglas DC-9-83 · Maiquetia, VenezuelaNTSB WPR21LA138Accident · No injuriesClass 4 · LimitedFinal reportBurg Frederick S ZEN CH701 · Shepherd, MTThe pilot’s unstable approach, and improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB WPR21LA137Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Three Forks, MTThe pilot’s improper landing flare, which resulted in a loss of directional control, runway excursion and impact with terrain.NTSB GAA21WA096AccidentClass 4 · ForeignCessna 172 · Bordeaux, FranceNTSB GAA21WA053Accident · 1 fatalClass 4 · ForeignRobinson R44 · Leksand, SwedenNTSB GAA21WA052AccidentClass 5 · ForeignCessna 188 · La Cruz, MexicoNTSB CEN21LA160Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Watkins, COThe pilot’s failure to maintain directional control during takeoff and the instructor pilot’s inadequate supervision of the pilot’s takeoff.NTSB CEN21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Erie, COThe pilot’s failure to maintain directional control during a full-stop landing, resulting in a runway excursion and impact with a snow berm.NTSB WPR21LA136Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Myrtle Creek, ORThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a runway excursion and impact with terrain.NTSB WPR21LA133Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206 · Lucerne Valley, CAThe pilot's failure to maintain aircraft control while maneuvering with a tailwind, resulting in the helicopter spinning and colliding with terrain.NTSB GAA21WA058AccidentClass 5 · ForeignCessna 152 · Lalpur Tanore, BangladeshNTSB ERA21LA175Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Fort Pierce, FLThe flight instructor’s delayed remedial action and failure to maintain directional control during a crosswind landing, which resulted in a runway excursion.NTSB ERA21LA156Accident · Serious injuriesClass 3 · LimitedFinal reportSchempp-Hirth K G MINI-NIMBUS C · Groveland, FLThe pilot’s unsuccessful initial attempt to release from the tow plane at the start of an unstable takeoff roll, which resulted in a runway excursion and collision with a parked vehicle. Contributing to the severity of the accident was the vehicle’s proximity…NTSB DCA21WA100IncidentClass 5 · ForeignBoeing 737 · Tijuana, MexicoNTSB DCA21LA096Accident · Serious injuriesClass 4 · LimitedFinal reportBombardier CL-600-2C10 · Los Angeles, CAthe improper retraction of the main cabin door, which resulted in the flight attendant falling when she opened the door at the destination.NTSB WPR21LA131Accident · No injuriesClass 3 · LimitedFinal reportCessna T210M · Leadore, IDThe pilot’s failure to attain the proper touchdown point on a graveled surfaced runway with insufficient landing performance and subsequent loss of control during the landing roll.NTSB GAA21WA071AccidentClass 5 · ForeignRobinson R44 · Pretoria, South AfricaNTSB ERA21LA155Accident · Minor injuriesClass 3 · LimitedFinal reportSocata MS894A · Monroe, GAMaintenance personnel’s failure to properly inspect and maintain the airplane’s engine cowling latches, which resulted in the in-flight separation of the engine cowling and a subsequent forced landing.NTSB ERA21FA154Accident · 3 fatalClass 3 · FieldFinal reportBeech B36 · Pembroke Pines, FLThe pilot’s likely activation of the auxiliary fuel pump to “high” for undetermined reasons during takeoff, which resulted in total loss of engine power due to an excessively rich fuel-to-air mixture. Also causal was the pilot’s exceedance of the airplane’s…NTSB DCA21WA097IncidentClass 5 · ForeignBoeing 747 · Mexico City, MexicoNTSB DCA21LA095Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Fort Worth, TXan encounter with clear air turbulence during approachNTSB CEN21LA161Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Dumas, ARThe failure of both pilots to see and avoid the other airplane.NTSB CEN21LA163Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Port Aransas, TXThe pilot’s failure to maintain proper airspeed on approach and his attempt to land on a wet runway with insufficient runway remaining, resulting in an overrun and loss of directional control.NTSB WPR21LA130Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Laton, CAThe pilot’s failure to maintain clearance from powerlines during low-altitude maneuvering.NTSB GAA21WA050Incident · No injuriesClass 4 · ForeignHonda HA-420 · Kohnan, JapanNTSB GAA21WA047Accident · Minor injuriesClass 5 · ForeignRobinson Helicopter R44 II · Rosh Pinna, IsraelNTSB CEN21LA158Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150H · Paris, TXThe pilot’s decision to takeoff with known obstacles on the runway and his subsequent failure to avoid the windsock on takeoff.NTSB ANC21LA025Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Chevak, AKThe pilot’s loss of directional control during the back-taxi for departure in strong crosswind conditions which resulted in a runway excursion. Contributing to the accident was the snow-and-ice-covered runway.NTSB ANC21LA024Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18A 150 · Kasilof, AKThe pilot’s mismanagement of the available fuel, which resulted in a total loss on engine power due to fuel starvation.NTSB WPR21LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Eastsound, WAThe pilot’s failure to maintain directional control during the landing roll with a tailwind, which resulted in a landing gear collapse and collision with terrain.NTSB ERA21LA152Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Franklin, NCThe reason for this accident could not be determined based on the available information.NTSB WPR21LA129Accident · Serious injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Arlington, AZThe pilot’s failure to maintain obstacle clearance during takeoff, which resulted in a collision with a cactus and impact with terrain.NTSB WPR21LA128Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · McCall, IDThe pilot's loss of directional control while landing in a crosswind, which resulted in a ground loop.NTSB ENG21WA018IncidentClass 5 · ForeignAirbus A300 · Bogota, ColombiaNTSB CEN21LA174Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Colby, KSThe pilot’s failure to remove the towbar from the nose landing gear before takeoff, which resulted in a sustained adverse yaw condition, and his failure to adequately monitor the fuel system while circling the airport, which resulted in fuel starvation and…NTSB ERA21LA151Accident · No injuriesClass 4 · LimitedFinal reportBeech Sierra · Augusta, METhe pilot’s improper landing flare, which resulted in a bounced landing, and a subsequent runway excursion. Also causal was the flight instructor’s delayed remedial action.NTSB CEN21LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Poplar Bluff, MOThe pilot’s decision to make a precautionary landing in a field that contained soft terrain, which resulted in the airplane nosing over. Contributing to the accident was the pilot’s decision to fly without a printed VFR sectional chart to identify the…NTSB CEN21LA154Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Duson, LAThe uncertified pilot’s failure to maintain control of the helicopter when encountering a wind gust while hovering to land.NTSB WPR21LA125Accident · No injuriesClass 4 · LimitedFinal reportPhillip B Rolls Pitts 12-EH · Red Bluff, CAThe pilot's failure to maintain directional control during a landing, which resulted in a ground loop and subsequent nose over.NTSB WPR21LA126Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 190 · Camarillo, CAThe failure of the pilot to maintain directional control of the airplane during the landing roll which resulted in a runway excursion and subsequent nose over.NTSB ERA21LA153Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32RT-300 · Brevard, NCThe pilot’s improper landing flare, which resulted in a hard landing, overstress fracture of components of the left main landing gear, and subsequent runway excursion.NTSB CEN21LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Pueblo, COThe pilot’s failure to maintain directional control in gusting crosswind conditions.NTSB CEN21LA151Accident · 1 fatalClass 3 · LimitedFinal reportBeech 35 · Palestine, TXA total loss of engine power due to the flight crew incorrectly placing the fuel selector between fuel tank detents, which resulted in fuel starvation. Contributing to the accident was the lack of a placard on the fuel selector, the lack of obvious fuel tank…NTSB CEN21LA149Accident · No injuriesClass 4 · LimitedFinal reportAeropro CZ S R O A220 · Loveland, COThe pilot’s failure to maintain directional control during landing that resulted in a ground loop and impact with terrain.NTSB CEN21FA150Accident · 1 fatalClass 3 · FieldFinal reportAviat A-1B · Berwyn, NEA loss of control and subsequent impact with terrain as a result of spatial disorientation during cruise in dark night conditions.