Major NTSB investigations, WA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 per year
| 1969 | 2 |
|---|---|
| 1976 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2022 | 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.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch') 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 DCA22MA193Accident · 10 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Freeland, WAThe in-flight unthreading of the clamp nut from the horizontal stabilizer trim actuator barrel due to a missing lock ring, which resulted in the horizontal stabilizer moving to an extreme trailing-edge-down position rendering the airplane’s pitch…NTSB LAX08MA007Accident · 10 fatalMajor investigationFinal reportCessna 208B · Naches, WAThe pilot's failure to maintain an adequate airspeed to avoid an aerodynamic stall while maneuvering. Contributing to the accident were the pilot's impaired physiological state due to hypoxia, the pilot's inadequate preflight weather evaluation, and his…NTSB SEA05MA202Accident · 3 fatalMajor investigationFinal reportAgusta A109A II · Edmonds, WALoss of control for an undetermined reason during maneuvering flight, which resulted in an in-flight collision with water.NTSB DCA90MA011Accident · 6 fatalClass 1 · MajorFinal reportBritish Aerospace BAE-3101 · Pasco, WAThe flightcrew's decision to continue an unstabilized instrument landing system (ILS) approach that led to a stall, most likely of the horizontal stabilizer, and loss of control at low altitude. Contributing to the accident was the air traffic controller's…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…NTSB SEA88MA015Accident · 4 fatalMajor investigationFinal reportCessna 310N · Bellingham, WAThe acft was chartered to take university (wwu) psnl to an alumni dinner. While rtrng at ngt, the plt made a localizer only, ILS rwy 16 apch in marginal VFR conds. Drg the apch, radar svc was terminated & the plt was told to ctc bellinghamradio, but he did…NTSB DCA83AA036Accident · 11 fatalFinal reportLockheed Learstar, L-18-56 · Silvana, WAThe acft was on a sport parachute flt to carry 24 parachutists to 12,500' over a drop zone (dz) for a mass jump. It was in a cargo configuration with no passenger seats, but it had 1 jump seat. There were 24 seat belts on the floor of the cargo area. Also,…NTSB DCA81AA006Accident · 7 fatalClosedBeech 99A · Spokane, WANTSB DCA78AA007Accident · 17 fatalClosedBeech 99 · Richland, WANTSB SEA761S041Incident · No injuriesClosedDouglas DC-9 · Spokane, WANTSB SEA70I0024Incident · No injuriesClosedBoeing 747 · Renton, WANTSB SEA69A0062Accident · 3 fatalClosedConvair 880 · Moses Lake, WA