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 DCA23LA411Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer ERJ170 · Eleroy, ILAn encounter with clear air turbulence.NTSB ANC23LA063Accident · No injuriesClass 4 · LimitedFinal reportCessna U206G · Skwentna, AKThe airplane’s float contacted an undetected submerged gravel bar during landing which resulted in a nose over.NTSB WPR23LA363Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Needles, CAAn encounter with windshear during the initial climb after takeoff, resulting in a loss of control and a subsequent hard landing.NTSB ERA23LA359Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 500 S · Key West, FLA total loss of engine power for reasons that could not be determined.NTSB ERA23LA338Accident · No injuriesClass 3 · LimitedFinal reportStephen J Moorman Just Aircraft Highla · Edenton, NCThe pilot’s inadequate fuel planning, which led to a total loss of engine power due to fuel exhaustion.NTSB ERA23LA336Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · North Myrtle Beach, SCThe pilot’s failure to properly secure the left wing fuel cap, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA23LA334Accident · 2 fatalClass 3 · LimitedFinal reportScoda Aeronautica Ltda Super Petrel LS · Hickory, NCThe pilot’s failure to maintain clearance from powerlines while maneuvering at a low altitude over water, which resulted in a collision and loss of control.NTSB CEN23FA361Accident · Serious injuriesClass 3 · FieldFinal reportMikoyan Gurevich MIG-23UB · Belleville, MIA reported partial loss of engine power while maneuvering for reasons that could not be determined.NTSB CEN23FA360Accident · Serious injuriesClass 3 · FieldFinal reportPiper PA-24-250 · Oklahoma City, OKThe pilot’s mismanagement of fuel, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB ERA23LA337Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Haines City, FLA total loss of engine power due to fuel starvation for reasons that could not be determined.NTSB ERA23LA332Accident · 1 fatalClass 3 · LimitedFinal reportBell 47G-5 · Mifflinville, PAThe pilot’s failure to see and avoid powerlines during an aerial application flight.NTSB CEN23FA359Accident · 1 fatalClass 3 · FieldFinal reportVans RV14 · Virden, ILThe pilot/builder’s improper configuration of the canopy latch micro switch, which incorrectly signaled a closed canopy before flight that resulted in an inflight opening of the airplane’s canopy, an upset of the airplane, and a loss of control from which the…NTSB WPR23LA311Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Miles City, MTThe pilot's failure to maintain control of the airplane while landing on unimproved terrain.NTSB OPS23FA010IncidentClass 4 · FieldFinal reportBoeing 737-7BD · San Diego, CAThe local control controller’s poor judgment in duty prioritization which distracted them from monitoring arriving and departing traffic and resulted in a runway incursion and loss of same runway separation. Contributing was the operations supervisor’s…NTSB ERA23LA333Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Port Norris, NJThe pilot’s improper fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB ERA23LA331Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Wetumpka, ALA total loss of engine power due to the separation of the No. 3 connecting rod from the crankshaft.NTSB CEN23LA366Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Derby, KSThe pilot’s loss of directional control during takeoff roll due the passenger’s interference with the rudder pedals, which resulted in a runway excursion.NTSB CEN23LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna A188B · Chillicothe, MOThe pilot’s decision to operate the airplane with a known tailwheel anomaly, which resulted in a loss of directional control.NTSB WPR23LA316Accident · No injuriesClass 3 · LimitedFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Henderson, NVThe flight instructor’s failure to ensure there was adequate fuel onboard before departure, which led to a loss of engine power due to fuel exhaustion.NTSB WPR23LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Marysville, CAThe flight instructor’s failure to monitor the airplane’s speed during a high-speed taxi, resulting in a runway excursion.NTSB ERA23FA330Accident · 1 fatalClass 3 · FieldFinal reportCessna P210 · Junction City, GAThe pilot’s continued flight into a known area of adverse weather, which resulted in the penetration of a severe thunderstorm, the pilot’s loss of airplane control, and the airplane’s subsequent in-flight breakup.NTSB CEN23LA362Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Harvard, ILThe pilot’s failure to maintain directional control during takeoff that resulted in a runway excursion and an impact with the cornfield.NTSB ANC23LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Chaka Creek, AKA partial loss of engine power as a result of carburetor ice. Contributing to the outcome was the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB WPR23LA314Accident · Serious injuriesClass 3 · LimitedFinal reportReynolds Ronald B Team Acft Z-MAX · Rigby, IDThe loss of engine power during takeoff due to inadequately secured wires, which resulted in the wearing of the wires’ sheaths and the grounding of the airplane’s electrical system. Contributing to the accident was the pilot’s failure to maintain airplane…NTSB WPR23LA313Accident · Minor injuriesClass 3 · LimitedFinal reportBell OH-58A · Guernsey, CAThe pilot’s overpitching of the main rotor blades while maneuvering at low altitude in a high-temperature environment at high gross weight, which resulted in a reduction of engine and rotor speed, excessive main rotor blade flapping, mast bumping, and impact…NTSB WPR23LA312Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Dixon, CAThe pilot’s loss of directional control after striking an unidentified object during landing on an unimproved runway, and his subsequent use of excessive braking that resulted in a nose-over.NTSB ERA23LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Princeton, NJThe pilot’s inadequate compensation for the prevailing wind conditions during takeoff, which resulted in a loss of control and subsequent collision with trees.NTSB ERA23LA335Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Manatí, PRThe flight instructor’s inadequate preflight inspection of the fuel level, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA23LA329Accident · Serious injuriesClass 4 · LimitedFinal reportEipper Formance Mxii · Holy Hill, SCThe pilot’s exceedance of the critical angle of attack during the initial climb, which resulted in an aerodynamic stall at low altitude and a collision with a hangar. Contributing to the accident was the pilot’s lack of experience in the accident make and…NTSB CEN23LA358Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Sevierville, TNThe flight instructor’s improper flight control inputs during the practice hovering autorotation that resulted in a loss of control and impact with terrain.NTSB ANC23FA061Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Skwentna, AKAn impact with terrain for reasons that could not be determined because the airplane was not recovered due to the inaccessible nature of the accident site.NTSB WPR23LA317Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Fullerton, CAThe separation of the stabilator actuator from the stabilator tab, which resulted in pitch control surface flutter and structural damage.NTSB WPR23LA308Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Ritchfield, UTThe pilot’s improper preflight planning that resulted in the loss of engine power due to fuel exhaustion.NTSB WPR23LA307Accident · No injuriesClass 3 · LimitedFinal reportBoeing A75N1(PT17) · Red Lodge, MTA partial loss of engine power during the initial climb out due to improper maintenance of the magneto.NTSB CEN23LA357Accident · No injuriesClass 4 · LimitedFinal reportPiper PA25 · Hartington, NEThe pilot’s misperception of the rising terrain resulting in a collision with crops and terrain.NTSB CEN23LA356Accident · No injuriesClass 4 · LimitedFinal reportVans JV-Special / RV8 · Roanoke, TXThe pilot's failure to maintain directional control during the landing roll with crosswind.NTSB CEN23FA353Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802 · Gilman City, MOThe pilot's exceedance of the airplane's critical angle of attack and failure to maintain adequate airspeed during a steep turn, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB WPR23LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Aurora, ORThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB WPR23FA302Accident · 3 fatalClass 3 · FieldFinal reportBell 407 · Cabazon, CAThe Skycrane flight crew’s decision to enter the Fire Traffic Area’s 7-nm NOCOM ring at an altitude significantly above their maximum cleared altitude, which resulted in their need for an aggressive descent into congested airspace and subsequent failure to…NTSB CEN23LA355Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Waco, TXThe solo student pilot’s improper descent path which resulted in a hard landing on the nose wheel and subsequent bounced landing.NTSB CEN23LA351Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft F21 · Holliday, TXA loss of engine power for reasons that could not be determined, which resulted in impact with terrain.NTSB CEN23FA352Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Caddo Mills, TXThe pilot’s loss of airplane control during an attempted forced landing following a loss of engine power.NTSB WPR23LA305Accident · 1 fatalClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Davis, CAAn inflight loss of control during a low altitude operation for undetermined reasons.NTSB WPR23LA304Accident · Minor injuriesClass 3 · LimitedFinal reportVan Grouw R / Cantrell L White Lightning · Las Vegas, NMA reported partial loss of engine power during cruise flight for undetermined reasons.NTSB CEN23LA350Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Carthage, ILA collision with a fence during landing due to the crew’s reduced distance estimation and depth perception while using night vision goggles. Contributing to the accident was the low moon angle, which made viewing the fence more challenging.NTSB WPR23LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna T210M · Indian Creek, IDThe pilot's improper fuel management, which resulted in fuel starvation, and gear up landing on a dirt airstrip.NTSB WPR23LA306Accident · No injuriesClass 3 · LimitedFinal reportBoeing CH-46E · Springerville, AZThe flight crew’s misidentification of a No. 2 torque sensing system signal conditioner malfunction when both engines were performing normally, which resulted in their attempt to execute a single-engine steep approach and landing without sufficient engine…NTSB ERA23LA326Accident · Serious injuriesClass 4 · LimitedFinal reportHughes 369 · Elberon, VAThe pilot’s failure to maintain clearance from a power line structure arm, which resulted in main rotor blade contact.NTSB CEN23FA349Accident · 1 fatalClass 3 · FieldFinal reportNanchang China CJ-6A · Peyton, COThe pilot’s exceedance of the airplane’s critical angle of attack while intentionally maneuvering in a steep bank at low altitude, which resulted in an accelerated aerodynamic stall/spin and subsequent loss of airplane control.NTSB ANC23LA060Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-12S · Igiugig, AKThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.