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 WPR22FA198Accident · 1 fatalClass 3 · FieldFinal reportBeech 77 · Hemet, CAThe student pilot’s failure to maintain clearance from a cinderblock wall while performing a go-around.Jun 7, 2022 · N18244 · Substantial damageNTSB WPR22LA200Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Wheatland, WYThe pilot’s improper landing flare which, resulted in a bounced landing and subsequent nose over.Jun 6, 2022 · N4067V · Substantial damageNTSB WPR22LA199Accident · Minor injuriesClass 4 · LimitedFinal reportBearhawk Bearhawk · Holbrook, AZThe pilot’s failure to maintain directional control during landing.Jun 6, 2022 · N22LD · Substantial damageNTSB CEN22LA235Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Nashville, ARThe pilot was not able to stop the airplane on a wet runway due to hydroplaning.Jun 6, 2022 · N787CD · Substantial damageNTSB WPR22LA205Accident · No injuriesClass 4 · LimitedFinal reportBell HH-1H · Reno, NVThe pilot’s loss of control following the inadvertent placement of his foot behind the anti-torque pedal.Jun 2, 2022 · N91JK · Substantial damageNTSB CEN22LA236Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Houston, TXThe pilot’s inability to compensate for a downdraft during the landing flare, which resulted in a hard, bounced landing, and subsequent loss of directional control.Jun 2, 2022 · N1396D · Substantial damageNTSB CEN22LA230Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Ennis, TXA partial loss of engine power for reasons that were undetermined.Jun 2, 2022 · N65497 · Substantial damageNTSB CEN22LA221Accident · Serious injuriesClass 3 · LimitedFinal reportCameron Balloons Z-90 · Burlington, WIThe pilot’s selection of an inappropriate landing location and his failure to avoid an oncoming freight train, which resulted in the train colliding with and dragging the balloon.Jun 2, 2022 · N65009 · Substantial damageNTSB CEN22LA228Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Allport, ARA partial loss of engine power due to fuel contamination from foreign object debris. Contributing to the accident was the operator’s failure to follow the manufacturer’s required airframe fuel filter inspection interval.Jun 1, 2022 · N5007R · Substantial damageNTSB WPR22LA191Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Carlsbad, CAThe pilot’s failure to maintain directional control of the airplane during takeoff.May 30, 2022 · N722PA · Substantial damageNTSB WPR22FA189Accident · 2 fatalClass 3 · FieldFinal reportAirborne Windsports PTY Edge XT-912-L · Granite Shoals, TXThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall while landing with a gusting wind.May 29, 2022 · N490F · Substantial damageNTSB ERA22LA249Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Melrose, TNA total loss of engine power due to carburetor icing.May 29, 2022 · N1294E · Substantial damageNTSB CEN22LA227Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28RT-201T · Morgan, TXA partial loss of engine power due to a corrosion-related fatigue crack of the No. 3 cylinder barrel.May 29, 2022 · N2148J · Substantial damageNTSB CEN22LA222Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172L · Canyon Lake, TXThe pilot’s failure to retract the flaps during a go-around, which resulted in decreased climb performance and a subsequent collision with trees and terrain.May 28, 2022 · N3842Q · Substantial damageNTSB CEN22FA215Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. G-164 · Whiskerville, ARThe pilot misjudged the approach during the emergency landing, likely due to the full chemical load, and impacted a ditch, resulting in substantial damage and postimpact fire. Contributing to the pilot’s injuries was the lack of a crash-resistant fuel system…May 28, 2022 · N178LB · DestroyedNTSB ANC22LA036Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Gulkana, AKThe pilot’s failure to maintain directional during the landing rollout in crosswind conditions, which resulted in a runway excursion and impact with terrain.May 28, 2022 · N5773M · Substantial damageNTSB CEN22LA226Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Weiner, ARThe pilot’s failure to maintain clearance from the telephone pole during a low-level aerial application pass.May 27, 2022 · N579LA · DestroyedNTSB ANC22LA037Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Willow, AKThe pilot’s selection of unsuitable terrain for landing which resulted in a nose over.May 27, 2022 · N1694M · Substantial damageNTSB DCA22LA125Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A320-232 · Springfield, MOThe flight’s encounter with clear air moderate turbulence.May 25, 2022 · N483UA · No damageNTSB WPR22LA185Accident · No injuriesClass 4 · LimitedFinal reportFrazier Robert L RV-6A · Prineville, ORThe pilot’s improper landing flare which resulted in a bounced landing and loss of directional control.May 23, 2022 · N811RF · Substantial damageNTSB ERA22LA238Accident · No injuriesClass 4 · LimitedFinal reportMX MXS · Bealeton, VAAn inflight collision with a bird while conducting low level aerobatics.May 22, 2022 · N104MX · Substantial damageNTSB CEN22FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Broomfield, COThe pilot’s failure to abort the takeoff due to degraded engine performance. Contributing to the accident was the reduced performance of the engine, the reason for which could not be determined.May 22, 2022 · N85CT · Substantial damageNTSB ERA22LA240Accident · Minor injuriesClass 4 · LimitedFinal reportNew Glasair Glastar · Beckley, WVThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions.May 21, 2022 · N171JV · Substantial damageNTSB ERA22FA233Accident · 1 fatalClass 3 · FieldFinal reportCessna 140 · Wayne, NEThe pilot’s exceedance of the airplane’s critical angle of attack on final approach while conducting traditional short takeoff and landing operations in gusting wind conditions, which resulted in an aerodynamic stall and spin from which the pilot could not…May 20, 2022 · N76075 · DestroyedNTSB CEN22LA206Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Beach City, TXThe pilot’s failure to maintain directional control in a gusting quartering tailwind that resulted in a loss of control and impact with trees.May 19, 2022 · N7451J · Substantial damageNTSB CEN22LA210Accident · No injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Angola, INThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard landing and the nose landing gear collapse.May 16, 2022 · N3530H · Substantial damageNTSB ERA22FA227Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS 2-33A · Blairstown, NJThe student pilot’s failure to maintain proper alignment with the landing area during the approach, which resulted in the left wing impacting a tree.May 15, 2022 · N17879 · Substantial damageNTSB WPR22LA179Accident · No injuriesClass 4 · LimitedFinal reportSparks Ralph A RV8 · Deming, NMThe pilot’s loss of airplane control during takeoff following an encounter with a gust of wind.May 14, 2022 · N669RS · Substantial damageNTSB WPR22LA178Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Estancia, NMThe pilot’s decision to land on an unsuitable surface which resulted in his loss of aircraft control.May 14, 2022 · N76190 · Substantial damageNTSB ERA22FA226Accident · 1 fatalClass 3 · FieldFinal reportCessna 172H · Miami, FLA total loss of engine power due to carburetor ice as a result of the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.May 14, 2022 · N8845Z · Substantial damageNTSB CEN22LA200Accident · Minor injuriesClass 4 · LimitedFinal reportThrush S2R-H80 · Aurora, MOThe pilot did not ensure clearance from a power line during a surveillance pass of a field to be sprayed.May 12, 2022 · N510KK · Substantial damageNTSB WPR22LA176Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Tucson, AZThe pilot’s failure to maintain directional control during landing.May 10, 2022 · N1272A · Substantial damageNTSB ERA22LA237Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA42 · Lehighton, PAThe flight instructor’s inadequate supervision of the flight and his failure to secure the right engine following an unsuccessful engine restart attempt, which resulted in the airplane’s inability to maintain altitude and a subsequent off-airport landing.May 9, 2022 · N988JA · Substantial damageNTSB WPR22FA173Accident · 2 fatalClass 3 · FieldFinal reportBlue Side UP Comp AIR 8 SS52 · Grasmere, IDThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.May 8, 2022 · N801DT · Substantial damageNTSB WPR22LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Portland, ORThe pilot’s failure to maintain directional control during landing on a wet surface with a tailwind, which resulted in a runway excursion.Apr 29, 2022 · N20640 · Substantial damageNTSB ERA22LA211Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 152 · Wadsworth, OHThe pilot’s failure to maintain directional control while attempting to land in a crosswind.Apr 28, 2022 · N46733 · Substantial damageNTSB ERA22LA252Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Daytona Beach, FLPilot’s failure to maintain clearance from a forklift while taxiing.Apr 26, 2022 · N32042 · Substantial damageNTSB ERA22LA209Accident · Minor injuriesClass 4 · LimitedFinal reportGarlick Helicopters OH-58A+ · Oakland, FLThe pilot’s decision to continue the low-altitude aerial application flight over water conditions that degraded his depth perception, which resulted in an inadvertent collision with the water.Apr 26, 2022 · N281SP · Substantial damageNTSB ERA22LA206Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206 · Lake Apopka, FLA collision with water following a loss of visual reference to the water surface due to sun glare.Apr 26, 2022 · N206BX · Substantial damageNTSB ERA22LA208Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24 · Honesdale, PAThe pilot’s failure to maintain clearance with the edge of the asphalt, which resulted in a runway excursion. Contributing to the accident was the pilot’s distraction due to a goose.Apr 25, 2022 · N6121P · Substantial damageNTSB ERA22LA204Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172A · Stockbridge, GAThe flight instructor’s delayed remedial action during an unstabilized approach, which resulted in an impact with powerlines and a subsequent loss of controlApr 25, 2022 · N7572T · Substantial damageNTSB ERA22LA202Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Fountain Inn, SCThe pilot’s failure to obtain the proper touchdown point during landing, which resulted in a runway overrun and collision with a fence.Apr 25, 2022 · N9583C · Substantial damageNTSB WPR22FA164Accident · 4 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 · Cedar City, UTThe pilot’s failure to maintain obstacle clearance, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s decision to operate the airplane above its maximum gross weight.Apr 24, 2022 · N321PF · DestroyedNTSB WPR22LA162Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Las Vegas, NVThe pilot’s failure to maintain sufficient clearance from the jet blast of a departing jet airplane.Apr 21, 2022 · N182HH · Substantial damageNTSB CEN22LA182Accident · No injuriesClass 4 · LimitedFinal reportPiper-Harris J3C-65 · Hartford, WIThe flight instructor lost control of the airplane while taxiing in gusty wind conditions.Apr 21, 2022 · N9721Y · Substantial damageNTSB CEN22LA181Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Manhattan, KSThe pilot’s failure to use carburetor heat during the approach and his unsuitable flight profile for an upsloping runway, which resulted in a partial loss of engine power and an impact with terrain during an attempted go-around.Apr 21, 2022 · N9263H · Substantial damageNTSB WPR22LA161Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172I · Blanding, UTThe pilot’s improper landing flare which, resulted in a bounced landing and loss of airplane control during an aborted landing in gusty wind conditions.Apr 20, 2022 · N46055 · Substantial damageNTSB WPR22LA153Accident · No injuriesClass 4 · LimitedFinal reportStoddard Hamilton Glasair Super II · Oxnard, CAThe pilot’s failure to maintain airplane control while on final approach, which resulted in a collision with a runway approach light.Apr 16, 2022 · N90YY · Substantial damageNTSB ERA22LA196Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Zebulon, NCThe flight instructor’s failure to maintain directional control with a quartering tailwind.Apr 16, 2022 · N7784S · Substantial damageNTSB ERA22LA191Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-260 · Grantsville, MDThe pilot’s decision to continue the flight into an area of moderate to heavy icing conditions, which resulted in a degradation of airplane performance and subsequent loss of control.Apr 16, 2022 · N3618W · Substantial damage