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.

NTSB GAA19CA452Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502 · Welsh, LAThe pilot's failure to maintain clearance from a telephone pole during an agricultural application flight.Jul 24, 2019 · N1509E · Substantial damageNTSB ERA19FA234Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Americus, GAThe pilot’s decision to depart in dark instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot’s and pilot-rated passenger’s self-induced pressure to…Jul 24, 2019 · N921CD · DestroyedNTSB CEN19CA237Accident · No injuriesData collectionFinal reportNorth American AT 6F · Oshkosh, WIThe pilot's loss of directional control during landing with a quartering tailwind, which resulted in a runway excursion and subsequent substantial damage.Jul 24, 2019 · N7976A · Substantial damageNTSB GAA19CA448Accident · No injuriesData collectionFinal reportCessna 172 · Van Nuys, CAThe pilot's failure to maintain directional control during landing with a left quartering crosswind, which resulted in a runway excursion and impact with runway lighting.Jul 23, 2019 · N737DW · Substantial damageNTSB DCA19CA189Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 767 · San Juan, PRAn encounter with convective turbulence during cruise flight.Jul 22, 2019 · N663UA · No damageNTSB WPR19LA201Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · King City, CAA landing gear collapse following an undetermined loss of electrical power, which prevented the landing gear from fully extending.Jul 21, 2019 · N3268C · Substantial damageNTSB GAA19CA451Accident · No injuriesData collectionFinal reportCessna 402 · St. Louis, MOThe airplane’s collision with a bird during short final.Jul 21, 2019 · N300SN · Substantial damageNTSB GAA19CA446Accident · No injuriesData collectionFinal reportEvektor Aerotechnik Sportstar · Tracy, CAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent emergency landing and collision with a tree.Jul 21, 2019 · N409EV · Substantial damageNTSB CEN19LA232Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Fredericksburg, TXA total loss of engine power for undetermined reasons.Jul 21, 2019 · N48410 · Substantial damageNTSB CEN19LA229Accident · No injuriesClass 3 · LimitedFinal reportCessna 305A · Houston, MOA total loss of engine power during initial climb due to carburetor icing, which resulted in a forced landing and impact with trees and terrain.Jul 21, 2019 · N1831 · Substantial damageNTSB ANC19TA037Accident · Serious injuriesClass 4Final reportPiper PA19 · Skwentna, AKThe pilot’s loss of directional control during a go-around and his failure to assess the wind conditions appropriately before a landing attempt.Jul 21, 2019 · N6PF · Substantial damageNTSB WPR19CA197Accident · Minor injuriesData collectionFinal reportAvid Avid Magnum · Yellow Pine, IDThe pilot's improper decision to land on a rough, grass airstrip, which resulted in the nose landing gear collapsing and a subsequent nose-over.Jul 20, 2019 · N777DV · Substantial damageNTSB GAA19CA443Accident · No injuriesData collectionFinal reportValldejuli John A Aerocomp · Jefferson City, MOThe pilot's failure to maintain directional control during a touch-and-go landing in gusting crosswind conditions, which resulted in a runway excursion, impact with runway lights, and a nose-over.Jul 20, 2019 · N12ZT · Substantial damageNTSB CEN19CA227Accident · No injuriesData collectionFinal reportVans RV-8 · Oshkosh, WIThe pilot’s failure to maintain adequate spacing from the lead airplane while landing following revised landing instructions, which necessitated that the pilot conduct an improper landing flare and resulted in a hard landing.Jul 20, 2019 · N143MS · Substantial damageNTSB GAA19CA450Accident · No injuriesData collectionFinal reportRockwell 112A · Cove, ORThe pilot's delayed decision to abort the takeoff from a grass runway, which resulted in a runway overrun and subsequent impact with a pole.Jul 19, 2019 · N1330J · Substantial damageNTSB ANC19FA035Accident · 1 fatalClass 2 · FieldFinal reportDe Havilland Beaver DHC 2 · Seldovia, AKThe airplane's floats impact with an ocean wave or swell, which exceeded the design load specifications of the flying wire assemblies and resulted in a partial separation of the float assemblies.Jul 19, 2019 · N68083 · Substantial damageNTSB ANC19LA036Accident · Serious injuriesClass 3 · LimitedFinal reportStoddard Hamilton Glasair II · Chattanooga, TNThe pilot's failure to switch to the secondary electrical system after the primary electrical system failed for unknown reasons.Jul 17, 2019 · C-GAFT · Substantial damageNTSB GAA19CA425Accident · No injuriesData collectionFinal reportAeros Skyranger · Brownville, METhe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control while attempting a go-around, which resulted in a runway excursion and impact with trees.Jul 16, 2019 · N75561 · Substantial damageNTSB GAA19CA424Accident · No injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot's failure to maintain lateral control during landing in gusting wind conditions, which resulted in the left wing striking the ground.Jul 16, 2019 · N1079M · Substantial damageNTSB GAA19CA423Accident · No injuriesData collectionFinal reportCessna 182 · Salmon, IDThe pilot's delayed decision to abort the landing on a wet grass runway and the flight instructor's delayed remedial action. Contributing to the accident was the wet runway which degraded braking.Jul 16, 2019 · N4876N · Substantial damageNTSB ERA19LA229Accident · Serious injuriesClass 3 · LimitedFinal reportProgressive Aerodyne Searey · Crescent, FLThe pilot’s misjudgment of his altitude during landing and subsequent decrease in pitch attitude, which resulted in a collision with the water.Jul 16, 2019 · N632FG · Substantial damageNTSB ANC19LA034Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Ocean City, MDA partial loss of power due to the liberation or failure of the No. 2 cylinder's exhaust valve.Jul 16, 2019 · N9715B · Substantial damageNTSB GAA19CA421Accident · Minor injuriesData collectionFinal reportWillie Bennett Glastar · Lompoc, CAThe pilot's failure to maintain a proper glidepath during a night landing, which resulted in impact with a tree.Jul 15, 2019 · N345BP · Substantial damageNTSB GAA19CA447Accident · No injuriesData collectionFinal reportBiuro Projektowe B Bogumil Ber SZD-56-2 · Sparks, NVThe pilot’s failure to abort the takeoff in a timely manner, which resulted in glider settling into sage brush.Jul 14, 2019 · N821W · Substantial damageNTSB GAA19CA409Accident · No injuriesData collectionFinal reportDiamond DA 40 · Denver, COThe pilot receiving instruction's failure to maintain the runway heading and bank control during landing in crosswind conditions, which resulted in a go-around and subsequent collision with a runway light.Jul 13, 2019 · N388JP · Substantial damageNTSB ERA19LA226Accident · No injuriesClass 3 · LimitedFinal reportCessna 120 · Summit, SCA total loss of engine power during initial climb due to carburetor ice formation.Jul 13, 2019 · N3886V · Substantial damageNTSB GAA19CA467Accident · No injuriesData collectionFinal reportCessna 525 · Orlando, FLThe airplane’s impact with a bird during approach.Jul 12, 2019 · N262BK · Substantial damageNTSB GAA19CA401Accident · No injuriesData collectionFinal reportCessna 172 · Vineyard Haven, MAThe pilot's failure to maintain lateral position in relation to the instrument approach course at night in instrument meteorological conditions, which resulted in collision with a tree.Jul 11, 2019 · N677DM · Substantial damageNTSB ANC19FA033Accident · 1 fatalClass 3 · FieldFinal reportPiper PA 24-180 · Ketchikan, AKThe pilot’s decision to continue visual flight rules into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.Jul 11, 2019 · N5840P · Substantial damageNTSB GAA19CA430Accident · No injuriesData collectionFinal reportPiper PA28 · Wasilla, AKThe pilot's improper landing flare, which resulted in an aerodynamic stall and subsequent hard landing, runway excursion, and collision with a sign.Jul 10, 2019 · N4245J · Substantial damageNTSB GAA19CA404Accident · No injuriesData collectionFinal reportPiper PA28 · SaipanThe pilot's failure to maintain directional control while exiting the runway, which resulted in a runway excursion and collision with taxiway lighting and runway signage.Jul 10, 2019 · N6733F · Substantial damageNTSB GAA19CA438Accident · No injuriesData collectionFinal reportBeech 19 · Columbia Station, OHThe pilot's failure to see and avoid tall grass along the side of the runway during the takeoff roll, which resulted in his loss of directional control, a runway excursion, and nose-over.Jul 9, 2019 · N9161S · Substantial damageNTSB CEN19LA216Accident · Minor injuriesClass 3 · LimitedFinal reportRutan Varieze · Kaneville, ILThe pilot's failure to use carburetor heat while operating at low power settings in conditions conducive to the development of carburetor ice, and the subsequent total loss of engine power due to carburetor icing.Jul 8, 2019 · N112EZ · Substantial damageNTSB GAA19CA396Accident · No injuriesData collectionFinal reportDonald Bernard Higgs Pietenpol · Anacortes, WAThe failure of the left main landing gear attachment point during the landing roll for reasons that could not be determined because the attachment was not examined, which resulted in a loss of directional control, collision with a drainage culvert, and a…Jul 7, 2019 · N7169K · Substantial damageNTSB GAA19CA387Accident · No injuriesData collectionFinal reportPiper PA32 · Seldovia, AKThe pilot's failure to attain a sufficient climb following a short-field takeoff, which resulted in collision with trees.Jul 7, 2019 · N3556W · Substantial damageNTSB ERA19TA223Accident · No injuriesClass 3Final reportCessna 180 · Okeechobee, FLThe pilot’s failure to maintain directional while landing with a quartering tailwind, which resulted in a ground loop.Jul 7, 2019 · N52031 · Substantial damageNTSB GAA19CA389Accident · No injuriesData collectionFinal reportCessna 152 · Paris, TXThe student pilot's failure to maintain the runway heading during takeoff with a crosswind, which resulted in impact with a hay bale left of the runway, and his improper decision to perform a soft-field takeoff without adequate practice.Jul 6, 2019 · N757YK · Substantial damageNTSB CEN19FA212Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Oxford, MSThe student pilot's failure to maintain airplane control during a go around with a tailwind, which resulted in an uncontrolled descent and impact with terrain.Jul 6, 2019 · N994CP · DestroyedNTSB CEN19FA211Accident · 1 fatalClass 2 · FieldFinal reportGrob G103 · Brandon, MSThe pilot's inadequate clearance from a tree during an attempted off-field landing.Jul 6, 2019 · N106NS · Substantial damageNTSB GAA19CA388Accident · No injuriesData collectionFinal reportPiper PA18 · Talkeetna, AKThe pilot's improper decision to land on rough, grassy terrain, which resulted in a nose-over.Jul 5, 2019 · N5830C · Substantial damageNTSB GAA19CA431Accident · No injuriesData collectionFinal reportDiamond DA40 · Tavernier, FLThe pilot's delayed decision to go around in high-temperature and high-density altitude conditions and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jul 4, 2019 · N420NG · Substantial damageNTSB GAA19CA394Accident · No injuriesData collectionFinal reportMerit CCX-2000 · Casper, WYThe pilot's failure to maintain directional control during landing with a tailwind, which resulted in a ground loop.Jul 4, 2019 · N941DM · Substantial damageNTSB ERA19FA210Accident · 7 fatalClass 2 · FieldFinal reportAgusta AW139 · Big Grand Cay, BahamasThe pilots’ decision to takeoff over water in dark night conditions with no external visual reference, which resulted in spatial disorientation and subsequent collision with the water. Also causal was the pilots’ failure to adequately monitor their…Jul 4, 2019 · N32CC · Substantial damageNTSB GAA19CA407Accident · No injuriesData collectionFinal reportCessna 172 · Montville, METhe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during a low-altitude climbing turn, which resulted in an aerodynamic stall.Jul 3, 2019 · N1516E · Substantial damageNTSB GAA19CA390Accident · No injuriesData collectionFinal reportCessna 152 · Tracy, CAThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a vehicle.Jul 2, 2019 · N6306P · Substantial damageNTSB GAA19CA384Accident · No injuriesData collectionFinal reportAmerican AA5 · Cheyenne, WYThe pilot's failure to maintain a proper descent rate and landing flare during landing with a tailwind, which resulted in a hard landing and a subsequent loss of directional control, runway excursion, and collision with objects.Jul 2, 2019 · N387G · Substantial damageNTSB WPR19FA183Accident · 2 fatalClass 3 · FieldFinal reportSchempp Hirth Arcus · Ephraim, UTThe pilot's decision to maneuver in close proximity to terrain while attempting to remain in an area of lift, which resulted in a collision with trees.Jul 1, 2019 · N215MM · DestroyedNTSB GAA19CA381Accident · No injuriesData collectionFinal reportCessna 175 · Coeur d'Alene, IDThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control during landing with a gusting crosswind, which resulted in a ground-loop.Jul 1, 2019 · N9235B · Substantial damageNTSB WPR19LA184Accident · Minor injuriesClass 3 · LimitedFinal reportCessna TR182 · Lincoln, MTA loss of control during landing, which resulted in a nose landing gear collapse and runway excursion.Jun 30, 2019 · N5JB · Substantial damageNTSB WPR19LA180Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Chandler, AZThe pilot's failure to maintain directional control during landing in a gusting right quartering headwind, which resulted in a collapse of the left main landing gear.Jun 30, 2019 · N786N · Substantial damage