NTSB investigations, OH
13 cases where the defining event was Collision during takeoff/land.
Cases per year
| 2009 | 2 |
|---|---|
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 2 |
| 2016 | 2 |
| 2019 | 1 |
| 2022 | 1 |
| 2025 | 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\" = 'OH' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '490')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '490') 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 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 ERA22LA334Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter AS365 · Hamilton, OHThe pilot’s decision to continue the landing without having visually identified wires that were known to be in the vicinity of the landing zone, which resulted in a collision with the wires while attempting an off-airport landing in dark night visual…NTSB GAA20CA073Accident · Minor injuriesData collectionFinal reportSchleicher ASW15 · Waynesville, OHThe glider pilot's improper approach during landing, which resulted in collision with trees.NTSB CEN16LA342Accident · No injuriesLimited investigationFinal reportFairchild M 62A-3 · Madison, OHThe pilot's failure to follow the Before Takeoff checklist and his improper use of flaps during takeoff, which degraded the airplane's climb performance and resulted in a collision with trees.NTSB CEN16LA311Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Cardington, OHThe partial loss of engine power due to carburetor icing during an attempted go-around.NTSB CEN13CA031Accident · No injuriesData collectionFinal reportCessna 150 · Carrollton, OHThe airplane’s collision with two deer during the takeoff roll.NTSB CEN12LA569Accident · No injuriesLimited investigationFinal reportPiper PA28 · Leesburg, OHThe pilot's improper preflight planning and decision to attempt a takeoff from a runway that was too short for conditions, which resulted in the airplane settling into terrain.NTSB CEN11LA451Accident · No injuriesLimited investigationFinal reportMaule MXT-7-180A · New Carlisle, OHThe pilot's failure to conduct a go-around once he recognized he was going to land long on the runway.NTSB CEN11CA147Accident · Minor injuriesData collectionFinal reportPegasus 503 Sport · Cambridge, OHThe pilot's failure to maintain clearance from trees and terrain during the landing approach.NTSB CEN11LA102Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctls · Willard, OHA total loss of engine power during cruise flight due to fatigue failure of a cylinder exhaust spring.NTSB CEN10CA296Accident · Minor injuriesData collectionFinal reportMooney M20M · Port Clinton, OHThe pilot’s delayed decision to abort the landing and his failure to properly reconfigure the airplane during the aborted landing attempt.NTSB CEN09CA588Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf · New London, OHThe pilot's failure to maintain clearance from an obstacle during takeoff and the flight instructor's inadequate supervision.NTSB CEN09CA449Accident · No injuriesData collectionFinal reportFoglio Tiger CUB · Toronto, OHThe pilot not turning off the carburetor heat prior to takeoff resulting in the engine's reduced performance, and his failure to remain clear of the tree during takeoff.