NTSB investigations, 1993
13 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\") = 1993
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") = 1993 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 MIA93LA199Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Deland, FLFailure of both pilots to maintain adequate visual lookout. Factors related to the accident were: the conflicting right traffic pattern procedures for landing that were briefed to the Boeing E75 pilot by the owner of the airstrip, and failure of both pilots…NTSB NYC93FA158Accident · 1 fatalField investigationFinal reportCessna 172N · Lincoln Park, NJThe failure of both pilots to maintain adequate visual lookout while in the airport traffic pattern, which resulted in an in-flight collision.NTSB SEA93LA168Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Ephrata, WAInadequate visual lookout by both pilots, resulting in their failure to see-and-avoid each other's aircraft. A factor related to the accident was: failure of the Grumman 164B pilot to adequately monitor the UNICOM frequency.NTSB CHI93FA302Accident · 5 fatalField investigationFinal reportRockwell 690-A · Norfolk, NEThe failure of the pilots of the Rockwell 690-A, N707BP, and the Piper PA-28R, N33056, to see and avoid each other. A factor which contributed to the accident was the failure of both pilot's to follow recommended communication procedures contained in the…NTSB CHI93FA274Accident · 2 fatalField investigationFinal reportCessna A150K · Goshen, INFailure of both pilots to see and avoid each other. A factor in the accident was the position of the sun which resulted in sun glare for the pilot of the mong sport.NTSB BFO93LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Pittsfield, MAThe failure of the pilot of the PA-28, N9044J, to properly tune his radios, and his failure to see and avoid the PA-38, N91357.NTSB ANC93FA114Accident · 4 fatalField investigationFinal reportPiper PA-16 · Fairbanks, AKFailure of the pilots of both airplanes to see and avoid each other, and the alcohol impairment of the pilot-in-command of the PA-16, N5960H. A factor which contributed to the accident was the sunglare.NTSB LAX93FA241Accident · 3 fatalField investigationFinal reportLancair 320 · Chino, CAInadequate visual lookout by the pilot of the Lancair 320, N69WD, that precluded him from recognizing a collision hazard and taking action to avoid a midair collision with the Cessna 152, N80203. In addition, the local controller failed to advise the pilot of…NTSB FTW93IA141Incident · No injuriesIncident investigationFinal reportCommander 114B · Oklahoma City, OKThe pilot of the pitts, N51ST, misunderstanding of the tower's instructions and clearance, and his failure to see and avoid the Commander 114B, N194A.NTSB ATL93FA082Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Statesboro, GAInadequate visual lookout by the pilots of both aircraft. Factors related to the accident were: failure of the pilot of N9317L to illuminate his aircraft navigation lights, and improper radio communications by the pilot of N47WD by selecting the wrong UNICOM…NTSB SEA93FA094Accident · Serious injuriesField investigationFinal reportGrumman A6E · Steptoe, WAThe inherent limitations of the see-and-avoid concept of separation of aircraft operating under visual flight rules that precluded the crew of the A6E and the pilot of the agcat from recognizing a collision hazard and taking actions to avoid a midair…NTSB CHI93LA195Accident · No injuriesLimited investigationFinal reportCessna A150L · Blaine, MNThe failure of the pilot of the Cessna 150, N6059J, and the pilot of the challenger to see and avoid each other.NTSB ATL93FA061Accident · 4 fatalField investigationFinal reportRobinson R22B · Atlanta, GAThe failure of the pilot/applicant of the R22B, N621SG, to follow low approach procedures, and the failure of the designated examiner/observer in the R22B to maintain visual separation from the Cessna 152, N5532Q. Contributing factors to the accident were:…