NTSB investigations, 2004
6 cases where the first occurrence was “Collision between aircraft (other than midair)”.
Cases per year
| 1994 | 7 |
|---|---|
| 1995 | 12 |
| 1996 | 15 |
| 1997 | 12 |
| 1998 | 11 |
| 1999 | 9 |
| 2000 | 9 |
| 2001 | 15 |
| 2002 | 8 |
| 2003 | 10 |
| 2004 | 6 |
| 2005 | 10 |
| 2006 | 6 |
| 2007 | 9 |
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\") = 2004
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\" = 271)
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") = 2004 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" = 271) 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 MIA05LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Pierce, FLThe failure of the pilot of the Piper 181 to apply his parking brake when stopped awaiting departure and his failure to maintain a visual lookout resulting in his airplane rolling forward and colliding with the Piper 201 which was awaiting departure.NTSB FTW04CA245Accident · No injuriesData collectionFinal reportCessna 172H · Houston, TXThe student pilot's failure to maintain clearance from a parked aircraft while taxiing. A contributing factor was the student pilot's anxiety attack.NTSB NYC04LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Philadelphia, PAThe inadequate visual lookout by the pilot of RV-6A and his failure to maintain clearance while taxiing, which resulted in an on-ground collision with the Piper.NTSB FTW04LA202Accident · No injuriesLimited investigationFinal reportCessna 140 · Kingston, OKThe failure by the other pilot to maintain visual lookout for other aircraft during landing.NTSB DEN04LA053Accident · No injuriesLimited investigationFinal reportCessna C172 · Broomfield, COthe pilot of the Maule's failure to maintain a visual lookout.NTSB CHI04LA083Accident · No injuriesLimited investigationFinal reportCessna 195 · Manitowoc, WIThe Cessna 195 pilot's failure to maintain clearance from the Cessna 177RG while taxiing to the ramp after landing. A contributing factor was the restricted forward visibility (blind spot) of the Cessna 195 due to the engine cowling. An additional factor was…