NTSB investigations, 1990, 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\") = 1990
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") = 1990 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 MIA91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Inverness, MSThe student pilot's failure to refuel the airplane. Factors were: uel exhaustion, the pilot's lack of total aeronautical experience, and soft terrain.NTSB MIA91LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rolling Fork, MSThe failure of the pilot to maintain wingtip clearance with tall grass at the edge of the runway during the ground roll.NTSB MIA90FA190Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Thornton, MSThe improper drilling of a hole in the spar cap by a mechanic resulting in the initiation of fatigue cracking in the spar cap and subsequent failure of the spar cap and inflight separation of the wing.NTSB MIA90LA185Accident · No injuriesLimited investigationFinal reportCessna A188B · Vicksburg, MSFailure of the pilot to avoid a mud hole on the runway during the ground roll to takeoff.NTSB MIA90LA176Accident · No injuriesLimited investigationFinal reportGrumman 164-A · Dundee, MSImproper maintenance repair by an unknown person that initiated the engine failure and the forced landing.NTSB MIA90LA173Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Hattiesburg, MSFailure of the pilot in command to attain adequate airspeed prior to liftoff during an attempted takeoff. The pilot then lost control of the airplane in flight. The pilot also delayed in his decision to abort the takeoff.NTSB MIA90LA169Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greenville, MSThe partial loss of engine power for an unknown reason.NTSB MIA90LA149Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Crowder, MSFatigue failure of a bolt which secures the mixture and throttle bellcranks to the bellcrank support assembly.NTSB MIA90LA138Accident · Minor injuriesLimited investigationFinal reportSpezio Sport DAL-1 · Columbus, MSFailure of the pilot to maintain adequate airspeed, resulting in an inadvertent stall and subsequent loss of control. A related factor was: the lack of a stall warning system installed in the aircraft.NTSB MIA90LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, MSThe student pilot landed long and delayed applying power during the ground roll of the touch-and-go landing.NTSB MIA90LA130Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCAA · Leland, MSFailure of the pilot to see-and-avoid the power lines.NTSB MIA90LA123Accident · Serious injuriesLimited investigationFinal reportBell TH-13T · Biloxi, MSThe passenger's intentional act of jumping in the air with his arm raised while under the main rotor.NTSB MIA90LA119Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Shelby, MSThe pilot's inadequate preflight planning and attempted flight with insufficient fuel on board to complete the flight.NTSB MIA90LA110Accident · No injuriesLimited investigationFinal reportCessna 180K · Crystal Springs, MSPilots failure to assure that the fuel cap was in position and secured prior to departure. This resulted in fuel siphoning overboard resulting in the precautionary landing.NTSB MIA90LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Jackson, MSThe pilot's improper compensation for the cross-wind.NTSB MIA90LA099Accident · No injuriesLimited investigationFinal reportCessna P210N · Natchez, MSThe late extension of the landing gear by the pilot.NTSB MIA90LA083Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Rolling Fork, MSThe in-flight separation of the left aileron due to improper maintenance procedures and an inadequate aircraft preflight.NTSB MIA90LA082Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Alligator, MSEngine failure due to undetermined reasons resulting in the forced landing.NTSB MIA90LA078Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mattson, MSThe no. 6 cylinder which cracked across the top from one spark plug hole to the other, resulting in the loss of engine power.NTSB MIA90LA057Accident · No injuriesLimited investigationFinal reportBeech 400 · West Point, MSThe pilot misjudged distance, speed, and altitude on final approach, and failed to attain the proper touchdown Point for landing.