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 WPR22LA131Accident · Minor injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Spanish Fork, UTThe pilot’s failure to maintain directional control during landing with gusting wind.NTSB GAA22WA132Accident · 1 fatalClass 5 · ForeignSukhoi SU-31 · Ploiesti, RomaniaNTSB ERA22LA168Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Myrtle Beach, SCVibration in the airframe and flight controls for reasons that could not be determined based on the available evidence.NTSB DCA22WA106Incident · No injuriesClass 5 · ForeignBoeing 757 · San Jose, Costa RicaNTSB CEN22LA161Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Benton, ARThe pilot’s failure to maintain control of the airplane while landing.NTSB CEN22LA158Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Garnett, KSThe pilot’s failure to maintain lateral control while hovering which resulted in a dynamic rollover.NTSB CEN22LA157Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT-401 · Rayville, LAA loss of engine power for a reason that could not be determined based on available information.NTSB WPR22LA137Accident · Minor injuriesClass 3 · LimitedFinal reportCzech Sport Aircraft A S Sportcruiser · Lanark, NMThe pilot’s loss of control of the airplane after the inadvertent unlocking and opening of the canopy for reasons that could not be determined based on available evidence.NTSB ERA22LA169Accident · Serious injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Smithfield, NCMaintenance personnel’s failure to set the correct engine timing after the replacement of a cylinder head and exhaust camshaft before the accident flight, which resulted in a total loss of engine power.NTSB ERA22LA167Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172P · Winder, GAMaintenance personnel’s failure to detect the damaged aileron cable during the most recent inspections, which resulted in the separation of the aileron control cable and subsequent loss of airplane control.NTSB CEN22LA154Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Wade, OKThe student pilot’s failure to maintain clearance from power lines during takeoff.NTSB CEN22LA152Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Ash Flat, ARThe partial loss of engine power during a go-around resulting in an inadvertent entry into an aerodynamic stall. Contributing to the accident was the inexperience of the low-time pilot.NTSB CEN22FA151Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Rowlett, TXA loss of helicopter control while maneuvering, which resulted in main rotor blade contact with the tailboom in flight, tail boom separation, and an uncontrolled descent.NTSB ANC22LA027Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Chitina, AKThe pilot’s exceedance of the wing’s critical angle of attack, which resulted in a stall and impact with terrain.NTSB WPR22LA127Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32R-300 · St. George, UTThe total loss of engine power for undetermined reasons.NTSB GAA22WA143Accident · No injuriesClass 5 · ForeignCessna 560XL · Sevilla, SpainNTSB GAA22WA139Accident · No injuriesClass 5 · ForeignPiper PA28 · Hilversum, NetherlandsNTSB CEN22LA178Accident · Minor injuriesClass 3 · LimitedFinal reportCessna L-19E · Sunflower, MSThe total loss of engine power for reasons that could not be determined.NTSB CEN22LA156Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Springtown, TXA total loss of engine power for reasons that could not be determined.NTSB WPR22LA135Accident · No injuriesClass 4 · LimitedFinal reportAirplane Factory Sling LSA · Torrance, CAThe flight instructor’s loss of airplane control during an aborted landing due to a wind shift, which resulted in an impact with a runway sign.NTSB WPR22LA134Accident · Minor injuriesClass 4 · LimitedFinal reportAutogyro Cavalon · El Monte, CAThe pilot’s diverted attention during landing, which resulted in a loss of directional control.NTSB GAA22WA163Accident · Serious injuriesClass 5 · ForeignCessna F172 · Bonn-Hangelar, GermanyNTSB CEN22LA153Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-46-600TP · Olive Branch, MSThe airplane’s hard right turn during landing in crosswind conditions and a subsequent loss of directional control due to adverse airplane-pilot coupling attributable to the design of the nose landing gear, whose directional stability was sensitive to…NTSB CEN22LA150Accident · No injuriesClass 4 · LimitedFinal reportSparrow Hawk III · Lubbock, TXThe pilot’s failure to maintain control of the gyrocopter during takeoff with strong gusty winds.NTSB WPR22LA132Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Howe, IDThe pilot’s failure to maintain adequate rotor rpm while descending with a gusting tailwind condition, which resulted in a loss of helicopter control.NTSB CEN22LA155Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Plains, TXThe pilot’s failure to maintain control of the airplane during taxi with a strong crosswind.NTSB GAA22WA135Incident · No injuriesClass 5 · ForeignBeech A100 · La Guaira, VenezuelaNTSB GAA22WA131Accident · Serious injuriesClass 5 · ForeignPiper PA28-140 · Bragança Paulista, BrazilNTSB GAA22WA128Accident · 1 fatalClass 5 · ForeignCessna 172RG · Brantford, CanadaNTSB DCA22WA221Occurrence · No injuriesClass 5 · ForeignBoeing 777 · Islamabad, PakistanNTSB DCA22WA102Accident · 132 fatalClass 5 · ForeignBoeing 737 · Wuzhou, ChinaNTSB ANC22LA025Accident · 2 fatalClass 3 · LimitedFinal reportCessna 172P · Kekaha, HIThe pilot’s improper decision to continue the visual-flight-rules flight into low visibility conditions, which resulted in controlled flight into terrain.NTSB WPR22LA125Accident · Serious injuriesClass 4 · LimitedFinal reportEurocopter AS332L1 · Azusa, CAThe pilot's failure to maintain clearance from a tree after encountering brownout conditions and a loss of visual reference during the approach to land.NTSB GAA22WA126Accident · Serious injuriesClass 5 · ForeignAyres SRT34 · Antioquia, ColombiaNTSB GAA22WA125Accident · Minor injuriesClass 5 · ForeignCirrus SR22 · Ringsted, DenmarkNTSB DCA22WA114IncidentClass 5 · ForeignBoeing 777-223 · Barcelona, SpainNTSB CEN22LA174Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Paragould, ARThe student pilot’s failure to maintain directional control during landing which resulted in a ground loop.NTSB ANC22LA024Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Talkeetna, AKThe pilot’s improper positioning of the fuel selector during takeoff, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB WPR22LA144Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Alpine, CAThe pilot’s failure to maintain clearance from rising terrain while operating in a canyon, which resulted in an impact with terrainNTSB WPR22LA130Accident · No injuriesClass 4 · LimitedFinal reportParadise Aircraft USA P1 · Glendale, AZA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate preflight fuel inspection.NTSB WPR22LA128Accident · No injuriesClass 4 · LimitedFinal reportNewell Michael J Lancair ES · Hurricane, UTLoss of brake pressure on the left brake due to air in the brake line which, resulted in a runway over run and collision with a ditch.NTSB GAA22WA134Incident · No injuriesClass 5 · ForeignBeech 95B55 · San Fernando, ArgentinaNTSB ERA22FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Dahlonega, GAThe pilot’s delay in initiating a go-around and his failure to maintain airplane control during the initial climb, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB ERA22LA195Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32 · Carlisle, PAThe pilot’s improper landing flare, which resulted in the airplane’s empennage impacting the runway surface during landing.NTSB ERA22FA160Accident · 2 fatalClass 3 · FieldFinal reportMD Helicopters 369 · Loxahatchee, FLThe pilot’s failure to maintain clearance from power lines while maneuvering at low altitude.NTSB CEN22LA149Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Grapevine, TXThe failure of the pilot of the second aircraft to maintain a safe distance from the lead airplane while taxiing, which resulted in a ground collision.NTSB WPR22LA129Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Belgrade, MTThe pilots misjudged landing approach, which resulted in a long landing and collision with a fence.NTSB GAA22WA130Accident · No injuriesClass 5 · ForeignCessna 150 · BragançA Paulista - Sp, BrazilNTSB ERA22LA165Accident · Minor injuriesClass 4 · LimitedFinal reportNordquist Richard A Vans RV7 · Polk City, FLA loss of control during landing due to the loose and uneven landing surface.NTSB ERA22LA164Accident · Minor injuriesClass 4 · LimitedFinal reportHartz Paul RV-6A · Lake City, FLThe pilot’s improper landing flare, which resulted in overload bending of the nose landing gear leg and subsequent nose-over.