NTSB investigations, FL

6 cases where NTSB found Task performance, general.

Cases per year

20092026
NTSB investigations, FL per year, 2009–2026: 6 cases
20091
20132
20141
20242

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\", '020600'))
  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 ERA24LA163Accident · Serious injuriesClass 3 · LimitedFinal reportEvektor-Aerotechnik A S Harmony LSA · Seffner, FLThe improper installation of the fuel line that connected the fuel pump to the four-way distributor, which resulted in fuel starvation when the line became disconnected.Apr 4, 2024 · N469JA · Substantial damageNTSB ERA24LA100Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Orlando, FLThe failure of the pilot flying to maintain directional control after touchdown with wind gusts that exceeded the airplane’s crosswind limitation. Contributing to the accident were the flightcrew’s continued approach to the runway despite the consistent wind…Jan 28, 2024 · N103JT · Substantial damageNTSB ERA14CA420Accident · No injuriesData collectionFinal reportMooney M20K · Vero Beach, FLThe failure of the pilot and personnel from the fixed base operator to assure the correct ground power unit was utilized to provide external power, resulting in damage to the aircraft's electrical wiring and subsequent damage to structure adjacent to the…Aug 23, 2014 · N231MN · Substantial damageNTSB ERA13LA297Accident · Minor injuriesLimited investigationFinal reportBeech G-36 · Pompano Beach, FLThe pilot’s premature rotation during takeoff with a tailwind and his delayed retraction of the landing gear, which reduced the airplane’s climb performance and subsequently led to the collision with power lines.Jun 21, 2013 · N7513 · Substantial damageNTSB ERA13LA248Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Geneva, FLThe passenger’s failure to adhere to the pilot’s instructions to stay away from the front of the airplane when the engine was operating.May 18, 2013 · N4702F · No damageNTSB ERA09LA238Accident · No injuriesLimited investigationFinal reportByron J. Moore Zealot · Clermont, FLA loss of engine power due to oil starvation as a result of the previous owner's improper servicing of the engine oil.Apr 9, 2009 · N61ZT · Substantial damage