Fatal NTSB investigations, 2020
14 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\") = 2020
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") = 2020 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 ERA21WA086Accident · 1 fatalClass 5 · ForeignBell 206 · Mambucaba, BrazilNTSB CEN21LA055Accident · 2 fatalClass 3 · LimitedFinal reportCessna 182R · Rockwall, TXThe pilot’s decision to continue an unstabilized approach and his delayed go-around decision, which resulted in the airplane’s impact with power lines and the ground. Contributing to the accident was the inaccurate wind direction reporting as a result of a…NTSB WPR21FA044Accident · 1 fatalClass 3 · FieldFinal reportPiper PA38 · Grass Valley, CAA total loss of engine power due to the pilot’s improper fuel management, which resulted in fuel starvation.NTSB CEN20LA401Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA32 · Kokomo, INThe pilot’s inadequate visual lookout, which resulted in a collision with a utility pole and the subsequent collision with terrain.NTSB CEN20LA352Accident · 1 fatalClass 3 · LimitedFinal reportBeech 200 · Rockford, ILThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined based on the available evidence.NTSB CEN20LA305Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · San Antonio, TXThe pilot’s improper decision to take off in an airplane over maximum gross weight and with a tailwind, which prevented the airplane from climbing.NTSB CEN20LA271Accident · 1 fatalClass 3 · LimitedFinal reportCessna T188 · Dustin, OKThe pilot’s continued takeoff without ensuring obstacles could be avoided due to his use of a sedating medication, which likely diminished his reaction time and flying performance.NTSB ERA20LA234Accident · 1 fatalClass 3 · LimitedFinal reportEvektor Aerotechnik Sportstar · Ocala, FLThe pilot’s impairment or distraction due to an acute stroke, which resulted in an unstabilized approach and subsequent loss of airplane control during landing.NTSB CEN20LA256Accident · 1 fatalClass 3 · LimitedFinal reportCessna 320 · Round Rock, TXImproper maintenance that led to a loss of engine power due to a failed left engine magneto, the pilot’s improper application of single engine emergency procedures, and his failure to maintain control of the airplane which resulted in a collision with trees.NTSB CEN20LA227Accident · 1 fatalClass 2 · LimitedFinal reportVans RV8 · Mandan, NDThe pilot's failure to remove the seat belt used as a flight control lock from the aft cockpit control stick before takeoff, which resulted in a loss of control during takeoff and collision with terrain.NTSB ERA20LA183Accident · 1 fatalClass 3 · LimitedFinal reportErcoupe 415 · Rogersville, TNThe pilot's failure to maintain a proper glidepath on approach, which resulted in an inflight collision with trees and terrain. Contributing to the accident was the pilot’s use of an impairing medication.NTSB WPR20LA128Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA31T · Billings, MTThe degraded airplane performance after takeoff for reasons that could not be determined from available evidence.NTSB ERA20WA173Accident · 1 fatalForeign investigationPiper PA25 · Matoes do Norte, BrazilThe government of Brazil has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on April 18, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB WPR20WA107Accident · 5 fatalForeign investigationCessna 404 · Lockhart River, AustraliaThe government of Australia has notified the NTSB of an accident involving a Cessna 404 airplane that occurred on March 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…