NTSB investigations, 2000, GA
6 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\") = 2000
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") = 2000 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 ATL00LA078Accident · 1 fatalLimited investigationFinal reportSolo Wings Aquilla · Chatsworth, GAThe pilot's failure to maintain clearance from trees while maneuvering that resulted in the collision with trees and the ground.NTSB MIA00LA226Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Statesboro, GAThe pilots failure to calculate his takeoff distance for the conditions, resulting in an in-flight collision with a fence, trees, and the terrain. A factor in the accident is the FAA's failure to require of the manufacturer and the manufacturer's failure to…NTSB MIA00LA180Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Stockbridge, GAan in-flight collision with trees while maneuvering, which was the result of the pilot not allowing adequate altitude to clear the trees before starting a turn.NTSB MIA00LA145Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Metter, GAthe pilot's failure to maintain an adequate lookout resulting in a collision with a transmission wire that resulted in a forced landing and substantial damage to the helicopter.NTSB ATL00LA036Accident · 2 fatalLimited investigationFinal reportTrike Unknown · Dalton, GAThe pilot's failure to maintain appropriate clearance with objects during final approach to landing. A factor was the tree.NTSB MIA00LA074Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincolnton, GAThe pilot's failure to remove ice from the wings prior to takeoff resulting in the aircraft not climbing after takeoff and colliding with a tree.