Final 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 WHERE c.\"completionStatus\" = 'Completed' 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 WHERE c."completionStatus" = 'Completed' 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 WPR22LA078Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Strawberry, AZThe pilot’s failure to maintain clearance from a static wire during approach.NTSB ERA22LA092Accident · Serious injuriesClass 4 · LimitedFinal reportBeech D55 · Hamilton, ALThe pilot’s failure to properly configure the airplane’s fuel system, which resulted in a loss of engine power on the left engine due to fuel starvation.NTSB CEN22LA084Accident · No injuriesClass 4 · LimitedFinal reportTextron 525 · Dubuque, IAAn inflight collision with a flock of geese that resulted in substantial damage to the vertical stabilizer.NTSB CEN22FA081Accident · 2 fatalClass 3 · FieldFinal reportCessna 208 · Fulshear, TXThe limitations of the see-and-avoid concept as a method for self-separation of aircraft, which resulted in an inflight collision. Contributing to the accident was the absence of collision avoidance technology on both aircraft.NTSB WPR22LA066Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons U S A-315 · Phoenix, AZThe pilot’s inability to maintain balloon control during a high wind landing, which resulted in a serious passenger injury.NTSB CEN22FA080Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · Bloomington, INThe pilot’s failure to follow the instrument landing system (ILS) course guidance, which resulted in the pilot’s loss of airplane control during the instrument approach. Contributing to the accident was the presence of turbulence and low-level wind shear.NTSB ERA22LA090Accident · 2 fatalClass 3 · LimitedFinal reportAerofab Lake LA-4-250 · Auburndale, FLA bird strike, which resulted in a loss of control while flying at low altitude over a lake.NTSB WPR22LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Ivanhoe, CAThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB ERA22LA089Accident · 1 fatalClass 3 · LimitedFinal reportCirrus Design SR22 · Knoxville, TNThe pilot’s encounter with a wake vortex from a preceding airplane, which resulted in a roll upset at an altitude too low for recovery. Contributing to the accident was the failure of ATC to issue a wake turbulence cautionary advisory.NTSB CEN22LA083Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Houston, TXThe instructed pilot and the flight instructor’s failure to extend the landing gear before landing resulting in a wheels up landing.NTSB ANC22LA011Accident · No injuriesClass 3 · LimitedFinal reportLarry Bingham LB-1 · Haines, AKA partial loss of engine power for reasons that could not be determined based on available information, which resulted in a precautionary landing and impact with snow.NTSB CEN22LA078Accident · Minor injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Bridgeport, TXThe pilot’s failure to maintain adequate main rotor RPM during an autorotation which resulted in a hard landing. Contributing to the accident was the pilot’s improper placement of the throttle during the initial practice power-on recovery autorotation.NTSB CEN22LA077Accident · No injuriesClass 4 · LimitedFinal reportHughes 269A · Crowley, TXThe student pilot’s encounter with a loss of tail rotor effectiveness during hover, and the flight instructor’s delayed remedial action that resulted in an emergency landing and impact with terrain.NTSB CEN22FA073Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 407 · LaPlace, LAThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the pilot’s decision to fly in instrument conditions.NTSB ERA22LA091Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 429 · Manhattan, NYThe pilots overapplication of flight controls during landing, which resulted in the rotor blades contacting the wire strike protection system and subsequent hard landing.NTSB DCA22LA044Accident · No injuriesClass 4 · LimitedFinal reportAirbus A320-251N · Paradise, NVThe captain’s failure to maintain proper pitch attitude during landing, likely caused by improper seat position.NTSB CEN22LA079Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Ellinwood, KSThe pilot's improper brake application during the landing roll, which resulted in a nose-over.NTSB CEN22LA074Accident · No injuriesClass 4 · LimitedFinal reportMini-MAX 1600R Sport · South Bend, INThe pilot’s low-level flight and poor visual lookout which resulted in collision with a light pole on final approach and the pilot’s improper decision to operate an airplane under the influence of alcohol.NTSB ERA22LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Hazleton, PAThe pilot’s failure to maintain proper airspeed on approach in tailwind conditions, which resulted in an extended touchdown, bounced landing, and runway excursion.NTSB CEN22LA072Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL18 · Abbeville, LAAn electrical fire for reasons that could not be determined.NTSB CEN22FA070Accident · 1 fatalClass 3 · FieldFinal reportCessna 310J · Inola, OKThe loss of airplane control for reasons that could not be determined based on the available evidence.NTSB WPR22LA062Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Temecula, CAThe total loss of engine power for reasons that could not be determined from the available evidence.NTSB WPR22LA061Accident · 1 fatalClass 3 · LimitedFinal reportMoul Willis RV-3 · Bermuda Dunes, CAThe pilot’s improper positioning of the fuel shutoff valve, which resulted in a loss of engine power, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, resulting in an aerodynamic stall and loss of control.NTSB ERA22LA108Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Lake City, FLThe pilot’s loss of control during the landing flare, which resulted in a runway excursion.NTSB ERA22FA086Accident · 1 fatalClass 3 · FieldFinal reportSwearingen SA226 · Bedford, NHThe pilot’s failure to secure and feather the left engine and increase power on the right engine after a perceived loss of engine power in the left engine, which resulted in a loss of control and impact with terrain just short of the runway. Contributing to…NTSB CEN22FA069Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Steamboat Springs, COThe pilot’s failure to adhere to the published instrument approach procedure, which resulted in controlled flight into terrain.NTSB ERA22FA085Accident · 2 fatalClass 3 · FieldFinal reportBeech V35 · Crab Orchard, KYThe noninstrument-rated pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control and collision with terrain. Contributing to the accident was…NTSB WPR22LA060Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Hillsboro, ORThe on-ground collision with a tree during an off airport precautionary landing. Contributing was the partial loss of engine power for undetermined reasons.NTSB CEN22LA076Accident · Serious injuriesClass 3 · LimitedFinal reportAviat A-1A · St. Jo, TXThe total loss of engine power due to carburetor icing during cruise flight, which resulted in a forced landing and impact with terrain.NTSB CEN22LA075Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Rockwall, TXThe pilot’s failure to go-around during the unstable visual approach, which resulted in a bounced touchdown near the end of the runway and the subsequent runway excursion.NTSB CEN22LA068Accident · Serious injuriesClass 4 · LimitedFinal reportCHR International Safari 400 · McKinney, TXThe pilot did not remove the cyclic control lock during preflight, which resulted in a loss of control during the initial hover.NTSB CEN22FA067Accident · 2 fatalClass 3 · FieldFinal reportPiper PA 28-140 · Houston, TXThe student pilot’s decision to depart into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB ERA22FA083Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Statesboro, GAThe pilot’s decision to initiate a visual flight rules flight into dark night instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control shortly after takeoff.NTSB CEN22LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Delta, COFuel starvation resulting in a loss of engine power.NTSB CEN22FA064Accident · 1 fatalClass 3 · FieldFinal reportVans RV-4 · Walsenburg, COThe pilot’s failure to maintain clearance from terrain while intentionally maneuvering in a canyon at low altitude. Contributing to the accident was the pilot’s decision to enter a canyon environment at a low altitude, and the sudden change in wind conditions…NTSB WPR22LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 310Q · Corona, CAThe pilot receiving instruction failure to extend the landing gear before landing due to distraction and the flight instructor’s inadequate supervision.NTSB ERA22LA082Accident · Minor injuriesClass 3 · LimitedFinal reportBeech S35 · Tallahassee, FLA total loss of engine power due to a lack of oil lubrication.NTSB WPR22FA055Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-31-350 · Medford, ORThe pilot’s failure to maintain aircraft control during the initial climb into clouds due to spatial disorientation, which resulted in an uncontrolled descent and collision with terrain.NTSB WPR22LA056Accident · No injuriesClass 4 · LimitedFinal reportMonte Clark Vans RV8 · Hamilton, MTThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB WPR22FA054Accident · 4 fatalClass 3 · FieldFinal reportBeech V35 · Visalia, CAThe pilot’s loss of control due to spatial disorientation shortly after takeoff. Contributing to the accident was the pilot’s decision to depart into night instrument meteorological conditions.NTSB ERA22LA081Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Bennettsville, SCThe pilot’s inadequate preflight planning, resulting in a takeoff attempt from a grass parking area instead of the runway and subsequent impact with a pole.NTSB CEN22LA071Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV8 · Wichita Falls, TXThe pilot’s improper fuel management that resulted in a total loss of engine power due to fuel starvation.NTSB CEN22FA058Accident · 1 fatalClass 3 · FieldFinal reportCessna 182L · Bonnerdale, ARThe noninstrument rated pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent impact with terrain.NTSB WPR22LA059Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Hachita, NMThe pilot’s failure to adequately monitor the environment during a low level operation, which resulted in collision with vegetation.NTSB ERA22LA084Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Midland, VACollision with a bird in flight, which resulted in damage to the right-wing leading-edge spar.NTSB CEN22LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Tahlequah, OKA loss of yaw control while on final approach, which resulted in the pilot performing an off-runway landing, and a subsequent nose over. The reason for the loss of yaw control could not be determined based on the available evidence.NTSB WPR22FA053Accident · 1 fatalClass 3 · FieldFinal reportRussell W Dyer Vortex · Lakeport, CAThe pilot’s loss of control for reasons that could not be determined and the delayed remedial action to recover from the power pushover event.NTSB CEN22LA063Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · St. Louis, MOThe pilot’s failure to apply power during the recovery procedure for the practice autorotation, which resulted in a hard landing.NTSB CEN22LA059Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Cleveland, TXA total loss of engine power due to fuel starvation, the reason for which could not be determined.NTSB ANC22LA009Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 208 · Port Alsworth, AKThe pilot's failure to maintain a proper approach path which resulted in landing short of the runway and impact with terrain.