NTSB investigations, 2008, FL

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

Cases per year

20082026
NTSB investigations, 2008, FL per year, 2008–2026: 335 cases
200812
200928
201019
201122
201225
201322
201422
201521
201621
201717
201818
201919
20208
202116
202216
20238
202420
202518
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\") = 2008
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    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 ERA09LA109Accident · No injuriesLimited investigationFinal reportMichel Paul John Murphy Rebel · Live Oak, FLA partial loss of engine power for undetermined reasons.Dec 27, 2008 · N616PM · Substantial damageNTSB ERA09LA081Accident · No injuriesLimited investigationFinal reportMerrell Stephen F1 Rocket · Sebastian, FLA loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel selector valve.Dec 7, 2008 · N757SM · Substantial damageNTSB ERA09CA097Accident · Serious injuriesData collectionFinal reportMiller Long EZ/XP · Wauchula, FLA total loss of engine power for undetermined reasons.Dec 7, 2008 · N6KD · Substantial damageNTSB ERA09LA047Accident · Minor injuriesLimited investigationFinal reportBell 206B · Boynton Beach, FLA loss of engine power due to an undertorqued air line fitting to the fuel control.Nov 11, 2008 · N281CB · Substantial damageNTSB ERA09LA001Accident · Serious injuriesLimited investigationFinal reportBezinque Alisport-Silent · Vero Beach, FLThe failure of the electric fuel boost pump which resulted in a loss of engine power due to fuel starvation.Oct 1, 2008 · N373DB · Substantial damageNTSB NYC08CA297Accident · No injuriesData collectionFinal reportErcoupe 415-C · Sebring, FLA bird strike which substantially damaged the propeller and required the engine to be secured. Contributing to the accident was the damaged propeller.Aug 29, 2008 · N87376 · Substantial damageNTSB NYC08LA255Accident · Serious injuriesLimited investigationFinal reportCessna 402B · Ocean Ridge, FLA partial loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s decision to add only a limited amount of fuel prior to the flight, and the fuel selector valve placards' inaccurate depiction of the airplane fuel tank…Jul 22, 2008 · N3990C · Substantial damageNTSB MIA08LA125Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe failure of the No. 3 connecting rod cap due to oil starvation. Contributing to the accident was the contamination of the engine oil.Jun 22, 2008 · N757HA · Substantial damageNTSB CHI08LA104Accident · No injuriesLimited investigationFinal reportVic Tatelman Baby Belle · Lakeland, FLThe failure of the tailrotor driveshaft hanger bearing and jamming of the tailrotor.Apr 9, 2008 · N6261N · Substantial damageNTSB NYC08LA106Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Pahokee, FLThe pilot's decision to depart with a known deficiency with the engine, which resulted in a loss of engine power. Contributing to the accident was the loss of engine power due to the failure of the engine-driven fuel pump.Feb 20, 2008 · N36GJ · Substantial damageNTSB MIA08LA043Accident · No injuriesLimited investigationFinal reportCessna U206F · Kissimmee, FLThe probable cause of this accident is undetermined.Jan 20, 2008 · N8JZ · Substantial damageNTSB NYC08LA077Accident · No injuriesLimited investigationFinal reportBell 407 · DeLand, FLA total loss of engine power due to the fatigue failure of a third stage turbine wheel blade.Jan 7, 2008 · N801DS · Substantial damage