NTSB investigations, 2000, WA
7 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 9 |
| 1984 | 8 |
| 1985 | 4 |
| 1986 | 10 |
| 1987 | 8 |
| 1988 | 7 |
| 1989 | 8 |
| 1990 | 9 |
| 1991 | 13 |
| 1992 | 6 |
| 1993 | 6 |
| 1994 | 10 |
| 1995 | 5 |
| 1996 | 5 |
| 1997 | 7 |
| 1998 | 6 |
| 1999 | 12 |
| 2000 | 7 |
| 2001 | 6 |
| 2002 | 5 |
| 2003 | 11 |
| 2004 | 13 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 10 |
Where
Latest 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 year(c.\"eventDate\") = 2000
AND 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\" = 260)
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' 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" = 260) 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 SEA01LA007Accident · No injuriesLimited investigationFinal reportBeech N35 · Arlington, WAThe pilot's failure to abort the takeoff upon experiencing directional control difficulties. Factors included the pilot's failure or inability to maintain directional control, and a taxiway sign.NTSB SEA00LA178Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Tacoma, WAThe pilot's inadequate compensation for winds and his failure to maintain directional control. Factors include a gusting crosswind.NTSB SEA00LA171Accident · No injuriesLimited investigationFinal reportCessna 180H · Roche Harbor, WAThe pilot's failure to adequately compensate for wind conditions during landing.NTSB SEA00LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ephrata, WAThe pilot-in-command's failure to maintain directional control during landing roll.NTSB SEA00LA101Accident · Minor injuriesLimited investigationFinal reportBell 206B · Bridgeport, WAAircraft control was not maintained. Inadequate remedial action and diverted attention were factors.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 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.