NTSB investigations, 2009, MS
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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
| 1964 | 54 |
|---|---|
| 1965 | 69 |
| 1966 | 62 |
| 1967 | 58 |
| 1968 | 50 |
| 1969 | 54 |
| 1970 | 40 |
| 1971 | 58 |
| 1972 | 52 |
| 1973 | 32 |
| 1974 | 51 |
| 1975 | 44 |
| 1976 | 36 |
| 1977 | 56 |
| 1978 | 49 |
| 1979 | 44 |
| 1980 | 43 |
| 1981 | 45 |
| 1982 | 36 |
| 1983 | 21 |
| 1984 | 29 |
| 1985 | 23 |
| 1986 | 26 |
| 1987 | 34 |
| 1988 | 26 |
| 1989 | 36 |
| 1990 | 20 |
| 1991 | 25 |
| 1992 | 20 |
| 1993 | 26 |
| 1994 | 20 |
| 1995 | 35 |
| 1996 | 22 |
| 1997 | 22 |
| 1998 | 25 |
| 1999 | 38 |
| 2000 | 24 |
| 2001 | 23 |
| 2002 | 16 |
| 2003 | 19 |
| 2004 | 18 |
| 2005 | 19 |
| 2006 | 12 |
| 2007 | 20 |
| 2008 | 16 |
| 2009 | 19 |
| 2010 | 8 |
| 2011 | 16 |
| 2012 | 19 |
| 2013 | 13 |
| 2014 | 12 |
| 2015 | 10 |
| 2016 | 7 |
| 2017 | 11 |
| 2018 | 6 |
| 2019 | 13 |
| 2020 | 7 |
| 2021 | 11 |
| 2022 | 9 |
| 2023 | 8 |
| 2024 | 8 |
| 2025 | 10 |
| 2026 | 7 |
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\") = 2009
AND c.\"eventStateOrRegion\" = 'MS' 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") = 2009 AND c."eventStateOrRegion" = 'MS' 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 ERA10LA059Accident · No injuriesLimited investigationFinal reportCessna A188B · Ripley, MSThe pilot’s failure to maintain adequate airspeed on final approach, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of engine power due to water in the fuel.NTSB ERA10LA032Accident · Serious injuriesLimited investigationFinal reportBell 206 · Eupora, MSA loss of engine power due to fuel contamination of the helicopter’s fuel supply.NTSB ERA10LA025Accident · Serious injuriesLimited investigationFinal reportArgence Enas A. Christen Eagle · Hernando, MSThe pilot's failure to maintain adequate airspeed during a return to the airport, which resulted in an aerodynamic stall and spin.NTSB ERA09LA536Accident · 1 fatalLimited investigationFinal reportDuke Paul Challenger II · Lumberton, MSThe non-certificated pilot’s failure to maintain clearance from trees during a go-around procedure for unknown reasons.NTSB ERA09FA497Accident · 1 fatalField investigationFinal reportRobinson R44 · Jackson, MSThe pilot's failure to maintain adequate main rotor rpm, for undetermined reasons.NTSB ERA09LA431Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT502 · Minter City, MSThe pilot’s failure to maintain airspeed while maneuvering at a low altitude, resulting in an aerodynamic stall.NTSB ERA09CA428Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Dundee, MSThe pilot's failure to maintain aircraft control during takeoff.NTSB ERA09LA388Accident · Serious injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Oakland, MSA total loss of engine power while maneuvering (after performing aerobatics) for undetermined reasons.NTSB ERA09CA359Accident · No injuriesData collectionFinal reportAircraft Mfg & Development CH 601XL S · Vaughn, MSThe pilot's inadequate preflight planning.NTSB ERA09LA346Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Magee, MSA total loss of engine power after takeoff for undetermined reasons.NTSB ERA09LA316Accident · 2 fatalLimited investigationFinal reportRick Campbell Zenith-STOL CH801 · Gallman, MSA total loss of engine power due to fuel starvation as a result of the flightcrew's improper fuel management.NTSB ERA09CA294Accident · No injuriesData collectionFinal reportCessna R182 · Collins, MSThe pilot’s failure to maintain clearance from an antenna during a low-altitude aerial observation flight. Contributing to the accident was the sun glare.NTSB ERA09CA285Accident · No injuriesData collectionFinal reportRichard Rank KitFox 4 · Madison, MSThe pilot’s failure to maintain aircraft control during an aborted formation takeoff.NTSB ERA09CA265Accident · Minor injuriesData collectionFinal reportCessna 172E · Como, MSThe pilot's inadequate recovery from a bounced landing.NTSB ERA09CA243Accident · Minor injuriesData collectionFinal reportCessna 150 · Madison, MSThe pilot's improper flare and subsequent loss of directional control.NTSB ERA09LA208Accident · No injuriesLimited investigationFinal reportCessna 150E · Columbia, MSA loss of engine power in flight due to fuel exhaustion as a result of the pilot's inadequate preflight and in-flight fuel planning.NTSB ERA09LA209Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lumberton, MSCollapse of the landing gear due to worn left main landing gear components.NTSB ERA09CA195Accident · No injuriesData collectionFinal reportCessna 172P · Cleveland, MSThe inadvertent encounter with a bird in flight.NTSB ERA09LA128Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Philadelphia, MSThe pilot's improper preflight weather planning and his continued VFR flight into IMC conditions resulting in an in-flight collision with trees.