NTSB investigations, 2001
7 cases where the first occurrence was “Midair collision”.
Cases per year
| 1982 | 30 |
|---|---|
| 1983 | 14 |
| 1984 | 26 |
| 1985 | 25 |
| 1986 | 29 |
| 1987 | 25 |
| 1988 | 18 |
| 1989 | 19 |
| 1990 | 23 |
| 1991 | 23 |
| 1992 | 12 |
| 1993 | 13 |
| 1994 | 12 |
| 1995 | 15 |
| 1996 | 17 |
| 1997 | 15 |
| 1998 | 15 |
| 1999 | 17 |
| 2000 | 19 |
| 2001 | 7 |
| 2002 | 10 |
| 2003 | 11 |
| 2004 | 12 |
| 2005 | 11 |
| 2006 | 8 |
| 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\") = 2001
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\" = 270)
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") = 2001 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" = 270) 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 ATL02LA012Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA300/L · St. Augustine, FLThe pilot of the other airplanes failure to maintain a visual lookout and yield the right-of-way to a lower airplane while landing. This resulted in an inadvertent midair collision. Contributing to the accident was reported excessive radio communication on…NTSB LAX01GA291Accident · 2 fatalFinal reportGrumman TS-2A · Hopland, CAthe failure of both pilots to maintain an adequate visual lookout. The failure of the pilot in Tanker 87 to comply with suggested procedures regarding positive radio contact and orbit entry was a factor.NTSB DEN01TA134Accident · No injuriesFinal reportBell 205A-1 · Jackson, WYthe Bell 212 helicopter pilot's inadequate visual lookout which resulted in a midair collision.NTSB SEA01LA122Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Bozeman, MTThe pilot of another aircraft failed to maintain clearance while maneuvering for a formation flight. An updraft was a factor.NTSB ATL01LA063Accident · 2 fatalLimited investigationFinal reportAir Tractor 502B · Anguilla, MSFailure of both pilots to maintain visual lookout, resulting in an in-flight collision. A factor was sun glare.NTSB LAX01FA101Accident · 4 fatalField investigationFinal reportCessna 152 · Long Beach, CAThe failure of the flight crews of both airplanes to maintain adequate visual lookout for traffic.NTSB FTW01FA058Accident · 2 fatalField investigationFinal reportCessna 152 · Platter, OKthe failure of both pilots to maintain a visual lookout, which resulted in a mid-air collision over a lake. A contributing factor to the accident was the sun glare from the setting sun.