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 ERA22LA074Accident · No injuriesClass 4 · LimitedFinal reportBeech C35 · Perry, GAThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with a parked airplane.NTSB WPR22LA047Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Puyallup, WAAn overstress fracture of the left main landing gear pivot assembly, which resulted in the failure of the left main landing gear to fully extend and lock into place.NTSB WPR22LA046Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV10 · Hurricane, UTThe total loss of engine power due to a loose fuel line at the fuel servo outlet port.NTSB WPR22LA045Accident · No injuriesClass 4 · LimitedFinal reportElvin Jack R JR Rotorway Exec 162F · Scio, ORThe pilot’s improper maintenance on the tail rotor assembly, which resulted in the loss of control and roll over.NTSB ENG22WA005IncidentClass 5 · ForeignBoeing 737 · Owerri, NigeriaNTSB CEN22LA057Accident · No injuriesClass 4 · LimitedFinal reportLeonardo AW169 · Austin, TXThe helicopter’s impact with a bird during cruise flight.NTSB CEN22FA042Accident · 3 fatalClass 3 · FieldFinal reportCessna T310R · Chadron, NEThe incapacitating effects of a myocardial infarction (heart attack), which resulted in the pilot's loss of airplane control and impact with terrain.NTSB WPR22FA044Accident · 1 fatalClass 3 · FieldFinal reportJahnke Lionel G Glasair III · Big Bear City, CAThe pilot’s failure to maintain clearance from mountainous terrain for reasons that could not be determined based on the available information, which resulted in controlled flight into terrain.NTSB ERA22LA088Accident · Serious injuriesClass 4 · LimitedFinal reportBombardier BD-100-1A10 · Atlantic Ocean, Turks & Caicos IslandsThe airplane’s encounter with moderate clear air turbulence which resulted in a serious injury to one unrestrained passenger.NTSB ERA22LA071Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Brent, ALThe inadequate maintenance of the oil filter adapter, which resulted in in an engine oil leak and subsequent loss engine oil pressure, and the subsequent off-airport landing.NTSB ERA22LA070Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Old Bridge, NJThe student pilot’s loss of control during a go-around, which resulted in an aerodynamic stall.NTSB DCA22WA219AccidentClass 5 · ForeignBoeing 737 · Gwaska, NigeriaNTSB CEN22LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Wheeling, ILThe student pilot’s improper landing flare, which resulted in a hard landing. Contributing was the student pilot’s self-induced pressure to land after being admonished by the controller.NTSB ANC22LA007Accident · No injuriesClass 3 · LimitedFinal reportCessna 207A · Bethel, AKThe improper installation of an avionics wire harness over a fuel line, which resulted in chafing of the wire harness, arcing, and a subsequent fire.NTSB ERA22LA069Accident · Serious injuriesClass 4 · LimitedFinal reportK Copters 47G-2 · Lancaster, PAThe flight instructor’s failure to ensure a positive transfer of aircraft control, which resulted in a loss of control and collision with terrain.NTSB CEN22LA052Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Marshall, MIThe airplane’s collision with a deer during takeoff.NTSB WPR22FA043Accident · 1 fatalClass 3 · FieldFinal reportCessna 182Q · Carlsbad, NMThe pilot's failure to maintain separation from an FM tower guy wire while on an aerial survey flight.NTSB GAA22WA036Accident · Minor injuriesClass 5 · ForeignPiper PA31 · Caroebe, BrazilNTSB ERA22LA067Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Glens Falls, NYA total loss of engine power for reasons that could not be determined.NTSB CEN22LA041Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Miamisburg, OHThe student pilot’s failure to maintain control of the helicopter during a low-altitude hover shortly after liftoff.NTSB WPR22LA042Accident · No injuriesClass 4 · LimitedFinal reportPhoenix Air U-15 Phoenix · Carlsbad, CAThe pilot’s failure to maintain distance with an airport sign while taxiing.NTSB GAA22WA033Accident · No injuriesClass 5 · ForeignCessna 152 · Vilar da Luz, PortugalNTSB ERA22LA072Accident · No injuriesClass 4 · LimitedFinal reportAeronca O58B · Jonestown, PAThe pilot’s incorrect glide path and landing flare, which resulted in a collision with obstacles on final approach and a hard landing.NTSB DCA22WA034IncidentClass 5 · ForeignBoeing 737 · Maringá, BrazilNTSB WPR22LA041Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Farmington, NMThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB WPR22LA036Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Mackay, IDThe pilot’s failure to maintain directional control during the landing roll, which resulted in the airplane veering into a ditch and nosing over.NTSB GAA22WA058Accident · 1 fatalClass 5 · ForeignRobinson R22 · Rauch, ArgentinaNTSB DCA22WA033IncidentClass 5 · ForeignBoeing 737 · Patna, IndiaNTSB CEN22FA035Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Estes Park, COThe airplane’s encounter with severe to extreme turbulence associated with mountain wave rotor cloud activity, which resulted in loss of airplane control.NTSB GAA22WA032Accident · 2 fatalClass 5 · ForeignCessna 182 · Hope, CanadaNTSB WPR22LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Belen, NMThe pilot’s failure to maintain directional control during takeoff.NTSB WPR22LA035Accident · Minor injuriesClass 3 · LimitedFinal reportSonex Waiex B · Laveen Village, AZFailure of the rocker swivel assembly due to either wear or corrosion, which resulted in a loss of engine power.NTSB WPR22LA034Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · Molalla, ORThe loss of engine power for undetermined reasons.NTSB ERA22LA064Accident · No injuriesClass 3 · LimitedFinal reportMooney M20M · Tampa, FLThe total loss of engine power due to the failure of maintenance personnel to properly tighten the fuel supply line b-nut at the manifold valve during installation.NTSB CEN22LA040Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 23 · Abilene, TXThe flight instructor’s inadequate fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the missing placard showing the usable fuel quantity.NTSB CEN22LA039Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36TC · Rockport, TXThe total loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN22LA038Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-160 · West Union, OHA malfunction of the flight controls for reasons that could not be determined based on available information.NTSB CEN22FA032Accident · 2 fatalClass 3 · FieldFinal reportBeech E-90 · Boyne City, MIThe pilot’s failure to maintain sufficient airspeed and his exceedance of the airplane’s critical angle of attack while in icing conditions, which resulted in an aerodynamic stall and subsequent ground impact.NTSB WPR22LA040Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Boulder City, NVThe installation of an improper right main landing gear door rod-end bolt, which resulted in the right main landing gear not extending during landing.NTSB WPR22LA039Accident · No injuriesClass 3 · LimitedFinal reportIai 1125 Westwind Astra · North Las Vegas, NVThe pilot landed long and failed to deploy the thrust reversers, which resulted in a runway overrun and impact with terrain. Contributing to the accident was the pilot’s decision to operate the airplane as a single pilot instead of the required minimum crew…NTSB WPR22LA037Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Stanley, IDThe pilot's failure to attain sufficient airspeed for the airplane to climb with a tailwind.NTSB GAA22WA031AccidentClass 5 · ForeignCessna 172N · Worms, GermanyNTSB GAA22WA030Accident · Serious injuriesClass 5 · ForeignHughes 269C · Klinga, GermanyNTSB GAA22WA028Accident · 1 fatalClass 5 · ForeignJust Escapade · York, United KingdomNTSB ERA22LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Palm Coast, FLThe student pilot’s improper landing flare and subsequent improper recovery from a bounced landing, resulting in a hard landing and substantial damage to the lower fuselage and firewall.NTSB ERA22LA060Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Wilkes-Barre, PAThe pilot’s decision to commence the flight in marginal visual flight rules conditions at night, and his failure to maintain a safe altitude once instrument conditions were encountered.NTSB ERA22LA059Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Burnsville, NCThe pilot’s failure to compensate for the high density altitude and the tailwind component while landing at a mountaintop airport, which resulted in an aerodynamic stall and a loss of aircraft control.NTSB ERA22LA063Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Denver, NCThe pilot’s failure to maintain directional control during the landing roll with a gusting crosswind.NTSB ERA22LA062Accident · Serious injuriesClass 4 · LimitedFinal reportMaxair Drifter · Sebring, FLThe non-certificated pilot’s decision to operate the airplane without flight training or a pilot certificate and his loss of control shortly after takeoff, which resulted in an aerodynamic stall at low altitude and collision with terrain.NTSB CEN22FA031Accident · 4 fatalClass 3 · FieldFinal reportBritten-Norman BN-2A · Beaver Island, MIThe pilot's exceedance of the airplane's critical angle of attack during final approach, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.