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 ERA20CA189Accident · No injuriesClass 4 · Data collectionFinal reportZenith Zodiac CH 650 · Carthage, NCThe pilot's failure to attain the proper touchdown point during landing with a tail wind, which resulted in a runway excursion.May 16, 2020 · N149WF · Substantial damageNTSB CEN20CA182Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Chatham, ILThe pilot's decision to continue flight in instrument meteorological conditions in an airplane not equipped for instrument flight, which forced her to perform a precautionary landing to a muddy field resulting in the airplane nosing over.May 15, 2020 · N120MZ · Substantial damageNTSB CEN20CA181Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 172 · Colchester, ILThe pilot's inadequate preflight of the fuel quantity which resulted in a loss of engine power due to fuel starvation during cruise flight.May 15, 2020 · N92036 · Substantial damageNTSB ANC20LA046Accident · 1 fatalClass 3 · LimitedFinal reportCessna A185 · Nuiqsut, AKThe pilot’s controlled flight into flat snow-covered terrain in weather conditions that were conducive to flat light conditions.May 15, 2020 · N5454E · Substantial damageNTSB ERA20CA184Accident · No injuriesClass 4 · Data collectionFinal reportBell OH-58C · Livingston, NYThe pilot's failure to maintain obstacle clearance while maneuvering at low altitude at night, which resulted in the helicopter striking a tree.May 14, 2020 · N183MP · Substantial damageNTSB WPR20LA144Accident · No injuriesClass 3 · LimitedFinal reportMooney M20J · Phoenix, AZA total loss of engine power due to oil starvation for reasons that could not be determined due to a lack of available evidence, which resulted in impact with terrain during a subsequent forced landing.May 13, 2020 · N201HH · Substantial damageNTSB WPR20CA151Accident · No injuriesClass 4 · Data collectionFinal reportLet L 33 Solo · Arlington, WAThe loss of lift while on final approach which resulted in a hard off-airport landing.May 11, 2020 · N355BA · Substantial damageNTSB ERA20CA185Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Fayetteville, TNThe pilot's failure to maintain directional control during landing in gusting crosswind conditions.May 11, 2020 · N4454A · Substantial damageNTSB ERA20CA178Accident · Minor injuriesClass 4 · Data collectionFinal reportSchempp Hirth Ventus 2CT · Stuarts Draft, VAA loss of thermal lift during a motor glider flight, which resulted in an off-airport landing. Contributing to the accident was the pilot's delayed attempted engine start.May 11, 2020 · N514TW · Substantial damageNTSB ERA20CA191Accident · Minor injuriesClass 4 · Data collectionFinal reportBell UH 1N · Baghdad, IraqThe flight crew's inadequate situational awareness and failure to maintain adequate clearance from a security barrier during a night takeoff.May 10, 2020 · N12328 · Substantial damageNTSB CEN20CA176Accident · No injuriesClass 4 · Data collectionFinal reportNorth American SNJ · San Antonio, TXThe pilot's loss of directional control while landing a tailwheel airplane in gusty wind conditions.May 8, 2020 · N3238G · Substantial damageNTSB CEN20LA172Accident · 1 fatalClass 3 · LimitedFinal reportCessna T210L · Burleson, TXThe loss of engine power due to fuel starvation.May 7, 2020 · N2074S · DestroyedNTSB CEN20LA170Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · Hallettsville, TXThe partial loss of engine power due to contaminated fuel and carburetor ice.Apr 30, 2020 · N2275H · Substantial damageNTSB CEN20LA162Accident · Minor injuriesClass 2 · LimitedFinal reportCessna T210 · New Braunfels, TXThe pilot's inadequate preflight inspection and fuel planning, which resulted in the loss of engine power due to fuel exhaustion.Apr 28, 2020 · N210HH · Substantial damageNTSB CEN20CA163Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Longmont, COThe pilot's loss of control during a go around.Apr 28, 2020 · N41498 · Substantial damageNTSB WPR20CA132Accident · No injuriesClass 4 · Data collectionFinal reportCook Sonex · Upland, CAA gradual loss of engine power during takeoff due to the pressure regulator not keeping continuous fuel pressure which led to a precautionary off airport landing and collision with terrain.Apr 27, 2020 · N1222C · Substantial damageNTSB WPR20CA134Accident · Minor injuriesData collectionFinal reportPiper PA18 · Bountiful, UTThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a roll-over.Apr 25, 2020 · N707VB · Substantial damageNTSB ERA20LA163Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · East Hampton, NYThe partial loss of engine power after takeoff due to the formation of carburetor ice while on the ground. Contributing to the accident was the pilot’s failure to apply carburetor heat.Apr 25, 2020 · N33005 · Substantial damageNTSB ERA20CA159Accident · No injuriesData collectionFinal reportAeronca 7AC · Enosburg, VTThe pilot's improper decision to land on unsuitable terrain, which resulted in a nose-over.Apr 25, 2020 · N83216 · Substantial damageNTSB ERA20LA161Accident · No injuriesClass 3 · LimitedFinal reportKeuthan Buccaneer II · Coden, ALA total loss of engine power due to carburetor icing. Contributing to the accident was the lack of a carburetor heat system installed on the engine.Apr 24, 2020 · N43310 · Substantial damageNTSB CEN20CA155Accident · No injuriesData collectionFinal reportVans RV 3 · Independence, IAThe pilot's failure to maintain directional control during a high-speed taxi with a quartering tailwind, which resulted in a runway excursion and impact with a fence and terrain.Apr 23, 2020 · N24DE · Substantial damageNTSB ERA20CA158Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Athens, GAThe pilot's failure to maintain airplane control after an aborted landing, which resulted in collision with trees.Apr 22, 2020 · N1115 · Substantial damageNTSB CEN20CA154Accident · No injuriesData collectionFinal reportCessna 172 · Ft Worth, TXThe student pilot’s failure to maintain a stabilized approach and the flight instructor's delayed remedial action to initiate a go-around, which resulted in a runway overrun and impact with runway lights and fences.Apr 22, 2020 · N13005 · Substantial damageNTSB ERA20CA155Accident · Serious injuriesData collectionFinal reportGrumman AA5 · Bloomingdale, GAThe pilot's failure to maintain airplane control during landing with a gusting quartering tailwind.Apr 21, 2020 · N314JG · Substantial damageNTSB CEN20CA158Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · El Campo, TXThe pilot's misjudgment of a ground spray rig’s position and his incorrect belief that a runway incursion might occur, which resulted in the pilot attempting and then aborting a go-around, which resulted in a runway excursion and collision with a fence.Apr 21, 2020 · N419TW · Substantial damageNTSB CEN20CA153Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Mamou, LAThe airplane's encounter with a sunken area during takeoff from a turf runway, which resulted in the airplane becoming prematurely airborne and impacting a tree and then terrain.Apr 21, 2020 · N653LA · Substantial damageNTSB WPR20CA125Accident · Minor injuriesData collectionFinal reportCessna 172 · Yakima, WAThe pilot's failure to attain sufficient altitude during a go-around, which resulted in impact with hilly terrain.Apr 20, 2020 · N75765 · Substantial damageNTSB ERA20CA156Accident · No injuriesData collectionFinal reportCessna 150 · Hamburg, NYThe pilot's improper decision to land on unsuitable terrain, which resulted in a nose-over.Apr 20, 2020 · N150LF · Substantial damageNTSB WPR20LA126Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 152 · Corona, CAThe pilot's failure to use carburetor heat while operating in conditions conducive to serious carburetor icing, which resulted in a total loss of engine power.Apr 19, 2020 · N6306P · Substantial damageNTSB CEN20LA150Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Bowie, TXThe pilot's failure to maintain control of the airplane during takeoff in gusting wind conditions, which resulted in an uncontrolled turn and descent into terrain.Apr 19, 2020 · N3670P · Substantial damageNTSB CEN20CA151Accident · No injuriesData collectionFinal reportEagle Eagle DW 1 · Hudson, COThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and nose-over.Apr 18, 2020 · N8810T · Substantial damageNTSB ERA20CA152Accident · No injuriesData collectionFinal reportHolmgren Bearhawk · Ahoskie, NCThe collapse of the right main landing gear during a bounced, crosswind landing.Apr 17, 2020 · N118CR · Substantial damageNTSB WPR20CA124Accident · No injuriesData collectionFinal reportCessna 180 · Marion, MTThe pilot's loss of directional control and subsequent improper brake application during the landing roll in gusting wind conditions, which resulted in a nose-over.Apr 16, 2020 · N53ES · Substantial damageNTSB CEN20CA152Accident · No injuriesData collectionFinal reportCessna 172 · Enid, OKThe flight instructor's delayed remedial action during a power-off approach and go-around in gusting wind conditions, which resulted in a hard landing, loss of directional control, and a runway excursion onto a field.Apr 16, 2020 · N737RR · Substantial damageNTSB ERA20LA150Accident · 2 fatalClass 3 · LimitedFinal reportArion Lightning LS-1 · Mount Pleasant, SCThe pilot's failure to maintain clearance from trees at the end of the runway due to spatial disorientation during initial climb in dark night conditions. Also causal was the flight instructor’s inadequate monitoring, which did not identify and prevent the…Apr 10, 2020 · N81DJ · DestroyedNTSB ERA20CA151Accident · No injuriesData collectionFinal reportPipistrel Sinus · Townsend, TNThe motor glider's encounter with atmospheric lift conditions that were not sufficient to maintain flight, which necessitated a forced landing and resulted in impact with vegetation. Contributing to the accident was the pilot's delayed decision to restart the…Apr 10, 2020 · N711MK · Substantial damageNTSB CEN20LA145Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Sidney, IAA loss of engine power for reasons that could not be determined.Apr 10, 2020 · N1258Z · Substantial damageNTSB WPR20LA122Accident · No injuriesClass 3 · LimitedFinal reportBuckman Bucks Special · Prescott, WADiminished engine performance due to carburetor icing conditions and multiple mechanical anomalies that did not allow for the airplane to attain adequate airspeed during takeoff from a planted field and failure to maintain clearance from obstructions.…Apr 9, 2020 · N9065F · Substantial damageNTSB CEN20LA143Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT 502 · Pecan Gap, TXThe pilot did not maintain adequate clearance from tree, which resulted in a collision with a tree and subsequent impact with terrain.Apr 8, 2020 · N9185D · DestroyedNTSB ANC20CA041Accident · No injuriesData collectionFinal reportPiper PA 18A · Chickaloon, AKThe pilot's selection of unsuitable terrain for landing, which necessitated a go-around, and her subsequent failure to maintain clearance from rising mountainous terrain.Apr 7, 2020 · N2791P · Substantial damageNTSB CEN20CA144Accident · No injuriesData collectionFinal reportRobinson R22 · Seymour, TXThe pilot's failure to maintain clearance from a tree while maneuvering at low altitude.Apr 6, 2020 · N7007X · Substantial damageNTSB CEN20CA139Accident · Serious injuriesData collectionFinal reportRans S-12 Airaile · Hillrose, COThe noncertificated pilot's diverted attention while looking at a fire during low-altitude flying, which resulted in a collision with power lines.Apr 4, 2020 · UNREG · Substantial damageNTSB CEN20CA138Accident · No injuriesData collectionFinal reportChampion Aeronca 7FC · Hessel, MIThe pilot's loss of directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and impact with a snowbank.Apr 2, 2020 · N3JZ · Substantial damageNTSB ERA20CA146Accident · No injuriesData collectionFinal reportCessna 172 · Hollywood, FLThe pilot’s failure to apply full engine power during the initiation of a go-around in gusting wind conditions and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at low altitude, and the flight instructor's…Apr 1, 2020 · N734HF · Substantial damageNTSB ERA20CA143Accident · No injuriesData collectionFinal reportDiamond DA42 · Palm Coast, FLThe pilot receiving instruction’s failure to maintain airplane control during a simulated engine failure landing and subsequent attempted go-around in gusting crosswind conditions and the flight instructor's delayed remedial action.Apr 1, 2020 · N311ER · Substantial damageNTSB CEN20LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Seguin, TXThe pilot’s mismanagement of airspeed and glidepath during approach for a precautionary landing, which resulted in a runway excursion and a collision with a fence.Apr 1, 2020 · N9883R · Substantial damageNTSB WPR20CA120Accident · No injuriesData collectionFinal reportPiper PA28R · Palm Springs, CAThe pilot's failure to see and avoid a parked vehicle near the taxiway edge.Mar 31, 2020 · N679X · Substantial damageNTSB CEN20LA136Accident · 2 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Audubon, IAThe pilot’s failure to recognize and avoid the power line during the low-altitude flight. Contributing to the accident was the pilot’s fatigue, which affected the pilot’s ability to see and avoid the power line.Mar 31, 2020 · N107EH · DestroyedNTSB WPR20LA115Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Sedona, AZThe pilot’s loss of pitch control while landing in crosswind conditions, which resulted in a collapsed nose gear and departure of the airplane from the runway.Mar 29, 2020 · N172FG · Substantial damageNTSB ANC20CA040Accident · No injuriesData collectionFinal reportPiper PA32 · Fairbanks, AKThe pilot's inadequate compensation for gusting crosswind conditions, which resulted in a loss of directional control, a runway excursion, and impact with a snowbank.Mar 28, 2020 · N1409X · Substantial damage