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 ANC22FA069Accident · 1 fatalClass 3 · FieldFinal reportStory Charles Brad TT FOX · Wasilla, AKThe pilot’s inability to maintain control of the airplane for reasons that could not be determined.NTSB ERA22LA390Accident · No injuriesClass 4 · LimitedFinal reportBell Textron Canada 505 · Chamblee, GAThe pilot’s failure to ensure that the helicopter was properly positioned over a dolly before attempting to land on it, which resulted in a rollover.NTSB ERA22FA387Accident · 2 fatalClass 3 · FieldFinal reportSea & Sky Krucker Cygnet · Emily, MNThe pilot’s operation of the weight-shift control aircraft over its design gross weight and his decision to take off with the engine operating at less than the specified takeoff rpm, which resulted in degraded takeoff and climb performance. Contributing to…NTSB ERA22FA386Accident · 1 fatalClass 3 · FieldFinal reportBeech B35 · French Lick, INThe pilot’s failure to make a stabilized approach, which resulted in a loss of directional control during landing.NTSB CEN22LA398Accident · No injuriesClass 3 · LimitedFinal reportCessna 172I · Olivet, MIThe pilot’s failure to attain/maintain a proper glidepath that resulted in a hard landing and impact with the runway.NTSB WPR22LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 305C (0-1E) · Rexburg, IDThe pilot's failure to maintain airplane control during the landing roll on a wet airstrip.NTSB WPR22LA318Accident · No injuriesClass 4 · LimitedFinal reportLeon E Everett Carbon CUB EX · Maricopa, AZThe pilot's failure to maintain airplane control during landing with a crosswind and the use of excessive braking application, which resulted in a nose over.NTSB ERA22LA389Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 140 · Slocomb, ALThe partial loss of engine power during takeoff for reasons that could not be determined.NTSB ERA22LA388Accident · Minor injuriesClass 4 · LimitedFinal reportSchleicher K7 · Mayville, NYThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in an off-airport landing.NTSB CEN22LA396Accident · Minor injuriesClass 4 · LimitedFinal reportJavron Experimental PA18 Replica · Osceola, IAThe stuck right brake at landing which resulted in a loss of control.NTSB CEN22LA395Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Prue, OKThe pilot’s failure to maintain clearance from power lines during intentional low-level maneuvering.NTSB WPR22LA329Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 Clipper 1 · Deadhorse, AKThe pilot's failure to maintain helicopter control during a descent, which resulted in a collision with terrain.NTSB WPR22LA322Accident · Minor injuriesClass 3 · LimitedFinal reportRay E Roberts Kitfox V Vixen · Caldwell, IDThe partial loss of engine power due to a loose wire leading to the engine’s electronic control unit (ECU). Contributing was the pilot’s exceedance of the critical angle of attack while maneuvering, which resulted in an aerodynamic stall at an altitude too…NTSB WPR22LA320Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Ione, CAThe flight instructor’s delayed decision to abort the takeoff, which resulted in impact with a fence and a tree. Contributing to the accident was the instructor’s decision to land at the unfamiliar airstrip without determining whether it was within the…NTSB WPR22LA317Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design General Avn Ctsw SuperSport · Boulder City, NVA total loss of engine power for undetermined reasons.NTSB ERA22LA415Accident · No injuriesClass 4 · LimitedFinal reportCessna T210N · Georgetown, DEThe pilot's failure to extend the landing gear before landing. Contributing to the accident was an inoperative landing gear warning horn.NTSB ERA22LA385Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kissimmee, FLThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the nose landing gear impacting the runway.NTSB CEN22LA408Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Murray, NEThe pilot’s failure to maintain airplane control during landing resulting in an impact with crop and a subsequent ground-loop. Contributing was the wet turf airstrip.NTSB WPR22LA316Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150H · Vacaville, CAThe partial loss of engine power due to a stuck exhaust valve.NTSB ERA22FA384Accident · 2 fatalClass 3 · FieldFinal reportMXR Technologies MX2 · Osteen, FLThe pilot’s loss of airplane control while performing aerobatic maneuvers, which resulted in the airplane entering an inverted flat spin that continued until the airplane impacted terrain.NTSB CEN22LA411Accident · No injuriesClass 4 · LimitedFinal reportCessna T210L · Atoka, OKThe pilot's failure to land the airplane within the desired touchdown zone, which resulted in a long landing and collision with a fence.NTSB CEN22LA394Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Liberty, MOThe flight instructor’s improper decision to take off without adequate airspeed which resulted in degraded performance and a collision with trees.NTSB CEN22LA393Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1 · Harvard, ILThe pilot’s failure to maintain directional control during take-off, which resulted in a collision with crop and terrain.NTSB WPR22LA326Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Egegik, AKThe pilot's failure to maintain directional control during takeoff from a lake.NTSB WPR22LA324Accident · No injuriesClass 3 · LimitedFinal reportChampion 7GCBA · Athol, IDThe failure of the right brake due to a disconnected master cylinder piston rod, which led to the departure of the airplane from the runway surface. Contributing to the accident was the mechanic’s failure to adequately inspect the connection between the…NTSB WPR22LA313Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-30 · St Ignatius, MTA partial loss of power during takeoff for undetermined reasons.NTSB ERA22FA383Accident · 2 fatalClass 3 · FieldFinal reportBell 206B · Whiteside, TNThe pilot’s failure to maintain clearance from the powerlines.NTSB CEN22LA444Accident · No injuriesClass 4 · LimitedFinal reportRockwell International 112A · Lee's Summit, MOThe pilot’s improper landing flare, which resulted in a bounced landing and the nose landing gear collapse.NTSB WPR22LA325Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D1 · Hope, AKThe pilot’s failure to maintain clearance from a tree while taxiing.NTSB WPR22LA314Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F33A · Wilder, IDCatastrophic engine failure during the initial climb due to an incorrectly installed crankshaft counterweight retaining ring.NTSB WPR22FA312Accident · 2 fatalClass 3 · FieldFinal reportJackson Dennis RV-8 · Scio, ORThe pilot’s decision to perform a low-altitude aerobatic maneuver and his improper execution of the maneuver, which resulted in impact with terrain.NTSB ERA22LA382Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7AC · Clermont, FLThe pilot’s inability to maintain directional control while landing due to a worn tailwheel locking mechanism, which resulted in a runway excursion and collision with terrain.NTSB CEN22LA400Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · San Isidro, TXThe pilot’s improper decision to conduct an autorotation with a tailwind, which resulted in a hard landing and substantial damage.NTSB WPR22LA371Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172M · Pacific Ocean, CAUndetermined because the airplane and pilot were not located.NTSB WPR22LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Donnelly, IDThe pilot’s improper decision to takeoff from a wet grass runway which did not allow for adequate braking traction when the pilot aborted the takeoff, which resulted in a runway excursion.NTSB WPR22FA311Accident · 1 fatalClass 3 · FieldFinal reportSmyth Sidewinder TD · Wichita Falls, TXThe pilot’s inexperience with the airplane and inadequate takeoff procedures, which led to exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.NTSB ERA22LA380Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Berry, ALA partial loss of engine power due to the No. 3 cylinder’s stuck exhaust valve.NTSB ERA22LA379Accident · Minor injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Bealeton, VAThe pilot of the departing airplane’s failure to see and avoid the landing airplane before takeoff, resulting in a collision with the landing airplane. Contributing was the airport’s failure to encourage pilots to use radios for traffic deconfliction when…NTSB WPR22LA328Accident · No injuriesClass 4 · LimitedFinal reportFall Martin Super CUB · Stanley, IDThe pilot’s failure to maintain airplane control during takeoff with a crosswind.NTSB ERA22LA408Accident · No injuriesClass 4 · LimitedFinal reportMooney M20E · Hollywood, MDThe pilot's failure to extend the landing gear before landing.NTSB ERA22LA381Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Orlando, FLThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA22LA378Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Marathon, FLA total loss of power for undetermined reasons.NTSB ERA22FA376Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Glendora, MSThe collision with terrain for reasons that could not be determined.NTSB DCA22LA188Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-824 · Pharisburg, OHThe airplane’s inadvertent encounter with convective turbulence.NTSB CEN22LA435Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Grand Glaize, MOThe pilot’s improper landing flare which resulted in a bounced landing.NTSB WPR22LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Avalon, CAThe pilot’s failure to extend the landing gear before landing, resulting in a gear up landing and substantial damage to the airplane’s belly.NTSB WPR22LA310Accident · Serious injuriesClass 3 · LimitedFinal reportStucker Gary Banty · Camarillo, CAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB WPR22LA308Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 195 · El Cajon, CAThe pilot’s failure to verify the fuel quantity prior to departure, which led to a loss of engine power due to fuel exhaustion.NTSB WPR22FA309Accident · 3 fatalClass 3 · FieldFinal reportCessna 152 · Watsonville, CAThe failure of the pilot of the multi-engine airplane to see and avoid the single-engine airplane while performing a straight-in approach for landing.NTSB ERA22LA375Accident · 1 fatalClass 4 · LimitedFinal reportCessna 172 · Atlantic Ocean (Atlantic Ocean)The pilot's suicide.