NTSB investigations, AL
7 cases where the defining event was Collision during takeoff/land.
Cases per year
| 2011 | 1 |
|---|---|
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2026 | 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\" = 'AL' 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" = 'AL' 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 ERA26LA285Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Tuscumbia, ALThe pilot’s failure to keep the tail rotor clear of an obstacle while attempting to land.NTSB ERA18LA188Accident · 1 fatalLimited investigationFinal reportNorthwing 17 · Section, ALThe noncertificated pilot's failure to maintain control of the weight-shift-control aircraft during an aborted landing. Contributing to the accident was the pilot's lack of flight experience in the aircraft.NTSB GAA18CA284Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · Bayou La Batre, ALThe pilot’s improper planning for landing on a wet grass airstrip, which resulted in a runway overrun.NTSB ERA17CA087Accident · Serious injuriesData collectionFinal reportCessna 170 · Hayden, ALThe pilot’s failure to maintain clearance from trees during the approach.NTSB ERA16LA171Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Foley, ALThe pilot's failure to obtain proper takeoff speed before breaking ground, which resulted in the airplane’s failure to gain altitude and a collision with trees and terrain.NTSB ERA15CA364Accident · Minor injuriesData collectionFinal reportHughes 269B · Hartford, ALThe pilot's inadequate preflight planning, and his subsequent failure to attain adequate altitude during takeoff, which resulted in a collision with a wire fence.NTSB ERA11CA353Accident · No injuriesData collectionFinal reportHead Balloons AX8-88 · Summerdale, ALThe balloon pilot's failure to maintain proper altitude/clearance from a tree line during the landing approach.