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 ERA20LA335Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Union, SCA total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s failure to use carburetor heat in conditions conducive to the development of carburetor icing.Sep 27, 2020 · N33859 · DestroyedNTSB WPR20LA322Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32-300 · Silver Springs, NVThe pilot’s failure to maintain directional control during a nighttime landing with a crosswind, which resulted in a runway excursion and impact with a sign.Sep 26, 2020 · N4132W · Substantial damageNTSB ERA20LA334Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · New Smyrna Beach, FLThe pilot’s decision to depart from a non-suitable surface, which resulted in a loss of directional control during takeoff roll.Sep 26, 2020 · N89476 · Substantial damageNTSB CEN20LA420Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Terrell, TXFuel starvation due to a fuel system leak, which resulted in a loss of engine power and the subsequent forced landing on unsuitable terrain.Sep 24, 2020 · N3958A · Substantial damageNTSB WPR20LA315Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-802A · Emmett, IDThe pilot’s descent below surrounding terrain and his delayed decision to initiate a climb which resulted in impact with terrain. Contributing to the accident were terrain and lighting conditions that affected the pilot’s ability to accurately assess terrain…Sep 23, 2020 · N836MM · Substantial damageNTSB ERA20LA330Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA25 · Floral City, FLThe pilot’s failure to see and avoid a tree while flying towards the rising sun during an aerial application flight, which resulted in a collision with the tree and a subsequent loss of airplane control.Sep 23, 2020 · N6106Z · DestroyedNTSB CEN20LA422Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · St. Clairsville, OHThe pilots improper fuel planning that resulted in a total loss of engine power due to fuel exhaustion.Sep 23, 2020 · N81624 · Substantial damageNTSB ANC20LA099Accident · No injuriesClass 3 · LimitedFinal reportCessna 170B · Big Lake, AKThe pilot’s failure to utilize carburetor heat while flying in conditions conducive to carburetor icing, which resulted in a total loss of engine power.Sep 23, 2020 · N4380B · Substantial damageNTSB WPR20LA323Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopter 369 · Chemehuevi Valley, CAThe pilot’s failure to maintain helicopter control during an approach with a gusting variable wind, which resulted in an impact with terrain.Sep 22, 2020 · N509CG · Substantial damageNTSB WPR20LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Island Park, IDThe pilot’s failure to maintain directional control during a crosswind landing.Sep 22, 2020 · N756RA · Substantial damageNTSB ERA20LA338Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Pottstown, PAThe pilot’s failure to maintain directional control while landing in gusty, shifting wind conditions.Sep 22, 2020 · N2772D · Substantial damageNTSB ERA20LA325Accident · Minor injuriesClass 4 · LimitedFinal reportErcoupe F 1 · West Kingston, RIThe pilot’s failure to conduct a proper preflight inspection and ensure the fuel was uncontaminated, which resulted in a partial loss of engine power and forced landing.Sep 21, 2020 · N3000G · Substantial damageNTSB CEN20LA407Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver MX II · Marengo, INA loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s decision to operate the airplane in conditions conducive to carburetor icing without a carburetor heating system, contrary to the engine manufacturer’s guidance.Sep 21, 2020 · UNREG · Substantial damageNTSB WPR20LA311Accident · Serious injuriesClass 3 · LimitedFinal reportNorth American B25N · Stockton, CAA total loss of engine power due to fuel exhaustion. Contributing to the accident was the erroneous fuel gauge indications and inadequate preflight planning and inspectionSep 20, 2020 · N7946C · Substantial damageNTSB CEN20LA415Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · San Antonio, TXThe pilot’s inadequate compensation for gusting crosswind conditions while landing, which resulted a loss of lateral control and impact with a fence.Sep 20, 2020 · N4019V · Substantial damageNTSB CEN20LA412Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Montrose, MOA total loss of engine power due to an electrical overload in the engine control unit wiring system; the electrical overload occurred as a result of improper installation by the airplane builder.Sep 20, 2020 · N210WP · Substantial damageNTSB CEN20LA401Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA32 · Kokomo, INThe pilot’s inadequate visual lookout, which resulted in a collision with a utility pole and the subsequent collision with terrain.Sep 20, 2020 · N8213X · DestroyedNTSB CEN20LA399Accident · 2 fatalClass 3 · LimitedFinal reportVans RV9 · Zeeland, MIThe pilot’s failure to maintain airspeed during a visual approach in dark night conditions, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the pilot’s lack of recent flight experience at night.Sep 19, 2020 · N94KJ · DestroyedNTSB CEN20CA406Accident · Minor injuriesClass 4 · Data collectionFinal reportPik PIK-20D · Union, ILThe pilot’s failure to maintain directional control during takeoff that resulted in a collision with another glider that was parked close to the departure runway, and the pilot’s improper decision to attempt a takeoff without ensuring he had safe clearance…Sep 19, 2020 · N32C · Substantial damageNTSB CEN20CA405Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Huntley, ILThe pilot’s decision to land at night without runway lighting, which resulted in a collision with an object.Sep 19, 2020 · N43020 · Substantial damageNTSB WPR20LA333Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic N500 · Peoria, AZThe balloon's encounter with unexpected windshear, which resulted in a hard landing and serious passenger injuries.Sep 18, 2020 · N500UM · No damageNTSB ERA20LA323Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Hollywood, FLThe pilot's failure to maintain directional control during a crosswind takeoff, which resulted in a collision with airport lights and a sign.Sep 18, 2020 · N234ME · Substantial damageNTSB CEN20CA404Accident · No injuriesClass 4 · Data collectionFinal reportCubcrafters CC11 · Larkspur, COThe pilot’s failure to maintain control of the airplane while taking off in gusting quartering tailwind conditions.Sep 18, 2020 · N55JV · Substantial damageNTSB CEN20LA403Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Palatine, ILThe loss of partial engine power due to fuel starvation during departure which resulted in a forced landing and collision with a utility pole.Sep 17, 2020 · N2699V · Substantial damageNTSB CEN20CA411Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna R182 · Marksville, LAThe pilot’s inadequate preflight inspection, during which he failed to ensure the landing gear handle in the “down” position which resulted in the landing gear retracting during takeoff, a loss of directional control, and a runway excursion.Sep 17, 2020 · N6208T · Substantial damageNTSB ANC20CA097Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Arctic Village, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a rock damaging the empennage.Sep 16, 2020 · N5779D · Substantial damageNTSB WPR20LA324Accident · No injuriesClass 4 · LimitedFinal reportPilatus PC-12/47E · Lake Abert, ORThe pilot’s failure to maintain clearance from an object during the takeoff ground roll due to inadequate monitoring of the environment.Sep 15, 2020 · N1220A · Substantial damageNTSB CEN20CA394Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA46 · Englewood, COThe pilot's failure to maintain directional control during landing in gusting winds.Sep 15, 2020 · N596ST · Substantial damageNTSB WPR20LA330Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Stanley, IDThe pilot's failure to maintain terrain clearance after flying into the wrong canyon in mountainous terrain which resulted in a collision with trees and terrain.Sep 13, 2020 · N52700 · Substantial damageNTSB WPR20LA304Accident · 2 fatalClass 3 · LimitedFinal reportCessna 172 · Seeley Lake, MTThe noninstrument-rated pilot’s encounter with instrument meteorological conditions during a night visual approach due to wildfire smoke, which resulted in controlled flight into terrain.Sep 13, 2020 · N3720R · Substantial damageNTSB ERA20LA315Accident · 2 fatalClass 3 · LimitedFinal reportVans RV9 · Steinhatchee, FLThe failure of the air traffic controller to provide hazardous weather information to the pilot, resulting in the flight’s encounter with strong updraft conditions, an inflight loss of airplane control, and an in-flight breakup. Contributing was the pilot’s…Sep 13, 2020 · N4889R · DestroyedNTSB ANC20CA094Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Kiana, AKThe pilot’s improper decision to perform a takeoff from an unsuitable surface, which resulted in a loss of control and nose over.Sep 13, 2020 · N3068A · Substantial damageNTSB WPR20LA309Accident · No injuriesClass 4 · LimitedFinal reportBird CK · Enterprise, ORThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.Sep 11, 2020 · N933V · Substantial damageNTSB WPR20CA307Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CC11-160 · Big Creek, IDThe pilot’s failure to maintain directional control during the landing roll with a gusting wind, which resulted in a runway excursion and impact with a tree.Sep 11, 2020 · N682CC · Substantial damageNTSB CEN20CA391Accident · Minor injuriesClass 4 · Data collectionFinal reportChampion 8GCBC · Ozark, ARThe pilot's failure to maintain clearance from a wire during final approach to landing.Sep 11, 2020 · N81BH · Substantial damageNTSB ERA20LA314Accident · 1 fatalClass 3 · LimitedFinal reportZenair CH750 Cruzer · Boaz, ALThe pilot’s failure to maintain control of the airplane, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing was the pilot’s continued visual flight rules flight into an area of low clouds.Sep 10, 2020 · N656BN · Substantial damageNTSB ANC20CA092Accident · No injuriesClass 4 · Data collectionFinal reportHelio H 295 · Fairbanks, AKThe pilot’s decision to initiate a right turn immediately after departure and his failure to maintain a proper crosswind correction, which resulted in a collision with terrain.Sep 10, 2020 · N68857 · Substantial damageNTSB WPR20LA331Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Randle, WAThe pilot's failure to maintain clearance from a tree while conducting an external load operation.Sep 9, 2020 · N91TA · DestroyedNTSB WPR20CA299Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 182 · Coeur d'Alene, IDThe pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion and a collision with trees and terrain.Sep 7, 2020 · N8885X · Substantial damageNTSB CEN20LA380Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Canyon Lake, TXThe total loss of engine power for a reason that could not be determined based on available information.Sep 7, 2020 · N4636D · Substantial damageNTSB CEN20CA388Accident · No injuriesClass 4 · Data collectionFinal reportMaule MX7 · Brazoria, TXThe pilot’s failure to maintain airplane control during a go-around from unsuitable terrain.Sep 7, 2020 · N897DC · Substantial damageNTSB CEN20LA379Accident · 4 fatalClass 3 · LimitedFinal reportCirrus SR22 · Chester, ARThe noninstrument-rated pilot’s continued flight into dark night instrument meteorological conditions which resulted in spatial disorientation and a subsequent loss of airplane control.Sep 5, 2020 · N733CD · DestroyedNTSB WPR20LA295Accident · 2 fatalClass 3 · LimitedFinal reportBeech 35 · Three Rivers, CAThe pilot’s controlled flight into terrain while operating in conditions of reduced visibility due to smoke.Sep 4, 2020 · N818S · DestroyedNTSB ERA20LA306Accident · Serious injuriesClass 4 · LimitedFinal reportThrush S2R-H80 · Hawkinsville, GAThe pilot's failure to maintain clearance from an antenna tower while maneuvering during an agricultural application flight while flying directly toward the sun.Sep 3, 2020 · N30529 · Substantial damageNTSB WPR20CA312Accident · No injuriesClass 4 · Data collectionFinal reportBeechcraft C90A · Fortuna, CAA collision with a deer while landing at night.Aug 31, 2020 · N982SB · Substantial damageNTSB ANC20LA086Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA 14 · Wasilla, AKThe pilot’s failure to maintain airplane control during an attempted go-around in gusting wind conditions, which resulted in impact with trees.Aug 31, 2020 · N4214H · Substantial damageNTSB CEN20LA436Accident · No injuriesClass 4 · LimitedFinal reportPiper J3 · Hartford, WIThe pilot’s loss of situation awareness which resulted in landing in a grass area and the subsequent collision with a runway marker.Aug 30, 2020 · N88204 · Substantial damageNTSB ANC20CA091Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Lime Village, AKThe pilot’s loss of control during the landing flare, which resulted in an impact with trees.Aug 30, 2020 · N107L · Substantial damageNTSB CEN20LA367Accident · 1 fatalClass 3 · LimitedFinal reportCirrus SR22 · Lawrenceville, ILThe pilot’s controlled flight into terrain as a result of his failure to properly execute an instrument approach and maintain clearance from trees in night instrument meteorological conditions. Contributing to the accident was the pilot’s unfamiliarity with a…Aug 29, 2020 · N607SR · DestroyedNTSB WPR20LA301Accident · 1 fatalClass 3 · LimitedFinal reportLake LA4 · Rawlins, WYThe pilot’s decision to depart despite a known mechanical trim malfunction and with a high-density altitude and the airplane at or above its maximum gross weight.Aug 25, 2020 · N93AB · Substantial damage