Fatal NTSB investigations
16 cases where the defining event was Abnormal runway contact.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 2 |
| 2012 | 1 |
| 2015 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2021 | 4 |
| 2022 | 1 |
| 2024 | 2 |
Where
Open the mapLatest 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '090')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '090') 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 WPR25FA002Accident · 1 fatalClass 3 · FieldPreliminary reportTaylor J-2 · Roseburg, OROn October 3, 2024, about 1130 Pacific daylight time, a Taylor J-2 airplane, N19252, was substantially damaged when it was involved in an accident near Roseburg, Oregon. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR24FA252Accident · 2 fatalClass 3 · FieldFinal reportTextron T206H · Kneeland, CAThe pilot’s delayed decision to perform a go-around after an unstabilized approach, which resulted in a loss of control, runway overrun, and impact with terrain.NTSB ERA22LA348Accident · 1 fatalClass 3 · LimitedFinal reportCASA C212 · Raeford, NCThe airplane’s encounter with windshear during landing, which resulted in a hard landing and separation of the right main landing gear, and the pilot’s subsequent decision to leave his seat in flight, which resulted in his fall from the airplane.NTSB GAA22WA002Accident · 1 fatalClass 5 · ForeignCessna 172 · St-Mathieu-de-Laprairie, CanadaNTSB WPR21FA353Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Billings, MTThe pilot’s improper flare, which led to a hard landing, subsequent loss of control, and collision with trees.NTSB WPR21FA288Accident · 1 fatalClass 3 · FieldFinal reportBorom Long-EZ · Tucson, AZThe pilot's failure to maintain adequate airspeed and to retract the speed brake during the approach, which resulted in a hard landing short of the runway. Contributing to the accident was the flight instructor’s decision to conduct a flight review in an…NTSB WPR21FA273Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Angwin, CAThe pilot's exceedance of the airplane’s critical angle of attack during an aborted landing after an unstabilized approach and hard landing, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing to the accident was the pilot’s…NTSB CEN18WA366Accident · 1 fatalForeign investigationCirrus SR22 · Balchik, BulgariaOn August 24, 2018, at 1608 coordinated universal time, a Cirrus SR22, LZ-SEV, impacted terrain at the Balchik Airfield (LBWB), Balchik, Bulgaria. The airplane was destroyed. The pilot was fatally injured. The flight originated from Lesnovo Airport (LBLS),…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 ERA17FA167Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Wallingford, CTThe pilot's unstablilized approach and improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain control during a go-around. Contributing to the accident was the pilot's lack of experience in the accident airplane…NTSB CEN15FA328Accident · 2 fatalField investigationFinal reportSocata TBM 700 · Milwaukee, WIThe pilot's improper pitch control during the landing, which resulted in the propeller striking the runway, and his failure to maintain adequate airspeed during the subsequent go-around, which resulted in the airplane exceeding its critical angle of attack…NTSB WPR15FA208Accident · 1 fatalField investigationFinal reportMooney M20E · Salem, ORThe pilot's unstabilized approach and delayed remedial action, which resulted in a porpoise during landing. Also causal to the accident was the pilot’s exceedance of the airplane's critical angle-of-attack during the subsequent aborted landing, which resulted…NTSB ANC12FA073Accident · 1 fatalField investigationFinal reportCessna U206G · Homer, AKThe pilot’s improper evaluation of the weather conditions and his subsequent downwind water landing in gusting wind conditions, which resulted in a nose-over.NTSB CEN11FA008Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Springfield, MOThe pilot's failure to maintain control of the airplane during an attempted go-around, which led to an aerodynamic stall.NTSB CEN10LA427Accident · 1 fatalLimited investigationFinal reportCessna 180 · Davant, LAThe pilot’s improper application of the flight controls and throttle during landing, which resulted in a nose over and subsequent inverted immersion in the water. Contributing to the accident was the flight instructor’s delayed remedial action and inadequate…NTSB DCA09RA041Accident · 2 fatalClass 5 · ForeignMcdonnell Douglas MD11 · Narita, JapanOn March 23, 2009, at 0649 local time, a FedEx Boeing (McDonnell Douglas) MD-11 crashed upon landing at Narita International Airport (NRT), Narita, Japan. The flight originated at Guangzho Baiyun International Airport (CAN), Guangzho, China. Both pilots were…