NTSB investigations, 2000, FL

8 cases where the first occurrence was “Hard landing”.

Cases per year

19822026
NTSB investigations, 2000, FL per year, 1982–2026: 242 cases
198216
198310
198412
19853
19867
198716
198812
19899
19906
19914
19925
19935
199411
19958
199611
199711
199812
199910
20008
20019
20026
20036
20047
200518
200613
20077

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\") = 2000
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200)
  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 ATL01LA005Accident · Serious injuriesLimited investigationFinal reportAlvin R. Kemmet Tango 2 · New Port Richey, FLThe uncertified pilot's improper recovery from a bounced landing which resulted in the collapse of the nose gear asasembly and subsequent nose over. Factors were the pilot's lack of certification and the runway light.Oct 2, 2000 · N29AK · Substantial damageNTSB ATL00LA090Accident · No injuriesLimited investigationFinal reportJack McDaniel Rans S12XL · Homestead, FLThe pilot's improper flare during landing which collapsed the landing gear.Sep 9, 2000 · N823S · Substantial damageNTSB MIA00LA254Accident · No injuriesLimited investigationFinal reportBeech D-45 · Jacksonville, FLthe pilot's improper landing flare which resulted the right wing dropping and impacting the runway.Aug 26, 2000 · N20685 · Substantial damageNTSB MIA00LA248Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Niceville, FLThe pilots failure to drop the advertising banner prior to a precautionary landing resulting in the aircraft stalling and landing hard. Contributing to the accident was the pilots failure to maintain airspeed during climb after banner pickup resulting in the…Aug 25, 2000 · N57648 · Substantial damageNTSB MIA00LA192Accident · No injuriesLimited investigationFinal reportEuropa Europa XS TRI-GEAR · Lakeland, FLthe flight instructor's inadequate supervision that resulted in the dual student performing an improper landing flare/touchdown which resulted in a hard landing and overload to the nose landing gear assembly.Jun 28, 2000 · N912EA · Substantial damageNTSB ATL00LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marco Island, FLThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a nose over.May 2, 2000 · N1449T · Substantial damageNTSB MIA00LA136Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Immokalee, FLthe pilot misjudged the flare resulting in a hard landing short of the intended landing site, subsequently impacting the ground, and nosing over.Apr 16, 2000 · N238DM · Substantial damageNTSB MIA00LA110Accident · Minor injuriesLimited investigationFinal reportAeronca-Bubeck Irving BUBECK-AERONCA · Merritt Island, FLThe flight instructors inadequate supervision of the dual student resulting in the student pushing forward on the control stick during a bounced landing until the aircraft impacted the runway, bounced, landed hard, and broke the main landing gear.Mar 17, 2000 · N6030T · Substantial damage