Fatal NTSB investigations, 2003, 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, 2003, 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\") = 2003
    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 SEA04LA019Accident · 1 fatalLimited investigationFinal reportKaman K-600 · Nordman, IDThe total failure of the helicopter's right main rotor shaft while in an ascending hover due to the propagation of a fatigue crack that initiated in a corrosion pit on the surface of a slot in the wall of the subject shaft. Factors include accumulation of…Nov 20, 2003 · N286M · Substantial damageNTSB SEA04FA020Accident · 1 fatalField investigationFinal reportCessna T210N · Bellevue, IDThe pilot's failure to maintain adequate altitude above mountainous terrain while maneuvering during descent. Factors included the mountainous terrain, the high wind condition, and dark night light conditions.Nov 20, 2003 · N5244A · DestroyedNTSB SEA03LA190Accident · 2 fatalLimited investigationFinal reportCessna 182 · Challis, IDThe pilot's failure to maintain clearance from trees while maneuvering. Factors include mountainous terrain and trees.Sep 13, 2003 · N5547B · DestroyedNTSB SEA03FA173Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Warm Lake, IDThe pilot's failure to maintain adequate airspeed during final approach resulting in a stall/spin. Contributing factors were the rapidly rising terrain and trees.Aug 26, 2003 · N6126J · DestroyedNTSB SEA03FA143Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · White Bird, IDThe failure of the pilot to maintain clearance with terrain while maneuvering. Factors contributing to the accident included the impairment of the pilot due to carbon monoxide exposure and the trees.Jul 17, 2003 · C-GBEN · DestroyedNTSB SEA03FA123Accident · 3 fatalField investigationFinal reportBeech A24-R · Yellow Pine, IDThe pilot's failure to maintain clearance. Factors include trees and mountainous terrain.Jul 4, 2003 · N254M · DestroyedNTSB SEA03FA100Accident · 2 fatalField investigationFinal reportAviat A-1 · Atlanta, IDClearance from trees was not maintained during the initial climb. A proper touchdown point was not attained, the pilot's lack of familiarity with the geographic area and trees were factors.Jun 12, 2003 · N104CA · Substantial damageNTSB SEA03FA096Accident · 1 fatalField investigationFinal reportAviat A-1A · Sandpoint, IDThe pilot's failure to maintain adequate airspeed during a low pass maneuver which resulted in a stall. A related factor was the trees.Jun 8, 2003 · N141F · Substantial damageNTSB SEA03FA092Accident · 1 fatalField investigationFinal reportCessna 180H · Yellow Pine, IDThe pilot's failure to maintain clearance while maneuvering. Trees, a box canyon and rising terrain were factors.May 25, 2003 · N767 · Substantial damageNTSB SEA03FA045Accident · 3 fatalField investigationFinal reportCessna 501 · Carey, IDPilot incapacitation for unknown reasons.Mar 15, 2003 · N70FJ · DestroyedNTSB SEA03FA042Accident · 4 fatalField investigationFinal reportPiper PA-34-220T · Rexburg, IDThe pilot's failure to maintain aircraft control while on final approach. High and gusting winds were a factor.Mar 5, 2003 · N9257X · Destroyed