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 WPR20LA319Accident · 1 fatalClass 3 · LimitedFinal reportCessna T182 · Santa Barbara, CAThe pilot’s loss of airplane control due to spatial disorientation after entering instrument meteorological conditions.NTSB ERA20LA335Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Union, SCA total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s failure to use carburetor heat in conditions conducive to the development of carburetor icing.NTSB WPR20LA322Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32-300 · Silver Springs, NVThe pilot’s failure to maintain directional control during a nighttime landing with a crosswind, which resulted in a runway excursion and impact with a sign.NTSB ERA20LA334Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · New Smyrna Beach, FLThe pilot’s decision to depart from a non-suitable surface, which resulted in a loss of directional control during takeoff roll.NTSB WPR20LA325Accident · No injuriesClass 4 · LimitedFinal reportCessna T210 · Bridgeport, CAAn inadvertent retraction of the flaps during a go-around by the pilot-rated passenger, which caused the airplane to settle onto the runway with the landing gear retracted.NTSB ERA20LA337Accident · No injuriesClass 4 · LimitedFinal reportLancair 235 · Chester, CTThe pilot's unstable approach, which resulted in a hard landing, and the separation of the left main landing gear.NTSB CEN20LA430Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46R-350T · Rogers, ARThe pilot’s inadvertent loss of aircraft control, resulting in substantial damage to the airframe during the spin recovery.NTSB CEN20LA419Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172S · San Marcos, TXThe F1 pilot’s failure to see and avoid the lower altitude Cessna while on final approach for landing. Contributing to the accident were the restrictions to pilot visibility inherent to low- and high-wing airplanes, and both pilots’ failure to recognize the…NTSB WPR20LA320Accident · Serious injuriesClass 3 · LimitedFinal reportGreat Lakes 2T1A · San Diego, CAA loss of engine power for reasons that could not be determined, which resulted in a hard landing off airport.NTSB CEN20LA424Accident · Serious injuriesClass 3 · LimitedFinal reportKitfox Speedster · Leadville, COA partial loss of engine power due to fuel starvation as a result of the pilot’s improper maintenance.NTSB CEN20LA420Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Terrell, TXFuel starvation due to a fuel system leak, which resulted in a loss of engine power and the subsequent forced landing on unsuitable terrain.NTSB CEN20LA417Accident · 2 fatalClass 3 · LimitedFinal reportQuicksilver Mxii · Killeen, TXA total loss of engine power due to cold seizure for a reason that could not be determined, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.NTSB WPR20LA315Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-802A · Emmett, IDThe pilot’s descent below surrounding terrain and his delayed decision to initiate a climb which resulted in impact with terrain. Contributing to the accident were terrain and lighting conditions that affected the pilot’s ability to accurately assess terrain…NTSB ERA20LA336Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · La Grange, NCThe pilot’s failure to maintain directional control during final approach, which resulted in a collision with trees.NTSB ERA20LA332Accident · No injuriesClass 3 · LimitedFinal reportGlasair 1RG · Hagerstown, MDThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA20LA330Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA25 · Floral City, FLThe pilot’s failure to see and avoid a tree while flying towards the rising sun during an aerial application flight, which resulted in a collision with the tree and a subsequent loss of airplane control.NTSB CEN20LA422Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · St. Clairsville, OHThe pilots improper fuel planning that resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC20LA099Accident · No injuriesClass 3 · LimitedFinal reportCessna 170B · Big Lake, AKThe pilot’s failure to utilize carburetor heat while flying in conditions conducive to carburetor icing, which resulted in a total loss of engine power.NTSB WPR20LA323Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopter 369 · Chemehuevi Valley, CAThe pilot’s failure to maintain helicopter control during an approach with a gusting variable wind, which resulted in an impact with terrain.NTSB WPR20LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Island Park, IDThe pilot’s failure to maintain directional control during a crosswind landing.NTSB WPR20CA316Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 12 · Pacific City, ORA loss of directional control during landing for reasons that could not be determined due to lack of available evidence.NTSB ERA20LA338Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Pottstown, PAThe pilot’s failure to maintain directional control while landing in gusty, shifting wind conditions.NTSB ERA20LA333Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Jackson, TNThe pilot’s failure to adequately monitor his fuel supply, resulting in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB ERA20LA329Accident · 1 fatalClass 3 · LimitedFinal reportCessna 182 · Lincolnton, GAThe pilot's loss of airplane control while maneuvering at a low altitude.NTSB ERA20LA328Accident · No injuriesClass 3 · LimitedFinal reportRockwell S2R · Hamilton, GAThe pilot’s inadequate preflight planning and improper operation of the engine beyond its indicated maximum cruise power setting, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA20LA326Accident · Serious injuriesClass 3 · LimitedFinal reportStearman E75 · Honea Path, SCThe partial loss of engine power due to the fatigue failure of an engine cylinder and the pilot’s subsequent decision to overfly several suitable forced-landing sites while attempting to return to the departure airstrip.NTSB ERA20LA325Accident · Minor injuriesClass 4 · LimitedFinal reportErcoupe F 1 · West Kingston, RIThe pilot’s failure to conduct a proper preflight inspection and ensure the fuel was uncontaminated, which resulted in a partial loss of engine power and forced landing.NTSB ERA20LA324Accident · 1 fatalClass 3 · LimitedFinal reportVans RV 8 · Hilliard, FLA total loss of engine power due to oil starvation.NTSB ERA20LA322Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Moosic, PAThe inadequate torquing of anchored-thru and free-thru studs during installation of the No. 2 cylinder, resulting in their fatigue fracture and subsequent total loss of engine power. Contributing to the undershoot landing was the pilot’s failure to divert to…NTSB CEN20LA407Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver MX II · Marengo, INA loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s decision to operate the airplane in conditions conducive to carburetor icing without a carburetor heating system, contrary to the engine manufacturer’s guidance.NTSB CEN20CA416Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172RG · Lafayette, INThe separation failure of a landing gear system hydraulic line and its compression fitting during cruise flight, which resulted in a partial gear up landing.NTSB ANC20LA098Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · King Salmon, AKThe fatigue fracture failure of the left main landing gear U-bolt during landing, which resulted in the collapse and separation of the left main landing gear spring.NTSB WPR20LA311Accident · Serious injuriesClass 3 · LimitedFinal reportNorth American B25N · Stockton, CAA total loss of engine power due to fuel exhaustion. Contributing to the accident was the erroneous fuel gauge indications and inadequate preflight planning and inspectionNTSB WPR20CA313Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT 402 · Somerton, AZThe pilot’s failure to use full power during takeoff and his delayed decision to abort the takeoff, which resulted in a runway overrun and subsequent impact with terrain.NTSB ERA20LA344Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Laconia, NHThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapsing.NTSB CEN20LA415Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · San Antonio, TXThe pilot’s inadequate compensation for gusting crosswind conditions while landing, which resulted a loss of lateral control and impact with a fence.NTSB CEN20LA412Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Montrose, MOA total loss of engine power due to an electrical overload in the engine control unit wiring system; the electrical overload occurred as a result of improper installation by the airplane builder.NTSB CEN20LA402Accident · 4 fatalClass 3 · LimitedFinal reportPiper PA46 · Hilltop Lakes, TXThe loss of engine power for reasons that could not be determined and the pilot’s failure to maintain control of the airplane which resulted in an aerodynamic stall and spin. Contributing to the accident was the pilot’s failure to establish and maintain a…NTSB CEN20LA401Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA32 · Kokomo, INThe pilot’s inadequate visual lookout, which resulted in a collision with a utility pole and the subsequent collision with terrain.NTSB WPR20LA310Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV4 · Clovis, NMThe pilot’s failure to maintain lateral control during initial climb due to distraction, which resulted in an in-flight upset and impact with terrain.NTSB ERA20LA331Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Fort Lauderdale, FLThe pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s decision to continue to the destination following the loss of engine power to the first engine.NTSB CEN20LA413Accident · FatalClass 3 · LimitedFinal reportCosmos Phase 3 · Wayne, OKA loss of control while taxiing for reasons that could not be determined based on available evidence.NTSB CEN20LA400Accident · 1 fatalClass 3 · LimitedFinal reportSafari S · Red Bud, ILA loss of control for reasons that could not be determined.NTSB CEN20LA399Accident · 2 fatalClass 3 · LimitedFinal reportVans RV9 · Zeeland, MIThe pilot’s failure to maintain airspeed during a visual approach in dark night conditions, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the pilot’s lack of recent flight experience at night.NTSB CEN20CA406Accident · Minor injuriesClass 4 · Data collectionFinal reportPik PIK-20D · Union, ILThe pilot’s failure to maintain directional control during takeoff that resulted in a collision with another glider that was parked close to the departure runway, and the pilot’s improper decision to attempt a takeoff without ensuring he had safe clearance…NTSB CEN20CA405Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Huntley, ILThe pilot’s decision to land at night without runway lighting, which resulted in a collision with an object.NTSB WPR20LA333Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic N500 · Peoria, AZThe balloon's encounter with unexpected windshear, which resulted in a hard landing and serious passenger injuries.NTSB ERA20LA323Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Hollywood, FLThe pilot's failure to maintain directional control during a crosswind takeoff, which resulted in a collision with airport lights and a sign.NTSB CEN20CA404Accident · No injuriesClass 4 · Data collectionFinal reportCubcrafters CC11 · Larkspur, COThe pilot’s failure to maintain control of the airplane while taking off in gusting quartering tailwind conditions.NTSB ERA20LA320Accident · Minor injuriesClass 3 · LimitedFinal reportStinson 108 · Newport, PAA total loss of engine power during cruise flight due to a disconnected carburetor mixture control cable which allowed the carburetor mixture lever to migrate to the cut-off position during flight.