Fatal NTSB investigations, 2008

11 cases where the sequence of events included Sys/Comp malf/fail (non-power).

Cases per year

20082026
Fatal NTSB investigations, 2008 per year, 2008–2026: 76 cases
200811
20092
20103
20115
20127
20143
20153
20166
20173
20182
20194
20205
20216
20226
20235
20242
20252
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\" = '330' 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 CEN09FA098Accident · 2 fatalField investigationFinal reportPiper PA-46 · Hayden, COThe pilot's loss of situational awareness while maneuvering in adverse weather conditions, resulting in spatial disorientation.Dec 22, 2008 · N46SB · DestroyedNTSB WPR09LA016Accident · 1 fatalLimited investigationFinal reportHeisler Lancair Legacy · Parowan, UTThe pilot failed to secure the canopy prior to takeoff, resulting in his inability to control the aircraft during the takeoff. Contributing to the accident was the pilot’s impairment from prescription medications and possible obstructive sleep apnea.Oct 18, 2008 · N151HT · Substantial damageNTSB DCA08MA098Accident · 4 fatalClass 1 · MajorFinal reportLearjet LR60 · Columbia, SCThe operator’s inadequate maintenance of the airplane’s tires, which resulted in multiple tire failures during takeoff roll due to severe underinflation, and the captain’s execution of a rejected takeoff (RTO) after V1, which was inconsistent with her…Sep 20, 2008 · N999LJ · DestroyedNTSB NYC08FA307Accident · 1 fatalField investigationFinal reportLindstrand Balloons 150A · Phoenixville, PAThe separation of a portion of a fuel fitting during a hard landing resulting in release of fuel and a fire in the balloons basket area. Contributing to the accident was the pilot's failure to follow the manufacturer's published procedures to shut down the…Sep 7, 2008 · N844LB · Substantial damageNTSB CHI08LA272Accident · 1 fatalLimited investigationFinal reportSocata TB-20 Trinidad · Cassville, WIThe left seat pilot's failure to maintain control of the airplane during a go-around and the inadvertent in-flight opening of the cabin door for undetermined reasons. Contributing to the accident was the distraction of the door opening.Sep 3, 2008 · N597TB · Substantial damageNTSB CHI08FA269Accident · 3 fatalField investigationFinal reportBell 206L-1 · Greensburg, INThe in-flight separation of a main rotor blade due to a fatigue failure of the blade spar, rendering the helicopter uncontrollable, and the manufacturer's production of main rotor blades with latent manufacturing defects, which precipitated the fatigue…Aug 31, 2008 · N37AE · DestroyedNTSB LAX08FA286Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Las Vegas, NVA loss of power in the right engine due to an in-flight fuel-fed fire in the right engine compartment that, while the exact origin could not be determined, was likely related to the right engine-driven fuel pump, its fuel supply line, or fitting. Contributing…Aug 28, 2008 · N212HB · Substantial damageNTSB DFW08LA206Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7-15 · Mountain Grove, MOAn on-board fire following a propane leak. Contributing to the accident was the lack of training/experience of the non-certificated pilot.Aug 17, 2008 · N90897 · Substantial damageNTSB DFW08LA097Accident · 1 fatalLimited investigationFinal reportRaytheon B200 · Taylor, TXThe failure of the pilot and mechanic to ensure that the airplane was depressurized prior to actuating the door. Contributing to the accident was the failure of the vacuum system.Apr 10, 2008 · N300FL · Minor damageNTSB LAX08LA063Accident · 1 fatalLimited investigationFinal reportWilson RV-7 · Nevada City, CAThe improper installation of the fuel pump, leading to a fatigue failure of the pump's lever arm and subsequent loss of engine power. Contributing to the accident was the lack of suitable terrain for a forced landing.Feb 18, 2008 · N331KM · Substantial damageNTSB ANC08MA038Accident · 6 fatalMajor investigationFinal reportPiper PA-31-350 · Kodiak, AKThe failure of company maintenance personnel to ensure that the airplane's nose baggage door latching mechanism was properly configured and maintained, resulting in an inadvertent opening of the nose baggage door in flight. Contributing to the accident were…Jan 5, 2008 · N509FN · Substantial damage