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 CEN20LA290Accident · No injuriesClass 3 · LimitedFinal reportPiper PA22 · Loveland, OHThe loss of engine power due to fuel starvationNTSB WPR20LA225Accident · No injuriesClass 3 · LimitedFinal reportVans RV 8 · Grimes, CAA partial loss of engine power for reasons that could not be determined because the airplane was not examined.NTSB WPR20LA224Accident · 1 fatalClass 3 · LimitedFinal reportHiller UH 12D · Mehama, ORAn in-flight separation of a tail rotor blade due to fatigue cracking and overstress, which resulted in a loss of directional control and subsequent ground impact.NTSB CEN20CA317Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Osceola, WIThe pilots did not maintain directional control of the airplane during landing.NTSB CEN20CA289Accident · No injuriesClass 4 · Data collectionFinal reportCessna 305 · Glenwood Springs, COThe pilot's failure to maintain airplane control during landing resulting in a nose over.NTSB ERA20CA257Accident · Minor injuriesClass 4 · Data collectionFinal reportKade Aventura II · Astor, FLThe pilot's failure to retract the amphibious airplane’s landing gear prior to the water landing, which resulted in a nose over.NTSB CEN20LA288Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Independence, MOFailure of the No. 5 piston head and ring, which resulted in a total loss of engine power and the pilot’s decision to takeoff with a known mechanical issue.NTSB ANC20CA070Accident · No injuriesClass 4 · Data collectionFinal reportBell 206L-1 · Homer, AKThe pilot's failure to see and avoid the boat's mast, which resulted in a main rotor blade strike. Contributing to the accident was the pilot's inadequate preflight planning by not having the boat's mast measured.NTSB WPR20LA223Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Vaughn, NMThe total loss of power in the right engine due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the manufacturer-recommended procedure after the loss of power in the right engine.NTSB ERA20CA253Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Washington, NCThe pilot's failure to maintain directional during landing on a wet grass runway.NTSB CEN20CA285Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Rochester, INThe pilot's failure to maintain directional control during landing resulting in a ground loop.NTSB WPR20CA222Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Hayward, CAThe pilot's failure to maintain airplane control during landing in gusting wind conditions, and the flight instructor's delayed remedial action, which resulted in the left wing striking the runway.NTSB ERA20CA252Accident · Minor injuriesClass 4 · Data collectionFinal reportFurlong CA-6 · Manville, NJA loss of directional control on takeoff for undetermined reasons.NTSB ERA20CA251Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 22 · Fuquay Varina, NCThe pilot's failure to attain a proper approach speed, which resulted in an overrun of the wet grass runway.NTSB CEN20CA284Accident · No injuriesClass 4 · Data collectionFinal reportBeech 95 55 · Spring, TXExcessive wear of the left brake liners which reduced brake effectiveness resulting in a runway excursion.NTSB CEN20CA281Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Houston, TXThe flight instructor and student pilot did not properly transfer airplane control during ground rollout, which resulted in the airplane exiting the runway and impacting a ditch.NTSB CEN20CA280Accident · No injuriesClass 4 · Data collectionFinal reportWaco YKC · New Carlisle, OHThe pilot's failure to maintain proper approach speed and descent path to the runway, which resulted in excessive speed at touchdown and insufficient runway remaining to safely bring the airplane to a stop before the end of the runway. Contributing to the…NTSB ANC20LA069Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Birch Creek, AKA loss of control for undetermined reasons while on the surface of the water during scoop operations in support of wildland firefighting operations.NTSB ANC20CA071Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Palmer, AKThe pilot's loss of control during landing, which resulted in a ground loop and left main landing gear collapse.NTSB WPR20CA220Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Port Townsend, WAThe pilot's failure to maintain directional control during a crosswind landing, which resulted in a nose over.NTSB ERA20LA247Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Fort Lauderdale, FLThe failure of both pilots to see and avoid each other while taxiing, which resulted in a ground collision. Contributing to the accident was the tower controller’s failure to provide information to each pilot regarding the position and intention of the other…NTSB ERA20CA246Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA22 · Cortland, NYThe mechanic’s incorrect rigging of the aileron control cables, which resulted in a reversal of aileron control inputs applied by the pilot during the takeoff. Also causal was the mechanic’s inadequate post-maintenance inspection and the pilot's inadequate…NTSB WPR20CA227Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · McCall, IDThe pilot's decision to land with excessive approach airspeed, which resulted in the airplane landing long, the application of additional braking action to stop and subsequent nose over.NTSB WPR20CA219Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Concord, CAThe student pilot's failure to maintain airplane control when the airplane drifted off of runway centerline and subsequently collided with a taxiway sign during a go-around.NTSB WPR20CA218Accident · No injuriesClass 4 · Data collectionFinal reportRans S6 · Richland, WAThe pilot's inability to arrest a descent rate or maintain altitude after encountering a downdraft while maneuvering at low altitude near mountainous terrain that resulted in a hard landing.NTSB ERA20LA245Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Falmouth, KYThe pilot’s failure to ensure that an adequate supply of fuel was available for the flight, which resulted in total loss of engine power due to fuel exhaustion.NTSB CEN20LA276Accident · No injuriesClass 3 · LimitedFinal reportRockwell S2R R1340 · Keokuk, IAThe improper installation of a fuel vent line during maintenance, which resulted in fuel starvation and a total loss of engine power.NTSB CEN20CA277Accident · Minor injuriesClass 4 · Data collectionFinal reportKitfox Kitfox Sport · Rand, COThe encounter with the downdrafts during the attempted takeoff, which resulted in decreased airplane's climb performance and subsequent impact with terrain.NTSB WPR20LA216Accident · 1 fatalClass 3 · LimitedFinal reportSchleicher ASW27 · Ely, NVThe pilot’s loss of glider control while maneuvering near a mountain ridge in downdrafts and dry microbursts at an altitude that precluded recovery.NTSB WPR20CA232Accident · No injuriesClass 4 · Data collectionFinal reportCessna U206 · Nenana, AKThe pilot's failure to maintain directional control during a soft field takeoff on a dirt airstrip, which resulted in an impact with a vehicle.NTSB WPR20CA221Accident · No injuriesClass 4 · Data collectionFinal reportQuickie Q2 · Preston, IDThe pilot's failure to maintain airplane control during takeoff in high density altitude conditions, which resulted in a collision with terrain. Contributing to the accident was the pilot's failure to accomplish performance calculations for the atmospheric…NTSB ERA20CA249Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Pickens, SCThe student pilot's improper landing flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB ERA20CA244Accident · Minor injuriesClass 4 · Data collectionFinal reportNew Kolb Kolb Flyer SS · Lutz, FLThe flight instructor’s failure to maintain control of the airplane following an unannounced transfer of flight control during takeoff.NTSB CEN20LA273Accident · Serious injuriesClass 3 · LimitedFinal reportAerospatiale AS355 · Rifle, COA loss of tail rotor effectiveness, the pilot’s subsequent loss of helicopter control, and collision with terrain.NTSB CEN20LA272Accident · 1 fatalClass 3 · LimitedFinal reportGolden Circle Air T-Bird · Grosse Ile, MIThe noncertificated pilot’s failure to maintain clearance from trees while maneuvering at low altitude in gusting wind conditions. Contributing to the accident was the pilot’s lack of flight experience.NTSB CEN20CA274Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA32 · Springfield, OHThe pilot’s inadequate inflight planning that resulted in a loss of engine power due to fuel exhaustion.NTSB ERA20CA248Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Culpeper, VAThe pilot’s failure to maintain directional control on landing resulting in a runway excursion and subsequent ground loop. Contributing to the outcome were the flight instructor’s inadequate remedial actions.NTSB CEN20LA279Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Dalhart, TXThe total loss of engine power due to a failed fuel control unit bearing.NTSB CEN20LA278Accident · 1 fatalClass 3 · LimitedFinal reportGrumman G164 · Springfield, COThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in collision with terrain. Contributing to the accident was the combining of chemicals known to produce foam and the pilot’s failure to…NTSB CEN20LA271Accident · 1 fatalClass 3 · LimitedFinal reportCessna T188 · Dustin, OKThe pilot’s continued takeoff without ensuring obstacles could be avoided due to his use of a sedating medication, which likely diminished his reaction time and flying performance.NTSB ANC20CA068Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Ketchikan, AKThe crew leader's decision to throw a chainsaw bar into the moving arc of the main rotor blade.NTSB ANC20CA067Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA32 · Naknek, AKThe PA-32 pilot's failure to see and avoid the other airplane.NTSB WPR20CA255Accident · Minor injuriesClass 4 · Data collectionFinal reportAir Creation/Sides Rick A Manta 503 · Ramona, CAThe solo student pilot's improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB ERA20CA250Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Auburn, METhe student pilot's improper landing flare, which resulted in a hard landing on the nosegear and nosegear collapse.NTSB DCA20CA122Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer ERJ170 · Plainfield, ILan encounter with convective turbulence.NTSB CEN20LA270Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 188 · Pembina, NDThe pilot’s failure to maintain control during an aerial spray turnaround in high crosswind conditions.NTSB WPR20LA215Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Port Orchard, WAThe pilot's delayed decision to go around from an unstable approach, which resulted in insufficient airplane performance to climb above rising terrain and a subsequent aerodynamic stall.NTSB WPR20CA236Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Farewell Lakes, AKThe pilot's delayed decision to abort the takeoff roll, which resulted in a runway overrun and airplane nose over.NTSB WPR20CA217Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Absarokee, MTThe pilot's failure to maintain airplane control during a go-around that resulted in the airplane exceeding its critical angle of attack and aerodynamically stalling which resulted in a collision with the ground.NTSB CEN20LA282Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Venice, LAA partial loss of engine power for reasons that could not be determined based on available evidence.