NTSB investigations, 2015, FL

6 cases where the sequence of events included Windshear or thunderstorm.

Cases per year

20082026
NTSB investigations, 2015, FL per year, 2008–2026: 21 cases
20081
20091
20111
20121
20131
20142
20156
20161
20172
20182
20201
20222

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\") = 2015
    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\" = '390' 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 ERA16LA008Accident · 1 fatalLimited investigationFinal reportCessna 172S · Seville, FLThe airplane’s encounter with a downdraft, and the pilot's decision to maneuver the airplane at a low altitude and airspeed, which provided insufficient time and altitude to recover before impacting terrain.Oct 10, 2015 · N5295Y · Substantial damageNTSB GAA15CA269Accident · No injuriesData collectionFinal reportMooney M20TN · Myakka City, FLThe pilot's failure to maintain directional control during the landing roll in windy conditions, resulting in a runway excursion and collision with a fence.Sep 10, 2015 · N892PS · Substantial damageNTSB ERA15FA325Accident · 1 fatalField investigationFinal reportCessna 310R · Titusville, FLThe pilot's continued flight into known convective weather conditions, which resulted in the airplane's encounter with thunderstorms and the pilot's subsequent loss of airplane control during a missed approach. Contributing to the accident was the failure of…Aug 26, 2015 · N90PS · DestroyedNTSB ERA15LA249Accident · No injuriesLimited investigationFinal reportBeech B 55 · Clearwater, FLThe pilot's delayed completion of the before landing checklist, including the extension of the landing gear, during an approaching thunderstorm, which resulted in a landing with the landing gear in transit and the subsequent collapse of the landing gear.Jun 19, 2015 · N216RW · Substantial damageNTSB ERA15LA161Accident · Serious injuriesLimited investigationFinal reportLanshe Aerospace Lake 250 · Fernandina Beach, FLThe pilot's failure to extend the landing gear during the approach, which resulted in a gear-up landing.Mar 18, 2015 · N99HB · Substantial damageNTSB ERA15CA116Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Deland, FLThe pilot's inadequate preflight weather planning and decision to land in an area with known convective wind gusts, which resulted in a loss of control and subsequent hard landing.Jan 12, 2015 · N5033S · Substantial damage