NTSB investigations
107 cases where the sequence of events included Wildlife encounter (non-bird).
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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '310' 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '310' 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 CEN09CA515Accident · No injuriesData collectionFinal reportCessna TR182 · Carrollton, OHThe airplane's impact with the deer during the night landing.NTSB CEN09CA049Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Blaine, MNThe deer impacting the airplane during takeoff roll.NTSB NYC08CA327Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Beverly, MAAn inadvertent collision with a deer while landing.NTSB MIA08CA198Accident · No injuriesData collectionFinal reportMooney M20S · New Castle, PAThe on-ground collision with a deer during the takeoff roll. A contributing factor in the accident was the failure to completely secure the airport perimeter.NTSB CHI08CA178Accident · No injuriesData collectionFinal reportMooney M20K · Howell, MIThe collision with a deer during the takeoff roll. Contributing to the accident was the dusk light condition.NTSB LAX08CA186Accident · No injuriesData collectionFinal reportAlon A2 · Sandpoint, IDThe airplane struck a deer on the runway while performing touch-and-go landings. Contributing to the accident was the dusk light condition.NTSB NYC08CA084Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Brooksville, FLA deer darting into the path of the airplane during the landing roll.