NTSB investigations, OR
14 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1997 | 3 |
| 1999 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 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\" = 430)
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" = 430) 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 SEA07LA147Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Troy, ORThe inadvertent entanglement of the crewmemeber's helmet's communication cord with the structure of the helicopter during the helicopter's ascent, which resulted in the crewmember being elevated above ground level before the helmet's cord separated, resulting…NTSB SEA06IA105Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Portland, ORThe inadvertent deployment of the off-wing escape slide due to the inadequate latching of the slide compartment door following access by maintenance personnel.NTSB SEA05CA079Accident · Minor injuriesData collectionFinal reportCessna 150 · Independence, ORThe pilot's failure to secure the airplane while starting the engine by hand-propping.NTSB SEA04LA178Accident · Serious injuriesLimited investigationFinal reportHelio H800 · Fossil, ORThe pilot's failure to remove the aileron wing gust locks prior to flight, which resulted in a loss of control during the descent/emergency landing. A factor contributing to the accident was the pilot's inadequate preflight.NTSB SEA99LA098Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Pendleton, ORA fouled external load cable, and the pilot's operation of the helicopter with a non-approved external bucket installation, resulting in misrouted hydraulic lines and consequent malfunction of the external load release system.NTSB SEA98IA027Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Eugene, ORA checklist procedure was not followed. The initiation of an evacuation was a factor.NTSB SEA97LA198Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1B · Dayville, ORImproper installation of the transmission door by a company mechanic, resulting in inflight separation of the door (which then struck the tail rotor system) and consequent total loss of the tail rotor. Contributing to the accident were: inadequate…NTSB SEA97LA085Accident · No injuriesLimited investigationFinal reportBeech 1900D · Portland, ORthe flightcrew's inadequate preflight, and the ramp agent's inadequate dispatch of the aircraft. The unsecured cargo door was a factor.NTSB SEA90LA004Accident · No injuriesLimited investigationFinal reportCessna 310C · Redmond, ORPoor inflight planning, and the pilot did not maintain a proper glide path on final approach, nor perform proper corrective action. Factors related to the accident were: the pilot's attention was diverted due to an open cabin door and the partial loss of…NTSB SEA86LA087Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Warm Springs, ORA precautionary landing was made due to the pilot becoming lost, the aircraft's navigation radio not working, and low fuel. A gusting crosswind was present during landing. On rollout the aircraft's wing tip caught a fence and the aircraft nosed over.NTSB SEA85LA002Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hood River, ORAt about 150 ft AGL on climb out, the tow plane lost power for an unspecified reason. The glider pilot released the tow and executed a 180 degree course reversal to a downwind (15 KTS) landing. During roll out, the left wing contacted the ground, causing an…NTSB SEA83IA116Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Portland, ORA broken hydraulic line near the left main landing gear allowed hydraulic fluid to leak on to the APU exhaust. The resultant smoke then was picked up by the left airpack and was blown into the cabin. The crew then ordered an evacuationof the passengers.NTSB SEA82DA076Accident · Serious injuriesFinal reportCessna 182F · Medford, ORAfter takeoff, engine oil began to accumulate on the windshield and restrict forward visibility. The pilot returned to land, bounced during landing, and elected to go-around. During climbout the aircraft struck trees on rising terrain and crashed. The owner…NTSB SEA82DA057Accident · Serious injuriesFinal reportHiller-Soloy 12E · Christmas Valle, ORThe helicopter was being used to string a transmission line. A rope (attach line) was used to connect the helicopter to the transmission line. The rope became detached and the pilot landed to have it reattached. A man, involved in the ground operations,…