NTSB investigations, 2019, FL

17 cases where the sequence of events included Loss of control on ground.

Cases per year

20082026
NTSB investigations, 2019, FL per year, 2008–2026: 258 cases
200815
200916
201013
201112
201212
201311
201410
201513
201619
201718
201819
201917
202018
202113
20227
20239
202414
202513
20269

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\") = 2019
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 GAA20CA067Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a taxiway sign.Nov 12, 2019 · N739UA · Substantial damageNTSB ERA20LA037Accident · Serious injuriesClass 3 · LimitedFinal reportMosquito XE · Seffner, FLThe pilot's failure to maintain control of the helicopter while landing, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's lack of helicopter experience.Nov 2, 2019 · UNREG · Substantial damageNTSB GAA20CA050Accident · No injuriesData collectionFinal reportPiper PA 30 · Opa Locka, FLThe pilot receiving instruction's failure to relinquish the flight controls to the flight instructor during a simulated engine failure during takeoff, which resulted in the airplane touching down in a left banking attitude and the landing gear collapsing.Oct 25, 2019 · N8816Y · Substantial damageNTSB GAA19CA580Accident · No injuriesData collectionFinal reportCessna 172 · Plant City, FLThe student pilot's failure to maintain directional control during the aborted landing, which resulted in a runway excursion and impact with a ditch.Sep 23, 2019 · N739RT · Substantial damageNTSB GAA19CA488Accident · No injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot's improper decision to turn off the runway while the airplane was moving too fast after landing, which resulted in a runway excursion and impact with a taxiway sign.Aug 8, 2019 · N65401 · Substantial damageNTSB ERA19TA223Accident · No injuriesClass 3Final reportCessna 180 · Okeechobee, FLThe pilot’s failure to maintain directional while landing with a quartering tailwind, which resulted in a ground loop.Jul 7, 2019 · N52031 · Substantial damageNTSB GAA19CA413Accident · No injuriesData collectionFinal reportCessna 152 · Clewiston, FLThe student pilot's maneuver to the left to avoid striking birds during takeoff and his subsequent loss of directional control after aborting the takeoff and landing on soft, muddy grass adjacent to the runway during, which resulted in a nose-over.Jun 23, 2019 · N5096L · Substantial damageNTSB GAA19CA415Accident · No injuriesData collectionFinal reportCessna 180 · Panama City, FLThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Jun 22, 2019 · N5239D · Substantial damageNTSB GAA19CA362Accident · No injuriesData collectionFinal reportCessna 172 · Tampa, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent nose-over.Jun 14, 2019 · N84402 · Substantial damageNTSB GAA19CA326Accident · No injuriesData collectionFinal reportCessna 172 · Orlando, FLThe student pilot's excessive rudder application during takeoff and the flight instructor's delayed remedial action, which resulted in a loss of directional control, a runway excursion, and subsequent substantial damage.Jun 8, 2019 · N1589D · Substantial damageNTSB ERA19LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Key West, FLThe pilot's decision to attempt a takeoff in rough sea conditions, resulting in damage to the floats and the sinking of the seaplane.Apr 23, 2019 · N366TA · Substantial damageNTSB GAA19CA209Accident · No injuriesData collectionFinal reportBell 206 · Big Pine, FLThe pilot's failure to maintain helicopter control while it was being reloaded with the rotors turning in gusting wind conditions, which resulted in a rotor strike with ground equipment.Apr 12, 2019 · N173MS · Substantial damageNTSB GAA19CA198Accident · No injuriesData collectionFinal reportCessna 195 · Ormond Beach, FLThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the nose landing gear collapsing.Mar 29, 2019 · N195PC · Substantial damageNTSB ERA19TA114Accident · Serious injuriesFinal reportRempe Kitfox · Merritt Island, FLThe pilot's failure to maintain airplane control during an attempted go-around.Mar 2, 2019 · N93XL · Substantial damageNTSB GAA19CA137Accident · No injuriesData collectionFinal reportCessna 172 · Sanford, FLThe student pilot's failure maintain the proper pitch attitude during landing, which resulted in the airplane porpoising.Feb 15, 2019 · N572ND · Substantial damageNTSB GAA19CA121Accident · No injuriesData collectionFinal reportEurocopter AS 350 · Tampa, FLThe pilot's improper landing flare while practicing autorotations, which resulted in a hard, bounced landing.Jan 29, 2019 · N680DG · Substantial damageNTSB GAA19CA122Accident · No injuriesData collectionFinal reportCessna 172 · Miami, FLThe student pilot's failure to control the airplane's speed and direction during the approach, which resulted in landing long, a runway excursion, and impact with a windsock.Jan 19, 2019 · N734AY · Substantial damage