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 ERA25LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Livermore Falls, METhe pilot’s failure to maintain adequate airspeed during landing in gusting wind conditions, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA25LA312Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Fitchburg, MAThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.NTSB DCA25LA312Accident · Serious injuriesClass 4 · LimitedFinal reportMcdonnell Douglas MD 83 · Miami, FLAn encounter with convective turbulence during descent that resulted in a serious injury to a flight attendant.NTSB CEN25LA336Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Argusville, NDThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude.NTSB CEN25LA338Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fargo, NDThe pilot’s failure to maintain directional control during landing with a gusting crosswind. Contributing to the accident was the closure of the wind aligned runway 27.NTSB ANC25LA092Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B2 · Juneau, AKThe pilot’s failure to maintain adequate obstacle clearance during takeoff from uneven, snow-covered terrain in flat light conditions.NTSB CEN25LA331Accident · Minor injuriesClass 4 · LimitedFinal reportElmwood Christavia · South Saint Paul, MNThe pilot’s failure to maintain airplane control during the landing roll. Contributing to the accident was the pilot’s decision to land the airplane on a non-approved landing surface.NTSB ANC25LA097Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350B3e · Skwentna, AKThe pilot’s inadvertent entanglement of a lightweight Kevlar long line into the helicopters operating main rotor system, resulting in a severe imbalance and separation of the main rotor gearbox.NTSB WPR25LA258Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1 · Vacaville, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB ANC25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 180G · Delta Junction, AKThe pilot’s failure to maintain a rate of climb sufficient to clear obstacles during takeoff, resulting in a collision with tree-covered terrain.NTSB ANC25LA087Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Homer, AKThe failure of the left main landing gear mount due to extensive corrosion while landing in an area of rough terrain.NTSB CEN25LA325Accident · No injuriesClass 4 · LimitedFinal reportHelio H-391B · Monroe, MIThe pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB ANC25LA096Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Haines, AKThe pilot’s selection of an unsuitable landing area resulting in an on-ground collision with an obscured log and a main landing gear separation.NTSB ANC25LA090Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Willow, AKThe pilot’s loss of control after a rejected takeoff, which resulted in a noseover.NTSB CEN25LA316Accident · Serious injuriesClass 4 · LimitedFinal reportXag P100 PRO · Depew, IAThe pilot’s failure to maintain clearance from the unmanned aircraft system during takeoff.NTSB WPR25LA246Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E · Fobes Hill, WAThe pilot’s abrupt maneuver to avoid a powerline during an aerial application flight, which resulted in the helicopter’s impact with terrain.NTSB WPR25LA247Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Etna, WYThe pilot’s premature rotation at insufficient airspeed during takeoff to avoid an unexpected animal on the runway, which resulted in a loss of control and subsequent nose-over during the aborted takeoff. Contributing to the accident was the pilot’s excessive…NTSB CEN25LA314Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Goodland, KSThe pilot’s failure to maintain aircraft control during the landing and go-around with variable wind direction and speed.NTSB CEN25LA312Accident · Serious injuriesClass 4 · LimitedFinal reportTaylorcraft BC12 · Ozark, ARThe pilot’s failure to maintain clearance from a tree which resulted in the right wing impacting the tree and a subsequent collision with trees and terrain. Contributing to the accident was the pilot’s decision to operate the airplane at a low altitude over…NTSB ANC25LA085Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK 1 · Soldotna, AKThe pilot’s failure to maintain clearance from rising terrain while maneuvering at low altitude.NTSB ANC25LA106Accident · No injuriesClass 4 · LimitedFinal reportBrian Turner Northern Explorer · Delta Junction, AKThe pilot’s failure to maintain obstacle clearance during landing, which resulted in an impact with trees.NTSB WPR25LA238Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Warren, IDThe pilot’s failure to adequately compensate for a wind gust during the departure roll, which resulted in a loss of directional control and a runway excursion.NTSB ANC25LA083Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Chisana, AKThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude.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 WPR25LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Inhama, ORThe pilot’s failure to maintain clearance from trees while taxiing, which resulted in a wing strike.NTSB CEN25LA294Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Stanwood, MIThe collision with a deer during takeoff.NTSB WPR25LA226Accident · No injuriesClass 4 · LimitedFinal reportCessna 182L · Tucson Estates, AZThe pilot’s inability to stop the airplane on the runway during a rejected takeoff for undetermined reasons, which resulted in the airplane’s impact with a ditch.NTSB CEN25LA292Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · North Bend, NEThe pilot’s failure to maintain clearance from wires while maneuvering at a low altitude, and the ground crew failure to inform the pilot that the support truck had been moved.NTSB CEN25LA299Accident · No injuriesClass 4 · LimitedFinal reportPiper J5A · Grenada, MSThe flight instructor’s inadequate supervision of the flight and improper decision to continue with a takeoff after the airplane swerved off the runway. Contributing to the accident was the student pilot’s failure to maintain directional control of the…NTSB CEN25LA286Accident · Minor injuriesClass 4 · LimitedFinal reportWeatherly 620B · Rushmore, MNThe pilot’s failure to maintain clearance from a tree during low-level maneuvering.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 CEN25LA274Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Hastings, NEThe pilot’s failure to maintain clearance from powerlines while maneuvering at low altitude.NTSB DCA25LA269Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer-Empresa Brasileira De ERJ 170-200 LR · Jacksonville, GAThe airplane’s encounter with unanticipated moderate turbulence.NTSB WPR25LA216Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Concrete, WAThe pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike.NTSB CEN25LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Faith, SDThe pilot's failure to maintain directional control during the landing roll with crosswind.NTSB WPR25LA219Accident · Serious injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Hollister, CAThe departing pilot’s failure to see and avoid the landing airplane during the takeoff, which resulted in a mid-air collision.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 CEN25LA266Accident · Minor injuriesClass 4 · LimitedFinal reportBell B206-B · Bloomington, ILThe pilot’s failure to avoid power lines during an aerial application flight.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 CEN25LA267Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Wyoming, ILThe pilot’s failure to attain a positive climb rate due to airplane’s improper takeoff configuration.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 WPR25LA231Accident · No injuriesClass 4 · LimitedFinal reportGary Weaver CCK-1865 · Wahsatch, UTThe pilot’s inability to maintain directional control following a collision with a boulder during an off airport precautionary landing.NTSB ANC25LA075Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.