NTSB investigations, 2003, GA
3 cases where the first occurrence was “Hard landing”.
Cases per year
| 1983 | 5 |
|---|---|
| 1984 | 2 |
| 1985 | 8 |
| 1986 | 1 |
| 1987 | 6 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 3 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 1 |
| 1996 | 4 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 2 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 1 |
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\" = 'GA' 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" = 'GA' 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 ATL04LA062Accident · No injuriesLimited investigationFinal reportCessna 172R · Atlanta, GAThe pilot's improper flare resulting in a hard landing. A factor is lack of total experience.NTSB ATL04LA019Accident · No injuriesLimited investigationFinal reportSpegele Mustang II · Calhoun, GAThe pilot's improper flare which resulted in a hard landing and subsequent landing gear collapse.NTSB ATL03LA095Accident · No injuriesLimited investigationFinal reportAerospatiale AS355F2 · Bainbridge, GAThe pilot's improper flare during an attempted landing.