NTSB investigations, 2018
143 cases where NTSB found Not determined, general.
Cases per year
| 2008 | 150 |
|---|---|
| 2009 | 199 |
| 2010 | 195 |
| 2011 | 156 |
| 2012 | 171 |
| 2013 | 128 |
| 2014 | 150 |
| 2015 | 163 |
| 2016 | 137 |
| 2017 | 135 |
| 2018 | 143 |
| 2019 | 118 |
| 2020 | 86 |
| 2021 | 98 |
| 2022 | 76 |
| 2023 | 68 |
| 2024 | 37 |
| 2025 | 29 |
| 2026 | 9 |
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 year(c.\"eventDate\") = 2018
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '05000000'))
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") = 2018 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '05000000')) 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 ERA19LA081Accident · No injuriesLimited investigationFinal reportCessna LC41 · Apopka, FLA partial loss of engine power during a go-around for reasons that could not be determined based on the available information, which resulted in a forced landing.NTSB WPR19LA060Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · San Diego, CALoss of directional control during the landing roll for reasons that could not be determined based on the available information.NTSB CEN19LA061Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Norwood, COThe partial loss of engine power for undetermined reasons.NTSB CEN19LA046Accident · No injuriesLimited investigationFinal reportCessna 120 · Beaumont, KSThe right brake being locked during the landing roll on the turf runway for reasons that could not be determined during postaccident examinations, which resulted in a noseover.NTSB WPR19LA041Accident · Serious injuriesClass 3 · LimitedFinal reportHawker Hawker Hntr FMK 58 · Honolulu, HIA total loss of engine power for undetermined reasons.NTSB WPR19LA039Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Los Banos, CAA partial loss of engine power for reasons that could not be determined based on the available information.NTSB WPR19LA035Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172P · Santa RitaA total loss of engine power for undetermined reasons.NTSB CEN19FA036Accident · 3 fatalClass 3 · FieldFinal reportCessna 525 · Memphis, INThe pilot’s inability to regain airplane control after a left roll that began for reasons that could not be determined based on the available evidence.NTSB CEN19FA035Accident · 1 fatalField investigationFinal reportPiper PA 30 · Marion, INThe pilot's exceedance of the airplane's critical angle of attack following a loss of the left engine power shortly after takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the loss of left…NTSB CEN19FA032Accident · 1 fatalField investigationFinal reportMooney M20C · Santa Fe, NMCollision with terrain for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's poor preflight planning and poor decision to depart on the accident flight.NTSB ANC19LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Whittier, AKA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA19LA086Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Petersburg, WVA loss of control during the landing roll and subsequent runway excursion for reasons that could not be determined based on the available evidence.NTSB WPR19TA037Accident · Minor injuriesClass 3Final reportScottish Series 100 MDL 101 · Lake Pleasant, AZImpact with a lake for undetermined reasons.NTSB ERA19FA048Accident · 1 fatalField investigationFinal reportVans RV-12 · Niceville, FLA partial loss of engine power during initial climb for undetermined reasons, and pilot's failure to maintain airspeed during a turn back to the runway, which resulted in an exceedance of the airplane's critical angle of attack, and subsequent aerodynamic…NTSB WPR19LA023Accident · No injuriesClass 3 · LimitedFinal reportVans RV7A · Ramona, CAThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA19FA039Accident · 1 fatalField investigationFinal reportCessna 310 · Walton, NYAn in-flight fire of undetermined origin. Contributing to the accident were the severe icing conditions encountered during the final minutes of the flight, which led to a loss of airplane control.NTSB WPR19LA019Accident · Serious injuriesClass 3 · LimitedFinal reportBell 47G · Wichita Falls, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB ANC19LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA 12 · Willow, AKThe loss of engine power shortly after takeoff for reasons that could not be determined based on the available information, which resulted in an emergency landing and collision with trees.NTSB CEN19FA018Accident · 1 fatalField investigationFinal reportEurocopter AS350 · Odanah, WIThe pilot's loss of helicopter control for undetermined reasons.NTSB ERA19LA026Accident · 5 fatalLimited investigationFinal reportPiper PA31T · Atlantic Ocean (Atlantic Ocean)An in-flight loss of control, which resulted in an impact with water, for reasons that could not be determined because the airplane was not recovered.NTSB CEN19LA013Accident · No injuriesLimited investigationFinal reportSorrell Sorrell SNS 7 · Middletown, OHThe pilot's loss of directional control during the landing rollout for reasons that could not be determined based on the available evidence, which resulted in the right wing striking the ground.NTSB ERA19LA022Accident · No injuriesLimited investigationFinal reportPiper PA22 · Brownstown, INThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the outcome was the student…NTSB ERA19FA020Accident · 1 fatalField investigationFinal reportBowers Flybaby · Milton, FLA loss of engine power for reasons that could not be determined, and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall at low altitude.NTSB ERA19LA018Accident · Minor injuriesClass 3 · LimitedFinal reportJabiru 250 · Daytona Beach Shores, FLA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN19LA006Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Hudson, COThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB WPR18FA279Accident · 1 fatalClass 2 · FieldFinal reportCessna 177RG · La Verne, CAThe pilot's failure to maintain adequate airspeed and the exceedance of the airplane's critical angle of attack during a turn, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was an undetermined engine…NTSB CEN18FA387Accident · 1 fatalField investigationFinal reportBeech 200 · Oscoda, MIThe pilot's descent below minimum descent altitude during the nonprecision instrument approach for reasons that could not be determined based on the available information.NTSB ERA18LA271Accident · Minor injuriesClass 3 · LimitedFinal reportBell OH 58A · Juana Diaz, PRA total loss of engine power for reasons that could not be determined based on the available information.NTSB ANC18FA071Accident · 2 fatalField investigationFinal reportPiper PA-12-150 · Healy, AKAn impact with terrain for reasons that could not be determined based on the available information.NTSB ERA18LA249Accident · 1 fatalLimited investigationFinal reportEdward R. Sugg Sonex · Marion, SCImpact with terrain for reasons that could not be determined based on the available information.NTSB WPR18LA257Accident · No injuriesClass 2 · LimitedFinal reportPiper J3C · Jackson, CAA loss of directional control during takeoff and initial climb for reasons that could not be determined based on the available information.NTSB CEN18LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA32 · Roanoke, TXThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA18LA243Accident · No injuriesClass 3 · LimitedFinal reportPiper PA12 · Cochranton, PAA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA18LA241Accident · Minor injuriesLimited investigationFinal reportDiamond DA40 · Mount Pleasant, TNA total loss of engine power for reasons that could not be determined because postaccident examination of the airplane did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA18LA239Accident · No injuriesClass 3 · LimitedFinal reportAvid MK-4 · Harnett, NCA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN18LA356Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Partridge, KSThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA18FA235Accident · 1 fatalField investigationFinal reportAirtime Cygnet · Pensacola, FLThe student pilot's loss of aircraft control for undetermined reasons.NTSB ERA18FA231Accident · 4 fatalField investigationFinal reportCessna 182 · Swainsboro, GAThe total loss of engine power for reasons that could not be determined based on available information.NTSB ERA18LA229Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Quincy, FLA loss of engine power due to decreased fuel flow for reasons that could not be determined based on the available evidence.NTSB CEN18LA349Accident · Serious injuriesLimited investigationFinal reportNorth American T-28B · Minneapolis, MNThe fire during approach for reasons that could not be determined based on the available evidence, which resulted in impact with terrain during approach for a precautionary landing.NTSB CEN18LA350Accident · No injuriesLimited investigationFinal reportCessna A188 · Atchison, KSThe partial loss of engine power for reasons that could not be determined during the postaccident examination.NTSB CEN18LA347Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Little Rock, ARThe total loss of engine power for reasons that could not be determined based on the available evidence, which resulted in a forced landing on unsuitable terrain.NTSB WPR18LA234Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 400 · Grand Forks, NDThe loss of engine power while maneuvering due to the failure of the power turbine blade assembly for reasons that could not be determined based on available evidence.NTSB WPR18TA239Accident · Minor injuriesClass 3Final reportEurocopter EC130 · Hilo, HIThe separation of the left sliding door in flight after it opened for reasons that could not be determined based on the available evidence, which resulted in damage to the main rotor blades.NTSB CEN18LA335Accident · No injuriesLimited investigationFinal reportCessna R172E · Colorado Springs, COThe airplane’s failure to maintain a climb after takeoff, which resulted in a forced landing on unsuitable terrain; the reason for the airplane’s failure to climb could not be determined based on the available evidence.NTSB CEN18LA338Accident · Serious injuriesLimited investigationFinal reportLazair II · Racine, OHThe impact with terrain for reasons that could not be determined based on the lack of evidence.NTSB CEN18LA332Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Westbrook, MNA runway excursion during takeoff for reasons that could not be determined based on the available evidence.NTSB WPR18FA219Accident · 1 fatalField investigationFinal reportBeech A36TC · Sylmar, CAThe pilot's failure to maintain airplane control following a total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR18FA220Accident · 1 fatalField investigationFinal reportDe Havilland DHC8 · Steilacoom, WAThe NTSB did not determine the probable cause of this event and does not plan to issue an investigative report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of Investigation.NTSB ERA18LA215Accident · No injuriesLimited investigationFinal reportCessna R182 · Florence, SCThe pilot's failure to comply with emergency procedures in the pilot's operating handbook, resulting in the collapse of the main landing gear during landing. Contributing to the accident was the pilot's failure to address the low battery voltage before…