NTSB investigations, 2003, GA
3 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 7 |
| 1984 | 8 |
| 1985 | 7 |
| 1986 | 5 |
| 1987 | 9 |
| 1988 | 7 |
| 1989 | 5 |
| 1990 | 2 |
| 1991 | 8 |
| 1992 | 6 |
| 1993 | 3 |
| 1994 | 7 |
| 1995 | 4 |
| 1996 | 7 |
| 1997 | 4 |
| 1998 | 7 |
| 1999 | 3 |
| 2000 | 6 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 5 |
| 2005 | 4 |
| 2006 | 4 |
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\" = 220)
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" = 220) 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 ATL04LA050Accident · Minor injuriesLimited investigationFinal reportBaker KR-2 · St. Marys, GAThe pilot's failure to maintain airspeed during climb out which resulted in a stall and inflight collision with trees.NTSB ATL04FA045Accident · 2 fatalField investigationFinal reportBeech B200 · Morlan, GAThe pilot's inadequate in-flight planning/decision when he continued the flight below the decision height and collided with trees. A related factor was the low ceiling.NTSB ATL03FA055Accident · 1 fatalField investigationFinal reportBeech A-36 · Milledgeville, GAThe pilot's improper IFR procedure by which he failed to maintain the minimum descent altitude, and his failure to maintain obstacle clearance. A factor was low the ceiling.