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 WPR21LA333Accident · Serious injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Glide, ORThe pilot’s failure to maintain clearance from a tree during an aerial application.Aug 27, 2021 · N303AE · Substantial damageNTSB CEN21LA449Accident · No injuriesClass 4 · LimitedFinal reportColumbia Aircraft Mfg LC41-550FG · Granby, COThe pilot’s loss of control during landing in high density altitude conditions.Aug 27, 2021 · N522LG · Substantial damageNTSB ERA21LA389Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Fairfield, NJThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.Aug 26, 2021 · N472CD · Substantial damageNTSB ERA21LA353Accident · No injuriesClass 3 · LimitedFinal reportEmbraer EMB-505 · Banner Elk, NCThe pilot’s failure to achieve the approach criteria for the available runway landing distances published in the POH, likely as a result of the steeper-than-normal approach and the required left turn on short final to avoid the terrain surrounding the…Aug 26, 2021 · N413N · Substantial damageNTSB CEN21LA392Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Olive Branch, MSThe pilot’s failure to maintain directional control of the airplane during landing with a direct crosswind that resulted in an impact with terrain.Aug 26, 2021 · N12573 · Substantial damageNTSB WPR21LA329Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150D · Chino, CAThe pilot’s delayed use of carburetor heat, which resulted in a loss of engine power due to carburetor icing.Aug 25, 2021 · N4375U · Substantial damageNTSB WPR21LA326Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Del Mar, CAThe partial loss of engine power for reasons that could not be determined, which resulted in a forced landing on an interstate highway and subsequent collision with vehicles.Aug 24, 2021 · N2843T · Substantial damageNTSB CEN21LA413Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Stow, OHThe airplane’s impact with a deer during a night landing.Aug 24, 2021 · N95445 · Substantial damageNTSB CEN21LA384Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Lansing, MIThe pilot’s decision to depart with a tailwind as a thunderstorm approached, which resulted in a loss of airplane performance due to an encounter with a significant tailwind gust and a subsequent runway excursion.Aug 24, 2021 · N1GG · DestroyedNTSB DCA21LA209Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus 319-132 · Chicago, ILAn encounter with clear air turbulence.Aug 21, 2021 · N806AW · No damageNTSB ANC21LA081Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK. I(L20A) · Kodiak, AKThe pilot’s improper landing flare, which resulted in a hard landing and nose over.Aug 21, 2021 · N4334Y · Substantial damageNTSB WPR21LA328Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wasilla, AKThe pilot’s inability to maintain control of the airplane during taxi after it encountered the prop wash from a larger airplane that was conducting a high-power engine run on the same taxiway.Aug 20, 2021 · N89ZW · Substantial damageNTSB WPR21LA325Accident · No injuriesClass 3 · LimitedFinal reportStout Garry V Europa - Trigear · Hanksville, UTThe pilot’s installation of a non-original equipment manufactured radiator cap, which resulted in the loss of coolant and the engine’s exceedance of the maximum admissible cylinder head temperature. Contributing to the accident was the lack of suitable…Aug 16, 2021 · N133AC · Substantial damageNTSB WPR21FA321Accident · 3 fatalClass 3 · FieldFinal reportCessna 182H · Bountiful, UTThe decision of both pilots to fly into a steep canyon, which resulted in the airplane being unable to maintain a sufficient altitude to clear rising terrain. Contributing to the accident was their delayed initial action in responding to the hazard, and their…Aug 16, 2021 · N8477S · DestroyedNTSB ANC21LA073Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Fairbanks, AKThe pilot’s unexpected encounter with supercooled liquid droplets (SLD), which resulted in a loss of control due to ice accumulation. Contributing to the accident were: (1) the pilot’s failure to maintain the minimum airspeed for flight in icing conditions,…Aug 16, 2021 · N97HA · Substantial damageNTSB WPR21LA319Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Panguitch, UTThe airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance due to high-density altitude conditions. Contributing to the accident was the pilot’s failure to conduct preflight performance planning…Aug 13, 2021 · N1651J · Substantial damageNTSB ANC21LA074Accident · No injuriesClass 3 · LimitedFinal reportCessna 180H · Soldotna, AKThe flight instructor's inadequate supervision of the pilot receiving instruction, which resulted in a loss of control during the landing touchdown and a left main landing gear collapse.Aug 13, 2021 · N3467Y · Substantial damageNTSB WPR21LA316Accident · No injuriesClass 3 · LimitedFinal reportBeech 77 · Stanley, NMA loss of engine performance due to lead fouling of the lower spark plugs, which resulted in an off airport forced landing.Aug 12, 2021 · N3873Y · Substantial damageNTSB CEN21LA381Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Wadsworth, OHA partial loss of engine power due to carburetor icing and the pilot’s failure to apply carburetor heat when the power loss occurred.Aug 11, 2021 · N66748 · Substantial damageNTSB CEN21FA368Accident · 1 fatalClass 3 · FieldFinal reportRockwell International S2R · Strasburg, NDThe pilot’s intentional flight under power lines and his failure to maintain clearance from the lines during an aerial application flight.Aug 10, 2021 · N4956X · Substantial damageNTSB WPR21LA308Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Reno, NVThe pilot’s failure to maintain clearance from mountainous terrain prior to encountering a downdraft, which resulted in a forced landing and collision with terrain.Aug 9, 2021 · N5735R · Substantial damageNTSB CEN21LA370Accident · No injuriesClass 4 · LimitedFinal reportMarlowe Thooft Just Acft Highlander · Brainerd, MNThe pilot’s failure to maintain directional control during a crosswind landing that resulted in an impact with terrain.Aug 7, 2021 · N234HW · Substantial damageNTSB CEN21FA360Accident · 3 fatalClass 3 · FieldFinal reportMooney M20M · Victoria, MNThe pilot’s loss of airplane control due to spatial disorientation during final approach, which led to a spiral dive that overstressed the airplane and resulted in an in-flight breakup.Aug 7, 2021 · N9156Z · DestroyedNTSB WPR21LA307Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170A · Metaline Falls, WAThe pilot’s failure to attain sufficient altitude during the initial climb to clear trees due to an encounter with windshear.Aug 6, 2021 · N5459C · Substantial damageNTSB WPR21LA306Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-85 · Woodburn, ORThe pilot’s failure to maintain clearance during takeoff from a person on the ground who sustained a serious injury as a result of the collision.Aug 5, 2021 · N6018H · No damageNTSB ANC21FA069Accident · 6 fatalClass 2 · FieldFinal reportDehavilland DHC-2 MK.I · Ketchikan, AKThe pilot’s decision to continue visual flight rules (VFR) flight into instrument meteorological conditions (IMC), which resulted in controlled flight into terrain. Contributing to the accident was the FAA’s reliance on voluntary compliance with the Ketchikan…Aug 5, 2021 · N1249K · DestroyedNTSB CEN21LA354Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Wooster, OHThe pilot inadvertently collided with powerline wires during an agricultural spraying flight, resulting in a loss of aircraft control and subsequent impact with the ground.Aug 4, 2021 · N1519U · Substantial damageNTSB CEN21LA350Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Waukon, IAThe pilot’s failure to maintain adequate clearance from a powerline during an agricultural application pass.Aug 4, 2021 · N775AK · Substantial damageNTSB CEN21FA355Accident · 2 fatalClass 3 · FieldFinal reportNorth American T-6G · Starkville, MSThe pilot’s failure to maintain clearance from trees while maneuvering at low altitude.Aug 4, 2021 · N7197C · DestroyedNTSB WPR21LA312Accident · Minor injuriesClass 4 · LimitedFinal reportLake LA-4 · Lake Isabell, CAThe pilot’s failure to establish a positive climb rate after takeoff, which resulted in an impact with an object.Aug 3, 2021 · N7615L · Substantial damageNTSB ERA21LA313Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Waxhaw, NCThe pilot’s failure to abort the takeoff in sufficient time to stop the airplane on the runway remaining. Contributing to the accident was the lack of airplane takeoff performance due to the pilot’s failure to assure that the carburetor heat control was in…Aug 2, 2021 · N3090U · Substantial damageNTSB CEN21LA351Accident · Serious injuriesClass 3 · LimitedFinal reportCozy Mark IV · Rushville, NEA total loss of engine power due to an obstruction of airflow to the engine as a result of the landing brake being deployed in flight.Aug 2, 2021 · N1361S · Substantial damageNTSB ANC21LA068Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-1 · Sterling, AKInsufficient available power as a result of low compression in three engine cylinders. Contributing to the accident was the pilot’s decision to takeoff with a slight quartering tailwind.Aug 2, 2021 · N8656K · Substantial damageNTSB WPR21LA310Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Fort Sumner, NMThe pilot's failure to maintain adequate clearance from a windmill while maneuvering during an aerial application flight.Jul 30, 2021 · N9197F · DestroyedNTSB CEN21LA348Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Merry, NEThe pilot’s failure to maintain clearance from a wire during a low-level aerial application flight.Jul 30, 2021 · N857TL · Substantial damageNTSB WPR21LA293Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28A · Mountain Home, IDThe pilot's improper fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent hard landing on uneven terrain.Jul 28, 2021 · N46MU · Substantial damageNTSB WPR21LA314Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CCX-2000 · Roseburg, ORThe pilot’s failure to maintain directional control during the landing roll which, resulted in a runway excursion and collision with a tree.Jul 27, 2021 · N161BS · Substantial damageNTSB ERA21LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Farmingdale, NYThe pilot’s failure to maintain clearance with a fuel truck while taxiingJul 27, 2021 · N73334 · Substantial damageNTSB CEN21LA341Accident · No injuriesClass 4 · LimitedFinal reportCessna T210F · Peyton, COThe pilot’s fuel mismanagement that resulted in a complete loss of engine power during climb and subsequent impact with terrain during a forced landing.Jul 27, 2021 · N6162R · Substantial damageNTSB CEN21LA340Accident · Serious injuriesClass 4 · LimitedFinal reportStephen L Kruer Superstol · Floyds Knobs, INThe pilot’s failure to maintain clearance from the trees during a go-around.Jul 27, 2021 · N852SK · Substantial damageNTSB ERA21LA300Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 140 · Murfreesboro, TNA total loss of engine power as a result of carburetor icing.Jul 26, 2021 · N72129 · Substantial damageNTSB ANC21FA065Accident · 2 fatalClass 3 · FieldFinal reportCessna 172P · Eagle River, AKAn inflight collision with terrain under unknown circumstances. Contributing to the delayed rescue response was the failure of the emergency locator transmitter (ELT) to activate as designed, and the mechanic’s failure to ensure the correct ELT was installed…Jul 26, 2021 · N65698 · Substantial damageNTSB WPR21LA311Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Kernville, CAThe pilot’s failure to maintain airplane control during landing after an encounter with a wind gust which resulted in a collision with trees.Jul 25, 2021 · N728KG · Substantial damageNTSB WPR21LA290Accident · Minor injuriesClass 4 · LimitedFinal reportBurkhart Grob G 103 Twin II · Levan, UTThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight which resulted in an off-airport landing and a collision with a fence.Jul 25, 2021 · N4446Y · Substantial damageNTSB ERA21LA299Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV6 · Ocracoke, NCThe pilot's failure to perform a go-around during the unstabilized approach, which resulted in the airplane landing too far down the runway, and a subsequent runway excursion.Jul 25, 2021 · N464DM · Substantial damageNTSB WPR21LA345Accident · No injuriesClass 4 · LimitedFinal reportCessna 340 · Rock Springs, WYThe pilot’s improper pitch control during takeoff which resulted in an aerodynamic stall and subsequent hard landingJul 24, 2021 · N419TT · Substantial damageNTSB WPR21LA302Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Sandpoint, IDThe pilot’s failure to maintain directional control during landing with a crosswind which, resulted in a runway excursion and impact with terrain.Jul 24, 2021 · N946PD · Substantial damageNTSB WPR21LA292Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 180K · Mt. Hood, ORThe total loss of engine power while in cruise flight for reasons that could not be determined based on available evidence. Contributing to the accident was the presentation of an abandoned airport as available for use in the Federal Aviation Administration…Jul 24, 2021 · N8884 · Substantial damageNTSB CEN21LA338Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Harrah, OKThe pilot’s decision to fly the airplane without a carburetor heat control in atmospheric conditions conducive to the development of serious carburetor icing, which resulted in a partial loss of engine power.Jul 23, 2021 · N83365 · Substantial damageNTSB CEN21LA336Accident · No injuriesClass 3 · LimitedFinal reportDriver RV-7 · Oshkosh, WIThe RV-8 pilot’s failure to account for the position of the RV-7 behind him during the landing roll in a staggered landing formation, which resulted in a ground collision of the two airplanes. Contributing to the accident was the self-induced pressure created…Jul 23, 2021 · N977RV · 2 aircraft · Substantial damage