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 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 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 CEN23LA211Accident · No injuriesClass 3 · LimitedFinal reportW10 Tailwind · Penrose, COThe failure of the right rudder pedal stop due to an inadequate weld, which resulted in a loss of control on the ground.NTSB WPR23LA213Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Tacoma, WAA fatigue failure of the left main landing gear hydraulic actuator, which resulted in a loss of hydraulic fluid that prevented the pilot from lowering the landing gear to the fully extended position and maintaining directional control after landing.NTSB WPR23LA209Accident · Minor injuriesClass 4 · LimitedFinal reportPipistrel Doo Ajdovscina Virus SW · Santa Fe, NMAn encounter with a downdraft during landing that resulted in a hard landing and the pilot’s loss of control.NTSB ERA23LA259Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Miami, FLThe pilot's improper landing flare, which resulted in substantial damage the airplane’s fuselage.NTSB ERA23LA251Accident · No injuriesClass 3 · LimitedFinal reportMagniflight M24 Orion Plus · Dauphin Island, ALA partial loss of engine power due to a loss of combustion in the No. 4 cylinder for undetermined reasons.NTSB CEN23LA210Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · St. Anthony, NDThe pilot’s failure to maintain clearance from terrain while maneuvering at low attitude.NTSB WPR23LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Santa Teresa, NMThe pilot’s loss of control after encountering a dust devil during landing.NTSB WPR23LA203Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · West Jordan, UTLoss of engine power due to fuel starvation as a result of the mechanic’s failure to properly secure the fuel system gascolator strainer bowl.NTSB GAA23WA160Accident · No injuriesClass 5 · ForeignPiper PA-34-220T · São Pedro da Água Branca,, BrazilNTSB GAA23WA157Accident · No injuriesClass 5 · ForeignPiper PA46-500TP · Saint-Tropez, FranceNTSB DCA23WA325IncidentClass 5 · ForeignBoeing 747 · Bangkok, ThailandNTSB CEN23LA212Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Light, ARThe pilot exceeding the climb capability of the airplane during takeoff which led to it settling into the ground.NTSB CEN23LA209Accident · No injuriesClass 4 · LimitedFinal reportKolb Firestar SS · Lodi, WIThe pilot’s failure to maintain control during takeoff.NTSB CEN23LA206Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172B · Divide, COA loss of engine power during cruise flight for reasons that could not be determined.NTSB CEN23LA205Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 8KCAB · Larchwood, IAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack during initial climb after takeoff, which resulted in an aerodynamic stall and impact with the ground.NTSB ANC23LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · McGrath, AKThe pilot’s delayed decision to abort the takeoff, which resulted in a forced landing and impact with terrain.NTSB ANC23LA039Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot’s failure to maintain directional control during landing with a quartering tailwind, which resulted in a water loop and impact with terrain.NTSB WPR23LA204Accident · No injuriesClass 4 · LimitedFinal reportCessna 175A · Enterprise, UTThe pilot’s inability to maintain altitude during an initial climbout in mountainous terrain after encountering a suspected downdraft.NTSB GAA23WA155Accident · No injuriesClass 5 · ForeignCessna 175 · Aldermaston, United KingdomNTSB ERA23FA249Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Plymouth, NYA total loss of engine power for reasons that could not be determined.NTSB CEN23LA234Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Grand Forks, NDThe student pilot’s failure to attain a proper takeoff attitude while demonstrating a soft field takeoff and his improper control inputs resulting in a dragged wing. Contributing to the accident were the gusting wind conditions.NTSB CEN23LA221Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Doniphan, MOA partial loss of engine power for undetermined reasons.NTSB CEN23FA204Accident · 2 fatalClass 3 · FieldFinal reportLuce Buttercup · Lyndonville, NYAn in-flight breakup due to structural overload of the airplane for undetermined reasons.NTSB WPR23LA367Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Minden, NVThe pilot’s failure to maintain directional control during the landing roll with a quartering headwind.NTSB WPR23LA205Accident · No injuriesClass 4 · LimitedFinal reportPiaggio Aero Industries P180 · Sugar Land, TXThe pilot’s failure to complete required preflight checklist items and properly configure the flaps for takeoff.NTSB GAA23WA158Accident · 2 fatalClass 5 · ForeignCessna 172 · Monagas, VenezuelaNTSB GAA23WA156Incident · No injuriesClass 5 · ForeignCessna 650 · Aalborg, DenmarkNTSB DCA23WA301Incident · No injuriesClass 5 · ForeignBoeing 737 · Jeddah, Saudi ArabiaNTSB CEN23LA303Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Ulysses, KSThe pilot’s failure to maintain clearance from a cable during spray operations.NTSB WPR23LA207Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · Kingman, AZThe failure of the passenger to adequately maintain a safe distance from the airplane’s propeller and the determination to let the passenger exit the airplane with the engine running.NTSB WPR23LA202Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M-18C 55 · Napa, CAThe pilot’s failure to use carburetor heat, which resulted in a loss of engine power due to carburetor icing and a subsequent impact with terrain during a forced landing.NTSB GAA23WA154Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Norman's Cay, BahamasNTSB ERA23LA248Accident · No injuriesClass 4 · LimitedFinal reportRaytheon B300 · Melbourne, FLAn inflight separation of the airplane’s airstair door for undetermined reasons.NTSB ERA23FA247Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Lake Worth, FLMaintenance personnel’s failure to detect the corroded aileron cable during recent inspections, which resulted in the separation of the aileron control cable and a subsequent loss of airplane control during takeoff.NTSB WPR23LA226Accident · No injuriesClass 3 · LimitedFinal reportCessna 310I · Sunnyside, WAThe failure of the side brace lock assembly of the right main landing gear due to overstress as a result of a hard landing.NTSB ERA23LA378Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Savannah, GAFailure and collapse of the nose landing gear during landing.NTSB ERA23LA245Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-25-260 · Hollywood, FLThe pilot’s improper banner pickup approach, which resulted in the banner tow hook contacting the airplane, and the subsequent overload separation of the right rudder control horn, resulting in a loss of airplane control.NTSB ERA23LA243Accident · No injuriesClass 4 · LimitedFinal reportThompson Edward LM-5X-W · Limington, METhe pilot’s inadequate compensation for the gusty crosswind conditions, which resulted in a collision with a tree during landing.NTSB DCA23WA419Incident · No injuriesClass 5 · ForeignEmbraer 190 · Napier, New ZealandNTSB CEN23LA203Accident · No injuriesClass 4 · LimitedFinal reportNanchang CJ6 · Windsor, COAn inflight collision with a bird while on initial climb.NTSB CEN23LA202Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Wright, LAThe pilot's decision to takeoff with the airplane overloaded which resulted in the airplane settling and subsequently impacting terrain.NTSB WPR23LA201Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177B · Tucson, AZA partial loss of engine power due to restricted fuel flow resulting from foreign object debris in the fuel flow transducer.NTSB WPR23LA200Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B3 · San Diego, CAThe pilot’s failure to maintain altitude during a hover taxi due to distraction resulting from the unanticipated activation of strobing lights while using night vision googles.NTSB WPR23LA199Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Casa Grande, AZAn in-flight separation of the throttle linkage, which resulted in a loss of throttle control. Contributing to the accident was maintenance personnel’s failure to follow the maintenance manual inspection procedure for the throttle cable assembly.NTSB CEN23FA201Accident · 1 fatalClass 3 · FieldFinal reportCessna 182T · Grand Isle, LAThe pilot’s operation of the airplane while intoxicated, resulting in its impact with the ocean.NTSB ERA23LA244Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Reidsville, NCThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind.NTSB CEN23LA256Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Romeoville, ILThe student pilot’s failure to attain/maintain a proper landing flare and failure to perform a go-around that resulted in an impact with the runway.NTSB CEN23LA207Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-5 · Fort Worth, TXAn in-flight collision with a bird.NTSB CEN23LA200Accident · No injuriesClass 3 · LimitedFinal reportFlight Design Ctsw · Gregory, MIThe pilot’s improper landing flare that resulted in a hard, bounced landing and subsequent overstress failure of the nose landing gear.NTSB CEN23LA199Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Abbeville, LAThe pilot’s failure to maintain proper helicopter control during autorotation that resulted in an abnormal ground contact which caused the subsequent main rotor strike on the tail boom that severed the tail rotor driveshaft. Contributing to the accident was…