NTSB investigations, 2020, LA

6 cases where the sequence of events included Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2020, LA per year, 2008–2026: 86 cases
20084
20097
20103
20116
20127
201311
20142
20155
20164
20171
20195
20206
20217
20225
20233
20243
20256
20261

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\" = 'LA' 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\" = '240' 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 CEN21LA089Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA28 · Bossier City, LAThe student pilot’s decision to conduct a flight during night instrument meteorological conditions and his loss of airplane control due to spatial disorientation. Contributing to the accident was the student pilot’s use of an amphetamine and his attention…Dec 16, 2020 · N55168 · DestroyedNTSB CEN21FA025Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · Slidell, LAThe pilot’s loss of control shortly after departure for reasons that could not be determined based on the available information.Oct 21, 2020 · N35DC · DestroyedNTSB CEN20LA286Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Welsh, LAA partial loss of engine power while in flight due to corrosion of engine components, which resulted in a loss of control and a subsequent impact with terrain.Jul 2, 2020 · N7511D · Substantial damageNTSB CEN20LA199Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA28 · Pineville, LAThe airplane’s inability to gain sufficient airspeed after takeoff due to it being at or over its maximum gross weight, which resulted in a loss of control. Contributing to the accident was the pilot’s decision to operate the airplane at or over its maximum…May 31, 2020 · N6461J · 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 CEN20FA075Accident · 3 fatalClass 3 · FieldFinal reportCessna 182 · Chatham, LAThe pilot’s encounter with icing in-flight, which resulted in a loss of control and impact with terrain.Feb 6, 2020 · N60381 · Destroyed