NTSB investigations, 1994
12 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\") = 1994
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") = 1994 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 LAX95LA042Accident · Minor injuriesLimited investigationFinal reportGrumman AA5 · Santa Paula, CAThe failure of both pilots to maintain an adequate visual lookout for other traffic in the pattern, and the other pilot's failure to effectively use the CTAF for position reports while in the pattern.NTSB LAX94FA383Accident · 1 fatalField investigationFinal reportMcdonnell Douglas 520N · Mesa, AZFailure of the chase helicopter pilot to maintain clearance from the lead helicopter during a night approach to land. Possible factors relating to the accident were: darkness, and inadequate radio coordination between flight crews of the two helicopters.NTSB LAX94LA368Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-5 · Reno, NVthat the pilot of the other airplane misjudged the distance between the airplanes. The other airplane pilot's diverted attention to the air race is a factor in this accident.NTSB NYC94LA130Accident · 1 fatalLimited investigationFinal reportEdward A. Alderfer EAA-3 · Middletown, OHInadequate visual lookout by both pilots which resulted in a mid-air collision. A factor was the failure of the pilot of the ultralight to stay north of runway 26.NTSB NYC94FA119Accident · 1 fatalField investigationFinal reportCessna 172RG · Kiptopeka, VAInadequate visual lookout by the flightcrew of the helicopter. A factor related to the accident was: failure of the departure controller to issue a traffic advisory.NTSB LAX94FA243Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Banning, CAThe failure of both pilots to see and avoid each other. The haze was a factor.NTSB MIA94LA119Accident · No injuriesLimited investigationFinal reportGlobe 9C-1B · Okeechobee, FLBoth pilots misjudged their clearance from each other.NTSB NYC94FA075Accident · 4 fatalField investigationFinal reportCessna 152 · E. Farmingdale, NYFailure of the local tower controller to adequately control the arrival of the airplanes, and inadequate visual lookout by the Piper PA-24 pilot. A factor related to the accident was: the local controller's improper phraseology in sequencing the airplanes.NTSB FTW94FA102Accident · 4 fatalField investigationFinal reportTaylorcraft DCO-65 · San Antonio, TXThe failure of the pilot of the other aircraft to maintain adequate clearance during formation flight. A factor was the pilot's inadequate preflight planning and preparation regarding inflight formation procedures.NTSB LAX94LA113Accident · No injuriesLimited investigationFinal reportCessna 175 · Oakdale, CAthe pilot's failure to maintain an adequate visual lookout, and his failure to adequately communicate his postion and intentions on the Common Traffic Advisory Frequency. A factor in the accident was the pilot's misidentification of the Cessna aircraft he was…NTSB SEA94LA054Accident · No injuriesLimited investigationFinal reportFokker DR-1 · Auburn, WAThe pilot failed to maintain clearance while maneuvering near another airplane.NTSB FTW94FA060Accident · 5 fatalField investigationFinal reportPalmer Hawk BM-4 · Pearland, TXInadequate visual lookout by the pilot of the hawk BM-4, which resulted in his failure to see-and-avoid the Cessna 172. The BM-4 pilot's non-standard procedure for entering the traffic pattern was a related factor.