NTSB investigations, 1996
17 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
Latest 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\") = 1996
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") = 1996 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 LAX97FA075Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · San Diego, CAThe failure of the pilot-in-command of the Piper PA-28, N943R, to maintain an adequate visual lookout to see and avoid the Cessna 150, N63137. A factor in the accident was the failure of the air traffic controller to issue a traffic advisory to the pilot…NTSB SEA97LA038Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Spokane, WAThe failure of the pilots of both airplanes to see and avoid each other. A factor contributing to the accident was the Cessna's pilot diverted attention.NTSB MIA97LA008Accident · Minor injuriesLimited investigationFinal reportCessna 21OK · Tampa, FLThe failure of the pilots of both airplanes to see and avoid each other. Contributing to the accident was the improper planning/decision of the pilot of the Cessna 210 to depart the traffic pattern on the downwind leg rather than on the upwind leg as…NTSB FTW97LA018Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Oil City, LAthe failure of the pilots of both aircraft to maintain an adequate visual lookout. Factors were: different traffic pattern altitudes flown by the two pilots, and the sunglare encountered by the pilot of the ultralight.NTSB LAX96LA343Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Truckee, CAThe inadequate visual outlook by both pilots while in the vicinity of the airport. A factor was that each aircraft was on a different frequency at the time.NTSB ANC96LA111Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas MD369D · Healy, AKThe inadequate visual outlook by the pilots of both aircraft, and their failure to see and avoid the other aircraft. A factor associated with the accident was sunglare affecting the helicopter pilot's vision.NTSB FTW96FA279Accident · 2 fatalField investigationFinal reportPrevatt RV-6 · Boulder, COPoor judgment by the pilot of the RV-6, N194JP, in that he traversed an uncontrolled airport at traffic pattern altitude, failure of the pilots of both airplanes to see and avoid each other, and an inadvertent airplane stall encountered by the pilot of the…NTSB ANC96LA093Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe pilot of the Cessna 180, N5020E, disregard of an air traffic control clearance/instruction to hold short. A factor in the accident was the failure of both pilots to maintain an adequate visual lookout for other aircraft.NTSB FTW96FA234Accident · 4 fatalField investigationFinal reportFairchild KR-31 · Bartlesville, OKThe failure of each pilot-in-command to maintain visual lookout. Factors were: the lack of each pilot-in-command obtaining/maintaining communication with the control tower, and inadequate lookout by each pilot-rated passenger, the inadequate…NTSB FTW96FA208Accident · 1 fatalField investigationFinal reportJerrell RV-4 · Englewood, COfailure of the pilot of the RV-4, N44AZ, to comply with an ATC clearance by landing on the wrong runway, and the failure of the pilot of the SU-29, N55SU, to maintain an adequate visual lookout. Factors in the accident were: the failure of the air traffic…NTSB MIA96LA120Accident · No injuriesLimited investigationFinal reportMooney M20C · St Augustine, FLinadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see-and-avoid each other's airplane. A factor relating to the accident was: the lack of traffic pattern position reports from the Christian Eagle, due to the…NTSB ATL96LA063Accident · No injuriesLimited investigationFinal reportCessna 172RG · Gulf Shores, ALThe failure of both pilots to maintain an adequate visual lookout. A factor was the lack of position reports via radio by the pilot of the helicopter.NTSB LAX96FA130Accident · No injuriesField investigationFinal reportBellanca 7GCAA · Los Alamitos, CAthe failure of both pilots to see and avoid each other. Factors were the pilots' failure to use available radar services.NTSB MIA96FA096Accident · 6 fatalField investigationFinal reportPiper PA-28-180 · Flagler Beach, FLinadequate visual lookout by the pilots in both airplanes, which resulted in their failure to see-and-avoid conflicting traffic.NTSB FTW96FA130Accident · 4 fatalField investigationFinal reportCessna 182R · Proctor, ARfailure of the pilots in both airplanes to see-and-avoid conflicting traffic (inadequate visual lookout).NTSB ATL96LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Arlington, TNthe failure of the pilot of the Cessna 150, N63434, to see and avoid the Cessna 152, N151FC.NTSB LAX96FA108Accident · Minor injuriesField investigationFinal reportPiper PA-28-181 · Ramona, CAinadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see and avoid each other.