Fatal NTSB investigations, 2008

13 cases where the sequence of events included Unknown or undetermined.

Cases per year

20082026
Fatal NTSB investigations, 2008 per year, 2008–2026: 1,013 cases
200813
200916
201032
201131
201227
201332
201446
201559
201672
201763
201880
201956
202047
202143
202258
202354
202455
202580
2026149

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\") = 2008
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' 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 ERA09WA113Accident · 12 fatalForeign investigationBritten Norman BN-2A MK III · Turks and Caicos, Turks & Caicos IslandsDec 15, 2008 · N650LP · DestroyedNTSB ERA09WA037Accident · 3 fatalForeign investigationBeech 65A90 · Timehri, GuyanaNov 1, 2008 · N87V · No damageNTSB ERA09WA028Accident · 1 fatalClass 5 · ForeignHawker-Beechcraft 100 · Bauru, BrazilOct 12, 2008 · N525ZS · DestroyedNTSB NYC08WA308Accident · 2 fatalForeign investigationRobinson R-44 · Muzino Village, RussiaSep 6, 2008 · RA-04180 · Substantial damageNTSB DFW08LA220Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20B · Cleburne, TXLoss of control inflight for undetermined reason.Aug 31, 2008 · N30WK · Substantial damageNTSB DFW08WA240Accident · 1 fatalForeign investigationCessna 501 · Las Americas, Dominican RepublicAug 19, 2008 · N223LC · Substantial damageNTSB CHI08FA248Accident · 1 fatalField investigationFinal reportBeech 58TC · Marysville, OHThe pilot's failure to maintain sufficient airspeed during the base to final turn resulting in an aerodynamic stall.Aug 14, 2008 · N715TB · DestroyedNTSB DEN08LA127Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus A · Midlothian, TXThe pilot's inability to maintain aircraft control due to an incapacitating cardiac event. Contributing to the accident was the pilot's poor decision to fly with known serious medical issues.Jul 23, 2008 · N47JD · DestroyedNTSB NYC08FA238Accident · 1 fatalField investigationFinal reportCessna 152 · Rossville, TNUndetermined.Jul 5, 2008 · N5372B · DestroyedNTSB DCA08WA073Accident · 4 fatalForeign investigationCessna 210 · Nairegi Enkera, KenyaOn June 10, 2008, about 1200 UTC, a Cessna 210, registration 5Y-BE, a chartered flight, was en route when it collided with high terrain near Nairegi Enkera, Kenya. The airplane was on a visual flight; instrument meteorological conditions prevailed due to low…Jun 10, 2008 · 5Y-BVE · DestroyedNTSB SEA08LA137Accident · 1 fatalLimited investigationFinal reportNolan RV-4 · Tolani Lake, AZAn in-flight collision with terrain for undetermined reasons.May 25, 2008 · N6290F · Substantial damageNTSB DFW08FA111Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Hemphill, TXA loss of control for undetermined reasons.Apr 22, 2008 · N729SR · DestroyedNTSB CHI08FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 310N · Keflavík, IcelandThe reported loss of both engines' power during cruise for undetermined reasons.Feb 11, 2008 · N5030Q · Substantial damage