NTSB investigations, 2003, FL
6 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\") = 2003
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") = 2003 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 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.NTSB MIA03CA041Accident · Serious injuriesData collectionFinal reportCessna 150K · Everglades City, FLThe instructor's failure to maintain airspeed during climb after lift off from an aborted landing, resulting in the airplane stalling, entering a spin, and crashing into water at the departure end of the runway. Contributing to the accident was the…