NTSB investigations, 1997, MS
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
| 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\") = 1997
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") = 1997 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 ATL98FA009Accident · 1 fatalField investigationFinal reportBeech B100 · Madison, MSthe pilot's failure to maintain control of the aircraft due to spatial disorientation. A related factor was: the instrument weather conditions.NTSB MIA98TA011Accident · Minor injuriesFinal reportCessna 172P · Wiggins, MSLoss of engine power for undetermined reasons resulting in a forced landing on unsuitable terrain and the aircraft nosing over during landing roll.NTSB MIA98LA003Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Jackson, MSA partial loss of engine power during the initial climb due to a blockage of the induction system by a piece of gasket material.NTSB MIA97LA252Accident · No injuriesLimited investigationFinal reportCessna A188B · Greenwood, MSThe intentional operation of the airplane from an unsuitable takeoff area by the pilot-in-command and inadvertent rotation of the airplane after encountering rising terrain on the runway.NTSB ATL97LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Fulton, MSThe excessively rich mixture produced by the carburetor, which led to the fuel exhaustion.NTSB ATL97LA139Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Mcgee, MSfuel starvation, while in maneuvering flight, due to the pilot's improper planning/decision.NTSB MIA97LA244Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Louisville, MSThe failure of the pilot to assure that the rudder trim was properly set for takeoff and his delay in aborting the takeoff when the airplane yawed to the left during the early portion of the takeoff roll.NTSB ATL97LA131Accident · No injuriesLimited investigationFinal reportLearjet 31 · Aberdeen, MSThe flightcrew's failure to extend the landing gear.NTSB ATL97LA121Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Holcomb, MSThe failure of the pilot to adequately see and avoid all obstructions while doing aerial application work.NTSB MIA97LA228Accident · No injuriesLimited investigationFinal reportCessna A188B · Cadaretta, MSa hard landing resulting in the airplane departing the runway and impacting with a tree.NTSB MIA97LA209Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · New Albany, MSa forced landing due to an undetermined complete loss of engine power, and subsequent impact with tress.NTSB MIA97LA203Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Bay St. Louis, MSThe pilot's improper short field landing procedure and use of full flaps prior to being assured of reaching the proper touchdown point, resulting in an in-flight collision with an embankment, and subsequent nose over. Contributing to the accident was a total…NTSB MIA97LA195Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Tunica, MSThe pilots poor preflight planning preparation for attempting to takeoff with a tailwind and with the hopper loaded 3/4 full during a 93degree F., day at a density altitude of 2,400 feet.NTSB MIA97LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Walls, MSThe poor in-flight planning by the pilot for her failure to divert to an alternate airport after recognizing that a low fuel quantity state existed when preflight and in-flight planning revealed sufficient fuel for the flight. Contributing to the accident was…NTSB MIA97LA190Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Edwards, MSfailure of the distributor drive gear in the right magneto, resulting in loss of engine power and a forced landing. The lack of suitable terrain for a forced landing was a related factor.NTSB MIA97LA187Accident · No injuriesLimited investigationFinal reportSpencer Pitts S-1S · Greenwood, MSloss of directional control during the landing rollout for undetermined reason(s), resulting in the airplane veering to the right and subsequently nosing over.NTSB ATL97LA084Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Columbus, MSinadequate maintenance/inspection and subsequent corrosion of the air filter, which resulted in pieces of the air filter to block the intake to the carburetor and result in loss of engine power. A factor relating to the accident was: failure of maintenance…NTSB ATL97LA070Accident · Minor injuriesLimited investigationFinal reportEugene Clements Pulsar · Indianola, MSThe pilot's failure to correctly recover from a bounced landing leading to the collapse of the nose gear. Factors were the pilot's lack of recent flight time and lack of aircraft familiarity.NTSB MIA97LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ackerman, MSinstallation of an incorrect fuel filter in the fuel tanker, which allowed water-contaminated fuel being dispensed into the aircraft, subsequent partial loss of engine power on initial takeoff climb, and a forced landing. The lack of suitable terrain for a…NTSB ATL97LA049Accident · No injuriesLimited investigationFinal reportCessna 441 · Madison, MSfailure of the pilot to follow the landing checklist, which resulted in a gear-up landing.NTSB ATL97LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Gulfport, MSthe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of fuel.NTSB ATL97LA036Accident · No injuriesLimited investigationFinal reportRobinson R22 · Wiggins, MSthe student pilot misjudged rotor blade clearance from a utility pole, which resulted in a collision. The proximity of the pole was a related factor.