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.
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
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 CEN25LA193Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Columbus, MSThe pilot's inadequate preflight inspection and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.NTSB CEN25LA190Accident · Minor injuriesClass 4 · LimitedFinal reportNelson Special · Hope, ARThe pilot’s failure to maintain airplane control during the landing roll.NTSB WPR25LA162Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Monroe, WAThe student pilot’s failure to maintain airplane control during landing, and the flight instructor’s delayed remedial action, which resulted in impact with a ditch.NTSB CEN25LA188Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Vega, TXThe airplane’s inadvertent encounter with a localized low boundary layer, which caused a wind shift, and a gusting tailwind during final approach, that resulted in the pilot deciding to impact a wind cone and a subsequent impact with terrain. Contributing was…NTSB CEN25LA187Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Goudeau, LAThe pilot’s inadvertent encounter with soft terrain conditions during the landing which resulted in a loss of directional and a subsequent nose-over.NTSB ANC25LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18A 150 · Susitna, AKThe pilot’s encounter with shifting winds during landing, which resulted in a loss of airspeed and altitude, and subsequent contact with water.NTSB ERA25LA213Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Murfreesboro, TNThe pilot’s failure to maintain directional control of the airplane while attempting to take off in a gusty crosswind, which resulted in a runway excursion.NTSB ERA25LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Montgomery, ALThe pilot’s failure to maintain adequate clearance from a fence during taxi.NTSB ANC25LA057Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Trapper Creek, AKThe pilot’s improper flare while landing on glassy water, which resulted in a hard landing.NTSB WPR25LA160Accident · No injuriesClass 4 · LimitedFinal reportPilatus PC-12/47 · Henderson, NVThe pilot’s failure to maintain directional control while landing with a quartering tailwind.NTSB CEN25LA180Accident · No injuriesClass 4 · LimitedFinal reportExcalibur Excalibur · Mountain View Airport, MOAn in-flight collision with a bird while enroute.NTSB ANC25LA039Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D1 · Willow, AKThe pilot's inadvertent application of brakes during landing, which resulted in a nose over.NTSB ERA25LA203Accident · Serious injuriesClass 3 · LimitedFinal reportSeamax Aircraft Ltda Seamax M-22 · Dahlgren Center, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s decision to take off with a known…NTSB ERA25FA201Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32RT · Yulee, FLThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the opening of the nose baggage door and subsequent distraction of the pilot…NTSB ERA25LA206Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Tiffin, OHThe airplane’s collision with a deer on the runway during takeoff.NTSB WPR25LA151Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-3 · Port of Del Bonita, MTThe pilot’s loss of directional control while landing in gusting wind conditions.NTSB CEN25LA172Accident · No injuriesClass 4 · LimitedFinal reportGolden Circle Air T-Bird · Dallas Center, IAThe pilot’s failure to maintain adequate roll control of the light sport airplane while on final approach to the airstrip with a crosswind.NTSB WPR25LA149Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Mojave, CAThe pilot’s exceedance of the airplane’s critical angle of attack during climb out from an aborted landing.NTSB DCA25LA197Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · Centerville, TNAn encounter with hail during descent.NTSB WPR25FA145Accident · 2 fatalClass 3 · FieldFinal reportChampion 7ECA · Cottonwood, CAThe flight instructor’s delayed response to an improper landing approach and runway overshoot, which resulted in an impact with an airport perimeter fence and trees.NTSB ERA25LA189Accident · No injuriesClass 3 · LimitedFinal reportChampion 7GCBC · Weyers Cave, VAA total loss of engine power on approach due to carburetor ice.NTSB WPR25LA157Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fullerton, CAThe pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun and collision with terrain.NTSB ANC25LA036Accident · Minor injuriesClass 4 · LimitedFinal reportStinson 108 · North Pole, AKThe pilot's failure to maintain obstacle clearance which resulted in an in-flight collision with a tree. Contributing to the accident was his impairment from the effects of alcohol consumption.NTSB WPR25LA139Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Oakland, CAThe pilot’s failure to maintain airplane control during takeoff with a left quartering crosswind.NTSB DCA25LA190Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Tahlequah, OKThe airplane’s encounter with moderate turbulence during descent.NTSB WPR25LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Placerville, CAThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB WPR25LA138Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Hood River, ORThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB ERA25LA221Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Oxford, METhe flight instructor’s failure to maintain directional control during the landing roll in gusty crosswind conditions.NTSB ERA25LA178Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Bethlehem, PAThe student pilot’s failure to maintain control of the airplane while landing in gusting crosswind conditions.NTSB DCA25LA185Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Houston, TXSerious Injury to a flight attendant sustained during an evacuation.NTSB WPR25LA142Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · West Jordan, UTThe pilot's failure to maintain directional control during takeoff. Contributing to the accident was the pilot inadvertently using a runway that resulted in a tailwind condition and the flight instructors delayed remedial action.NTSB ANC25LA034Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182B · Girdwood, AKThe pilot's decision to land on an unsuitable landing surface, which resulted in a nose-over.NTSB WPR25LA125Accident · No injuriesClass 4 · LimitedFinal reportCessna 190 · Idaho Falls, IDThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB CEN25LA155Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver MX II · Brady, TXThe airplane’s encounter with a dust devil, which resulted in a loss of airplane control at a low altitude.NTSB WPR25LA132Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Oakland, CAThe pilot’s failure to maintain directional control during takeoff roll with a left crosswind.NTSB CEN25LA152Accident · No injuriesClass 4 · LimitedFinal reportCorben Junior ACE · Jeanerette, LAThe pilot’s failure to maintain airplane control during the landing roll.NTSB ANC25LA033Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Bethel, AKThe pilot's delayed decision to abort the takeoff when the airplane was not attaining sufficient airspeed for takeoff and subsequently departed the end of the lake and collided with terrain.NTSB CEN25LA153Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Wausau, WIThe pilot’s failure to maintain directional control while landing in shifting wind conditions.NTSB ERA25LA181Accident · Serious injuriesClass 4 · LimitedFinal reportSchleicher ASW-19 · Zephyrhills, FLThe pilot’s inadequate inflight planning and an encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in an off-airport landing and collision with a fence.NTSB ANC25LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Manley Hot Springs, AKThe student pilot’s failure to maintain directional control during the landing roll on a snow and ice-covered runway, which resulted in a runway excursion and subsequent nose over.NTSB ERA25LA192Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Fort Myers, FLThe pilot’s failure to maintain directional control of the airplane while landing in gusting crosswind conditions, which resulted in the left wing impacting the runway.NTSB ERA25LA191Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Chesterfield, VAThe pilot’s improper landing flare, which resulted in a hard landing and the collapse of the nose landing gear.NTSB DCA25LA173Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787 · Claveria, PhilippinesAn encounter with convective turbulence during cruise that was not detected in advance by cockpit weather radar or weather information services.NTSB WPR25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Madras, ORThe pilot’s loss of control during landing roll with gusty winds.NTSB WPR25LA119Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · San Carlos, CAThe pilot's failure to maintain directional control during landing roll with crosswind conditions.NTSB CEN25LA137Accident · No injuriesClass 4 · LimitedFinal reportJust Highlander · Rusk, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN25LA145Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra Mkii · Nacogdoches, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN25LA132Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12 · Russellville, ARThe failure of the U.S. Army helicopter pilots to yield the right-of-way to the landing airplane, which resulted in the airplane encountering wake turbulence emitted from the three departing U.S. Army helicopters, a subsequent loss of directional control, and…NTSB ERA25LA152Accident · No injuriesClass 4 · LimitedFinal reportMaule M7 · Birdsboro, PAThe pilot’s decision to land with a quartering tailwind in shifting wind conditions, which resulted in a loss of control and nose-over.NTSB CEN25LA134Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Denton, TXThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing. Contributing to the accident was the gusty crosswind and windshear during landing.