NTSB investigations, 2024, AL
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 1 |
|---|---|
| 1963 | 1 |
| 1964 | 61 |
| 1965 | 92 |
| 1966 | 70 |
| 1967 | 85 |
| 1968 | 68 |
| 1969 | 75 |
| 1970 | 89 |
| 1971 | 73 |
| 1972 | 76 |
| 1973 | 82 |
| 1974 | 67 |
| 1975 | 71 |
| 1976 | 77 |
| 1977 | 82 |
| 1978 | 72 |
| 1979 | 50 |
| 1980 | 50 |
| 1981 | 48 |
| 1982 | 61 |
| 1983 | 60 |
| 1984 | 41 |
| 1985 | 45 |
| 1986 | 48 |
| 1987 | 45 |
| 1988 | 36 |
| 1989 | 33 |
| 1990 | 32 |
| 1991 | 30 |
| 1992 | 40 |
| 1993 | 33 |
| 1994 | 27 |
| 1995 | 42 |
| 1996 | 32 |
| 1997 | 17 |
| 1998 | 27 |
| 1999 | 29 |
| 2000 | 17 |
| 2001 | 25 |
| 2002 | 27 |
| 2003 | 30 |
| 2004 | 27 |
| 2005 | 22 |
| 2006 | 24 |
| 2007 | 29 |
| 2008 | 28 |
| 2009 | 13 |
| 2010 | 8 |
| 2011 | 17 |
| 2012 | 25 |
| 2013 | 10 |
| 2014 | 24 |
| 2015 | 23 |
| 2016 | 12 |
| 2017 | 19 |
| 2018 | 20 |
| 2019 | 15 |
| 2020 | 17 |
| 2021 | 15 |
| 2022 | 21 |
| 2023 | 19 |
| 2024 | 11 |
| 2025 | 18 |
| 2026 | 17 |
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\") = 2024
AND c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
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") = 2024 AND c."eventStateOrRegion" = 'AL' AND c."eventCountry" = 'USA' 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 ERA25FA071Accident · 1 fatalClass 3 · FieldFinal reportMagni Builder M-16 · Foley, ALThe sport pilot’s failure to maintain control of the gyroplane during initial climb, which resulted in an uncontrolled descent and collision with terrain.NTSB ERA24LA349Accident · No injuriesClass 4 · LimitedFinal reportSmith T Gunter Quick Silver SP II · Mobile, ALThe pilot’s failure to maintain control of the airplane in gusty wind conditions while flying low over water, which resulted in the floats impacting a wave and the airplane’s subsequent nose over into the water.NTSB ERA24LA344Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Cullman, ALThe pilot’s decision to depart in an area of developing convective weather, which resulted in an unanticipated wind shift during the initial climb after takeoff, a loss of climb performance, and the subsequent forced landing.NTSB ERA24LA275Accident · No injuriesClass 4 · LimitedFinal reportPiper PA23 · Montgomery, ALThe failure of the nose landing gear actuator to maintain a fully down and locked position.NTSB ERA24LA259Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · Selma, ALThe pilot receiving instruction’s improper landing flare which resulted in a hard landing and subsequent landing gear collapse.NTSB ERA24LA232Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172P · Citronelle, ALA total loss of engine power due to fuel starvation as a result of a fuel vent line that was clogged by an insect nest.NTSB ERA24LA222Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177 · Selma, ALInsufficient lubrication of the engine’s internal components, which resulted in a total loss of engine power.NTSB ERA24LA170Accident · No injuriesClass 4 · LimitedFinal reportBeta Biz LX7 · Huntsville, ALThe failure of the nose landing gear actuator forward hydraulic fitting, which resulted in a main landing gear collapse during landing due to the loss of hydraulic fluid and pressure.NTSB ERA24LA152Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Opelika, ALA partial loss of engine power due to a combination of fuel/oil contamination in the fuel injector assembly.NTSB ERA24LA114Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172M · Brookwood, ALThe pilot’s failure to see and avoid powerlines while maneuvering at low altitude.NTSB ERA24FA102Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24 · Eufaula, ALA total loss of engine power due to fuel starvation as a result of the pilot’s inadequate fuel planning/management.