NTSB investigations, FL
242 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 16 |
|---|---|
| 1983 | 10 |
| 1984 | 12 |
| 1985 | 3 |
| 1986 | 7 |
| 1987 | 16 |
| 1988 | 12 |
| 1989 | 9 |
| 1990 | 6 |
| 1991 | 4 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 11 |
| 1995 | 8 |
| 1996 | 11 |
| 1997 | 11 |
| 1998 | 12 |
| 1999 | 10 |
| 2000 | 8 |
| 2001 | 9 |
| 2002 | 6 |
| 2003 | 6 |
| 2004 | 7 |
| 2005 | 18 |
| 2006 | 13 |
| 2007 | 7 |
Where
Open the mapLatest 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 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.
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 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB NYC07CA224Accident · Minor injuriesData collectionFinal reportPiper PA-28R-200 · Tampa, FLThe pilot's misjudged altitude/distance, which resulted in a hard landing, prior to the runway.NTSB MIA07CA143Accident · Minor injuriesData collectionFinal reportCessna 172N · Carrabelle, FLThe improper flare by the pilot-in-command resulting in a hard landing.NTSB ATL07CA121Accident · No injuriesData collectionFinal reportBeech BE-76 · Pompano Beach, FLThe pilot's improper flare resulting in a hard landing. A factor in the accident was the certified flight instructor's inadequate supervision.NTSB SEA07CA207Accident · No injuriesData collectionFinal reportCessna 172S · Pahokee, FLThe student pilot's improper flare during the landing which resulted in a hard landing. The student pilot's failure to relinquish control of the aircraft, the flight instructors inadequate supervision and not being able to recover control of the aircraft from…NTSB NYC07CA112Accident · No injuriesData collectionFinal reportCessna 172SP · Daytona Beach, FLThe pilot's improper flare at night, which resulted in a hard landing. A factor in the accident was the pilot's lack of recent night experience.NTSB NYC07CA108Accident · No injuriesData collectionFinal reportPiper PA28R-201 · Leesburg, FLThe flight instructor's failure to take remedial action, and the private pilot's failure to maintain proper airspeed, which resulted in a hard landing.NTSB ATL07LA033Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Wauchula, FLThe pilot's improper flare which resulted in a hard landing and overload failure of the right landing gear strut.NTSB MIA07CA019Accident · No injuriesData collectionFinal reportCessna 172S · New Smyrna, FLThe student pilot's improper recovery from a bounced landing.NTSB MIA07CA012Accident · No injuriesData collectionFinal reportAmerican AA-1 · Lakeland, FLThe pilot's misjudgment of the landing flare/touchdown which resulted in a hard landing.NTSB MIA07CA008Accident · No injuriesData collectionFinal reportCessna 172S · Ormond Beach, FLThe failure of the student pilot to initiate a recovery from the bounced landing resulting in a hard landing.NTSB SEA06LA193Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLThe student pilot's improper recovery from a bounced landing.NTSB MIA06CA112Accident · No injuriesData collectionFinal reportCessna 150L · Crystal River, FLThe student pilot's improper recovery from a bounced landing.NTSB ANC06LA102Accident · Serious injuriesLimited investigationFinal reportLiberty XL2 · Ormond Beach, FLThe pilot's improper recovery from a bounced landing, and failure to maintain minimum airspeed during the subsequent aborted landing, which resulted in an inadvertent stall and impact with terrain. A factor associated with the accident was the inadvertent…NTSB MIA06CA113Accident · No injuriesData collectionFinal reportCessna 172R · Kissimmee, FLThe pilot's improper flare.NTSB ANC06CA057Accident · No injuriesData collectionFinal reportRobinson R-44 · Indiantown, FLA hard landing and subsequent nose down when the helicopter pilot misjudged the landing flare during a touchdown autorotation.NTSB MIA06CA101Accident · No injuriesData collectionFinal reportCessna 172N · Miami, FLThe improper flare by the pilot resulting in a hard landing and substantial damage to the airplane.NTSB MIA06CA084Accident · No injuriesData collectionFinal reportLinwood R. Lawrence Van's Aircraft RV-9A · Venice, FLThe pilot's improper landing flare/touchdown which resulted in a hard landing and damage to the airplane.NTSB MIA06CA081Accident · No injuriesData collectionFinal reportWoolley John A Lancair 320 · Lakeland, FLThe pilot's improper landing flare/touchdown which resulted in a hard landing and damage to the airplane.NTSB MIA06CA088Accident · No injuriesData collectionFinal reportCessna 172N · Daytona Beach, FLThe pilot's improper landing flare/touchdown, which resulted in the airplane porpoising and incurring damage.NTSB MIA06CA046Accident · No injuriesData collectionFinal reportPiper PA-46/Jetprop · Tampa, FLThe pilot's improper flare.NTSB MIA06CA014Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe pilots inadequate landing flare/touchdown which resulted in a hard landing.NTSB MIA06CA013Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe pilot-in-command's improper flare during a practice autorotative landing, which resulted in a hard landing.NTSB MIA06CA012Accident · No injuriesData collectionFinal reportCessna 152 · Titusville, FLThe student pilot's inadequate recovery from a bounced landing resulting in substantial damage to the airplane.NTSB MIA05CA160Accident · No injuriesData collectionFinal reportBell 206B3 · Titusville, FLThe flight instructor's improper flare resulting in a hard landing and main rotor contact with tail boom.NTSB MIA05LA148Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Lantana, FLThe CFI's delayed remedial action to recover from a practice autorotation with planned power recovery resulting in a hard landing.NTSB MIA05CA142Accident · No injuriesData collectionFinal reportCessna 172R · Daytona Beach, FLThe student pilot's improper flare and recovery from a bounced landing.NTSB ATL05CA114Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Daytona Beach, FLThe private pilots improper landing flare. Factors were flight instructors inadequate supervision, and landing crosswind.NTSB MIA05CA120Accident · No injuriesData collectionFinal reportCessna 172R · Fort Myers, FLThe pilot's improper landing flare which resulted in a hard landing.NTSB MIA05CA114Accident · No injuriesData collectionFinal reportBeech F33A · Cedar key, FLThe pilots improper landing flare/touchdown, which resulted in a hard landing, and damage to the airplane.NTSB MIA05CA109Accident · No injuriesData collectionFinal reportCessna 172R · Daytona Beach, FLThe student pilot's improper landing flare and the CFI's inadequate supervision resulting in a hard landing and damage to the airplane.NTSB MIA05CA121Accident · No injuriesData collectionFinal reportCessna 172SP · Clearwater, FLThe pilot's improper flare and recovery from a bounced landing.NTSB MIA05CA092Accident · No injuriesData collectionFinal reportCessna 337 B · Ocala, FLThe pilot's improper landing flare during an aborted takeoff, which resulted in a hard landing and damage to the airplane.NTSB MIA05CA091Accident · No injuriesData collectionFinal reportCessna 172 · Kissimmee, FLThe pilot's improper recovery from a bounced landing resulting in a hard landing and damage to the airplane.NTSB MIA05CA072Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Opa Locka, FLThe dual student's improper descent rate during a simulated engine failure and simulated forced landing and the CFI's inadequate remedial action which resulted in a hard landing.NTSB MIA05CA067Accident · No injuriesData collectionFinal reportCessna 172 · Jacksonville, FLThe pilot's improper landing flare which resulted in a hard landing.NTSB MIA05CA061Accident · No injuriesData collectionFinal reportCessna 172 · Brooksville, FLThe pilot's improper landing flare which resulted in substantial damage during the subsequent hard landing.NTSB ANC05CA031Accident · Minor injuriesData collectionFinal reportDickson RV-7A · Panacea, FLThe pilot's misjudged landing flare, which resulted in a hard landing, the collapse of the nose gear, and subsequent nose over.NTSB MIA05CA054Accident · No injuriesData collectionFinal reportCessna 182S · Punta Gorda, FLThe pilot's improper flare resulting in a hard landing and subsequent damage to the firewall.NTSB MIA05LA027Accident · No injuriesLimited investigationFinal reportCessna 170A · Opa Locka, FLThe pilot's improper landing flare/touchdown, which resulted in a hard landing.NTSB MIA05CA039Accident · No injuriesData collectionFinal reportRobinson R-22 · Daytona Beach, FLThe improper landing flare by an unknown pilot at an unknown time resulting in a hard landing and substantial damage to the helicopters tailcone.NTSB MIA05CA002Accident · Minor injuriesData collectionFinal reportRobinson R-22 · Pompano Beach, FLThe flight crew's excessive descent rate during landing, resulting in a hard landing, and the tail boom being severed.NTSB MIA04LA136Accident · No injuriesLimited investigationFinal reportCessna 182 · Naples, FLThe dual student's improper landing flare and the pilot-in-command/CFI's inadequate supervision resulting in a hard landing.NTSB ATL04CA113Accident · No injuriesData collectionFinal reportCessna 172N · Odessa, FLThe pilot's improper landing flare that resulted in a hard landing.NTSB ANC04LA029Accident · No injuriesLimited investigationFinal reportCessna 172P · Lutz, FLThe student pilot's misjudged landing flare, which resulted in a hard landing and subsequent collapse of the nose landing gear.NTSB ANC04LA028Accident · No injuriesLimited investigationFinal reportCessna 172P · Clewiston, FLThe student pilot's misjudged landing flare, which resulted in a hard landing, a collapse of the nose wheel landing gear, and the airplane nosing over when it encountered a ditch.NTSB MIA04CA028Accident · No injuriesData collectionFinal reportCessna 172S · Orlando, FLThe student pilots improper landing flare and his improper recovery from a bounced landing resulting in a hard landing and damage to the airplane.NTSB MIA04CA025Accident · No injuriesData collectionFinal reportCessna 152 · Ormond Beach, FLThe student pilot improper recovery from a bounced landing, which resulted in a hard landing and damage to the airplane.NTSB MIA04CA003Accident · No injuriesData collectionFinal reportWilliam F. Lair RV-6A · Fort Myers, FLThe pilot in command's improper recovery from a bounced landing, which resulted in a hard landing and damage to the airplane.NTSB MIA03LA166Accident · Minor injuriesLimited investigationFinal reportRobinson Robinson R22 Beta · Odessa, FLThe failure of the pilot to maintain the proper airspeed during the practice 180-degree autorotational landing and his failure to maintain main rotor rpm resulting in a hard landing. A contributing factor in the accident was the delay by the designated pilot…NTSB MIA03CA125Accident · No injuriesData collectionFinal reportCessna 172S · Melbourne, FLThe pilot's improper flare and inadequate recovery from a bounced landing. Contributing factors were the pilot's failure to maintain directional control and his failure to execute a go-around.