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 MIA67F0450Accident · Serious injuriesClosedPiper PA-25 · Greenville, MSMar 14, 1967 · N6913Z · Destroyed NTSB MIA67A0090Accident · No injuriesClosedBoeing A75N1 · Tralake, MSMar 7, 1967 · N59759 · Minor damage NTSB MIA67F0452Accident · No injuriesClosedCessna 140 · Amory, MSMar 5, 1967 · N2194N · Substantial damage NTSB MIA67F0426Accident · No injuriesClosedCessna 210D · Jackson, MSMar 1, 1967 · N3740Y · Substantial damage NTSB MIA67F0394Accident · No injuriesClosedCessna 150D · Madison, MSFeb 23, 1967 · N6031T · Destroyed NTSB MIA67F0412Accident · Minor injuriesClosedCessna 150F · Wiggins, MSFeb 22, 1967 · N8500G · Substantial damage NTSB MIA67F0379Accident · No injuriesClosedCessna 172F · Port Gibson, MSJan 30, 1967 · N8594U · Substantial damage NTSB MIA67F0340Accident · Serious injuriesClosedCessna 180 · Vicksburg, MSDec 30, 1966 · N3191D · Destroyed NTSB MIA67F0320Accident · No injuriesClosedPiper PA-22 · Starkville, MSDec 12, 1966 · N4989Z · Substantial damage NTSB MIA67F0326Accident · No injuriesClosedAero Comdr 500 · Vicksburg, MSDec 7, 1966 · N6231B · Substantial damage NTSB MIA67D0306Accident · No injuriesClosedCessna 150 · Agricola, MSDec 3, 1966 · N7860Z · Substantial damage NTSB MIA67F0307Accident · No injuriesClosedN.American SNJ-5 · Picayune, MSNov 26, 1966 · N7987C · Substantial damage NTSB MIA67F0301Accident · No injuriesClosedTemco GC-1B · Agricola, MSNov 17, 1966 · N3856K · Substantial damage NTSB MIA67F0294Accident · No injuriesClosedChampion 7EC · Picayune, MSNov 10, 1966 · N7506B · Substantial damage NTSB MIA67F0272Accident · No injuriesClosedCessna 150 · Icksburg, MSNov 10, 1966 · N7044F · Substantial damage NTSB MIA67F0245Accident · No injuriesClosedCessna 210D · Jackson, MSNov 10, 1966 · N3740Y · Substantial damage NTSB MIA67A0050Accident · 2 fatalClosedBell 47J-2A · Leland, MSOct 20, 1966 · N8582F · Destroyed NTSB MIA67F0213Accident · No injuriesClosedCessna 170B · Shelby, MSOct 13, 1966 · N8387A · Substantial damage NTSB MIA67F0215Accident · No injuriesClosedSnow S2C · Independence, MSOct 10, 1966 · N9488R · Destroyed NTSB MIA67A0045Accident · 3 fatalClosedPiper PA-24 · Stringer, MSOct 9, 1966 · N9048P · Destroyed NTSB MIA67D0217Accident · No injuriesClosedPiper PA-24 · Macon, MSOct 2, 1966 · N5756P · Substantial damage NTSB MIA67F0188Accident · No injuriesClosedPiper J-3 · Clarksdale, MSOct 1, 1966 · N92627 · Substantial damage NTSB MIA67A0041Accident · 2 fatalClosedPiper PA-28 · Senatobia, MSSep 28, 1966 · N7878W · Destroyed NTSB MIA67D0182Accident · No injuriesClosedCessna 150 · Lambert, MSSep 22, 1966 · N7018F · Destroyed NTSB MIA67F0144Accident · No injuriesClosedBeech S35 · Vicksburg, MSSep 7, 1966 · N6852Q · Substantial damage NTSB MIA67D0165Accident · No injuriesClosedPiper J3C · Shelby, MSAug 31, 1966 · N78405 · Substantial damage NTSB MIA67D0148Accident · No injuriesClosedPiper PA-28 · Meridian, MSAug 31, 1966 · N7246W · Substantial damage NTSB MIA67F0142Accident · No injuriesClosedPiper PA-28 · Bruce, MSAug 27, 1966 · N7382W · Substantial damage NTSB MIA67A0029Accident · 1 fatalClosedPiper PA-18 · Cliftonville, MSAug 27, 1966 · N9280D · Destroyed NTSB MIA67F0129Accident · No injuriesClosedPiper PA-24 · Jackson, MSAug 26, 1966 · N7937P · Substantial damage NTSB MIA67F0139Accident · Minor injuriesClosedPiper PA-25 · Corinth, MSAug 22, 1966 · N6123Z · Destroyed NTSB MIA67F0110Accident · No injuriesClosedGrumman G-164 · Lodi, MSAug 18, 1966 · N597Y · Substantial damage NTSB MIA67F0108Accident · No injuriesClosedBoeing A-75 · Raymond, MSAug 18, 1966 · N4998N · Substantial damage NTSB MIA67F0112Accident · No injuriesClosedGrumman G-164 · Sand Hill, MSAug 13, 1966 · N10229 · Substantial damage NTSB MIA67F0111Accident · Serious injuriesClosedCessna 150 · Hernando, MSAug 6, 1966 · N7978Z · Substantial damage NTSB MIA67D0064Accident · No injuriesClosedLuscombe 8F · Picayune, MSJul 23, 1966 · N2925K · Substantial damage NTSB MIA67A0013Accident · 1 fatalClosedPiper J-3 · Hernando, MSJul 22, 1966 · N35162 · Destroyed NTSB MIA67F0090Accident · No injuriesClosedPiper PA-24 · Jackson, MSJul 15, 1966 · N8965P · Substantial damage NTSB MIA67F0057Accident · Minor injuriesClosedCessna 172 · Lamar, MSJul 14, 1966 · N6744A · Substantial damage NTSB MIA67F0002Accident · No injuriesClosedCessna 180 · Grace, MSJul 6, 1966 · N2425F · Substantial damage NTSB MIA67F0004Accident · No injuriesClosedPiper PA-25 · Brookhaven, MSJul 4, 1966 · N7503Z · Substantial damage NTSB MIA67D0010Accident · Minor injuriesClosedCessna 140 · Cherau, MSJun 29, 1966 · N2581N · Substantial damage NTSB MIA66D0629Accident · No injuriesClosedChampion 7FC · Pascagoula, MSJun 27, 1966 · N9849Y · Substantial damage NTSB MIA66A0150Accident · 2 fatalClosedDouglas DC-3 · Long Beach, MSJun 27, 1966 · N17337 · Destroyed NTSB MIA66A0147Accident · Minor injuriesClosedBell 47G2A · Lakeshore, MSJun 23, 1966 · N73211 · Destroyed NTSB MIA66F0610Accident · No injuriesClosedLuscombe 8A · Meridian, MSJun 20, 1966 · N1057K · Substantial damage NTSB MIA66F0592Accident · No injuriesClosedGrumman G164A · Exingtom, MSJun 20, 1966 · N671U · Substantial damage NTSB MIA66A0142Accident · 1 fatalClosedAero Comdr 680F · South Haven, MSJun 10, 1966 · N209PP · Destroyed NTSB MIA66F0566Accident · Minor injuriesClosedPiper PA-18A · Amory, MSJun 8, 1966 · N4196Z · Destroyed NTSB MIA66F0595Accident · Minor injuriesClosedMooney MK20C · Pascagoula, MSJun 3, 1966 · N5555Q · Destroyed