Final NTSB investigations, FL

8 cases where the defining event was Dragged wing/rotor/float/other.

Cases per year

20082026
Final NTSB investigations, FL per year, 2008–2026: 8 cases
20082
20091
20101
20143
20221

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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '093')
  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 ERA22LA293Accident · No injuriesClass 4 · LimitedFinal reportCrawford James R MU-582 Drifter · Seminole, FLThe pilot’s failure to maintain control of the airplane during landing flare.Jun 19, 2022 · N2628E · Substantial damageNTSB ERA14CA166Accident · No injuriesData collectionFinal reportWaco UIC · Saint Petersburg, FLThe pilot's inadequate compensation for the wind conditions during landing.Mar 23, 2014 · N13562 · Substantial damageNTSB ERA14CA155Accident · No injuriesData collectionFinal reportCessna 172M · Brooksville, FLThe pilot's failure to compensate for the reported crosswind conditions resulting in the wings contacting the ground.Mar 14, 2014 · N80457 · Substantial damageNTSB ERA14CA136Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lake Wales, FLThe pilot's improper flare during a water landing, which resulted in the wings contacting the water.Feb 24, 2014 · N9563P · Substantial damageNTSB ERA10CA223Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · Moore Haven, FLThe pilot's failure to maintain directional control during a water landing.Apr 7, 2010 · N4GS · Substantial damageNTSB ERA09CA525Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A TWI · Clermont, FLThe flight instructor's delayed remedial action resulting in an off-airfield landing and ground loop.Sep 17, 2009 · N308BG · Substantial damageNTSB MIA08CA201Accident · Serious injuriesData collectionFinal reportCox Clyde H Fshr Aero Vsns Clbty · Tampa, FLThe pilot’s failure to maintain control of the airplane during takeoff due to inadequate maintenance.Sep 25, 2008 · N716HJ · Substantial damageNTSB MIA08LA048Accident · Serious injuriesLimited investigationFinal reportGrumman G-21A · Marathon, FLThe pilot’s failure to maintain control of the airplane during a water landing.Jan 29, 2008 · N21A · Substantial damage