Fatal NTSB investigations, OR
13 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 2 |
|---|---|
| 1986 | 2 |
| 1990 | 3 |
| 1997 | 3 |
| 2003 | 2 |
| 2006 | 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 c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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\" = 353)
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."highestInjuryLevel" = 'Fatal' 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" = 353) 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 SEA06FA038Accident · 1 fatalField investigationFinal reportMooney M20K · North Plains, ORThe pilot's failure to maintain airspeed while maneuvering for a forced landing, resulting in a stall-spin and uncontrolled descent to ground impact. A contributing factor was the loss of engine power due to fuel exhaustion resulting from the pilot's…NTSB SEA03LA157Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-24E · Hood River, ORThe pilot's failure to refuel prior to the flight, resulting in fuel exhaustion during the initial climb, followed by the pilot's failure to maintain airspeed. An inadvertent stall was a factor.NTSB SEA03FA110Accident · 1 fatalField investigationFinal reportHarshbarger W/Reed RV-8 · Grants Pass, ORCorrosion and contamination within the fuel servo unit and the pilot's delayed turn back to the runway. Contributing factors were trees and the pilot's impairment due to prescription medication.NTSB SEA97FA148Accident · 2 fatalField investigationFinal reportBeech 77 · Cottage Grove, ORFuel exhaustion resulting from the pilot's inadequate preflight planning/preparation and his failure to maintain adequate airspeed during a forced landing approach, resulting in a stall. A related factor was the pilot's failure to refuel.NTSB SEA97FA130Accident · 1 fatalField investigationFinal reportLockheed P-38L · Tillamook, ORfailure of the pilot to maintain minimum control speed (VMC), after loss of power in one engine, which resulted in a loss of aircraft control and collision with terrain. Related factors were: the pilot's improper fuel management and failure to change the fuel…NTSB SEA97FA094Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Klammath Falls, ORThe pilot's failure to set the throttle of his second failed engine to 'Cracked-1/2-Open' as called for in the Engine Failure/Restart checklist, followed by a high-power engine surge. Factors include the pilot's delay in landing for refueling, the pilot…NTSB SEA91FA038Accident · 2 fatalField investigationFinal reportCessna 182B · Estacada, ORA power loss due to carburetor ice, and missing muffler cones as a result of inadequate maintenance inspection. In addition, the pilot failed to maintain adequate airspeed during the forced landing which resulted in a stall.NTSB SEA90LA095Accident · 1 fatalLimited investigationFinal reportGrace Long EZ · La Grande, ORLoss of engine power due to fuel contamination which resulted from the pilot's inadequate preflight inspection of the aircraft.NTSB SEA90FA047Accident · 2 fatalField investigationFinal reportBurton Cavalier Model 2 · Grants Pass, ORFuel exhaustion which resulted from the pilots intentionally operating the aircraft with a known deficiency. The pilot failed to maintain airspeed, resulting in a stall/spin and uncontrolled descent.NTSB SEA86FA155Accident · 2 fatalField investigationFinal reportAeronca 7AC · Mulino, ORThe pvt plt had been giving rides around the local area for about an hour. He had just dropped off one passenger and picked up another. The acft taxied from the ramp to the rwy 30 and made a normal takeoff. During crosswind turn the engine started to miss and…NTSB SEA86FA073Accident · 1 fatalField investigationFinal reportAerospatiale SE 318C · Siletz, ORThe plt unsuccessfully attempted to lift a 1597 lb load of cedar blocks which would have placed the helicopter aprx 880 lbs over its max gross weight with an external load. The plt was setting the load down for ground personnel to unload some of the blocks…NTSB SEA82FA117Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Portland, ORThe pilot, enrolled in a course for a commercial pilot certificate, was scheduled for a solo flight from seattle to bremerton, Washington and return. He departed at about 1300 PDT. At about 1635 PDT, residents near the crash site reported that they saw and…NTSB SEA82FYM18Accident · 2 fatalFinal reportMccall KR-2 · Union, ORReportedly, the aircraft departed la grande, OR with 12 gallons of fuel on board and was flown to baker, OR. Later, the pilot departed baker on a return flight to la grande without refueling. Subsequently, the plane was reported as missing. The next day it…