NTSB investigations, 2003, PA
3 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 6 |
| 1984 | 7 |
| 1985 | 3 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 7 |
| 1990 | 7 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 1 |
| 1999 | 3 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 2 |
| 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\" = 'PA' 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" = 'PA' 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 IAD04CA004Accident · No injuriesData collectionFinal reportBeech BE-55 · E. Stroudsburg, PAThe pilot's improper flare, which resulted in a hard landing and collapse of the nose landing gear.NTSB NYC03CA185Accident · Minor injuriesData collectionFinal reportCessna 172E · Lemont Furnace, PAThe pilot's improper bounced landing recovery. A factor was the pilot's inadequate flare during the initial touchdown.NTSB IAD03LA051Accident · No injuriesLimited investigationFinal reportBell 47G · Lehighton, PAThe student pilot's improper flare, which resulted in a hard landing, and his continued flight operations with a known discrepancy.