NTSB investigations, 2003
11 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\") = 2003
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") = 2003 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 ANC04FA016Accident · 4 fatalField investigationFinal reportPiper J3C-65 · Peoria, AZThe inadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid each other's aircraft and a subsequent midair collision. A factor associated with the accident was the airplane pilot's failure to determine that…NTSB NYC04FA033Accident · 2 fatalField investigationFinal reportCessna 180 · Westerly, RIThe Piper pilot's improper decision to continue a landing on an occupied runway, which resulted in an in-flight collision with the departing Cessna. Factors related to the accident were the departing Cessna pilot's inattentive radio communications, and the…NTSB LAX04FA037Accident · 2 fatalField investigationFinal reportRobinson R22 Beta II · Torrance, CAthe failure of the pilot of the R22 to comply with an ATC clearance.NTSB ATL04LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Pell City, ALThe pilot's failure to follow VFR Approach procedures and to maintain visual lookout.NTSB CHI03FA284Accident · 3 fatalField investigationFinal reportCessna 172S · Lake Elmo, MNBoth pilots failed to maintain adequate visual lookout and did not maintain clearance from the other aircraft.NTSB MIA03LA162Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · West Palm Beach, FLThe poor judgment by the pilot-in-command of the airplane for his initiation of takeoff after the helicopter pilot had announced intention to perform a 180-degree autorotation to the runway, and the failure of both pilots to maintain visual lookout resulting…NTSB DEN03LA130Accident · No injuriesLimited investigationFinal reportAerostar RX-8 · Snowmass Villag, COthe failure of the pilot of balloon #2 to maintain clearance from balloon #1 while overtaking him.NTSB MIA03FA124Accident · 5 fatalField investigationFinal reportCessna 172N · Deerfield Beach, FL**This case was revised 6/10/2005 and 2/24/2016. Refer to the public docket for this accident for details.** The failure of the pilot of N4903F, the Cessna 172, and the pilot of N759XA, the Cessna 182, to see and avoid each other while operating in Class E…NTSB LAX03LA129Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Herald, CAthe inadequate visual lookout for other aircraft by both pilots that resulted in a midair collision.NTSB DEN03MA035Accident · 5 fatalMajor investigationFinal reportPiper PA-31T · Denver, COBoth pilots' inadequate visual lookout. A contributing factor was the Cheyenne pilot operating the airplane with a known transponder deficiency.NTSB LAX03FA066Accident · 2 fatalField investigationFinal reportCessna 182H · Parker, AZfailure of both pilot's to see and avoid one another while maneuvering in the traffic pattern. A factor in the accident was the inability of the Cessna pilot to communicate on the CTAF frequency due to the limitations of his radios.