NTSB investigations

5,639 cases where NTSB found Conditions/weather/phenomena.

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\", '0303'))
  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 ERA25LA139Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Gainesville, GAThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane while landing in gusty crosswind conditions.Feb 23, 2025 · N2480D · Substantial damageNTSB ERA25LA127Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Mayo, MDA total loss of engine power at low altitude due to an accumulation of carburetor ice while in a cruise-power descent, which resulted in a forced landing.Feb 22, 2025 · N781FM · Substantial damageNTSB WPR25LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 180A · Waterville, WAThe pilot’s failure to maintain directional control during landing roll.Feb 20, 2025 · N7792A · Substantial damageNTSB ANC25LA020Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Kapolei, HIThe flight instructor’s failure to avoid wake turbulence from a heavy airplane departing from a parallel runway, which resulted in a loss of airplane control during initial climb after a touch-and-go landing.Feb 20, 2025 · N19867 · Substantial damageNTSB ERA25FA119Accident · 1 fatalClass 3 · FieldFinal reportCessna 208 · Pierson, FLThe non-instrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.Feb 14, 2025 · N40EA · Substantial damageNTSB DCA25LA126Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Hacienda Heights, CAThe airplane’s encounter with moderate turbulence during descent, which resulted in serious injury to a flight attendant.Feb 14, 2025 · N939WN · No damageNTSB WPR25LA092Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Shafter, CAA total loss of engine power due to carburetor ice. Contributing was the student pilot and flight instructors’ failure to utilize carburetor heat.Feb 9, 2025 · N8535N · Substantial damageNTSB ERA25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Rock Hill, SCThe student pilot’s failure to maintain control of the airplane during an aborded crosswind landing.Feb 9, 2025 · N84048 · Substantial damageNTSB WPR25LA107Accident · No injuriesClass 4 · LimitedFinal reportCessna T207A · Tusayan, AZAn encounter with wind gusts, which resulted in a loss of control and a collapse of the nose landing gear.Feb 7, 2025 · N9317M · Substantial damageNTSB ERA25LA111Accident · Serious injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · New Lexington, OHThe pilot’s flight into previously forecasted freezing rain, which resulted in ice accretion, reduced forward visibility, and a subsequent landing undershoot.Feb 5, 2025 · N406SR · Substantial damageNTSB DCA25LA117Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-832 · Seattle, WAThe Japan Airlines flight crew’s failure to maintain adequate clearance from the parked Delta Air Lines aircraft while taxiing in congested ramp conditions.Feb 5, 2025 · N3737C · 2 aircraft · Substantial damageNTSB DCA25MA108Accident · 67 fatalClass 1 · MajorFinal reportBombardier CL-600-2C10 · Washington, DCThe Federal Aviation Administration’s (FAA) placement of a helicopter route in close proximity to a runway approach path; their failure to regularly review and evaluate helicopter routes and available data, and their failure to act on recommendations to…Jan 30, 2025 · N709PS · 2 aircraft · DestroyedNTSB CEN25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Air Force Academy, COThe pilot’s failure to maintain airplane control during final approach after encountering an unexpected windshear.Jan 27, 2025 · N51387 · Substantial damageNTSB ERA25LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Smyrna, TNThe pilot’s failure to maintain an appropriate approach path, resulting in the airplane contacting a tree during a landing approach at night.Jan 17, 2025 · N21254 · Substantial damageNTSB CEN25LA086Incident · No injuriesClass 3 · LimitedFinal reportAmerican Champion 7ECA · Longview, TXThe failure of the lower hinge barrel due to fatigue cracking. Contributing to the failure of the lower hinge barrel was increased stress from end face contact likely associated with worn bushings or displaced needle bearings.Jan 16, 2025 · N798L · Substantial damageNTSB DCA25LA085Accident · No injuriesClass 4 · LimitedFinal reportBoeing 767 · San Bernardino, CAEncounter with windshear during landing which resulted in a tailstrike.Jan 10, 2025 · N324UP · Substantial damageNTSB CEN25LA073Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Buras, LAThe pilot’s failure to maintain control during a hover taxi with a quartering tailwind.Jan 8, 2025 · N430JM · Substantial damageNTSB ERA25LA090Accident · No injuriesClass 4 · LimitedFinal reportHinson Melvin J Velocity · Norfolk, VAA landing gear collapse during landing in gusty crosswind conditions.Jan 5, 2025 · N160MH · Substantial damageNTSB ANC25LA015Accident · No injuriesClass 4 · LimitedFinal reportGippsaero PTY GA8 · Nightmute, AKThe pilot’s loss of directional control while taxiing in gusting wind conditions.Jan 4, 2025 · N916RK · Substantial damageNTSB WPR25LA076Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Los Alamos, NMThe pilot’s failure to maintain airplane control while landing in gusty crosswind conditions.Dec 31, 2024 · N71074 · Substantial damageNTSB CEN25LA067Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Galveston, TXThe pilot’s failure to maintain terrain clearance during the takeoff from the helipad in high and gusting wind conditions, that resulted in the right skid extension embedding in the artificial turf, and a subsequent dynamic rollover sequence.Dec 31, 2024 · N441HQ · Substantial damageNTSB DCA25LA091Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Gulf of America (Gulf of Mexico)An encounter with an area of clear air turbulence during cruise, which resulted in a serious injury to a flight attendant.Dec 29, 2024 · N647UA · No damageNTSB CEN25LA074Accident · No injuriesClass 3 · LimitedFinal reportCessna 560 · Pagosa Springs, COThe pilot’s inadequate preflight planning and poor preflight inspection and decision-making, which led to a takeoff attempt above the airplane’s certified maximum takeoff weight with snow-contaminated wings, resulting in a rejected takeoff at an airspeed…Dec 27, 2024 · N753MB · Substantial damageNTSB ERA25LA085Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 15AC · Loganville, GAThe pilot’s failure to maintain clearance of trees during an attempted go-around in sun glare.Dec 25, 2024 · N6665K · Substantial damageNTSB ANC25LA011Accident · No injuriesClass 3 · LimitedFinal reportRaytheon C90A · Honolulu, HIA temporary reduction in the airplane’s braking effectiveness during engine start following an exterior wash, which resulted in its uncommanded forward movement and collision with a parked airplane. Contributing to the accident was the flight crew’s delayed…Dec 21, 2024 · N438CA · Substantial damageNTSB ERA25LA073Accident · No injuriesClass 4 · LimitedFinal reportCessna 560 · Atlanta, GAThe vehicle driver’s inadequate visual lookout while driving on a non-licensed vehicle roadway in restricted visibility conditions, which resulted in a collision with a taxiing airplane.Dec 11, 2024 · N981AG · Substantial damageNTSB WPR25LA057Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Glendale, AZThe pilot's failure to maintain directional control during the landing roll. .Dec 9, 2024 · N36249 · Substantial damageNTSB WPR25LA053Accident · No injuriesClass 3 · LimitedFinal reportGulfstream AM Corp Comm Div 690D · Spokane, WAA partial loss of engine(s) power due ice ingestion.Dec 2, 2024 · N29GA · Substantial damageNTSB CEN25LA053Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Boscobel, WIThe ice obstruction of the engine oil breather tube and alternate air outlet, which resulted in a failure of the crankcase oil seal and loss of engine oil. Contributing to the accident was the incorrect engine oil breather tube installed in the airplane by…Dec 2, 2024 · N41997 · Substantial damageNTSB ERA25LA060Accident · Minor injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2012 Traveller · Boston, MAThe tug crew’s inadequate visual lookout while towing an airplane at night and their failure to identify a stationary airplane within sufficient time/distance to stop.Nov 25, 2024 · N651CA · Substantial damageNTSB DCA25LA047Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Brasilia, BrazilThe airplane’s encounter with unanticipated turbulence during cruise flight, which resulted in serious injury to one passenger who was not seated.Nov 24, 2024 · N753AN · No damageNTSB CEN25FA047Accident · 2 fatalClass 3 · FieldFinal reportCessna 182T · Drake, COThe pilot’s failure to maintain airplane control while maneuvering in mountainous terrain. Contributing was mountain wave turbulence in the area.Nov 23, 2024 · N434CP · DestroyedNTSB ERA25LA059Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Lakeland, FLThe pilot’s failure to maintain yaw control during a tailwind approach, which resulted in a loss of tail rotor effectiveness, an uncommanded spin, and subsequent hard landing.Nov 21, 2024 · N422RH · Substantial damageNTSB WPR25LA044Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Show Low, AZThe pilot’s failure to maintain directional control during the takeoff.Nov 19, 2024 · N705AB · Substantial damageNTSB ERA25LA047Accident · No injuriesClass 3 · LimitedFinal reportBoeing A75N1(PT17) · Huntington, WVThe pilot’s failure to utilize carburetor heat while operating the engine at low power and in conditions conducive to the formation of carburetor ice, which resulted in a total loss of engine power due to carburetor icing.Nov 18, 2024 · N55464 · Substantial damageNTSB DCA25LA041Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757-231 · Cooper Hill, MOAn encounter with convective induced turbulence which resulted in a flight attendant serious injury.Nov 18, 2024 · N717TW · No damageNTSB WPR25LA041Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Palm Springs, CAThe pilot’s failure to maintain clearance from a commercial airliner which resulted in an encounter with wake turbulence and subsequent loss of control resulting in impact with terrain.Nov 17, 2024 · N828PS · Substantial damageNTSB WPR25LA040Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172I · Mayer, AZThe accumulation of carburetor ice, which resulted in a loss of engine power and a subsequent forced landing.Nov 17, 2024 · N8390L · Substantial damageNTSB WPR25LA038Accident · No injuriesClass 3 · LimitedFinal reportDehavilland DHC-6-300 · Boulder City, NVA loss of directional control during the landing roll in gusting crosswind conditions.Nov 15, 2024 · N241SA · Substantial damageNTSB DCA25LA044Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Tokyo, JapanAn encounter with turbulence while in cruise flight, resulting in serious injuries to two flight attendants.Nov 15, 2024 · N833AA · No damageNTSB WPR25LA043Accident · No injuriesClass 4 · LimitedFinal reportCharlie Guinn CCK-1865 · Lewiston, MTThe pilot’s failure to maintain directional control in a gusting tailwind, which resulted in an impact with a tree.Nov 14, 2024 · N247CC · Substantial damageNTSB WPR25LA037Accident · No injuriesClass 3 · LimitedFinal reportCessna 172I · Los Angeles, CAA partial loss of engine power due to carburetor ice accumulation.Nov 14, 2024 · N46028 · Substantial damageNTSB ERA25LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Palm Beach Gardens, FLThe pilot’s failure to maintain directional control of the airplane during landing in a gusting crosswind, which resulted in a hard landing and runway excursion.Nov 13, 2024 · N6294C · Substantial damageNTSB CEN25LA039Accident · No injuriesClass 4 · LimitedFinal reportAtkinson Jeffrey M RV-8 · Denton, TXThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Nov 13, 2024 · N228HM · Substantial damageNTSB WPR25LA033Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Lancaster, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Nov 8, 2024 · N1977C · Substantial damageNTSB WPR25LA032Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Prescott, AZThe flight instructor’s failure to maintain clearance from a fence during taxi. Contributing to the accident was the low light conditions and obstacles adjacent to the deice bay.Nov 7, 2024 · N679ER · Substantial damageNTSB DCA25LA023Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Kingston, JamaicaAn inadvertent encounter with convective turbulence while in enroute cruise flight.Nov 3, 2024 · N651UA · No damageNTSB ERA25FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna 150F · Wilder, TNThe student pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions at night, which resulted in controlled flight into terrain.Oct 31, 2024 · N8110S · DestroyedNTSB WPR25LA029Accident · Serious injuriesClass 3 · LimitedFinal reportDaher TBM700 · Pinedale, WYThe pilot’s failure to ensure that the airplane was free of snow contamination before takeoff and to follow the manufacturer’s anti-icing procedure during continued snowfall, which resulted in an aerodynamic stall and loss of control shortly after liftoff.…Oct 29, 2024 · N885CA · Substantial damageNTSB ERA25LA039Accident · No injuriesClass 4 · LimitedFinal reportCessna T240 · Fort Myers, FLThe pilot’s inadequate compensation for the prevailing wind conditions while landing, which resulted in a runway excursion and collision with a sign.Oct 26, 2024 · N94981 · Substantial damage