NTSB investigations, 2020, ID

6 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2020, ID per year, 2008–2026: 197 cases
200811
200914
201012
201122
201215
201311
201414
201511
201610
201712
201811
201920
20206
20213
20224
20232
20247
20259
20263

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\" = 'ID' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 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 WPR20CA269Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 182 · Cascade, IDThe pilot's decision to continue the unstable approach which resulted in an inadequate flare, bounced landing and collision with trees following a delayed go around.Aug 13, 2020 · N92403 · Substantial damageNTSB WPR20CA179Accident · No injuriesClass 4 · Data collectionFinal reportAyres S2R · Lenore, IDThe pilot's failure to maintain clearance from power lines while maneuvering during an aerial application flight, which resulted in a wire strike.Jun 12, 2020 · N40226 · DestroyedNTSB WPR20CA171Accident · Minor injuriesClass 4 · Data collectionFinal reportEnstrom 480 · Murphy, IDThe pilot's failure to maintain clearance from a power line while maneuvering during an aerial application flight.Jun 4, 2020 · N130JS · Substantial damageNTSB WPR20CA100Accident · No injuriesData collectionFinal reportPiper PA28R · Twin Falls, IDThe pilot's loss of directional control during takeoff in gusting crosswind conditions, which resulted in a runway excursion and impact with a runway approach light.Mar 6, 2020 · N41429 · Substantial damageNTSB WPR20CA095Accident · No injuriesData collectionFinal reportCessna 172 · Dubois, IDThe student pilot's failure to maintain a proper airspeed and descent rate while conducting a low pass over a snow-covered runway after encountering a downdraft and the flight instructor's delayed action, which resulted in the wheels contacting the snow and…Feb 27, 2020 · N7904G · Substantial damage