Final NTSB investigations
2,174 cases where NTSB found Not determined, general.
Cases per year
| 2008 | 147 |
|---|---|
| 2009 | 181 |
| 2010 | 187 |
| 2011 | 143 |
| 2012 | 165 |
| 2013 | 123 |
| 2014 | 149 |
| 2015 | 163 |
| 2016 | 137 |
| 2017 | 135 |
| 2018 | 143 |
| 2019 | 118 |
| 2020 | 86 |
| 2021 | 98 |
| 2022 | 76 |
| 2023 | 68 |
| 2024 | 37 |
| 2025 | 17 |
| 2026 | 1 |
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.\"completionStatus\" = 'Completed'
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 c."completionStatus" = 'Completed' 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 ANC26LA026Accident · Minor injuriesClass 4 · LimitedFinal reportCessna U206F · Juneau, AKA total loss of engine power for reasons that could not be determined because the airplane was not recovered from the ocean.NTSB WPR26LA062Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Las Vegas, NVTail rotor blade impact from an unidentified object at an undetermined time.NTSB WPR26LA023Accident · Minor injuriesClass 4 · LimitedFinal reportHawker Hawker Hunter MK.58 · Big Sur, CAA complete loss of engine power for reasons that could not be determined.NTSB CEN25LA378Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Racine, WIA total loss of engine power for reasons that could not be determined.NTSB CEN25LA352Accident · Minor injuriesClass 4 · LimitedFinal reportGlasair GlaStar · Hearne, TXThe inflight engine compartment fire for reasons that could not be determined.NTSB CEN25LA328Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV14 · Parker, COSeparation of the right landing gear wheel assembly during landing.NTSB ERA25LA298Accident · No injuriesClass 4 · LimitedFinal reportPaschal JR Roy E Velocity XL RG · Columbia, SCA landing gear collapse during landing.NTSB WPR25LA212Accident · 1 fatalClass 4 · LimitedFinal reportCessna T240 · San Diego, CAImpact with the ocean for reasons that could not be determined because the pilot and airplane were not located.NTSB ERA25LA259Accident · No injuriesClass 4 · LimitedFinal reportRobbins C/Robbins J Rotorway Exec 162F · Towanda, PAAn in-flight fire for reasons that could not be determined due to the extent of fire damage.NTSB ERA25LA216Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172F · Vero Beach, FLA total loss of engine power for reasons that could not be determined.NTSB CEN25LA164Accident · 1 fatalClass 4 · LimitedFinal reportAir Tractor AT802 · Atlantic Ocean, CanadaThe airplane’s impact with the ocean for undetermined reasons based on the available evidence.NTSB CEN25LA149Accident · Serious injuriesClass 3 · LimitedFinal reportPphu Ekolot KR-030 Topaz · Platteville, WIThe pilot’s failure to maintain clearance from terrain for reasons which could not be determined.NTSB CEN25LA107Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C-1 · Alvord, TXA total loss of engine power for a reason that could not be determined.NTSB CEN25LA083Accident · No injuriesClass 4 · LimitedFinal reportRaytheon Hawker 800XP · Minneapolis, MNThe failure of the nose landing gear to extend for undetermined reasons.NTSB ERA25LA100Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Orange, MAFailure of the left main landing gear to fully extend and lock for undetermined reasons as a functional test of the landing gear system could not duplicate the anomaly.NTSB ERA25LA096Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Pompano Beach, FLThe separation of the securing hardware for the right main landing gear upper and lower torque links for undetermined reasons, which prevented extension of the right main landing gear.NTSB WPR25LA077Incident · No injuriesClass 4 · LimitedFinal reportBombardier Inc., Canadair CL-215-6B11 · Los Angeles, CAThe NTSB did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of Investigation.NTSB WPR25LA080Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-32-300 · Round Mountain, NVImpact with mountainous terrain for reasons that could not be determined due to a lack of available evidence.NTSB WPR25FA062Accident · 1 fatalClass 3 · FieldFinal reportAmerican Eurocopter AS350B3 · Potrero, CAThe pilot’s loss of control during cruise flight due to incapacitation for reasons that could not be determined.NTSB WPR25LA048Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20F · Fullerton, CAThe loss of engine power during departure for reasons that could not be determined.NTSB CEN25LA041Accident · No injuriesClass 4 · LimitedFinal reportRotorway Exec 162 F · Blaine, MNA loss of engine power that resulted in a hard landing.NTSB ERA25LA044Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C-1 · Boalsburg, PAA loss of engine power for reasons that could not be determined.NTSB ERA25LA007Accident · Minor injuriesClass 3 · LimitedFinal reportNorth American Navion · Rutherfordton, NCAn in-flight fire, the origin of which could not be determined based on the available evidence.NTSB CEN24LA364Accident · No injuriesClass 4 · LimitedFinal reportGrumman G-164A · LaPlace, LATotal loss of engine power during the agricultural application flight for reasons that could not be determined.NTSB CEN24FA346Accident · 1 fatalClass 3 · FieldFinal reportSonex Sonex · Sulphur Springs, INThe pilot’s loss of directional control during takeoff for undetermined reasons.NTSB ERA24LA369Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Somerville, NJA total loss of engine power due to an undetermined fuel delivery issue.NTSB CEN24LA336AccidentClass 4 · LimitedFinal reportCessna 182D · Coopersville, MIThe loss of airplane control while landing.NTSB ERA24FA362Accident · 1 fatalClass 3 · FieldFinal reportSchleicher Alexander ASH 26 E · Waynesville, OHA loss of control on takeoff for undetermined reasons.NTSB CEN24FA312Accident · 1 fatalClass 3 · FieldFinal reportEngineering & Research Ercoupe 415-C · Elkhart, ILAn off-airport landing in a soybean field for reasons that could not be determined. Contributing to the severity of the pilot’s injuries and airplane damage was a fire that occurred at an unknown time.NTSB CEN24FA298Accident · 1 fatalClass 3 · FieldFinal reportDeGraw DeBird · Napoleon, MISeparation of the gyroplane’s tail due to main rotor blade contact for reasons that could not be determined.NTSB ERA24FA304Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT802 · Cuba, KYImpact with terrain for reasons that could not be determined.NTSB ERA24LA303Accident · No injuriesClass 3 · LimitedFinal reportJones LONG-EZ · Thomasville, GAThe pilot reported that he was maneuvering around weather at 11,500 ft mean sea level (msl) when he made a rapid descent to 3,500 ft msl to remain clear of clouds. He reported that he did not exceed the airplane’s maneuvering speed during the descent, and…NTSB ERA24FA300Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Palm Beach Gardens, FLA loss of engine power for reasons that could not be determined.NTSB CEN24LA249Accident · No injuriesClass 3 · LimitedFinal reportRotorway 162 F · Maybee, MIA partial loss of engine power for undetermined reasons.NTSB WPR24FA213Accident · 1 fatalClass 3 · FieldFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Chamberino, NMAn aerodynamic stall and loss of control for reasons that could not be determined based on the available information.NTSB ERA24LA267Accident · Minor injuriesClass 3 · LimitedFinal reportGarlick Helicopters OH-58A+ · Cisco, GAA reported total loss of engine power for reasons that could not be determined.NTSB CEN24FA220Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Broseley, MOThe pilot’s inflight loss of airplane control for reasons that could not be determined.NTSB WPR24LA193Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Monument Hills, CAA total loss of engine power for reasons that could not be determined.NTSB ANC24LA045Accident · No injuriesClass 3 · LimitedFinal reportCessna 206 · King Salmon, AKA partial loss of engine power due to detonation/preignition of the No. 1 cylinder for reasons that could not be determined.NTSB WPR24LA177Accident · No injuriesClass 3 · LimitedFinal reportBanes John Scott Kitfox Series 6 · Parowan, UTThe pilot’s inability to control the airplane during landing due to tailwheel assembly damage sustained during a previous shimmy event that occurred for reasons that could not be determined based on the available evidence.NTSB ERA24LA208Accident · Serious injuriesClass 3 · LimitedFinal reportAdmore International Jets Aircam · DeLand, FLThe uncommanded movement of the left propeller into reverse during approach for undetermined reasons, resulting in an in-flight loss of control of the airplane at low altitude during approach.NTSB ERA24LA213Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Apex, NCThe loss of directional control during the landing roll for reasons that could not be determined, due to impact damage sustained to the brake system.NTSB ERA24LA169Accident · No injuriesClass 4 · LimitedFinal reportSnyder Robert L Challenger II · Hendersonville, NCA loss of engine power for undetermined reasons.NTSB ERA24LA166Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Key Biscayne, FLA loss of engine power for reasons that could not be determined.NTSB CEN24LA147Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7KCAB · Bluff Dale, TXAn engine compartment fire for reasons that could not be determined due to extensive thermal damage.NTSB CEN24FA148Accident · 3 fatalClass 3 · FieldFinal reportDavis DA-3 · Antlers, OKImpact with terrain for reasons that could not be determined.NTSB CEN24LA146Accident · No injuriesClass 3 · LimitedFinal reportSchweizer G-164B · Kaplan, LAA partial loss of engine power for reasons that could not be determined.NTSB ERA24LA214Accident · No injuriesClass 3 · LimitedFinal reportBeech 95B55 · St. Augustine, FLThe incomplete extension of the landing gear into the down-and-locked position for reasons that could not be determined. .NTSB CEN24LA119Accident · Serious injuriesClass 3 · LimitedFinal reportZenith Stol CH750 · Sextonville, WIA loss of engine power for reasons that could not be determined, followed by a loss of control and subsequent impact with terrain.NTSB CEN24LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · Cherokee, OKA partial loss of engine power for reasons that could not be determined. Contributing to the accident was the presence of ground fog, which hindered the landing approach and resulted in the pilot inadvertently landing long and impacting a fence during the…