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 CEN22LA188Accident · No injuriesClass 3 · LimitedFinal reportBeech B-99 · Milwaukee, WIA right main landing gear collapse due to fatigue failure of the landing gear drag leg support fitting.NTSB CEN22LA187Accident · No injuriesClass 3 · LimitedFinal reportNorth American AT-6D · Fredericksburg, TXA total loss of engine power due to a failure of the No. 1 cylinder.NTSB CEN22LA186Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Loogootee, INThe inadequate maintenance and subsequent failure of an internal component in the fuel servo that prevented adequate fuel flow to the engine, which resulted in a partial loss of engine power.NTSB WPR22LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Portland, ORThe pilot’s failure to maintain directional control during landing on a wet surface with a tailwind, which resulted in a runway excursion.NTSB WPR22LA168Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Folsom, NMThe pilot’s failure to maintain airspeed and rotor rpm which resulted in a hard landing.NTSB GAA22WA167AccidentClass 5 · ForeignBeech 36 · Staad, SwitzerlandNTSB ERA22LA211Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 152 · Wadsworth, OHThe pilot’s failure to maintain directional control while attempting to land in a crosswind.NTSB CEN22LA185Accident · 1 fatalClass 3 · LimitedFinal reportSuperior Culver LFA · Syracuse, KSThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an inadvertent aerodynamic stall while returning to the airport following a partial loss of engine power for reasons that could not be determined.NTSB GAA22WA188Accident · No injuriesClass 4 · ForeignKodiak 100 · West New Britain Province, Papua New GuineaNTSB GAA22WA169Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Konstanz, GermanyNTSB CEN22LA184Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Terre Haute, INA hard landing, which resulted in the failure of the right main landing gear outer bearing and collapse of the landing gear.NTSB ERA22LA252Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Daytona Beach, FLPilot’s failure to maintain clearance from a forklift while taxiing.NTSB ERA22LA209Accident · Minor injuriesClass 4 · LimitedFinal reportGarlick Helicopters OH-58A+ · Oakland, FLThe pilot’s decision to continue the low-altitude aerial application flight over water conditions that degraded his depth perception, which resulted in an inadvertent collision with the water.NTSB ERA22LA206Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206 · Lake Apopka, FLA collision with water following a loss of visual reference to the water surface due to sun glare.NTSB ERA22FA207Accident · 2 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 429 · Elba, NYThe pilots’ inappropriate flight control inputs while in vortex ring state, which resulted in main rotor blade contact with the tail boom and a subsequent in-flight breakup. Also causal was the flight instructor’s inadequate monitoring of the flight.NTSB ENG22WA024IncidentClass 5 · ForeignBoeing 737 · Queensland, AustraliaNTSB DCA22WA120Incident · Minor injuriesClass 5 · ForeignBoeing 737 · Almeria, SpainNTSB WPR22LA167Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Redding, CAThe student pilot's improper landing flare and remedial action which resulted in a bounced landing.NTSB WPR22LA165AccidentClass 4 · LimitedFinal reportCessna 182G · Eloy, AZThe unoccupied airplanes exceedance of the critical angle of attack which resulted in a stall, subsequent inverted spin, and impact with terrain.NTSB ERA22LA208Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24 · Honesdale, PAThe pilot’s failure to maintain clearance with the edge of the asphalt, which resulted in a runway excursion. Contributing to the accident was the pilot’s distraction due to a goose.NTSB ERA22LA205Accident · No injuriesClass 4 · LimitedFinal reportMaule MX7 · Tampa, FLThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA22LA204Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172A · Stockbridge, GAThe flight instructor’s delayed remedial action during an unstabilized approach, which resulted in an impact with powerlines and a subsequent loss of controlNTSB ERA22LA202Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Fountain Inn, SCThe pilot’s failure to obtain the proper touchdown point during landing, which resulted in a runway overrun and collision with a fence.NTSB WPR22LA166Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · Ravensdale, WAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB WPR22FA164Accident · 4 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 · Cedar City, UTThe pilot’s failure to maintain obstacle clearance, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s decision to operate the airplane above its maximum gross weight.NTSB ERA22LA200Accident · Serious injuriesClass 4 · LimitedFinal reportTitan T51 · Perry, FLThe pilot’s inadequate preflight inspection of the fuel quantity, which resulted in fuel exhaustion, a subsequent total loss of engine power, and an off-airport landing.NTSB ERA22LA201Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Union, SCThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with terrain.NTSB GAA22WA162Accident · 1 fatalClass 5 · ForeignMooney M20K · Springbank, AB, CanadaNTSB ERA22LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Westminster, MDThe student pilot’s failure to attain the proper touchdown point which resulted in a runway overrun.NTSB WPR22LA163Accident · No injuriesClass 3 · LimitedFinal reportTextron T206H · Santa Barbara, CAThe loss of directional control for undetermined reasons. Contributing was the overstress fracture of the nose gear upper trunnion brace attach point.NTSB WPR22LA162Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Las Vegas, NVThe pilot’s failure to maintain sufficient clearance from the jet blast of a departing jet airplane.NTSB ERA22FA199Accident · 2 fatalClass 3 · FieldFinal reportCessna 340 · Covington, GAThe private pilot’s loss of control in flight, which resulted in a collision with terrain. Contributing to the accident was the student pilot’s decision to obtain flight instruction from the private pilot and the private pilot's insufficient qualifications to…NTSB CEN22LA183Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Wharton, TXThe pilot’s failure to extend the landing gear.NTSB CEN22LA182Accident · No injuriesClass 4 · LimitedFinal reportPiper-Harris J3C-65 · Hartford, WIThe flight instructor lost control of the airplane while taxiing in gusty wind conditions.NTSB CEN22LA181Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Manhattan, KSThe pilot’s failure to use carburetor heat during the approach and his unsuitable flight profile for an upsloping runway, which resulted in a partial loss of engine power and an impact with terrain during an attempted go-around.NTSB WPR22LA161Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172I · Blanding, UTThe pilot’s improper landing flare which, resulted in a bounced landing and loss of airplane control during an aborted landing in gusty wind conditions.NTSB WPR22FA160Accident · 1 fatalClass 3 · FieldFinal reportCessna 337 · Sylmar, CAThe pilot’s loss of airplane control while troubleshooting a landing gear issue, which resulted in an aerodynamic stall/spin at an altitude too low to recover. Contributing to the accident was the pilot’s impairment from alcohol consumption.NTSB GAA22WA176Accident · 5 fatalClass 5 · ForeignCessna 207 · Carrefour, HaitiNTSB ANC22LA032Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Wasilla, AKThe pilot's failure to maintain a proper glidepath while on final approach to landing which resulted in an impact with a snow berm and a nose over.NTSB WPR22LA159Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 42 · Long Beach, CAThe failure of the right main landing gear brace rib for reasons that could not be determined based on available information.NTSB GAA22WA172IncidentClass 5 · ForeignPiper PA-46-600TP · Londrina, BrazilNTSB CEN22LA179Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Englewood, COThe flight instructor’s inadequate supervision of the student pilot and the student pilot’s loss of directional control during landing, which resulted in a runway excursion.NTSB GAA22WA166AccidentClass 4 · ForeignPiper PA25 · Cabeceiras, BrazilNTSB GAA22WA159Accident · 1 fatalClass 5 · ForeignCessna 172 · Coonagarabran, AustraliaNTSB ERA22LA194Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140B · Panama City, FLA total loss of engine power due to fuel contamination. Contributing to the accident was the inadequate maintenance and inspection of the airplane and engine by maintenance personnel, and the pilot’s inadequate preflight inspection and runup.NTSB ERA22LA192Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206B · Cedar Key, FLThe pilot’s improper fuel planning during agricultural spraying operations, which resulted in fuel starvation, a loss of engine power, and a hard landing following an autorotation.NTSB WPR22LA156Accident · Serious injuriesClass 4 · LimitedFinal reportSawby Scott RV-6A · Richland, WAThe pilot’s failure to maintain directional control during the takeoff ground roll.NTSB WPR22LA155Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Boise, IDThe pilot receiving instructions failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB WPR22LA154Accident · Serious injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B3 · Deer Valley, AZThe fuelers improper action during the refueling process.NTSB GAA22WA164Accident · No injuriesClass 5 · ForeignCirrus SR22 · Picarra, Brazil