NTSB investigations: Bell OH-58A
8 cases on aircraft the registry lists as Bell OH-58A, where NTSB found Not determined, general. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2023 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181579')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND 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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181579')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '05000000')))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR23LA107Accident · Minor injuriesClass 3 · LimitedFinal reportBell OH-58A · Yuma, AZA total loss of engine power for reasons that could not be determined.NTSB CEN20LA187Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · West Branch, MIThe pilot's failure to maintain rotor rpm during a precautionary autorotation, which resulted in a hard landing. Contributing to the accident was the airframe vibration for reasons that could not be determined because examination of the helicopter revealed no…NTSB CEN19LA121Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Omaha, NEA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA18LA271Accident · Minor injuriesClass 3 · LimitedFinal reportBell OH 58A · Juana Diaz, PRA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN14TA020Accident · Minor injuriesFinal reportBell OH-58A · Jefferson City, MOThe loss of engine power for reasons that could not be determined because postaccident examinations of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA13TA021Accident · Minor injuriesFinal reportBell OH-58A · Jackson, TNA loss of engine power for undetermined reasons because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA10LA499Accident · Serious injuriesLimited investigationFinal reportBell OH-58A · Taylorsville, MSA total loss of engine power while maneuvering at low altitude for undetermined reasons.NTSB ERA10GA015Accident · No injuriesFinal reportBell OH-58A · Ocala, FLThe excessive wear and failure of engine governor components for undetermined reasons, which resulted in a loss of engine power.