NTSB investigations, OR
18 cases where NTSB found Inspection.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2023 | 4 |
| 2024 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020615'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '020615')) 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 WPR24LA228Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV-12IS · Scappoose, ORThe pilot’s failure to remove the seat belt used as a flight control lock from the right control stick before takeoff, which resulted in a loss of control, an aerodynamic stall, and a collision with terrain during takeoff. Contributing to the accident was the…NTSB WPR24LA031Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK27-2 · Pendleton, ORThe operator’s use of an insufficiently charged battery that resulted in a total loss of engine power and subsequent impact with terrain.NTSB WPR24LA033Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Baker City, ORThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR23LA303Accident · Minor injuriesClass 3 · LimitedFinal reportAldinger Albert John Cozy Mark III · McDermitt, ORThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR23LA309Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Dune City, ORThe pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, and impact with terrain.NTSB WPR22LA060Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Hillsboro, ORThe on-ground collision with a tree during an off airport precautionary landing. Contributing was the partial loss of engine power for undetermined reasons.NTSB WPR20FA016Accident · 1 fatalClass 3 · FieldFinal reportEnstrom 280F · Jordan Valley, ORA partial loss of engine power due to a worn engine air induction hose, and a subsequent uncontrolled descent into terrain. Contributing to the accident was the failure of maintenance personnel to adequately inspect the hose, and the pilot’s decision to fly…NTSB GAA17CA331Accident · Minor injuriesData collectionFinal reportPiper PA25 · Hood River, ORThe pilot's failure to visually check the fuel level prior to takeoff and subsequent mismanagement of the available fuel supply during numerous glider tow flights.NTSB GAA16CA317Accident · Minor injuriesData collectionFinal reportRyan Navion · McMinnville, ORThe pilot's failure to replace the oil filler cap following the preflight inspection, which resulted in a loss of engine oil and engine power, an emergency landing, and impact with terrain.NTSB WPR14CA120Accident · No injuriesData collectionFinal reportPiper PA 16 · Scappoose, ORThe pilot's failure to maintain directional control during landing roll. Contributing to the accident was the pilot's diverted attention and inadequate preflight inspection.NTSB WPR13LA102Accident · No injuriesLimited investigationFinal reportCessna 172RG · Redmond, ORFailure of the left main landing gear pivot assembly during the landing approach.NTSB WPR11LA352Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Troutdale, ORThe in-flight separation of the tail rotor drive shaft cover as a result of maintenance personnel not ensuring that it was secured after a maintenance inspection; also causal was the pilot’s inadequate preflight inspection of the helicopter.NTSB WPR11FA333Accident · 2 fatalField investigationFinal reportDavidson Zenith Stol CH701 · Glendale, ORA total loss of engine power due to fuel starvation and the pilot’s subsequent failure to maintain airplane control during the forced landing. Contributing to the accident was the pilot’s failure to ensure that the fuel valves were in the correct position for…NTSB WPR11CA329Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Albany, ORThe pilot's inadequate preflight inspection and failure to ensure the fuel cap was secured after refueling, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR11LA012Accident · No injuriesLimited investigationFinal reportCessna 172 · Portland, ORThe pilot's inadequate preflight inspection and failure to ensure adequate fuel was onboard for the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR09CA467Accident · No injuriesData collectionFinal reportBeech 35-C33 · Tillamook, ORA loss of engine power due to fuel exhaustion as a result of the pilot's failure to visually verify that sufficient fuel was on board prior to flight. Contributing to the accident was a malfunctioning fuel gage.NTSB WPR09LA219Accident · No injuriesLimited investigationFinal reportEllumax Leasing Epic LT · Astoria, ORThe partial loss of engine power during climb to cruise due to the failure of the engine's fuel control unit. Contributing to the accident was the incorrect machining of an internal component of the fuel control unit, and the failure of the assembling…NTSB LAX08LA080Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Portland, ORThe failure of company maintenance personnel to install the upper pivot bolt through the pivot hole in the upper end of the landing gear actuating rod, and the company maintenance inspector's inadequate inspection of the work performed.