NTSB investigations, 2003, IL
7 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 10 |
| 1984 | 8 |
| 1985 | 4 |
| 1986 | 5 |
| 1987 | 3 |
| 1988 | 7 |
| 1989 | 5 |
| 1990 | 7 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 2 |
| 1994 | 6 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 2 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 7 |
| 2004 | 4 |
| 2005 | 3 |
| 2006 | 2 |
| 2007 | 3 |
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 year(c.\"eventDate\") = 2003
AND c.\"eventStateOrRegion\" = 'IL' 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" = 'IL' 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 CHI03LA209Accident · No injuriesLimited investigationFinal reportYoung Cozy MkIV · Quincy, ILThe pilot's improper flare.NTSB CHI03LA260Accident · No injuriesLimited investigationFinal reportCessna 172L · Harvard, ILThe pilot's improper flare which led to a hard landing.NTSB CHI03LA240Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28C · Kankakee, ILThe pilot misjudged flare which led to a hard landing. Contributing to the accident was the pilot's failure to follow procedures/directives when he exceeded the airplane's weight and balance.NTSB CHI03LA143Accident · No injuriesLimited investigationFinal reportMooney M20S · West Chicago, ILThe pilot's improper flare, and the pilot's failure to maintain directional control. Contributing factors were the pilot's improper flare and his inadequate recovery from a bounced landing.NTSB CHI03LA114Accident · No injuriesLimited investigationFinal reportCessna 182T · Marengo, ILThe pilot's improper flare. A factor contributing to the accident was the gusty crosswind.NTSB CHI03LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Carbondale, ILThe pilot failed to properly recover from a bounced landing which resulted in the airplane porpoising.NTSB CHI03LA085Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · West Chicago, ILThe pilot's improper flare resulting in a hard landing.