NTSB investigations, 2000, FL
8 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
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.
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
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 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.NTSB ATL00LA090Accident · No injuriesLimited investigationFinal reportJack McDaniel Rans S12XL · Homestead, FLThe pilot's improper flare during landing which collapsed the landing gear.NTSB MIA00LA254Accident · No injuriesLimited investigationFinal reportBeech D-45 · Jacksonville, FLthe pilot's improper landing flare which resulted the right wing dropping and impacting the runway.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.