NTSB investigations

10,307 cases where NTSB found Environmental issues.

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\", '03'))
  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 ERA23LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Princeton, NJThe pilot’s inadequate compensation for the prevailing wind conditions during takeoff, which resulted in a loss of control and subsequent collision with trees.Aug 9, 2023 · N172FW · Substantial damageNTSB CEN23LA357Accident · No injuriesClass 4 · LimitedFinal reportPiper PA25 · Hartington, NEThe pilot’s misperception of the rising terrain resulting in a collision with crops and terrain.Aug 8, 2023 · N8847L · Substantial damageNTSB CEN23LA356Accident · No injuriesClass 4 · LimitedFinal reportVans JV-Special / RV8 · Roanoke, TXThe pilot's failure to maintain directional control during the landing roll with crosswind.Aug 8, 2023 · N7776J · Substantial damageNTSB CEN23LA350Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Carthage, ILA collision with a fence during landing due to the crew’s reduced distance estimation and depth perception while using night vision goggles. Contributing to the accident was the low moon angle, which made viewing the fence more challenging.Aug 6, 2023 · N288AE · Substantial damageNTSB WPR23LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna T210M · Indian Creek, IDThe pilot's improper fuel management, which resulted in fuel starvation, and gear up landing on a dirt airstrip.Aug 5, 2023 · N7067Z · Substantial damageNTSB WPR23FA301Accident · 1 fatalClass 3 · FieldFinal reportGlasair Glastar · Idaho City, IDThe pilot’s loss of airplane control during takeoff for reasons that could not be determined.Aug 4, 2023 · N617G · Substantial damageNTSB ERA23LA328Accident · 2 fatalClass 3 · LimitedFinal reportCessna 172 · Charlotte Amalie, CBThe pilots’ loss of airplane control due to spatial disorientation. Contributing to the accident was both pilots’ lack of experience in operating in actual instrument meteorological conditions.Aug 4, 2023 · N13384 · DestroyedNTSB WPR23LA303Accident · Minor injuriesClass 3 · LimitedFinal reportAldinger Albert John Cozy Mark III · McDermitt, ORThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Aug 3, 2023 · N964AL · Substantial damageNTSB CEN23LA347Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401 · Jamestown, NDThe pilot’s failure to maintain proper airspeed after liftoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.Aug 3, 2023 · N6015W · Substantial damageNTSB CEN23LA346Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Halstad, MNThe pilot’s attempt to rotate the airplane without sufficient airspeed which resulted in a lack of climb performance and impact with terrain. Contributing to the accident was the pilot’s decision to attempt the takeoff with a tailwind.Aug 2, 2023 · N45453 · Substantial damageNTSB WPR23LA298Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Long Beach, CAThe flight instructor’s inattention during ground operations, which resulted in unintentional movement of the airplane and ground collision with another airplane.Aug 1, 2023 · N46393 · 2 aircraft · Minor damageNTSB CEN23LA341Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Arthur, ILThe pilot’s failure to maintain clearance from trees during a low-level aerial application flight.Jul 31, 2023 · N644ME · Substantial damageNTSB CEN23LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Sherman, TXThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose over.Jul 31, 2023 · N6837F · Substantial damageNTSB WPR23LA293Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Port Angeles, WAThe pilot’s inadequate fuel monitoring, which resulted in a total loss of engine power due to fuel starvation.Jul 30, 2023 · N8675W · Substantial damageNTSB WPR23LA290Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 23 · Coolin, IDThe pilot’s failure to maintain clearance from trees after takeoff, during high density altitude weather conditions.Jul 30, 2023 · N2362Z · Substantial damageNTSB WPR23FA296Accident · 1 fatalClass 3 · FieldFinal reportCessna T206H · Yellow Pine, IDThe pilot’s decision to perform a go-around into rising mountainous terrain. Contributing to the accident was the pilot’s failure to follow published airport guidance about go-arounds, and landings and takeoffs with unfavorable winds.Jul 30, 2023 · N918KG · Substantial damageNTSB CEN23LA342Accident · 1 fatalClass 4 · LimitedFinal reportBell 206B · Denison, IAThe pilot’s inflight distraction, which resulted in his failure to see and avoid wires.Jul 30, 2023 · N231RL · Substantial damageNTSB WPR23LA292Accident · No injuriesClass 4 · LimitedFinal reportJohn Espe Cruiser · Buhl, IDThe pilot's failure to maintain airplane control during landing with a gusting tail wind.Jul 29, 2023 · N314E · Substantial damageNTSB WPR23FA289Accident · Serious injuriesClass 3 · FieldFinal reportCessna 177 · Gillette, WYThe pilot's decision to depart the high-density-altitude airport with the airplane at the maximum gross weight limit.Jul 29, 2023 · N3357T · Substantial damageNTSB ERA23FA317Accident · 1 fatalClass 3 · FieldFinal reportBell 206-L4 · Springfield, OHThe pilot’s failure to remain clear of powerlines during an agricultural spraying operation.Jul 29, 2023 · N652HA · Substantial damageNTSB CEN23LA336Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Alta, IAThe airplane’s encounter with a dust devil, which resulted in a loss of lift, and subsequent collision with powerlines.Jul 29, 2023 · N402PR · Substantial damageNTSB DCA23LA382Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Myrtle Beach (Atlantic Ocean)An encounter with convectively induced turbulence (CIT) while in cruise flight.Jul 28, 2023 · N77431 · No damageNTSB CEN23LA334Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Aberdeen, SDThe pilot's failure to maintain directional control while taxiing with a quartering tailwind, which resulted in a ground loop.Jul 27, 2023 · N8503W · Substantial damageNTSB CEN23LA329Accident · Minor injuriesClass 3 · LimitedFinal reportVarga 2150A · Green Lake, WIA loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight planning.Jul 27, 2023 · N5601G · Substantial damageNTSB CEN23LA328Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Hanlontown, IAThe pilot’s failure to maintain clearance from a cable during spray operations.Jul 26, 2023 · N467HA · Substantial damageNTSB ANC23LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK. I(L20A) · Point Baker, AKThe pilot’s failure to maintain directional control during takeoff with a quartering tailwind.Jul 26, 2023 · N6782L · Substantial damageNTSB CEN23LA324Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-402B · Clara City, MNThe pilot’s failure to maintain clearance from a transmission line during an aerial application flight.Jul 25, 2023 · N291DL · Substantial damageNTSB DCA23LA383Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · East Palestine, OHAn inadvertent encounter with convectively induced turbulence (CIT) during descent.Jul 24, 2023 · N279WN · No damageNTSB CEN23FA315Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Houston, TXThe student pilot’s loss of airplane control in dark night conditions.Jul 23, 2023 · N17043 · Substantial damageNTSB WPR23LA284Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Red Lodge, MTThe pilot’s loss of directional control during landing with wind gusts, which resulted in a ground loop and collision with a fence.Jul 22, 2023 · N53132 · Substantial damageNTSB WPR23LA280Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12S · Kalispell, MTThe pilot's failure to maintain directional control of the airplane during landing with a crosswind.Jul 21, 2023 · N48MR · Substantial damageNTSB ERA23LA307Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206 · Terra Alta, WVThe pilot’s inability to maneuver the helicopter for recovery after experiencing a strong, unanticipated tailwind in a confined operating area, which resulted in a descent and subsequent impact with terrain.Jul 21, 2023 · N9913K · Substantial damageNTSB CEN23LA321Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Plains, KSThe pilot’s failure to maintain control during takeoff from a water-contaminated runway.Jul 21, 2023 · N602AA · Substantial damageNTSB WPR23LA282Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Elko, NVThe pilot’s failure to ensure adequate airplane performance before taking off from a significantly shorter runway than originally planned for.Jul 20, 2023 · N4149J · Substantial damageNTSB ANC23FA056Accident · 4 fatalClass 3 · FieldFinal reportBell 206-L4 · Wainwright, AKThe pilot's decision to fly at a low altitude over a large body of water toward featureless terrain, which resulted in a loss of visual clues and controlled flight into terrain.Jul 20, 2023 · N311MH · DestroyedNTSB CEN23LA309Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Princeton, TXThe student pilot’s decision to attempt a takeoff from an unimproved field which resulted in an impact with an obstacle.Jul 16, 2023 · N41317 · Substantial damageNTSB ERA23LA368Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Culpeper, VAThe airplane’s impact with a deer while performing a takeoff at night.Jul 15, 2023 · N1809H · Substantial damageNTSB CEN23LA325Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic N-210 · Erie, COA hard landing due to the high wind conditions which resulted in two passengers sustaining serious injuries.Jul 14, 2023 · N1958S · No damageNTSB CEN23LA311Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802 · Benson, MNThe pilot’s failure to adequately survey a field for obstructions prior to a low-level aerial application pass, which resulted in an impact with a powerline. Contributing to the accident was the degraded visibility due to the smoke in the area.Jul 14, 2023 · N22FK · Substantial damageNTSB CEN23LA305Accident · Serious injuriesClass 4 · LimitedFinal reportAdams Balloon AB · Lafayette, COAn inadvertent hard landing in high wind conditions resulting in serious injury of two passengers. Contributing to the accident was the increase in prevailing winds prior to the forecast.Jul 14, 2023 · N895FA · No damageNTSB CEN23LA308Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Atchison, KSThe pilot’s failure to adequately survey a field for obstructions prior to a low-level aerial application pass, which resulted in an impact with a powerline.Jul 13, 2023 · N533DR · Substantial damageNTSB ANC23LA050Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Matanuska Glacier, AKThe airplane’s encounter with downdrafts resulting in decreased performance insufficient to outclimb rising terrain.Jul 13, 2023 · N460JC · Substantial damageNTSB DCA23LA378Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-214 · Inverness, FLAn inadvertent encounter with convectively induced turbulence during descent.Jul 12, 2023 · N249NV · No damageNTSB CEN23LA302Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Custer, SDThe pilot’s weather encounter that resulted in a high speed landing, the balloon tipping over, and serious injury to a passenger.Jul 12, 2023 · N605KD · No damageNTSB CEN23LA300Accident · No injuriesClass 4 · LimitedFinal reportAcrosport II · Hertford, NCThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with vegetation.Jul 12, 2023 · N827JA · Substantial damageNTSB WPR23LA271Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · Burlington, WAThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.Jul 11, 2023 · N8889K · Substantial damageNTSB ERA23LA305Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Gray, GAAn in-flight collision with a bird.Jul 11, 2023 · N271MG · Substantial damageNTSB WPR23FA258Accident · 1 fatalClass 3 · FieldFinal reportCessna 172N · San Rafael, CAThe total loss of engine power due to carburetor icing as a result of the pilot’s failure to activate the carburetor heat in a timely manner during the descent.Jul 9, 2023 · N4922G · Substantial damageNTSB WPR23LA266Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Judith Gap, MTThe pilot's decision to take off on a soft field that exceeded the performance capabilities of the airplane, which resulted in an impact with a pole and terrain.Jul 8, 2023 · N4135M · Substantial damageNTSB WPR23LA261Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6G · La Grande, ORThe pilot's failure to maintain clearance from trees during an airstrip overfly, which resulted in impact damage to the left wing.Jul 8, 2023 · N92761 · Substantial damage