Fatal NTSB investigations, 2008

5 cases where the sequence of events included Altitude deviation.

Cases per year

20082026
Fatal NTSB investigations, 2008 per year, 2008–2026: 43 cases
20085
20091
20102
20113
20124
20131
20145
20153
20166
20171
20183
20191
20211
20222
20233
20241
20261

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\" = '282' 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 CEN09WA082Accident · 2 fatalForeign investigationLearjet Lear 23 · Tlaxcala, MexicoOn December 7, 2008 at approximately 1815 central standard time (CST) a twin-engine turbo fan, Learjet 23, Mexican Registration XC-LGD, was destroyed when it impacted a lake while on final approach to an unlit day visual flight rules airport near Tlaxcala,…Dec 8, 2008 · XC-LGD · Substantial damageNTSB ERA09FA060Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Smithfield, RIThe pilot's improper descent below the published minimum descent altitude during the approach, which resulted in controlled flight into terrain.Nov 17, 2008 · N2316P · Substantial damageNTSB MIA08MA203Accident · 4 fatalClass 1 · MajorFinal reportAerospatiale SA365N-1 D · District Heights, MDThe pilot's attempt to regain visual conditions by performing a rapid descent and his failure to arrest the descent at the minimum descent altitude during a nonprecision approach. Contributing to the accident were (1) the pilot’s limited recent instrument…Sep 28, 2008 · N92MD · Substantial damageNTSB NYC08FA157Accident · 2 fatalField investigationFinal reportCartwright H Jr/Cottrell M RV-10 · Seale, ALThe pilot-in-command's in-flight loss of control due to spatial disorientation. Contributing to the accident were the weather conditions and the pilot-in-command's lack of flight experience in the accident airplane.Apr 7, 2008 · N210HM · DestroyedNTSB NYC08MA090Accident · 6 fatalMajor investigationFinal reportRaytheon C90A · Mount Airy, NCThe pilot's failure to maintain control of the airplane in instrument meteorological conditions. Contributing to the accident were the pilot's improper decision to descend below the minimum descent altitude, and failure to follow the published missed approach…Feb 1, 2008 · N57WR · Substantial damage