NTSB investigations, OR
16 cases where the sequence of events included Part(s) separation from AC.
Cases per year
| 2011 | 2 |
|---|---|
| 2012 | 2 |
| 2013 | 2 |
| 2017 | 1 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 1 |
| 2023 | 1 |
| 2024 | 2 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '338' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '338' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR24LA260Accident · No injuriesClass 3 · LimitedFinal reportKitfox Series V · La Grande, ORSeparation of the propeller blades from progressive damage at the blade roots due to overtightening of the hub bolts.NTSB DCA24MA063Accident · Minor injuriesClass 1 · MajorFinal reportBoeing 737-9 · Portland, ORthe in-flight separation of the left mid exit door (MED) plug due to Boeing Commercial Airplanes’ failure to provide adequate training, guidance, and oversight necessary to ensure that manufacturing personnel could consistently and correctly comply with its…NTSB WPR23FA141Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Oxbow, ORThe pilot’s continued visual flight into instrument meteorological conditions, resulting in airframe ice accretion and a subsequent loss of airplane control.NTSB WPR20LA224Accident · 1 fatalClass 3 · LimitedFinal reportHiller UH 12D · Mehama, ORAn in-flight separation of a tail rotor blade due to fatigue cracking and overstress, which resulted in a loss of directional control and subsequent ground impact.NTSB WPR19LA169Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Independence, ORFatigue failure of the right landing gear axle, which resulted in a loss of control during the landing roll.NTSB GAA19CA185Accident · Minor injuriesData collectionFinal reportRockwell S 2R · Hermiston, ORThe pilot's distraction due to a spray handle opening and his improper pitch trim setting during final approach, which resulted in an excessive pitchdown when he took his hand off the controls to close the handle.NTSB GAA18CA569Accident · No injuriesData collectionFinal reportMaule M7 · Grass Valley, ORThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA176Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Ontario, ORThe flight instructor's failure to maintain directional control during landing, in cross wind conditions.NTSB GAA18CA108Accident · No injuriesData collectionFinal reportPiper J3L · Astoria, ORThe control stick handgrip separation from the control stick resulting in the airplane pitching forward, which resulted in hard landing.NTSB WPR17LA116Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA 300/S · Pendelton, ORThe pilot’s failure to follow checklists to ensure the canopy was secured before takeoff.NTSB WPR13FA411Accident · 1 fatalField investigationFinal reportBell UH 1B · Detroit, ORThe fatigue failure of the upper two tailboom attachment points, which resulted in the tailboom separating from the fuselage during logging operations. Contributing to the accident was poor maintenance throughout the helicopter’s operational life.NTSB WPR13LA174Accident · No injuriesLimited investigationFinal reportVans RV12 · Waldport, ORThe pilot’s improper flare, which resulted in a hard landing.NTSB WPR13FA056Accident · 2 fatalField investigationFinal reportMcdaniel RV-6-CH · Scio, ORThe pilot's decision to perform aerobatics in an airplane that was prohibited from aerobatics as stated in its operating limitations document, which resulted in the failure of the right wing spar.NTSB WPR13FA006Accident · Minor injuriesField investigationFinal reportGarlick Helicopters UH-1H · Shady Cove, ORThe separation of the tail rotor gearbox and tail rotor assembly as a result of fatigue to the tail rotor gearbox input quill assembly attachment studs.NTSB WPR11LA412Accident · No injuriesLimited investigationFinal reportWheeler Vans RV-6A · Albany, ORThe in-flight separation of a propeller blade due to fatigue.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.