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 WPR23LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Twisp, WAThe pilot’s loss of directional control during landing, which resulted in a runway excursion and ground loop.NTSB WPR23FA188Accident · 2 fatalClass 3 · FieldFinal reportCessna T182T · Albany, WYThe pilot’s decision to conduct flight into an area of icing in an airplane that was prohibited from such conditions, which resulted in exceedance of the airplane’s critical angle of attack, an aerodynamic stall/spin, and the pilot’s spatial disorientation…NTSB CEN23FA183Incident · 1 fatalClass 3 · FieldFinal reportRobinson R22 Beta · Brady, TXThe non-certificated pilot’s failure to ensure the collective friction control was adequately engaged during an on-ground engine run, which resulted in the helicopter inadvertently becoming airborne. Contributing to the crash were the pilot’s various physical…NTSB CEN23LA184Accident · Serious injuriesClass 4 · LimitedFinal reportRans S7 · Gardner, KSThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.NTSB WPR23LA190Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · Elko, NVThe pilot’s loss of directional control during landing with a quartering tailwind.NTSB ERA23LA232Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Selma, ALThe pilot’s improper preflight inspection, during which the left wing fuel sump drain was moved to and left in the open and locked position, allowing for fuel to drain during the flight and resulting in a total loss of engine power due to fuel starvation.…NTSB ANC23LA034Accident · No injuriesClass 4 · LimitedFinal reportDennis D Downs CCK-1865 · Sterling, AKThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA23LA229Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · South Bethlehem, NYThe pilot’s improper decision to attempt an intersection takeoff in a tailwind when the full runway in the opposite, headwind direction was available.NTSB ERA23LA228Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Bradenton, FLThe pilot’s failure to maintain adequate rotor rpm during landing which resulted in a premature landing on uneven ground and a subsequent rollover.NTSB CEN23LA182Accident · No injuriesClass 3 · LimitedFinal reportLoehle Acft 5151 Mustang · Hector, MNA total loss of engine power due to fuel starvation as a result of the pilot’s modifications to the fuel system. Contributing to the accident was the pilot’s decision to continue the takeoff despite observing lower than anticipated propeller rpm, his decision…NTSB WPR23LA184Accident · No injuriesClass 3 · LimitedFinal reportRans S-21 · Creswell, ORA total loss of engine power caused by fatigue cracking and fracture of the crankshaft due to severe wear of the bearings.NTSB WPR23FA185Accident · 3 fatalClass 3 · FieldFinal reportGates Lear Jet 36A · San Clemente Island, CAThe pilots’ loss of airplane control following a catastrophic fire that started on the left side of the aft equipment bay (tail cone). The fire likely initiated from a leak from the left fuel motive flow line due to a b-nut that loosened for reasons that…NTSB ERA23LA233Accident · Minor injuriesClass 4 · LimitedFinal reportRotorway Exec · Akron, OHThe non-certificated pilot’s failure to maintain control of the unregistered helicopter during landing.NTSB ANC23LA033Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235 · Soldotna, AKThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB WPR23LA186Accident · Serious injuriesClass 3 · LimitedFinal reportAviat A-1C-180 Husky · Lakewood, WAAn erroneous landing gear warning that led to the pilot’s decision to abort the landing, which resulted in a collision with trees during a go-around.NTSB ERA23LA226Accident · No injuriesClass 4 · LimitedFinal reportSilvaire Luscombe 8F · Frenchville, METhe pilot's failure to maintain control of the airplane while landing in gusting wind conditions.NTSB CEN23LA185Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Midland, TXThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB ANC23LA032Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Skwentna, AKThe pilot's failure to maintain adequate altitude/clearance from terrain while maneuvering in adverse weather conditions, which resulted in a dynamic rollover.NTSB WPR23LA180Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Ariel, WAThe pilot’s failure to maintain aircraft control during the landing roll, resulting in a nose over.NTSB ERA23LA222Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150M · Hernando, FLThe pilot’s failure to maintain adequate clearance from obstacles during takeoff at night.NTSB WPR23LA178Accident · No injuriesClass 4 · LimitedFinal reportUniversal Globe GC-1A · Belen, NMThe airplane’s encounter with downdraft on takeoff, which resulted in a loss of control.NTSB ERA23FA219Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Reliance, TNThe pilot’s decision to continue an instrument flight into an area of forecast weather with severe to extreme turbulence associated with a line of thunderstorms, which resulted in an in-flight breakup. Contributing was the pilot’s operation of the airplane in…NTSB WPR23LA181Accident · No injuriesClass 4 · LimitedFinal reportSteven Radenbaugh JA35 Superstol · Moorpark, CAThe pilot’s failure to maintain control of the airplane during an off airport precautionary landing. Contributing to the accident was the pilot’s decision to continue the flight with a possible mechanical malfunction.NTSB ERA23LA225Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20K · Hillsborough Township, NJThe partial loss of engine power due to maintenance personnel’s failure to ensure that the ignition harnesses were properly secured and the pilot’s inappropriate pitch control inputs, which resulted in the airplane exceeding its critical angle of attack and…NTSB ERA23LA224Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Clyde, OHThe pilot’s inadequate fuel management, which resulted in fuel starvation and a forced landing.NTSB CEN23LA186Accident · Serious injuriesClass 4 · LimitedFinal reportBeech F33A · Tahlequah, OKThe pilot’s failure to remove the wheel chocks before engine start which resulted in the inadvertent contact with the propeller while the engine was running.NTSB CEN23LA179Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Englewood, COThe pilot’s decision to adjust his seat during taxi, which resulted in his seat sliding aft, and subsequent loss of directional control.NTSB CEN23LA178Accident · Serious injuriesClass 3 · LimitedFinal reportAirbus Helicopters EC130 · Carta Valley, TXThe right rear-seat passenger’s improper judgement to release his restraint system and depart the helicopter while in a hover, which resulted in him sustaining serious injuries. Contributing to the accident was his impairment from effects of alcohol…NTSB CEN23FA174Accident · 4 fatalClass 3 · FieldFinal reportPool Cessna R172 · Victor, COThe pilot’s failure to follow established mountain flying guidance, which resulted in a loss of control and impact with trees and mountainous terrain. Contributing to the accident was the airplane’s reduced climb performance at the elevated density altitude…NTSB CEN23FA173Accident · 1 fatalClass 3 · FieldFinal reportCessna 310D · Ennis, TXThe partial loss of right engine power due to reduced fuel flow as a result of the contamination of the fuel screen.NTSB WPR23LA179Accident · No injuriesClass 4 · LimitedFinal reportELY John M Vans Acft RV-8 · North Las Vegas, NVThe pilot’s failure to maintain directional control during landing in gusting wind conditions, which resulted in a ground loop.NTSB ERA23LA221Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7DC-CONV · Fort Mill, SCThe pilot’s failure to apply carburetor heat before initiating a descent in conditions conducive to the development of carburetor icing, which resulted in a partial loss of engine power due to carburetor ice.NTSB ERA23LA218Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Greenville, NCInadequate maintenance by the operator and maintenance personnel, which resulted in a loss of engine power due to oil starvation.NTSB DCA23LA278Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Charlotte, NCThe captain’s failure to maintain the appropriate airspeed and pitch attitude during landing which resulted in a tailstrike.NTSB WPR23LA177Accident · No injuriesClass 3 · LimitedFinal reportCessna 210M · Pasco, WAImproper maintenance on the fuel outlet line to the fuel servo, which resulted in the line partially separating from the fuel outlet fitting and the subsequent fuel starvation and total loss of engine power.NTSB ERA23LA227Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5A · Knoxville, TNThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions.NTSB ERA23LA217Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Defuniak Springs, FLThe pilot's failure to maintain directional control while taking off in a crosswind, which resulted in a runway excursion and impact with a berm. Contributing was the automated weather briefing which failed to include accurate wind information.NTSB CEN23LA177Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Longville, MNThe pilot’s failure to maintain directional control during the landing roll with an unexpected windshift, which resulted in a runway excursion.NTSB CEN23LA175Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Brookings, SDThe student pilot’s failure to maintain pitch and directional control during the takeoff roll. Contributing to the accident, was the student pilot’s delay in relinquishing control of the airplane and the instructor's delayed reaction before the loss of…NTSB CEN23LA171Accident · No injuriesClass 4 · LimitedFinal reportKitfox IV · Gretna, NEThe pilot’s failure to maintain clearance from terrain during a turn immediately after takeoff.NTSB WPR23LA175Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P337H · Laurel, MTA partial loss of engine power to the rear engine resulting from cylinder detonation for undetermined reasons, which resulted in a forced landing and impact with terrain.NTSB CEN23LA180Accident · No injuriesClass 4 · LimitedFinal reportSearey LSX · Pottsboro, TXThe pilot’s failure to retract the landing gear before a water landing.NTSB CEN23LA172Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-34-200 · Coldspring, TXThe stabilator trim rod assembly separated from the stabilator link assembly due to a missing connecting bolt, which resulted in the pilot’s inability to maintain pitch control of the airplane.NTSB CEN23LA169Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH750 · Udall, KSThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the reported loss of engine power for reasons that could not be determined.NTSB WPR23LA183Accident · No injuriesClass 3 · LimitedFinal reportAero Vodochody L-39ZA · Barnhart, TXA total loss of engine power due to water-contaminated fuel from an undetermined source.NTSB WPR23LA176Accident · No injuriesClass 4 · LimitedFinal reportAkroTech Giles G-202 · Santa Barbara, CAA fire that resulted from venting fuel coming into contact with hot exhaust surfaces or exhaust gases. Contributing to the fire was the design and location of the main tank fuel vent.NTSB WPR23LA174Accident · No injuriesClass 4 · LimitedFinal reportCessna T210N · San Luis Obispo, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR23FA173Accident · 3 fatalClass 3 · FieldFinal reportBeech A36 · Big Bear, CAThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed on short final while operating in adverse wind conditions, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN23LA168Accident · No injuriesClass 3 · LimitedFinal reportCessna 182D · Batesville, MSThe pilot’s failure to maintain airplane control while landing with a left gusting crosswind. Contributing to the accident was the partial loss of engine power during the go-around.NTSB WPR23FA172Accident · 1 fatalClass 3 · FieldFinal reportCessna 172S · Los Angeles, CAThe pilot’s failure to maintain clearance with the hilly terrain resulting from his loss of situational awareness due to the deteriorating weather conditions as he descended to approach his destination airport.