NTSB investigations, 2007, 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\") = 2007
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") = 2007 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 NYC08FA071Accident · 3 fatalField investigationFinal reportBell 206L-3 · Cherokee, ALThe pilot's failure to maintain control of the helicopter during an out-of-ground-effect hover. Contributing to the accident was a loss of tail rotor effectiveness.NTSB MIA08CA030Accident · No injuriesData collectionFinal reportCessna 172N · Talladega, ALThe pilot's failure to maintain directional control of the airplane.NTSB NYC08CA073Accident · No injuriesData collectionFinal reportPiper PA-31T · Muscle Shoals, ALThe pilot's failure to lower the landing gear.NTSB NYC08CA058Accident · No injuriesData collectionFinal reportFisher Aero Celebrity · White Plains, ALA propeller failure during cruise flight.NTSB MIA08FA026Accident · 2 fatalField investigationFinal reportCessna R182 · Woodland, ALThe flight instructor’s failure to maintain control of the airplane while attempting to conduct visual flight in reduced visibility conditions at night. Factors contributing to the accident include the flight instructor’s inadequate preflight planning, and…NTSB NYC08LA050Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Talladega, ALThe pilot's inadequate visual lookout, which resulted in an in-flight collision with a wire.NTSB MIA08CA012Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Tuscaloosa, ALThe pilot's failure to maintain a visual look out while taxing resulting in an on-ground collision with a parked airplane.NTSB NYC08LA018Accident · No injuriesLimited investigationFinal reportBlair Skybolt · Guntersville, ALSeparation of the right tailwheel control link spring from the right control arm of the tailwheel, which resulted in a loss of control during landing.NTSB NYC07FA226Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Whitfield, ALThe pilot’s intentional flight into known thunderstorms.NTSB ATL07CA126Accident · No injuriesData collectionFinal reportRans RV-9A · Harvest, ALThe pilot's improper landing flare and touchdown.NTSB NYC07CA222Accident · Minor injuriesData collectionFinal reportLancair IV-P · Alabaster, ALThe pilot's failure to attain the proper touchdown point.NTSB MIA07CA126Accident · Minor injuriesData collectionFinal reportPhantom Sport XI · Anderson, ALThe failure of the unqualified person (pilot) to maintain airspeed during the initial climb, resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with a residence.NTSB NYC07LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Enterprise, ALThe designated examiner's improper decision to simulate an engine failure on short final approach, in conjunction with a short-field landing maneuver, and his inadequate remedial action. Contributing to the accident was the private pilot's inadvertent…NTSB MIA07LA111Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Cullman, ALThe pilot’s mismanagement of an in-flight emergency, which resulted in a gear-up landing and runway overrun. Contributing to the accident was a breach to the engine crankcase above and in line with the No. 1 cylinder.NTSB DFW07CA136Accident · No injuriesData collectionFinal reportSandall Evan R RV8 · Wilsonville, ALThe pilot's failure to maintain directional control while landing.NTSB ANC07LA045Accident · No injuriesLimited investigationFinal reportCessna 177 · Centreville, ALThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power and substantial damage during a forced landing on a road.NTSB MIA07LA102Accident · 1 fatalLimited investigationFinal reportBell 47G · Hayden, ALThe student pilot's failure to maintain aircraft control during hover, following a bounced landing.NTSB MIA07CA100Accident · Serious injuriesData collectionFinal reportHillery W. Grice Alley Cat 1 · Fairhope, ALThe failure of the pilot-in-command to maintain terrain clearance while completing a loop at an airshow, resulting in impact with the runway.NTSB MIA07FA098Accident · 1 fatalField investigationFinal reportHughes 369A · Moulton, ALThe separation of a main rotor blade from its tension torsion bar for an undetermined reason.NTSB NYC07CA113Accident · No injuriesData collectionFinal reportMooney M-18L · Bessemer, ALThe pilot's failure to maintain control which resulted in a hard landing and subsequent gear collapse during the landing roll. A factor in the accident was wind gusts.NTSB ATL07CA080Accident · No injuriesData collectionFinal reportRans RV-4 · Selma, ALThe pilot's failure to maintain directional control during landing roll.NTSB ATL07CA072Accident · Minor injuriesData collectionFinal reportCessna C-150G · Enterprise, ALThe CFI's attempted takeoff with known deficiencies in the engine which resulted in a loss of engine power, a forced landing on muddy terrain, and a nose over.NTSB ATL07CA068Accident · No injuriesData collectionFinal reportBeech D50E · Decatur, ALThe pilot's improper fuel management resulting in failure of both engines due to fuel starvation.NTSB ATL07LA066Accident · 1 fatalLimited investigationFinal reportSzybowcowy Zaklad Do SZD-36A · Sylacauga, ALThe pilot's improper installation of the left wing attachment pin, which allowed it to disengage during cruise flight, resulting in wing separation.NTSB ATL07LA063Accident · No injuriesLimited investigationFinal reportRandy Stanley Rotoway Exc 162F · Foley, ALLoss of engine power due to failure of the No. 4 engine exhaust valve.NTSB ATL07LA052Accident · Minor injuriesLimited investigationFinal reportBell 47G2A · Huntsville, ALThe loss of engine power due to undetermined reasons.NTSB ATL07LA044Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Phenix City, ALLoss of engine power due to fuel starvation, the pilot's inadequate preflight planning, and his misunderstanding of how the fuel system operates. Contributing to the accident was the manufacturers insufficiently defined procedures for low fuel operations,…NTSB ATL07FA038Accident · 2 fatalField investigationFinal reportCessna 172K · Bessemer, ALThe non-instrument-rated pilot's continued visual flight rules flight into instrument meteorological conditions.NTSB ATL07LA034Accident · No injuriesLimited investigationFinal reportGreenhaw, William Lancair 360 · Guntersville, ALFailure of an unapproved automotive fuel line installed by the owner/pilot mechanic which resulted in an engine fire during taxi after landing.