NTSB investigations, 1985, OR
5 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\") = 1985
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") = 1985 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 SEA86LA025Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Imnaha, ORPrior to takeoff the pilot taxied through a lot of slush. A nose over occurred while attempting to land on a snow covered clearing. The nose over probably occurred due to very deep snow on the landing area and frozen brakes.NTSB SEA86LA011Accident · No injuriesLimited investigationFinal reportCessna 172 · Lebanon, ORA loss of directional control occurred during landing roll. The acft veered to the right, struck a ditch and then nosed over. A helicopter was hovering to the left of the landing rwy, probably causing enough wake turbulence to cause the loss of directional…NTSB SEA85LA139Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Ontario, ORThe plt reported that when he landed, the wind was gusting to 25 KTS. He stated that when the acft touched down, it encountered a whirlwind that lifted the tail. Subsequently, the acft nosed over & was damaged. According to the 1700 PDT wx observation at…NTSB SEA85LA091Accident · No injuriesLimited investigationFinal reportCessna 185 · Paulina, ORThe plt reported that on 4/11/85, the left tire blew out during a landing at omak, WA, damaging the left wheel & braking sys. He said that repairs had been made, but the left brake felt spongy. The next flt (on 4/12/85) was to a private airstrip at Paulina,…NTSB SEA85LA083Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Burns, ORThe acft veered left and the plt overcorrected with right rudder and a ground loop then occurred. The plt said the brakes needed to be worked on prior to the accident. He said that they were not as effective as they should have been & that he was aware of the…