NTSB investigations, 1983, OR
2 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 3 |
| 1994 | 3 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 3 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 1 |
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\") = 1983
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\" = 310)
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") = 1983 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" = 310) 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 SEA83LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Rome, ORThe acft struck a rock during landing and damaged the landing gear. The pilot was on a fishing trip and landed initiallyon a gravel bar. He decided to move the acft to a longer plateau because of increasing density altitude. Upon landing inthis open field the…NTSB SEA83LA082Accident · No injuriesLimited investigationFinal reportStinson L-5 · Haines, ORThe aircraft collided with a fence during a takeoff and nosed over. The runway was an alfalfa field approximately 1000 feet in length with high growth. The density altitude was 4000 feet. The aircraft did become airborne but settled back to the field, and…