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 WPR24LA243Accident · No injuriesClass 3 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Cottonwood, AZThe pilot’s low-speed, high-power maneuvering in high density altitude and near maximum gross weight, which resulted in an uncommanded right yaw due to a loss of tail rotor effectiveness and a subsequent hard landing.NTSB WPR24LA241Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Herriman, UTA hard landing following a total loss of engine power due to fuel starvation as a result of the improper idle setting of the helicopter’s engine. Contributing to the loss of engine power was the instructor’s reduction of engine power past that recommended by…NTSB WPR24LA244Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Lakeport, CAA collision with a deer during takeoff.NTSB CEN24LA267Accident · No injuriesClass 4 · LimitedFinal reportCovington Edward L SHA-GLASAIR · Saint James, MNAn in-flight bird strike which resulted in an engine compartment fire that ultimately destroyed the airplane.NTSB CEN24LA262Accident · No injuriesClass 4 · LimitedFinal reportSkystar Kitfox · Hackney, KSThe pilot’s failure to maintain directional control during the landing roll in a gusting wind condition.NTSB ANC24LA065Accident · No injuriesClass 4 · LimitedFinal reportBeech 65-B80 · Woleai Atoll, MicronesiaThe pilot's selection of an unsuitable takeoff area, resulting in a loss of directional control. Contributing to the accident was a flooded runway.NTSB WPR24LA247Accident · Minor injuriesClass 4 · LimitedFinal reportBell 407 · Stanley, IDA sudden wind shift which resulted in a rapid descent and subsequent dynamic rollover and collision into water.NTSB ANC24LA066Accident · No injuriesClass 4 · LimitedFinal reportCurtiss Wright C-46R · Kenai, AKAn in-flight collision with birds during takeoff.NTSB ANC24FA063Accident · 3 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Kekaha, HIAn encounter with turbulence due to downdraft winds that resulted in mast bumping and an in-flight breakup.NTSB WPR24LA242Accident · No injuriesClass 4 · LimitedFinal reportCessna 182A · Teton Village, WYThe pilot’s failure to maintain control of the airplane during the landing roll.improper compensation for the prevailing wind conditions, resulting in impact of the left wing on the runway surface.NTSB ERA24LA306Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Cochran, GAThe airplane’s impact with a bird resulting in substantial damage to the right wing.NTSB ANC24LA062Accident · Minor injuriesClass 4 · LimitedFinal reportFoxair Kitfox S7 Supersport · Tok, AKThe pilot's failure to maintain directional control during takeoff with a crosswind.NTSB ERA24FA294Accident · 3 fatalClass 3 · FieldFinal reportCessna 182 · Rutherfordton, NCThe pilot’s failure to maintain clearance from clouds, resulting in controlled flight into terrain due to mountain obscuration.NTSB CEN24LA259Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Thorntown, INThe pilot’s failure to ensure that the load hose was disconnected from the helicopter before takeoff, which resulted in a loss of control after liftoff and a hard landing.NTSB CEN24LA257Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Sedgwick, ARThe pilot’s failure to maintain clearance from a power line during the spray pass.NTSB WPR24FA227Accident · 1 fatalClass 3 · FieldFinal reportFantasy Air Sro Allegro 2007 · Eureka, UTThe pilot’s failure to maintain airplane control during initial climb, which resulted in an in-flight upset and impact with terrain.NTSB WPR24FA226Accident · 2 fatalClass 3 · FieldFinal reportChampion 7GCBC · Eatonville, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid trees, which resulted in an aerodynamic stall.NTSB ERA24LA296Accident · Serious injuriesClass 4 · LimitedFinal reportMissoula Super Drifter · Lafayette, TNThe pilot's failure to maintain control of the airplane during a go-around in gusting wind conditions.NTSB WPR24LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Sunriver, ORThe pilot’s loss of control during landing roll with a gusty tailwind.NTSB ERA24LA313Accident · No injuriesClass 4 · LimitedFinal reportTrozzi Thomas Searey · Eustis, FLThe flight instructor's failure to properly configure the landing gear before performing a water landing.NTSB ERA24LA295Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Clearwater, FLAn in-flight collision with a bird while flying in the airport traffic pattern.NTSB CEN24LA254Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV8 · Atwater, MNThe pilot’s inability to stop the landing roll on a wet grass runway which resulted in a runway overrun.NTSB ERA24LA297Accident · 1 fatalClass 4 · LimitedFinal reportBuckeye Dream Machine · Bainbridge, GAThe non-certificated pilot’s failure to maintain adequate clearance from powerlines while maneuvering at low altitude. Contributing to the accident was the pilot’s impairment due to alcohol and methamphetamine use.NTSB CEN24LA255Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802 · Brad, TXThe pilot’s failure to maintain airplane control after encountering a large boat wake.NTSB CEN24LA252Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · New Florence, MOThe pilot’s failure to maintain proper altitude/clearance from a dead tree limb during an aerial application flight.NTSB ANC24LA060Accident · No injuriesClass 4 · LimitedFinal reportDe Havilland DHC2 · Susitna, AKThe pilot’s selection of an unsuitable takeoff area, resulting in the floats contacting the shallow river bottom during takeoff, and a subsequent loss of control.NTSB ERA24LA293Accident · No injuriesClass 4 · LimitedFinal reportCessna 525 · Richmond, VAThe pilot’s failure to maintain directional control of the airplane while landing in rain and gusting wind conditions.NTSB ERA24LA285Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210L · Albany, OHThe pilot's loss failure to maintain directional control of the airplane during a crosswind landing. Contributing was an unanticipated wind gust.NTSB ERA24LA284Accident · Serious injuriesClass 4 · LimitedFinal reportCorella Neil RV9A · Saluda, SCThe pilot’s failure to maintain an appropriate glide path during the landing approach in variable wind conditions, which resulted in collision with trees.NTSB ERA24FA283Accident · 5 fatalClass 3 · FieldFinal reportPiper PA46 · Trout Creek, NYThe pilot’s loss of airplane control in flight due to spatial disorientation during a climb to cruise altitude in instrument meteorological conditions and turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was…NTSB CEN24LA246Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402 · Helm, MSThe pilot’s failure to maintain control, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN24FA243Accident · 2 fatalClass 3 · FieldFinal reportWaco YKC · Selden, KSThe pilot's inadvertent visual flight into instrument meteorological conditions, which had not been forecast at the time of departure, and which resulted in a loss of control due to spatial disorientation.NTSB ERA24LA289Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Lewiston Woodville, NCThe obstruction of the engine’s cooling system by foreign object debris (residential-type insulation), which resulted in smoke, an elevated oil temperature, and a subsequent off-airport landing on unsuitable terrain.NTSB CEN24LA247Accident · No injuriesClass 4 · LimitedFinal reportAmerican Air Racing Lancair IVP · Midland, TXThe pilot’s failure to extend and verify landing gear extension which resulted in a wheels-up landing. Contributing was the increased workload due to several airplane issues that occurred during the descent in severe turbulence.NTSB WPR24LA220Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-200 · Cedar City, UTThe pilot’s failure to maintain directional control during the landing roll, with gusty tailwind.NTSB WPR24FA215Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Big Creek, IDThe pilot’s delayed decision to go around after descending below the recommended abort altitude with a slight tailwind and an over-gross-weight airplane, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s failure to…NTSB ERA24LA287Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350 · Sanford, FLThe helicopter pilot’s improper maneuvering at low altitude in gusty wind conditions, which resulted in the helicopter entering a vortex ring state, and hard landing during a subsequent autorotation.NTSB CEN24LA244Accident · Minor injuriesClass 4 · LimitedFinal reportDesert Fox 1 · Ellicott, COThe pilot's decision to takeoff with a quartering tailwind and high density altitude which resulted in a runway overrun. Contributing to the accident was the failure of the right main axle mount due to the poor weld.NTSB CEN24LA241Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Andover, MOThe pilot’s inability to maintain altitude and airspeed during cruise flight likely due to a decrease in engine performance associated with the unauthorized use of automobile fuel, which led to an inflight collision with a tree and hard landing.NTSB ANC24LA055Accident · No injuriesClass 4 · LimitedFinal reportGippsland GA-8 · Tuntutuliak, AKThe pilot's failure to maintain directional control during takeoff after an encounter with a gusting wind, which resulted in a wing strike.NTSB WPR24LA249Accident · No injuriesClass 4 · LimitedFinal reportSchempp-Hirth DISCUS-2B · Nephi, UTThe pilot’s failure to maintain airspeed during a wind encounter, which resulted in a hard landing.NTSB ERA24LA278Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Swans Island, METhe pilot’s delayed decision to abort the landing. Contributing was his decision to land downwind.NTSB WPR24LA216Accident · Serious injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASH 31 MI · Parowan, UTThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain?flight.NTSB ANC24LA059Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Anchorage, AKThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB ERA24LA273Accident · No injuriesClass 4 · LimitedFinal reportConstruzioni Aeronautiche Tecn P2004 Bravo · Laurens, SCAn in-flight collision with a bird while in cruise flight.NTSB WPR24LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Chamberlain Guard Station, IDThe pilot’s failure to maintain directional control during takeoff which resulted in a collision with a rodent hole and subsequent nose over.NTSB WPR24LA208Accident · Minor injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Yellow Pine, IDThe pilot’s failure to attain a proper touchdown point during landing and his subsequent excessive use of brakes.NTSB WPR24FA202Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Capitan, NMThe pilot’s decision to continue the visual flight rules flight through an apparent visual corridor that rapidly narrowed due to rising terrain and mountain obscuration, resulting in momentary instrument meteorological conditions and the pilot’s subsequent…NTSB CEN24LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Crete, NEThe airplane’s collision with a deer on the runway during a touch-and-go landing.NTSB WPR24LA207Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Scheelite, CAThe pilot’s inadvertent entry to a box canyon where the airplane could not outclimb the rising terrain.