NTSB investigations, 1999
9 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\") = 1999
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") = 1999 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 LAX00LA060Accident · No injuriesLimited investigationFinal reportPitts S-2B · Santa Ana, CAThe failure of the pilot of the other airplane to maintain an adequate obstruction clearance while taxiing.NTSB SEA00LA026Accident · No injuriesLimited investigationFinal reportRockwell NA-265-65 · Seattle, WAInadequate visual lookout and clearance was not maintained. Diverted attention, dark night conditions and rain were factors.NTSB LAX00LA011Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Jean, NVThe pilot of the other airplane's failure to maintain an adequate visual lookout while taxiing for departure. Factors in the accident were: the narrow nature of the taxiway and the pilot of the other airplane's subsequent inability to S-turn for better…NTSB FTW99LA245Accident · No injuriesLimited investigationFinal reportCessna 150K · Springdale, ARThe inadequate visual lookout by both pilots.NTSB ANC99LA107Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Ketchikan, AKA failure of ground handling personnel to verify a release procedure/directive, and removal of the airplane's tiedown, and subsequent collision with a parked airplane.NTSB LAX99FA218Accident · No injuriesField investigationFinal reportBoeing 747-4F6B · Los Angeles, CAAirport management's failure to ensure that its current operating procedure, which required the arriving airplane to power into the terminal gate, was being used. Also causal was (1) the ground service company's utilization of an outdated arrival procedure…NTSB LAX99LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Scottsdale, AZThe failure of the local and ground controller to coordinate the clearances of both aircraft and to maintain separation of the traffic in the taxiway movement area.NTSB DEN99LA047Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Denver, COThe pilot of N328BA's failure to maintain visual lookout while taxiing, causing the subsequent collision with N151SA.NTSB LAX99LA086Accident · No injuriesLimited investigationFinal reportCessna 150L · Madera, CAThe pilot's failure to maintain an adequate visual lookout and to see the stationary airplane on the taxiway ahead.