Fatal NTSB investigations, 2002, ID

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
Fatal NTSB investigations, 2002, ID per year, 1964–2026: 434 cases
19645
19656
196610
19675
196812
19695
197010
19716
19726
19737
197410
19754
197614
197712
19789
197917
198012
198110
19829
198311
19848
198512
198612
19874
19889
19895
199012
19919
19928
19934
19946
19954
19969
19977
19988
19997
20007
20016
20029
200311
20047
20057
20062
20073
20083
20096
20105
20116
20125
20135
20145
20154
20162
20173
20184
20193
20204
20212
20226
20234
20245
20253
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\") = 2002
    AND c.\"eventStateOrRegion\" = 'ID' 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 SEA03LA005Accident · 2 fatalLimited investigationFinal reportIV Lancair IV · Coeur d'Alene, IDThe pilot's inadequate flare and his failure to maintain runway alignment. The pilot's lack of familiarity,downsloping terrain, and trees are contributing factors.Oct 15, 2002 · N599L · Substantial damageNTSB SEA02FA180Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Yellow Pine, IDThe pilot's failure to maintain clearance from trees. A factor was trees south of the departure end of the runway.Sep 25, 2002 · N7027W · DestroyedNTSB SEA02FA175Accident · 3 fatalField investigationFinal reportCessna TR182 · Twin Falls, IDThe pilot's failure to maintain runway alignment and his failure to execute a timely go-around maneuver resutling in the aircraft's impacting a parked fuel truck well clear of the runway safety area. Contributing factors were the strong crosswind/gusty wind…Sep 15, 2002 · N738GX · DestroyedNTSB SEA02FA146Accident · 3 fatalField investigationFinal reportBeech BE-35 · Idaho Falls, IDThe flying pilot's failure to maintain adequate airspeed resulting in a stall/spin. An additional cause was the flight instructor's inadequate supervision of the flight.Aug 5, 2002 · N82Z · DestroyedNTSB SEA02FA145Accident · 2 fatalField investigationFinal reportCessna 182A · Emmett, IDThe pilot's failure to maintain clearance from power transmission lines while maneuvering.Aug 5, 2002 · N4085D · Substantial damageNTSB SEA02FA119Accident · 2 fatalField investigationFinal reportCessna 335 · Tensed, IDAircraft control was not maintained during an emergency landing. A loss of power for undetermined reasons was a factor.Jul 4, 2002 · N27069 · Substantial damageNTSB SEA02FA109Accident · 2 fatalField investigationFinal reportBeech A35 · Atlanta, IDClearance from an object was not maintained during an aborted landing. Trees and mountainous terrain were factors.Jun 22, 2002 · N658B · Substantial damageNTSB SEA02FA108Accident · 1 fatalField investigationFinal reportGarlick UH-1H · Clark Fork, IDA failure of unknown origin in the tail rotor drive assembly. Factors include mountainous terrain unsuitable for an emergency landing.Jun 21, 2002 · N114DR · Substantial damageNTSB SEA02GA053Accident · 3 fatalFinal reportPiper PA-31 · Atlanta, IDThe pilot's failure to maintain aircraft control while in cruise flight which resulted in the in-flight separation due to overload of the spar at the right wing root. Hypoxia was a factor.Mar 12, 2002 · N2336V · Substantial damage