NTSB investigations, 2008, FL

5 cases where the sequence of events included Ground collision.

Cases per year

20082026
NTSB investigations, 2008, FL per year, 2008–2026: 52 cases
20085
20091
20102
20113
20122
20135
20141
20157
20164
20171
20182
20194
20203
20222
20242
20254
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.\"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\" = '200' 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 ERA09CA095Accident · No injuriesData collectionFinal reportBeech C23 · Panacea, FLA loss of engine power due to a failure of the mixture control cable housing attachment.Dec 8, 2008 · N60410 · 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 MIA08CA074Accident · No injuriesData collectionFinal reportCessna 525B · Stuart, FLThe flight crew's failure to reset the brakes circuit breaker resulting in a loss of brakes during taxi and an on ground collision with an unoccupied parked airplane.Mar 8, 2008 · N400GG · Substantial damageNTSB MIA08FA070Accident · 3 fatalField investigationFinal reportUlrich Christen Velocity XL RG · Titusville, FLThe pilot of the Velocity’s failure to see and avoid the flight of four RV-8s that had landed and were in the process of clearing the runway.Mar 1, 2008 · N244CU · 2 aircraft · DestroyedNTSB NYC08LA091Accident · Minor injuriesLimited investigationFinal reportNorth American Rockwell NA-265-80 · Ft. Lauderdale, FLThe depletion of pressure in the normal hydraulic system for an undetermined reason, and the pilots' failure to properly operate the emergency braking system. Contributing to the accident was an inoperative hydraulic system aural warning.Feb 1, 2008 · N3RP · Substantial damage