NTSB investigations, 2019, FL

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

Cases per year

20082026
NTSB investigations, 2019, 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\") = 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\" = '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 GAA20CA088Accident · Serious injuriesData collectionFinal reportHiggins John H/Williams John D Questair Venture · Daytona Beach, FLThe pilot's unstabilized approach, which resulted in a hard, bounced landing, loss of directional control, and impact with a tree and then terrain.Oct 27, 2019 · N35HW · DestroyedNTSB GAA20CA051Accident · No injuriesData collectionFinal reportPereyra Aventura · Tavares, FLThe pilot's improper landing flare, which resulted in a bounced landing on water, and his failure to maintain airplane control during a go-around, which resulted in the airplane nosing over.Oct 26, 2019 · N170AV · Substantial damageNTSB GAA20CA091Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 · Apopka, FLThe student pilot's improper landing flare, which resulted in a hard, bounced landing and subsequent nose-over.Oct 24, 2019 · N639BV · Substantial damageNTSB GAA19CA556Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe student pilot's improper landing flare, which resulted in a porpoised landing and a nose landing gear collapse.Sep 17, 2019 · N472TC · Substantial damageNTSB GAA19CA431Accident · No injuriesData collectionFinal reportDiamond DA40 · Tavernier, FLThe pilot's delayed decision to go around in high-temperature and high-density altitude conditions and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jul 4, 2019 · N420NG · 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 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 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 damage