NTSB investigations, 2020, SC

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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

19642026
NTSB investigations, 2020, SC per year, 1964–2026: 1,853 cases
196446
196541
196658
196749
196862
196939
197051
197142
197258
197343
197449
197551
197639
197744
197856
197928
198029
198132
198252
198340
198435
198536
198625
198735
198841
198927
199023
199120
199231
199324
199430
199532
199619
199728
199828
199926
200019
200113
200221
200322
200420
200522
200617
200715
200820
200929
201019
201121
201221
201313
201413
201512
201615
201712
201821
201918
202013
202122
202221
202321
202410
202519
202615

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\" = 'SC' 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 ERA21LA054Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Greenville, SCA partial loss of engine power due to the pilot’s delayed application of carburetor heat, which resulted in carburetor icing.Nov 24, 2020 · N5566J · Substantial damageNTSB ERA21LA031Accident · No injuriesClass 4 · LimitedFinal reportSparrowhawk II · North Myrtle Beach, SCA ruptured fuel line, which resulted in fuel starvation to the engine and a total loss of engine power.Oct 7, 2020 · N40380 · Substantial damageNTSB ERA21LA002Accident · Minor injuriesClass 3 · LimitedFinal reportBeech BE-36 · Green Sea, SCThe pilot’s inadvertent placement of the fuel selector in an intermediate position, which starved the engine of fuel and resulted in a total loss of engine power.Oct 2, 2020 · N656V · Substantial damageNTSB 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 ERA20LA326Accident · Serious injuriesClass 3 · LimitedFinal reportStearman E75 · Honea Path, SCThe partial loss of engine power due to the fatigue failure of an engine cylinder and the pilot’s subsequent decision to overfly several suitable forced-landing sites while attempting to return to the departure airstrip.Sep 21, 2020 · N1524M · DestroyedNTSB ERA20LA286Accident · Minor injuriesClass 3 · LimitedFinal reportJust JA 30 Superstol · Clover, SCThe separation of a spark plug lead, resulting in a partial loss of engine power and collision with trees.Aug 15, 2020 · N146BB · Substantial damageNTSB ERA20LA278Accident · Serious injuriesClass 3 · LimitedFinal reportCessna P210 · Allendale, SCA total loss of engine power as a result of fuel starvation due to contamination from a thermoplastic polymer used in the fuel system. Contributing to the accident was the pilot’s failure to report debris observed in the fuel system during previous preflight…Aug 7, 2020 · N6300W · DestroyedNTSB ERA20LA270Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA31 · Sumter, SCThe pilot’s fuel mismanagement during flight, which resulted in a total loss of engine power from both engines due to fuel starvation.Aug 1, 2020 · C-GXKS · Substantial damageNTSB ERA20CA249Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Pickens, SCThe student pilot's improper landing flare and improper recovery from a bounced landing, which resulted in a hard landing.Jul 11, 2020 · N737WA · Substantial damageNTSB ERA20CA243Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Greenwood, SCThe pilot's failure to maintain adequate clearance from a parked airplane while taxiing. Contributing to the accident was the parked airplane's position over the double-yellow taxiway edge lines and into the taxiway object-free movement area.Jun 7, 2020 · N6958J · Substantial damageNTSB ERA20LA150Accident · 2 fatalClass 3 · LimitedFinal reportArion Lightning LS-1 · Mount Pleasant, SCThe pilot's failure to maintain clearance from trees at the end of the runway due to spatial disorientation during initial climb in dark night conditions. Also causal was the flight instructor’s inadequate monitoring, which did not identify and prevent the…Apr 10, 2020 · N81DJ · DestroyedNTSB ERA20LA132Accident · 1 fatalClass 3 · LimitedFinal reportCessna 310 · Charleston, SCThe pilot’s fuel mismanagement during flight, resulting in a total loss of engine power due to fuel starvation.Mar 21, 2020 · N8080M · Substantial damageNTSB ERA20LA129Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Conway, SCThe pilot’s incorrect use of the autopilot while approaching the initial approach fix and his subsequent improper primary pitch control input while a pitch mode of the autopilot was engaged, which resulted in pitch excursions and subsequent departure from…Mar 17, 2020 · N150X · Substantial damage