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 CEN23LA198Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Wichita, KSThe pilot’s failure to maintain a safe taxi distance from a turbine-powered airplane, resulting in an encounter of the turbine-powered airplane’s jet blast while taxiing.NTSB DCA23WA373Incident · No injuriesClass 5 · ForeignEmbraer ERJ190 · Vargas, VenezuelaNTSB CEN23LA197Accident · No injuriesClass 4 · LimitedFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Gueydan, LAThe failure of both pilots to see and avoid each other resulting in a collision on the airstrip. Contributing was the pilots’ failure to announce their intentions over their radios as they were taking off and landing.NTSB CEN23LA196Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Kansas City, MOThe student pilot's failure to maintain directional control during takeoff.NTSB ANC23LA038Accident · No injuriesClass 4 · LimitedFinal reportAerospatiale AS350B2 · Honolulu, HIThe instructor pilot’s inadequate supervision of the pilot receiving instruction, which resulted in a hard landing, and substantial damage to the tail boom.NTSB WPR23LA195Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Mobile, AZThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion and nose over.NTSB WPR23LA194Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CCX-2300 · Spanish Fork, UTThe pilot's decision to attempt an unfamiliar takeoff technique, his failure to maintain pitch control during takeoff, and his subsequent decision to retract flaps at a low altitude, which resulted in a descent into a building.NTSB ERA23LA264Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Lancaster, TNThe fatigue failure of an exhaust valve, resulting in a partial loss of engine power.NTSB ERA23LA240Accident · 1 fatalClass 3 · LimitedFinal reportCessna R182 · Macon, NCThe pilot’s failure to properly set the elevator trim before takeoff, which resulted in a loss of control during takeoff.NTSB ERA23FA239Accident · 1 fatalClass 3 · FieldFinal reportCommander 114TC · Palm City, FLA loss of engine power for undetermined reasons, and the pilot’s subsequent loss of control, which resulted in impact with terrain.NTSB ERA23FA238Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · Rougemont, NCA total loss of engine power due to oil starvation. The source of the oil starvation could not be determined.NTSB WPR23LA198Accident · Minor injuriesClass 3 · LimitedFinal reportSilvaire Luscombe 8A · Clovis, NMThe airplane’s uncontrollable descent and forced landing for reasons that could not be determined.NTSB WPR23LA197Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Redding, CAA fuel leak caused by an age-degraded fuel pressure sender hose, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was inadequate maintenance.NTSB WPR23LA193Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · American Falls, IDThe pilot’s inadvertent selection of the off position of the fuel tank selector inflight, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR23LA192Accident · 2 fatalClass 3 · LimitedFinal reportViking Air DHC-6-400 · Half Moon Bay, CAThe failure of the ferry fuel tank system to transfer fuel during a trans-Pacific flight for reasons that could not be determined, which resulted in fuel starvation and a subsequent ditching into the water.NTSB GAA23WA153Accident · 3 fatalClass 5 · ForeignAvions Robin DR400 · Les Ponts-de-Martel, SwitzerlandNTSB GAA23WA152Accident · 3 fatalClass 5 · ForeignCirrus SR20 · Mali Makovnik, CroatiaNTSB CEN23LA213Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Ray, MIThe flight instructor’s failure to maintain airplane control during simulated engine-out procedures. Contributing to the accident was the flight instructor’s decision to land with a tailwind.NTSB CEN23LA192Accident · No injuriesClass 4 · LimitedFinal reportNorth American-Buehn T-6G · Ankeny, IAThe pilot’s inadvertent retraction of the landing gear control lever, resulting in a gear-up landing on the runway.NTSB ANC23LA037Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Hunter Creek, AKThe pilot’s loss of directional control during takeoff roll in gusting wind conditions.NTSB WPR23LA196Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172H · Seattle, WAA stuck exhaust valve that resulted in a partial loss of engine power and a forced water ditching.NTSB ERA23LA242Accident · Minor injuriesClass 4 · LimitedFinal reportGary R Brearley RV-9A · Kingston, TNThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing which resulted in a nose over.NTSB DCA23WA303Incident · No injuriesClass 5 · ForeignBoeing 777 · Abu Dhabi, United Arab EmiratesNTSB CEN23LA208Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8E · Cortez, COFailure of the right main landing gear due to prolonged corrosion of the landing gear tube, which weakened the gear.NTSB CEN23LA193Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32RT · DeKalb, ILThe pilot’s failure to maintain aircraft control during a go-around in gusting winds. Contributing was the presence of windshear.NTSB GAA23WA162AccidentClass 5 · ForeignPiper PA18 · Oldenburg, GermanyNTSB ERA23LA237Accident · No injuriesClass 4 · LimitedFinal reportBeech 65-A90-1 · Petersburg, WVThe flight crew’s failure to ensure that the landing gear were properly configured before landing.NTSB ERA23FA235Accident · No injuriesClass 3 · FieldFinal reportHonda HA-420 · Summerville, SCThe pilot’s improper calculation of the airplane’s landing approach speed and required landing distance, which resulted in the airplane touching down fast with inadequate runway available, and a subsequent runway excursion.NTSB CEN23LA194Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-C33A · Indianola, MSAn in-flight fire for undetermined reasons.NTSB CEN23LA191Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Genoa, ILThe pilot’s failure to maintain airplane control during a go-around.NTSB WPR23LA300Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tracy, CAThe pilot’s failure to maintain directional control during the landing roll after encountering a wind gust.NTSB ERA23LA241Accident · Minor injuriesClass 3 · LimitedFinal reportBurril Benjamin D BDB001 · Wadesboro, NCA reported total loss of engine power and a subsequent forced landing for reasons that could not be determined because the pilot did not make the wreckage available for examination.NTSB ERA23FA234Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-25-235 · Hollywood, FLThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of aircraft control.NTSB CEN23LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Flower Mound, TXThe fatigue failure of the rocker arm which resulted in a partial loss of engine power. Contributing was the airplane operator’s failure to inspect the rocker arm in accordance with the engine manufacturer’s service bulletin.NTSB CEN23FA190Accident · 1 fatalClass 3 · FieldFinal reportBeech E-90 · Winslow, ARThe pilot’s poor preflight decision to depart into known instrument meteorological conditions (IMC) without a functional autopilot system, which resulted in spatial disorientation and his failure to maintain aircraft control while flying in IMC during the…NTSB ANC23LA036Accident · No injuriesClass 4 · LimitedFinal reportPiper PA31 · Point Thomson, AKThe pilot’s inadvertent descent below the published minimum descent altitude, while operating in flat light conditions, which resulted in controlled flight into terrain.NTSB ANC23LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Anchorage, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.NTSB CEN23LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna A185f · Grand Junction, COThe pilot’s failure to maintain directional control during the landing roll with gusting wind.NTSB WPR23LA191Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Spanish Fork, UTThe instructor pilot’s improper landing flare during a straight-in autorotation, which resulted in a hard landing.NTSB ERA23LA231Accident · No injuriesClass 3 · LimitedFinal reportCharles D Walker Walker Curtiss JN4D · Greenville, KYThe separation of an electrical wire that powered the ignition module, rendering the ignition system inoperative, and resulting in the total loss of engine power.NTSB ENG23WA028AccidentClass 5 · ForeignLearjet 35 · Hohn, GermanyNTSB DCA23LA290AccidentClass 4 · LimitedFinal reportGeneral Atomics MQ-9 Block 1 · Elgin, AZThe pilot’s loss of situational awareness, resulting in the UAS’s controlled flight into terrain.NTSB CEN23FA187Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Chambers, NEThe pilot’s continued VFR flight into instrument meteorological conditions at night and his failure to maintain adequate altitude, which resulted in controlled flight into terrain.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 DCA23WA289Incident · No injuriesClass 5 · ForeignBoeing 747 · Luxembourg, LuxembourgNTSB 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 GAA23WA149Accident · No injuriesClass 5 · ForeignRobinson R66 · Konakovo, RussiaNTSB DCA23WA294Occurrence · No injuriesClass 5 · ForeignEmbraer ERJ 190-100 IGW · Queretaro, MexicoNTSB 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.