NTSB investigations, WA

3 cases where the first occurrence was “Fire/explosion”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19842026

NTSB investigations, WA per year, 1984–2026: 3 cases
1984	1
1987	1
1988	1

Where

Open the map

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" = 170) 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\" = 170)
  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" = 170)
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 DCA88MA052Accident · Serious injuriesMajor investigationFinal reportde Havilland DHC-8 · Seattle, WAShortly after tkof from Seattle-tacoma intl airport, the crew noted a rt eng power loss and decided to return for a precautionary lndg. After lowering the lndg gear, a massive fire was discovered in the rt eng nacelle. After lndg, directional control and all…Apr 16, 1988 · N819PH · Destroyed NTSB SEA87IA119Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-101 · Seattle, WAThe crew of the scheduled airline passenger flight experienced an explosion and fire in the right engine at approx 800 ft AGL during initial climb after takeoff. The pilot shut the engine down, activated two fire bottles, which extinguished the fire and…Jun 19, 1987 · N813PH · Minor damage NTSB SEA84IA125Incident · No injuriesIncident investigationFinal reportBeech 1900C · Spokane, WADuring climbout from rwy 21, at an alt of about 500 ft, smoke, fire & sparks erupted from the lower & upper forward corners of the circuit breaker panel on the f/o sidewall. The capt took control of the acft & landed the acft on rwy 03. Investigation revealed…Jun 4, 1984 · N123CZ · Minor damage