NTSB investigations, OH
23 cases where NTSB found Altitude.
Cases per year
| 2008 | 3 |
|---|---|
| 2010 | 2 |
| 2011 | 3 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 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 c.\"eventStateOrRegion\" = 'OH' 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\", '01062012'))
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" = 'OH' 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", '01062012')) 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 ERA26LA311Accident · No injuriesClass 4 · LimitedFinal reportHPH Glasflugel 304CZ · Xenia, OHThe glider’s encounter with atmospheric conditions where lift was not sufficient to maintain flight.NTSB ERA26LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Zanesville, OHThe pilot’s failure to maintain clearance from a power line during an approach to land.NTSB ERA24LA220Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · New Washington, OHThe pilot’s failure to maintain clearance from powerlines during an aerial application flight.NTSB ERA24FA120Accident · 3 fatalClass 3 · FieldFinal reportPiper PA32 · Jackson, OHThe non-instrument-rated pilot’s decision to depart under visual flight rules into instrument meteorological conditions, which resulted in an inflight collision with terrain while maneuvering.NTSB ERA23FA317Accident · 1 fatalClass 3 · FieldFinal reportBell 206-L4 · Springfield, OHThe pilot’s failure to remain clear of powerlines during an agricultural spraying operation.NTSB CEN22FA131Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Fostoria, OHThe pilot’s loss of airplane control in night instrument meteorological conditions during the procedure turn of an instrument approach due to spatial disorientation, which resulted in a collision with terrain.NTSB CEN22FA113Accident · 1 fatalClass 3 · FieldFinal reportCessna 182T · Heath, OHThe pilot’s failure to maintain altitude after takeoff, which resulted in collision with trees and terrain.NTSB CEN21LA034Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Lebanon, OHImproper maintenance that resulted in a blocked crankcase breather port and a subsequent total loss of engine power.NTSB CEN20CA312Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT 602 · Tiro, OHThe pilot's failure to maintain clearance while attempting to fly under power lines during an aerial application pass.NTSB CEN19FA072Accident · 3 fatalClass 1 · FieldFinal reportBell 407 · Zaleski, OHThe NTSB determines that the probable cause of this accident was Survival Flight's inadequate management of safety, which normalized pilots' and operations control specialists' noncompliance with risk analysis procedures and resulted in the initiation of the…NTSB CEN17FA258Accident · 2 fatalField investigationFinal reportPiper PA 28-181 · Waterford, OHThe pilot's loss of airplane control due to spatial disorientation in instrument meteorological conditions.NTSB CEN17FA016Accident · 2 fatalField investigationFinal reportMakela RV-4 · Oregonia, OHThe pilot's decision to fly at a low altitude, which resulted in the collision with a zipline.NTSB CEN16FA370Accident · 2 fatalField investigationFinal reportPiper PA 11 · Arcanum, OHThe student pilot's reckless flying attitude and use of multiple psychoactive drugs, which likely impaired his ability to maintain clearance from terrain while maneuvering at low altitude.NTSB GAA15LA027Accident · Serious injuriesLimited investigationFinal reportCub Crafters CC18 180 · Westfield Township, OHThe pilot’s failure to maintain clearance from trees during a base-to-final turn while landing toward the sun.NTSB CEN13FA274Accident · 2 fatalField investigationFinal reportBoeing-Stearman IB75A · Dayton, OHThe pilot's controlled flight into terrain. Contributing to the accident was the pilot's modified airshow maneuver, which placed the airplane at low altitude and airspeed and out of position within the performance area.NTSB CEN12LA112Accident · 1 fatalLimited investigationFinal reportAmerican Champion 8KCAB · Marysville, OHThe pilot’s failure to maintain sufficient altitude from the terrain while performing low-level aerobatics.NTSB CEN11FA557Accident · 3 fatalField investigationFinal reportPiper PA-23 · Millersburg, OHThe pilot’s failure to maintain clearance with terrain during the landing approach in night conditions and fog. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB CEN11FA420Accident · 1 fatalField investigationFinal reportLuscombe 8A · Farmdale, OHThe pilot's decision to initiate an aerobatic maneuver at an altitude that did not allow for full recovery of the airplane before ground impact.NTSB CEN10LA418Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Clyde, OHThe pilot's failure to maintain clearance from a grain auger during aerial application maneuvers.NTSB CEN10CA225Accident · Minor injuriesData collectionFinal reportSchweizer SGS1-34 · Waynesville, OHThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB CHI08CA186Accident · No injuriesData collectionFinal reportNaval Aircraft Factory N3N-3 · Luckey, OHThe pilot not maintaining clearance from the high vegetation during the off airport landing. Contributing to the accident was the high vegetation.NTSB CHI08CA139Accident · No injuriesData collectionFinal reportCessna 172N · Blue Ash, OHThe separation of the throttle cable from the linkage during the approach to land and the altitude/clearance not being available to the pilot during the forced landing. Contributing to the accident was the electrical wires the airplane impacted.NTSB CHI08CA103Accident · No injuriesData collectionFinal reportKoleno Titan T-51 · Geneva, OHThe failure of the propeller pitch control mechanism during approach. Contributing to the accident were the inability of the pilot to maintain airspeed and altitude, and the unsuitable terrain.