Fatal NTSB investigations, 2019
9 cases where the sequence of events included Collision during takeoff/land.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 7 |
| 2010 | 6 |
| 2011 | 5 |
| 2012 | 10 |
| 2013 | 4 |
| 2014 | 10 |
| 2015 | 9 |
| 2016 | 7 |
| 2017 | 8 |
| 2018 | 7 |
| 2019 | 9 |
| 2020 | 14 |
| 2021 | 15 |
| 2022 | 18 |
| 2023 | 8 |
| 2024 | 7 |
| 2025 | 6 |
| 2026 | 8 |
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 year(c.\"eventDate\") = 2019
AND c.\"highestInjuryLevel\" = 'Fatal'
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 year(c."eventDate") = 2019 AND c."highestInjuryLevel" = 'Fatal' 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 ERA20WA041Accident · 3 fatalForeign investigationCessna 550 · Marau, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 550 airplane that occurred on November 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB WPR20FA008Accident · 2 fatalClass 3 · FieldFinal reportPiper PA 24 · Angel Fire, NMThe airplane’s degraded performance due to high-density altitude and gusting wind conditions, which resulted in its inability to maintain altitude during the initial takeoff climb. Contributing to the accident was the pilot’s lack of experience with high…NTSB CEN20FA008Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7AC · Green Bay, WIThe pilot’s low final approach path and his failure to see and avoid a truck traveling on a roadway, which resulted in a collision with the truck.NTSB ERA19WA271Accident · 7 fatalForeign investigationPiper PA31 · Popayan, ColombiaThe government of Colombia has notified the NTSB of an accident involving a PIPER PA31 airplane that occurred on September 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB WPR19FA244Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · McKenzie Bridge, ORThe pilot's delayed climb and misjudgment of the airplane’s performance and the runway distance needed to clear obstacles at the end of the runway, which resulted in a collision with trees and subsequent impact with terrain. Contributing to the accident was…NTSB CEN19FA211Accident · 1 fatalClass 2 · FieldFinal reportGrob G103 · Brandon, MSThe pilot's inadequate clearance from a tree during an attempted off-field landing.NTSB ANC19FA026Accident · 3 fatalField investigationFinal reportHelio H 250 · Seward, AKThe pilot's failure to maintain clearance from trees during takeoff, which resulted in an in-flight collision, a loss of control, and impact with terrain.NTSB ANC19FA021Accident · 1 fatalClass 2 · FieldFinal reportBradshaw / McCauley Giles G-202 · Wasilla, AKThe pilot's failure to maintain control after the partial loss of engine power. Contributing to the accident was a contamination of the fuel system, which likely seized the electric fuel pump and restricted fuel flow to the engine.NTSB ERA19WA198Accident · 4 fatalForeign investigationDiamond DA 62 · Dubai, United Arab EmiratesThe government of United Arab Emirates has notified the NTSB of an accident involving a Diamond DA 62 airplane that occurred on May 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Arab Emirates's…