NTSB investigations, 2022, FL

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

Cases per year

20082026
NTSB investigations, 2022, 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\") = 2022
    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 ERA23FA060Accident · 1 fatalClass 3 · FieldFinal reportDetrick Donald G Detrick DA-2 · Oak Hill, FLThe student pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with a tree.Nov 15, 2022 · N4307Q · Substantial damageNTSB ERA23LA015Accident · Minor injuriesClass 4 · LimitedFinal reportST Clair David L Tango 2 · Yulee, FLThe pilot’s improper landing flare which resulted in a hard, bounced landing that damaged the nose landing gear, resulting in an inability to maintain directional control and subsequent runway excursion.Oct 9, 2022 · N55XT · Substantial damageNTSB ERA22LA247Accident · No injuriesClass 3 · LimitedFinal reportCessna 150F · Jacksonville, FLThe pilot’s failure to maintain directional control during a touch-and-go landing after applying power for takeoff, which resulted in a runway excursion and noseover.May 29, 2022 · N8919S · Substantial damageNTSB ERA22LA205Accident · No injuriesClass 4 · LimitedFinal reportMaule MX7 · Tampa, FLThe pilot’s failure to maintain directional control during the landing roll.Apr 25, 2022 · N4278B · Substantial damageNTSB ERA22LA165Accident · Minor injuriesClass 4 · LimitedFinal reportNordquist Richard A Vans RV7 · Polk City, FLA loss of control during landing due to the loose and uneven landing surface.Mar 17, 2022 · N275PL · Substantial damageNTSB ERA22LA134Accident · Minor injuriesClass 3 · LimitedFinal reportSpangenberg AR-1KC · Sarasota, FLThe pilot’s improper control input during an aborted takeoff procedure, which resulted in a main rotor blade contacting the vertical stabilizer, a loss of control, and subsequent runway excursion.Feb 20, 2022 · N65PC · Substantial damageNTSB ERA22LA437Accident · No injuriesClass 4 · LimitedFinal reportWhiting Cleon Glasair SH-2 · Palmetto, FLThe pilot’s loss of directional control during takeoff roll.Jan 20, 2022 · N5125X · Substantial damage