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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ANC25LA082Accident · No injuriesClass 4 · LimitedFinal reportCessna U206F · Yakutat, AKThe pilot’s failure to maintain clearance during approach in gusting wind conditions to a remote airstrip, resulting in a collision with brush.NTSB WPR25LA235Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Kamiah, IDThe pilot’s loss of airplane control following an encounter with a microburst during takeoff.NTSB WPR25LA234Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · Cashmere, WAThe pilot’s failure to maintain clearance from obstacles during an aborted landing, while flying in tailwind conditions. Contributing to the accident was the high density altitude weather condition.NTSB CEN25LA283Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Hartsburg, ILThe pilot’s failure to maintain control of the airplane during takeoff with a tailwind from a wet turf airstrip.NTSB WPR25LA227Accident · Minor injuriesClass 4 · LimitedFinal reportHartline J Bon Hartline Kitfox III · Logan, UTThe pilot’s failure to maintain airplane control during takeoff in variable wind and high density altitude conditions.NTSB ERA25LA276Accident · No injuriesClass 4 · LimitedFinal reportHoward DGA-15P · Farmingdale, NYThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind.NTSB DCA25LA269Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer-Empresa Brasileira De ERJ 170-200 LR · Jacksonville, GAThe airplane’s encounter with unanticipated moderate turbulence.NTSB CEN25LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Faith, SDThe pilot's failure to maintain directional control during the landing roll with crosswind.NTSB DCA25LA267Accident · Minor injuriesClass 4 · LimitedFinal reportBoeing 787 · North Charleston, SCThe ground crews improper parking of N247BZ, which left its tail protruding into the taxiway, and the JA986A flight crew’s failure to maintain adequate clearance while taxiing.NTSB CEN25LA271Accident · No injuriesClass 4 · LimitedFinal reportPZL Swidnik PW-5 · Kerrick, TXThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB CEN25LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Lansing, MIThe pilot’s improper landing flare and subsequent failure to maintain directional control during the landing in a crosswind condition.NTSB DCA25LA272Accident · Serious injuriesClass 4 · LimitedFinal reportBombardier CL-600-2D24 · Germantown, KYAn inadvertent encounter with severe turbulence during descent.NTSB CEN25LA258Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH701 · Blaine, MNThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN25LA251Accident · Minor injuriesClass 4 · LimitedFinal reportScott Vincin Just Acft Highlander · Mancos, COThe airplane’s reduced climb performance during takeoff in mountainous terrain, which resulted in the airplane’s inability to climb and impact with terrain.NTSB WPR25LA206Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Page, AZThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB CEN25LA240Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CCK-1865 · La Garita, COThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude in mountainous terrain. Contributing was the pilot’s inadequate preflight planning and aeronautical decision making.NTSB CEN25LA238Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Joliet, ILThe pilot’s failure to maintain directional control during the crosswind landing.NTSB CEN25LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA12 · Brush, COThe pilot’s failure to maintain directional control while performing a touch and go landing.NTSB CEN25LA231Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Lockport, LAThe pilot’s inadequate planning for the high density altitude conditions which resulted in reduced airplane performance, climb capability, and subsequent forced landing.NTSB WPR25LA199Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Tukwila, WAThe pilot’s failure to maintain yaw control during a takeoff to a hover in a gusting crosswind, which resulted in a loss of directional control and a subsequent hard landing.NTSB WPR25LA194Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Helena, MTThe pilot’s failure to maintain directional control of the airplane during landing.NTSB CEN25LA228Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20M · Ben Bolt, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB ANC25LA064Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Palmer, AKThe pilot’s diverted attention during takeoff in flat light conditions, which resulted in a loss of visual reference with terrain.NTSB ANC25LA056Accident · No injuriesClass 4 · LimitedFinal reportCessna 172H · Manokotak, AKThe pilot’s decision to land on an unsuitable landing surface with a tailwind, which resulted in a nose over. Contributing was the pilot’s failure to recognize the wind direction, resulting in a tailwind landing.NTSB WPR25LA198Accident · No injuriesClass 4 · LimitedFinal reportRepublic RC-3 · Coolin, IDThe pilot’s failure to maintain control of the airplane and exceedance of the critical angle of attack during takeoff in windy conditions which resulted in a subsequent hard landing.NTSB ANC25LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Chenega, AKThe pilot’s failure to maintain directional control during landing in gusting and variable wind conditions.NTSB ERA25LA245Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Kelleys Island, OHThe pilot’s failure to maintain control of the airplane while taking off in gusting crosswind conditions.NTSB ERA25LA243Accident · No injuriesClass 4 · LimitedFinal reportCessna T188C · Mount Gilead, OHThe pilot’s failure to maintain adequate airspeed while in a turn during initial climb and the exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at a low altitude.NTSB CEN25LA222Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Sweetwater, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB ANC25LA058Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-8 · Alexander Creek, AKThe pilot’s failure to maintain airplane control during final approach. Contributing to the accident was the airplane’s encounter with a downdraft that led to a rapid loss of altitude.NTSB WPR25LA196Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-220C · Pendleton, ORThe pilot’s failure to maintain directional control during landing, in gusting crosswind conditions.NTSB DCA25LA240Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A321-211 · Miami, FLThe unexpected encounter with a rapidly developing convective cell during climb resulting in convectively induced turbulence on a dark moon-less evening.NTSB DCA25LA239Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320 · Nashville, TNThe airplane’s encounter with moderate convective turbulence during descent.NTSB WPR25LA185Accident · No injuriesClass 4 · LimitedFinal reportSilvaire Luscombe 8A · San Andreas, CAThe pilot’s loss of directional control during landing roll following an encounter with a dust devil.NTSB WPR25LA187Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Kayenta, AZThe pilots’ failure to maintain airplane control during takeoff in gusting crosswind conditions, which resulted in a runway excursion.NTSB WPR25LA186Accident · No injuriesClass 4 · LimitedFinal reportKohut Mark A Murphy SR 2500 · Challis, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB DCA25LA241Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8H4 · Barlow Bend, ALThe airplane’s encounter with unanticipated turbulence during descent, resulting in a serious injury to a flight attendant.NTSB DCA25LA238Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Fort Myers, FLThe airplane’s inadvertent encounter with convective turbulence during descent, which resulted in serious injuries to two flight attendants.NTSB WPR25LA172Accident · Minor injuriesClass 4 · LimitedFinal reportBoeing B75N1 · Spokane Valley, WAThe pilot’s failure to maintain directional control during a takeoff roll in quartering tailwind conditions.NTSB CEN25LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fort Morgan, COThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane during a gusty crosswind landing.NTSB DCA25LA234Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Ebro, FLThe airplane’s encounter with convective turbulence during climb while diverting to an alternate airport, resulting in a serious injury to a passenger who disregarded the flight crew’s illuminated seat belt sign and the cabin crew’s instruction to remain…NTSB ANC25LA051Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-12 · Fairbanks, AKThe pilot’s failure to maintain clearance from trees during a go-around with a tailwind.NTSB WPR25LA179Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · East Wenatchee, WAThe pilot’s failure to maintain directional control during the landing roll with a left crosswind.NTSB WPR25LA175Accident · No injuriesClass 3 · LimitedFinal reportCessna 182P · Hyampom, CAThe pilot’s failure to use carburetor heat, which resulted in a loss of engine power due to carburetor icing and a subsequent impact with terrain during a forced landing.NTSB WPR25LA177Accident · No injuriesClass 4 · LimitedFinal reportRolladen Schneider LS-7WL · Tonasket, WAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB ANC25LA047Accident · No injuriesClass 4 · LimitedFinal reportBrian Peck RV-14 · Camas, WAThe pilot’s failure to maintain directional control during landing roll which resulted in a runway excursion.NTSB ANC25LA049Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Flagstaff, AZThe pilot’s failure to maintain directional control during takeoff in variable and gusty wind, which resulted in a ground loop.NTSB CEN25LA200Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Gibson, ARThe pilot’s loss of control during takeoff due to an encounter with a sudden wind shift.NTSB ANC25LA071Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Willow, AKThe flight instructor’s delayed remedial action/lack of supervision. Contributing to the accident was the pilot receiving instructions failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a ground loop.NTSB WPR25LA168Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7BCM · Port Townsend, WAThe flight instructor’s delayed remedial action and inadequate compensation for shifting wind conditions which resulted in a veer off the runway and collision with a sign.