OpenAirDocs.org

NTSB investigations, AL

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

Cases per year

19852026

Where

Open the map

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 c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
    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 ATL04LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Pell City, ALThe pilot's failure to follow VFR Approach procedures and to maintain visual lookout.Oct 4, 2003 · N70SR · 2 aircraft · Substantial damageNTSB ATL99FA132Accident · 2 fatalField investigationFinal reportContinental Copters Tomcat MK5A · Heflin, ALThe pilot of N9010T's failure to maintain visual lookout while maneuvering, resulting in a midair collision with N30899. A factor was the sun glare.Sep 16, 1999 · N9010T · 2 aircraft · DestroyedNTSB 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.Mar 10, 1996 · N6612V · 2 aircraft · Substantial damageNTSB ATL95LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Payne, ALThe inaequate visual lookout by both pilots. Factors were the radio reception difficulties of the 152 pilot, his failure to make position reports while maneuvering for a landing, and the failure of the 182 pilot to have a safety observer while conducting…Apr 25, 1995 · N5527M · 2 aircraft · Substantial damageNTSB ATL90FA139Accident · 4 fatalField investigationFinal reportPiper PA-38-112 · Florence, ALFailure of the pilot-in-command of N2409K to maintain safe separation from N2437K during unauthorized formation maneuvering. Overconfidence in personal ability and the execution of unauthorized formation flight on the part of both pilots-in-command were…Jul 1, 1990 · N2409K · 2 aircraft · DestroyedNTSB ATL90FA095Accident · 2 fatalField investigationFinal reportEmbraer EMB-120 · Gadsden, ALInadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid oncoming traffic. A factor related to the accident was: the sun's glare, which restricted the vision of the Cessna 172 pilot.Apr 9, 1990 · N217AS · 2 aircraft · Substantial damageNTSB ATL90FA024Accident · 4 fatalField investigationFinal reportBeech C90 · Gadsden, ALFailure of the pilots of both aircraft to maintain adequate visual lookout to see-and-avoid the other aircraft.Nov 5, 1989 · N3804F · 2 aircraft · DestroyedNTSB ATL85MA282Accident · 2 fatalMajor investigationFinal reportGates Learjet 35A · Auburn, ALDrg arrival, the aircrew of a Gates lear jet 35A, N873LP, canceled their IFR clearance & contacted the Auburn UNICOM, then entered the traffic pattern to land on rwy 18. The UNICOM operator rprtd that the lear jet crew had rprtd their position on each portion…Sep 22, 1985 · N873LP · 2 aircraft · Destroyed