NTSB investigations, FL

9 cases where NTSB found Health/Fitness.

Cases per year

20092026
NTSB investigations, FL per year, 2009–2026: 9 cases
20092
20111
20141
20151
20161
20171
20182

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 c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020130'))
  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 ERA18FA235Accident · 1 fatalField investigationFinal reportAirtime Cygnet · Pensacola, FLThe student pilot's loss of aircraft control for undetermined reasons.Aug 27, 2018 · N186AT · Substantial damageNTSB ERA18FA064Accident · 1 fatalField investigationFinal reportVans RV-12 · Bonita Springs, FLThe pilot's unsafe maneuvering and exceedance of the airplane's operating limitations, which resulted in an in-flight failure of the left wing. Contributing to the accident was the pilot's underlying physiologic or psychiatric disease.Jan 22, 2018 · N262WS · DestroyedNTSB ANC18FA007Accident · 1 fatalField investigationFinal reportIcon A5 · Clearwater, FLThe pilot's improper decision to perform aggressive, low-altitude maneuvers due to his impairment from the use of multiple psychoactive substances, which resulted in a loss of control.Nov 7, 2017 · N922BA · Substantial damageNTSB ERA16FA297Accident · 1 fatalField investigationFinal reportHeberlein Ronald Vans RV 9A · Sebring, FLThe pilot's failure to maintain clearance from terrain.Aug 24, 2016 · N379RV · DestroyedNTSB ERA16FA012Accident · 2 fatalField investigationFinal reportPiper PA 28-180 · Lake Worth, FLA loss of control for reasons that could not be determined based on the available information.Oct 13, 2015 · N57312 · DestroyedNTSB ERA14LA363Accident · 1 fatalLimited investigationFinal reportTemco GC 1B · Yulee, FLThe pilot’s failure to maintain airplane control, which resulted in subsequent impact with terrain.Jul 28, 2014 · N1CY · Substantial damageNTSB ERA12FA130Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Jacksonville, FLThe pilot's in-flight loss of control during climb after a banner pickup. Contributing to the accident was the pilot's impairment due to marijuana.Dec 31, 2011 · N7408Z · Substantial damageNTSB ERA09LA198Accident · 1 fatalLimited investigationFinal reportMcNear Explorer Coupe · Okeechobee, FLThe pilot's failure to maintain directional control of the gyrocopter while taxiing for takeoff.Mar 14, 2009 · N5098L · Substantial damageNTSB ERA09LA188Accident · 2 fatalLimited investigationFinal reportMXR Technologies MX2 · Dade City, FLAn in-flight loss of aircraft control for an undetermined reason.Mar 9, 2009 · N262MX · Substantial damage