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 WPR23LA019Accident · No injuriesClass 4 · LimitedFinal reportProgressive Aerodyne SeaRey · Lake Isabel, WAThe pilot’s loss of airplane control after an encounter with windshear during takeoff which, resulted in a hard water landing.NTSB WPR23LA018Accident · No injuriesClass 4 · LimitedFinal reportPiper J3F-60 · Herlong, NVThe pilot's failure to maintain adequate separation during a formation flight, which resulted in an encounter with wake turbulence, an aerodynamic stall, and collision with terrain.NTSB WPR23LA015Accident · No injuriesClass 4 · LimitedFinal reportAeroprakt Manufacturing SP Zoo A22LS · Prescott, AZThe pilot’s loss of directional control during landing with a wind gust, which resulted in a runway excursion and nose over.NTSB WPR23LA014Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Petaluma, CAThe pilot’s failure to maintain directional control during landing in gusting wind.NTSB WPR23LA013Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Tucson, AZThe pilot’s loss of control during landing for reasons that could not be determined based on the available evidence.NTSB ERA23LA039Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Kingstree, SCThe airplane’s impact with two deer during the landing roll.NTSB ERA23LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Elizabethtown, KYThe pilot's decision to continue the taxi without visual reference to the surface, due to his vision being impaired by darkness and glare, which resulted in the airplane’s departure from the paved surface and impact with a ditch. Contributing was the flight…NTSB CEN23LA014Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 62 · Dallas, TXA total loss of airplane electrical power for undetermined reasons, which resulted in a complete loss of engine power to both engines. Contributing was the worn main battery and the incorrectly wired ECU backup batteries.NTSB WPR23LA016Accident · No injuriesClass 3 · LimitedFinal reportQuickie Q2 · Laramie, WYThe partial loss of engine power due to the seizure of the No. 1 cylinder exhaust valve in the valve guide.NTSB ERA23LA032Accident · No injuriesClass 4 · LimitedFinal reportHoward DGA-15P · Lawrenceburg, TNThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB ERA23LA029Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Montgomery, ALThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA23LA028Accident · No injuriesClass 4 · LimitedFinal reportMcglaughlin Richard Sportsman GS2 · Pell City, ALThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion.NTSB ERA23LA021Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Daytona Beach, FLThe pilot’s misjudged landing point which resulted in a loss of control and collision with terrain.NTSB ERA23LA019Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5A · Knoxville, TNThe student pilot’s loss of directional control on landing.NTSB ERA23LA020Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 100 · New Smyrna Beach, FLThe pilot’s exceedance of the critical angle of attack during takeoff and corresponding stall/mush. Contributing to the accident were the pilot’s operation of the airplane above the maximum specified gross weight.NTSB ERA23LA018Accident · No injuriesClass 4 · LimitedFinal reportCessna 310 · Middlefield, OHThe pilot’s inadequate fuel planning and inflight fuel management which resulted in exhaustion of his fuel supply and a forced landing.NTSB CEN23LA015Accident · No injuriesClass 4 · LimitedFinal reportBeech B-60 · Ardmore, OKThe pilot did not ensure adequate clearance from construction vehicles during taxi.NTSB CEN23LA286Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · Holland, MIThe pilot’s failure to maintain directional control during the landing roll with gusty wind which exceeded the maximum crosswind of the airplane.NTSB CEN23LA012Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Paola, KSThe pilot’s improper positioning of the fuel selector, which resulted in fuel starvation and a loss of engine power during a departure climb.NTSB ERA23LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Morristown, TNThe solo student pilot’s improper flare, which resulted in a hard landing.NTSB CEN23LA013Accident · Serious injuriesClass 4 · LimitedFinal reportPober Pixie · Sterling, COThe pilot’s failure to maintain control during the takeoff with strong gusty surface wind.NTSB WPR23LA012Accident · No injuriesClass 3 · LimitedFinal reportCessna T210L · Marana, AZA failure of a retaining ring in the airplane’s left main landing gear door actuator and the subsequent complete loss of hydraulic fluid, which resulted in a gear-up landing.NTSB ERA23LA015Accident · Minor injuriesClass 4 · LimitedFinal reportST Clair David L Tango 2 · Yulee, FLThe pilot’s improper landing flare which resulted in a hard, bounced landing that damaged the nose landing gear, resulting in an inability to maintain directional control and subsequent runway excursion.NTSB ERA23LA012Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MX-7-160 · Northville, NYThe pilot's decision to depart from an area of wet sand, which resulted in a nose over during the attempted takeoff.NTSB CEN23LA009Accident · Minor injuriesClass 4 · LimitedFinal reportYates Mike E Roaring Eagle · Stanwood, IAThe pilot’s exceedance of the airplane’s critical angle of attack in the traffic pattern, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover. Contributing to the accident was the partial loss of engine…NTSB WPR23LA011Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Monument Valley, UTThe pilot’s loss of airplane control during the landing flare in gusting wind and subsequent loss of directional control during the landing roll.NTSB WPR23LA010Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Burlington, WAThe pilots improper landing flare and remedial action which resulted in a hard, bounced landing.NTSB WPR23LA009Accident · Serious injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 505 · Moab, UTThe pilot’s loss of helicopter control during landing, that resulted in a dynamic roll over.NTSB ERA23LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Dacula, GAAn in-flight collision with a bird while on approach.NTSB ERA23LA013Accident · No injuriesClass 3 · LimitedFinal reportSchempp-Hirth Discus CS · Woodstock, VAImproper repair of a crack by maintenance personnel, which resulted in a subsequent failure of the glider canopy.NTSB ERA23LA011Accident · Serious injuriesClass 3 · LimitedFinal reportBell Textron Canada 505 · Fort Myers, FLThe pilot’s execution of a landing approach with a right, quartering tailwind, low forward airspeed, and high power demand that, when combined, resulted in a loss of tail rotor effectiveness and helicopter control.NTSB ERA23LA010Accident · Serious injuriesClass 4 · LimitedFinal reportGreen L/Gilner D RV-4 · Rowlesburg, WVThe pilot's failure to maintain an appropriate airspeed/angle-of-attack during the landing approach, which resulted in an aerodynamic stall, and impact with terrain.NTSB CEN23LA010Accident · No injuriesClass 4 · LimitedFinal reportZenith CH 750 · Libby, MNThe total loss of engine power due to the pilot’s improper fuel management, which led to fuel starvation. Contributing to the accident was the low altitude at which the loss of engine power occurred.NTSB CEN23LA006Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International S53A · Albuquerque, NMThe pilot’s inability to find a suitable landing area in a critical fuel situation and his decision to land on a highway, which resulted in the balloon impacting a bridge railing and terrain.NTSB ERA23LA009Accident · Minor injuriesClass 3 · LimitedFinal reportSwensen Fisher Celebrity · Greensboro, NCThe pilot/mechanic’s failure to remove excess sealant from the header fuel tank after recent maintenance, which resulted in fuel starvation to the engine and a loss of engine power. Contributing to the accident was the pilot’s inflight decision making…NTSB ERA23FA008Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Newport News, VAThe flight instructor’s failure to monitor the student pilot on takeoff and her delayed remedial action to stop him from exceeding the airplane’s critical angle of attack, which resulted in a low altitude aerodynamic stall from which she was unable to recover.NTSB ERA23FA007Accident · 1 fatalClass 3 · FieldFinal reportSeamax M-22 · East Hampton, NYAn inflight separation of the right wing as a result of the manufacturer’s application of a bolt and nut in the upper wing strut attachment point that was inconsistent with the nut design intent and usage limitations.NTSB CEN23LA008Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Iola, TXThe pilot’s failure to maintain control of the airplane while landing.NTSB CEN23LA007Accident · No injuriesClass 4 · LimitedFinal reportWaszak Arthur B Wittman Tailwind W10 · Waldron, ARThe pilot’s failure to maintain adequate airspeed during the landing resulting in an inadvertent aerodynamic stall and hard landing.NTSB ANC23FA001Accident · 1 fatalClass 3 · FieldFinal reportCessna A185F · Fairbanks, AKThe improperly maintained floats, which allowed water to fill the front compartments and resulted in the airplane nosing over during taxi. Contributing to the fatal injury of the pilot was the improperly secured cargo, which prevented the pilot from egressing…NTSB WPR23LA033Accident · No injuriesClass 4 · LimitedFinal reportRaytheon A36 · Freeport, ILThe pilot’s failure to extend the landing gear.NTSB ERA23FA006Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Arundel, METhe pilot’s loss of situational awareness, which resulted in an unstabilized approach, descent below published minimum altitudes, and collision with terrain.NTSB DCA23LA005Incident · No injuriesClass 3 · LimitedFinal reportBombardier CL-600-2B19 · Dayton, OHThe airplane’s right turn, which developed during the landing rollout and persisted until the airplane came to rest, for reasons that could not be determined based on the available evidence. Contributing to the incident was the pilot’s reliance primarily on…NTSB CEN23LA011Accident · No injuriesClass 4 · LimitedFinal reportCessna L-19E · Navasota, TXThe pilot’s loss of control while landing resulting in a runway excursion and ground loop.NTSB CEN23LA005Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7BCM · San Antonio, TXThe flight instructor’s failure to attain/maintain aircraft control during landing.NTSB WPR23LA020Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters FX-3 · Hot Springs, MTThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR23FA007Accident · 1 fatalClass 3 · FieldFinal reportCornford Craig H Mustang II · Jamul, CAImpact with mountainous terrain for undetermined reasons due to the limited evidence that could be collected from the accident sceneNTSB ERA23LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Sanford, FLThe pilot's unstable approach, which resulted in a hard landing and impact with a runway threshold light. Also causal was the flight instructor’s failure to take remedial action to prevent the hard landing.NTSB ERA23LA005Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Milan, GAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel contamination.NTSB ERA23LA004Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Coleman, FLThe pilot's failure to maintain an appropriate final approach airspeed, which resulted in a runway excursion and impact with a fence.