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 CEN20LA063Accident · Serious injuriesClass 3 · LimitedFinal reportPiel CP301 · Paulding, OHThe pilot’s failure to maintain control of the airplane following the loss of engine power. The loss of engine power was the result of fuel starvation due to the degraded fuel tank and fuel contamination.NTSB ERA20LA079Accident · No injuriesClass 3 · LimitedFinal reportRans S12 · Titusville, FLA total loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN20CA062Accident · No injuriesData collectionFinal reportBeech 76 · St. Charles, MOThe pilot receiving instruction’s misunderstanding of the flight instructor’s instruction and the pilot's and the instructor’s insufficient use of rudder while adding power to the operating engine, which resulted in the airplane rolling left and the wing…NTSB ANC20LA015Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 200 · Unalaska, AKThe pilot’s improper decision to takeoff downwind and to load the airplane beyond its allowable gross weight and center of gravity limits, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the inadequacy of the…NTSB WPR20FA065Accident · 1 fatalClass 3 · FieldFinal reportCessna T310 · Roy, UTThe pilot’s inadequate preflight fuel planning and fuel management, which resulted in a total loss of power to the left engine due to fuel exhaustion. Also causal was the pilot's failure to follow the one-engine inoperative checklist and maintain the…NTSB ERA20LA076Accident · Serious injuriesClass 3 · LimitedFinal reportMagni M-24 Plus · Nashua, NHThe pilot's incapacitation during the takeoff roll due to a stroke.NTSB ERA20CA075Accident · Minor injuriesClass 4 · Data collectionFinal reportVans Vans RV 9 · Coleman, FLThe pilot's failure to properly configure the airplane for takeoff, which resulted in premature liftoff, loss of control, and collision with terrain.NTSB ERA20LA077Accident · No injuriesClass 3 · LimitedFinal reportVelocity Elite RG · St. Petersburg, FLA failure of the propeller pitch change electric motor, which resulted in an improper setting for takeoff and a subsequent runway overrun. Also causal was the inadequate maintenance and inspection of the propeller system and the pilot’s failure to follow the…NTSB ERA20CA081Accident · Minor injuriesData collectionFinal reportPereyra Aventura · East Palatka, FLThe pilot's failure to properly configure the amphibious airplane for a water landing, which resulted in it flipping over.NTSB WPR20CA064Accident · Minor injuriesData collectionFinal reportAirborne XT912 · Hawthorne, CAThe student pilot's failure to arrest the airplane’s descent rate, which resulted in a hard landing.NTSB WPR20FA063Accident · 4 fatalClass 3 · FieldFinal reportCessna TR182 · Billings, MTThe pilot’s failure to maintain clearance due to poor decision making in selecting an unsafe altitude during cruise flight.NTSB WPR20CA087Accident · No injuriesData collectionFinal reportPiper PA28 · Santa Barbara, CAThe pilot's failure to maintain clearance from a parked airplane during taxi operations at night.NTSB ANC20LA013Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Fairbanks, AKThe improper installation of a hydraulic line at the right main landing gear (MLG) unlock actuator, which resulted in a total loss of system hydraulic pressure and failure of the landing gear to extend. Contributing to the accident was the failure of the…NTSB CEN20LA058Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Bandera, TXThe in-flight electrical fire, which resulted in smoke in the cabin and an emergency landing. Contributing to the accident was the unsuitable terrain for the emergency landing.NTSB ERA20FA074Accident · 2 fatalClass 3 · FieldFinal reportRobinson R66 · Mechanicsburg, PAA severe left roll excursion after the onset of pitch and roll oscillations, which were not arrested by the pilot for undetermined reasons. This resulted in main rotor blade contact with the airframe and a subsequent inflight breakup of the helicopter.NTSB DCA20CA058Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A320 · New Orleans, LAan encounter with convectively induced turbulence while overflying an area of known convective activity.NTSB WPR20CA066Accident · No injuriesData collectionFinal reportPiper PA 23 · Helena, MTThe pilot's improper decision to attempt an off-airport departure from rough terrain without inspecting the takeoff area, which resulted in a collision with a shallow rut during takeoff and the nose landing gear collapsing.NTSB ERA20LA071Accident · Minor injuriesClass 3 · LimitedFinal reportHughes OH 6A · Preston, GAA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA20CA140Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Palm Coast, FLThe student pilot's failure to allow adequate separation when passing the parked airplane, which resulted in a ground collision.NTSB DCA20CA049Accident · No injuriesData collectionFinal reportBoeing 737 · New York, NYfailure of the deicing truck driver to maintain appropriate clearance from the airplane.NTSB ERA20CA072Accident · Minor injuriesData collectionFinal reportBeech 23 · Norfolk, VAThe pilot receiving instruction's failure to maintain airplane control during landing with a crosswind, which resulted in a bounced landing, and the flight instructor's delayed remedial action, which resulted in a loss of control during the go-around.NTSB ANC20CA012Accident · Minor injuriesClass 4 · Data collectionFinal reportCirrus SR22 · Kapolei, HIThe student pilot's loss of airplane control during a short field takeoff in gusting crosswind conditions, and the designated pilot examiner's delayed remedial action.NTSB WPR20LA062Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · El Monte, CAThe inflight separation of a section of a propeller blade due to a fatigue crack which resulted in a forced landing.NTSB ERA20LA069Accident · Serious injuriesClass 3 · LimitedFinal reportGlassair I · Mount Sterling, KYThe pilot’s mismanagement of the fuel selector, which resulted in fuel starvation and a total loss of engine power.NTSB ERA20FA068Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Newborn, GAThe pilot’s impairment/incapacitation from carbon monoxide poisoning due to a degraded muffler. Contributing to the accident was the pilot’s failure to properly maintain the airplane.NTSB ERA20FA063Accident · 2 fatalClass 3 · FieldFinal reportVans Vans RV-6 · Cullman, ALThe pilot’s inadequate planning, which resulted in fuel exhaustion and a total loss of engine power during the initial climb. Also causal was the pilot’s exceedance of the airplane’s critical angle of attack while attempting to return to the runway after…NTSB ERA20CA065Accident · Serious injuriesClass 4 · Data collectionFinal reportAmerican AA5 · Rutherfordton, NCThe pilot's failure to maintain control of the airplane during an intentional aerodynamic stall, which resulted in a spin and subsequent collision with terrain.NTSB WPR20FA057Accident · 1 fatalClass 3 · FieldFinal reportThunder Mustang TM-1 · Santa Clarita, CAEngine detonation that resulted in material deformation of the crankcase and led to engine failure and restricted cockpit visibility.NTSB WPR20CA060Accident · No injuriesData collectionFinal reportCessna 150 · Twentynine Palms, CAThe pilot's poor preflight planning, during which he failed to verify the proper procedure to activate the runway lights; his inability to locate the airport without lighting; and the airplane’s subsequent low-fuel state as he circled looking for the airport,…NTSB WPR20CA059Accident · No injuriesData collectionFinal reportSud SE 3130 Alouette II · Mokelumne Hills, CAThe pilot's failure to maintain adequate clearance from terrain during a hover-taxi, which resulted in the helicopter's skid contacting grass and a subsequent dynamic roll-over.NTSB ERA20CA139Accident · No injuriesData collectionFinal reportBeech 200 · Morristown, NJThe airplane hydroplaning while landing on a wet runway, which degraded its braking capability and resulted in a runway overrun onto grass and mud and the nose landing gear collapsing. Contributing to the accident was the pilot's improper decision to land the…NTSB CEN20LA055Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 100 · Mullin, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA20CA073Accident · No injuriesData collectionFinal reportBeech Hawker 900XP · San Juan, PRThe pilot's failure to maintain a proper descent rate during landing, which resulted in a hard landing short of the runway.NTSB WPR20CA069Accident · Serious injuriesData collectionFinal reportGulfstream G IV · Van Nuys, CAThe airplane’s encounter with turbulence during descent, which resulted in a serious injury to a flight attendant.NTSB ERA20LA064Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Kenansville, NCA fatigue failure of the camshaft due to a manufacturing defect, which resulted in a partial loss of engine power.NTSB CEN20LA053Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T210 · Ada, OKThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation, and the pilot’s inadequate preflight inspection and preflight fuel planning.NTSB ANC20CA011Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Fairbanks, AKThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, an emergency off-airport landing, and a nose over.NTSB WPR20CA055Accident · No injuriesData collectionFinal reportCessna 175 · Elk, CAThe pilot's failure to arrest the descent rate during an aborted simulated engine-out approach, which resulted in impact with vegetation and a subsequent cartwheel.NTSB CEN20LA051Accident · No injuriesClass 3 · LimitedFinal reportEnstrom F28 · Danbury, TXThe failure of the engine's No.3 intake valve resulting is a loss of engine power and a rollover following the autorotation to soft ground.NTSB CEN20FA049Accident · 2 fatalClass 3 · FieldFinal reportMooney M20S · Olathe, KSThe pilot’s failure to set the elevator trim properly for takeoff, which resulted in an exceedance of the airplane’s critical angle of attack during climb out, an aerodynamic stall, and the subsequent impact with terrain.NTSB CEN20CA052Accident · No injuriesData collectionFinal reportPiper PA28R · Onaga, KSThe pilot's improper decision to take off with the airplane at a high gross weight from a short, turf runway, which degraded its climb performance and led to a delayed aborted takeoff, a runway excursion, and impact with terrain.NTSB WPR20LA054Accident · No injuriesClass 3 · LimitedFinal reportMitsubishi MU2B · Big Piney, WYThe failure of the right propeller position to correspond to the throttle change when moved to the beta position for reasons that could not be determined based on available evidence.NTSB CEN20CA048Accident · No injuriesData collectionFinal reportVans RV 10 · Granbury, TXThe airplane’s impact with a bird while on approach.NTSB CEN20CA047Accident · No injuriesData collectionFinal reportCessna 182 · Robstown, TXThe pilot's failure to set the friction lock on the throttle before hand propping the engine, which allowed the airplane to move forward and impact a credit card machine. Contributing to the accident was the malfunction of the parking brake for reasons that…NTSB ERA20FA060Accident · 1 fatalClass 3 · FieldFinal reportAmerican AA5 · College Park, MDThe pilot's loss of airplane control due to spatial disorientation after entering a climbing turn in instrument meteorological conditions.NTSB WPR20CA053Accident · No injuriesData collectionFinal reportCessna 170 · Missoula, MTThe pilot receiving instruction's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and ground-loop, and the flight instructor’s failure to adequately monitor the pilot.NTSB ERA20LA082Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20J · Farmingdale, NYThe pilot’s improper preflight inspection, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA20LA062Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32RT · Fletcher, NCA failure of two of the oil pump drive gear’s teeth, which resulted in a loss of engine oil lubrication, and a total loss of engine power.NTSB CEN20MA044Accident · 5 fatalClass 2 · MajorFinal reportPiper PA 31T · Lafayette, LAThe pilot’s loss of airplane control due to spatial disorientation during the initial climb in instrument meteorological conditions.NTSB WPR20FA051Accident · No injuriesClass 3 · FieldFinal reportCirrus SF50 · Santa Monica, CAThe improper design of the audio interface system, which caused an electrical short circuit that led to a ground fire.