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 CEN22LA108Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Lamesa, TXThe pilot’s failure to maintain clearance from terrain during a descent that resulted in an impact with terrain.NTSB ANC22LA014Accident · No injuriesClass 3 · LimitedFinal reportBell 205A-1 · El Cajon, CAA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB ANC22LA012Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Hana, HIThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB WPR22LA080Accident · Serious injuriesClass 3 · LimitedFinal reportWalter Tachiki Tachiki 750 Cruzer · Spanish Fork, UTA partial loss of engine power due to an obstructed catalytic converter, which most likely resulted from the pilot’s failure to properly repair or replace it after it was likely damaged during a previous incident. Contributing to the accident was the pilot’s…NTSB CEN22LA105Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Carrizo Springs, TXThe pilot’s failure to maintain directional control of the airplane during landing with a gusting crosswind that resulted in a runway excursion.NTSB CEN22FA100Accident · 2 fatalClass 3 · FieldFinal reportBell 407 · Houma, LAThe pilot’s sudden loss of consciousness for undetermined reasons during cruise flight, which resulted in a loss of control and impact with terrain.NTSB WPR22LA088Accident · No injuriesClass 3 · LimitedFinal reportExtra Flugzeugbau EA 300/L · Phoenix, AZThe failure of the right brake due to the separation of the brake pad from the brake assembly. Also causal was the improper maintenance of the airplane, which resulted in the use of a brake pad that was inappropriate for the airplane make and model.NTSB WPR22LA079Accident · No injuriesClass 4 · LimitedFinal report2021fx3 CCX-2000 · Redmond, ORThe pilot's failure to maintain directional control during the landing roll.NTSB ERA22LA109Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Lexington, SCA loss of engine power due to a shift of the No. 3 main journal bearing, which resulted in blocked oil ports that restricted oil to the engine’s internal components and a subsequent catastrophic engine failure.NTSB ERA22LA107Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Winter Haven, FLThe pilot receiving instruction’s failure to maintain airspeed during a turn, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall. Contributing to the accident was the flight instructor’s failure to…NTSB ERA22LA106Accident · No injuriesClass 4 · LimitedFinal reportCharles C Menger JR Safari 400 · Gallatin, TNA reported stuck throttle for reasons that could not be determined during postaccident examinations and subsequent loss of control during hover.NTSB ERA22LA129Accident · No injuriesClass 4 · LimitedFinal reportLindstrand Balloons 60X · Louisville, KYThe pilot applicant’s delayed reaction to the balloon's increased rate of descent, which resulted in impact with a light pole.NTSB ERA22LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Edisto Island, SCA loss of engine power due to the fatigue failure of the crankshaft counterweight retaining ring and the No. 6 connecting rod.NTSB ERA22FA105Accident · Serious injuriesClass 3 · FieldFinal reportEurocopter Deutschland EC135 P2+ · Drexel Hill, PAAn inflight attitude upset for undetermined reasons that resulted in a rotor system overspeed, a reduction of power from both engines, and a subsequent hard landing.NTSB CEN22LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Wahoo, NEThe pilot’s failure to maintain directional control during the landing.NTSB WPR22LA077Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-16 · Creswell, ORThe pilot’s excessive left brake pedal application during landing roll, which resulted a loss of directional control, runway excursion, and nose over.NTSB WPR22LA076Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172H · Los Angeles, CAThe pilot’s inadequate preflight inspection during which he failed to remove all water contamination in the fuel system, which resulted in a total loss of engine power on takeoff. Contributing to the accident was the condition of the fuel caps, which allowed…NTSB CEN22FA096Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Defiance, MOThe pilot’s loss of airplane control while flying in night instrument conditions due to spatial disorientation and the flight crew’s inability to recover from an unusual airplane attitude.NTSB ERA22LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Knoxville, TNThe pilot of the Cessna 150’s failure to avoid the taxiing Cessna 172.NTSB CEN22LA098Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Youngstown, OHA loss of engine power for reasons that could not be determined based on available information, which resulted in a forced landing.NTSB CEN22LA095Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Washington, INThe pilot’s failure to maintain directional control while landing in gusty crosswind conditions which resulted in a runway excursion.NTSB ERA22LA101Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Lebanon, TNThe failure of the certified flight instructor to attain the proper glidepath which resulted in a collision with a fence and terrain.NTSB CEN22LA097Accident · No injuriesClass 3 · LimitedFinal reportAviat A-1B · Matagorda Island, TXThe pilot’s loss of directional control during an intentional off-airport landing.NTSB WPR22LA072Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 120 · Upland, CAThe pilot’s loss of airplane control during a go-around as it encountered wake turbulence from a slow hover taxiing helicopter.NTSB CEN22LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Minocqua, WIThe pilot’s loss of control during landing when the airplane encountered ice and snow on the runway.NTSB CEN22LA102Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Grand Forks, NDFailure of the landing gear to properly extend before landing for reasons that could not be determined.NTSB CEN22LA093Accident · No injuriesClass 3 · LimitedFinal reportZenith CH750 · Montrose, COA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR22LA074Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Jordan Valley, ORThe pilot’s decision to takeoff on remote snow covered terrain which, resulted in a nose-over.NTSB ERA22LA099Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20C · Southeast Arcadia, FLThe total loss of engine power for reasons that could not be determined based on the available evidence for this investigation.NTSB CEN22LA094Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182C · Port Aransas, TXThe loss of engine power due to carburetor icing and the pilot’s failure to utilize carburetor heat.NTSB WPR22LA070Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Mojave, CAThe pilot’s failure to maintain airplane control during an encounter with a wind gust during taxi.NTSB WPR22FA073Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Marana, AZThe pilot’s loss of airplane control due to spatial disorientation after entering instrument meteorological conditions. Contributing to the accident was the pilot’s impairment due to use of methamphetamine before the flight.NTSB ERA22FA098Accident · 4 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Bronson, FLA loss of control due to spatial disorientation as a result of the noninstrument-rated pilot’s improper decision to attempt a visual flight rules flight at night into an area of known reduced visibility due to fog.NTSB DCA22LA053Accident · No injuriesClass 4 · LimitedFinal reportAirbus A330 · Newark, NJTurkish Airlines flightcrew’ s misperception of the distance to safely pass the stopped Republic Airways airplane.NTSB WPR22LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 150C · Johnsondale, CAThe pilot’s failure to maintain directional control of the airplane while landing on a snow-covered unimproved runway.NTSB CEN22LA091Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Presidio, TXThe non-certificated pilot’s failure to perform a preflight weight and balance calculation and his decision to operate the airplane beyond the allowable center of gravity limitations, which resulted in a loss of control and impact with terrain.NTSB CEN22LA087Accident · 1 fatalClass 3 · LimitedFinal reportJ&J Ultralights Seawing · Golden, MOThe noncertificated pilot’s failure to maintain aircraft control while aggressively maneuvering at low altitude.NTSB CEN22FA086Accident · 2 fatalClass 3 · FieldFinal reportBell 206B · Livingston, TXThe pilot exceeding the yaw control capability of the helicopter for the flight conditions, resulting in a non-mechanical loss of tail rotor effectiveness.NTSB ERA22LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Berlin, NJAn inadvertent in-flight collision with a goose while on approach.NTSB ERA22LA097Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 207 · Marathon, FLA total loss of engine power due to the failure of the No. 2 bearing, which resulted in the No. 2 connecting rod failing due to fatigue, high heat, and stress.NTSB ERA22FA096Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Cosby, TNThe pilot’s intentional, continued flight into instrument meteorological conditions in a helicopter that was not certified for instrument conditions, which resulted in a loss of helicopter control and a collision with trees and terrain.NTSB WPR22FA068Accident · 4 fatalClass 3 · FieldFinal reportGates Learjet 35A · El Cajon, CAThe flight crew’s decision to descend below the published MDA, cancel their IFR clearance to conduct an unauthorized circle-to-land approach to another runway while the airport was in nighttime IFR conditions, and the exceedance of the airplane’s critical…NTSB CEN22LA085Accident · No injuriesClass 3 · LimitedFinal reportBeech A100 · West Helena, ARThe malfunction of the propeller autofeather system after takeoff for undetermined reasons, which resulted in both propellers going into feather and a hard landing.NTSB ERA22FA095Accident · 2 fatalClass 3 · FieldFinal reportMooney M20J · Jacksonville, FLThe pilot’s failure to maintain airspeed during initial climb, which resulted in an aerodynamic stall/spin. Contributing was the pilot’s likely distraction due to the opening of the baggage door.NTSB CEN22FA082Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Hardy, ARThe non-instrument rated pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was a loss of engine power due to fuel…NTSB CEN22LA089Accident · Minor injuriesClass 3 · LimitedFinal reportLancair IV · Iron Mountain, MIThe total loss of engine power after takeoff for undetermined reasons.NTSB CEN22LA088Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Rainbow, TXThe pilot’s improper decision to conduct an intentional low altitude flight which resulted in a collision with wires and impact with terrain.NTSB ANC22LA015Accident · No injuriesClass 4 · LimitedFinal reportEurocopter France AS350B2 · Kahului, HIThe pilot’s abrupt flight control inputs to correct for dynamic rollover, resulting in a hard landing.NTSB WPR22LA069Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172N · Auburn, CAThe pilot’s failure to maintain altitude during an instrument approach, which resulted in an impact with power lines.NTSB WPR22FA067Accident · 2 fatalClass 3 · FieldFinal reportVans RV6 · Show Low, AZThe pilot’s exceedance of the airplane’s critical angle of attack following an aborted landing approach, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery.