Skip to content

NTSB investigations, MS

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 c."eventStateOrRegion" = 'MS' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 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 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 ATL80FKQ19Accident · No injuriesClosedCessna A188B · Merigold, MSAug 5, 1980 · N9118R · Substantial damage NTSB ATL80FLT10Accident · No injuriesClosedBeech 23 · Holly Springs, MSJul 29, 1980 · N24045 · Substantial damage NTSB ATL80FKQ18Accident · Serious injuriesClosedCessna A188B · Yazoo City, MSJul 24, 1980 · N53117 · Substantial damage NTSB ATL80FA077Accident · 1 fatalClosedBellanca 8GCBC · Banks, MSJul 24, 1980 · N8652V · Destroyed NTSB ATL80DKQ17Accident · No injuriesClosedCessna 188B · Belzoni, MSJul 18, 1980 · N8789G · Substantial damage NTSB ATL80FKQ16Accident · Minor injuriesClosedTomcat Mark 5 · Tutwiler, MSJul 13, 1980 · N9099T · Substantial damage NTSB ATL80FKQ15Accident · No injuriesClosedCessna 152 · Ocean Springs, MSJul 12, 1980 · N5387B · Substantial damage NTSB ATL80FLT09Accident · No injuriesClosedGrumman G-164 · Olive Branch, MSJul 9, 1980 · N582Y · Destroyed NTSB ATL80FKQ13Accident · No injuriesClosedCessna 188 · Charleston, MSJul 8, 1980 · N53307 · Substantial damage NTSB ATL80DKQ14Accident · No injuriesClosedCessna T188C · Tutwiler, MSJul 8, 1980 · N3155J · Substantial damage NTSB ATL80FA070Accident · 1 fatalClosedAero Comdr 680V · Jackson, MSJul 7, 1980 · N2755H · Destroyed NTSB ATL80FKQ12Accident · Minor injuriesClosedCessna A188B · Hollandale, MSJul 5, 1980 · N4883Q · Substantial damage NTSB ATL80DKQ11Accident · No injuriesClosedAeronca 7AC · Leland, MSJun 27, 1980 · N2942E · Substantial damage NTSB ATL80DKQ10Accident · No injuriesClosedCessna 188B · Leland, MSJun 26, 1980 · N91494 · Substantial damage NTSB ATL80FKQ09Accident · No injuriesClosedGrumman G-164B · Clarksdale, MSJun 19, 1980 · N6765Q · Substantial damage NTSB ATL80DKQ08Accident · Minor injuriesClosedCessna A188B · Philipp, MSJun 16, 1980 · N731NL · Destroyed NTSB ATL80FA053Accident · 2 fatalClosedGrumman AA-1C · Delisle, MSJun 14, 1980 · N9754U · Destroyed NTSB ATL80FKQ07Accident · Minor injuriesClosedPiper PA-22 · Brookhaven, MSJun 7, 1980 · N3567A · Substantial damage NTSB ATL80FKQ06Accident · Minor injuriesClosedAir Tractor AT301 · Flora, MSJun 4, 1980 · N3648Y · Destroyed NTSB ATL80DKQ05Accident · No injuriesClosedCessna 188T · Hollandale, MSMay 30, 1980 · N2198J · Substantial damage NTSB ATL80FKQ04Accident · No injuriesClosedGrumman G-164A · Boyle, MSMay 25, 1980 · N9734 · Substantial damage NTSB ATL80FKQ03Accident · No injuriesClosedGrumman G-164A · Clarksdale, MSMay 23, 1980 · N7867 · Substantial damage NTSB ATL80FA047Accident · 1 fatalClosedPiper PA-34 · Enterprise, MSMay 16, 1980 · N812DM · Destroyed NTSB ATL80DKQ02Accident · No injuriesClosedCessna T188T · Belzoni, MSMay 8, 1980 · N2321J · Substantial damage NTSB ATL80FKQ01Accident · Serious injuriesClosedCessna 150 · Prentiss, MSMay 6, 1980 · N7921F · Substantial damage NTSB MIA80FA052Accident · Serious injuriesClosedCessna 414 · Gulfport, MSApr 2, 1980 · N1659T · Destroyed NTSB MIA80FKQ06Accident · Minor injuriesClosedCessna 337 · Madison, MSApr 1, 1980 · N112DH · Substantial damage NTSB MIA80FKQ05Accident · Serious injuriesClosedAmateur PDQ-2 · Greenville, MSMar 31, 1980 · N635MC · Substantial damage NTSB MIA80FKQ04Accident · No injuriesClosedCessna 140 · Drew, MSMar 23, 1980 · N76653 · Substantial damage NTSB MIA80FKQ03Accident · Minor injuriesClosedGrumman G-164A · Flora, MSMar 14, 1980 · N48507 · Destroyed NTSB MIA80FLT02Accident · Minor injuriesClosedAero Comdr S2R · Eudora, MSMar 11, 1980 · N5601X · Substantial damage NTSB MIA80FLT01Accident · 1 fatalClosedCessna 188 · Tunica, MSFeb 27, 1980 · N8148V · Destroyed NTSB MIA80FKQ02Accident · 1 fatalClosedErco 415-C · Mooreville, MSJan 5, 1980 · N87156 · Substantial damage NTSB MIA80DRQ01Accident · No injuriesClosedBellanca 7GCAA · Belzoni, MSOct 2, 1979 · N86632 · Substantial damage NTSB MIA79FA130Accident · 2 fatalClosedCessna 120 · Vicksburg, MSSep 29, 1979 · N72504 · Destroyed NTSB MIA79DKQ34Accident · No injuriesClosedPiper PA-25 · Duck Hill, MSSep 12, 1979 · N7446Z · Substantial damage NTSB MIA79FKG33Accident · 1 fatalClosedRockwell S2R · Belzoni, MSSep 8, 1979 · N5044X · Substantial damage NTSB MIA79DKQ32Accident · No injuriesClosedCessna A188A · Sidon, MSSep 8, 1979 · N18DS · Destroyed NTSB MIA79DKQ30Accident · Minor injuriesClosedCessa A188B · Crawford, MSSep 6, 1979 · N731BQ · Destroyed NTSB MIA79FKQ31Accident · Minor injuriesClosedEmair MA-1 · Canton, MSSep 4, 1979 · N97063 · Substantial damage NTSB MIA79FKQ28Accident · Minor injuriesClosedAir Tractor AT-301 · Grenada, MSSep 4, 1979 · N8595S · Substantial damage NTSB MIA79DKQ29Accident · No injuriesClosedCessna A188B · Glen Allan, MSSep 4, 1979 · N731EK · Substantial damage NTSB MIA79FKQ27Accident · No injuriesClosedCessna A188B · Sledge, MSAug 29, 1979 · N53196 · Substantial damage NTSB MIA79DKQ26Accident · Minor injuriesClosedCessna A188B · Nitta Yuma, MSAug 28, 1979 · N731VL · Substantial damage NTSB MIA79FKQ25Accident · No injuriesClosedGrumman G-164A · Sunflower, MSAug 27, 1979 · N48437 · Substantial damage NTSB MIA79FKQ23Accident · No injuriesClosedCessna A188B · Shelby, MSAug 24, 1979 · N84284 · Substantial damage NTSB MIA79FKQ24Accident · No injuriesClosedCessna 188 · Water Valley, MSAug 20, 1979 · N1586M · Destroyed NTSB MIA79FKQ22Accident · No injuriesClosedGrumman G-164A · Madison, MSAug 13, 1979 · N8673H · Destroyed NTSB MIA79FKQ21Accident · No injuriesClosedPiper PA-36 · Tutwiler, MSAug 12, 1979 · N56664 · Destroyed NTSB MIA79FKQ20Accident · Minor injuriesClosedNaval Fcty N3N-3 · Petal, MSJul 29, 1979 · N45021 · Substantial damage