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 CEN23LA331Accident · Minor injuriesClass 4 · LimitedFinal reportDavid Brown/U Balldin/T Morgan Zenith Stol CH701 · Arnaudville, LAThe pilot’s failure to maintain airspeed resulting in exceeding the airplane’s critical angle of attack and an aerodynamic stall. The low altitude at which the flight was conducted contributed to the outcome.NTSB CEN23LA265Accident · No injuriesClass 4 · LimitedFinal reportBearhawk Model 5 · Livingston, TXThe pilot’s failure to maintain directional control during the rollout, which resulted in a runway excursion, and a collision with a building. Contributing to the accident were the obstacles at the airstrip that prevented the pilot from performing a go-around.NTSB WPR23LA259Accident · Serious injuriesClass 4 · LimitedFinal reportAviat A-1B · Las Vegas, NVThe pilot’s unsafe inflight operation of the airplane and failure to maintain clearance from a person on the ground, which resulted in a serious injury.NTSB WPR23LA243Accident · No injuriesClass 3 · LimitedFinal reportKitfox 2 · Cave Junction, ORThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB ERA23LA303Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-201 · Macon, GAAn inflight collision with a bird.NTSB CEN23LA267Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Rockport, TXThe failure of the left engine starter adapter gear, which resulted in catastrophic damage to other engine components, and the subsequent loss of engine power.NTSB CEN23LA266Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Howell, MIA loss of engine power due to the formation of carburetor ice that resulted from the pilot’s delayed use of carburetor heat during the landing approach.NTSB CEN23LA264Accident · No injuriesClass 3 · LimitedFinal reportBeech B19 · Scott City, KSA partial loss of engine power as a result of carburetor icing that formed while the engine was operating at a low power setting for an extended period before departure.NTSB WPR23LA241Accident · No injuriesClass 3 · LimitedFinal reportCessna 172K · Marana, AZA total loss of engine power due to fuel exhaustion.NTSB GAA23WA214Accident · No injuriesClass 5 · ForeignBell 206B · Thetford Mines, CanadaNTSB GAA23WA191Accident · Serious injuriesClass 5 · ForeignIcon A5 · Donam Port, North KoreaNTSB ERA23LA275Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Pence Springs, WVA total loss of engine power due to carburetor icing.NTSB DCA23WA335Accident · Serious injuriesClass 5 · ForeignBoeing 777 · Chek Lap Kok, Hong Kong SAR ChinaNTSB CEN23LA263Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182G · Gunnison, COThe pilot’s improper decision to fly into an area of unsuitable terrain which the airplane was unable to exit, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB CEN23LA262Accident · No injuriesClass 3 · LimitedFinal reportPiper PA23 · Ocean Springs, MSA total loss of engine power during the initial climb due to fuel starvation for undetermined reasons.NTSB CEN23LA261Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Cedar Creek, MOA seizure of the power takeoff piston due to inadequate maintenance to the lubrication system, which resulted in a lack of oil lubrication and subsequent engine failure.NTSB CEN23LA260Accident · No injuriesClass 4 · LimitedFinal reportSharp Glennis Escapade · Bolivar, MOThe pilot’s failure to maintain aircraft control during a soft-field takeoff after encountering a wind gust.NTSB CEN23LA259Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28RT-201T · Baytown, TXThe total loss of engine power for undetermined reasons and the subsequent impact with terrain.NTSB CEN23FA257Accident · 1 fatalClass 3 · FieldFinal reportAvid Magnum · Beaver Island, MIThe pilot’s failure to maintain clearance from the water while maneuvering in low visibility conditions due to smoke and haze.NTSB GAA23WA174Accident · No injuriesClass 5 · ForeignCessna 188 · Vereda Puerto, ColombiaNTSB CEN23LA255Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Westhope, NDThe pilot’s failure to maintain aircraft control that resulted in an impact with terrain after takeoff.NTSB WPR23LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Idaho Falls, IDThe pilot’s failure to maintain directional control while landing with a gusting crosswind.NTSB WPR23LA235Accident · No injuriesClass 4 · LimitedFinal reportJohn Topliff PA18-200EXP · Truckee, CAThe pilot’s loss of directional control on landing roll out, during variable wind conditions.NTSB GAA23WA183Accident · 1 fatalClass 5 · ForeignAir Tractor AT802 · Ngodwana, South AfricaNTSB GAA23WA173Accident · 2 fatalClass 5 · ForeignBell 412 · Gom, MexicoNTSB DCA23WA470OccurrenceClass 5 · ForeignAirbus A320 · Vilnius, LithuaniaNTSB CEN23LA254Accident · Serious injuriesClass 3 · LimitedFinal reportLet L-23 Super Blanik · Gregory, MIThe flight instructor’s failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack, leading to an aerodynamic stall during the off-field landing.NTSB CEN23LA251Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Osceola, IAThe pilot’s failure to maintain directional control of the tailwheel equipped airplane during a crosswind landing.NTSB CEN23LA250Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 7EC · Waunakee, WIA total loss of engine power during the initial takeoff climb due to a worn manual fuel primer pump locking mechanism, which resulted in an unlocked primer and an overly rich fuel mixture.NTSB CEN23LA249Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Mesquite, TXThe pilot’s inability to maintain directional control during the landing roll due to corroded brake caliper pins.NTSB CEN23FA248Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7CCM · Duluth, MNThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed, which resulted in an aerodynamic stall and loss of control.NTSB GAA23WA181Accident · No injuriesClass 5 · ForeignCessna 310 · Derby, AustraliaNTSB ERA23LA272Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Wellington, FLWear of the fuel control unit drive shaft and the corresponding fuel pump drive gear, which resulted in the disengagement of the fuel control unit from the fuel pump, a decrease in fuel flow, and a loss of engine power.NTSB DCA23WA348IncidentClass 5 · ForeignBoeing 767 · Frankfurt, GermanyNTSB DCA23WA334Incident · No injuriesClass 5 · ForeignBoeing 737 · Shiraz, IranNTSB CEN23LA252Accident · No injuriesClass 4 · LimitedFinal reportStarduster II · Norwich, NYThe pilot’s loss of directional control during landing rollout due to interference from the pilot’s foot/shoe with the airplane structure that resulted in a runway excursion and impact with terrain.NTSB GAA23WA179Accident · Minor injuriesClass 4 · ForeignCessna 170 · Santiago, BrazilNTSB CEN23LA247Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Cedar Lake, INThe failure of the flight instructor to attain/maintain aircraft control while maneuvering, which resulted in an uncontrolled descent and impact with the lake.NTSB ANC23LA044Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Talkeetna, AKA loss of directional control, while landing, due to a flat main landing gear tire.NTSB GAA23WA177Accident · 2 fatalClass 5 · ForeignSocata Rallye 180 · Arkösund, Norrköping, SwedenNTSB GAA23WA172Accident · No injuriesClass 5 · ForeignRobinson R44 · San Carlos de Boliva-Buenos Aires, ArgentinaNTSB ERA23LA271Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Seymore, TNThe flight instructor’s failure to properly configure the wing flaps for a soft-field takeoff on a short runway, which resulted in a runway overrun and collision with trees.NTSB DCA23WA329IncidentClass 5 · ForeignBoeing 717 · Brisbane, AustraliaNTSB DCA23WA327Accident · No injuriesClass 5 · ForeignBoeing 787 · Taipei, TaiwanNTSB CEN23LA246Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · College Station, TXThe mechanic’s failure to properly secure the oil suction screen plug during recent maintenance, which resulted in an oil leak and subsequent loss of engine power due to oil starvation.NTSB CEN23LA245Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Louise, TXThe pilot’s failure to maintain directional control in gusting wind conditions.NTSB CEN23LA244Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Sturgis, SDThe pilot’s improper timing to initiate beta mode with the propeller and his failure to maintain directional during the full load landing that resulted in a runway excursion. Contributing to the accident was the pilot’s lack of recent experience with…NTSB ANC23LA043Accident · No injuriesClass 4 · LimitedFinal reportBuck/Crawford/Crawford Christavia MK-1 · Anchorage, AKThe instructor pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a wing impacting a runway light.NTSB WPR23LA238Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s improper flare, which resulted in a hard landing.NTSB WPR23LA232Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Rochester, NVA broken fuel line fitting that resulted in a total loss of engine power due to fuel starvation.