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 WPR22LA336Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 120 · Scappoose, ORThe pilot's failure to maintain airplane control while taxing in gusty wind conditions.Sep 5, 2022 · N77257 · Substantial damageNTSB WPR22LA334Accident · Serious injuriesClass 3 · LimitedFinal reportBuxbaum Mark Edward Long EZ · Medicine Bow, WYA partial loss of engine power due to the fatigue fracture of the No. 4 exhaust valve head.Sep 5, 2022 · N444MR · Substantial damageNTSB ERA22LA409Accident · No injuriesClass 4 · LimitedFinal reportCessna 182N · Blairstown, NJThe pilot’s decision to cross the taxiway at an unsuitable location.Sep 4, 2022 · N8942G · Substantial damageNTSB DCA22LA198Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus 220 · New York, NYAn encounter with convective turbulence.Sep 4, 2022 · N113DQ · No damageNTSB ERA22LA407Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Mount Bethel, PAThe glider’s encounter with atmospheric conditions, where the lift was not sufficient to maintain flight resulting in an off-airport landing and collision with powerlines.Sep 3, 2022 · N17867 · Substantial damageNTSB ERA22FA397Accident · 1 fatalClass 3 · FieldFinal reportRotorway Jetexec · Arthur, KYThe pilot’s decision to attempt the cross-country flight in thunderstorm conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s failure to obtain a weather briefing.Sep 3, 2022 · N162NH · DestroyedNTSB ANC22LA071Accident · No injuriesClass 4 · LimitedFinal reportStinson 10A · Port Alsworth, AKThe pilot's delayed decision to execute a go-around maneuver while landing with a tailwind into a short strip, which resulted in a runway overrun and subsequent loss of control.Sep 3, 2022 · N5847X · Substantial damageNTSB ANC22LA070Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot’s failure to maintain centerline in dusk light conditions which resulted in impact with trees.Sep 3, 2022 · N119CC · Substantial damageNTSB ERA22LA403Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Toughkenamon, PAThe airplane’s impact with a bird while entering the traffic pattern.Sep 2, 2022 · N78QB · Substantial damageNTSB WPR22LA330Accident · Minor injuriesClass 3 · LimitedFinal reportSikorsky S-61N · Shady Cove, ORA total loss of engine power due to the failure of the No. 2 engine’s stage 1 turbine blades as a result of an unreported hot start two days earlier.Sep 1, 2022 · N617CK · Substantial damageNTSB ERA22LA395Accident · 1 fatalClass 3 · LimitedFinal reportDiamond Aircraft Industries DA 42 · Orlando, FLThe flight crew’s insufficient evaluation of the deteriorating weather conditions in the area, which resulted in an encounter with a microburst.Sep 1, 2022 · N43RG · Substantial damageNTSB DCA22LA196Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-824 · Denver, COAn encounter with clear air turbulence, which resulted in a serious injury as a flight attendant was lowering her jumpseat.Sep 1, 2022 · N76529 · No damageNTSB DCA22LA191Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 717-200 · Detroit, MIAn encounter with moderate turbulence during descent.Aug 29, 2022 · N946AT · No damageNTSB ERA22FA387Accident · 2 fatalClass 3 · FieldFinal reportSea & Sky Krucker Cygnet · Emily, MNThe pilot’s operation of the weight-shift control aircraft over its design gross weight and his decision to take off with the engine operating at less than the specified takeoff rpm, which resulted in degraded takeoff and climb performance. Contributing to…Aug 28, 2022 · N505DB · Substantial damageNTSB WPR22LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 305C (0-1E) · Rexburg, IDThe pilot's failure to maintain airplane control during the landing roll on a wet airstrip.Aug 27, 2022 · N305SU · Substantial damageNTSB WPR22LA318Accident · No injuriesClass 4 · LimitedFinal reportLeon E Everett Carbon CUB EX · Maricopa, AZThe pilot's failure to maintain airplane control during landing with a crosswind and the use of excessive braking application, which resulted in a nose over.Aug 27, 2022 · N628LE · Substantial damageNTSB ERA22LA388Accident · Minor injuriesClass 4 · LimitedFinal reportSchleicher K7 · Mayville, NYThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in an off-airport landing.Aug 27, 2022 · N107AS · Substantial damageNTSB CEN22LA395Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Prue, OKThe pilot’s failure to maintain clearance from power lines during intentional low-level maneuvering.Aug 27, 2022 · N132JD · Substantial damageNTSB CEN22LA408Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Murray, NEThe pilot’s failure to maintain airplane control during landing resulting in an impact with crop and a subsequent ground-loop. Contributing was the wet turf airstrip.Aug 25, 2022 · N5951B · Substantial damageNTSB CEN22LA411Accident · No injuriesClass 4 · LimitedFinal reportCessna T210L · Atoka, OKThe pilot's failure to land the airplane within the desired touchdown zone, which resulted in a long landing and collision with a fence.Aug 24, 2022 · N2317G · Substantial damageNTSB ERA22FA383Accident · 2 fatalClass 3 · FieldFinal reportBell 206B · Whiteside, TNThe pilot’s failure to maintain clearance from the powerlines.Aug 23, 2022 · N770HP · Substantial damageNTSB WPR22LA325Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D1 · Hope, AKThe pilot’s failure to maintain clearance from a tree while taxiing.Aug 22, 2022 · N96095 · Substantial damageNTSB CEN22LA400Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · San Isidro, TXThe pilot’s improper decision to conduct an autorotation with a tailwind, which resulted in a hard landing and substantial damage.Aug 21, 2022 · N4447A · Substantial damageNTSB WPR22LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Donnelly, IDThe pilot’s improper decision to takeoff from a wet grass runway which did not allow for adequate braking traction when the pilot aborted the takeoff, which resulted in a runway excursion.Aug 20, 2022 · N735DU · Substantial damageNTSB WPR22LA328Accident · No injuriesClass 4 · LimitedFinal reportFall Martin Super CUB · Stanley, IDThe pilot’s failure to maintain airplane control during takeoff with a crosswind.Aug 19, 2022 · N25MF · Substantial damageNTSB DCA22LA188Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-824 · Pharisburg, OHThe airplane’s inadvertent encounter with convective turbulence.Aug 19, 2022 · N73270 · No damageNTSB CEN22LA387Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Millville, MNThe pilot’s inadequate inflight planning resulted in impact with a power line.Aug 16, 2022 · N641RZ · Substantial damageNTSB WPR22LA305Accident · No injuriesClass 4 · LimitedFinal reportHughes Helicopters 369E · Ely, NVThe pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude.Aug 15, 2022 · N500AR · Substantial damageNTSB ERA22LA371Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Talladega, ALA collision with a deer during takeoff.Aug 15, 2022 · N1486T · Substantial damageNTSB CEN22LA388Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28 · Lucedale, MSThe pilot’s failure to maintain directional control while landing on the wet turf runway with a higher speed.Aug 15, 2022 · N5341W · Substantial damageNTSB ERA22LA373Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Gardiner, NYThe pilot’s failure to go-around in a timely manner which resulted in a collision with a fence.Aug 14, 2022 · N33125 · Substantial damageNTSB ERA22LA369Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jamestown, NYA partial loss of engine power for reasons that could not be definitively determined.Aug 12, 2022 · N4751F · Substantial damageNTSB CEN22LA384Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Kearney, NEThe pilot’s inadequate in-flight planning that resulted in a loss of engine power due to fuel exhaustion.Aug 12, 2022 · N5253P · Substantial damageNTSB ERA22FA368Accident · 3 fatalClass 3 · FieldFinal reportPiper PA32 · Metz, WVThe non-instrument-rated pilot’s intentional visual flight into instrument meteorological conditions based on latent weather information, which resulted in the airplane entering extreme precipitation, a loss of aircraft control, and in-flight break-up.Aug 11, 2022 · N720RP · Substantial damageNTSB ANC22FA066Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · Arctic Village, AKThe pilot’s decision to depart in turbulent and gusting wind conditions, which resulted in a loss of control and impact with terrain.Aug 11, 2022 · N3937M · Substantial damageNTSB WPR22FA298Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Blyn, WAThe pilot’s continued operation of the airplane with known mechanical malfunctions with the flight displays, and his continued flight into instrument meteorological conditions, which resulted in an inflight collision with terrain while maneuvering.Aug 10, 2022 · N379DH · Substantial damageNTSB ERA22LA377Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Lehighton, PAThe pilot failure to ensure the runway was clear before landing, resulting in a runway excursion and collision with runway lights.Aug 10, 2022 · N7695W · Substantial damageNTSB CEN22LA389Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Appleton, MNThe pilot’s failure to maintain directional control during the takeoff roll with a quartering tailwind.Aug 10, 2022 · N73194 · Substantial damageNTSB CEN22LA385Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Sparta, MIThe pilot’s delayed decision to reject the takeoff, resulting in a runway excursion and impact with a fence.Aug 10, 2022 · N55338 · Substantial damageNTSB CEN22LA386Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802A · Onalaska, TXThe pilot’s failure to maintain directional control during takeoff from a lake in gusting wind conditions.Aug 9, 2022 · N830DA · Substantial damageNTSB CEN22LA382Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Kahului, HIThe pilot’s inadequate compensation for gusting winds while maneuvering on the ground.Aug 9, 2022 · N84352 · Substantial damageNTSB WPR22LA293Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Circle, MTThe loss of engine power due to carburetor ice. Contributing to the accident was the pilot’s failure to use carburetor heat.Aug 7, 2022 · N36542 · Substantial damageNTSB ERA22LA363Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150H · Ellenville, NYBoth pilots’ decision to perform the takeoff near maximum gross weight with 10° of flaps, contrary to the owner’s manual procedure, which resulted in the airplane’s degraded climb performance approaching high terrain.Aug 7, 2022 · N50439 · Substantial damageNTSB CEN22LA380Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · McCarthy, AKThe pilot’s failure to maintain control of the airplane during takeoff in turbulent weather conditions.Aug 7, 2022 · N171Q · Substantial damageNTSB CEN22LA370Accident · Serious injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Highland, ILThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.Aug 6, 2022 · N424BG · Substantial damageNTSB WPR22LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 182B · Yellow Pine, IDThe pilot's failure to maintain clearance from a tree while maneuvering.Aug 5, 2022 · N722BS · Substantial damageNTSB WPR22LA294Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-160 · White Salmon, WAThe pilot’s failure to attain a proper touchdown point, and his delayed decision to go around which, resulted in a collision with trees.Aug 5, 2022 · N7485R · Substantial damageNTSB CEN22LA366Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Maynard, IAAn impact with a powerline as a result of an unexpected wind gust.Aug 5, 2022 · N619RB · Substantial damageNTSB WPR22LA291Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350B3 · Chino, CAThe subsequent delamination of the main rotor blades as a result of an unidentified main rotor blade impact with vegetation during a previous flight by another pilot.Aug 4, 2022 · N833SB · Substantial damageNTSB ERA22LA356Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182C · Holly Ridge, NCThe pilot’s failure to maintain clearance of powerlines on final approach.Aug 4, 2022 · N8865T · Substantial damage