NTSB investigations, 2005

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

Cases per year

19822026
NTSB investigations, 2005 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\") = 2005
    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 LAX06LA065Accident · No injuriesLimited investigationFinal reportBeech F33A · La Verne, CAthe failure of the pilot of the other aircraft to comply with his air traffic control clearance and line up for the proper runway, and his failure to maintain an adequate visual lookout, which resulted in his in-flight collision with the Cessna airplane.Dec 22, 2005 · N3084N · 2 aircraft · No damageNTSB LAX06LA056Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Corona, CAfailure of both pilots to see and avoid each other during traffic pattern operations at a non-towered airport.Dec 11, 2005 · N65696 · 2 aircraft · Substantial damageNTSB MIA06FA022Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Homestead, FLThe failure of both pilot's to maintain visual lookout resulting in the mid-air collision. A factor in the accident was the failure of the AS-350B pilot to follow approach procedures suggested in the Speedway Heliport Operations Manual. Findings in the…Nov 21, 2005 · N264BH · 2 aircraft · Substantial damageNTSB NYC06FA025Accident · 1 fatalField investigationFinal reportCessna 172A · Pohatcong, NJThe inadequate visual lookout of the pilots in both airplanes, which resulted in a midair collision during descent.Nov 5, 2005 · N7467T · 2 aircraft · Substantial damageNTSB CHI06FA010Accident · 4 fatalField investigationFinal reportPlavcan Lancair 235 · Rootstown, OHThe failure of both pilots to maintain an adequate visual lookout during cruise flight, which resulted in their failure to see and avoid each other and a midair collision.Oct 14, 2005 · N235U · 2 aircraft · DestroyedNTSB SEA05FA158Accident · 2 fatalField investigationFinal reportCessna 150M · Renton, WAThe failure of the DHC-2 Beaver pilot to understand air traffic advisory information and the failure of the Cessna pilot to maintain visual separation, resulting in a midair collision. A factor contributing to the accident was the inadequate traffic advisory…Aug 5, 2005 · N66234 · 2 aircraft · DestroyedNTSB DFW05LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Bonita, LAThe failure of the pilot to maintain adequate visual lookout, which resulted in a midair collision.Jul 14, 2005 · N61220 · 2 aircraft · Substantial damageNTSB NYC05FA117Accident · 2 fatalField investigationFinal reportCarlstrom Long EZ · Lewes, DEThe Long EZ pilot's failure to maintain clearance from the RV-8 airplane, which resulted in a mid-air collision during a formation flight.Jul 10, 2005 · N78LC · 2 aircraft · DestroyedNTSB DFW05LA134Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164D · Jennings, LAThe failure of both pilots to maintain adequate visual lookout, which resulted in a midair collision while on final approach.May 24, 2005 · N8120K · 2 aircraft · Substantial damageNTSB MIA05LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bradfordville, FLThe failure of ATC to provide traffic advisories and safety alerts required in class C airspace and the inability of both pilots to see and avoid each other (low wing on top, high wing below), resulting in the midair collision.Mar 13, 2005 · N7706N · 2 aircraft · Substantial damageNTSB CHI05FA055Accident · 1 fatalField investigationFinal reportCessna T-37B · Hollister, OKThe pilots of the AT-502B and the T-37B failed to maintain adequate visual lookout and did not maintain clearance from the other aircraft. Contributing factors included the lack of a transponder and radios on the AT-502B, and the reduced visibility due to…Jan 18, 2005 · 66-8003 · 2 aircraft · Destroyed