NTSB investigations, 2001, FL

11 cases where the first occurrence was “Loss of control - on ground/water”.

Cases per year

19822026
NTSB investigations, 2001, FL per year, 1982–2026: 316 cases
198211
198312
198412
198516
198617
198715
198812
198915
199010
199110
19924
19938
199414
19959
199610
19978
19989
199911
20008
200111
200217
200314
200412
200514
200623
200714

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\") = 2001
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
  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 ATL02LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lake Wales, FLThe pilot's improper decision to land on a wet sod runway which resulted in a loss of directional control during landing. Factors were the wet grass strip which allowed the airplane to hydroplane.Oct 24, 2001 · N4033W · Substantial damageNTSB MIA02LA002Accident · No injuriesLimited investigationFinal reportCessna 172R · Wauchula, FLthe pilot's failure to maintain directional control of the aircraft while attempting to take off after executing a touch-and-go landing, in gusty wind conditions, which resulted in a ground swerve, and the aircraft exiting the runway, and incurring…Oct 1, 2001 · N851CP · Substantial damageNTSB MIA01LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Melbourne, FLthe pilot's failure to maintain directional control of the aircraft during the landing rollout while landing in gusty crosswind conditions, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial damage when it…Sep 30, 2001 · N5447F · Substantial damageNTSB MIA01LA124Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Destin, FLfailure of the flight instructor to maintain directional control of the aircraft during the landing rollout while landing with a crosswind in gusty conditions, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial…Apr 17, 2001 · N1364N · Substantial damageNTSB MIA01LA118Accident · No injuriesLimited investigationFinal reportCessna 172R · Ormond Beach, FLthe flight instructor's inadequate supervision and the dual student's improper use of brakes which resulted in the loss of directional control and collision with a wind sock. Contributing to the accident was the flight instructor's failure to follow…Apr 9, 2001 · N436ER · Substantial damageNTSB MIA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182Q · Melbourne, FLThe failure of the pilot-in-command to maintain directional control of the airplane during the landing roll of the touch-and-go landing resulting in the on ground collision with a ditch and subsequent separation of the nose gear wheel and fork assembly and…Mar 3, 2001 · N4949N · Substantial damageNTSB MIA01LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student's failure to maintain control of the aircraft during landing due to his improper landing flare height and improper recovery from a bounced landing, resulting in a nose landing gear collapse, and excursion off the runway.Feb 25, 2001 · N942AC · Substantial damageNTSB ATL01LA032Accident · No injuriesLimited investigationFinal reportCessna 208 · Key West, FLThe airplanes' inadvertent collision with a swell during a water landing near a ferry boat that resulted the overload failure of the rear float/strut assembly.Jan 31, 2001 · N208KW · Substantial damageNTSB MIA01LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe student pilot's failure to maintain directional control on landing rollout with a crosswind. This resulted in the airplane departing the runway, colliding with a berm/ridge, becoming airborne, and colliding with the terrain in a nose down attitude.Jan 29, 2001 · N152DF · Substantial damageNTSB ATL01LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLThe pilots failure to maintain directional control during the landing roll, which resulted in the collision with the airport sign.Jan 18, 2001 · N704ZF · Substantial damageNTSB MIA01LA056Accident · Serious injuriesLimited investigationFinal reportMaule MXT-7-180A · Perry, FLThe loss of control on landing due to the student's improper recovery from a bounced landing, and the resulting nose over on the grass runway.Jan 7, 2001 · N40030 · Substantial damage