NTSB investigations, AL
32 cases where NTSB found Not determined, general.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2011 | 2 |
| 2012 | 4 |
| 2014 | 5 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 3 |
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.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
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."eventStateOrRegion" = 'AL' AND c."eventCountry" = 'USA' 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 ERA23LA288Accident · No injuriesClass 4 · LimitedFinal reportSteen Skybolt · Aliceville, ALA partial loss of engine power for reasons that could not be determined as the wreckage was not recovered and could not be examined.NTSB ERA23FA254Accident · 1 fatalClass 3 · FieldFinal reportZenith 601XL · Albertville, ALA descent and impact with terrain for reasons that could not be determined.NTSB ERA23LA251Accident · No injuriesClass 3 · LimitedFinal reportMagniflight M24 Orion Plus · Dauphin Island, ALA partial loss of engine power due to a loss of combustion in the No. 4 cylinder for undetermined reasons.NTSB ERA22LA417Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Meridianville, ALA loss of engine power that could not be determined based on the available evidence.NTSB ERA21LA347Accident · Minor injuriesClass 3 · LimitedFinal reportQuad City Challenger · Geneva, ALA total loss of engine power for reasons that could not be determined.NTSB ERA21FA133Accident · 2 fatalClass 3 · FieldFinal reportPiper PA32RT · Vinemont, ALA loss of engine power for reasons that could not be determined.NTSB ERA20LA272Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Alabaster, ALA loss of control and lack of climb performance shortly after takeoff for reasons that could not be determined based on available evidence, resulting in a collision with terrain.NTSB ERA20LA194Accident · No injuriesClass 3 · LimitedFinal reportBellanca 8KCAB · Rainbow City, ALThe partial loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN20FA009Accident · 1 fatalClass 3 · FieldFinal reportVans RV-8 · White Plains, ALImpact with terrain for reasons that could not be determined based on the available information.NTSB ERA18LA177Accident · No injuriesLimited investigationFinal reportCrawford RV-7 · Alexander City, ALA total loss of engine power for reasons that could not be determined because examination of the engine revealed no evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA18LA161Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Fort Morgan, ALA partial loss of engine power for reasons that could not be determined because postaccident engine examinations did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA18FA118Accident · 1 fatalField investigationFinal reportCessna R182 · Ashville, ALDescent and impact with terrain for reasons that could not be determined.NTSB ERA17LA282Accident · Minor injuriesLimited investigationFinal reportBellanca 7ACA · Fairhope, ALA total loss of engine power for reasons that could not be determined because postaccident examination and a test run of the engine did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA17FA140Accident · 2 fatalField investigationFinal reportBeech A36 · Dadeville, ALA loss of engine power for reasons that could not be determined due to postcrash thermal damage to the engine accessories and the airframe. Contributing to the accident was the pilot's failure to navigate to any of the available forced landing sites within…NTSB ERA16LA326Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Ozark, ALA total loss of engine power for reasons that could not be determined following a successful postaccident engine run on the accident helicopter.NTSB ERA16LA199Accident · No injuriesLimited investigationFinal reportAmerican Legend AL3 · Elberta, ALA total loss of engine power for reasons that could not be determined because the engine ran normally during a postaccident engine test run with no anomalies noted.NTSB ERA15FA330Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Alabaster, ALAn in-flight loss of airplane control for reasons that could not be determined because postaccident examination of the airframe and engine revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA15LA232Accident · No injuriesLimited investigationFinal reportBeech A23 24 · Grove Hill, ALA total loss of engine power for reasons that could not be determined because engine examination and testing did not reveal any anomalies that would have precluded normal operation.NTSB ERA14FA396Accident · 2 fatalField investigationFinal reportMcdonnell Douglas Helicopter 369E · Northport, ALAn inadvertent collision with a utility wire for reasons that could not be determined from recorded data and examination of the helicopter and accident site.NTSB ERA14LA369Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Helena, ALA total loss of engine power for reasons that could not be determined due to postcrash fire damage.NTSB ERA14LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Monroeville, ALA loss of engine power for reasons that could not be determined because postaccident examination of the engine and fuel system revealed no anomalies.NTSB ERA14FA300Accident · 3 fatalField investigationFinal reportIsrael Aircraft Industries 1124A · Huntsville, ALThe flight crew's inability to maintain airplane control during initial climb following deployment of the right thrust reverser for reasons that could not be determined because postaccident examination of the airframe and engine thrust reverser system did not…NTSB ERA14LA257Accident · Serious injuriesLimited investigationFinal reportP&M Quikr · Gulf Shores, ALThe pilot’s failure to maintain aircraft control during engine startup, which resulted in a collision with a parked airplane. Contributing to the accident was the pilot’s failure to follow engine startup procedures and a sudden surge of engine power for…NTSB ERA13LA041Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Fairhope, ALThe Grumman pilot’s loss of directional control during landing for undetermined reasons because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the Piper pilot…NTSB ERA12LA505Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Bay Minette, ALThe separation of the tailwheel linkage for reasons that could not be determined because the linkage was not located, which resulted in a loss of directional control during landing.NTSB ERA12LA273Accident · No injuriesLimited investigationFinal reportCessna T337B · Dothan, ALThe failure of the landing gear to extend and lock, despite troubleshooting attempts using normal and emergency procedures. The reason for the failure could not be determined because the systems were unavailable for testing.NTSB ERA12LA150Accident · No injuriesLimited investigationFinal reportM-Squared Breese 2 · Bayou La Batre, ALThe pilot's inability to maintain control of the airplane for reasons that could not be determined because postaccident examination of the rudder control system did not reveal any anomalies that would have precluded control of the airplane.NTSB ERA11LA197Accident · No injuriesLimited investigationFinal reportBurr Andrew E Xiv Rotorway Exec 162F · Lincoln, ALA total loss of engine power during cruise flight for undetermined reasons.NTSB ERA11LA175Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Birmingham, ALA total loss of engine power for undetermined reasons.NTSB ERA09LA455Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2CM · St. Elmo, ALA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain adequate airspeed during the forced landing.NTSB ERA09LA263Accident · 1 fatalLimited investigationFinal reportKeeley/Tidd MK-1 · Demopolis, ALThe pilot's failure to maintain adequate airspeed following a complete loss of engine power resulting in a stall while maneuvering to land. The reason for the loss of engine power was undetermined.NTSB MIA08LA138Accident · 2 fatalLimited investigationFinal reportColyaer SL Freedom S100 · Limestone, ALThe pilot's loss of aircraft control for undetermined reasons while making a water landing.