OpenAirDocs.org

NTSB investigations, 1997

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

Cases per year

19822026

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 year(c.\"eventDate\") = 1997
    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 FTW98FA063Accident · 3 fatalField investigationFinal reportPitts S-2B · Bozeman, MTThe failure of both pilots to maintain visual lookout. Factors were the pilot of N693SB not following procedures and directives, and the pilot of N693SB using poor judgment.Dec 7, 1997 · N693SB · 2 aircraft · DestroyedNTSB LAX98FA045Accident · 1 fatalField investigationFinal reportCessna 152 · El Cajon, CAThe solo student's failure to see and follow the other aircraft on the downwind as he had been instructed. Factors influencing this accident was the failure of the pilots in the other aircraft to see and avoid the aircraft encroaching on his flight path; the…Nov 25, 1997 · N757FT · 2 aircraft · DestroyedNTSB FTW98LA022Accident · No injuriesLimited investigationFinal reportCessna 150G · Tyler, TXThe failure of the of pilot of the departing Cessna to follow standard departure procedures and his disorientation while navigating to locate a highway. A factor was the failure of both pilots to maintain visual lookout.Oct 19, 1997 · N3916J · 2 aircraft · Minor damageNTSB FTW98LA009Accident · No injuriesLimited investigationFinal reportCameron N-90 · Albuquerque, NMThe failure of the pilot of the Aerostar RX 8, N71415, to follow procedures/directives.Oct 10, 1997 · N1602R · 2 aircraft · Substantial damageNTSB MIA98FA007Accident · 3 fatalField investigationFinal reportBeech 35-C33A · Robbins, NCfailure of the pilots in both aircraft to see-and-avoid each other's airplane (inadequate visual lookout), and failure of the Beech pilot to operate his airplane at a correct Visual Flight Rules (VFR) cruising altitude for his route of flight.Oct 7, 1997 · N2050W · 2 aircraft · DestroyedNTSB ATL97FA113Accident · Serious injuriesField investigationFinal reportPilatus BN-2 Islander · Fajardo, PRThe pilot's failure to maintain adequate visual lookout.Aug 7, 1997 · N26JA · 2 aircraft · Substantial damageNTSB CHI97FA218Accident · 7 fatalField investigationFinal reportCessna 172P · Chicago, ILthe pilots not maintaining visual separation between their airplanes. A factor in this accident was the pilot of the southbound airplane not reporting her position abeam the airport as directed by the ATC controller.Jul 19, 1997 · N5323K · 2 aircraft · DestroyedNTSB NYC97LA125Accident · 1 fatalLimited investigationFinal reportShafer SONERAI-I · W.Hampton Beach, NYfailure of the number two pilot (N77TY) to follow race procedures, and failure of the number three pilot (N20CS) to turn and avoid the number two airplane, when it decelerated into the number three pilot's blind spot.Jun 22, 1997 · N20CS · 2 aircraft · DestroyedNTSB MIA97FA179Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Asheboro, NCfailure of the pilots in both airplanes to see and/or avoid a collision with each other.Jun 4, 1997 · N804DA · 2 aircraft · Substantial damageNTSB FTW97FA208Accident · 1 fatalField investigationFinal reportBell 206B · Intracoastl Cty, LAThe failure of both pilots to see and avoid each other's aircraft. Factors were the failure of the pilot of N2773A to use the available traffic advisory service and the failure of the operator of N2773A to make the use of traffic advisory services a company…Jun 1, 1997 · N115AL · 2 aircraft · Substantial damageNTSB SEA97FA105Accident · 3 fatalField investigationFinal reportCessna 182 · Clinton, UTInadequate prior arrangements for formation flight by the pilot-in-command of the Cessna 182, N5434B, and his subsequent failure to see-and-avoid the Piper PA-28R, N5270T. Factors were: the Cessna pilot's visibility of the Piper impaired by the sun;…May 10, 1997 · N5434B · 2 aircraft · DestroyedNTSB ANC97FA051Accident · 2 fatalField investigationFinal reportCessna 185 · Tatitlek, AKThe command pilots of both airplanes inadequate visual outlook which led to their failure to see and avoid each other's airplane. A factor associated with the accident was sunglare.Apr 9, 1997 · N59AK · 2 aircraft · Minor damageNTSB SEA97LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150D · Arlington, WAThe failure of the commercial pilot to perform an adequate visual lookout while on final approach for landing on the runway, and the failure of the student pilot of the other airplane to perform an adequate visual lookout prior to taking off from the same…Apr 6, 1997 · N4100U · 2 aircraft · DestroyedNTSB ANC97FA037Accident · 2 fatalField investigationFinal reportShort Brothers SC7 · Nunapitchuk, AKinadequate visual look-out by the pilots of both airplanes, which resulted in their failure to see-and-avoid each other's airplanes.Mar 25, 1997 · N451SA · 2 aircraft · DestroyedNTSB CHI97FA084Accident · 4 fatalField investigationFinal reportDouglas DC-3C/BT-67R · Newton, WIfailure of the Beech A36 pilot to maintain clearance from the modified Douglas DC-3, while positioning the A36 for photography of the DC-3.Mar 15, 1997 · TZ389 · 2 aircraft · Destroyed