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 CEN20TA031Accident · No injuriesClass 3Final reportBeech 36 · Spring Branch, TXThe pilot's inadequate preflight performance planning and his operation of the airplane outside of the manufacturer's specified weight and balance limitations, which resulted in a failure of the airplane to become airborne, an aborted takeoff, and subsequent…NTSB WPR20LA040Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV 6 · Pima, AZA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR20CA041Accident · No injuriesData collectionFinal reportCessna 182 · Camas, WAThe student pilot's improper landing flare, which resulted in a bounced landing, and the flight instructor’s delayed remedial action and the student’s failure to relinquish control, which resulted in a runway overrun and impact with a fence.NTSB DCA20IA034Incident · No injuriesIncident investigationFinal reportAirbus AS 350 B2 · Los Angeles, CAan inflight collision with a hard object of polycarbonate construction, with size and features consistent with that of a small UAS (drone).NTSB ERA20LA047Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Potts Camp, MSThe pilot’s delayed use of carburetor heat, which resulted in carburetor icing and a subsequent total loss of engine power.NTSB CEN20LA029Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8A · Baldwin City, KSThe pilot's failure to maintain directional control during takeoff, and the flight instructor's delayed remedial action, which resulted in a runway excursion and nose over.NTSB WPR20CA036Accident · No injuriesData collectionFinal reportJavron PA-18 Replica · Nephi, UTThe passenger’s inadvertent application of the brakes during landing, which resulted in a nose-over.NTSB CEN20LA028Accident · No injuriesClass 3 · LimitedFinal reportBAE BAE125 · Detroit, MIThe pilots’ failure to increase approach speed as recommended for flight in icing conditions, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the failure of the stall warning system to advise the…NTSB ERA20TA046Accident · No injuriesClass 3Final reportPiper PA28 · Vero Beach, FLThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB CEN20FA023Accident · 3 fatalClass 3 · FieldFinal reportPiper PA24 · San Antonio, TXThe loss of engine power for reason that could not be determined. Contributing to the accident was the pilot’s failure to maintain aircraft control while maneuvering to landing which resulted in an inadvertent stall/spin with insufficient altitude to recover.NTSB ERA20CA048Accident · No injuriesData collectionFinal reportCirrus SR22 · Union City, TNThe pilot's failure to maintain directional control during landing with a gusting crosswind, which resulted in a runway excursion and the left wing impacting grass.NTSB ERA20LA045Accident · Minor injuriesClass 3 · LimitedFinal reportYakovlev YAK 52 · Wrightsville, GAA total loss of engine power due to the failure of the No. 5 cylinder exhaust valve, which resulted in an forced off-airport landing.NTSB CEN20FA022Accident · 9 fatalClass 3 · FieldFinal reportPilatus PC12 · Chamberlain, SDThe pilot’s loss of control shortly after takeoff, which resulted in an inadvertent, low-altitude aerodynamic stall. Contributing to the accident was the pilot’s improper loading of the airplane, which resulted in reduced static longitudinal stability and his…NTSB CEN20CA027Accident · No injuriesData collectionFinal reportSkystar Kitfox · Williamston, MIThe pilot's improper decision to continue taxiing the airplane on unsuitable terrain, which resulted in a nose-over.NTSB ANC20FA007Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-31-350 · Cooper Landing, AKThe pilot’s failure to maintain clearance from terrain during gusty wind and reduced visibility night conditions.NTSB WPR20LA035Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH701 · Byron, CAThe pilot/builder's improper construction of the cowling, which resulted in inadequate venting of the engine, its overheating, and a partial loss of engine power.NTSB WPR20FA034Accident · 3 fatalClass 3 · FieldFinal reportCirrus SR-22 · North Las Vegas, NVThe pilot’s failure to maintain clearance from terrain during cruise flight in dark night conditions.NTSB ANC20FA005Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · Blythe, CAA loss of control in flight due to the pilot’s decision to fly into a mountain range, at night, in conditions conducive to high wind, mountain waves, and turbulence.NTSB WPR20CA058Accident · No injuriesData collectionFinal reportAeronca 11AC · San Diego, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind, which resulted in a collision with an airport sign and subsequent ground-loop.NTSB DCA20CA028Accident · No injuriesData collectionFinal reportGeneral Atomics MQ-9 · Palmdale, CAIncorrect control inputs by the student pilot during a crosswind landing, resulting in control saturation and a runway excursion.NTSB CEN20TA025Accident · No injuriesClass 3Final reportPiper PA34 · Mount Pleasant, TXThe pilot's hard, bounced landing and the flight instructor's delayed remedial action, which resulted in a fracture of the nose landing gear mounting structure.NTSB ERA20FA043Accident · 1 fatalClass 3 · FieldFinal reportBushby Bushby Mustang M II · Milton, FLThe pilot’s failure to maintain control of the airplane on takeoff, which resulted in an aerodynamic stall.NTSB CEN20LA046Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Shreveport, LAThe loss of engine power for undetermined reasons.NTSB WPR20LA033Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Caldwell, IDThe total loss of engine power due to the separation of the wastegate exhaust elbow.NTSB WPR20FA031Accident · 2 fatalClass 3 · FieldFinal reportGrumman AA5 · Jackpot, NVThe pilot’s loss of control due to spatial disorientation while departing in dark night conditions, which resulted in impact with terrain. Contributing to the accident was the pilot’s limited experience flying in night conditions.NTSB GAA20CA094Accident · Minor injuriesData collectionFinal reportPiper PA28 · Simsbury, CTThe automobile driver's incursion onto an active runway, which resulted in a collision with a landing airplane.NTSB GAA20CA092Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportscruiser · Lamar, COThe pilot's distraction due to an open canopy during final approach, which resulted in a loss of altitude and ground impact short of the runway.NTSB ERA20LA044Accident · Serious injuriesClass 3 · LimitedFinal reportBeech E35 · Okeechobee, FLThe separation of the throttle control cable from the carburetor throttle control lever resulting in the near total loss of engine power. Contributing to the separation of the throttle cable was the lack of proper securing hardware by unknown maintenance…NTSB CEN20CA033Accident · No injuriesData collectionFinal reportPiper PA18 · Kerrville, TXThe pilot’s loss of airplane control during the landing flare, which resulted in a loss of directional control and ground-loop.NTSB CEN20CA026Accident · No injuriesData collectionFinal reportBellanca 1730 · Clear Lake, MNThe pilot's focus inside the cockpit during the base turn and final approach, which led to a high sink rate developing and a subsequent hard landing short of the runway.NTSB CEN20LA020Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus SR22 · Tyler, TXA total loss of engine power as a result of detonation due to a combination of improper magneto to engine timing and a rich fuel mixture.NTSB CEN20FA019Accident · 1 fatalClass 3 · FieldFinal reportRaytheon A36 · San Marcos, TXThe pilot’s loss of control shortly after takeoff in instrument meteorological conditions for reasons that could not be determined based on the available information.NTSB GAA20CA090Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Brogue, PAThe pilot's failure to see and avoid wires during approach to landing.NTSB ERA20LA038Accident · No injuriesClass 3 · LimitedFinal reportMooney M20M · College Park, MDThe pilot’s improper flare, which resulted in a bounced landing, his improper airplane configuration during the attempted go-around, which resulted in the airplane not climbing, and his subsequent landing off the side of the runway.NTSB WPR20LA024Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Ogden, UTThe flight instructor’s failure to raise the landing gear using the alternate system, which resulted in a reduced climb rate and impact with an obstacle. Contributing to the accident was the flight instructor’s lack of understanding of the backup landing gear…NTSB GAA20CA089Accident · No injuriesData collectionFinal reportCessna 172 · DuBois, PAThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power, and his subsequent improper landing flare, which resulted in a hard, bounced landing. Contributing to the accident were the pilot's improper preflight…NTSB GAA20CA081Accident · No injuriesData collectionFinal reportStinson SR9 · West Jefferson, OHThe pilot's use of excessive braking during landing, which resulted in a nose-over.NTSB ERA20CA036Accident · Minor injuriesData collectionFinal reportPiper PA32 · Venice, FLA stuck brake caliper, which overheated while the pilot was taxiing the airplane, caught fire, and subsequently destroyed the airplane.NTSB WPR20LA026Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Livermore, CAThe improper installation of the flight control stick, which resulted in separation of the flight control stick from the stick stub assembly and an uncontrolled descent and impact with terrain.NTSB WPR20LA025Accident · No injuriesClass 3 · LimitedFinal reportNorth American SNJ-4 · Heber City, UTThe pilot’s loss of directional control during landing as a result of the separated tailwheel-to-rudder link rodNTSB GAA20CA086Accident · No injuriesData collectionFinal reportCessna 152 · Sherman/Dennison, TXThe pilot's improper landing flare, which resulted in a bounced landing.NTSB ENG20IA005Incident · No injuriesClass 3 · IncidentFinal reportAgusta A109 · Penobscot, MEFatigue fracture of the main rotor blade tip cap leading edge and subsequent partial separation of the tip cap, resulting in increased vibrations in the main rotor.NTSB ERA20LA039Accident · No injuriesClass 3 · LimitedFinal reportRans Rans S7 Courier · West Liberty, KYThe pilot's failure to verify that the engine oil tank contained adequate oil for the cross-country flight, which resulted in a total loss of engine power as a result of lack of lubrication. Contributing to the accident was the incorrect oil consumption…NTSB GAA20CA087Accident · No injuriesData collectionFinal reportFisher FP 202 Koala · Erwin, NCThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with vegetation.NTSB WPR20LA029Accident · No injuriesClass 3 · LimitedFinal reportAgusta A109 · Salt Lake City, UTThe flight nurse’s inadvertent application of left anti-torque pedal during cruise flight, which resulted in a rapid yaw and pitch movement that caused the tail rotor blades to contact the tailboom.NTSB WPR20LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Red Rock, AZA total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s improper use of carburetor heat.NTSB ERA20LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Toms River, NJThe failure of the Cessna 172N pilot to see and avoid a second airplane while maneuvering in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the Cessna 172N pilot to tune his radio to the correct…NTSB GAA20CA080Accident · No injuriesData collectionFinal reportSymphony Aircraft Ind SA · Fitzgerald, GAThe airplane’s impact with a deer while landing.NTSB GAA20CA074Accident · No injuriesData collectionFinal reportCessna 172 · FallBrook, CAThe student pilot's use of excessive ground speed while making a right turn when exiting the runway, which resulted in a loss of directional control and a runway excursion.NTSB GAA20CA071Accident · No injuriesData collectionFinal reportCessna 182 · San Luis, COThe pilot's improper pitch attitude during landing on rising terrain in flat light conditions, which resulted in a hard landing.