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 CEN20CA104Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Athens, TXThe rear seat pilot and the student pilot's failure to see and avoid trees during initial climb following an aborted landing.NTSB WPR20LA096Accident · Minor injuriesClass 3 · LimitedFinal reportLightning Avion Eab Arion Lightning · Jerome, IDThe pilot’s mismanagement of fuel, which resulted in fuel starvation and the pilot’s loss of airplane control during an emergency descent, which resulted in a stall and subsequent impact with terrain.NTSB ERA20CA114Accident · No injuriesData collectionFinal reportCessna 172 · Everglades City, FLThe pilot's failure to maintain airplane control during the landing flare in gusting crosswind conditions, which resulted in the left wing striking the runway.NTSB ERA20CA113Accident · No injuriesData collectionFinal reportLearjet 55 · Farmingdale, NJThe flight crew's failure to stop the airplane on the available runway, which was wet and resulted in the airplane impacting a ditch.NTSB WPR20LA094Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · Torrance, CAThe partial loss of power due to a malfunction of the throttle cable, which limited movement of the throttle body.NTSB CEN20LA109Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Dumas, ARThe pilot’s failure to maintain clearance from a power line pole during a low-level aerial application flight, which resulted in impact with the bracket and a subsequent forced landing.NTSB ERA20CA112Accident · Minor injuriesClass 4 · Data collectionFinal reportBeech 58 · Augusta, GAThe pilot's failure to land and stop the airplane within the available runway, which resulted in a runway overrun. Contributing to the outcome was the pilot's inadvertent feathering of both propellers during approach to landing.NTSB CEN20FA098Accident · 1 fatalClass 3 · FieldFinal reportInnovator Mosquitto · North Manchester, INThe pilot’s loss of control for reasons that could not be determined based on the available information.NTSB WPR20CA093Accident · Minor injuriesData collectionFinal reportAviat A1 · Columbia, CAThe pilot's failure to maintain bank control during landing in gusting wind conditions.NTSB CEN20FA096Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Rogers, MNInadequate maintenance that resulted in improper torque to the engine-driven fuel pump inlet fitting, which led to a loss of engine power and forced landing into unsuitable terrain.NTSB CEN20CA103Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Bunkie, LAThe pilot's failure to lock the tailwheel before landing, which resulted in his loss of directional control during the landing roll, a runway excursion onto soft ground, and a subsequent ground loop.NTSB CEN20CA101Accident · No injuriesData collectionFinal reportCessna A185 · Hawley, MNThe pilot's improper landing flare and touchdown, which resulted in a bounced landing and loss of directional control and the airplane's subsequent impact with a snowbank and ground loop during an attempted go-around.NTSB CEN20CA100Accident · Minor injuriesData collectionFinal reportCommander 114 · Coldwater, MIThe flight instructor’s inadequate communication with the pilot under review about his intention to simulate a single-engine failure and his subsequent exceedance of the airplane’s critical angle of attack when the pilot did not respond as expected, which…NTSB ANC20FA024Accident · 2 fatalClass 3 · FieldFinal reportCessna 305 · Mokuleia, HIA separation of the left rudder cable due to inadequate maintenance, which resulted in an in-flight loss of control and impact with terrain.NTSB ERA20CA107Accident · No injuriesData collectionFinal reportOrlican L60 · Frederick, MDThe pilot's failure to maintain airplane control during the approach, which resulted in the airplane ballooning and then veering left upon landing and the right wing impacting the runway.NTSB ANC20CA023Accident · Minor injuriesClass 4 · Data collectionFinal reportRobinson R44 · Talkeetna, AKThe pilot's failure to maintain adequate clearance from snow covered terrain during an en route descent in flat light conditions, which resulted in controlled flight into terrain.NTSB ERA20CA125Accident · No injuriesData collectionFinal reportCessna 510 · Daytona Beach, FLThe pilot's failure to lower the landing gear before landing. Contributing to the accident was the examiner’s failure to check that the landing gear was extended.NTSB CEN20FA093Accident · 3 fatalClass 3 · FieldFinal reportBeech 200 · Coleman, TXThe pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s distraction with a “popped” circuit breaker and communications with air traffic control.NTSB CEN20CA094Accident · No injuriesData collectionFinal reportCessna 172 · Boulder, COThe pilot's loss of directional control during the landing roll on the slush-covered runway.NTSB ANC20CA022Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Koyuk, AKThe pilot's failure to maintain directional control during a landing in flat light conditions, which resulted in a ground loop.NTSB WPR20CA092Accident · No injuriesData collectionFinal reportBell OH 58A · Colexico, CAThe pilot's failure to arrest the descent rate while maneuvering at low altitude, which resulted in impact with terrain.NTSB CEN20LA095Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Chesterfield, MOThe flight instructor’s and student pilot’s failure to ensure that the landing gear was extended before landing.NTSB ERA20CA106Accident · No injuriesData collectionFinal reportAerospatiale AS350 · Tampa, FLThe flight instructor's inadvertent throttle reduction below idle, which resulted in a total loss of engine power and subsequent impact with terrain following a power-off autorotation.NTSB CEN20CA090Accident · No injuriesData collectionFinal reportRobinson R22 · Cotulla, TXThe pilot's failure to remove the right skid trailer tie-down before attempting to take off, which resulted in a dynamic roll-over.NTSB ERA20LA105Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Fayetteville, NCThe passenger’s excessive control application during the takeoff and the flight instructor’s inadequate remedial action, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA20CA104Accident · No injuriesData collectionFinal reportSchweizer 269C · Ormond Beach, FLThe student pilot's improper pedal and cyclic input while maneuvering, which resulted in a loss of helicopter control.NTSB ERA20CA102Accident · No injuriesData collectionFinal reportCessna 172 · Rochester, NYThe pilot's failure to maintain airplane control during a go-around. Contributing to the accident was the pilot’s decision to take off after perceiving a rudder issue during taxi operations.NTSB CEN20TA088Accident · Minor injuriesClass 3Final reportCessna 170 · Valley Center, KSThe pilot's delayed decision to abort the takeoff when the airplane passed the point where he had anticipated the liftoff would occur.NTSB CEN20CA089Accident · No injuriesData collectionFinal reportPiper PA28 · Sparta, MIThe student pilot's failure to maintain directional control while landing on the snow/slush-covered portion of the runway and the flight instructor's improper decision to allow the student to make his first solo flight from a snow/slush-covered runway.NTSB ERA20LA109Accident · Minor injuriesClass 3 · LimitedFinal reportRockwell 112 · Knoxville, TNA loss of directional control during landing following deflation of a flat-spotted tire for reasons that could not be determined based on available evidence.NTSB ENG20LA016Incident · No injuriesClass 3 · LimitedFinal reportAirbus A319 · Sacramento, CAA worn component within each engine integrated drive generator (IDG) resulted in the loss of electrical power supplied to several flight deck displays and systems while on approach to landing. The component, a fixed cylinder block, had significant wearing of…NTSB CEN20LA092Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150 · Wadsworth, OHThe pilot’s inadequate preflight fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN20CA087Accident · No injuriesData collectionFinal reportVans RV8 · Columbus, MSThe inadvertent engine start of the unoccupied airplane, which resulted in it moving forward and impacting a hangar and an electrical box.NTSB CEN20CA086Accident · No injuriesData collectionFinal reportCessna 182 · Huron, SDThe pilot's failure to maintain adequate airspeed during final approach, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall at too low of an altitude to recover.NTSB WPR20CA102Accident · No injuriesData collectionFinal reportMooney M20K · Minden, NVThe pilot’s failure to complete a before landing checklist, which resulted in his delayed extension of the landing gear, and his subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN20CA085Accident · No injuriesData collectionFinal reportRobinson R44 · Marfa, TXThe pilot's failure to maintain clearance from a fence during low-altitude maneuvering.NTSB ERA20FA101Accident · 2 fatalClass 3 · FieldFinal reportMooney M20J · Bartow, FLThe pilot’s exceedance of the airplane's critical angle of attack and subsequent aerodynamic stall and spin at low altitude due to a possible distraction in the cockpit for which the reason was undetermined.NTSB CEN20LA083Accident · No injuriesClass 3 · LimitedFinal reportPiaggio P180 · Broomfield, COThe pilot’s loss of directional control on the snow-covered runway, which resulted in a runway excursion.NTSB ANC20CA027Accident · No injuriesData collectionFinal reportCessna TP206 · Kahului, HIThe pilot's improper landing flare in gusting crosswind conditions, which resulted in the airplane porpoising and a subsequent a loss of directional control, runway excursion, and nose-over.NTSB WPR20FAMS2Accident · 1 fatalClass 3 · Missing aircraftFinal reportLuscombe 8 · Pacific Ocean, ORUndetermined because the airplane and pilot were not located.NTSB ERA20CA100Accident · No injuriesData collectionFinal reportCessna 402 · Barnstable, MAThe pilot's failure to properly secure the crew hatch door before takeoff, which resulted in the door’s forward hinge assembly tearing from its fuselage mount point.NTSB ENG20LA015Incident · No injuriesClass 4 · LimitedFinal reportAirbus A220 · Bordeaux, FranceA No. 1 (left) engine low pressure compressor (LPC) stage 1 integrally bladed rotor (IBR) separation due to a high cycle fatigue crack (HCF) that originated at the runout of an airfoil leading edge root radius. The HCF crack developed because of a…NTSB CEN20LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 560 · Aledo, TXThe in-flight separation of the upper and lower right engine cowlings for reasons that could not be determined based on available evidence.NTSB WPR20CA090Accident · No injuriesData collectionFinal reportBeech 36 · Avalon, CAThe pilot's improper approach and delayed decision to apply corrective action, which resulted in a runway overrun, impact with a berm, and a subsequent nose-over.NTSB ERA20FA097Accident · 1 fatalClass 3 · FieldFinal reportAviastroitel AC 4C · Front Royal, VAThe pilot's exceedance of the glider’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CEN20LA078Accident · Serious injuriesClass 3 · LimitedFinal reportNavion Navion · Fort Smith, ARThe inadequate inspection of the fuel selector valve, which was degraded, allowed fuel to leak, and resulted in fuel starvation and a loss of engine power.NTSB ERA20FA096Accident · 4 fatalClass 3 · FieldFinal reportCessna 501 · Fairmount, GAThe pilots’ loss of control in flight in freezing instrument meteorological conditions due to spatial disorientation and the cumulative effects of task saturation.NTSB CEN20FA076Accident · 1 fatalClass 3 · FieldFinal reportBeech 33 · Granbury, TXThe pilot's exceedance of the airplane's critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall and loss of control.NTSB CEN20CA079Accident · No injuriesData collectionFinal reportAir Tractor AT-504 · Fort Morgan, COThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in the left main landing gear tire bursting and the tailwheel assembly failing.NTSB ERA20CA095Accident · No injuriesData collectionFinal reportCessna 208 · Baltimore, MDThe pilot's failure to maintain clearance from the approach lights during an instrument approach.