NTSB investigations, OR
6 cases where NTSB found Organizational issues.
Cases per year
| 2010 | 1 |
|---|---|
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2023 | 1 |
| 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\", '04'))
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", '04')) 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 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 WPR23LA255Accident · Serious injuriesClass 3 · LimitedFinal reportAvia Stroitel AC-5M · North Plains, ORThe pilot’s failure to maintain control of the motor glider, which resulted in an inflight overstress separation of the right wing during a high-speed, high-wing-load spiral dive recovery. Contributing to the accident was the inadequately manufactured wing…NTSB WPR14LA160Accident · Serious injuriesLimited investigationFinal reportAgustawestland AW109SP · Astoria, ORThe decision by the ship pilot and the helicopter crew to lower the ship pilot to a location on the ship that did not provide the helicopter pilot with an adequate view of the ship. Contributing to the accident was the inadequate pre-mission coordination…NTSB WPR13LA396Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Sisters, ORThe pilot's inadequate preflight fuel planning and poor decision-making, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the lack of documentation describing the limitations of the airplane’s fuel…NTSB WPR12LA329Accident · No injuriesLimited investigationFinal reportInterplane Skyboy EX · Sandy, ORA partial loss of engine power during takeoff due to carburetor icing. Contributing to the accident was the lack of a carburetor heat system installed on the airplane.NTSB WPR11FA052Accident · No injuriesField investigationFinal reportGates Lear Jet 25B · Portland, ORThe failure of the flight crew to stop the airplane on the runway due to the flying pilot’s failure to attain the proper touchdown point. Contributing to the accident was an anti-skid system that was not performing optimally, which allowed the airplane to…