NTSB investigations, 2010, FL

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

Cases per year

20082026
NTSB investigations, 2010, 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\") = 2010
    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 ERA11CA030Accident · Minor injuriesData collectionFinal reportCirrus SR20 · Sanford, FLThe student pilot's loss of directional control during a go-around maneuver following a bounced landing.Oct 21, 2010 · N495DA · Substantial damageNTSB ERA11CA029Accident · No injuriesData collectionFinal reportSqueglia R/Wheeler W Hummel Bird · Hollywood, FLThe pilot's inadequate flare, which resulted in a hard landing.Oct 18, 2010 · N824RS · Substantial damageNTSB ERA10TA481Accident · No injuriesFinal reportPiper PA-34-200T · Inverness, FLThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the nose landing gear.Sep 15, 2010 · N2872S · Substantial damageNTSB ERA10CA249Accident · No injuriesData collectionFinal reportCessna 152 · Cross City, FLThe pilot's inadequate compensation for the crosswind condition resulting in the loss of directional control while landing.Apr 28, 2010 · N49007 · Substantial damageNTSB ERA10LA235Accident · No injuriesLimited investigationFinal reportCessna 152 · Avon Park, FLThe operator's failure to correct known deficiencies with the carburetor, which resulted in a complete loss of engine power and subsequent forced landing by the pilot. Also causal was the operator's decision to rent the airplane in an unairworthy condition.Apr 18, 2010 · N5499B · Substantial damageNTSB ERA10CA234Accident · No injuriesData collectionFinal reportKramer Clemens E Stol CH750 · Lakeland, FLThe pilot's improper flare, which resulted in a nosegear collapse during landing.Apr 16, 2010 · N148CK · Substantial damageNTSB ERA10LA135Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Indiantown, FLThe pilot's improper landing flare, which resulted in damage to the nose landing gear and the airplane nosing over.Feb 6, 2010 · N155ZS · Substantial damage