NTSB investigations, OR
5 cases where the first occurrence was “Forced landing”.
Cases per year
| 1982 | 2 |
|---|---|
| 2004 | 2 |
| 2006 | 1 |
Where
Open the mapLatest 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 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\" = 180)
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 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" = 180) 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 SEA06CA125Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Hood River, ORA loss of lift, which resulted in a forced landing. Trees in the landing area were a contributing factor.NTSB SEA04LA092Accident · Serious injuriesLimited investigationFinal reportStart & Flug H-101 Salto · Creswell, ORThe pilot's failure to maintain clearance from the terrain while attempting to maneuver the aircraft into the wind during an off-airport landing in an open field. Factors include the pilot's inadequate in flight planning, tailwind conditions during an…NTSB SEA04LA079Accident · No injuriesLimited investigationFinal reportSZD Jantar 42-1 · Wamic, ORThe glider pilot's inadequate en route planning, which resulted in a forced landing in an area without suitable landing terrain. Factors include no suitable landing terrain in the area where the pilot found it necessary to execute a forced landing, and trees…NTSB SEA83LA023Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Cascade Locks, ORWhile cruising at 10000 feet MSL, in IMC conditions, the pilot reported that power had been lost. During descent to 2000 feet the engine restarted and failed several times but eventually maintained idle throughout the remainder of the descent. Portland…NTSB SEA82DA115Accident · Minor injuriesFinal reportGrumman AA-5A · Toketee, ORThe pilot calculated the weight of his aircraft to be 90 pounds below the maximum gross weight. The airport density altitude was calculated to be approximately 5000 feet. The pilot stated that after takeoff the aircraft achieved an altitude of 50 to 100 feet…