NTSB investigations, 2012, OR
7 cases where NTSB found Not determined, general.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2010 | 8 |
| 2012 | 7 |
| 2013 | 3 |
| 2014 | 4 |
| 2015 | 6 |
| 2016 | 3 |
| 2018 | 3 |
| 2019 | 4 |
| 2020 | 4 |
| 2021 | 6 |
| 2024 | 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 year(c.\"eventDate\") = 2012
AND 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\", '05000000'))
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 year(c."eventDate") = 2012 AND 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", '05000000')) 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 WPR12LA439Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eugene, ORA total loss of engine power due to fuel exhaustion during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have resulted in the loss of engine power.NTSB WPR12LA366Accident · No injuriesLimited investigationFinal reportPiper PA-30 B · Scappoose, ORThe failure of the landing gear to fully extend as a result of a failure of the landing gear transmission assembly for reasons that could not be determined based on the available evidence.NTSB WPR12LA347Accident · Minor injuriesLimited investigationFinal reportHiller UH-12D · Deer Island, ORA loss of helicopter control while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA324Accident · No injuriesLimited investigationFinal reportHawker Beechcraft G58 · Medford, ORA loss of directional control on landing for reasons that could not be determined based on the available evidence.NTSB WPR12FA193Accident · No injuriesField investigationFinal reportCessna 560XL · Eugene, ORAn uncommanded landing gear retraction after touchdown for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR12FA180Accident · 2 fatalField investigationFinal reportLeague Lancair IV-TP · Sisters, ORThe pilots’ inability to maintain control of the airplane and arrest a steep spiral dive while maneuvering for reasons that could not be determined because postaccident examination could not identify any anomalies that would have precluded normal operation…NTSB WPR12LA181Accident · No injuriesLimited investigationFinal reportCub Crafters CC11-100 · Monmouth, ORA partial loss of engine power during takeoff for undetermined reasons.