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 MIA76FKQ36Accident · Minor injuriesClosedPiper PA-28 · Liberty, MSJun 25, 1976 · N59374 · Substantial damage NTSB MIA76FLT03Accident · Minor injuriesClosedCessna A188B · Byhalia, MSJun 22, 1976 · N84040 · Destroyed NTSB MIA76FKQ35Accident · No injuriesClosedCessna A188B · Shelby, MSJun 8, 1976 · N9399G · Destroyed NTSB MIA76FKQ34Accident · Minor injuriesClosedGrumman G-164A · Swan Lake, MSJun 8, 1976 · N7961 · Substantial damage NTSB MIA76AM090Accident · 4 fatalClosedBeech 95-B55 · Holly Springs, MSMay 29, 1976 · N834J · Destroyed NTSB MIA76FKQ33Accident · No injuriesClosedCessna 182A · Madison, MSMay 27, 1976 · N3852D · Substantial damage NTSB MIA76FKQ32Accident · No injuriesClosedCessna A188B · Rolling Fork, MSMay 25, 1976 · N91262 · Substantial damage NTSB MIA76FKQ31Accident · No injuriesClosedCessna A188B · Hollandale, MSMay 24, 1976 · N70058 · Substantial damage NTSB MIA76FKQ30Accident · No injuriesClosedBoeing E75N1 · Tchula, MSMay 17, 1976 · N63D · Substantial damage NTSB MIA76FKQ29Accident · No injuriesClosedPiper PA-25 · Pace, MSApr 26, 1976 · N5861Z · No damage NTSB MIA76AM078Accident · 2 fatalClosedPiper PA-32 · Plain, MSApr 15, 1976 · N32416 · Destroyed NTSB MIA76FKQ28Accident · No injuriesClosedCessna 188 · Webb, MSApr 5, 1976 · N9715V · Minor damage NTSB MIA76FKQ27Accident · No injuriesClosedCessna A188B · Batesville, MSMar 18, 1976 · N53203 · Substantial damage NTSB MIA76FKQ26Accident · No injuriesClosedCessna 172 · Port Gibson, MSMar 13, 1976 · N79568 · Substantial damage NTSB MIA76FKQ25Accident · 1 fatalClosedCessna 150 · Madison, MSFeb 19, 1976 · N3504V · Destroyed NTSB MIA76AM063Accident · 2 fatalClosedPine Air Super · Iuka, MSFeb 19, 1976 · N2115K · Destroyed NTSB MIA76FKQ24Accident · No injuriesClosedPiper PA-22 · Slate Springs, MSFeb 14, 1976 · N6915D · Substantial damage NTSB MIA76AM060Accident · Minor injuriesClosedCessna 150L · Walls, MSFeb 8, 1976 · N11626 · 2 aircraft · Substantial damage NTSB MIA76AM042Accident · 1 fatalClosedBeech J35 · Columbus, MSNov 14, 1975 · N8296D · Destroyed NTSB MIA76FLT02Accident · No injuriesClosedPiper J3C · Southhaven, MSNov 10, 1975 · N98453 · Substantial damage NTSB MIA76FKQ24Accident · Serious injuriesClosedCessna 182P · Mccomb, MSOct 24, 1975 · N8183G · Destroyed NTSB MIA76FKQ22Accident · Minor injuriesClosedCessna 140 · Philip, MSOct 21, 1975 · N76515 · Destroyed NTSB MIA75FKQ21Accident · Minor injuriesClosedCessna A188B · Drew, MSOct 21, 1975 · N4480Q · Substantial damage NTSB MIA76FKQ23Accident · No injuriesClosedGrumman G-164A · Holly Bluff, MSOct 14, 1975 · N959X · Substantial damage NTSB MIA76FKQ20Accident · No injuriesClosedCessna A188B · Inverness, MSOct 14, 1975 · N79215 · Substantial damage NTSB MIA76FKQ19Accident · No injuriesClosedBell 47G2 · Sumner, MSSep 27, 1975 · N993B · Substantial damage NTSB MIA76DKQ18Accident · No injuriesClosedCessna A188B · Georgetown, MSSep 26, 1975 · N4700R · Substantial damage NTSB MIA76AM025Accident · 2 fatalClosedPiper PA-28R · Grenada, MSSep 17, 1975 · N934PA · Destroyed NTSB MIA76FKQ14Accident · 1 fatalClosedBell 47G3B1 · Magnolia, MSSep 15, 1975 · N216AC · Destroyed NTSB MIA76DKQ17Accident · No injuriesClosedAeronca 7AC · Hollandale, MSSep 14, 1975 · N83946 · Substantial damage NTSB MIA76FKQ13Accident · 1 fatalClosedGrumman G164A · Clarksdale, MSSep 6, 1975 · N4920 · Destroyed NTSB MIA76DLT01Accident · No injuriesClosedPiper PA-28 · Coldwater, MSSep 6, 1975 · N1339T · Substantial damage NTSB MIA76FKQ12Accident · No injuriesClosedCessna A188B · Edwards, MSAug 30, 1975 · N53287 · Substantial damage NTSB MIA76FKQ11Accident · No injuriesClosedCessna A188B · Minter City, MSAug 29, 1975 · N9746G · Substantial damage NTSB MIA76FKQ10Accident · No injuriesClosedAero Cmdr S2R · Belzoni, MSAug 27, 1975 · N5586X · Substantial damage NTSB MIA76AM018Accident · 3 fatalClosedPiper PA-23 · Decatur, MSAug 24, 1975 · N2019P · Destroyed NTSB MIA76FKQ09Accident · Minor injuriesClosedGrum Amer AA1-B · Lexington, MSAug 21, 1975 · N9607L · Substantial damage NTSB MIA76FKQ08Accident · No injuriesClosedPiper PA-18 · Madison, MSAug 20, 1975 · N4686Y · Substantial damage NTSB MIA76FKQ07Accident · Serious injuriesClosedBell 47G-2 · Itta Bena, MSAug 14, 1975 · N4823 · Substantial damage NTSB MIA76FKQ06Accident · No injuriesClosedPiper PA-28 · Greenwood, MSAug 11, 1975 · N3656R · Substantial damage NTSB MIA7LFKQ05Accident · Serious injuriesClosedCessna 150G · Okolona, MSJul 28, 1975 · N4050J · Substantial damage NTSB MIA76FKQ04Accident · Minor injuriesClosedCessna 150 · West Point, MSJul 27, 1975 · N66124 · Destroyed NTSB MIA76AM008Accident · 3 fatalClosedPiper PA-28R · Dekalb, MSJul 25, 1975 · N56778 · Destroyed NTSB MIA76FK003Accident · No injuriesClosedBoeing B75N1 · Merigold, MSJul 23, 1975 · N9478H · Substantial damage NTSB MIA76FKQ02Accident · No injuriesClosedBell 47G3BI · Bay St Louis, MSJul 15, 1975 · N54HP · Substantial damage NTSB MIA76FKQ01Accident · No injuriesClosedHughes 269C · Columbus, MSJul 2, 1975 · N9293F · Substantial damage NTSB MIA75FLT07Accident · Minor injuriesClosedBellanca 17-30A · Olive Branch, MSJun 24, 1975 · N39848 · Substantial damage NTSB MIA75FKQ36Accident · No injuriesClosedPiper PA-28R · Jackson, MSJun 21, 1975 · N33322 · Substantial damage NTSB MIA75DKQ35Accident · No injuriesClosedCessna 172 · Forest, MSJun 14, 1975 · N4125F · Substantial damage NTSB MIA75FKQ34Accident · Minor injuriesClosedBeech 35-C33 · Petal, MSJun 8, 1975 · N6134V · Substantial damage