NTSB investigations, 1982, OR
7 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\") = 1982
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") = 1982 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 SEA83IA034Incident · No injuriesIncident investigationFinal reportSwearingen SA-226TC · Klamath Falls, ORDuring takeoff on runway 14 with the winds from 310 deg at 17 knots, satisfactory acceleration occurred through 70 knots followed by a slowing rate of acceleration at 80 knots. The captain then reduced power and shortly thereafter felt the left main tires…NTSB SEA82DA110Accident · No injuriesFinal reportRockwell Int'T S2R · Adrian, ORThe pilot landed on a dirt strip that had just been bladed. After touching down in a 3-point attitude, the aircraft rolled about 100 ft and then veered to the left. The pilot stated that he could not correct the situation with right brake and rudder, and…NTSB SEA82FYM17Accident · 1 fatalFinal reportPiper PA-18 · Yamhill, ORDuring takeoff the aircraft veered off the right side of runway 8 and collided with a split rail fence. The aircraft then crossed a gravel road and struck a wire cattle fence catching on fire within seconds after coming to a stop. The winds were out of the…NTSB SEA82DA068Accident · No injuriesFinal reportde Havilland 2 · 15n Of Medford, ORThe pilot started a downwind takeoff on runway 15 with 9 parachutists on board. The runway was unidirectional requiring takeoffs on runway 15 which sloped downhill. After beginning the takeoff roll, the pilot had difficulity in maintaining directional control…NTSB SEA82DYM12Accident · No injuriesFinal reportPiper PA-28-181 · Albany, ORWhile proceeding from a restaurant parking area to the runway, the aircraft had to be taxied across a bridge. The bridge was 30 ft wide and 50 ft long. It had no side rails and was used to cross a drainage ditch. A slight right turn was required just before…NTSB SEA82DA026Accident · No injuriesFinal reportBellanca 7KCAB · Burns, ORDuring landing in calm wind conditions, the aircraft bounced slightly. On the second touchdown, it veered left and struck a snowbank. The student pilot reported that it seemed like the left brake froze. The left brake was examined for possible dragging and…NTSB SEA82DA021Accident · No injuriesFinal reportCessna 340A · Sunriver, ORThe instructor was providing dual instruction to a private pilot with no previous time in this nor any multi- engine aircraft. Also, the pirvate pilot had not flown within the previous 90 days. He initiated a takeoff on runway 18 with the wind from 210…