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 WPR19FA182Accident · 2 fatalClass 3 · FieldFinal reportCub Crafters CCK-1865 · Moab, UTThe pilots failure to maintain clearance from terrain while maneuvering at a low altitude in mountainous terrain.Jun 30, 2019 · N66DN · Substantial damageNTSB CEN19FA191Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C · Elyria, OHA loss of engine power due to carburetor icing, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.Jun 30, 2019 · N98527 · Substantial damageNTSB GAA19CA477Accident · No injuriesData collectionFinal reportCessna 172 · Greer, SCThe pilot's improper decision to continue a steep and fast approach to landing, which resulted in a runway overrun and collision with a drainage culvert.Jun 29, 2019 · N724BC · Substantial damageNTSB GAA19CA400Accident · Minor injuriesData collectionFinal reportBeech 95 · Navasota, TXThe airplane’s impact with a bird.Jun 29, 2019 · N998DM · Substantial damageNTSB GAA19CA382Accident · No injuriesData collectionFinal reportPiper PA24 · Brunswick, GAThe pilot's failure to properly lean the fuel mixture in flight, which resulted in fuel exhaustion, a subsequent total loss of engine power, and a forced landing with the landing gear retracted.Jun 29, 2019 · N8294P · Substantial damageNTSB ERA19TA204Accident · Serious injuriesClass 3Final reportRobinson R44 · Parsons, WVThe pilot's decision to maneuver the helicopter at low altitude over a river, which resulted in a wire strike and subsequent collision with terrain.Jun 29, 2019 · N883TY · Substantial damageNTSB CEN19LA193Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Garwood, TXThe pilots' failure to maintain clearance from a power line during low level operations.Jun 29, 2019 · N7143Y · Substantial damageNTSB GAA19CA429Accident · Minor injuriesData collectionFinal reportFlightstar Sportplanes Flightstar II · Coward, SCThe noncertificated pilot's exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall.Jun 28, 2019 · UNREG · Substantial damageNTSB GAA19CA378Accident · No injuriesData collectionFinal reportCessna 180 · Wasilla, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the left wing striking bushes. Contributing to the accident was the pilot’s distorted visual perception due to his flying with one seat cushion rather than the two…Jun 28, 2019 · N9939V · Substantial damageNTSB GAA19CA375Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe student pilot's improper landing flare and failure to maintain the runway heading, which resulted in the loss of airplane control, and the flight instructor's delayed remedial action during a go-around with a crosswind, which resulted in a bounced landing…Jun 28, 2019 · N606JA · Substantial damageNTSB ERA19LA217Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 77 · Leesburg, FLA partial loss of engine power due to carburetor icing, which resulted from the flight instructor's decision not to use carburetor heat.Jun 28, 2019 · N1802Y · Substantial damageNTSB CEN19FA185Accident · 2 fatalClass 2 · FieldFinal reportAgusta A109 · Brainerd, MNThe pilot's spatial disorientation during an instrument approach in dark night instrument meteorological conditions, which resulted in a loss of control and subsequent impact with terrain.Jun 28, 2019 · N11NM · Substantial damageNTSB GAA19CA395Accident · No injuriesData collectionFinal reportMaule M5 · Gillette, WYThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.Jun 27, 2019 · N6127M · Substantial damageNTSB GAA19CA377Accident · No injuriesData collectionFinal reportCessna 177 · Pleasanton, KSThe pilot's loss of yaw control during takeoff with a right quartering headwind in gusting wind conditions, which resulted in a collision with trees.Jun 27, 2019 · N30257 · Substantial damageNTSB CEN19LA188Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 560 · Janesville, WIThe passenger’s decision to unbuckle her restraints during an in-flight turbulence event, resulting in serious injury.Jun 27, 2019 · N318RW · Minor damageNTSB ANC19LA028Accident · No injuriesClass 3 · LimitedFinal reportDe Havilland DHC-2 · Ketchikan, AKA loss of directional control while landing, which resulted in a water loop.Jun 27, 2019 · N94DC · Substantial damageNTSB GAA19CA435Accident · No injuriesData collectionFinal reportPiper PA34 · State College, PAThe pilot's improper landing flare in gusting wind conditions, which resulted in a bounced landing and landing gear collapse.Jun 26, 2019 · N497SA · Substantial damageNTSB CEN19TA196Accident · No injuriesFinal reportAeronca 65 C · Gilliam, LAThe pilot's failure to see and avoid a dark-colored utility pole while taxiing for takeoff.Jun 26, 2019 · N22173 · Substantial damageNTSB GAA19CA383Accident · No injuriesData collectionFinal reportPiper PA28 · Milton, FLThe flight instructor's intentional overapplication of rudder to avoid a ditch during landing with a tailwind, which resulted in a runway excursion and landing gear collapse.Jun 25, 2019 · N5697V · Substantial damageNTSB GAA19CA371Accident · No injuriesData collectionFinal reportCessna 182 · Presidio, TXThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with vegetation.Jun 24, 2019 · N8521T · Substantial damageNTSB GAA19CA413Accident · No injuriesData collectionFinal reportCessna 152 · Clewiston, FLThe student pilot's maneuver to the left to avoid striking birds during takeoff and his subsequent loss of directional control after aborting the takeoff and landing on soft, muddy grass adjacent to the runway during, which resulted in a nose-over.Jun 23, 2019 · N5096L · Substantial damageNTSB CEN19LA184Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Vine Grove, KYThe pilot’s failure to maintain a proper visual lookout during the approach, which resulted in inadequate clearance from a tree.Jun 23, 2019 · N70803 · Substantial damageNTSB WPR19FA178Accident · 1 fatalClass 2 · FieldFinal reportMaule M7-235B · Sunriver, ORA partial loss of engine power due to the separation of baffling in both mufflers. Contributing to the accident was the pilot's failure to retract the landing gear on the float-equipped airplane before performing a forced landing to the river.Jun 22, 2019 · N118G · Substantial damageNTSB GAA19CA368Accident · No injuriesData collectionFinal reportCessna 172 · Tulsa, OKThe pilot's failure to maintain directional control while landing in gusting crosswind conditions, which resulted in a runway excursion and impact with a taxiway sign.Jun 22, 2019 · N9200B · Substantial damageNTSB CEN19LA213Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · Smithfield, RIThe pilot’s failure to use carburetor heat on approach in weather conditions conducive to carburetor icing, which resulted in a forced landing to a pond.Jun 22, 2019 · N415WP · Substantial damageNTSB CEN19LA204Accident · No injuriesClass 3 · LimitedFinal reportWaco YMF-5C · Bar Harbor, MEA total loss of engine power due to a cylinder failure for undetermined reasons.Jun 22, 2019 · N63WC · Substantial damageNTSB GAA19CA369Accident · No injuriesData collectionFinal reportPiper L21 · Imnaha, ORThe pilot's failure to maintain directional control while taking off from a soft, rough field, which resulted in a ground-loop.Jun 21, 2019 · N753AT · Substantial damageNTSB GAA19CA366Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Yerington, NVThe pilot's failure to properly secure the airplane before hand propping it, which resulted in the unmanned airplane moving and colliding with a fence.Jun 21, 2019 · N49368 · Substantial damageNTSB GAA19CA365Accident · No injuriesData collectionFinal reportCessna 182 · Burley, IDThe pilot's improper landing flare during landing in a gusting, right quartering tailwind, which resulted in the airplane wheel barrowing and a subsequent runway overrun, impact with terrain, and noseover.Jun 21, 2019 · N8465M · Substantial damageNTSB CEN19LA179Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Cottrellville Township, MIThe partial loss of engine power due to carburetor icing and the pilot’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing. The reason for the pilot’s inability to advance the throttle for the go-around could not be…Jun 21, 2019 · N2360R · Substantial damageNTSB ANC19FA026Accident · 3 fatalField investigationFinal reportHelio H 250 · Seward, AKThe pilot's failure to maintain clearance from trees during takeoff, which resulted in an in-flight collision, a loss of control, and impact with terrain.Jun 21, 2019 · N6314V · DestroyedNTSB GAA19CA363Accident · No injuriesData collectionFinal reportCessna 150 · Elkader, IAThe pilot's delayed decision to go around, which resulted in a collision with trees and terrain.Jun 20, 2019 · N6471F · Substantial damageNTSB CEN19FA177Accident · 2 fatalField investigationFinal reportBeech A36 · Elida, OHThe noninstrument-rated pilot's decision to continue visual flight rules flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot not obtaining a weather…Jun 20, 2019 · N6150X · DestroyedNTSB WPR19FA175Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Two Harbors, CAThe pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain.Jun 18, 2019 · N7187D · DestroyedNTSB GAA19CA405Accident · No injuriesData collectionFinal reportEurocopter EC135 · Cobleskill, NYThe pilot's failure to maintain situational awareness during takeoff from a confined area, which resulted in the helicopter rotors striking tree branches.Jun 17, 2019 · N135WJ · Substantial damageNTSB GAA19CA364Accident · No injuriesData collectionFinal reportCessna 170 · Hewitt Lake, AKThe pilot's failure to maintain directional control during takeoff from a soft, grass airstrip, which resulted in impact with brush.Jun 17, 2019 · N4427B · Substantial damageNTSB GAA19CA361Accident · Minor injuriesData collectionFinal reportQuicksilver Aircraft Northeast Sport · Ledgedale, PAThe pilot's selection of unsuitable terrain for takeoff, which resulted a nose-over. Contributing to the accident was the pilot's improper in-flight fuel management, which resulted in the precautionary landing on unsuitable terrain.Jun 17, 2019 · N418RB · Substantial damageNTSB GAA19CA352Accident · No injuriesData collectionFinal reportAir Tractor AT402 · Liberal, KSThe pilot's failure to see and avoid a windmill tower while maneuvering at low altitude.Jun 17, 2019 · N5044Y · Substantial damageNTSB ERA19LA199Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12 · Readington, NJThe pilot's failure to land on the mowed turf runway, which resulted in the airplane landing in tall grass and subsequently nosing over.Jun 17, 2019 · N43766 · Substantial damageNTSB WPR19FA173Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-11 · Copperopolis, CAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude. Contributing to the accident was the pilot’s impairment from consuming alcohol before the flight.Jun 16, 2019 · N209H · DestroyedNTSB GAA19CA349Accident · No injuriesData collectionFinal reportPiper PA18 · Beluga, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a noseover.Jun 16, 2019 · N91144 · Substantial damageNTSB WPR19FA172Accident · 1 fatalClass 3 · FieldFinal reportNanchang CJ6 · Porter Ranch, CAThe pilot’s continued flight into marginal visual meteorological conditions, which resulted in controlled flight into terrain.Jun 15, 2019 · N269AG · Substantial damageNTSB GAA19CA367Accident · Minor injuriesData collectionFinal reportCessna 172 · Lebanon, KYThe pilot's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion, impact with a ditch, and subsequent nose-over.Jun 15, 2019 · N75903 · Substantial damageNTSB GAA19CA347Accident · Minor injuriesData collectionFinal reportRobinson R22 · San Antonio, TXThe pilot receiving instruction's improper cyclic control input during landing, which resulted in a dynamic rollover, and the flight instructor's improper decision to practice landings in tall grass in gusting wind conditions.Jun 15, 2019 · N511HE · Substantial damageNTSB GAA19CA362Accident · No injuriesData collectionFinal reportCessna 172 · Tampa, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent nose-over.Jun 14, 2019 · N84402 · Substantial damageNTSB GAA19CA351Accident · No injuriesData collectionFinal reportVans Vans Acft RV 6 · Culpepper, VAThe pilot's failure to maintain directional control during takeoff in gusting crosswind conditions, which resulted in a ground loop.Jun 14, 2019 · N696SH · Substantial damageNTSB CEN19LA172Accident · Minor injuriesClass 3 · LimitedFinal reportKarns SKY Ranger · Hedgesville, WVA partial loss of engine power during takeoff due to the formation of carburetor ice while on the ground, which resulted in an impact with terrain.Jun 14, 2019 · N106RK · Substantial damageNTSB WPR19LA170Accident · Serious injuriesClass 3 · LimitedFinal reportJames Experimental Cub · Stanley, IDOverstress failure of the right-wing spar due to an encounter with turbulence.Jun 13, 2019 · N9WU · Substantial damageNTSB ANC19LA027Accident · No injuriesClass 3 · LimitedFinal reportHelio H391 · Hope, AKThe pilot’s failure to maintain directional control during a precautionary landing, which resulted in a ground loop. Contributing to the accident was a partial loss of engine power for reasons that could not be determined.Jun 12, 2019 · N10CJ · Substantial damageNTSB GAA19CA346Accident · No injuriesData collectionFinal reportCessna 152 · Greenville, TXThe passing pilot’s failure to maintain clearance from the airplane that he was attempting to pass during taxi operations. Contributing to the accident was the passing pilot's distraction due to looking at his on-board navigation device while attempting to…Jun 11, 2019 · N152TR · 2 aircraft · Substantial damage