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 WPR22FA033Accident · 2 fatalClass 3 · FieldFinal reportZenith Stol CH701 · Randsburg, CAThe pilot’s improper landing approach, which failed to account for wind conditions, and his exceedance of the airplane’s critical angle of attack following an overshoot of the runway extended centerline, resulting in an accelerated aerodynamic stall.…NTSB ERA22LA066Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · St. Petersburg, FLThe pilot’s inadvertent selection of an off fuel selector position, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA22LA061Accident · No injuriesClass 4 · LimitedFinal reportEric A Munzer Dornier D027-B2 · Martinsville, VAThe pilot’s failure to maintain directional control during landing rollout, which resulted in a runway excursion and an impact with a ditch.NTSB ENG22LA004Occurrence · No injuriesClass 3 · LimitedFinal reportBeech F33 · Bellefontaine, OHThe internal failure of the autopilot pitch servo actuator that caused the autopilot to command a nose down movement of the pitch trim.NTSB GAA22WA029Accident · 1 fatalClass 5 · ForeignCessna P210N · Dornbirn, AustriaNTSB ERA22FA058Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Branchville, NJThe flight instructor’s failure to recover from a steep spiral turn during an instructional flight.NTSB DCA22WA024IncidentClass 5 · ForeignBoeing 737 · Warsaw, PolandNTSB GAA22WA027Accident · No injuriesClass 5 · ForeignRans S6-ESD · Felton, United KingdomNTSB ERA22FA056Accident · 1 fatalClass 3 · FieldFinal reportZenith CH601 · Oak Hill, FLA loss of airplane control while maneuvering at low altitude.NTSB CEN22LA034Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Fort Davis, TXThe pilot’s encounter of a downdraft from which there was insufficient altitude to recover.NTSB CEN22LA033Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Freer, TXThe pilot’s encounter with ‘settling with power’ while maneuvering at a low altitude, which resulted in a rapid descent and subsequent hard landing.NTSB WPR22LA032Accident · No injuriesClass 4 · LimitedFinal reportBell OH-58A · Holtville, CAThe pilot’s failure to maintain helicopter control after becoming spatially disoriented when the helicopter entered low-level haze/fog.NTSB ERA22LA054Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Sarasota, FLA partial loss of engine power due to a failed throttle cable.NTSB ANC22LA006Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC-18-180 · Yukon Charlie River, AKThe pilot’s selection of an unsuitable landing site, which resulted in a nose-over.NTSB WPR22LA028Accident · No injuriesClass 4 · LimitedFinal reportBearhawk 4 · Redding, CAThe pilot’s improper landing flare which resulted in a hard landing and subsequent ground loop.NTSB GAA22WA035Accident · No injuriesClass 4 · ForeignRobinson R44 · Belo Horizonte, BrazilNTSB ERA22FA051Accident · 1 fatalClass 3 · FieldFinal reportIssitt Greg Sonex · Malone, FLAn in-flight collision with a tree for reasons that could not be determined.NTSB ERA22FA050Accident · 1 fatalClass 3 · FieldFinal reportMooney M20F · Villa Rica, GAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin.NTSB CEN22LA056Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Madison, MSThe student pilot’s failure to maintain aircraft control following a bounced landing.NTSB ERA22LA057Accident · No injuriesClass 4 · LimitedFinal reportCessna/Air Repair 305F · Anne Arundel, MDThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and substantial damage.NTSB ERA22LA052Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-220C · Ridgeway, VAThe pilot’s improper fuel management which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.NTSB ERA22LA049Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Newport Richie, FLA loss of directional control on landing for undetermined reasons.NTSB CEN22LA030Accident · No injuriesClass 4 · LimitedFinal reportRaytheon G36 · Frankenmuth, MIThe pilot’s failure to maintain directional control while landing on a wet grass strip.NTSB ANC22FA005Accident · 1 fatalClass 3 · FieldFinal reportGerald Jones 2+2 · Kodiak, AKThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB GAA22WA024Accident · 5 fatalClass 5 · ForeignBeech C90 · Caratinga, BrazilNTSB ERA22FA047Accident · 1 fatalClass 3 · FieldFinal reportPiper PA30 · Rock Hill, SCThe pilot’s exceedance of the airplane's critical angle of attack while troubleshooting a landing gear indication, which resulted in an aerodynamic stall at low altitude.NTSB CEN22FA029Accident · 1 fatalClass 3 · FieldFinal reportVans RV · Harrison, MIThe pilot’s failure to maintain adequate airspeed and exceedance of the airplane’s critical angle of attack during landing approach, which resulted in an aerodynamic stall.NTSB WPR22LA029Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Challis, IDThe pilot’s loss of directional control after the airplane encountered a gust of wind during the landing roll.NTSB WPR22LA027Accident · No injuriesClass 4 · LimitedFinal reportSanta Fe CCX-2300 · Taos, NMThe pilot’s failure to maintain directional control during a landing roll, which resulted in a ground loop and impact with the ground.NTSB ERA22LA053Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Ringwood, NJA loss of engine power in flight due to fuel exhaustion as a result of the pilot’s failure to secure the left wing’s fuel cap.NTSB ERA22LA046Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Margarettsville, NCThe pilot’s delayed application of carburetor heat during the descent, which resulted in a total loss of engine power due to carburetor icing.NTSB ERA22LA045Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Decatur, GAOil exhaustion due to an oil leak that resulted in a total loss of engine power.NTSB WPR22FA026Accident · 1 fatalClass 3 · FieldFinal reportAyres S-2R · Shafter, CAThe pilot’s decision to depart into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control.NTSB DCA22WA025IncidentClass 5 · ForeignBoeing 737 · Darwin, AustraliaNTSB DCA22WA020Incident · No injuriesClass 5 · ForeignBoeing 787-9 · Baradero, ArgentinaNTSB GAA22WA034Accident · No injuriesClass 5 · ForeignPiper PA34 · Luqa, MaltaNTSB WPR22LA025Accident · No injuriesClass 3 · LimitedFinal reportCessna R172K · Rexburg, IDA total loss of engine power for reasons that could not be determined based on the available evidence. Contributing to the accident was the pilot’s decision to operate the airplane with a known mechanical issue.NTSB GAA22WA026IncidentClass 5 · ForeignSikorsky S92 · North Sea, United KingdomNTSB GAA22WA023Accident · No injuriesClass 5 · ForeignZenith 601 · Ciocanesti, RomaniaNTSB ERA22LA044Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Stevensville, MDAn in-flight collision with a bird during initial climb.NTSB ERA22LA043Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-236 · Orleans, MAThe pilot’s spatial disorientation and subsequent loss of airplane control while maneuvering over water in dark night conditions.NTSB ERA22LA039Accident · No injuriesClass 3 · LimitedFinal reportBell 47D1 · Zelienople, PAA total loss of engine power for reasons that could not be determined.NTSB ERA22FA036Accident · 1 fatalClass 3 · FieldFinal reportVans RV4 · Chattahoochee, FLThe pilot’s failure to properly secure the canopy before takeoff, allowing the canopy to open and then separate in flight, which resulted in the pilot’s failure to maintain control of the airplane for reasons that could not be determined based on the…NTSB ENG22WA003Incident · 2 fatalClass 5 · ForeignBoeing 727 · Ciudad de la Costa, UruguayNTSB DCA22WA021Incident · No injuriesClass 5 · ForeignBoeing 787-9 · Vogo, IndiaNTSB CEN22LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Hudson Oaks, TXThe partial loss of engine power due to fuel exhaustion. Contributing was the pilot’s improper fuel planning.NTSB CEN22LA025Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Cresson, TXThe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with trees.NTSB CEN22LA024Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150L · Forrest City, ARThe pilot’s loss of control during landing. Contributing to the pilot’s injuries was his ejection from the airplane resulting from him not wearing his available seat restraints.NTSB CEN22FA023Accident · 2 fatalClass 3 · FieldFinal reportBeech P35 · Harrison, NEThe pilot’s decision to continue the flight into instrument and icing conditions, which resulted in loss of control and impact with terrain. Contributing to the accident was the pilot’s failure to obtain a timely weather briefing.NTSB GAA22WA025Accident · Serious injuriesClass 5 · ForeignCessna 182P · Tulisa Park, South Africa