NTSB investigations, 2004, OR
6 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 5 |
| 1984 | 7 |
| 1985 | 5 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 4 |
| 1990 | 9 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 4 |
| 1994 | 4 |
| 1995 | 6 |
| 1996 | 3 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 4 |
| 2000 | 9 |
| 2001 | 8 |
| 2002 | 3 |
| 2003 | 10 |
| 2004 | 6 |
| 2005 | 5 |
| 2006 | 3 |
| 2007 | 5 |
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\") = 2004
AND c.\"eventStateOrRegion\" = 'OR' 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") = 2004 AND c."eventStateOrRegion" = 'OR' 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 SEA05LA015Accident · No injuriesLimited investigationFinal reportLuscombe 11A · Redmond, ORThe student pilot's failure to maintain directional control during the landing roll. Also causal were the instructor's inadequate supervision and remedial action. Factors include soft terrain just off the side of the runway.NTSB SEA05CA003Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Medford, ORThe pilot's inadequate compensation for crosswind conditions during landing, resulting in his failure to maintain directional control. Factors include the presence of crosswinds.NTSB SEA04LA187Accident · Minor injuriesLimited investigationFinal reportWSK PZL Warzawa-Okecie PZL-104 Wilga 80 · The Dalles, ORAircraft control was not maintained by the tow plane pilot and the glider pilot did not maintain a proper climb rate during the initial climb. A direct crosswind and wind gusts were factors.NTSB SEA04CA171Accident · Minor injuriesData collectionFinal reportCessna 182P · Hillsboro, ORThe pilot's failure to maintain aircraft directional control during landing roll. A contributing factor was the right-quartering tail wind.NTSB SEA04LA108Accident · No injuriesLimited investigationFinal reportCessna 421B · Bend, OROn ground encounter with terrain during the takeoff roll as a result of the left side brake not operating. Inadequate maintenance inspection, overload of the nose landing gear and soft terrain were factors.NTSB SEA04LA040Accident · No injuriesLimited investigationFinal reportLancair LC42-550FG · Redmond, ORThe pilot rated passenger's failure to maintain directional control during the landing roll. Inadequate supervision by the pilot-in-command (CFI) and a taxiway sign were factors.