NTSB investigations, 2018, FL

9 cases where the sequence of events included Abnormal runway contact.

Cases per year

20082026
NTSB investigations, 2018, FL per year, 2008–2026: 130 cases
20084
20094
20107
20115
20123
20135
20149
201513
201611
20175
20189
20198
202011
202110
20224
20236
20242
202510
20264

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\") = 2018
    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\" = '090' 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 GAA19CA040Accident · No injuriesData collectionFinal reportPiper PA28 · Miami, FLThe student pilot's improper landing flare, which resulted in a hard landing.Oct 26, 2018 · N15888 · Substantial damageNTSB GAA18CA450Accident · Minor injuriesData collectionFinal reportRobinson R44 · Lantana, FLThe student pilot’s improper pitch control during landing, which resulted in a dynamic rollover.Jul 27, 2018 · N479AT · Substantial damageNTSB GAA18CA445Accident · No injuriesData collectionFinal reportCirrus SR20 · Sanford, FLThe flight instructor's failure to maintain an appropriate approach speed in crosswind conditions, which resulted in the airplane landing long on the wet runway and his subsequent loss of directional control when he attempted to exit the runway at high speed…Jul 25, 2018 · N482DA · Substantial damageNTSB GAA18CA427Accident · Minor injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot’s inadvertent encounter with thunderstorm conditions and her failure to maintain a proper landing flare in a crosswind, which resulted in a bounced landing.Jul 16, 2018 · N5551L · Substantial damageNTSB GAA18CA348Accident · No injuriesData collectionFinal reportCessna 172 · Orlando, FLThe pilot’s improper landing flare, which resulted in a bounced, hard landing.May 29, 2018 · N497SJ · Substantial damageNTSB GAA18CA292Accident · No injuriesData collectionFinal reportPiper PA28 · Merritt Island, FLThe student pilot’s improper landing flare in tailwind conditions, which resulted in a hard landing.May 11, 2018 · N610FT · Substantial damageNTSB GAA18CA261Accident · Minor injuriesData collectionFinal reportZenair CH 2000 · Naples, FLThe student pilot’s improper landing flare, which resulted in a bounced landing.May 7, 2018 · N699ZA · Substantial damageNTSB GAA18CA151Accident · No injuriesData collectionFinal reportCessna 172 · Lakeland, FLThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a bounced landing.Mar 7, 2018 · N2221R · Substantial damageNTSB GAA18CA174Accident · No injuriesData collectionFinal reportCessna P210 · Jacksonville, FLThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were pilot fatigue and his failure to use the before landing checklist.Feb 20, 2018 · N81MT · Substantial damage