Fatal NTSB investigations
26 cases where NTSB found Task performance, general.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 2 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 1 |
| 2022 | 2 |
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\", '020600'))
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", '020600')) 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 DCA23LA109Accident · 1 fatalClass 3 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Montgomery, ALThe ramp agent’s cognitive impairment, which resulted in her (1) inconsistent behavior with trained procedures and pre landing briefings, (2) presence on the left side of the airplane while the left engine was still operating, and (3) subsequent ingestion…NTSB WPR22FA303Accident · 2 fatalClass 3 · FieldFinal reportCessna T207A · Page, AZThe total loss of engine power for undetermined reasons during low altitude cruise flight, which resulted in a water ditching. Contributing to the severity of the accident was the pilot’s failure to extend the flaps during the ditching, which increased the…NTSB CEN21FA007Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Telluride, COThe pilot’s loss of control during the climb to cruise flight resulting in the airplane’s impact with terrain. Contributing to the accident was the pilot’s decision to not climb to a higher altitude before proceeding over high terrain.NTSB CEN19FA271Accident · 1 fatalClass 3 · FieldFinal reportCessna U206 · Hopedale, LAThe controlled flight into terrain (CFIT), resulting from the pilot’s failure to maintain proper altitude and continued flight into instrument meteorological conditions.NTSB CEN19FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 425 · Butler, MOThe pilot’s loss of airplane control during a descent to a diversion airport with only the left engine operating. Contributing to the accident was a malfunction of the right engine throttle, the cause of which could not be determined.NTSB CEN19FA084Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Goshen, INThe pilot’s failure to maintain adequate altitude for undetermined reasons during a practice circling approach in dark night visual meteorological conditions, which resulted in a collision with power lines.NTSB CEN18LA309Accident · 1 fatalLimited investigationFinal reportCameron A 250 · Hartsel, COThe passengers’ fall from the basket after landing when the basket tipped over.NTSB CEN16LA260Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Kennett, MOThe pilot's failure to maintain clearance from power lines while maneuvering during the aerial application flight.NTSB DCA13MA133Accident · 2 fatalClass 1 · MajorFinal reportAirbus A300 - F4 622R · Birmingham, ALthe flight crew's continuation of an unstabilized approach and their failure to monitor the aircraft's altitude during the approach, which led to an inadvertent descent below the minimum approach altitude and subsequently into terrain. Contributing to the…NTSB CEN13FA196Accident · 2 fatalField investigationFinal reportHawker Beechcraft 390 · South Bend, INThe private pilot's inadequate response to the dual engine shutdown during cruise descent, including his failure to adhere to procedures, which ultimately resulted in his failure to maintain airplane control during a single-engine go-around. An additional…NTSB WPR13FA054Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Corona, CAThe pilot's failure to maintain clearance between the helicopter’s main rotor blades and the metal canopy of a fuel island.NTSB ERA12FA540Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Falmouth, MAThe flight instructor’s inadequate remedial action. Contributing to the accident was the student pilot’s poor control of the airplane during the approach.NTSB ANC12FA095Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Homer, AKThe pilot's failure to see and avoid high tension power lines.NTSB CEN12FA570Accident · 2 fatalField investigationFinal reportAmerican AA-1 · Llano, TXThe flight instructor’s delayed remedial action and inadequate supervision during practice traffic pattern work. Contributing to the accident was the flight instructor’s use of sedating medication on the day of the accident and airplane’s high angle of attack…NTSB CEN12FA115Accident · 3 fatalField investigationFinal reportBeech 19A · McArthur, OHThe pilot’s failure to maintain airplane control during an attempted go-around.NTSB CEN12FA058Accident · 1 fatalField investigationFinal reportCessna 337G · Alamosa, COThe loss of power to the rear engine due to fuel starvation during takeoff, which resulted from the fuel selector valve being inadvertently moved to the “off” position, and resulted in the airplane’s inability to climb.NTSB WPR11FA316Accident · 4 fatalField investigationFinal reportMooney M20F · Watsonville, CAThe pilot's decision to take off toward a nearby low cloud layer and the subsequent turn, stall, and spin during the pilot’s attempt to avoid the cloud layer. Contributing to the accident was the pilot's failure to avoid the stall. His ability to avoid the…NTSB ERA11FA291Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · New Hampton, NYThe PA24 pilot’s failure to maintain adequate clearance from the PA28, resulting in an in-flight collision. Contributing to the accident was the PA24 pilot's decision to overtake the PA28.NTSB CEN11FA075Accident · 1 fatalField investigationFinal reportHawker-Beechcraft A36 · Oklahoma City, OKThe pilot’s loss of control of the airplane during night instrument meteorological conditions, likely due to spatial disorientation.NTSB WPR10FA223Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D1 · Skokomish, WAThe pilot's failure to maintain clearance from trees while flying over hilly, forested terrain.NTSB ERA09LA371Accident · 1 fatalLimited investigationFinal reportLayson Stanley B Steen SKY Bolt · High Point, NCThe pilot’s failure to maintain clearance from power lines during takeoff.NTSB ERA09FA145Accident · 6 fatalField investigationFinal reportPiper PA-34-200T · Huntington, WV(1) The pilot’s failure to perform adequate preflight planning and to use available in flight resources in a timely manner and (2) his decision to continue visual-flight-rules flight in instrument meteorological conditions despite his lack of an instrument…NTSB DFW08FA212Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Yuma, COThe pilot's failure to maintain control of the airplane after an encounter with instrument meteorological conditions.NTSB DFW08LA197Accident · 1 fatalLimited investigationFinal reportMarshall James J Cozy MK IV · Midlothian, TXThe pilot's failure to maintain clearance from the wall of the rock quarry.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 DFW08LA122Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Bartlett, TXThe pilot's failure to maintain tail rotor clearance from terrain (embankment) during takeoff.