OpenAirDocs.org

Fatal NTSB investigations, 2004, SC

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

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\") = 2004
    AND c.\"eventStateOrRegion\" = 'SC' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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 ATL05FA034Accident · 3 fatalField investigationFinal reportDiamond DA40-180 · Pelzer, SCThe pilot's failure to follow IFR procedures and to maintain assigned altitude resulting in a collision with a transmission wire and trees.Dec 9, 2004 · N42SE · Substantial damageNTSB ATL05LA018Accident · 2 fatalLimited investigationFinal reportBellanca Citabria 7ECA · Summerville, SCThe loss of engine power due to undetermined reasons.Oct 30, 2004 · N57388 · Substantial damageNTSB ATL05FA011Accident · 1 fatalField investigationFinal reportBeech BE-P35 · Aiken, SCThe pilot’s failure to follow IFR procedures, and continued flight below the minimum descent altitude and collided with trees.Oct 25, 2004 · N32AB · DestroyedNTSB ATL05LA009Accident · 2 fatalLimited investigationFinal reportNorth American Harvard II T-6 · Leesville, SCLoss of engine power due to fuel system contamination which blocked the flow of fuel which resulted in fuel starvation.Oct 23, 2004 · N92871 · Substantial damageNTSB CHI04MA182Accident · 4 fatalMajor investigationFinal reportBell 407 · Newberry, SCThe pilot's failure to maintain terrain clearance as a result of fog conditions. A contributing factor was inadequate weather and dispatch information relayed to the pilot.Jul 13, 2004 · N503MT · DestroyedNTSB ATL04LA123Accident · 1 fatalLimited investigationFinal reportCessna 310 · N. Myrtle Beach, SCThe pilot's inadequate preflight/planning and his in-flight decision which resulted in the loss of power in one engine due to fuel starvation.May 30, 2004 · N361Z · Substantial damageNTSB ATL04FA096Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Greenwood, SCThe pilot's failure to maintain airspeed during initial climb that resulted in an inadvertent stall and the subsequent collision with trees. A factor was the inadequate preflight planning/preparation when he failed to lower the wing flaps.Apr 19, 2004 · N8157J · DestroyedNTSB ATL04FA093Accident · 3 fatalField investigationFinal reportCessna 182S · North Augusta, SCThe pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an uncontrolled descent and subsequent in-flight collision with trees and the ground.Apr 12, 2004 · N364ME · Substantial damageNTSB ATL04FA090Accident · 2 fatalField investigationFinal reportSmith Aerostar 601P · Johns Island, SCThe pilot's failure to maintain airspeed during emergency descent, which resulted in an inadvertent stall/spin and uncontrolled descent into trees and terrain. A factor was the loss of engine power in one engine due to pre-ignition/detonation.Apr 5, 2004 · N869CC · Substantial damage