Skip to content

NTSB investigations, MS

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 MIA73FKQ21Accident · No injuriesClosedCessna 172 · Gulfport, MSOct 21, 1972 · N2429U · Substantial damage NTSB MIA73FKQ19Accident · 2 fatalClosedPientonpol Camper · Ocean Sprngs, MSOct 1, 1972 · N1074Z · Destroyed NTSB MIA73FKQ20Accident · No injuriesClosedPiper J3C-65 · Pascagoula, MSSep 27, 1972 · N32806 · Destroyed NTSB MIA73FKQ17Accident · 1 fatalClosedCessna A188B · Alligator, MSSep 27, 1972 · N21605 · Destroyed NTSB MIA73DLT09Accident · No injuriesClosedPiper PA-25 · Holly Sprngs, MSSep 27, 1972 · N4993Y · Substantial damage NTSB MIA73DKQ16Accident · No injuriesClosedGrumman G-164 · Monticello, MSSep 26, 1972 · N10245 · Substantial damage NTSB MIA73DLT06Accident · No injuriesClosedCessna 188A · Dundee, MSSep 23, 1972 · N5624J · Substantial damage NTSB MIA73AM045Accident · 1 fatalClosedCessna 177 · Natchez, MSSep 20, 1972 · N30245 · Destroyed NTSB MIA73IM034Incident · Minor injuriesClosedDouglas DC-8 · Meridian, MSSep 17, 1972 · N806E · No damage NTSB MIA73FKQ16Accident · Serious injuriesClosedCessna 172 · Columbus, MSSep 13, 1972 · N3934R · Substantial damage NTSB MIA73AM026Accident · 6 fatalClosedPiper PA-31 · Columbus, MSSep 7, 1972 · N9261Y · Destroyed NTSB MIA73FKQ12Accident · No injuriesClosedCessna A188A · Calhoun City, MSSep 6, 1972 · N9966G · Destroyed NTSB MIA73DKQ14Accident · Serious injuriesClosedCessna A188A · Rulville, MSSep 6, 1972 · N4406Q · Destroyed NTSB MIA73DLT03Accident · No injuriesClosedCessna 150 · Olive Branch, MSSep 5, 1972 · N1294Q · Substantial damage NTSB MIA73DKQ13Accident · Minor injuriesClosedCallair A-9 · Edwards, MSSep 5, 1972 · N9620Z · Substantial damage NTSB MIA73DKQ11Accident · No injuriesClosedGrumman G-164A · Woodville, MSSep 3, 1972 · N8372 · Substantial damage NTSB MIA73DKQ10Accident · No injuriesClosedPiper PA-25 · Bobo, MSAug 31, 1972 · N7257Z · Destroyed NTSB MIA73FKQ09Accident · No injuriesClosedPiper PA-30 · Greenwood, MSAug 30, 1972 · N7805Y · Substantial damage NTSB MIA73FKQ07Accident · Serious injuriesClosedCessna A188 · Arcola, MSAug 29, 1972 · N3508Q · Substantial damage NTSB MIA73DKQ08Accident · Serious injuriesClosedBoeing E75 · Greenwood, MSAug 29, 1972 · N65872 · Destroyed NTSB MIA73FKQ05Accident · No injuriesClosedCessna 188 · Webb, MSAug 21, 1972 · N8075V · Destroyed NTSB MIA73FKQ06Accident · No injuriesClosedBoeing B75N1 · Minter City, MSAug 18, 1972 · N64387 · Substantial damage NTSB MIA73FKQ04Accident · No injuriesClosedChampion 7ECA · Ocean Sprngs, MSAug 18, 1972 · N6325N · Substantial damage NTSB MIA73FKQ03Accident · No injuriesClosedFleet Acft 16B · Mccomb, MSAug 14, 1972 · N162V · Substantial damage NTSB MIA73AM015Accident · 1 fatalClosedCessna 177 · Jackson, MSAug 9, 1972 · N3217T · Destroyed NTSB MIA73FKQ02Accident · No injuriesClosedGrumman G-164 · Philipp, MSAug 7, 1972 · N745Y · Substantial damage NTSB MIA73DLT02Accident · No injuriesClosedCessna A188A · Olive Branch, MSAug 6, 1972 · N9905G · Substantial damage NTSB MIA73AM009Accident · No injuriesClosedCessna 206 · Jackson, MSJul 13, 1972 · N5016U · Substantial damage NTSB MKC73AK004Accident · 1 fatalClosedCessna 172 · Tunica, MSJul 6, 1972 · N3965L · Destroyed NTSB MIA72FLT15Accident · No injuriesClosedBellanca 17-31A · Walls, MSJun 20, 1972 · N8211R · Substantial damage NTSB MIA72DKQ36Accident · No injuriesClosedCessna 172K · Boyle, MSJun 17, 1972 · N78249 · Substantial damage NTSB MIA72DLT14Accident · No injuriesClosedCessna 188A · Olive Branch, MSJun 16, 1972 · N9945G · Destroyed NTSB MIA72FKQ35Accident · Serious injuriesClosedAero Comdr 560-A · Greenwood, MSJun 10, 1972 · N2754B · Destroyed NTSB MIA72AM128Accident · 2 fatalClosedFairchild M-62A · Madison, MSJun 2, 1972 · N54112 · Destroyed NTSB MIA72FLT13Accident · Minor injuriesClosedCessna 182 · Southaven, MSMay 26, 1972 · N91516 · Substantial damage NTSB MIA72FKQ34Accident · Minor injuriesClosedLuscombe 8E · Laurel, MSMay 26, 1972 · N1499K · Substantial damage NTSB MIA72AM118Accident · 1 fatalClosedBeech A23 · Leakesville, MSMay 7, 1972 · N3888Q · Destroyed NTSB MIA72AM115Accident · Minor injuriesClosedCessna 411 · Monticello, MSApr 30, 1972 · N7399U · Substantial damage NTSB MIA72FKQ33Accident · No injuriesClosedGillam Star SA300 · Picayune, MSMar 31, 1972 · N2462 · Substantial damage NTSB MIA72AM098Accident · 1 fatalClosedPiper J3C-65 · Ocean Sprngs, MSMar 23, 1972 · N42193 · Destroyed NTSB MIA72DKQ32Accident · No injuriesClosedCallair A-9 · Avon, MSMar 18, 1972 · N7601V · Substantial damage NTSB MIA72AM091Accident · 3 fatalClosedCessna 182H · Wiggins, MSMar 14, 1972 · N8428S · Destroyed NTSB MIA72IM084Incident · No injuriesClosedMartin 404 · Columbus, MSFeb 21, 1972 · N259S · Minor damage NTSB MIA72FKQ29Accident · No injuriesClosedCessna 310K · Tupelo, MSFeb 15, 1972 · N6996L · Destroyed NTSB MIA72FKQ30Accident · No injuriesClosedPiper PA-30 · Greenwood, MSFeb 14, 1972 · N7026Y · Substantial damage NTSB MIA72DKQ31Accident · No injuriesClosedPiper PA-28 · Picayune, MSFeb 12, 1972 · N5509U · Substantial damage NTSB MIA72FKQ28Accident · Serious injuriesClosedCessna 188B · Columbus, MSJan 7, 1972 · PT-DZL · Destroyed NTSB MIA72FKQ27Accident · No injuriesClosedHiller Acft FH1100 · Hattiesburg, MSDec 22, 1971 · N5035F · Substantial damage NTSB MIA72FKQ26Accident · No injuriesClosedCessna 175 · Duck Hill, MSNov 28, 1971 · N9259B · Substantial damage NTSB MIA72AM045Accident · 4 fatalClosedPiper PA-31 · Iuka, MSNov 17, 1971 · N780JM · Destroyed