NTSB investigations, 2000, WA
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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\") = 2000
AND c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2000 AND c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA' 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 SEA00LA066Accident · No injuriesLimited investigationFinal reportBeech A200 · Seattle, WAThe pilot's failure to properly follow pre-takeoff checklists (resulting in the engine starters remaining engaged after engine start, generators not being activated, discharge of the aircraft battery and consequent total electrical failure during flight with…NTSB SEA00LA060Accident · No injuriesLimited investigationFinal reportCessna 180K · Silverdale, WAThe pilot's inadequate compensation for winds. Factors include gusty, shifting winds, crosswinds, and an earthen berm near the edge of the runway.NTSB SEA00IA062Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Seattle, WAContaminated air being ducted into the aircraft's cabin from the engine exhaust of a nearby ground power cart.NTSB SEA00FA061Accident · 1 fatalField investigationFinal reportBell 47G-3B-1 · Stanwood, WAThe disengagement of the oil jet fitting from its threaded receptacle at the forward end of the engine crankshaft. This resulted in excessive oil within the clutch assembly, the subsequent slipping of the clutch, and ultimately the disengagement of the rotor…NTSB SEA00LA059Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Odessa, WADisintegration of a lining of the right brake and subsequent lodging of brake lining debris between the brake housing and brake disc, resulting in seizure of the right brake. A factor was that directional control was not possible.NTSB SEA00IA057Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-600 · Seattle, WAAn oil leak from the aircraft's APU that subsequently contaminated the aircraft's environmental system.NTSB SEA00LA058Accident · No injuriesLimited investigationFinal reportCessna 170B · Lopez Island, WAThe pilot's failure to maintain aircraft control during landing. Contributing factors were the crosswind condition, gusts, and the pilot's overall lack of total (flight and tail wheel) experience.NTSB SEA00LA054Accident · No injuriesLimited investigationFinal reportCessna 172N · Quincy, WAFailure to maintain terrain clearance. Factors include mountainous/hilly terrain.NTSB SEA00IA050Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Seattle, WAThe flight crew's encounter with a suspicious device, which necessitated an emergency evacuation.NTSB SEA00LA049Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Townsend, WAThe pilot's failure to adequately compensate for changing wind conditions during the landing roll in a tailwheel-equipped aircraft. Factors include a variable, shifting wind that changed from a quartering headwind to a quartering tailwind just prior to the…NTSB SEA00LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Richland, WAFailure of a connecting rod for undetermined reasons. Factors include unsuitable terrain for the forced landing attempt.NTSB SEA00LA046Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-8-63F · Seattle, WAInadequate inspection of the number 1 and 2 engine cowls by company maintenance personnel and inadequate preflight inspection by the flight engineer, resulting in unsecured cowls separating from the aircraft during takeoff. A factor was unsecured number 1 and…NTSB SEA00LA045Accident · No injuriesLimited investigationFinal reportCessna 150H · Spangle, WAExhaustion of the fuel supply due to a leaking fuel tank system. Factors contributing to the accident were, inaccurate fuel quantity sensors, the lack of suitable terrain in the area of the forced landing, and a fence alongside the dirt upon which the pilot…NTSB SEA00LA043Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Kahlotus, WAThe pilot's failure to maintain sufficient altitude over, or clearance with, a barbed-wire fence. A factor was the fence.NTSB SEA00LA041Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Snohomish, WAThe pilot's improper decision to attempt a go-around, then attempt to stop on the wet grass. Factors include variable winds, the pilot's inadequate compensation for the winds conditions, his inadequate recovery from a bounced landing, wet grass along the side…NTSB SEA00LA036Accident · No injuriesLimited investigationFinal reportBeech D18S · Everett, WALoss of aircraft control during initial climb for undetermined reasons.NTSB SEA00FA037Accident · 1 fatalField investigationFinal reportCessna 150G · Marysville, WAFuel exhaustion due to the non-certificated 'pilot's' failure to determine the fuel quantity prior to takeoff. Factors include a dark night, and a non-iluminated electrical transmission wire strung across the highway upon which the pilot was attempting to…