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 ANC22LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna 207A · Pilot Station, AKThe pilot’s failure to maintain directional control during takeoff in crosswind conditions which resulted in a loss of control and impact with terrain.Apr 16, 2022 · N73503 · Substantial damageNTSB WPR22LA180Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-400 · Benson, AZThe pilot’s failure to lower the landing gear on approach due to distraction.Apr 15, 2022 · N8493P · Substantial damageNTSB ERA22LA197Accident · No injuriesClass 4 · LimitedFinal reportCessna 182R · Tuskegee, ALThe pilot’s inadequate compensation for the gusty crosswind wind conditions which resulted in a hard landing and subsequent nose gear collapse.Apr 15, 2022 · N9388X · Substantial damageNTSB WPR22FA151Accident · 1 fatalClass 3 · FieldFinal reportCessna 208B · Heyburn, IDThe pilot’s failure to maintain altitude during an instrument approach, which resulted in a descent below the approach path and impact with a vent stack. Also causal was the failure of the processing plant to correctly paint the vent stacks, which had been…Apr 13, 2022 · N928JP · Substantial damageNTSB CEN22LA176Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Twin Lakes, COThe failure of the left turbocharger at FL230, which resulted in a rapid loss of manifold pressure and subsequent complete loss of engine power due to an overly rich fuel-air mixture setting. Contributing was the smoke in the cabin in IMC, which caused the…Apr 13, 2022 · N112TR · Substantial damageNTSB ANC22LA029Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Beluga, AKThe pilot’s excessive touchdown speed, which resulted in a long landing and impact with terrain.Apr 12, 2022 · N135ES · Substantial damageNTSB ERA22LA184Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Bald Head Island, NCThe pilot’s failure to maintain control during landing on a soft surface.Apr 10, 2022 · N4693S · Substantial damageNTSB WPR22FA148Accident · 1 fatalClass 3 · FieldFinal reportTaylorcraft BL-65 · Counselor, NMA loss of control while maneuvering at a high-density altitude in gusty wind conditions.Apr 9, 2022 · N24345 · Substantial damageNTSB WPR22LA150Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASK 21 · Valyermo, CAThe gliders encounter with atmospheric conditions where the lift was not sufficient to maintain flight and subsequent impact with mountainous terrain.Apr 8, 2022 · N212NM · Substantial damageNTSB CEN22LA173Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Tomball, TXThe pilot did not maintain directional control during landing, which led to a runway excursion and nose-over of the airplane.Apr 8, 2022 · N1141U · Substantial damageNTSB CEN22LA171Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Peyton, COThe pilot’s decision to not activate the runway lighting and misjudged the runway location, which resulted in a collision with a windsock.Apr 8, 2022 · N248G · Substantial damageNTSB ERA22LA185Accident · No injuriesClass 4 · LimitedFinal reportPF Cub Flyers CCK-2000 · Collegedale, TNThe pilot's failure to maintain directional control of the airplane during landing, which resulted in a runway excursion and a subsequent nose-over.Apr 7, 2022 · N311PF · Substantial damageNTSB ERA22LA182Accident · Minor injuriesClass 3 · LimitedFinal reportAmerican AA-1 · Kennesaw, GAA loss of engine power due to the formation of carburetor ice.Apr 7, 2022 · N623W · Substantial damageNTSB ANC22LA045Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Aleknagik, AKThe pilot’s selection of unsuitable terrain for taxi which resulted in an impact with trees.Apr 7, 2022 · N6847B · Substantial damageNTSB ERA22LA210Accident · No injuriesClass 4 · LimitedFinal reportHenderson Clifford S Super Bear CSH-1 · Indiana, PAThe pilot's loss of directional control while landing, which resulted in a ground loop.Apr 5, 2022 · N371M · Substantial damageNTSB ERA22LA179Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20M · Manville, NJThe pilot’s delayed go-around decision following an encounter with a tailwind during landing, which resulted in an inability to climb and subsequent impact with trees.Apr 4, 2022 · N41XL · Substantial damageNTSB CEN22LA170Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Houston, TXThe student pilot’s failure to maintain direction control during takeoff in gusty wind conditions.Apr 3, 2022 · N857CP · Substantial damageNTSB CEN22LA165Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Calhan, COThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.Apr 3, 2022 · N9119W · Substantial damageNTSB WPR22LA143Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Van Nuys, CAThe student pilot’s failure to maintain sufficient distance behind a jet airplane which, resulted in his loss of airplane control due to the jet airplane’s jet blast and the flight instructor’s delayed remedial action.Apr 2, 2022 · N3901L · 2 aircraft · Substantial damageNTSB ERA22LA180Accident · Minor injuriesClass 4 · LimitedFinal reportHughes 269A · Fort White, FLThe non-instrument-rated pilot’s decision to fly a visual flight rules only helicopter in instrument meteorological conditions, which resulted in a collision with trees and terrain.Apr 2, 2022 · N7057L · Substantial damageNTSB ERA22LA176Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177RG · Gaithersburg, MDThe pilot’s failure to maintain adequate airspeed while maneuvering on final approach which resulted in a high sink rate and subsequent collision with a fence.Apr 2, 2022 · N123LS · Substantial damageNTSB ERA22LA175Accident · Minor injuriesClass 3 · LimitedFinal reportLearjet 45 · Morristown, NJThe captain’s inadequate compensation for crosswind conditions, which resulted in a loss of directional control.Apr 2, 2022 · N877W · Substantial damageNTSB WPR22LA140Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Merced, CAThe pilot’s failure to see and avoid wires while conducting an aerial application flight, which resulted in a wire strike and ground impact.Apr 1, 2022 · N9287U · Substantial damageNTSB WPR22LA139Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Swan Valley, IDThe pilot’s failure to maintain airplane control during the landing roll on a snow-covered runway surface.Mar 30, 2022 · N35AH · Substantial damageNTSB CEN22LA160Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Lampasas, TXThe pilot’s decision to perform a takeoff from a perpendicular taxiway rather than the airport runway, which led to the airplane striking trees at the end of the departure path.Mar 30, 2022 · N4738B · Substantial damageNTSB ERA22LA178Accident · No injuriesClass 4 · LimitedFinal reportExtra 300 · Rome, GAAn inflight collision with a bird while conducting low level aerobatics.Mar 29, 2022 · N808YF · Substantial damageNTSB CEN22LA166Accident · Serious injuriesClass 4 · LimitedFinal reportBeech B200 · Odessa, TXThe airplane’s encounter with severe clear air turbulence that was not forecasted, which resulted in a serious injury to an unrestrained passenger.Mar 29, 2022 · N469SL · No damageNTSB CEN22LA159Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RXS-8 · Yutan, NEThe pilot’s improper brace during landing which resulted in a serious injury during the landing sequence.Mar 28, 2022 · N9106Q · Minor damageNTSB WPR22LA131Accident · Minor injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Spanish Fork, UTThe pilot’s failure to maintain directional control during landing with gusting wind.Mar 26, 2022 · N976PA · Substantial damageNTSB CEN22LA154Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Wade, OKThe student pilot’s failure to maintain clearance from power lines during takeoff.Mar 25, 2022 · N6714F · Substantial damageNTSB ANC22LA027Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Chitina, AKThe pilot’s exceedance of the wing’s critical angle of attack, which resulted in a stall and impact with terrain.Mar 25, 2022 · N7074K · Substantial damageNTSB WPR22LA135Accident · No injuriesClass 4 · LimitedFinal reportAirplane Factory Sling LSA · Torrance, CAThe flight instructor’s loss of airplane control during an aborted landing due to a wind shift, which resulted in an impact with a runway sign.Mar 23, 2022 · N863SL · Substantial damageNTSB CEN22LA150Accident · No injuriesClass 4 · LimitedFinal reportSparrow Hawk III · Lubbock, TXThe pilot’s failure to maintain control of the gyrocopter during takeoff with strong gusty winds.Mar 23, 2022 · N430HS · Substantial damageNTSB WPR22LA132Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Howe, IDThe pilot’s failure to maintain adequate rotor rpm while descending with a gusting tailwind condition, which resulted in a loss of helicopter control.Mar 22, 2022 · N44DQ · Substantial damageNTSB CEN22LA155Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Plains, TXThe pilot’s failure to maintain control of the airplane during taxi with a strong crosswind.Mar 22, 2022 · N7199G · Substantial damageNTSB ANC22LA025Accident · 2 fatalClass 3 · LimitedFinal reportCessna 172P · Kekaha, HIThe pilot’s improper decision to continue the visual-flight-rules flight into low visibility conditions, which resulted in controlled flight into terrain.Mar 21, 2022 · N98763 · DestroyedNTSB WPR22LA125Accident · Serious injuriesClass 4 · LimitedFinal reportEurocopter AS332L1 · Azusa, CAThe pilot's failure to maintain clearance from a tree after encountering brownout conditions and a loss of visual reference during the approach to land.Mar 20, 2022 · N950SG · Substantial damageNTSB WPR22LA144Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Alpine, CAThe pilot’s failure to maintain clearance from rising terrain while operating in a canyon, which resulted in an impact with terrainMar 19, 2022 · N42764 · Substantial damageNTSB WPR22LA130Accident · No injuriesClass 4 · LimitedFinal reportParadise Aircraft USA P1 · Glendale, AZA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate preflight fuel inspection.Mar 19, 2022 · N101YY · Substantial damageNTSB ERA22LA165Accident · Minor injuriesClass 4 · LimitedFinal reportNordquist Richard A Vans RV7 · Polk City, FLA loss of control during landing due to the loose and uneven landing surface.Mar 17, 2022 · N275PL · Substantial damageNTSB CEN22FA145Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-30 · Pond Creek, OKThe pilot’s loss of control of the airplane, resulting in an in-flight breakup.Mar 17, 2022 · N8357Y · DestroyedNTSB ERA22LA157Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Harveysburg, OHA complete loss of engine power as a result of carburetor ice due to the flight instructor’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.Mar 16, 2022 · N9588E · Substantial damageNTSB ANC22LA023Accident · Minor injuriesClass 4 · LimitedFinal reportEurocopter AS 350 BA · Valdez, AKThe pilot's failure to maintain a proper approach path in flat light conditions, which resulted in landing short of the intended landing spot and impact with terrain.Mar 15, 2022 · N99676 · Substantial damageNTSB WPR22LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna T210L · Lancaster, CAA total loss of engine power due to the pilot’s inadequate fuel management which resulted in fuel starvation and subsequent collision with a fence during landing.Mar 14, 2022 · N94001 · Substantial damageNTSB CEN22LA141Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150M · Brodhead, WIA loss of engine power due to the fatigue fracture of the No. 1 cylinder’s rocker shaft bosses, which resulted in a forced landing into uneven terrain.Mar 13, 2022 · N63246 · Substantial damageNTSB ERA22FA153Incident · 1 fatalClass 2 · FieldFinal reportAmerican AA-1 · Bay Minette, ALThe pilot’s loss of control during taxi, which resulted in a taxiway overrun and subsequent impact with terrain. Contributing to the incident were the low visibility conditions that existed at the airport around the time of the incident.Mar 11, 2022 · N5774L · Substantial damageNTSB CEN22LA143Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Taylorville, ILThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.Mar 11, 2022 · N755ZR · Substantial damageNTSB ERA22LA150Accident · No injuriesClass 3 · LimitedFinal reportHonda Jet HA-420 · Pittsburgh, PAThe flight crew's continuation of an unstable approach, which resulted in a long landing on a contaminated runway. Contributing to the outcome was the captain’s full application of the emergency brake, which resulted in hydroplaning and a runway excursion.Mar 9, 2022 · N903JT · Substantial damageNTSB ERA22FA149Accident · 2 fatalClass 3 · FieldFinal reportCessna 182Q · Panama City, FLThe pilot’s deviation from the final approach course during a night instrument approach with low instrument meterological conditions, which resulted in an impact with heavily wooded terrain. Contributing to the accident was the pilot’s decision to continue…Mar 9, 2022 · N182XT · DestroyedNTSB WPR22LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Nampa, IDThe pilot’s failure to maintain directional control during landing with a crosswind.Mar 7, 2022 · N968SW · Substantial damage