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 CEN21LA333Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Baraboo, WIThe pilot’s failure to maintain clearance from the fence while on final approach.Jul 23, 2021 · N51CF · Substantial damageNTSB WPR21LA296Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Chelan, WAThe pilot’s unstable approach to land in turbulent conditions, which resulted in a hard landing short of the runway and subsequent loss of directional control and collision with terrain.Jul 22, 2021 · N315JT · Substantial damageNTSB CEN21LA373Accident · No injuriesClass 4 · LimitedFinal reportMooney M20F · New Albany, MSThe pilot’s delayed decision to abort the landing that resulted in a collision with a fence post. Contributing to the accident was the failure of the alternator drive belt during cruise flight for unknown reasons and the subsequent inoperative electrical…Jul 22, 2021 · N6474Q · Substantial damageNTSB ERA21LA298Accident · No injuriesClass 3 · LimitedFinal reportCarpenter Stol CH750 · Rockwell, NCThe total loss of engine power due to carburetor ice. Also causal was the pilot’s failure to apply carburetor heat at any time during the flight.Jul 21, 2021 · N750RS · Substantial damageNTSB ERA21LA295Accident · 2 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Point Harbor, NCThe noncertificated pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation over a large body of water and a high velocity impact with the water. Contributing to the accident…Jul 19, 2021 · N4529J · DestroyedNTSB ERA21LA294Accident · No injuriesClass 4 · LimitedFinal reportTurbine Cubs Of Wyoming PA-18 Super CUB · Dinwiddie, VAThe pilot’s failure to maintain control while taxiing on soft ground, which resulted in a nose-over.Jul 19, 2021 · N507TC · Substantial damageNTSB CEN21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Brenham, TXThe pilot’s failure to maintain control of the airplane during takeoff from a rough field.Jul 19, 2021 · N9024M · Substantial damageNTSB CEN21FA330Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Elgin, MNThe pilot’s decision to operate the helicopter under powerlines, which resulted in a main rotor blade striking a powerline, causing the helicopter to descend from a low altitude and impact terrain.Jul 19, 2021 · N44BJ · DestroyedNTSB CEN21LA323Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Refugio, TXThe pilot’s failure to maintain directional control during the landing roll with a tailwind.Jul 16, 2021 · N174R · Substantial damageNTSB WPR21FA272Accident · 4 fatalClass 3 · FieldFinal reportMooney M20J · Dinsmore, CAThe airplane’s degraded engine performance due to wear to the intake cam lobes, which diminished the airplane’s takeoff and climb performance, resulting in a subsequent collision with trees.Jul 15, 2021 · N4474H · DestroyedNTSB CEN21LA322Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Edcouch, TXThe pilot’s inadequate compensation for a gusting wind during takeoff.Jul 15, 2021 · N334LA · Substantial damageNTSB WPR21FA270Accident · 2 fatalClass 3 · FieldFinal reportCessna 421C · Monterey, CAThe pilot’s failure to maintain airplane control due to spatial disorientation during an instrument departure procedure in instrument meteorological conditions which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of…Jul 13, 2021 · N678SW · DestroyedNTSB ERA21LA291Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A150K · Brooksville, FLA total loss of engine power as a result of carburetor icing.Jul 13, 2021 · N8412M · Substantial damageNTSB ERA21LA284Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Elba, ALThe partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with trees during takeoff.Jul 11, 2021 · N8172S · Substantial damageNTSB ANC21LA063Accident · No injuriesClass 4 · LimitedFinal reportBeech F35 · Yakutat, AKThe pilot’s failure to ensure adequate runway distance for landing.Jul 11, 2021 · N891JH · Substantial damageNTSB ANC21LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Rampart, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose over.Jul 11, 2021 · N2583C · Substantial damageNTSB CEN21LA315Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421C · Longmont, COThe loss of performance for reasons that could not be determined.Jul 10, 2021 · N66NC · Substantial damageNTSB WPR21LA276Accident · No injuriesClass 4 · LimitedFinal reportPayne Steven R RV-8 · Hillsboro, ORThe second pilot’s diverted attention while taxing which, resulted in his failure to maintain clearance from another airplane holding short of the runway.Jul 9, 2021 · N526KP · 2 aircraft · Substantial damageNTSB ANC21LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2-L-20 · Coffman Cove, AKThe pilot’s impact with a buoy on takeoff which resulted in a nose-over.Jul 9, 2021 · N9279Z · Substantial damageNTSB ANC21LA058Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-210C · Anchorage, AKThe pilot’s impact with a log while dragging an off-airport landing site.Jul 7, 2021 · N349X · Substantial damageNTSB CEN21LA318Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Nappanee, INThe pilot’s failure to maintain clearance from the tower during low-level agricultural operations.Jul 6, 2021 · N602RE · Substantial damageNTSB ANC21LA053Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Kenney Lake, AKThe pilot’s failure to maintain adequate clearance from a tree during takeoff, which resulted in a loss of directional control and impact with terrain.Jul 6, 2021 · N185YT · Substantial damageNTSB WPR21LA260Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5B · Wells, NVThe pilot’s decision to takeoff with a tailwind, which resulted in an impact with terrain.Jul 5, 2021 · N28643 · Substantial damageNTSB DCA21LA176Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Miami, FLan inadvertent encounter with convective turbulence.Jul 5, 2021 · N156AN · No damageNTSB CEN21LA317Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Blanco, TXThe unexpected change in wind speed and direction during the landing which resulted a runway overrun.Jul 5, 2021 · N1393F · Substantial damageNTSB WPR21LA304Accident · No injuriesClass 4 · LimitedFinal reportCessna 182C · Coeur D Alene, IDThe pilot’s failure to attain a proper touchdown point due to excessive airspeed, which resulted in a runway excursion and collision with an object near the end of the runway.Jul 4, 2021 · N9007T · Substantial damageNTSB WPR21LA259Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Lander, WYThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a fence.Jul 4, 2021 · N7802K · Substantial damageNTSB CEN21FA305Accident · 2 fatalClass 3 · FieldFinal reportHawker Beechcraft G36 · Aspen, COThe pilot’s failure to navigate through mountainous terrain, which resulted in controlled flight into terrain.Jul 4, 2021 · N36JJ · DestroyedNTSB ANC21LA052Accident · Serious injuriesClass 4 · LimitedFinal reportChampion 7GCBC · Palmer, AKThe pilot’s selection of unsuitable terrain for landing which resulted in a nose-over.Jul 4, 2021 · N5213X · Substantial damageNTSB CEN21LA306Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Pottsboro, TXThe airplane’s degraded performance from the rough, grass runway surface and the pilot’s delayed decision to abort the takeoff resulting in a runway excursion.Jul 3, 2021 · N181BW · Substantial damageNTSB ERA21LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 402A · Fort Lauderdale, FLThe pilot’s loss of directional control during takeoff with a fogged wind screen and sun glare, which resulted in a runway excursion and a collision with a taxiway sign.Jul 2, 2021 · N4550Q · Substantial damageNTSB CEN21FA300Accident · 2 fatalClass 3 · FieldFinal reportBeech 35-33 · Roff, OKThe pilot’s loss of airplane control due to spatial disorientation during low-level nighttime flight.Jul 2, 2021 · N302Z · DestroyedNTSB WPR21LA264Accident · No injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Twin Falls, IDPartial loss of engine power during a low pass, due to carburetor icing and the pilot’s failure to use carburetor heat during the landing approach.Jul 1, 2021 · N9609H · Substantial damageNTSB ERA21LA307Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Carrollton, ALThe pilot’s incorrect preflight planning and poor in-flight planning, resulting in fuel exhaustion. Contributing to the damage was the inadvertent encounter with a hole during the forced landing.Jul 1, 2021 · N561QL · Substantial damageNTSB CEN21LA308Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Tyler, TXThe pilot’s failure to maintain proper airspeed on approach resulting in an extended touchdown, bounced landing, and runway excursion.Jul 1, 2021 · N42084 · Substantial damageNTSB ANC21LA056Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · North Pole, AKThe pilot’s exceedance of the airplane’s takeoff performance limitations, which prevented the airplane from gaining sufficient altitude to clear the trees off the departure end of the runway.Jul 1, 2021 · N2746D · DestroyedNTSB ANC21LA054Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s excessive use of brakes during landing, which resulted in a nose-over. Contributing to the accident was the flight instructor’s inadequate supervision and the gusty tailwind conditions.Jul 1, 2021 · N8996Y · Substantial damageNTSB WPR21LA255Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Terreton, IDThe pilot's exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall and subsequent impact with terrain.Jun 30, 2021 · N1972L · Substantial damageNTSB CEN21FA297Accident · 1 fatalClass 3 · FieldFinal reportEarthstar Gull 2000 · Curtiss, WIThe non-instrument-rated pilot’s decision to depart into instrument meteorological conditions with dense fog and low clouds, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot’s self-imposed…Jun 30, 2021 · N1712L · Substantial damageNTSB WPR21LA257Accident · No injuriesClass 4 · LimitedFinal reportWheeler C / Wheeler K Lancair 235 · Borrego Springs, CAThe pilot’s failure to maintain airplane control during a crosswind landing which resulted in an impact with terrain.Jun 29, 2021 · N43KC · Substantial damageNTSB WPR21LA250Accident · No injuriesClass 3 · LimitedFinal reportL-Bird CCX-2000 · Hood River, ORThe total loss of engine power due to improper construction of the muffler, which resulted in separation of the internal components.Jun 28, 2021 · N10TA · Substantial damageNTSB ANC21LA050Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Dillingham, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions which resulted in a loss of control and impact with terrain.Jun 28, 2021 · N8216J · Substantial damageNTSB WPR21LA251Accident · Serious injuriesClass 4 · LimitedFinal reportStinson 108-3 · Stevenson, WAA runway incursion, which resulted in a go-around, and subsequent forced landing when the airplane was not able to climb at a rate sufficient to clear approaching rising terrain.Jun 27, 2021 · N6548M · DestroyedNTSB WPR21LA249Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20F · Marion, MTThe pilot’s improper rotation during takeoff from a high-altitude airport and his failure to abort the takeoff, which resulted in an impact with trees and terrain. Contributing to the accident was the pilot’s improper management of the turbocharger, which…Jun 27, 2021 · N9613M · Substantial damageNTSB ERA21LA270Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Waxhaw, NCThe pilot’s failure to maintain clearance from powerlines during a low-level aerial application flight.Jun 27, 2021 · N7078V · Substantial damageNTSB WPR21LA244Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Ririe, IDThe pilot’s encounter with a tailwind during takeoff roll, which resulted in an aborted takeoff, collision with a ditch and subsequent nose over.Jun 26, 2021 · N3208Y · Substantial damageNTSB WPR21FA242Accident · 5 fatalClass 3 · FieldFinal reportCameron Balloons US O-120 · Albuquerque, NMThe failure of the pilot to maintain adequate clearance from power lines while maneuvering for landing. Contributing to the accident was the pilot’s use of impairing, illicit drugs.Jun 26, 2021 · N158NM · DestroyedNTSB ERA21LA269Accident · 1 fatalClass 3 · LimitedFinal reportGarlick Helicopters OH-58A+ · Alpine, ALThe pilot’s failure to maintain clearance from powerlines during a low-level aerial application flight, resulting in main rotor blade impact with a fiber-optic cable, a loss of control, and the helicopter’s subsequent impact with terrain.Jun 25, 2021 · N372NS · Substantial damageNTSB DCA21LA164Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · New Orleans, LAAn inadvertent encounter with severe turbulence during cruise flight that caused a flight attendant to fall and fracture his ankle.Jun 25, 2021 · N926UW · No damageNTSB CEN21LA291Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Loveland, COThe flight instructor’s failure to maintain aircraft control during the landing flare and subsequent attempted go-around with a strong quartering crosswind.Jun 25, 2021 · N9277J · Substantial damage