NTSB investigations, 2000, 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\") = 2000
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") = 2000 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 ATL01LA013Accident · No injuriesLimited investigationFinal reportBeech BE-23-A24R · Jackson, MSDeer on the runway, which forced the pilot to make an evasive maneuver forcing him to the side of the runway and striking the marker lights.NTSB MIA01LA031Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Iuka, MSa loss of engine power due to fuel contamination resulting in fuel starvation, a forced landing and the subsequent in-flight collision with a wire.NTSB MIA01LA011Accident · Serious injuriesLimited investigationFinal reportCamillo Annaloro C A Spcl Quicks · Lucedale, MSThe failure of the pilot to secure a fabric panel during preflight inspection resulting in the panel separating from the aircraft during climb after takeoff, passing through the propeller and damaging wing flap fabric, loss of engine power due to wing flap…NTSB MIA00LA272Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Gulfport, MSa loss of power on both engines, during a simulated engine out approach, resulting in a forced landing and the subsequent on ground impact with a pole.NTSB MIA00FA265Accident · 2 fatalField investigationFinal reportBeech 58P · Brookhaven, MSThe poor in-flight planning/decision by the pilot for flying a close-in downwind leg, improper aircraft handling by the pilot for his executing a 70-75 degree angle of bank turning base to final while circling to land, and inadvertent stall/mush of the…NTSB MIA00LA257Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Canton, MSThe pilot's inadequate visual lookout which resulted in the helicopter colliding with power lines, catching fire, and being consumed by fire after landing.NTSB MIA00LA276Accident · Serious injuriesLimited investigationFinal reportChristian Quicksilver · Booneville, MSan inadvertent stall at too low an altitude to allow recovery, which resulted in impact with trees. Factors in this accident were the owner/pilot was not a certified pilot, and lacked training.NTSB MIA00LA237Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Perthshire, MSthe pilot's failure to perform a weight and balance check that resulted in overloading of the airplane with spraying material, for the weather conditions that existed at the time of takeoff. Factors in this accident were extremely high temperatures, which…NTSB MIA00LA225Accident · No injuriesLimited investigationFinal reportCessna 421A · Homewood, MSThe inadequate installation of the right propeller by the mechanic for his failure to properly torque the eight nuts resulting in fatigue failure of the studs and separation of the right propeller during cruise flight. Findings in the investigation were 1)…NTSB MIA00FA221Accident · 1 fatalField investigationFinal reportBeech 58 · Hernando, MSThe arcing of an electrical wire behind the instrument panel and the associated cracking of fuel and oil lines. Also causal was the pilot's inappropriate remedial action not in accordance with the emergency checklist.NTSB MIA00FA217Accident · 2 fatalField investigationFinal reportCessna 150M · Holly Springs, MSThe failure of the pilot to maintain control while maneuvering the aircraft due to impairment as a result of use of illegal drugs, and the subsequent collision with the terrain during an uncontrolled descent.NTSB MIA00LA202Accident · 1 fatalLimited investigationFinal reportCessna A188B · Inverness, MSThe failure of the pilot to maintain airspeed while reversing course during an aerial application flight resulting in the aircraft stalling, descending, impacting a tree, and crashing to the ground.NTSB MIA00LA204Accident · No injuriesLimited investigationFinal reportSpurgeon Avid Bandit · Columbus, MSthe owner/builder's improper installation that resulted in the fuel line being snagged, resulting in fuel starvation and an inflight loss of engine power and subsequent damage to the airplane during the forced landing.NTSB MIA00LA197Accident · No injuriesLimited investigationFinal reportCessna A188B · Belzoni, MSThe pilot's failure to refuel prior to departure resulting in loss of engine power due to fuel exhaustion.NTSB ATL00LA067Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Tylertown, MSLoss of directional control due to separation of the tail-wheel spring assembly. A factor was the ditch which run adjacent to the runway.NTSB ATL00FA061Accident · 2 fatalField investigationFinal reportCessna 150G · Oxford, MSThe certified flight instructor's failure to maintain airspeed during climbout.NTSB MIA00LA182Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Steens, MSthe flight instructor failed to maintain control of the airplane after landing, which resulted in an on ground collision with a tree. Factors in this accident were the flight instructor allowed the student to get too fast and high on the approach.NTSB MIA00LA168Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Monticello, MSThe failure of the pilot to maintain directional control during takeoff into crosswind conditions resulting in the collision with trees. A factor in the accident was the pilot's lack of familiarity with the aircraft.NTSB MIA00LA150Accident · No injuriesLimited investigationFinal reportCessna 172H · Picayune, MSAn in-flight fire in the vicinity of the firewall from an undetermined source. This resulted in a forced landing to an airport and total consumption of the airplane by fire after landing.NTSB MIA00FA146Accident · No injuriesField investigationFinal reportBeech F35 · Jackson, MSimproper rigging of the rudder/elevators and differential mechanism assembly by unknown person(s), which resulting in what the pilot describes as inflight flutter of the tail section, which resulted in damage to the aft empennage area.NTSB MIA00LA130Accident · Minor injuriesLimited investigationFinal reportScott Vans RV-4 · Natchez, MSan inadvertent stall at too low altitude to allow recovery. Factors in this accident were fog and low ceilings.NTSB MIA00LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ocean Springs, MSThe pilot's failure to maintain control of the aircraft while making a forced landing following loss of engine power for undetermined reasons, resulting in the aircraft impacting hard on the runway, bouncing into the air, and colliding with powerlines off the…NTSB MIA00LA092Accident · Serious injuriesLimited investigationFinal reportKitchens Revolution Mini 500B · Hazelhurst, MSthe pilot's failure to maintain control of the helicopter during a practice autorotation, by allowing the rotor rpm to become inadequate to cushion the touchdown, which resulted in a hard landing, and subsequent roll over.NTSB MIA00LA086Accident · No injuriesLimited investigationFinal reportCessna 172R · Olive Branch, MSThe student pilot's failure to maintain directional control during landing and the subsequent collision with a taxiway sign and collapsed right main landing gear.