NTSB investigations, 1993

13 cases where the first occurrence was “Midair collision”.

Cases per year

19822026
NTSB investigations, 1993 per year, 1982–2026: 435 cases
198230
198314
198426
198525
198629
198725
198818
198919
199023
199123
199212
199313
199412
199515
199617
199715
199815
199917
200019
20017
200210
200311
200412
200511
20068
20079

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.

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…Sep 23, 1993 · N43320 · 2 aircraft · Substantial damageNTSB 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.Aug 15, 1993 · N5226E · 2 aircraft · DestroyedNTSB 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.Aug 1, 1993 · N5958J · 2 aircraft · DestroyedNTSB 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…Jul 30, 1993 · N707BP · 2 aircraft · DestroyedNTSB 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.Jul 25, 1993 · N8382M · 2 aircraft · DestroyedNTSB 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.Jul 24, 1993 · N9044J · 2 aircraft · Substantial damageNTSB 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.Jul 9, 1993 · N5960H · 2 aircraft · Substantial damageNTSB 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…Jun 5, 1993 · N69WD · 2 aircraft · DestroyedNTSB 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.Apr 28, 1993 · N194A · 2 aircraft · Minor damageNTSB 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…Apr 28, 1993 · N9317L · 2 aircraft · Substantial damageNTSB 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…Apr 14, 1993 · USN · 2 aircraft · DestroyedNTSB 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.Feb 28, 1993 · N6059J · 2 aircraft · Minor damageNTSB 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:…Feb 19, 1993 · N621SG · 2 aircraft · Destroyed