NTSB investigations

19,222 cases where NTSB found Aircraft.

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01'))
  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.

NTSB ANC24LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland-Kenmore DHC-2 · Juneau, AKA partial loss of engine power during initial climb due to a cracked cylinder.Jun 28, 2024 · N590DB · Substantial damageNTSB CEN24LA244Accident · Minor injuriesClass 4 · LimitedFinal reportDesert Fox 1 · Ellicott, COThe pilot's decision to takeoff with a quartering tailwind and high density altitude which resulted in a runway overrun. Contributing to the accident was the failure of the right main axle mount due to the poor weld.Jun 27, 2024 · N10ZR · Substantial damageNTSB CEN24LA242Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Duluth, MNThe failure of the left engine induction coupling during takeoff, which resulted in a total loss of left engine power and an uncommanded left yaw/roll due to asymmetrical thrust and increased drag, from which the pilot had insufficient altitude to recover…Jun 27, 2024 · N5080J · Substantial damageNTSB CEN24LA241Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Andover, MOThe pilot’s inability to maintain altitude and airspeed during cruise flight likely due to a decrease in engine performance associated with the unauthorized use of automobile fuel, which led to an inflight collision with a tree and hard landing.Jun 27, 2024 · N3165C · Substantial damageNTSB CEN24FA240Accident · 2 fatalClass 3 · FieldFinal reportCessna 414A · McKinney, TXThe pilot's improper decision to attempt continued flight after a loss of left engine power with usable runway remaining and his subsequent failure to follow the emergency procedures and maintain air minimum control speed, which resulted in a loss of control.…Jun 27, 2024 · N414BS · DestroyedNTSB WPR24LA218Accident · Minor injuriesClass 3 · LimitedFinal reportTL Ultralight Sting RG · Rio Linda, CAA loss of engine power due to fuel exhaustion. Contributing to the accident was a fuel quantity indication that was inconsistent with the actual fuel state of the airplane, which likely led the pilot to overestimate the amount of fuel remaining onboard.Jun 26, 2024 · N912RG · Substantial damageNTSB ERA24LA279Accident · Serious injuriesClass 3 · LimitedFinal reportAlexander S Rolinski Aventura II · DeLand, FLImproper installation of the electric-driven fuel pump inlet hoses, which resulted in a hose failure and subsequent loss of engine power due to fuel starvation.Jun 26, 2024 · N727TK · Substantial damageNTSB ANC24LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Cordova, AKThe pilot’s improper landing flare, which resulted in a hard, bounced landing.Jun 26, 2024 · N3411U · Substantial damageNTSB ANC24LA055Accident · No injuriesClass 4 · LimitedFinal reportGippsland GA-8 · Tuntutuliak, AKThe pilot's failure to maintain directional control during takeoff after an encounter with a gusting wind, which resulted in a wing strike.Jun 26, 2024 · N13AV · Substantial damageNTSB WPR24LA249Accident · No injuriesClass 4 · LimitedFinal reportSchempp-Hirth DISCUS-2B · Nephi, UTThe pilot’s failure to maintain airspeed during a wind encounter, which resulted in a hard landing.Jun 25, 2024 · N41RE · Substantial damageNTSB WPR24LA217Accident · No injuriesClass 4 · LimitedFinal reportMoles Kenneth Rans S-19 · Independence, ORThe student pilot's improper landing flare which resulted in a hard landing.Jun 25, 2024 · N806GK · Substantial damageNTSB WPR24LA214Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pleasant Grove, CAThe pilot’s delayed recognition of the extent of the airplane’s increased takeoff roll. Contributing to the accident was the pilot’s lack of experience operating the airplane at a high gross weight.Jun 25, 2024 · N6793K · Substantial damageNTSB WPR24FA213Accident · 1 fatalClass 3 · FieldFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Chamberino, NMAn aerodynamic stall and loss of control for reasons that could not be determined based on the available information.Jun 25, 2024 · N9709 · DestroyedNTSB ERA24LA298Accident · No injuriesClass 4 · LimitedFinal reportGlobe GC1B · Peachtree City, GAA right main landing gear collapse during landing.Jun 25, 2024 · N3301K · Substantial damageNTSB ERA24LA288Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Medina, OHThe pilot’s failure to extend the landing gear and the flight instructor’s lack of remedial action, which resulted in a landing with the landing gear not correctly configured.Jun 25, 2024 · N182GZ · Substantial damageNTSB ERA24LA276Accident · Minor injuriesClass 3 · LimitedFinal reportSnyder Searey · New Ipswich, NHA total loss of engine power due to the exhaust muffler and tailpipe assembly separating from its attach points and impacting the propeller.Jun 25, 2024 · N453TS · Substantial damageNTSB ERA24LA275Accident · No injuriesClass 4 · LimitedFinal reportPiper PA23 · Montgomery, ALThe failure of the nose landing gear actuator to maintain a fully down and locked position.Jun 25, 2024 · N14175 · Substantial damageNTSB WPR24LA206Accident · No injuriesClass 3 · LimitedFinal reportCessna 182A · Spokane Valley, WAThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jun 24, 2024 · N4059D · Substantial damageNTSB ERA24LA277Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Fire Island, NYA total loss of engine power for undetermined reasons.Jun 24, 2024 · N890MA · Substantial damageNTSB ANC24LA059Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Anchorage, AKThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Jun 24, 2024 · N748WP · Substantial damageNTSB ANC24LA053Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tok, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll.Jun 24, 2024 · N2839C · Substantial damageNTSB WPR24LA204Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MXT-7-180 · Winifred, MTThe pilot’s inadvertent excessive application of brakes, which resulted in a nose over.Jun 23, 2024 · N5519C · Substantial damageNTSB CEN24LA349Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Hooper, NEThe solo student pilot’s unstable approach to the runway, which resulted in a hard, bounced landingJun 23, 2024 · N988CP · Substantial damageNTSB CEN24LA238Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fort Leavenworth, KSThe pilot’s failure to maintain directional control after landing.Jun 23, 2024 · N74CF · Substantial damageNTSB CEN24LA236Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Boerne, TXMaintenance personnel’s inadequate adjustment of fuel flow, which resulted in an excessively rich mixture, a rough-running engine, and a subsequent partial loss of engine power.Jun 23, 2024 · N87AQ · Substantial damageNTSB WPR24LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Chamberlain Guard Station, IDThe pilot’s failure to maintain directional control during takeoff which resulted in a collision with a rodent hole and subsequent nose over.Jun 22, 2024 · N4722B · Substantial damageNTSB WPR24LA205Accident · Minor injuriesClass 3 · LimitedFinal reportReplica PA-12 Replica · Douglas, WYA loss of power due to fuel exhaustion as a result of the pilot’s failure to calibrate the fuel flow indicator.Jun 22, 2024 · N406Z · Substantial damageNTSB CEN24LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Schriever, LAThe pilot’s inadvertent application of the toe brakes during the takeoff roll.Jun 22, 2024 · N77143 · Substantial damageNTSB WPR24LA208Accident · Minor injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Yellow Pine, IDThe pilot’s failure to attain a proper touchdown point during landing and his subsequent excessive use of brakes.Jun 21, 2024 · N588Z · Substantial damageNTSB WPR24FA202Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Capitan, NMThe pilot’s decision to continue the visual flight rules flight through an apparent visual corridor that rapidly narrowed due to rising terrain and mountain obscuration, resulting in momentary instrument meteorological conditions and the pilot’s subsequent…Jun 21, 2024 · N331BS · DestroyedNTSB ERA24LA272Accident · No injuriesClass 4 · LimitedFinal reportAdams Walter R Searey · Sopchoppy, FLThe pilot’s improper landing flare, which resulted in abnormal contact with the water during landing.Jun 21, 2024 · N425UW · Substantial damageNTSB ERA24LA271Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Hernando, FLThe improper installation of a cylinder rocker stud by maintenance personnel, which resulted in a partial loss of engine power and subsequent forced landing.Jun 21, 2024 · N734XT · Substantial damageNTSB ANC24LA054Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Aleknagik, AKThe pilot’s failure to maintain pitch control of the airplane during initial climb.Jun 21, 2024 · N55WE · Substantial damageNTSB WPR24LA210Accident · No injuriesClass 3 · LimitedFinal reportLancair LC42-550FG · Humboldt Bay, CAMaintenance personnel’s incorrect installation of an engine rocker cover gasket, which resulted in oil exhaustion and subsequent loss of engine power during the initial climb.Jun 20, 2024 · N141PB · Substantial damageNTSB CEN24LA318Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Stanwood, MIThe pilot’s failure to maintain terrain clearance during a low-level aerial application flight, which resulted in impact with terrain and a subsequent forced landing. Contributing to the accident was the location of the spray boom pressure gauge, which…Jun 20, 2024 · N4004K · Substantial damageNTSB WPR24LA211Accident · No injuriesClass 3 · LimitedFinal reportBeech 58P · Escalante, UTThe failure of the windshield for undetermined reasons.Jun 19, 2024 · N9NS · Substantial damageNTSB WPR24LA207Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Scheelite, CAThe pilot’s inadvertent entry to a box canyon where the airplane could not outclimb the rising terrain.Jun 19, 2024 · N3627N · Substantial damageNTSB WPR24FA200Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Bluestem, WAThe pilot’s failure to manage main rotor rpm during an autorotation, which resulted in a loss of helicopter control. Contributing to the accident was a loss of power for reasons that could not be determined.Jun 19, 2024 · N323TT · DestroyedNTSB CEN24LA232Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Ruston, LAThe student pilot’s failure to maintain directional control during the landing roll with a crosswind.Jun 19, 2024 · N8725U · Substantial damageNTSB CEN24LA231Accident · No injuriesClass 4 · LimitedFinal reportFoskett James J CH 750 Cruiser · East Troy, WIThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Jun 19, 2024 · N355VT · Substantial damageNTSB WPR24LA212Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA31 · Lemoore, CAThe pilot’s improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion and a subsequent emergency landing.Jun 18, 2024 · C-GJBG · Substantial damageNTSB WPR24LA203Accident · No injuriesClass 4 · LimitedFinal reportJoseph H Mason Bearhawk Patrol · Twin Falls, IDThe pilot’s failure to maintain directional control during the landing roll.Jun 18, 2024 · N357MB · Substantial damageNTSB ERA24LA267Accident · Minor injuriesClass 3 · LimitedFinal reportGarlick Helicopters OH-58A+ · Cisco, GAA reported total loss of engine power for reasons that could not be determined.Jun 18, 2024 · N72BM · Substantial damageNTSB CEN24LA233Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Murphysboro, ILThe pilot’s failure to maintain directional control during landing.Jun 18, 2024 · N5335G · Substantial damageNTSB ERA24FA266Accident · Serious injuriesClass 3 · FieldFinal reportLockheed 12 · Jackson, GAMaintenance personnel’s failure to properly secure the right brake line, which resulted in a loss of right brake effectiveness during the landing roll and a subsequent runway excursion.Jun 17, 2024 · N2072 · Substantial damageNTSB ERA24FA265Accident · 1 fatalClass 3 · FieldFinal reportVans RV6 · Methuen, MAThe pilot’s failure to manage the available fuel supply, which resulted in a total loss of engine power due to fuel starvation.Jun 17, 2024 · N715PA · Substantial damageNTSB CEN24LA239Accident · No injuriesClass 3 · LimitedFinal reportThrush S2R · Hebron, NDForeign object debris in the Negative Torque Sensing (NTS) system check valve, which impeded the flow of oil to the NTS system and the propeller governor (PG) reset piston, resulting in a total loss of engine power and an off-airport forced landing.…Jun 17, 2024 · N529KC · Substantial damageNTSB CEN24FA228Accident · 2 fatalClass 3 · FieldFinal reportCessna 421 · Steamboat Springs, COThe pilot’s failure to maintain sufficient airspeed following a loss of engine power, which resulted in an inadvertent aerodynamic stall/spin at low altitude.Jun 17, 2024 · N245T · DestroyedNTSB ERA24LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Smithfield, NCThe pilot’s failure to maintain directional control during the landing roll.Jun 16, 2024 · N2257D · Substantial damageNTSB ERA24LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Elizabeth City, NCThe pilot’s improper flare and subsequent improper recovery from a bounced landing.Jun 16, 2024 · N92970 · Substantial damage