NTSB investigations, 2003, WA
11 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\") = 2003
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") = 2003 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 SEA04LA007Accident · No injuriesLimited investigationFinal reportCessna 185 · Trout Lake, WAThe failure of the pilot to maintain directional control of the aircraft during the landing roll. A factor was the wet runway.NTSB SEA04LA002Accident · No injuriesLimited investigationFinal reportCessna 172S · Seattle, WAImproper flare during the landing. Excessive airspeed and improper remedial action were factors.NTSB SEA03LA194Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Bremerton, WAAircraft control was not maintained during the landing roll which resulted in the aircraft nosing over.NTSB SEA03LA150Accident · No injuriesLimited investigationFinal reportCessna 185 · Sinclair Is., WAThe pilot's failure to maintain directional control while taxiing for takeoff. Factors contributing to the accident were the ditch and the fence.NTSB SEA03LA120Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Moses Lake, WAAn improper flare which resulted in a bounced landing during landing. The pilot's failure to maintain aircraft control and soft terrain were factors which eventually led to the aircraft nosing over.NTSB SEA03LA103Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe dual student's failure to maintain aircraft control and the flight instructor's delayed remedial action. Contributing factors were the crosswind condition and the flight instructor's lack of experience.NTSB SEA03LA081Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Colville, WAThe pilot's inadequate compensation for wind conditions on landing. A contributing factor was a crosswind.NTSB SEA03LA080Accident · No injuriesLimited investigationFinal reportAllen SA-300 · Yakima, WADirectional control was not maintained during the landing roll. A steering spring disconnected as a result of a tailwheel shimmy was a factor.NTSB SEA03LA071Accident · No injuriesLimited investigationFinal reportCessna 180 · Pasco, WAThe pilot's inadequate remedial action when his aircraft began to veer during the landing roll, and his ultimate failure to maintain directional control which resulted in a ground loop. Factors include the pilot's momentary diversion of his attention during…NTSB SEA03LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Prosser, WAImproper flare while landing. Factors include rough uneven terrain.NTSB SEA03LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAAircraft control was not maintained during the landing roll. A tailwind and a snow bank were factors.