NTSB investigations, 2002
8 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\") = 2002
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") = 2002 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 ANC03LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Bethel, AKThe failure of both pilot's to maintain a visual outlook during taxi operations on the ramp.NTSB MIA02IA167Incident · No injuriesIncident investigationFinal reportBoeing 737-823 · Miami, FLThe failure of the tug driver to maintain wingtip clearance with a parked airplane, and the inability of the tug driver to communicate with the brake rider during a tow operation following failure of the headset cord. Contributing factors in the incident were…NTSB ANC02LA086Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Fairbanks, AKThe failure of both pilots to maintain adequate visual outlook while taxiing.NTSB LAX02LA241Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesa, AZthe pilot of the other airplane'ss use of an excessive taxi speed and too close of a spacing interval to the Cessna 152, which resulted in an on-ground collision when the Cessna 152 abruptly stopped.NTSB NYC02LA141Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Dayton, OHThe inadequate visual lookout by the pilot of the Kitfox. Factors related to the accident were the non-radio equipped Waco, and the hazy visual conditions.NTSB ANC02LA053Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Ketchikan, AKThe failure of a ground handler to follow company proceedure/directives, and his premature release of a mooring line. Factors associated with the accident were the congested operations area, and the operator's failure to provide adequate safe zones for the…NTSB ANC02FA023Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-82 · Anchorage, AKThe MD-11 flight crew's failure to maintain clearance while taxiing and the other's airplane's (MD-82) ground-marshaling personnel's failure to follow procedures/directives when they did not display an emergency stop signal to the crew of the MD-11. Factors…NTSB LAX02LA084Accident · No injuriesLimited investigationFinal reportCessna 172S · Glendale, AZThe pilot of the landing airplane failed to maintain directional control resulting in the on-ground collission.