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 WPR23FA257Accident · 6 fatalClass 3 · FieldFinal reportCessna 550 · Murrieta, CAThe flight crew’s decision to descend below the decision altitude of an instrument approach without having the appropriate runway visual reference(s) distinctively identified and with the visibility below the minimum that was prescribed for the approach,…Jul 8, 2023 · N819KR · DestroyedNTSB CEN23LA287Accident · No injuriesClass 4 · LimitedFinal reportAerofab LA-4 · Big Prairie, MIThe airplane’s collision with a submerged log during a water landing.Jul 8, 2023 · N993PT · Substantial damageNTSB WPR23LA268Accident · No injuriesClass 4 · LimitedFinal reportVickers-Armstrong Spitfire IX · Deer Park, WAThe pilot’s failure to maintain directional control during landing with a crosswind.Jul 7, 2023 · N633VS · Substantial damageNTSB ERA23LA299Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Richmond, VAThe pilot’s delay in performing a go-around after a likely encounter with low-level wind shear, resulting in a hard landing. Contributing to the accident were the pilot’s failure to recognize the severity of the actual and forecasted weather near the airport…Jul 7, 2023 · N759HD · Substantial damageNTSB CEN23LA290Accident · No injuriesClass 4 · LimitedFinal reportGood James AIR CAM · Caswell Beach, NCThe pilot’s failure to properly evaluate the sea state during an open sea landing and subsequent takeoff attempt resulting in an inadvertent impact with the water.Jul 7, 2023 · N38HP · Substantial damageNTSB CEN23FA283Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Rayville, LAThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control during the approach to the destination airport and subsequent impact with terrain.Jul 7, 2023 · N15RP · DestroyedNTSB CEN23FA285Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-60-601P · Burlington, COThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control in flight and subsequent impact with terrain.Jul 6, 2023 · N100PB · DestroyedNTSB CEN23LA292Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Burlington, VTThe student pilot’s improper landing flare, which resulted in a hard, bounced landing and the flight instructor’s delayed remedial action.Jul 5, 2023 · N64AF · Substantial damageNTSB CEN23LA280Accident · Serious injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Amity, MOThe pilot’s failure to see and avoid wires while conducting a low-level aerial application flight.Jul 5, 2023 · N828WP · Substantial damageNTSB CEN23LA279Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Chapman, KSThe pilot’s failure to maintain clearance from the power line during an agricultural application pass.Jul 5, 2023 · N67FA · Substantial damageNTSB CEN23LA275Accident · No injuriesClass 4 · LimitedFinal reportCessna 180A · Grand Prairie, TXThe pilot’s failure to maintain directional control during landing. Contributing to the accident was the unexpected sudden wind shift.Jul 5, 2023 · N889SL · Substantial damageNTSB ANC23LA047Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-210C · Kusatan, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a bounced landing and an encounter with soft terrain, and a nose over.Jul 5, 2023 · N51592 · Substantial damageNTSB WPR23LA254Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MX7-180C · Belgrade, MTThe pilot’s failure to maintain directional control during landing with a quartering tailwind, which resulted in a runway excursion and nose over.Jul 4, 2023 · N3171H · Substantial damageNTSB CEN23LA272Accident · Serious injuriesClass 4 · LimitedFinal reportSix Chuter SR7 XL · Chetek, WIThe pilot’s failure to maintain aircraft control during initial climb which resulted in an impact with a pole, trees, and terrain.Jul 2, 2023 · N6365A · Substantial damageNTSB ANC23LA046Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Talkeetna, AKThe pilot’s encounter with a downdraft while maneuvering low-level, which resulted in a collision with terrain.Jul 2, 2023 · N3321B · Substantial damageNTSB WPR23LA273Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Metaline Falls, WAThe pilot’s loss of directional control during landing due to impact with a concrete ring embedded in the grass runway.Jul 1, 2023 · N68TP · Substantial damageNTSB ERA23LA284Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269C · Macclenny, FLThe improper maintenance of the landing gear dampers and main rotor elastomeric dampers, resulting in ground resonance during an unsuccessful takeoff attempt with the helicopter near its maximum gross weight for the density altitude.Jul 1, 2023 · N9WZ · Substantial damageNTSB ANC23LA049Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Beluga, AKThe pilot's selection of an unsuitable takeoff site, resulting in a collision with brush-covered terrain.Jul 1, 2023 · N15XX · Substantial damageNTSB CEN23LA271Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Siloam Springs, ARThe pilot’s failure to maintain clearance from power lines while on final approach to land.Jun 30, 2023 · N739GU · Substantial damageNTSB WPR23LA246Accident · No injuriesClass 4 · LimitedFinal reportBlack Sheep CCX-1865 · Big Creek Ranger Station, IDThe pilot’s failure to identify the wet landing surface and his subsequent inability to maintain directional control and stop during landing on the unimproved grass runway, which resulted in a runway excursion and unintentional ground loop.Jun 28, 2023 · N510US · Substantial damageNTSB WPR23LA245Accident · No injuriesClass 4 · LimitedFinal reportSchleicher Alexander ASH 26 E · Williams, CAThe pilot’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in a collision with terrain.Jun 26, 2023 · N26DX · Substantial damageNTSB CEN23LA277Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C-50 · Elbert, COThe pilot's loss of directional control during takeoff and subsequent excessive use of brakes which resulted in a nose-over. Contributing to the accident was his decision to takeoff downwind.Jun 26, 2023 · N23161 · Substantial damageNTSB WPR23LA240Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Cedar Mountain, UTThe pilot’s decision to depart with a high density altitude, which degraded the airplane’s climb performance and resulted in an impact with trees.Jun 25, 2023 · N2358V · Substantial damageNTSB ERA23LA295Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206B · Sandersville, GAThe pilot’s failure to maintain clearance from trees during landing, which resulted in a tail rotor contact with tree limbs and a subsequent loss of control.Jun 25, 2023 · N919AC · Substantial damageNTSB ERA23LA278Accident · No injuriesClass 4 · LimitedFinal reportGopalan Hariharan 4 Place · Sanford, NCThe pilot’s failure to maintain directional control while landing in a crosswind, which resulted in a nose over.Jun 25, 2023 · N108YZ · Substantial damageNTSB CEN23LA265Accident · No injuriesClass 4 · LimitedFinal reportBearhawk Model 5 · Livingston, TXThe pilot’s failure to maintain directional control during the rollout, which resulted in a runway excursion, and a collision with a building. Contributing to the accident were the obstacles at the airstrip that prevented the pilot from performing a go-around.Jun 25, 2023 · N619MS · Substantial damageNTSB WPR23LA259Accident · Serious injuriesClass 4 · LimitedFinal reportAviat A-1B · Las Vegas, NVThe pilot’s unsafe inflight operation of the airplane and failure to maintain clearance from a person on the ground, which resulted in a serious injury.Jun 24, 2023 · N307F · Minor damageNTSB ERA23LA303Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-201 · Macon, GAAn inflight collision with a bird.Jun 24, 2023 · N285MG · Substantial damageNTSB CEN23LA266Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Howell, MIA loss of engine power due to the formation of carburetor ice that resulted from the pilot’s delayed use of carburetor heat during the landing approach.Jun 24, 2023 · N4008Q · Substantial damageNTSB CEN23LA264Accident · No injuriesClass 3 · LimitedFinal reportBeech B19 · Scott City, KSA partial loss of engine power as a result of carburetor icing that formed while the engine was operating at a low power setting for an extended period before departure.Jun 24, 2023 · N9721Q · Substantial damageNTSB ERA23LA275Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Pence Springs, WVA total loss of engine power due to carburetor icing.Jun 23, 2023 · N9543E · Substantial damageNTSB CEN23LA260Accident · No injuriesClass 4 · LimitedFinal reportSharp Glennis Escapade · Bolivar, MOThe pilot’s failure to maintain aircraft control during a soft-field takeoff after encountering a wind gust.Jun 23, 2023 · N907ML · Substantial damageNTSB CEN23FA257Accident · 1 fatalClass 3 · FieldFinal reportAvid Magnum · Beaver Island, MIThe pilot’s failure to maintain clearance from the water while maneuvering in low visibility conditions due to smoke and haze.Jun 23, 2023 · N103DG · Substantial damageNTSB WPR23LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Idaho Falls, IDThe pilot’s failure to maintain directional control while landing with a gusting crosswind.Jun 21, 2023 · N3531Y · Substantial damageNTSB WPR23LA235Accident · No injuriesClass 4 · LimitedFinal reportJohn Topliff PA18-200EXP · Truckee, CAThe pilot’s loss of directional control on landing roll out, during variable wind conditions.Jun 21, 2023 · N356AW · Substantial damageNTSB CEN23LA251Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Osceola, IAThe pilot’s failure to maintain directional control of the tailwheel equipped airplane during a crosswind landing.Jun 21, 2023 · N3127C · Substantial damageNTSB CEN23LA245Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Louise, TXThe pilot’s failure to maintain directional control in gusting wind conditions.Jun 18, 2023 · N932SH · Substantial damageNTSB CEN23LA244Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Sturgis, SDThe pilot’s improper timing to initiate beta mode with the propeller and his failure to maintain directional during the full load landing that resulted in a runway excursion. Contributing to the accident was the pilot’s lack of recent experience with…Jun 18, 2023 · N290LA · Substantial damageNTSB ERA23FA270Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-30 · Ebensburg, PAThe pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an uncontrolled descent and collision with terrain.Jun 17, 2023 · N7628Y · DestroyedNTSB CEN23LA242Accident · Minor injuriesClass 4 · LimitedFinal reportTipton Kitfox Kitfox IV · Odessa, MOThe pilot’s failure to attain the proper touchdown speed, which resulted in a runway excursion and subsequent nose over.Jun 17, 2023 · N4287Y · Substantial damageNTSB WPR23LA233Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Elko, NVThe pilot’s loss of control after encountering a dust devil during takeoff.Jun 16, 2023 · N8223A · Substantial damageNTSB ANC23FA042Accident · 2 fatalClass 3 · FieldFinal reportCessna 180 · Shaktoolik, AKThe pilot’s encounter with gusting tailwind conditions during takeoff, which resulted in impact with a tree, a loss of control, and subsequent impact with terrain.Jun 16, 2023 · N91361 · Substantial damageNTSB CEN23LA427Accident · Minor injuriesClass 4 · LimitedFinal reportQuad City Challenger · Indianola, MSThe non-certificated pilot’s loss of control during the night landing.Jun 14, 2023 · UNREG · Substantial damageNTSB CEN23FA239Accident · 2 fatalClass 3 · FieldFinal reportMooney M20R · Watertown, WIThe pilot’s loss of control due to spatial disorientation while operating in instrument meteorological conditions. Contributing to the accident was the pilot’s impairment from the prohibited substance; however, the extent of impairment could not be determined.Jun 14, 2023 · N1025C · DestroyedNTSB ERA23LA294Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA50 · Wagener, SCThe pilot’s decision to take off from a short, grass runway in gusting wind conditions, resulting in a rejected takeoff and runway excursion.Jun 13, 2023 · OE-DSD · Substantial damageNTSB WPR23LA231Accident · Minor injuriesClass 4 · LimitedFinal reportJohnson Gary L Fisher Horizon 1 · Chelan, WAThe pilot’s improper selection of a touchdown point and delayed recognition, which resulted in an impact with an obstacle.Jun 12, 2023 · N88GJ · Substantial damageNTSB WPR23FA225Accident · 1 fatalClass 3 · FieldFinal reportCessna R182 · McCall, IDMaintenance personnel's failure to properly torque and inspect the magneto hardware, which resulted in a partial loss of engine power.Jun 12, 2023 · N3138C · Substantial damageNTSB WPR23LA230Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV6A · Mimbres, NMThe pilot’s inflight loss of control while landing with wind gusts that resulted in a hard landing and subsequent nose over.Jun 11, 2023 · N60605 · Substantial damageNTSB WPR23FA223Accident · 2 fatalClass 3 · FieldFinal reportCompagnie Daher TB 30 Epsilon · Apache Junction, AZThe pilot’s controlled flight into the mountainous terrain due to diminished depth perception as a result of the shadowing effect from the sun’s position. Contributing to the accident was the decision by all three pilots to fly low altitude around the…Jun 10, 2023 · N759F · DestroyedNTSB WPR23LA218Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A188B · Chillicothe, MOA partial loss of engine power due to a tear in the fuel manifold diaphragm, which prevented sufficient fuel flow to the engine.Jun 7, 2023 · N731UF · Destroyed