NTSB investigations, 2020
24 cases where NTSB found Physical.
Cases per year
| 2008 | 50 |
|---|---|
| 2009 | 45 |
| 2010 | 50 |
| 2011 | 62 |
| 2012 | 48 |
| 2013 | 45 |
| 2014 | 47 |
| 2015 | 56 |
| 2016 | 43 |
| 2017 | 39 |
| 2018 | 25 |
| 2019 | 31 |
| 2020 | 24 |
| 2021 | 21 |
| 2022 | 36 |
| 2023 | 22 |
| 2024 | 18 |
| 2025 | 9 |
| 2026 | 3 |
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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0201'))
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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0201')) 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 CEN21LA089Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA28 · Bossier City, LAThe student pilot’s decision to conduct a flight during night instrument meteorological conditions and his loss of airplane control due to spatial disorientation. Contributing to the accident was the student pilot’s use of an amphetamine and his attention…NTSB CEN21LA084Accident · 2 fatalClass 3 · LimitedFinal reportRobinson R44 · Colorado City, TXThe pilot’s loss of control and exceedance of performance and/or structural limitations during low-altitude operations, which resulted in an inflight breakup.. Contributing to the accident was the pilot’s impairment from the effects of tetrahydrocannabinol.NTSB CEN21LA080Accident · 1 fatalClass 3 · LimitedFinal reportVans RV6 · Hitchcock, TXThe pilot’s impairment by the effects of ingested alcohol, which resulted in the loss of airplane control and impact with terrain.NTSB CEN21LA070Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA38 · Franklin, ARThe impairment of both pilots from carbon monoxide exposure due to a degraded muffler. Contributing to the accident was the inadequate maintenance inspection, which failed to detect the degraded muffler.NTSB CEN21FA043Accident · 1 fatalClass 3 · FieldFinal reportBeech J35 · Fredericksburg, TXThe pilot of the J35’s failure to maintain clearance from the M35, which resulted in a midair collision and the J35 pilot’s subsequent loss of control and impact with terrain.NTSB CEN21LA030Accident · 1 fatalClass 3 · LimitedFinal reportCessna 210 · Lubbock, TXThe pilot’s improper decision to fly into icing conditions with an airplane that was not equipped for icing, which led to structural icing and a subsequent loss of airplane control, and the pilot’s impairment from carbon monoxide poisoning due to a cracked…NTSB ERA21LA020Accident · 1 fatalClass 3 · LimitedFinal reportAero Commander 100 · Citra, FLThe student pilot’s inadequate preflight planning likely due to impairment from ethanol, which resulted in a total loss of engine power due to fuel exhaustion. Contributing was his improper decision to depart from an unlit airstrip in dark night conditions.NTSB CEN20LA407Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver MX II · Marengo, INA loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s decision to operate the airplane in conditions conducive to carburetor icing without a carburetor heating system, contrary to the engine manufacturer’s guidance.NTSB ERA20LA313Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Jackson, TNThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's impairment due to alcohol.NTSB CEN20LA374Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · Walker, MNThe pilot’s impairment from the effects of an undiagnosed brain tumor.NTSB ERA20CA291Accident · No injuriesClass 4 · Data collectionFinal reportTeam Rocket F1 Rocket · Finelyville, PAThe pilot's misjudgment of the airplane’s speed and altitude during the landing approach, and his failure to attain the proper touchdown point during landing, which resulted in a runway overrun. Contributing to the accident were his access to a limited set of…NTSB ANC20LA074Accident · 7 fatalClass 3 · LimitedFinal reportDe Havilland DHC-2 · Soldotna, AKThe failure of both pilots to see and avoid the other airplane. Contributing to the accident were (1) the PA-12 pilot’s decision to fly with a known severe vision deficiency that had resulted in denial of his most recent application for medical certification…NTSB ERA20CA260Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Whitehall, MDThe pilot's failure to maintain adequate clearance from a known obstacle while landing from a hover.NTSB CEN20LA278Accident · 1 fatalClass 3 · LimitedFinal reportGrumman G164 · Springfield, COThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in collision with terrain. Contributing to the accident was the combining of chemicals known to produce foam and the pilot’s failure to…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 CEN20CA247Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CC19-180 · Fredericksburg, TXThe pilot's failure to maintain directional control during the landing roll. The pilot being fatigued likely contributed to his failure to maintain directional control during the landing roll.NTSB ANC20CA054Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Gulkana, AKThe pilot's failure to maintain proper airspeed during final approach to landing, and his subsequent failure to attain sufficient altitude to clear trees during an attempted go-around.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 CEN20LA136Accident · 2 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Audubon, IAThe pilot’s failure to recognize and avoid the power line during the low-altitude flight. Contributing to the accident was the pilot’s fatigue, which affected the pilot’s ability to see and avoid the power line.NTSB CEN20LA122Accident · 1 fatalClass 3 · LimitedFinal reportCessna 208 · LaCrosse, KSAn infight loss of control as a result of pilot impairment, the cause of which could not be determined.NTSB ANC20CA032Accident · No injuriesData collectionFinal reportCessna 172 · Big Lake, AKThe pilot's improper decision to initiate the takeoff roll from a snow-covered taxiway, which resulted in a loss of directional control, runway excursion, and impact with a snow berm.NTSB ERA20LA076Accident · Serious injuriesClass 3 · LimitedFinal reportMagni M-24 Plus · Nashua, NHThe pilot's incapacitation during the takeoff roll due to a stroke.NTSB ERA20FA068Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Newborn, GAThe pilot’s impairment/incapacitation from carbon monoxide poisoning due to a degraded muffler. Contributing to the accident was the pilot’s failure to properly maintain the airplane.