Fatal NTSB investigations
13 cases where NTSB found Oversight of personnel.
Cases per year
| 2008 | 3 |
|---|---|
| 2010 | 2 |
| 2011 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2022 | 1 |
| 2025 | 1 |
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 c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '04032010'))
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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '04032010')) 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 DCA25MA108Accident · 67 fatalClass 1 · MajorFinal reportBombardier CL-600-2C10 · Washington, DCThe Federal Aviation Administration’s (FAA) placement of a helicopter route in close proximity to a runway approach path; their failure to regularly review and evaluate helicopter routes and available data, and their failure to act on recommendations to…NTSB ANC23FA008Accident · 3 fatalClass 3 · FieldFinal reportRaytheon C90A · Kaupo, HIGuardian Flight’s inadequate pilot training and performance tracking, which failed to identify and correct the pilot’s consistent lack of skill, and which resulted in the pilot’s inability to maintain his position inflight using secondary instruments to…NTSB WPR18FA013Accident · 2 fatalField investigationFinal reportFlugzeugproduktions-und Vertri EA 300/L · Four Corners, CACollision with terrain after the pilot was unable to regain airplane control during an aerobatic maneuver. Contributing to the accident was the operator's failure to provide effective internal oversight to identify and prohibit exceedance of the airplanes'…NTSB DCA17FA109Accident · 2 fatalField investigationFinal reportShort Bros. & Harland SD3 30 · Charleston, WVthe flight crew's improper decision to conduct a circling approach contrary to the operator's standard operating procedures (SOP) and the captain's excessive descent rate and maneuvering during the approach, which led to inadvertent, uncontrolled contact with…NTSB DCA16MA204Accident · 16 fatalClass 1 · MajorFinal reportKubicek BB85 · Lockhart, TXThe pilot's pattern of poor decision-making that led to the initial launch, continued flight in fog and above clouds, and descent near or through clouds that decreased the pilot's ability to see and avoid obstacles. Contributing to the accident were (1) the…NTSB ANC15FA049Accident · 1 fatalClass 3 · FieldFinal reportCessna 207A · Juneau, AKThe pilot's decision to initiate and continue visual flight into instrument meteorological conditions, which resulted in a loss of situational awareness and controlled flight into terrain. Contributing to the accident were the company's failure to follow its…NTSB CEN14FA110Accident · 1 fatalField investigationFinal reportCessna 310R · Waterford, MIThe pilot's controlled flight into terrain during an instrument landing system approach at night in instrument flight rules conditions. Contributing to the accident were the operator's inadequate training of the pilot, the operator's failure to provide a…NTSB ERA11FA495Accident · 1 fatalField investigationFinal reportNorth American T-28C · Martinsburg, WVThe pilot's impairment or incapacitation that occurred during a low-altitude aerobatic maneuver due to complications from a recent heart attack, resulting in his inability to maintain control of the airplane. Contributing to the accident was the Federal…NTSB ANC10FA038Accident · 1 fatalField investigationFinal reportPiper PA-18-135 · Willow, AKThe pilot's failure to maintain clearance from a tree due to the effects of impairment from alcohol consumption.NTSB ERA10FA148Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Springfield, KYThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion, and the pilot's impairment due to alcohol. Contributing to the accident was the Federal Aviation Administration's failure to adequately oversee…NTSB DFW08FA153Accident · 2 fatalField investigationFinal reportCessna 310Q · Steamboat, COThe pilot's failure to maintain clearance from mountainous terrain in day visual conditions. Contributing to the accident was the pilot's impairment due to marijuana and inadequate medical oversight of the pilot by the Federal Aviation Administration.NTSB DFW08LA121Accident · 1 fatalLimited investigationFinal reportTromsness Enterprises Turbine LE · Miami, OKThe pilot's failure to maintain control of the airplane for undetermined reasons. Contributing to the accident included his extensive use of medications and/or his multiple medical conditions and the failure of the FAA to follow up on his reported medication…NTSB LAX08FA047Accident · 1 fatalField investigationFinal reportBeechcraft V35B · Selma, CAThe pilot's failure to maintain control resulting in the in-flight break-up of the airplane due to aerodynamic overload. Contributing factors included the pilot's impairment due to multiple medical conditions and due to recent use of alcohol.