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 WPR24LA282Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Durham, CAThe pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike.NTSB WPR24LA271Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Manhattan, MTA total loss of engine power due to carburetor icing.NTSB WPR24LA277Accident · No injuriesClass 4 · LimitedFinal reportBeech N35 · Sequim, WAAn encounter with a downdraft, which resulted in a hard landing.NTSB ERA24LA343Accident · Minor injuriesClass 4 · LimitedFinal reportYakovlev YAK-55M · North Kingstown, RIThe non-certificated pilot’s lack of experience in the tailwheel-equipped airplane and his decision to land in a quartering tailwind, which resulted in a loss of directional control on landing.NTSB CEN24LA324Accident · No injuriesClass 4 · LimitedFinal reportRans RV8 · Morris, ILThe student pilot’s failure to maintain directional control and the flight instructors delayed remedial action while landing with a gusty crosswind.NTSB WPR24LA283Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Fallbrook, CAThe pilot’s failure to maintain clearance from an obstacle during taxi operations.NTSB WPR24LA274Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Minden, NVThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight and a subsequent collision with an obstacle during an off-field landing.NTSB CEN24LA313Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Dyess, ARThe improper overhaul of the carburetor and the malfunction of left magneto which resulted in a partial loss of engine power.NTSB WPR24FA270Accident · 3 fatalClass 3 · FieldFinal reportCessna 182K · Augusta, MTThe non-instrument-rated pilot’s decision to continue a visual flight rules flight into a rugged mountain area in deteriorating weather conditions, which resulted in impact with terrain.NTSB DCA24LA255Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Waycross, GAThe aircraft’s encounter with convectively induced turbulence.NTSB DCA24LA256Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Severn, MDA passenger’s failure to comply with crew member instructions to remain seated with seatbelt fastened.NTSB CEN24LA380Accident · Serious injuriesClass 3 · LimitedFinal reportXag P100 PRO · Francesville, INThe remote pilot’s in-flight loss of control of the unmanned aircraft due to GPS signal fluctuations, which resulted in a collision with, and serious injury to, a person assisting the operation.NTSB WPR24LA276Accident · No injuriesClass 4 · LimitedFinal reportMaule M4 · Scappoose, ORThe pilot’s loss of directional control after an encounter with a wind gust.NTSB DCA24LA254Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Linneus, MOAn inadvertent encounter with convectively induced turbulence during cruise.NTSB WPR24LA265Accident · Minor injuriesClass 3 · LimitedFinal reportBell 407 · Raft River, IDThe pilot’s misdiagnosis of an erroneous engine instrument indication and his subsequent decision to enter an autorotation, which resulted in a hard landing due to degraded visual cues and low ambient light conditions. Contributing to the accident were the…NTSB CEN24LA301Accident · Minor injuriesClass 3 · LimitedFinal reportTailwind W10 · West Livingston, TXA partial loss of engine power due to carburetor ice.NTSB WPR24LA264Accident · No injuriesClass 4 · LimitedFinal reportMooney M20F · Carrizozo, NMThe airplane’s encounter with a downdraft after takeoff, which resulted in a forced landing.NTSB ERA24LA344Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Cullman, ALThe pilot’s decision to depart in an area of developing convective weather, which resulted in an unanticipated wind shift during the initial climb after takeoff, a loss of climb performance, and the subsequent forced landing.NTSB CEN24LA299Accident · No injuriesClass 4 · LimitedFinal reportCessna 177A · Palmyra, WIThe student pilot’s failure to maintain directional control during the landing with gusty wind conditions.NTSB CEN24LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Castroville, TXThe pilot’s inadequate recovery from a bounced landing and his failure to maintain proper airplane pitch control and airspeed during the go-around, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall at a low…NTSB CEN24FA295Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Irene, SDThe pilot’s poor decision to continue the flight into deteriorating weather conditions and his failure to maintain a safe altitude, which resulted in controlled flight into trees and terrain.NTSB CEN24LA293Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Lincoln, NEThe pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB CEN24LA289Accident · No injuriesClass 3 · LimitedFinal reportEvektor Aerotechnik EV97 · Midland, TXThe pilot’s failure to maintain directional control during taxi due to strong wind gusts.NTSB ANC24LA071Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Huntsville, UTThe pilot's failure to navigate in hazy conditions, which resulted in a forced landing in a field and a collision with a pole.NTSB CEN24LA292Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Lewisville, TXThe pilot’s failure to maintain sufficient airspeed during a go-around, which resulted in an aerodynamic stall and impact with water. Contributing to the accident were crosswind gusts.NTSB ANC24LA070Accident · No injuriesClass 4 · LimitedFinal reportRoberts Jeff Super RV8 · Carter, WYThe pilots encounter with a shifting winds during takeoff, which resulted in a loss of control and runway excursion.NTSB WPR24FA257Accident · 7 fatalClass 3 · FieldFinal reportPilatus PC-12/47E · Recluse, WYThe pilot’s loss of control due to spatial disorientation while operating in instrument meteorological conditions, which resulted in an in-flight breakup. Contributing to the accident was the pilot’s distraction from the autopilot disconnecting due to an…NTSB WPR24FA255Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Izee, ORThe pilot’s controlled flight into terrain while maneuvering through an area of low visibility due to wildfire smoke and haze.NTSB WPR24LA273Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel Standard Libelle · Fields, ORThe glider’s encounter with a gusting wind and downdraft conditions, which resulted in exceedance of the glider’s critical angle of attack, an aerodynamic stall, and a hard landing.NTSB WPR24LA253Accident · No injuriesClass 4 · LimitedFinal reportCanadian Car & Foundry Harvard MK IV · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA24LA324Accident · No injuriesClass 4 · LimitedFinal reportLake LA4 · Catskill, NYThe pilot’s failure to maintain control of the airplane during a takeoff from water in gusting wind conditions.NTSB WPR24LA254Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-34-220T · Roy, UTThe flight instructor’s decision to shut down an engine on an extended leg of the airport traffic pattern, which led to a loss of performance and inability to maintain altitude.NTSB CEN24LA294Incident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Appleton, WIThe pilot’s failure to maintain adequate wingtip clearance while taxiing. Contributing to the accident was the ambiguous nonstandard parking at the time of the incident.NTSB CEN24LA285Accident · Serious injuriesClass 4 · LimitedFinal reportCessna A188B · Sumner, NEThe pilot’s failure to maintain clearance from a power line during the spray pass.NTSB WPR24LA260Accident · No injuriesClass 3 · LimitedFinal reportKitfox Series V · La Grande, ORSeparation of the propeller blades from progressive damage at the blade roots due to overtightening of the hub bolts.NTSB ERA24FA318Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Ronkonkoma, NYA loss of engine power during initial climb for undetermined reasons. Contributing to the outcome was the pilot's failure to maintain control of the airplane following the loss of engine power and his decision to perform an intersection takeoff which, reduced…NTSB CEN24LA276Accident · No injuriesClass 4 · LimitedFinal reportBell 206 · Cornland, ILThe pilot was unable to see a wire due to the setting sun and the helicopter subsequently struck the wire.NTSB CEN24LA275Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Cuba City, WIThe pilot’s failure to maintain clearance from a wire during an agricultural application pass.NTSB CEN24LA328Accident · No injuriesClass 3 · LimitedFinal reportHawker Beechcraft Hawker 900XP · Telluride, COThe flight crew’s failure to properly configure the airplane for takeoff in a high-density altitude environment, which resulted in a loss of control and a subsequent runway excursion. Contributing to the accident was the flight crew’s failure to use…NTSB ANC24LA069Accident · 3 fatalClass 3 · LimitedFinal reportBeech A35 · Gustavus, AKThe pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB ANC24LA068Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver U-6A · Pedro Bay, AKThe pilot’s failure to maintain directional control of the airplane during takeoff. Contributing to the accident was sun glare.NTSB ERA24LA314Accident · No injuriesClass 4 · LimitedFinal reportBell OH-58A · Hegins, PAThe pilot’s inadequate pre-flight and in-flight planning, which resulted in the helicopter striking a wire hazard during an aerial application flight.NTSB WPR24LA251Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Carlsbad, CAThe pilot’s failure to maintain lateral control of the helicopter while departing with a crosswind, which resulted in a dynamic rollover.NTSB ERA24LA320Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Port St. Lucie, FLThe pilot’s failure to correctly identify the airport runway, which resulted in a landing on a road and contact with a power line. Contributing to the outcome was the sun glare.NTSB ERA24LA315Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Zephyrhills, FLThe loss of engine power due to the formation of carburetor ice as a result of the pilot’s delayed application of carburetor heat.NTSB CEN24LA273Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Blaine, MNThe airplane’s collision with a deer on the runway during takeoff.NTSB WPR24LA246Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Grady, NMThe pilot’s failure to maintain directional control during takeoff with a quartering tailwind.NTSB ERA24LA317Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Montauk, NYThe pilot’s failure to maintain an appropriate glide path during the landing approach in terrain induced turbulence, resulting in a hard landing and subsequent runway excursion.NTSB CEN24LA265Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Le Roy, MIThe pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an inflight collision with trees.NTSB WPR24LA245Accident · Serious injuriesClass 4 · LimitedFinal reportKubicek Factory S R O BB26Z · Casper, WYThe pilot's inability to maintain control of the balloon after encountering high wind conditions and windshear during the landing, which resulted in the pilot’s ejection from the basket and serious injury.