NTSB investigations, 2006, 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\") = 2006
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") = 2006 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 DFW07CA045Accident · No injuriesData collectionFinal reportErcoupe 415-C · Lakeshore, MSThe landing overrun for unknown reasons. A factor was the ditch.NTSB DFW07LA006Accident · Minor injuriesLimited investigationFinal reportWindward OWL · Starkville, MSThe structural failure of the airframe due to the inadvertent excessive airspeed during maneuvering.NTSB DFW07CA012Accident · No injuriesData collectionFinal reportCessna 182 · Vicksburg, MSThe structural damage to the firewall during a suspected hard landing.NTSB DFW06LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Newton, MSThe total loss of engine power due to fuel contamination. A factor was the pilot's inadequate preflight inspection.NTSB DFW06LA195Accident · 1 fatalLimited investigationFinal reportCessna A188B · Sumrall, MSThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the partial loss of engine power and the low altitude.NTSB DFW06CA194Accident · Serious injuriesData collectionFinal reportCurtiss-Wright Travel Air 4000 · Jackson, MSThe pilot's failure to maintain airspeed on final approach resulting in an inadvertent stall and a subsequent loss of control.NTSB DFW06FA187Accident · 2 fatalField investigationFinal reportCessna 172N · Petal, MSThe pilot's improper use of flaps, which resulted in an impact with trees during takeoff-initial climb.NTSB DFW06CA128Accident · No injuriesData collectionFinal reportBeech BE33 · Greenville, MSThe pilot's failure to maintain directional control while landing. Contributing factors were the crosswind and the gusty winds.NTSB DFW06FA110Accident · 1 fatalField investigationFinal reportMooney M20K · Columbus, MSThe loss of engine power for undetermined reasons. A contributing factor was the pilot's improper decision to forgo suitable forced landing opportunities in an attempt to return to the airport.NTSB DFW06LA103Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Meridian, MSThe pilot's failure to maintain clearance from trees. Contributing factors were the drug impairment and low maneuvering altitude.NTSB DFW06FA095Accident · 2 fatalField investigationFinal reportPiper/Stevens PA18A-150 · Hollandale, MSThe pilots failure to maintain control of the airplane. A contributing factor was the pilots impairment.NTSB DFW06CA092Accident · No injuriesData collectionFinal reportWaterwings SeaRey · Vicksburg, MSThe pilot's inadvertent reduction of power resuting in a collision with water. Contributing factors were the low altiude selected and the pilot's inattention.