OpenAirDocs.org

NTSB investigations, 2020, NE

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19622026

Where

Open the map

Latest cases

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 year(c.\"eventDate\") = 2020
    AND c.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA'
  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 CEN21LA097Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Albion, NEThe pilot’s failure to maintain directional control during the landing with a tailwind.Dec 18, 2020 · N9590A · Substantial damageNTSB CEN20LA364Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Ogallala, NEThe total loss of engine power due to a failure of the master connecting rod.Aug 24, 2020 · N2437D · Substantial damageNTSB CEN20LA381Accident · No injuriesClass 3 · LimitedFinal reportPiper PA36 · Ord, NEThe pilot’s failure to maintain adequate airspeed while in a turn during initial climb and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at a low altitude.Aug 18, 2020 · N57607 · Substantial damageNTSB CEN20CA347Accident · Minor injuriesClass 4 · Data collectionFinal reportGrumman G164 · Scottsbluff, NEThe pilot’s loss of visual reference during agricultural low-level flight, resulting in collision with power lines.Aug 18, 2020 · N48416 · Substantial damageNTSB CEN20CA331Accident · No injuriesClass 4 · Data collectionFinal reportCessna A188 · Hartington, NEThe pilot's failure to ensure that the engine oil cap was installed before takeoff, which resulted in the oil obscuring the pilot’s view through the windshield and necessitated a forced landing on unsuitable terrain. Contributing to the accident were the…Jul 27, 2020 · N9278G · Substantial damageNTSB CEN20CA316Accident · Minor injuriesClass 4 · Data collectionFinal reportRobinson R44 · Hebron, NEA loss of engine power due to water contamination in the fuel system. Contributing to the accident was the pilot’s inadequate preflight to sump the fuel tanks prior to flight.Jul 27, 2020 · N771GB · Substantial damageNTSB CEN20LA306Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT502 · Grant, NEThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering during an agricultural flight, which resulted in an aerodynamic stall and a loss of control at too low of an altitude to recover. Contributing to the accident was the pilot’s…Jul 25, 2020 · N502KJ · Substantial damageNTSB CEN20CA307Accident · Serious injuriesClass 4 · Data collectionFinal reportVans Vans RV 6 · Imperial, NEThe pilot's inadequate preflight performance planning and his decision not to utilize all available runway during high density altitude operations which led to an inflight loss of control and subsequent collision with terrain.Jul 25, 2020 · N327WB · Substantial damageNTSB CEN20CA137Accident · No injuriesData collectionFinal reportPiper PA-28-235C · Omaha, NEThe student pilot’s improper landing flare, which resulted in a bounced landing, subsequent loss of directional control, and the airplane going down an embankment.Mar 31, 2020 · N9468W · Substantial damage