NTSB investigations, 2002, FL

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

Cases per year

19822026
NTSB investigations, 2002, 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\") = 2002
    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 MIA03CA030Accident · No injuriesData collectionFinal reportCessna A150M · Crystal River, FLThe student pilot's improper application of brakes during the landing rollout, which resulted in a loss of directional control and the airplane running off of the runway, impacting a runway light structure, and nosing over.Dec 16, 2002 · N9852J · Substantial damageNTSB MIA03CA026Accident · No injuriesData collectionFinal reportPiper PA38 · Pensacola, FLThe student pilot's attempt to turn off the runway at an excessive taxi speed resulting in a loss of directional control and collision with a taxiway sign.Dec 8, 2002 · N2585B · Substantial damageNTSB ATL03LA005Accident · No injuriesLimited investigationFinal reportCessna 172 · Opa Locka, FLThe pilot' inadequate evaluation of weather information, and the selection of the wrong runway that resulted in an attempted takeoff with a tailwind and the subsequent loss of control during takeoff.Oct 17, 2002 · N903WA · Substantial damageNTSB MIA02LA172Accident · No injuriesLimited investigationFinal reportRonald Levee Kitfox IV · De Land, FLThe failure of the pilot to maintain directional control of the airplane during the flare/touchdown resulting in substantial damage. A factor in the accident was the poor in-flight planning decision by the pilot for his continuing the approach in close…Sep 29, 2002 · N1441Z · Substantial damageNTSB MIA02LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLThe student pilot's failure to maintain control of the airplane during the takeoff roll/run which resulted in the airplane departing the runway and into a ditch where it nosed over incurring substantial damage.Sep 1, 2002 · N68414 · Substantial damageNTSB MIA02LA156Accident · No injuriesLimited investigationFinal reportAviat A1 · Merritt Island, FLThe pilot's failure to maintain directional control during the landing rollout while landing in a crosswind which resulted in the airplane inadvertently veering off the runway and incurring damage when the pilot forced it into a ground loop to avoid entry…Aug 8, 2002 · N13HU · Substantial damageNTSB MIA02LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Hialeah, FLThe failure of the pilot to maintain directional control of the airplane during the takeoff roll resulting in the on-ground collision with a ditch and subsequent nose over of the airplane.Jul 26, 2002 · N4893H · Substantial damageNTSB MIA02LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Okeechobee, FLThe failure of the pilot to maintain directional control of the airplane during the takeoff roll following a short field approach and landing, resulting in the on-ground collision with a fence.Jul 24, 2002 · N9284H · Substantial damageNTSB MIA02LA122Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Jacksonville, FLThe failure of the solo student/owner to maintain directional control of the airplane during takeoff in a crosswind, which resulted in the airplane veering off the runway, a collision with a runway light, and a ground loop.Jul 1, 2002 · N1693A · Substantial damageNTSB ATL02LA126Accident · No injuriesLimited investigationFinal reportCessna 180 · Jacksonville, FLThe pilot's failure to maintain directional control on landing rollout resulting in an inadvertent ground loop. A factor related to the accident was the certified flight instructors inadequate supervision of the training flight.Jun 19, 2002 · N9150C · Substantial damageNTSB ATL02LA118Accident · No injuriesLimited investigationFinal reportCessna 152 · Immokalee, FLThe student pilot's failure to maintain directional control while attempting a touch and go landing resulted in an on-ground collision with a ditch. A factor in this accident was the student pilot's lack of experience.May 29, 2002 · N5224P · Substantial damageNTSB MIA02LA097Accident · No injuriesLimited investigationFinal reportCessna 206H · Sarasota, FLThe pilot's failure to maintain compensation for surface wind conditions resulting in excessive taxi speed, a loss of control while taxiing, an excursion off the taxiway, collision with a concrete pad, and a nose over.May 22, 2002 · N24013 · Substantial damageNTSB ATL02LA080Accident · No injuriesLimited investigationFinal reportCessna 170B · Ocala, FLThe pilot's failure to maintain directional control on landing roll, resulting in a loss of control/ground loop.Apr 8, 2002 · N3470C · Substantial damageNTSB ATL02LA073Accident · No injuriesLimited investigationFinal reportCessna 172P · Pensacola, FLThe pilot's inadequate compensation for a crosswind and his failure to maintain directional control during the landing roll. Contributing to the accident was the pilot's decision to land with a tailwind.Apr 4, 2002 · N64079 · Substantial damageNTSB MIA02LA076Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Crescent City, FLTfhe failure of the pilot to maintain directional control of the aircraft during takeoff roll, resulting in an excursion off the left side of the runway and collision with an adjacent hangar.Apr 2, 2002 · N43615 · Substantial damageNTSB MIA02LA055Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Milton, FLThe inability of the pilot to maintain directional control of the airplane resulting in a ground loop. A finding in the investigation was a loose left rudder flight control cable.Jan 22, 2002 · N41686 · Substantial damageNTSB MIA02LA056Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Sarasota, FLThe poor in-flight planning decision by the pilot-in-command for his failure to request the runway most aligned with the wind and his failure to maintain directional control during the landing roll.Jan 20, 2002 · N235AL · Substantial damage