NTSB investigations, 1998, OR
2 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 6 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 4 |
| 1987 | 1 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 7 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 6 |
| 1996 | 5 |
| 1997 | 5 |
| 1998 | 2 |
| 1999 | 6 |
| 2000 | 4 |
| 2001 | 2 |
| 2002 | 2 |
| 2004 | 2 |
| 2005 | 5 |
| 2006 | 3 |
| 2007 | 4 |
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\") = 1998
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\" = 230)
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") = 1998 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" = 230) 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 SEA98LA184Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Flying M Ranch, ORThe pilot's failure to maintain an airspeed above stalling speed (Vs), and the resultant stall/mush of the aircraft into the terrain. Factors include the pilot's improper decision to attempt a go-around into rising terrain, landing with a tailwind, and trees…NTSB SEA98LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Miltonfreewater, ORThe pilots failure to maintain proper terrain clearance. Factors contributing to the accident are high density altitude and rising terrain.