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 WPR23LA099Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Rich County, UTThe pilot’s inability to maintain altitude following an encounter with turbulence and adverse wind conditions.Jan 25, 2023 · N23FD · Substantial damageNTSB CEN23LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Eagle River, WIThe pilot’s decision to takeoff from an unsuitable surface which resulted in collision with an object.Jan 25, 2023 · N73034 · Substantial damageNTSB WPR23LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 195A · Calexico, CAThe pilot’s failure to maintain directional control during the landing roll in gusting wind.Jan 20, 2023 · N95U · Substantial damageNTSB CEN23LA090Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Hyannis, NEThe pilot’s failure to maintain clearance from a snowbank during landing, which resulted in a nose-over.Jan 20, 2023 · N717DJ · Substantial damageNTSB CEN23LA087Accident · No injuriesClass 3 · LimitedFinal reportWorld WA-3 · Shreveport, LAThe loss of engine power due to carburetor icing.Jan 20, 2023 · N71SN · Substantial damageNTSB ERA23LA116Accident · No injuriesClass 4 · LimitedFinal reportMesafox Kitfox · Orlando, FLAn inadvertent encounter with the jet blast of another airplane while taxiing, which resulted in substantial damage to the airplane’s left wing.Jan 19, 2023 · N915KF · Substantial damageNTSB CEN23LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Brush, COThe pilot’s failure to maintain directional control during the landing roll with strong gusty surface winds.Jan 17, 2023 · N41529 · Substantial damageNTSB CEN23FA084Accident · 4 fatalClass 3 · FieldFinal reportPiper PA46 · Yoakum, TXThe pilot’s spatial disorientation during a missed approach in instrument meteorological conditions, which led to an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.Jan 17, 2023 · N963MA · Substantial damageNTSB WPR23LA090Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-160 · Minidoka, IDThe pilot’s failure to maintain control during landing on a contaminated runway.Jan 16, 2023 · N30737 · Substantial damageNTSB CEN23LA083Accident · No injuriesClass 3 · LimitedFinal reportCheek Carroll Hatz/Cheek · Brashear, TXA partial loss of engine power due to the formation of carburetor ice, which resulted in the inability to maintain altitude and the subsequent hard forced landing.Jan 15, 2023 · N1957P · Substantial damageNTSB DCA23LA125Incident · No injuriesClass 1 · LimitedFinal reportBoeing 737-900ER · Queens, NYThe American Airlines flight 106 (AAL106) crew’s surface navigation error due to distractions caused by their performance of concurrent operational tasks during taxi, which resulted in a loss of situational awareness. Contributing to the incident was the air…Jan 14, 2023 · N914DU · 2 aircraft · No damageNTSB ANC23LA013Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BL-65 · Wasilla, AKThe pilot's failure to remove all water from the fuel tank, which resulted in fuel contamination and a subsequent partial loss of engine power.Jan 14, 2023 · N29886 · Substantial damageNTSB ERA23FA109Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Dawsonville, GAThe pilot’s decision to initiate a visual flight rules flight into night instrument meteorological conditions, resulting in a loss of control in-flight due to spatial disorientation. Contributing to the accident was the pilot’s lack of qualifications and…Jan 13, 2023 · N4254T · DestroyedNTSB WPR23LA089Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-C55 · Yelm, WAThe pilot’s failure to attain a proper touchdown point during landing with a tailwind which resulted in a runway over run. Contributing to the accident was a wet runway.Jan 12, 2023 · N225V · Substantial damageNTSB CEN23FA077Accident · 2 fatalClass 3 · FieldFinal reportCessna 150H · Auburn, NEThe flight instructor’s failure to maintain control after a loss of engine power due to carburetor icing while maneuvering for forced landing in dark night visual meteorological conditions.Jan 12, 2023 · N22859 · Substantial damageNTSB ERA23FA108Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-301 · Dayton, VAThe pilot’s controlled flight into terrain while descending over mountainous terrain at night.Jan 11, 2023 · N43156 · DestroyedNTSB CEN23LA086Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Fowlerton, TXThe pilot’s failure to maintain clearance with trees, which resulted in an uncontrollable spin due to tail rotor damage.Jan 10, 2023 · N811S · Substantial damageNTSB ERA23LA105Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Paris, KYThe pilot’s loss of control after encountering changing wind conditions during the initial climb, which resulted in descent and collision with terrain.Jan 5, 2023 · N6111W · Substantial damageNTSB WPR23FA083Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-34-220T · New Harmony, UTThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation.Jan 4, 2023 · N814WT · DestroyedNTSB CEN23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Yukon, OKThe pilot’s failure to maintain directional control during the landing roll.Jan 3, 2023 · N7769E · Substantial damageNTSB WPR23FA080Accident · 1 fatalClass 3 · FieldFinal reportEmbraer Executive EMB-505 · Provo, UTThe pilot’s failure to deice the airplane before takeoff in weather conditions conducive to ice accumulation, which resulted in an ice-contaminated wing and subsequent stall during takeoff.Jan 2, 2023 · N555NR · Substantial damageNTSB DCA23LA114Accident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2D24 · New York, NYITA Airways flight crew's incorrect evaluation of the clearance between their airplane and another airplane stopped on an adjoining taxiway.Jan 2, 2023 · N928XJ · 2 aircraft · Substantial damageNTSB ANC23LA011Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Kenai, AKThe pilot's failure to maintain directional control during landing in flat light conditions, resulting in the airplane to nose over.Jan 2, 2023 · N94X · Substantial damageNTSB WPR23LA082Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Watsonville, CAThe pilot’s failure to maintain clearance from powerlines during a go around.Jan 1, 2023 · N7181A · Substantial damageNTSB CEN23FA071Accident · 4 fatalClass 3 · FieldFinal reportBell 407 · Galliano, LAThe pilot’s failure to ensure the helicopter was clear of obstacles before takeoff from the helideck, which resulted in the helicopter’s right landing skid pivoting about a helideck perimeter light during takeoff and a dynamic rollover. Additionally, the…Dec 29, 2022 · N595RL · Substantial damageNTSB WPR23LA081Accident · No injuriesClass 4 · LimitedFinal reportEmbraer Executive EMB-505 · Hawthorne, CAA runway overrun due to the pilot’s failure to stop the airplane as a result of diminished braking action due to a water contaminated runway surface.Dec 28, 2022 · N16DF · Substantial damageNTSB ERA23LA095Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Hampton, NHThe pilot’s failure to maintain directional control of the airplane while landing in crosswind conditions, which resulted in a runway excursion.Dec 26, 2022 · N2895Z · Substantial damageNTSB ERA23LA094Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Franklin, VAThe pilot’s failure to maintain clearance from trees during the initial climb following an aborted precautionary landing. Contributing to the outcome were the inoperative runway lights, which reduced the likelihood that the pilot could successfully land the…Dec 26, 2022 · N177D · Substantial damageNTSB CEN23LA069Accident · No injuriesClass 4 · LimitedFinal reportCessna 150J · South St. Paul, MNThe student pilot’s failure to maintain directional control during the take-off roll with a snow and ice covered runway.Dec 26, 2022 · N51115 · Substantial damageNTSB DCA23LA107Accident · Serious injuriesClass 4 · LimitedFinal reportGulfstream Aerospace GIV-X (G450) · Miami, FLAn unanticipated encounter with convective induced turbulence from developing cumulus clouds below the flight path, which produced strong updrafts and downdrafts.Dec 24, 2022 · N456FX · No damageNTSB CEN23LA068Accident · No injuriesClass 3 · LimitedFinal reportGrumman American AA-5B · Reserve, LAThe partial loss of engine power due to carburetor icing and the flight instructor’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing.Dec 21, 2022 · N321GD · Substantial damageNTSB CEN23LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Pocahantas, IAThe pilot’s landing flare which resulted in a bounced landing and the nose landing gear collapsing. Contributing to the accident was the airplane's encounter with adverse weather conditions which led to structural icing that affected flight characteristics…Dec 20, 2022 · N2930J · Substantial damageNTSB WPR23LA070Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV6 · Afton, WYThe pilot’s failure to maintain control during landing on a contaminated runway.Dec 18, 2022 · N78HJ · Substantial damageNTSB DCA23LA096Accident · Serious injuriesClass 3 · LimitedFinal reportAirbus A330-243 · Kahului, HIThe flight crew’s decision to fly over an observed storm cell instead of deviating around it despite sufficient meteorological information indicating the potential for severe convective activity.Dec 18, 2022 · N393HA · Minor damageNTSB ANC23LA009Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 77 · Lihue, HIThe airplane’s exceedance of its critical angle of attack after encountering a downdraft during departure, which resulted in an aerodynamic stall and impact with terrain.Dec 15, 2022 · N991AB · Substantial damageNTSB ANC23FA008Accident · 3 fatalClass 3 · FieldFinal reportRaytheon C90A · Kaupo, HIGuardian Flight’s inadequate pilot training and performance tracking, which failed to identify and correct the pilot’s consistent lack of skill, and which resulted in the pilot’s inability to maintain his position inflight using secondary instruments to…Dec 15, 2022 · N13GZ · Substantial damageNTSB WPR23LA066Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters EC 130 T2 · Yuba City, CAAn in-flight collision with a bird while in cruise flight.Dec 13, 2022 · N415RX · Substantial damageNTSB WPR23LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA42 · Lewistown, MTThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the out of service visual glideslope indicator and snow obscuring the runway markings.Dec 13, 2022 · C-GZPU · Substantial damageNTSB WPR23LA068Accident · No injuriesClass 4 · LimitedFinal reportEurocopter EC120B · Rancho Cordova, CAThe pilot receiving instruction’s loss of helicopter control during landing with a crosswind, and the flight instructor’s delayed remedial action.Dec 11, 2022 · N255SD · Substantial damageNTSB ERA23LA084Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Gilgo-Oak Beach-Captree, NYThe flight instructor’s inadequate remedial action while supervising the student pilot’s practice autorotation in gusting wind conditions, which resulted in a dynamic rollover.Dec 11, 2022 · N14HT · Substantial damageNTSB WPR23LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Socorro, NMThe pilot’s improper landing flare, which resulted in a hard bounced landing and loss of control in gusting wind.Dec 10, 2022 · N422B · Substantial damageNTSB WPR23LA063Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · La Sal, UTThe pilot’s failure to maintain clearance from terrain during a toe-in landing to sloping terrain which resulted in a loss of helicopter control.Dec 8, 2022 · N458HW · Substantial damageNTSB DCA23LA093Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Newark, NJAn inadvertent encounter with clear air turbulence during descent.Dec 8, 2022 · N649UA · No damageNTSB ANC23LA017Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Wasilla, AKThe pilot's selection of an unsuitable landing site, which resulted in a nose over after the main landing gear wheels broke through deep snow on the snow-covered runway.Dec 8, 2022 · N3861P · Substantial damageNTSB CEN23LA063Accident · No injuriesClass 4 · LimitedFinal reportRockwell International S2R-G6 · Mission, TXThe pilot's failure to maintain clearance from an electrical box.Dec 6, 2022 · N4205X · Substantial damageNTSB CEN23FA059Accident · 1 fatalClass 3 · FieldFinal reportEngineering & Research Ercoupe 415-C · Corning, IAThe pilot’s failure to maintain clearance from obstructions during a go-around, which resulted in impact with powerlines, a tree, and the ground.Dec 5, 2022 · N99345 · DestroyedNTSB CEN23FA057Accident · 2 fatalClass 3 · FieldFinal reportCessna 210-5(205) · Cleburne, TXAn in-flight loss of control as a result of spatial disorientation in night instrument meteorological conditions.Dec 5, 2022 · N8149Z · DestroyedNTSB ERA23FA079Accident · 3 fatalClass 3 · FieldFinal reportPiper PA28 · Venice, FLThe pilot’s spatial disorientation during takeoff in dark night visual meteorological conditions, which resulted in his failure to maintain a positive rate of climb and a subsequent descent into the water.Dec 4, 2022 · N4676F · Substantial damageNTSB WPR23LA053Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · Morgan, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low attitude. Contributing to the accident was the pilot’s loss of visual reference due to snow and flat light conditions.Dec 3, 2022 · N60WY · Substantial damageNTSB DCA23LA090Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer ERJ170 · Taneytown, MDAn encounter with turbulence during descent.Dec 3, 2022 · N85356 · No damage