Fatal NTSB investigations, 2008

9 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
Fatal NTSB investigations, 2008 per year, 2008–2026: 225 cases
20089
200919
201024
201118
201216
201311
201420
201513
20167
20177
201812
201913
202010
20217
202210
202312
20248
20255
20264

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\" = '440' 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 ERA09FA093Accident · 1 fatalField investigationFinal reportBeech 36 · Louisville, KYThe pilot’s continued operation of the aircraft with known deficiencies. Contributing to this accident was the improper sealing of the engine case during overhaul.Dec 18, 2008 · N7472N · Substantial damageNTSB WPR09LA050Accident · 1 fatalLimited investigationFinal reportBeech A36 · Coalinga, CAThe loss of engine power while in climb to cruise flight for undetermined reasons.Dec 1, 2008 · N3058Y · Substantial damageNTSB CEN09TA060Accident · 1 fatalFinal reportBell OH-58C · Quitman, ARThe pilot’s failure to execute a proper autorotation during a forced landing after a loss of rotor rpm for undetermined reasons.Nov 16, 2008 · N153GF · Substantial damageNTSB WPR09LA022Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Concrete, WAThe loss of engine power during initial climb due to the pilot's improper exhaust system maintenance, which resulted in restriction of the carburetor's air intake.Oct 23, 2008 · N97946 · Substantial damageNTSB ERA09LA025Accident · 1 fatalLimited investigationFinal reportMoses Tim C Quicksilver · Wingate, NCA loss of engine power due to a fractured crankshaft.Oct 21, 2008 · N184GT · Substantial damageNTSB WPR09FA015Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Markleeville, CAA loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s failure to choose a suitable landing area.Oct 16, 2008 · N9581C · Substantial damageNTSB NYC08LA245Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pelham, GAA partial loss of engine power for undetermined reasons which led to a forced landing in unsuitable terrain.Jul 12, 2008 · N7395 · Substantial damageNTSB SEA08MA136Accident · 3 fatalMajor investigationFinal reportAerospatiale AS-350-D · Avalon, CALoss of engine power during approach for landing due to a fatigue fracture of a power turbine blade.May 24, 2008 · N67GE · DestroyedNTSB NYC08FA184Accident · 2 fatalField investigationFinal reportCessna 337A · West Creek, NJThe pilot's departure with insufficient fuel for the planned flight, and his improper in-flight fuel management, which resulted in a total loss of power in both engines due to fuel starvation. Contributing to the accident was the pilot's fatigue, which was…May 17, 2008 · N5382S · Substantial damage