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 MIA66F0182Accident · No injuriesClosedPiper PA-18A · Louisville, MSAug 10, 1965 · N8189C · Substantial damage NTSB MIA66F0192Accident · No injuriesClosedPiper PA-24 · Meridian, MSAug 9, 1965 · N8763P · Substantial damage NTSB MIA66F0167Accident · No injuriesClosedPiper PA-18A · Tupelo, MSAug 6, 1965 · N6776B · Substantial damage NTSB MIA66A0018Accident · 4 fatalClosedBeechcraft A35 · Mathiston, MSAug 5, 1965 · N615B · Destroyed NTSB MIA66F0091Accident · No injuriesClosedBoeing A-75N1 · Avalon, MSJul 31, 1965 · N1922M · Substantial damage NTSB MIA66F0090Accident · No injuriesClosedGlobe GC-1B · Forest, MSJul 24, 1965 · N78088 · Substantial damage NTSB MIA66D0069Accident · No injuriesClosedCessna 150D · Gillsburg, MSJul 24, 1965 · N4323U · Substantial damage NTSB MIA66F0066Accident · No injuriesClosedBeechcraft 35 · Madison, MSJul 20, 1965 · N2886V · Substantial damage NTSB MIA66F0065Accident · No injuriesClosedPiper PA-22 · Gulfport, MSJul 18, 1965 · N8729D · Substantial damage NTSB MIA66F0050Accident · No injuriesClosedPiper PA-24 · Meridian, MSJul 18, 1965 · N6336P · Substantial damage NTSB MIA66A0008Accident · No injuriesClosedBell Tomcat · Skene, MSJul 12, 1965 · N73871 · Substantial damage NTSB MIA66F0086Accident · No injuriesClosedPiper PA-25 · Batesville, MSJul 11, 1965 · N7507Z · Substantial damage NTSB MIA65A0126Accident · 1 fatalClosedBoeing 75N1 · Sunflower, MSJun 26, 1965 · N4936C · Substantial damage NTSB MIA65A0125Accident · 1 fatalClosedPiper PA-12 · Tutwiler, MSJun 25, 1965 · N7555H · Destroyed NTSB MIA66D0044Accident · Minor injuriesClosedCessna 172B · Starkville, MSJun 21, 1965 · N7552X · Destroyed NTSB MIA66F0041Accident · No injuriesClosedCallair A-9 · Moorhead, MSJun 20, 1965 · N9666Z · Substantial damage NTSB MIA66D0040Accident · No injuriesClosedCessna 172 · Wayside, MSJun 18, 1965 · N6417B · Substantial damage NTSB MIA65A0119Accident · 1 fatalClosedPiper PA-18A · Lambert, MSJun 17, 1965 · N8169C · Destroyed NTSB MIA66F0019Accident · Serious injuriesClosedCallair A-9 · Doddsville, MSJun 2, 1965 · N3568G · Substantial damage NTSB MIA66F0004Accident · No injuriesClosedPiper PA-30 · Yazoo City, MSJun 2, 1965 · N7084Y · Substantial damage NTSB MIA65A0116Accident · 1 fatalClosedBeechcraft 65 · Greenville, MSMay 30, 1965 · N196BG · Destroyed NTSB MIA65F0094Accident · No injuriesClosedCessna 170A · Columbus, MSMay 6, 1965 · N1373D · Destroyed NTSB MIA65F0103Accident · No injuriesClosedCessna 182E · Cleveland, MSMay 3, 1965 · N9270X · Substantial damage NTSB MIA65D0075Accident · No injuriesClosedAero Cmdr 500-B · Houston, MSApr 27, 1965 · N78347 · Substantial damage NTSB MIA65F0061Accident · Serious injuriesClosedAeronca 7AC · Bay St.Louis, MSApr 17, 1965 · N82527 · Substantial damage NTSB MIA65F0047Accident · No injuriesClosedPiper PA-24 · Columbia, MSApr 10, 1965 · N6225P · Substantial damage NTSB UNK65X1482Accident · Serious injuriesClosedPiper J3 · Belzoni, MSApr 5, 1965 · N30352 · Destroyed NTSB MIA65F0039Accident · No injuriesClosedCessna 172 · Charleston, MSApr 4, 1965 · N2535Y · Substantial damage NTSB MIA65A0097Accident · No injuriesClosedLockhead PV-2 · Laurel, MSMar 28, 1965 · N7260C · Substantial damage NTSB MIA65F0043Accident · No injuriesClosedPiper PA-18 · Hazlehurst, MSMar 16, 1965 · N3598Z · Substantial damage NTSB MIA65F0006Accident · No injuriesClosedCessna 140 · Batesville, MSMar 8, 1965 · N72717 · Substantial damage NTSB MIA65A0089Accident · 1 fatalClosedPiper J3C-65 · Lumberton, MSMar 2, 1965 · N65901 · Substantial damage NTSB UNK65X1450Accident · Minor injuriesClosedBeechcraft A-23 · Louisville, MSFeb 23, 1965 · N2306Q · Destroyed NTSB MIA65F0032Accident · No injuriesClosedPiper PA-22 · Starkville, MSFeb 22, 1965 · N4989Z · Substantial damage NTSB UNK65X1420Accident · No injuriesClosedPiper PA22 · Drew, MSFeb 14, 1965 · N5133Z · Substantial damage NTSB UNK65X1342Accident · No injuriesClosedCessna 180 · Natchez, MSJan 24, 1965 · N2600Y · Substantial damage NTSB UNK65X1270Accident · Serious injuriesClosedBeechcraft C-18S · Quitman, MSJan 11, 1965 · N5881C · Destroyed NTSB MIA65A0072Accident · 2 fatalClosedCessna 210 · Ocean Sprgs, MSJan 10, 1965 · N9565T · Destroyed NTSB UNK65X1178Accident · Serious injuriesClosedTempco D-16 · Madison, MSDec 28, 1964 · N4366K · Substantial damage NTSB UNK65X1129Accident · No injuriesClosedMooney M21 · Jackson, MSDec 25, 1964 · N1299X · Substantial damage NTSB MIA65 0063Accident · 1 fatalClosedPiper PA-20 · Batesville, MSDec 13, 1964 · N7091K · Destroyed NTSB UNK65X0948Accident · Serious injuriesClosedCessna 182 · Belzoni, MSDec 7, 1964 · N3062Y · Destroyed NTSB UNK65X0524Accident · 2 fatalClosedAeronca 7AC · Greenville, MSNov 1, 1964 · N81481 · Substantial damage NTSB UNK65X0515Accident · No injuriesClosedBeechcraft 23 · Greenville, MSNov 1, 1964 · N2332Q · Substantial damage NTSB UNK65X0393Accident · No injuriesClosedCessna 172 · Marks, MSOct 24, 1964 · N3864S · Substantial damage NTSB UNK65X0351Accident · No injuriesClosedPiper PA30 · Columbus, MSOct 20, 1964 · N7354Y · Substantial damage NTSB UNK65X0347Accident · No injuriesClosedCessna 140 · Horn Lake, MSOct 20, 1964 · N2274N · Substantial damage NTSB UNK65X0318Accident · Serious injuriesClosedBell 47G · Walls, MSOct 18, 1964 · N2467B · Substantial damage NTSB UNK65X0216Accident · No injuriesClosedBoeing A75N1 · Yazoo City, MSOct 10, 1964 · N61042 · Substantial damage NTSB UNK64X4086Accident · No injuriesClosedBellanca 1419 · Madison, MSSep 21, 1964 · N132M · Substantial damage