Skip to content

NTSB investigations, WA

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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" = 'WA' 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

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\" = 'WA' 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.

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" = 'WA' 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

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 SEA08LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tacoma, WAThe failure of both pilots to maintain an adequate visual lookout during cruise flight.Nov 20, 2007 · N6147B · 2 aircraft · Substantial damage NTSB 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 · Destroyed NTSB SEA04FA083Accident · 1 fatalField investigationFinal reportCessna 170B · Tenino, WAThe pilot's failure to maintain an adequate visual lookout during cruise flight, which resulted in a midair collision between the two airplanes.May 17, 2004 · N3510D · 2 aircraft · Destroyed NTSB SEA04LA063Accident · 1 fatalLimited investigationFinal reportGlasflugel STD Libelle 201B · Oso, WAThe pilot of the Glaser-Dirks (lead glider) failure to maintain clearance from the Glasflugel (trailing glider) resulting in a mid-air collision while maneuvering.Apr 2, 2004 · N161D · 2 aircraft · Substantial damage NTSB SEA00FA021Accident · Minor injuriesField investigationFinal reportBell 206L-3 · Seattle, WAAdequate separation and lookout not maintained by the pilots of both aircraft.Nov 17, 1999 · N206AC · 2 aircraft · Substantial damage NTSB SEA00IA007Incident · No injuriesIncident investigationFinal reportCessna 172P · Wenatchee, WAThe failure of the pilots in both aircraft to maintain an adequate visual lookout. Haze was a factor.Oct 23, 1999 · N54844 · 2 aircraft · Minor damage NTSB 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 · Destroyed NTSB SEA97LA038Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Spokane, WAThe failure of the pilots of both airplanes to see and avoid each other. A factor contributing to the accident was the Cessna's pilot diverted attention.Dec 18, 1996 · N6043M · 2 aircraft · Substantial damage NTSB SEA94LA054Accident · No injuriesLimited investigationFinal reportFokker DR-1 · Auburn, WAThe pilot failed to maintain clearance while maneuvering near another airplane.Feb 2, 1994 · N10717 · Substantial damage 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.Aug 1, 1993 · N5958J · 2 aircraft · Destroyed 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…Apr 14, 1993 · USN · 2 aircraft · Destroyed NTSB SEA92FA195Accident · 3 fatalField investigationFinal reportSnodgrass Starduster TOO · Lacey, WAThe failure of both pilots to see and avoid each other.Sep 7, 1992 · N4316 · 2 aircraft · Destroyed NTSB SEA92FA026Accident · 7 fatalField investigationFinal reportCessna 172P · Snohomish, WAA visual lookout was not maintained.Dec 7, 1991 · N65831 · 2 aircraft · Destroyed NTSB SEA92FA022Accident · Serious injuriesField investigationFinal reportCessna 150E · Vancouver, WAInadequate visual lookout on the part of the pilot as well as both the flight instructor and student of the other aircraft. A factor contributing to the accident was the other pilot's lack of landing light usage.Nov 22, 1991 · N2582J · 2 aircraft · Destroyed NTSB SEA89FA160Accident · 4 fatalField investigationFinal reportCessna 152 · Snohomish, WAThe pilot's failure to see and avoid N49231, a Cessna 172. Contributing factors were: a flight path directly into the setting sun, and the low light conditions of dusk on the ground below.Aug 30, 1989 · N49231 · 2 aircraft · Destroyed NTSB SEA87FA100Accident · 3 fatalField investigationFinal reportCessna 172 · Ritzville, WAOccupants of both acft were family members traveling in company for holiday. Takeoff was about one min apart with N44726 in trail. Due higher norm crz performance, N44726 overtook N5711A. Plt of N44726 reduced speed and established position about 1/2 mile to…May 24, 1987 · N5711A · 2 aircraft · Destroyed NTSB SEA86FA121Accident · 2 fatalField investigationFinal reportCessna 152 · Mead, WABoth acft were operating in VFR conditions modified by slight haze, high overcast and low sun angle near airport. N6161M was performing lazy eight maneuvers in a normal practice area two miles east of airport; N8267Q was in clockwise orbital descent for…May 20, 1986 · N6161M · 2 aircraft · Destroyed NTSB SEA86FA092Accident · 4 fatalField investigationFinal reportCessna 172P · Seattle, WAN99034 departed kenmore air harbor on a short local solo flight. Witnesses reported observing the aircraft takeoff and initiate a climb to the south. N65783 was returning from a recurrency check flight and was approaching from a southerly direction in a climb…Apr 5, 1986 · N99034 · 2 aircraft · Destroyed NTSB SEA84FA172Accident · 1 fatalField investigationFinal reportSchempp-Hirth Ventus A · Ephrata, WAA 'gaggle' of about 7 gliders were maneuvering in a climb when N919R climbed into the group. The plt of N17KS said he saw N919R closing and increased his angle of bank to about 100 degrees to try and avoid a collision. The leadingedge of the left wing of…Jul 12, 1984 · N17KS · 2 aircraft · Minor damage NTSB SEA84LA159Accident · No injuriesLimited investigationFinal reportApplebay Sailplanes Zuni II · Ephrata, WAThe two gliders collided while thermaling in vicinity of each other while engaged in a contest. According to the plts they lost sight of each other while spiraling in the lift. Both acft landed safely. The collision was nose to tail.Jul 3, 1984 · N22HL · 2 aircraft · Substantial damage NTSB SEA84FA060Accident · 3 fatalField investigationFinal reportCessna 172N · Kent, WAAt about 1345 PST, the plt of a Cessna 172N, N4603F, departed crest airpark, Kent, WA, on a local pleasure flt. Aprx 5 min later, the plt & 1 passenger of a float equipped Cessna 180, N4908A, took off from lake meridian, Kent, WA, & were also on a local…Feb 24, 1984 · N4603F · 2 aircraft · Destroyed NTSB SEA82AA126Accident · 6 fatalFinal reportCessna 172 · Mercer Island, WAN2428E, a C-172, had departed sea-tac arpt for a VFR flt to snohomish, WA, about 27 mi on the 355 deg radial from the sea-tac VORTAC. It proceeded nnw over the west shore of Mercer Island located approximately 10 mi north of the sea-tac arpt. N761EL, a…Jul 23, 1982 · N2428E · 2 aircraft · Destroyed