NTSB investigations, 1990, OR
9 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\") = 1990
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") = 1990 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 SEA90LA184Accident · No injuriesLimited investigationFinal reportCessna 180 · Enterprise, ORThe pilot's failure to maintain directional control of the aircraft during landing.NTSB SEA90LA151Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Klamath Falls, ORPilot's failure to maintain directional control during the landing roll, resulting in a ground loop. The pilot's lack of experience in this make/model was a related factor.NTSB SEA90LA073Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Newberg, ORThe pilot did not maintain directional control duing the landing.NTSB SEA90LA063Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Scio, ORAn inadequate recovery from a bounced landing and inadequate clearance to avoid colliding with trees.NTSB SEA90LA062Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Hillsboro, ORPilot displayed poor starting procedures by proceeding with known deficiencies with the parking brake and the inadequacies of the tie down. The pilot did not attain assistance for this procedure which resulted in the airplane getting away and colliding with…NTSB SEA90LA059Accident · No injuriesLimited investigationFinal reportStearman 4E · Burns, ORThe pilot's failure to maintain directional control.NTSB SEA90LA058Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Redmond, ORPilot did maintain directional control of the airplane during the takeoff ground run. The pilot was unable to adequately correct the situation before the airplane exited the runway and ground looped resulting in the collapse of the main landing gear.NTSB SEA90LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Yamhill, ORThe pilot's selection of unsuitable terrain. Factors related to the accident were: the runway conditions and the tree.NTSB SEA90LA041Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Sun River, ORThe pilot's failure to properly compensate for strong crosswinds during takeoff ground roll.