Fatal NTSB investigations, 2020

6 cases where the sequence of events included Aircraft structural failure.

Cases per year

20082026
Fatal NTSB investigations, 2020 per year, 2008–2026: 155 cases
200812
200920
20109
201113
201212
201313
20144
20158
20168
20177
201812
20195
20206
20214
20226
20237
20248
20251

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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '337' 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 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 WPR20LA283Accident · 1 fatalClass 3 · LimitedFinal reportKaman K 1200 · Pine Grove, ORAn in-flight breakup resulting from contact of the left rotor system with the right rotor system after an in-flight failure of a servo flap from a left rotor blade.Aug 25, 2020 · N314 · Substantial damageNTSB WPR20WA210Accident · 2 fatalForeign investigationRobinson R44 · Broome Aerodrome, AustraliaThe government of Australia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on July 04, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…Jul 4, 2020 · VH-NBY · Substantial damageNTSB CEN20WA237Accident · 1 fatalForeign investigationPiper PA34 · Reinsfeld, GermanyThe government of Germany has notified the NTSB of an accident involving a Piper PA-34 220T airplane, German registration D-GEMZ, that occurred on June 17, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's…Jun 17, 2020 · D-GEMZ · DestroyedNTSB CEN20LA201Accident · 4 fatalClass 3 · LimitedFinal reportPiper PA28 · Carlinville, ILThe pilot’s attempted recovery from a steep descent which inadvertently exceeded the ultimate load factor of the airframe and resulted in a low-level inflight breakup.May 31, 2020 · N8991W · DestroyedNTSB ERA20FA086Accident · 2 fatalClass 3 · FieldFinal reportMustang II · Senoia, GAThe pilot’s exceedance of the airplane’s structural limitations while conducting previous aerobatic maneuvers, which resulted in an in-flight breakup of the airplane.Jan 25, 2020 · UNREG · Destroyed