NTSB investigations, FL
56 cases where the sequence of events included Collision during takeoff/land.
Cases, newest first
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\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '490' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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" = 'FL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '490' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA09CA073Accident · Minor injuriesData collectionFinal reportExtra Flugzeugbau EA 300/L · Tampa, FLThe pilot's inadequate visual lookout, which resulted in a collision with an object.NTSB MIA08LA164Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Arcaida, FLThe pilot's failure to maintain a proper climb rate after takeoff.NTSB NYC08CA276Accident · No injuriesData collectionFinal reportCessna A188B · Gardner, FLThe pilot's misjudged distance/altitude during takeoff.NTSB MIA08FA144Accident · 3 fatalField investigationFinal reportBeech A-36 · Tampa, FLThe pilot's improper decision to take off with a tailwind and his failure to maintain runway alignment during initial takeoff climb.NTSB NYC08CA128Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Apopka, FLThe pilot's failure to maintain clearance/altitude while on the final leg of the approach.NTSB NYC08CA092Accident · Minor injuriesData collectionFinal reportKral Series 5 Kitfox · Fruitland Park, FLThe pilot's failure to maintain adequate clearance from obstructions during the landing approach. Contributing to the accident was the reduced visibility due to sunglare and haze.