NTSB investigations, WA
11 cases where the first occurrence was “Fire”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 2 |
| 1986 | 4 |
| 1990 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 2001 | 1 |
Where
Open the mapLatest 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\" = '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\" = 171)
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" = 171) 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 SEA01LA112Accident · No injuriesLimited investigationFinal reportCessna 150F · Arlington, WAA fire that originated in the aircraft's carburetor.NTSB SEA94FA124Accident · 2 fatalField investigationFinal reportRyan Navion L-17B · Olympia, WAAn inflight fire for an undetermined reason.NTSB SEA91IA219Incident · Minor injuriesIncident investigationFinal reportBoeing 747-151 · Seattle, WAA fire in the number 4 engine, resulting from a fuel leak at the main fuel control unit, due to improper maintenance by unknown/undetermined person. The L5 emergency exit failed to operatee due to a broken plastic pulley guard in the slide release mechanism.NTSB SEA91IA003Incident · No injuriesIncident investigationFinal reportCessna 551 · Elma, WAInadequate inspection of the electrical wire bundle assembly by maintenance personnel, and chafing/burning of the wire bundle.NTSB SEA87LA041Accident · No injuriesLimited investigationFinal reportDouglas C-54/DC-4 · Pacific Ocean, WAThe plt reptd that he ditched his DC-4 in the Pacific Ocean on the evening of December 23 after experiencing an uncontrollable no. 3 eng fire at the conclusion of a tng flt. The ditching occurred in dark night conditions with minimal 10 foot swells having a…NTSB SEA87LA024Accident · No injuriesLimited investigationFinal reportCessna 182B · Bellingham, WADrg an attempted start, the eng backfired & an induction fire started. However, the plt did not continue cranking the eng. Strong surface winds inhibited the effectiveness of the acft's portable fire extinguisher. The plt then attempted to use an extinguisher…NTSB SEA87IA003Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Seattle, WADuring attempt to apply ground power to acft, internal feeder cables shorted and melted down. Investigation revealed poor workmanship by contracted maintenance personnel in modification installation.NTSB SEA86IA058Incident · No injuriesIncident investigationFinal reportCessna T210 · Roche Harbor, WAOn initial climb after takeoff, electrical fire broke out in back of pilot's yoke. Pilot managed to extinguish five- inch flames by hand, climbed to 2000 feet and evaluated situation. Noting no further problems, flight was continued to destination. Enroute,…NTSB SEA85LA230Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Burlington, WADuring initial climb, the plt smelled smoke & heard a backfire, then the eng lost power. A forced landing was made in a field on rough/uneven terrain. During the landing roll, the acft struck a ditch & was damaged. A visual inspection revealed that the left…NTSB SEA85LYE02Accident · No injuriesFinal reportAero Commander 600S-20 · Pasco, WAThis Aero Commander 600S-20 departed on an aerial application flight. Shortly after takeoff the pilot noticed flames coming from the engine compartment, experienced a power loss and made a forced landing in sand dunes, substantially damaging the aircraft.…NTSB SEA84FA031Accident · No injuriesField investigationFinal reportPiper 601P · Garfield, WAThe acft was forced to land on a road due to a fire in the left wing. During the investigation of the accident it was found that the left turbocharger had been removed and reinstalled several times. A clamp on the turbocharger exhaust wasimproperly installed…